,DBKEYTBL
DBKEYTBL directs CA IDMS/DB Audit to build a table of the db-keys of all member records when auditing a set occurrence. CA IDMS/DB Audit uses this table to detect a set loop. A set loop occurs when a member record's next db-key points back to a previous member in the set chain.
If you specify DBKEYTBL, CA IDMS/DB Audit stops processing a set under either of these two circumstances:
If you do not specify DBKEYTBL, CA IDMS/DB Audit stops processing a set when it has retrieved the number of members indicated by the SETLIMIT value.
The maximum number of entries DBKEYTBL can hold is 120% of the SETLIMIT value. 80% of SETLIMIT is allocated to the primary portion of the table and 40% of SETLIMIT is allocated to an overflow portion of the table.
Because of the algorithm used for accessing the db-key table, there may be no room for a particular db-key in the table even though the SETLIMIT value has not been reached. Therefore, you may need to specify a SETLIMIT value slightly larger than what appears necessary.
CA IDMS/DB Audit always allocates storage for the db-key table during the audit phase because this table is required when creating extract records for set errors. Consequently, you should always specify DBKEYTBL when auditing CALCSETS or USERSETS.
|
Copyright © 2013 CA.
All rights reserved.
|
|