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 UNLOAD PLUS for DB2 13.1.

SHRLEVEL

The SHRLEVEL option specifies the level of access that concurrently operating Db2 applications and utilities have to the target spaces during UNLOAD PLUS processing.

SHRLEVEL.png

Restriction

UNLOAD PLUS ignores this option when DIRECT NO is in effect.

Specifying the default

You can specify the default for the SHRLEVEL command option in your installation options module by using the SHRLEVEL installation option. UNLOAD PLUS was shipped with a default value of REFERENCE for this option. The command option overrides the default that is in the installation options module.

REFERENCE

SHRLEVEL REFERENCE restricts object status to read-only during UNLOAD PLUS processing. UNLOAD PLUS then externalizes the pages of the table space. When UNLOAD PLUS is operating on partitioned objects, access is restricted only to the partitions that are being unloaded. When UNLOAD PLUS processing completes, the utility restores the object to its original status.

If you are unloading from a full or incremental image copy (including an encrypted copy or cabinet copy), UNLOAD PLUS unloads only from image copies that are marked as SHRLEVEL REFERENCE in SYSIBM.SYSCOPY or, for an encrypted copy or cabinet copy, the BMCXCOPY table.

CHANGE

If you are unloading from a table space, specify SHRLEVEL CHANGE to allow read/write access to the table space during unload processing.

If you are unloading from a full or incremental image copy (including an encrypted copy or cabinet copy), UNLOAD PLUS unloads from image copies marked as either SHRLEVEL REFERENCE or SHRLEVEL CHANGE in SYSIBM.SYSCOPY or, for an encrypted copy or cabinet copy, the BMCXCOPY table.

CONSISTENT NO

This option tells UNLOAD PLUS not to attempt to maintain consistency with a point-in-time image of the data when using SHRLEVEL CHANGE. When you specify CONSISTENT NO, UNLOAD PLUS does not restrict access to the object except for the brief time required to externalize pages if you specify QUIESCE YES. CONSISTENT NO is the default for SHRLEVEL CHANGE.

Specifying the default

You can specify the default for the SHRLEVEL CHANGE CONSISTENT command option in your installation options module by using the CHANGE_CONSISTENT installation option. UNLOAD PLUS was shipped with a default value of NO for this option. The command option overrides the default that is in the installation options module.

QUIESCE

This option tells UNLOAD PLUS whether to externalize the unloaded table space’s pages from the Db2 buffer pool. If you specify QUIESCE without a value, UNLOAD PLUS assumes QUIESCE YES. The following table describes the values that you can specify with QUIESCE:

YES

YES tells UNLOAD PLUS to restrict access briefly to the object while UNLOAD PLUS externalizes pages from the Db2 buffer pool

NO

Specify this value if you do not want UNLOAD PLUS to restrict access to the object and externalize pages from the Db2 buffer pool.

Warning

If you specify QUIESCE NO, UNLOAD PLUS does not restrict access to the objects, nor does it externalize pages from the Db2 buffer pool. These actions might result in the following consequences:

  • UNLOAD PLUS might not process any updated pages in the buffer pool.
  • If you run UNLOAD PLUS on a Db2 object immediately following the creation of the data set for that object, any data involved might exist only in Db2 buffer pools, causing UNLOAD PLUS to terminate.
  • If UNLOAD PLUS encounters any pages that have uncommitted data, it unloads the uncommitted data.

Specifying the default

You can specify the default for the SHRLEVEL CHANGE CONSISTENT NO QUIESCE command option in your installation options module by using the CHANGE_QUIESCE installation option. UNLOAD PLUS was shipped with a default value of NO for this option. The command option overrides the default that is in the installation options module.


CONSISTENT YES

Specify CONSISTENT YES to have UNLOAD PLUS maintain consistency with a point-in-time image of the data while enabling read/write access to the data. UNLOAD PLUS provides this capability by using XBM or SUF to produce a snapshot image of the data in a table space.

When you specify SHRLEVEL CHANGE CONSISTENT YES, UNLOAD PLUS externalizes the pages of the table space, then activates XBM or SUF to begin caching pre-update page images. For more information about using XBM or SUF with UNLOAD PLUS, see Running-SHRLEVEL-CHANGE-CONSISTENT-YES. For detailed information about XBM and SUF, see the SNAPSHOT UPGRADE FEATURE for DB2 documentation.

You can use the following additional options:

  • You can specify a particular XBM subsystem ID by using the XBMID installation or command option.
  • To write a message to the MVS system log to indicate that snapshot-processing initialization for UNLOAD PLUS has successfully completed, specify the WTOMSG option.

Restriction

This option is not valid when you specify INFILE.

Specifying the default

You can specify the default for the SHRLEVEL CHANGE CONSISTENT command option in your installation options module by using the CHANGE_CONSISTENT installation option. UNLOAD PLUS was shipped with a default value of NO for this option. The command option overrides the default that is in the installation options module.

Related topics

Basic-processing-options

Object-status-with-DIRECT-YES

 

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