Previous Topic: USERSETS OptionNext Topic: DBKEYTBL Option


SETLIMIT Option

,SETLIMIT=number-of-members

SETLIMIT specifies the maximum number of member records to retrieve from a set occurrence before assuming that a set loop condition exists. A set loop occurs when a member record's next db-key points back to a previous member record in the set chain.

The SETLIMIT value must be an integer from 1 through 9999999. For most efficient performance, the value should equal the maximum number of member records in any one set occurrence. Specifying too large a value causes unnecessary processing within a set when a set loop exists. Another result of specifying too large a value is unnecessarily large storage requirements for DBKEYTBL and the db-key save table.

SETLIMIT causes CA IDMS/DB Audit to stop processing a set only when it has retrieved the number of members specified by the SETLIMIT value. For this reason, you can detect a set loop much more quickly by specifying DBKEYTBL (explained in the next section).

CA IDMS/DB Audit does not perform any fixing if the SETLIMIT value is reached for any set occurrence.

Default: 3000