LOAD
The following table describes the operands for the LOAD control statement:
Operand | Description |
|---|---|
TYPE=statisticsTableType (BMC.AMIOPS.SPE2304) | Specifies the type of accounting or statistics table Possible values are as follows:
This required field has no default. |
TYPE1=accountingTableType (BMC.AMIOPS.SPE2304) | Specifies the type of accounting or statistics table Possible values are as follows:
|
TYPE2=auditTableType | Specifies the type of audit table Possible values are as follows:
This required field has no default. |
TYPE3=statisticsAuditTableType | Specifies the type of statistics or audit table Possible values are as follows:
This required field has no default. |
TYPE4=acceleratorSimBPTableType | Specifies the type of accelerator table or simulated bufferpool table Possible values are as follows:
This required field has no default. |
| TYPE5= statisticsAuditTableType | Specifies the type of statistics or audit table Possible values are as follows:
This required field has no default. |
TABLE=tableName | Specifies name of the receiving table This table is read to define the columns defined within the table. |
LOG=YES|NO | Defines the LOG parameter for the load of this table If not defined, the default is defined by the GLOBAL LOG value. |
NOCOPYPEND=YES|NO | Defines NOCOPYPEND for the load of this table if LOG=NO is specified If not defined, the default is defined by a prior GLOBAL NOCOPYPEND value. |
FROMDD=ddName | Indicates the ddname assigned to the file that is to be loaded This required field has no default. |
REPLACE=YES|NO | Specifies whether the table space and all its indexes need to be reset to empty before records are loaded The default is NO; however, if KEEPDICTIONARY=YES is specified, REPLACE=YES becomes the default. |
KEEPDICTIONARY=YES|NO | Specifies whether a new compression dictionary is built YES prevents the LOAD utility from building a new compression dictionary. LOAD retains the current compression dictionary and uses it for compressing the input data. This option eliminates the cost associated with building a new dictionary. The default is NO. |
SORTKEYS=nnnnn | Specifies an estimated number of index keys to be sorted in parallel with the reload and build phases to improve performance The default is 0. |
SHRLEVEL=NONE|CHANGE | Defines the SHRLEVEL parameter for the load of this table SHRLEVEL=CHANGE allows access to a table during the load process, which increases log and archive processing overhead. An appropriate LOCKSIZE specification is required for the table space. SHRLEVEL=CHANGE increases overhead by changing the LOAD process to use a mass INSERT algorithm, and LOG=YES must be specified. |