have a look at our Maintain for DB2. The Reorg utility does all
wonderful things you wanted to check before actually doing the
The REORG generation feature of Maintain has support for the
versions, e.g., online REORG, inline COPY, and inline RUNSTATS.
thresholds available for REORG definitions allow reorgani-zations
controlled based on the following:
- Minimum object size.
- Reorganization level; table space level, partition level, or
combination, depending on the object size.
- Catalog statistics; PERCDROP, NEARINDREF, FARINDREF, LEAFDIST,
and CLUSTER-RATIO, PERCACTIVE, ORGRATIO.
- Data set extents.
Utility JCL generation for the REORG is determined by Maintain when
above thresholds are reached. Within this JCL, you can control
REORG LOG parameter is on or off depending on table space size.
Definitions of REORG dependent actions are easy. Just indicate
not the JCL for QUIESCE, COPY, RUNSTATS and REBIND utilities should
Runstats generation is handled quite intelligent, too, you can have
on English as well.
For further information you can contact in the States SEGUS
mailto:[login to unmask email]
Software Engineering Germany
<[login to unmask email] An: [login to unmask email]
Gesendet von: DB2 Data Thema: Online Reorgs
Base Discussion List
<[login to unmask email]>
Bitte antworten an DB2
Data Base Discussion
Does anybody have any jcl/programs that are using DB2 utilities for
Reorg (preferably that decides yes or no to do a reorg and possibly
program checks primary and secondary and sets the new quantities
necessary before the reorg).
Trace R. Jones