Chapter 5 Working with Information Liquidity Models


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

 


Copyright (C) 2007. Sybase Inc. All rights reserved.