Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see LOADPLUS for DB2 13.1.

COPY

The COPY option tells LOADPLUS whether to produce a copy of the table space or selected partitions during the load.

COPY.png

Additional options tell LOADPLUS what type of copy to produce.

In addition to interactions with other options (which are documented with those options), the value that you specify can affect the following aspects of your load job:

NO

COPY NO (the default) tells LOADPLUS to not make a copy of the table space.

COPYPEND

The COPYPEND option tells LOADPLUS whether to set the COPY pending status when it finishes the load.

Specifying the default

You can specify the default for the COPYPEND command option in your installation options module by using the COPYPEND installation option. LOADPLUS was shipped with a default value of YES for this option. With the following exception, the command option overrides the default that is in the installation options module.

If the value of the COPYPEND installation option includes the ENFORCE keyword, you cannot override the installation option with the COPYPEND command option.

YES

YES tells LOADPLUS to set the COPY pending status after loading the table. The job completes with return code 4, indicating that you need to make a copy of the table for recovery purposes.

Restrictions

Note the following restrictions when specifying COPYPEND YES:

  • For an SQLAPPLY load, LOADPLUS ignores this option.
  • When you specify LOAD RESUME YES and you do not load any rows, LOADPLUS does not set COPY pending and the job completes with return code 0.
  • If the table space that you are loading is in LPL or WEPR status and you specify this option, LOADPLUS terminates.
  • If the value for the COPYPEND installation option is (NO,ENFORCE), specifying COPYPEND YES on the LOAD command causes LOADPLUS to issue message BMC50115E and terminate.

NO

NO tells LOADPLUS not to set the COPY pending status after loading the table. The job completes with return code 0. Use this option only for static tables or tables that you can reload if needed, because you will not be able to recover the tables.

For a DSNUTILB load, LOADPLUS passes COPYPEND NO as NOCOPYPEND to the IBM Db2 LOAD utility.

Restriction

The following restrictions apply to COPYPEND NO:

  • If the value for the COPYPEND installation option is (YES,ENFORCE), specifying COPYPEND NO on the LOAD command causes LOADPLUS to issue message BMC50115E and terminate processing.
  • When you specify COPYPEND NO, LOADPLUS does not reset (remove) COPY pending status if the table that you are loading was in COPY pending status before the load.

YES

If you specify COPY YES, LOADPLUS creates a copy of the table space or partitions, depending on the type of object that you are loading and the value of your other command or installation options. Depending on the value of other copy options, LOADPLUS creates a standard Db2 image copy, DSN1COPY-type copy, or inline image copy.

Restriction

If you specify this option for an SQLAPPLY load, LOADPLUS issues message BMC50115E and terminates.

DSNUTILB load jobs

The following considerations apply when you specify COPY YES for a DSNUTILB load:

  • When invoking DSNUTILB, LOADPLUS includes the COPYDDN and RECOVERYDDN information in the TEMPLATE control statement that it builds for the IBM Db2 LOAD utility.
  • You must specify ACTIVE YES for at least the primary copy data set (DDTYPE LOCPFCPY). Otherwise, LOADPLUS issues message BMC50181E and terminates. All copy data sets for a DSNUTILB load are dynamically allocated. LOADPLUS ignores any copy data set allocation in your JCL.

Additional considerations

The following additional considerations apply to COPY YES:

  • If you specify this option and you are loading LOB or XML data, you must enable dynamic allocation for the appropriate LOB or XML copy data sets.
  • If the table space was in COPY pending status before the load, LOADPLUS resets COPY pending status unless you specify REGISTER NONE.
  • If you specify this option and the table space that you are loading is in LPL or WEPR status, you must register at least one copy.
  • LOADPLUS creates all copies with system pages at the beginning of the data set (in the same way that the IBM COPY utility creates image copies when you specify SYSTEMPAGES YES).
  • The difference between an image copy and a DSN1COPY-type copy is one of registration: an image copy is registered, a DSN1COPY-type copy is not.

INLINE

The INLINE option tells LOADPLUS whether to make an inline image copy while loading the table space.

Restriction

When invoking DSNUTILB, LOADPLUS ignores this option.

Specifying the default

You can specify the default for the INLINE command option in your installation options module by using the INLINECP installation option. LOADPLUS was shipped with a default value of YES for this option. The command option overrides the default that is in the installation options module.

YES

INLINE YES tells LOADPLUS to create an inline image copy while loading the table space. Because LOADPLUS creates the image copy while loading the table space, rather than after, specifying INLINE YES can reduce the elapsed time of your load job.

Restrictions

When any of the following conditions exists, LOADPLUS functions as if you specified INLINE NO, regardless of the option that you specify here or in your installation options:

  • You are loading XML data.
  • You specify LOAD RESUME YES, unless you also specify PART n REPLACE for all participating partitions.
  • The copy data sets are on a stacked tape.

  • You restart your load job.

    An exception to this condition is that, if you are running a two-phase load job and you specify RESTART(PHASE), LOADPLUS generates an inline copy if the value of INLINE is YES.

  • The size of the table space page is greater than 4 KB, you are loading multiple partitions, and you have one image copy data set.

    An exception to this condition exists for partition-by-growth table spaces. LOADPLUS can create inline image copies of partition-by-growth table spaces in this case.

NO

INLINE NO tells LOADPLUS not to create an inline image copy while loading the table space, but to create a Db2 image copy or DSN1COPY-type copy after loading the table space.

REGISTER

The REGISTER option tells LOADPLUS to register some, none, or all copies with Db2 in the SYSIBM.SYSCOPY table. You can specify one of the following options:

Value

Description

ALL

ALL, which is the default, registers all copies requested in the JCL by ddname.

NONE

NONE tells LOADPLUS to not register any of the copies with Db2. Unless the object was in COPY pending status before the load, LOADPLUS does not leave the object in COPY pending status.

If you specify this option and the table space that you are loading is in LPL or WEPR status, LOADPLUS terminates.

ddname

This option allows you to specify by ddname the copy data set to register. LOADPLUS registers only the copies in the data sets that you specify with this option. The ddnames that you specify in this option must also be present in your JCL.

Restrictions

Note the following restrictions on registering copies:

  • When invoking DSNUTILB, LOADPLUS ignores this option.
  • LOADPLUS does not register the following copies:
    • A copy written to DD DUMMY
    • A copy written to a DD specified with DSN=NULLFILE
  • If any one copy is rejected due to a duplicate entry in the SYSIBM.SYSCOPY table, LOADPLUS does not register any of the requested copies. LOADPLUS issues an error message and completes with return code 8.

Related topic

Copy-options

 

 

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