Examples of REORG PLUS jobs

Each example includes the following information:

A description of the reorganization job
The REORG PLUS job stream
The SYSPRINT from the job

Related topic

Some examples include additional output that might be useful to understand a particular feature.

All of these examples have the following common properties:

These examples use a single BMC product load library, assuming that this library contains the following files and libraries:
- REORG PLUS load files
- Common component load files that REORG PLUS requires
- SAS/C transient library (required for statistics processing)
When data sets are allocated in the JCL, these examples use minimal data set space allocations.
The value for the FILECHK installation option is set to WARN. This value prevents the jobs from failing when they encounter temporary data sets.

You can find copies of the JCL for these examples in member ARUEXnn in the HLQ.LLQCNTL installation data set (where nn is the number of the example, HLQ is the high-level qualifier specified during installation, and LLQ is the low-level qualifier or prefix set during installation).

For syntax details, see Syntax-of-the-REORG-command. For information about JCL statement requirements, see Building-the-REORG-PLUS-job.

Use the following table to locate an example with a specific reorganization, process, or object type, or one that uses a specific option:

Function	Examples
Reorganization type
Full (entire table space/all partitions)	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-6-ANALYZE-ONLY-to-generate-space-estimates Example-7-Selective-unload-with-discards-to-archive-data-set Example-8-ON-FAILURE-with-a-user-specified-return-code Example-9-Partition-by-growth-table-space Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
Partial (selected partitions)	Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job
Index only	Example-3-Index-only-reorganization
Two phase	Example-7-Selective-unload-with-discards-to-archive-data-set Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
Object type
Partition-by-range table space	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-3-Index-only-reorganization Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
Partition-by-growth table space	Example-6-ANALYZE-ONLY-to-generate-space-estimates Example-7-Selective-unload-with-discards-to-archive-data-set Example-8-ON-FAILURE-with-a-user-specified-return-code Example-9-Partition-by-growth-table-space
Clustering index	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job Example-6-ANALYZE-ONLY-to-generate-space-estimates Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing
Nonpartitioned secondary index	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-3-Index-only-reorganization Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job Example-7-Selective-unload-with-discards-to-archive-data-set Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
Data-partitioned secondary index	Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing
ASUSRPRT data set	Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions
ASUSRPRT DD DUMMY	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-5-Restart-of-a-paused-reorganization-job
DDLIN data set	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing
Command option
ACTIVE NO	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning
ACTIVE YES	Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-5-Restart-of-a-paused-reorganization-job Example-8-ON-FAILURE-with-a-user-specified-return-code Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
ANALYZE	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
ANALYZE ONLY	Example-6-ANALYZE-ONLY-to-generate-space-estimates
ANALYZE SAMPLE	Example-9-Partition-by-growth-table-space Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
ANALYZE SCAN	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation
ARCHDDN	Example-7-Selective-unload-with-discards-to-archive-data-set
BMCSTATS YES	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job Example-9-Partition-by-growth-table-space
COPY YES	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-7-Selective-unload-with-discards-to-archive-data-set Example-8-ON-FAILURE-with-a-user-specified-return-code Example-9-Partition-by-growth-table-space Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
COPYDDN	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-7-Selective-unload-with-discards-to-archive-data-set
COPYLVL	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-9-Partition-by-growth-table-space
DDTYPE	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-3-Index-only-reorganization Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job Example-8-ON-FAILURE-with-a-user-specified-return-code Example-9-Partition-by-growth-table-space Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
DEADLINE	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning
DELAY	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
DSNPAT	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-3-Index-only-reorganization Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job Example-8-ON-FAILURE-with-a-user-specified-return-code Example-9-Partition-by-growth-table-space Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
FASTSWITCH	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
KEEPDICTIONARY NO	Example-9-Partition-by-growth-table-space
LOGMEM	Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
LOGSPILL	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
LONGLOG	Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
MAXRO	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
MAXNEWPARTS	Example-9-Partition-by-growth-table-space
ON FAILURE	Example-8-ON-FAILURE-with-a-user-specified-return-code
ORDER NO	Example-6-ANALYZE-ONLY-to-generate-space-estimates Example-7-Selective-unload-with-discards-to-archive-data-set
ORDER YES	Example-6-ANALYZE-ONLY-to-generate-space-estimates Example-8-ON-FAILURE-with-a-user-specified-return-code Example-9-Partition-by-growth-table-space Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
PART	Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job
PREFORMAT YES	Example-9-Partition-by-growth-table-space
RBALRSN_CONVERSION	Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
REBALANCE	Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
RECOVERYDDN	Example-7-Selective-unload-with-discards-to-archive-data-set
REDEFINE NO	Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions Example-3-Index-only-reorganization Example-7-Selective-unload-with-discards-to-archive-data-set
REDEFINE YES	Example-6-ANALYZE-ONLY-to-generate-space-estimates
REGISTER	Example-7-Selective-unload-with-discards-to-archive-data-set Example-9-Partition-by-growth-table-space
REORG INDEX	Example-3-Index-only-reorganization
RIDMAPMEM	Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
SELECT (selective unload)	Example-7-Selective-unload-with-discards-to-archive-data-set
SET	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation
SHRLEVEL NONE	Example-9-Partition-by-growth-table-space
SHRLEVEL REFERENCE	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-2-Partial-reorganization-with-SHRLEVEL-REFERENCE-and-a-single-copy-of-a-subset-of-partitions
SHRLEVEL CHANGE	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
SIZEPCT	Example-9-Partition-by-growth-table-space Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
SORTDATA	Example-8-ON-FAILURE-with-a-user-specified-return-code
SPILLDSNPAT	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
SPILLSTORCLAS	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
SPILLUNIT	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
UNLOAD PAUSE	Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job
UNIT	Example-9-Partition-by-growth-table-space Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes
UNLOAD CONTINUE	Example-6-ANALYZE-ONLY-to-generate-space-estimates Example-7-Selective-unload-with-discards-to-archive-data-set Example-9-Partition-by-growth-table-space Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY
UPDATE	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation
UPDATEDB2STATS YES	Example-4-Partial-reorganization-with-UNLOAD-PAUSE Example-5-Restart-of-a-paused-reorganization-job Example-9-Partition-by-growth-table-space
WHERE clause	Example-1-Single-phase-reorganization-of-a-partitioned-table-space-using-dynamic-data-set-allocation Example-7-Selective-unload-with-discards-to-archive-data-set
XBMID	Example-10-SHRLEVEL-CHANGE-with-DDLIN-and-online-repartitioning Example-11-SHRLEVEL-CHANGE-with-LONGLOG-and-DELAY Example-12-SHRLEVEL-CHANGE-with-table-controlled-partitioning-and-partition-rebalancing Example-13-Materializing-pending-definition-changes

The following topics contain examples of jobs that were run by using the REORG PLUS product:

Examples of REORG PLUS jobs

On this page