NUMRECS integer
NUMRECS provides an estimate of the total number of rows that BMC AMI Load expects to load for the specified table or table partition. BMC AMI Load uses NUMRECS value to dynamically allocate your sort work data sets and to determine the most efficient method for sort processing.
Use the NUMRECS keyword to specify the estimated total number of rows that BMC AMI Load expects to load:
- For multi-table table spaces, into each table
- For partitioned table spaces, into each partition
The default value for NUMRECS is 0. Any big integer value that does not exceed 9,223,372,036,854,775,807 is valid. If both ENUMROWS and NUMRECS are specified in the SYSIN statement, then NUMRECS is ignored and ENUMROWS is used.
Related topics
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*