NUMRECS integer


(BMC.DB2.SPE2304)

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 the NUMRECS integer is ignored and the ENUMROWS is used.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Load for Db2 13.1