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.

Considerations when reorganizing LOB table spaces (SHRLEVEL REFERENCE)


When SHRLEVEL REFERENCE is in effect, REORG PLUS uses single-phase processing to reorganize your LOB table space and update the auxiliary index. The following considerations apply in this case.

Object status requirements

In addition to the status restrictions for any other SHRLEVEL REFERENCE reorganization job, the auxiliary index on the LOB table space must not be in page set rebuild pending (PSRBD) or rebuild pending (RBDP) status.

Data set requirements

REORG PLUS does not use any sort work or SYSUT1 data sets that you allocate when reorganizing LOB table spaces with SHRLEVEL REFERENCE.

Incompatible REORG PLUS command options

Some REORG PLUS command options are not available when you are reorganizing a LOB table space with SHRLEVEL REFERENCE. The following table describes the options that are not available and how REORG PLUS responds if your job contains these options.

Command option

REORG PLUS response

ANALYZE BMCSTATS

Ignores this option

ANALYZE

ANALYZE SAMPLE

ANALYZE SCAN

Does not sample or scan, but adds high-used relative byte addresses (HURBAs) from all data sets to estimate copy data set size

CONDEXEC BMC

CONDEXEC YES

Issues message BMC50056E and terminates

DELETE

Issues message and terminates

INDREFLIMIT

Issues message BMC50056E and terminates if specifying this option would cause REORG PLUS to check criteria for conditional reorganization

OFFPOSLIMIT

Issues message BMC50056E and terminates if specifying this option would cause REORG PLUS to check criteria for conditional reorganization

ORDER YES

Changes this option to ORDER NO

REBALANCE

Ignores this option

SELECT

Issues message and terminates

SHRLEVEL CHANGE

Issues message BMC50115E and terminates

UNLOAD CONTINUE

Changes this option to UNLOAD RELOAD

UNLOAD PAUSE

Issues message and terminates

UPDATE

Issues message and terminates

 

 

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

REORG PLUS for DB2 13.1