REORG-pending status

REORG-pending status indicates that an object either must or should be reorganized.

The following REORG-pending states can be set:

REORG-pending (REORP) restrictive status
Indicates that the object must be reorganized to apply definition changes before the data is accessible. REORP status must be reset for all adjacent logical partitions that are in REORP status.
REORG-pending (AREO*) advisory status
Indicates that the object needs to be reorganized for optimal performance. AREO* status can be reset on a single partition, regardless of whether adjacent partitions are also in AREO* status. The affected objects are not restricted and can be accessed by both readers and writers.
REORG-pending (AREOR) advisory status:
Indicates that the object should be reorganized to apply pending definition changes. AREOR status must be reset for all adjacent logical partitions that are in AREOR status. The affected objects are not restricted and can be accessed by both readers and writers. The affected objects are not modified until a REORG utility job is run to materialize the definition changes.

To reset REORG-pending status, take the actions that are described in the following table.

Table 1. Resetting REORG-pending status
Status Abbreviation Object affected Corrective action
REORG-pending REORP Table space or partition

Run one of the following utilities on the table space or one or more partitions:

  • REORG TABLESPACE
  • LOAD with the REPLACE option

If a table space is in both REORG-pending and CHECK-pending status (or auxiliary CHECK-pending status), run REORG first and then run the CHECK DATA utility to clear the respective states.

If one or more partitions are in REORP status, you must include all adjacent logical partitions that are in REORP status in the same REORG or LOAD job. For example, suppose that a partitioned table space has logical partitions in the following states:
P1
REORP
P2
REORP
P3
RW
P4
REORP
P5
REORP

In this case, the partition range P1:P2 must be in the same utility job, and the partition range P4:P5 must be in the same utility job. You can either include both of these ranges in one utility job or run two separate jobs, one for each range. Alternatively, you can specify the REORG option SCOPE PENDING so that the utility includes both ranges in REORP status.

Advisory REORG-pending AREO* Table space or partition

Run one of the following utilities on the table space or one or more partitions:

  • REORG TABLESPACE
  • LOAD with the REPLACE option

If one or more partitions are in AREO* status, you can reset AREO* for a specific partition without being restricted by another AREO* status for an adjacent partition. AREO* status does not have to be reset for all affected partitions at the same time.

Advisory REORG-pending AREO* Index space or partition

Run one of the following utilities on the index space or one or more partitions:

  • REORG TABLESPACE
  • LOAD with the REPLACE option
  • REORG INDEX
  • REBUILD INDEX

If one or more partitions are in AREO* status, you can reset AREO* for a specific partition without being restricted by another AREO* status for an adjacent partition. AREO* status does not have to be reset for all affected partitions at the same time.

Advisory REORG-pending AREOR Table space or partition

Run REORG TABLESPACE on the table space or all affected partitions.

When AREOR is set at the partition level, you must include all adjacent logical partitions that have this status in the same REORG job. For example, suppose that you change partition limits or change the page size and as a result, the table space has partitions in the following states:

P1
AREOR
P2
AREOR
P3
RW
P4
AREOR
P5
AREOR

In this case, the partition range P1:P2 must be in the same REORG job, and the partition range P4:P5 must be in the same REORG job. You can either include both of these ranges in one REORG job or run two separate jobs, one for each range. Alternatively, you can specify the SCOPE PENDING option so that REORG includes both ranges in AREOR status. (You can run REORG on the individual partitions and not the entire adjacent range in AREOR. However, in that case, REORG does not materialize any pending definition changes and the AREOR status is not reset.)

If you want to drop any pending definition changes, use the ALTER TABLESPACE statement with the DROP PENDING CHANGES clause. This statement removes the pending changes and resets the AREOR status.

Advisory REORG-pending AREOR Index space or partition

Run one of the following utilities on the index space or all affected partitions:

  • REORG TABLESPACE
  • REORG INDEX

When AREOR is set at the partition level, you must include all adjacent logical partitions that have this status in the same REORG job. See the example in the preceding row for table spaces. (You can run REORG on the individual partitions and not the entire adjacent range in AREOR. However, in that case, REORG does not materialize any pending definition changes and the AREOR status is not reset.)