Distributed Configuration Checker Report
The Distributed Configuration Checker Report verifies that the configuration information in a local database and its remote counterparts is identical where necessary. The report pinpoints any significant differences between the database objects and the configurations of those objects.
We recommend that you run this report after installing or reconfiguring Ingres Replicator as a way to ensure that you have no configuration errors.
The Distributed Configuration Checker Report checks the following items:
• Replicated database information
• CDDS information
• Propagation path information
• All tables registered for replication
• All registered columns
The report is created when you choose the DistribConfig option from the Resolver Reports Menu window.
Following is an example of the Distributed Configuration Checker Report:
Ingres Replicator
Distributed Configuration Checker Report
From local database 'hq'
28-feb-2003 09:24:00
Report on remote database sfo::west (11):
DD_CDDS ERROR:
Record for CDDS no 3, CDDS name 'Accounting'
not found in remote database.
DD_REGIST_TABLES ERROR:
Support tables not created for local table no 4, table name 'tab1',
table owner 'testenv'.
Report on remote database lon::europe (20):
DD_CDDS ERROR:
CDDS no 0 has local collision mode of 0,
but remote collision mode of 2.
DD_CDDS ERROR:
Record for CDDS no 3, CDDS name 'Accounting'
not found in remote database.
DD_PATHS_ERROR:
Record for CDDS no 0, localdb no 10, sourcedb no 10,
targetdb no 11 not found in remote database.
DD_PATHS_ERROR:
Record for CDDS no 0, localdb no 10, sourcedb no 20,
targetdb no 11 not found in remote database.
DD_PATHS_ERROR:
Record for CDDS no 0, localdb no 10, sourcedb no 30,
targetdb no 11 not found in remote database.
DD_REGIST_TABLES ERROR:
Support tables not created for local table no 4, table name 'tab1',
table owner 'testenv'.
Report on remote database hkg::asia (30):
DD_CDDS ERROR:
CDDS no 0 has local collision mode of 0,
but remote collision mode of 2.
DD_CDDS ERROR:
Record for CDDS no 3, CDDS name 'Accounting'
not found in remote database.
DD_REGIST_TABLES ERROR:
Support tables not created for local table no 4, table name 'tab1',
table owner 'testenv'.