Previous Topic: Differences Between &NDBSCAN Sequences and &NDBSEQ Sequences

Next Topic: Scan Expressions

Control &NDBSCAN Resource Usage

Since &NDBSCAN can perform large amounts of I/O, or use large amounts of storage, particularly when sorting, there are four limits that prevent any one scan request from tying up excessive resources. They are:

These limits are specified using the SYSPARMS command. Each limit can have a default value, to be applied if an &NDBSCAN does not specify an overriding value, and a maximum limit, that is always used to constrain the maximum value which can be coded in any &NDBSCAN.

The &NDBSCAN statement lets you specify overriding values for any of the limits. These values replace the SYSPARM-specified defaults for that scan. If any supplied value exceeds the SYSPARM-specified maximum, the SYSPARM maximum is used.

An &NDBSCAN request that exceeds one of these limits is terminated, and a response code, indicating which limit was exceeded, is returned. The scan debug display indicates the limit values assigned to the scan request.