Monitoring Change Activity › DBName Table Coding Rules

DBName Table Coding Rules

During execution the Change Monitor detects the DICTNAME and SUBSCHEMA name when an update to an IDD is requested. It then searches for this name in the DBNAME table to determine the appropriate CCDB to which activity should be logged.

The relationship between a dictionary (that is, an IDMSNWKA mapping) and a CCDB (that is, a xxxxCCDB segment) must be one-to-one. The same pair of mappings must always occur together under a DBNAME.

The DBName for the dictionary linked, or "hooked" to the Change Monitor should be the same as the Segment Name of the segment in the DMCL containing the dictionary's DDLDML area. Failure to do so may allow the Change Monitor to be bypassed if the segment name of the DDLDML is specified as a DBName or Dictname. A valid DBName for a "hooked" dictionary must include:

• Segment(s) describing the areas of a dictionary (DDLDML, DDLDCLOD, and, optionally, DDLDCMSG)
• Segment(s) describing all areas of a CCDB (NDVR-ADM, NDVR-LOG, and NDVR-PAK)
• Subschema mapping of IDMSNWKA to NDVRNWKA

For example, if the DMCL contains the following segment definitions:

SEGMENT APPLDICT
     AREA APPLDICT.DDLDML
     AREA APPLDICT.DDLDCLOD
SEGMENT SYSMSG
     AREA SYSMSG.DDLDCMSG
SEGMENT APPLCCDB
     AREA APPLCCDB.NDVR-ADM
     AREA APPLCCDB.NDVR-LOG
     AREA APPLCCDB.NDVR-PAK

The correct DBName definition to link the APPLDICT dictionary to the Change Monitor would be:

CREATE DBNAME dbtable-name.APPLDICT
   INCLUDE SEGMENT APPLDICT
   INCLUDE SEGMENT SYSMSG
   INCLUDE SEGMENT APPLCCDB
   SUBSCHEMA IDMSNWKA MAPS TO NDVRNWKA
   SUBSCHEMA NDVRSUBS MAPS TO NDVRSUBS;

If APPLDICT is the default dictionary for the system, in addition to the above, you must establish subschema mappings at the DBTable level as follows:

MODIFY DBTABLE dbtable-name
  SUBSCHEMA IDMSNWKA MAPS TO NDVRNWKA
         DBNAME APPLDICT
  SUBSCHEMA IDMSNWK? MAPS TO IDMSNWK?
         DBNAME APPLDICT

Note: Pointing two separate dictionaries at the same CCDB is not permitted. View the CCDB as a logical and physical extension to the dictionary.