Skip to Content

Default language.

Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.

Related topic

Descriptions of REORG PLUS command options

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

 

 

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

REORG PLUS for DB2 13.1