Database Checks

The following ILM model checks are made on databases:

Check

Description and Correction

Database name and code uniqueness

Database names and codes must be unique in the namespace.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Existence of data connection or data access link

A database must either be linked to at least one replication process or transformation process using a data connection, or to at least one data store [database, data access application or XML document] using a data access link

Manual correction: Add any missing data connection links between the database and the replication process or the transformation process or add any missing data access links between the database and the data store

Automatic correction: None

Database code maximum length

The database code length is limited by the maximum length specified in the XEM definition [CodeMaxLen entry, in the Objects > Settings category] and in the naming conventions of the model options.

Manual correction: Modify the code length to meet this requirement

Automatic correction: Truncates the code length to the maximum length specified in the XEM definition

Existence of model

At least one model must be attached to the database.

Manual correction: Add any missing models in the Physical Data Models tab of the database property sheet

Automatic correction: None


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com