To detect a set loop and allow fixing of these errors, you can specify DBKEYTBL in the AUDIT statement. CA IDMS/DB Audit maintains a table of all member record db-keys retrieved for each set occurrence during set walk processing. Whenever a record's next db-key is found in the table already, CA IDMS/DB Audit stops processing the set. In Figure 2.35, when auditing the DEPT-ACADEMIC set, the following member records are retrieved and their db-keys placed in the table: American Literature, English Literature, and Remedial English. Since Remedial English's next db-key is already in the table, CA IDMS/DB Audit recognizes that the set contains a loop and terminates the set-walk for that set occurrence.
Note: Even if DBKEYTBL is not specified in the AUDITstatement, CA IDMS/DB Audit activates the DBKEYTBL function during the creation of extract records to determine whether or not a next or prior db-key points to a record previously retrieved in the set. Therefore, you must plan storage for DBKEYTBL.
Figure 2.35: Set Loop
|
Copyright © 2013 CA.
All rights reserved.
|
|