Limited supportBMC 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.

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

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)

1, 2, 7, 8, 9, 10, 11, 12, 13, 14, 15

Partial (selected partitions)

3, 5, 6

Index only

Two phase

8, 10, 11, 12

DSNUTILB reorganization

Object type

Partitioned table space

2, 3, 5, 6, 12, 13, 14, 15

Segmented table space

1, 7, 8, 9, 10

Partition-by-growth table space

VCAT-defined table space

Clustering index

1, 2, 3, 5, 6, 7, 11, 12, 13

Nonpartitioned secondary index

2, 3, 4, 5, 6, 8, 12,13,14

Data-partitioned secondary index

Index created with DEFER YES

Index containing keys with random ordering

ASUSRPRT data set

ASUSRPRT DD DUMMY

2, 6

DDLIN data set

SYSIDCIN data set

Command option

ACTIVE NO

1, 2, 9, 12

ACTIVE YES

3, 9, 10

ANALYZE

ANALYZE ONLY

ANALYZE SAMPLE

11, 14, 15

ANALYZE SCAN

ARCHDDN

BMCSTATS YES

2, 3, 5, 6, 11

COPY YES

1, 2, 3, 8, 9, 10, 11, 12, 13, 14, 15

COPYDDN

2, 8, 10

COPYLVL

2, 3, 10, 11

DDTYPE

1, 2, 3, 4, 5, 6, 9, 10, 11, 12, 13, 14, 15

DEADLINE

DELAY

DELETEFILES NO

DSNPAT

2, 3, 4, 5, 6, 9, 10, 11, 12, 13, 14, 15

FASTSWITCH

12, 13, 14, 15

IFALLOC

INLINE YES

KEEPDICTIONARY NO

LOGMEM

LOGSPILL

LONGLOG

MAXEXTSZ

MAXRO

MAXNEWPARTS

ON FAILURE

ORDER NO

7, 8

ORDER YES

7, 9, 10, 11, 12, 13, 14, 15

PART

3, 5, 6

PREFORMAT YES

RBALRSN_CONVERSION

REBALANCE

RECOVERYDDN

REDEFINE NO

3, 4, 8,10

REDEFINE YES

REGISTER

REORG INDEX

RIDMAPMEM

SELECT (selective unload)

SET

SHRLEVEL NONE

SHRLEVEL REFERENCE

2, 3

SHRLEVEL CHANGE

12, 13, 14, 15

SIZEPCT

SORTDATA

SORTDEVT

SORTNUM

SPILLDSNPAT

SPILLSTORCLAS

SPILLUNIT

THRESHLD

UNLOAD PAUSE

5, 6

UNIT

10, 11, 12, 13, 14, 15

UNITCNT

UNLOAD CONTINUE

7, 8, 10, 11, 12

UPDATE

UPDATEDB2STATS YES

1, 5, 6, 10, 11

VOLCNT

WHERE clause

2, 8

XBMID

12, 13, 14, 15

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

Related topic

Getting-started

 

 

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