Consultor Eletrônico

Status: Unverified

GOAL:

How to interpret output from the DataServer Schema Verify Utility

FACT(s) (Environment):

DataServers

FIX:

The DataServer Schema Verify Utility verifies that the schema image matches the data definitions in your foreign database.

For example, if you delete the Customer table from your foreign database, but not from the schema image, the Verify utility reports that there is an orphaned object. You can verify the schema information from a single or from multiple tables, and then choose to update the table or tables so that the schema information matches the foreign database definitions.

The verify utility reads the definitions in the database and compares them to the information in the schema image. It reports the differences it finds and the degree of their severity. These are the categories of differences and how they impact your database applications:

· Minor - These differences have no impact on the usability of your application.

· Retained - The Update utility cannot correct these differences, hence the term "retained." You must determine how severely they impact your application and change the data definitions either in the schema holder using the Data Dictionary or in your database.

· Severe - These differences might cause your application to malfunction. When the Verify utility detects severe differences, it automatically updates the schema image to solve the discrepancies. It adjusts the information in the schema image to match the database definitions. Severe differences in definitions that the DataServer uses internally also cause the schema image to be updated.