RTS & DSNACCOX

Tom Glaser

RTS & DSNACCOX
Hi,

I’m investigating the use of stored procedure DSNACCOX (DB2 V9) to allow the RTS to tell us when to take a Reorg. I’m interested in how other companies are using this stored procedure? Do you run this daily against the entire subsystem and generate a list of all table spaces that should be reorg’d…then submit one job for all of them….or maybe submit multiple jobs at a time? Maybe you run the stored procedure and build “exclude” control cards that are used with the listdef command within the utility….then run a reorg with listdef and when it sees the exclude, it doesn’t take a reorg. Just trying to get an idea on how to best use this stored procedure.

Thanks in advance,

Tom Glaser

DB2 Support
MasterCard
tel 1-636-722-3087
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

PAUL WALTERS

Re: RTS & DSNACCOX
(in response to Tom Glaser)
If we have partitioned objects and we always reorg at the tablespace level it would get one job. If we reorg at the part level we would have one reorg per part. We build these reorg jobs when the object is built - so we can combine the output of DSNACCOX with a list of jobs names and feed this directly into our scheduling system.

We handle our reorg indexes differently we - we produced the list of indexes to be reorged and divide the list among 20 reorg index jobs.

Most of our reorgs run off hours over the weekend when our incoming traffic is the lightest. We build the selection Friday during the day so we can adjust it as needed.

We have larger monthly window where we do anything that might be disruptive.


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Tom Glaser
Sent: Wednesday, December 01, 2010 2:00 PM
To: [login to unmask email]
Subject: [DB2-L] RTS & DSNACCOX

Hi,

I’m investigating the use of stored procedure DSNACCOX (DB2 V9) to allow the RTS to tell us when to take a Reorg. I’m interested in how other companies are using this stored procedure? Do you run this daily against the entire subsystem and generate a list of all table spaces that should be reorg’d…then submit one job for all of them….or maybe submit multiple jobs at a time? Maybe you run the stored procedure and build “exclude” control cards that are used with the listdef command within the utility….then run a reorg with listdef and when it sees the exclude, it doesn’t take a reorg. Just trying to get an idea on how to best use this stored procedure.

Thanks in advance,

Tom Glaser

DB2 Support
MasterCard
tel 1-636-722-3087
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

This E-Mail has been scanned for viruses.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv