Skip to Content
Information
Limited support BMC 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 REORG PLUS for DB2 13.1.

Selective unload and update options for REORG TABLESPACE

The SELECT and DELETE options allow you to specify conditions that must be met in order for a row to be unloaded and reloaded during the reorganization. The UPDATE option allows you to reset column values to a constant.

Restrictions

These options do not apply to the following jobs:

  • Index-only reorganizations
  • DSNUTILB jobs
  • XML table space reorganizations
  • LOB table space reorganizations

  • Table space reorganizations of table spaces that contain a LOB column

    Warning

    Important

    You can specify UPDATE unless either of the following conditions exists:

    • The UPDATE statement attempts to update a LOB column.
    • An associated WHERE clause references a LOB column.
  • Catalog table space reorganizations
  • Reorganizations of table spaces that include archive-enabled tables
  • Reorganizations of table spaces that contain system period temporal tables that are enabled for versioning
  • Reorganizations of objects that are in RREPL status

Related topic

Descriptions-of-REORG-PLUS-command-options

 

 

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

REORG PLUS for DB2 11.2