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.

DELETE FROM

The DELETE FROM option tells REORG PLUS to delete the rows that match the specified WHERE clause conditions from the named table.

DELETE_FROM.png

This option does not apply to an index-only reorganization.

Rows that REORG PLUS does not delete are unloaded and used to reload the table space. The table name specifies the table to which the delete criterion applies. If you do not specify the creator name, REORG PLUS uses the authorization ID of the user running the reorganization.

Restrictions

REORG PLUS terminates when you specify this option for the following jobs:

  • Index-only reorganizations
  • DSNUTILB jobs
  • XML table space reorganizations
  • LOB table space reorganizations
  • Reorganizations of table spaces that contain 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

For restrictions on the WHERE clause of your DELETE statement, see WHERE.

Additional considerations

Note the following additional information about the DELETE FROM option:

Error
Warning

If you are deleting rows from a table with a primary key, REORG PLUS does not guarantee or maintain any referential integrity of the primary keys and does not set the CHECK pending status. You might need to run either the BMC CHECK PLUS product or the IBM Db2 CHECK DATA utility on dependent tables to restore referential integrity, or run REORG PLUS on dependent tables to delete dependent rows.

WHERE

The WHERE clause enables you to specify which rows are to be deleted. For more information, see WHERE.

Warning

Important

When you use WHERE on a partial reorganization, REORG PLUS processes only the specified partitions. If the WHERE condition matches rows in any of the partitions that are not being reorganized, those rows are unaffected. You do not need to specify predicates to limit the WHERE condition to only partitions that you are reorganizing.

Related topic

Selective-unload-and-update-options-for-REORG-TABLESPACE

 

 

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

REORG PLUS for DB2 11.2