LOAD

Use the LOAD parameter in CQM@WDB2 to control the offload of data to the performance history database.

Description

(Required) Indicates whether or not existing data is deleted from performance history database prior to loading new data and whether or not statistics are collected during the Db2® LOAD.

Syntax

LOAD(RESUME|REPLACE|REPLACE,STATISTICS)

Default

REPLACE

Valid values

RESUME

Perform the LOADs in RESUME mode.

REPLACE

(Default) Perform the LOADs in REPLACE mode.

REPLACE,STATISTICS

Adds the following load card to the Db2 Load Utility control file, which generates the statistics as described in the Db2 Utilities Suite for z/OS® Utility Guide and Reference (SC18-7427):

STATISTICS TABLE(ALL) INDEX(ALL)

Index statistics are collected when any user-defined indexes have been added to the performance history schema.

Example

LOAD(RESUME)

By specifying LOAD(RESUME), the load cards are built as follows:

LOAD INDDN METRDATA FORMAT UNLOAD RESUME YES ENFORCE NO INTO TABLE "x"."yz" LOG NO

The load sets the objects to copy pending, necessitating additional action by the user. NOCOPYPEND should be an accepted option for the LOAD parameter.