The DB2 catalog was restructured between DB2 v1.1 and DB2 v1.2.
resulted in DSNDB03 becoming DSNDB04 for the catalog and
becoming DSNDB07 for sort.
This was the first and last time a new catalog was introduced
catalog structure changes. Since v1.2 all structure changes
(are) made directly to the existing catalog.
You can still see DSNDB02 pop up every once in a while when
internal things happen in DB2.
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA
On 8/22/2013 11:55 AM, Lizette Koehler wrote:
> This is a good question and probably more of a historical
> What purpose would knowing the DSNDB02/03/05 do for your job
> If they do not exist, then they would not be important.
> As far as I know, I have not heard of an explanation of WHY
> what it does. So that they do not exist does not cause me any
> Over the years (I started with DB2 V1.3) IBM has added and
> elements without much fanfare.
> This is definitely one of those areas where it would be nice
> was a cross reference table of what tables belong to what
> Which you can find some of the information through various
> I learn a lot by just doing lists against some of the
> tables and see how the associations work.
> Humans typically love things in sequence, but I find that only
> for numbers. If you have colors in a sequence how would you do
> alphabetic, wavelength, and so forth. But numbers we want to
go from 1
> -- 10 in order. But in dataset names I no longer see numbers
> numbers. But rather as just another way to specify a name. So
> sometimes for fun, will label things out of order just to
> coworkers. So a program with lots of loops I might code Loop1
> by Loop4 followed by LoopA, and just make things chaotic. You
> not assume that you would go from Loop1 to Loop2 in some of my
> *From:*Lucky Raps [mailto:[login to unmask email]
> *Sent:* Thursday, August 22, 2013 9:36 AM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - DB2 System databases
> Hi all,
> I have read few links from google, about DSNDB01,
> DSNDB04,DSNDB06 & DSNDB07. But I could not find much
> DSNDB02,DSNDB03 & DSNDB05,are the database available in
> If yes, can any one help with some information on these db
> and its uses or alteast some material?
> If no, is there any specific reason for IBM to skip these
> number series?
> Thanks for your help.
> -----End Original Message-----