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.
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |