LOAD

TYPE=accountingStatisticsTableType

Specifies the type of accounting or statistics table

Possible values are:

• ACCT
• SUMACCT
• DDFACCT
• SUMDDFACCT
• PKGACCT
• SUMPKGACCT
• BUFACCT
• SUMBUFACCT
• STAT
• SUMMSTAT
• DDFSTAT
• SUMDDFSTAT
• BUFSTAT
• SUMBUFSTAT
• DGPASTAT

This required field has no default.

TYPE2=auditTableType

Specifies the type of audit table

Possible values are:

• AUDFAIL
• AUDGRV
• AUDDDL
• AUDDML
• AUDDMB
• AUDCHG
• AUDUTL
• AUDSUM

This required field has no default.

TYPE3=statisticsAuditTableType

Specifies the type of statistics or audit table

Possible values are:

• ASPCSTOR
• SYSTSTOR
• AUDCMD
• AUDATH
• AUDTRC
• AUDFTB
• AUDIFE

This required field has no default.

TYPE4=acceleratorSimBPTableType

Specifies the type of accelerator table or simulated bufferpool table

Possible values are:

• ACCA
• ACCS
• SYMB

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.