Each SQL object consists of information stored in various tables managed by SQL and CA Datacom Datadictionary. A successful rebind depends on the accessibility of that information. The CA Datacom/DB SQL Upgrade Rebind Utility cannot execute successfully if the SQL objects (constraints, plans, and views) that it rebinds are not intact in the CA Datacom/DB system to be rebound. The SQL Object Consistency Analyzer allows you to verify that the needed information is accessible. Therefore, before beginning an upgrade to a new CA Datacom/DB version, execute the SQL Object Consistency Analyzer against your current CA Datacom/DB system. If any problems are discovered, correct them before you begin the upgrade.
Note: You can also execute the SQL Object Consistency Analyzer against the new CA Datacom/DB version system if you suspect rows are missing in SQL-managed tables (in the areas in the DATA-DICT and DDD-DATABASE databases).
The information on the SQL Object Consistency Analyzer is divided into three sections:
|
Copyright © 2014 CA.
All rights reserved.
|
|