Online Reorgs

Does anybody have any jcl/programs that are using DB2 utilities for Online
Reorg (preferably that decides yes or no to do a reorg and possibly by
program checks primary and secondary and sets the new quantities as
necessary before the reorg).


Trace R. Jones

Hi Trace,

You might want to take a look at Infotel's Master-Reorg. It works with the
IBM online reorg and provides the intelligence to the process you are
talking about. All you have to do is set up some very simple JCL to give it
a list of candidate objects to reorg and how much time you have available,
either a deadline or a specific number of hours and minutes, for the reorg
process to run. The built in intelligence of the product will decide what
objects need to be reorged the worst and taking into account your timeframes
will process the objects.

-There is no need for RUNSTATS up front.
-You can have the objects resized as part of the process
-If for some reason there is a problem with one of the objects during the
process
MasterReorg will recover it automatically and move on to the next object.
-MasterReorg also comes with InfoReorg, it's own high performance off line
reorg for times when you might prefer not to run an online reorg
-MasterReorg has the ability to cluster freespace around hotspots in the
tablespaces so freespace can be used more effectively, reducing the
frequency of a reorg.
-Post reorg the catalog can be updated with statistics gathered during reorg
process.
-Post reorg binds can be generated for effected objects.

You can find more information on this and the rest of the Infotel products
at the website below. If you would like to hear more feel free to contact
me.

Thanks,
Bob Brock
Krypton Consulting LLC
800-687-8884
972-691-1127
[login to unmask email]
www.krypton-consulting.com

----- Original Message -----
From: "Trace Jones" <[login to unmask email]>
Sent: Wednesday, January 09, 2002 12:16 PM
Subject: Online Reorgs


> Does anybody have any jcl/programs that are using DB2 utilities for Online
> Reorg (preferably that decides yes or no to do a reorg and possibly by
> program checks primary and secondary and sets the new quantities as
> necessary before the reorg).
>
>
> Trace R. Jones
>

Hi Trace,

have a look at our Maintain for DB2. The Reorg utility does all the
wonderful things you wanted to check before actually doing the reorg.

The REORG generation feature of Maintain has support for the current DB2
versions, e.g., online REORG, inline COPY, and inline RUNSTATS. The
thresholds available for REORG definitions allow reorgani-zations to be
controlled based on the following:
- Minimum object size.
- Reorganization level; table space level, partition level, or a
combination, depending on the object size.
- Catalog statistics; PERCDROP, NEARINDREF, FARINDREF, LEAFDIST, FAROFFPOS,
and CLUSTER-RATIO, PERCACTIVE, ORGRATIO.
- Data set extents.
Utility JCL generation for the REORG is determined by Maintain when the
above thresholds are reached. Within this JCL, you can control whether the
REORG LOG parameter is on or off depending on table space size.
Definitions of REORG dependent actions are easy. Just indicate whether or
not the JCL for QUIESCE, COPY, RUNSTATS and REBIND utilities should be
generated.
Runstats generation is handled quite intelligent, too, you can have a look
at http://www.seg.de, description available on English as well.

For further information you can contact in the States SEGUS Inc.
(http://www.segus.com)by mailto:[login to unmask email]

HTH, Dirk

Dirk Johann
Software Engineering Germany
http://www.seg.de




Trace Jones
<[login to unmask email] An: [login to unmask email]
NERGY.COM> Kopie:
Gesendet von: DB2 Data Thema: Online Reorgs
Base Discussion List
<[login to unmask email]>


09.01.02 19:16
Bitte antworten an DB2
Data Base Discussion
List






Does anybody have any jcl/programs that are using DB2 utilities for Online
Reorg (preferably that decides yes or no to do a reorg and possibly by
program checks primary and secondary and sets the new quantities as
necessary before the reorg).


Trace R. Jones