SV: [DB2-L] dsntijne question - useful pattern for cat reorg?

Olle Brostrom

SV: [DB2-L] dsntijne question - useful pattern for cat reorg?
Hello Roy,
Yes, we have built our own catalog reorg jobs based upon DSNTIJNE.
As you indicated we removed the CONVERT8 keyword and we changed the SHRLEVEL to CHANGE from REFERENCE where possible.
We do not reorg the complete catalog on a regular basis. SYSCOPY and SYSLGRNX are reorged once a week and SYSPACKAGE and SPT01 are reorged about once a year.
The SYSCOPY and SYSLGRNX reorg are scheduled in our job scheduler
You need to keep track on the number of datasets allocated for the larger tablespaces which require more than one dataset before you start the reorg.
We have only positive experiences from this.
Olle

-----Ursprungligt meddelande-----
Från: IDUG DB2-L [mailto:[login to unmask email] För Roy Reynolds
Skickat: den 12 januari 2011 16:18
Till: [login to unmask email]
Ämne: [DB2-L] dsntijne question - useful pattern for cat reorg?

Long ago I recall talking with an IBM DB2 catalog guy about migration job DSNTIJNE. We discussed how it was actually a catalog online reorg with the exception of the CONVERTV8 keyword. I seem to recall asking if, after removing that keyword I could use it to run a catalog online reorg. I think he said 'yes'. I'm guessing there were some caveats too but don't recall them now.
I'm preparing to migrate members of a DS group to V9 and want to reorg the catalog first. I doubt it has ever been reorged apart from the migration to V8. Has anyone ever used DSNTIJNE as a pattern for a catalog online reorg?
I'd appreciate advice, experiences, and comments before proceeding in the next week or two.
Thanks,
Roy

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

_____________________________________________________________________
* 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! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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

Cathy Taddei

Re: dsntijne question - useful pattern for cat reorg?
(in response to Olle Brostrom)
We reorg'd every tablespace in our shop to migrate from one DASD frame to another without an outage, and I did use DSNTIJNE from v8 as a model. Since we are v9, I had to look up the indexes for each tablespace because there are quite a few more in v9. Also had to add quite a few tablespaces that were not part of DSNTIJNE, but it was a good starting point.

Cathy

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Roy Reynolds
Sent: Wednesday, January 12, 2011 7:18 AM
To: [login to unmask email]
Subject: [DB2-L] dsntijne question - useful pattern for cat reorg?

Long ago I recall talking with an IBM DB2 catalog guy about migration job DSNTIJNE. We discussed how it was actually a catalog online reorg with the exception of the CONVERTV8 keyword. I seem to recall asking if, after removing that keyword I could use it to run a catalog online reorg. I think he said 'yes'. I'm guessing there were some caveats too but don't recall them now.
I'm preparing to migrate members of a DS group to V9 and want to reorg the catalog first. I doubt it has ever been reorged apart from the migration to V8. Has anyone ever used DSNTIJNE as a pattern for a catalog online reorg?
I'd appreciate advice, experiences, and comments before proceeding in the next week or two.
Thanks,
Roy


_____________________________________________________________________
* 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! *
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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