The Dynamic System Table definitions are automatically installed to the CXX and CA Datacom Datadictionary as part of the Version 14.0 upgrade or install process. If you use the recommended DBID of 1000, you do not need to deal with the BTG member or catalog the database. Member BTG1000 in the macro library provides the Dynamic System Table definitions. Process these definitions through CA Datacom Datadictionary and catalog the base. The database selected is 1000, but it can be changed to any valid DBID. The database ID selected must be provided in the Multi-User startup option SYSTEMDBID n for the Dynamic System Tables to have data accessible.
Important! Specify the SYSTEMDBID Multi-User startup option to activate Dynamic System Table access from the MUF.
Note: For more information about SYSTEMDBID, see the CA Datacom/DB Database and System Administration Guide.
Do not modify other information. The SQL processing is based upon the CA Datacom Datadictionary definitions as they are cataloged. The actual data is built based upon the database ID matching the SYSTEMDBID, the CA Datacom table names, and the definitions provided. Changing field definitions would cause unpredictable results.
Place all the Dynamic System Tables in the same database. The DBID of the database in which you place all Dynamic System Tables must match the DBID specified with the SYSTEMDBID Multi-User startup option. We recommend that you use a DBID of 1000 for the Dynamic System Tables database, but it is possible to specify any DBID of your choice for the SYSTEMDBID. However, Dynamic System Tables cannot share a database with any other tables. The database containing Dynamic System Tables do not need to be initialized or loaded, and it should not be defined as virtual.
For security purposes, these tables are like all others. You can use any of the security features to protect or restrict the data.
|
Copyright © 2014 CA.
All rights reserved.
|
|