DB2 System databases

Brahmaiah Peddapadamala

DB2 System databases

 

Hi all,

 

         I have read few links from google, about DSNDB01, DSNDB04,DSNDB06 & DSNDB07. But I could not find much information on DSNDB02,DSNDB03 & DSNDB05,are the database available in DB2?

         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.

 

Lucky

steen rasmussen

DB2 System databases
(in response to Brahmaiah Peddapadamala)
These Databases don't exist - it has been this way since day-1.
Do you really care why these number were skipped ?

Steen

From: Lucky Raps [mailto:[login to unmask email]
Sent: Thursday, August 22, 2013 11: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 information on DSNDB02,DSNDB03 & DSNDB05,are the database available in DB2?

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.



Lucky

-----End Original Message-----

Brahmaiah Peddapadamala

RE: DB2 System databases
(in response to steen rasmussen)

 

No, out of interest. I asked. But in one of the presentation, i read about DSNDB02.

http://www.iiug.org/idug06/C04.pdf

 

Thanks

Lucky

Lizette Koehler

DB2 System databases
(in response to Brahmaiah Peddapadamala)
This is a good question and probably more of a historical aspect.



What purpose would knowing the DSNDB02/03/05 do for your job function?



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 IBM does what it
does. So that they do not exist does not cause me any issues.



Over the years (I started with DB2 V1.3) IBM has added and removed elements
without much fanfare.



This is definitely one of those areas where it would be nice if there was a
cross reference table of what tables belong to what tablespaces. Which you
can find some of the information through various searches. I learn a lot by
just doing lists against some of the SYSIBM.SYS* tables and see how the
associations work.



Humans typically love things in sequence, but I find that only valid for
numbers. If you have colors in a sequence how would you do that,
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 as numbers. But
rather as just another way to specify a name. So I sometimes for fun, will
label things out of order just to annoy my coworkers. So a program with
lots of loops I might code Loop1 followed by Loop4 followed by LoopA, and
just make things chaotic. You could not assume that you would go from Loop1
to Loop2 in some of my code.







Lizette









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 information on DSNDB02,DSNDB03 &
DSNDB05,are the database available in DB2?

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.



Lucky

_____

Adam Baldwin

RE: DB2 System databases
(in response to steen rasmussen)

A quick trawl of the DB2L archives suggests that in an early incarnation of DB2 DSNDB03 was the catalog and DSNDB05 the temporary database. I don't remember that myself (having worked with DB2 since V1.2) but that could be due to memory loss...

Interestingly, in the QMF 10 manual I see:

"Users should not use any of the databases used exclusively by DB2 itself. These databases include DSNDB01, DSNDB03, and DSNDB05."

....

 

Adam

William Favero

DB2 System databases
(in response to Brahmaiah Peddapadamala)
DSNDB03 and DSNDB05 are from DB2 V1.1. These have not been of interest
to anyone since about 1987.

DSNDB02 is used occasionally internally by DB2.

--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA

On 8/22/2013 11:47 AM, Lucky Raps wrote:
>
> No, out of interest. I asked. But in one of the presentation, i read
> about DSNDB02.
>
> http://www.iiug.org/idug06/C04.pdf
>
> Thanks
>
> Lucky
>
>
> -----End Original Message-----

William Favero

DB2 System databases
(in response to Brahmaiah Peddapadamala)
BTW, in case you come across the directory table SCT02 and start
wondering what happened to SCT01... SCT01 vanished at the same time the
catalog was changed when we moved form DB2 v1.1 to DB2 v1.2.

--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA

On 8/22/2013 11:47 AM, Lucky Raps wrote:
>
> No, out of interest. I asked. But in one of the presentation, i read
> about DSNDB02.
>
> http://www.iiug.org/idug06/C04.pdf
>
> Thanks
>
> Lucky
>
>
> -----End Original Message-----

William Favero

DB2 System databases
(in response to Lizette Koehler)
The DB2 catalog was restructured between DB2 v1.1 and DB2 v1.2. This
resulted in DSNDB03 becoming DSNDB04 for the catalog and DSNDB05
becoming DSNDB07 for sort.

This was the first and last time a new catalog was introduced because of
catalog structure changes. Since v1.2 all structure changes where
(are) made directly to the existing catalog.

You can still see DSNDB02 pop up every once in a while when certain
internal things happen in DB2.

--
Willie
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 aspect.
>
> What purpose would knowing the DSNDB02/03/05 do for your job function?
>
> 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 IBM does
> what it does. So that they do not exist does not cause me any issues.
>
> Over the years (I started with DB2 V1.3) IBM has added and removed
> elements without much fanfare.
>
> This is definitely one of those areas where it would be nice if there
> was a cross reference table of what tables belong to what tablespaces.
> Which you can find some of the information through various searches.
> I learn a lot by just doing lists against some of the SYSIBM.SYS*
> tables and see how the associations work.
>
> Humans typically love things in sequence, but I find that only valid
> for numbers. If you have colors in a sequence how would you do that,
> 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 as
> numbers. But rather as just another way to specify a name. So I
> sometimes for fun, will label things out of order just to annoy my
> coworkers. So a program with lots of loops I might code Loop1 followed
> by Loop4 followed by LoopA, and just make things chaotic. You could
> not assume that you would go from Loop1 to Loop2 in some of my code.
>
> Lizette
>
> *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 information on
> DSNDB02,DSNDB03 & DSNDB05,are the database available in DB2?
>
> 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.
>
> Lucky
>
> ------------------------------------------------------------------------
>
> -----End Original Message-----

Adam Baldwin

RE: DB2 System databases
(in response to William Favero)

Thanks for that interesting bit of DB2 history Willie. I've never stopped to think about the reasons behind the DSNDBnn naming conventions. Nice to fill in the gaps.

Cheers, Adam

James Campbell

DB2 System databases
(in response to William Favero)
Surely that's a typo and should be "DSNDB06 for the catalog"

On 22 Aug 2013 at 12:45, Willie Favero wrote:

>
> The DB2 catalog was restructured between DB2 v1.1 and DB2 v1.2. This resulted in
> DSNDB03 becoming DSNDB04 for the catalog

<rest snipped>

Brahmaiah Peddapadamala

RE: DB2 System databases
(in response to James Campbell)

Thanks you all for the interesting information.

 

  Can anyone share some information on DSNDB02, how it is used in DB2 or share some links from DB2 infocenter or IBM Manuals that I can read to know bit on DSNDB02 DB.

Thanks

Lucky

William Favero

DB2 System databases
(in response to James Campbell)
Yup.... you're right....

and that's why people like me should never take vacations...

--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA

On 8/22/2013 6:39 PM, James Campbell wrote:
> Surely that's a typo and should be "DSNDB06 for the catalog"
>
> On 22 Aug 2013 at 12:45, Willie Favero wrote:
>
>> The DB2 catalog was restructured between DB2 v1.1 and DB2 v1.2. This resulted in
>> DSNDB03 becoming DSNDB04 for the catalog
> <rest snipped>
>
> -----End Original Message-----
>
>

William Favero

DB2 System databases
(in response to Brahmaiah Peddapadamala)
Nope....

--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA

On 8/22/2013 7:17 PM, Lucky Raps wrote:
>
> Thanks you all for the interesting information.
>
> Can anyone share some information on DSNDB02, how it is used in DB2
> or share some links from DB2 infocenter or IBM Manuals that I can read
> to know bit on DSNDB02 DB.
>
> Thanks
>
> Lucky
>
>
> -----End Original Message-----

Nguyen Duc Tuan

DB2 System databases
(in response to William Favero)
Lucky, be careful.
It is good to be curious about every thing. Because you learn by this.
But don't loose your time with dsndb02 or dsndb03 ... they don't exist.
Point.
There is a difference between trying to understand about the Db2 mechanics
vs. Waste your time and energy with what in French we say "masturbation
intellectuelle"
Just an advice of a technician.
On 23 Aug 2013 04:39, "Willie Favero" <[login to unmask email]> wrote:

> Nope....
>
> --
> Willie
> My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
> Houston, TX, USA
>
> On 8/22/2013 7:17 PM, Lucky Raps wrote:
>
> Thanks you all for the interesting information.
>
>
>
> Can anyone share some information on DSNDB02, how it is used in DB2 or
> share some links from DB2 infocenter or IBM Manuals that I can read to know
> bit on DSNDB02 DB.
>
> Thanks
>
> Lucky
>
> -----End Original Message-----
>
>
>
> -----End Original Message-----
>

Colin Clayton

DB2 System databases
(in response to Lizette Koehler)
So no programming standards at your site then Lizette ? :)

Colin

From: Lizette Koehler [mailto:[login to unmask email]
Sent: 22 August 2013 18:55
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 System databases

This is a good question and probably more of a historical aspect.

What purpose would knowing the DSNDB02/03/05 do for your job function?

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 IBM does what it does. So that they do not exist does not cause me any issues.

Over the years (I started with DB2 V1.3) IBM has added and removed elements without much fanfare.

This is definitely one of those areas where it would be nice if there was a cross reference table of what tables belong to what tablespaces. Which you can find some of the information through various searches. I learn a lot by just doing lists against some of the SYSIBM.SYS* tables and see how the associations work.

Humans typically love things in sequence, but I find that only valid for numbers. If you have colors in a sequence how would you do that, 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 as numbers. But rather as just another way to specify a name. So I sometimes for fun, will label things out of order just to annoy my coworkers. So a program with lots of loops I might code Loop1 followed by Loop4 followed by LoopA, and just make things chaotic. You could not assume that you would go from Loop1 to Loop2 in some of my code.



Lizette




From: Lucky Raps [mailto:[login to unmask email]
Sent: Thursday, August 22, 2013 9:36 AM
To: [login to unmask email]<mailto:[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 information on DSNDB02,DSNDB03 & DSNDB05,are the database available in DB2?

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.



Lucky

________________________________

-----End Original Message-----

Adam Baldwin

RE: DB2 System databases
(in response to Brahmaiah Peddapadamala)

A quick google search on DB2 DSNDB02 gives:

DSNDB02 - dbid = 2

Contains a bit map on assignment/free DBIDs for user created databases.

No underlying tablespace.

The bit map is stored in its own DBD.

Adam

William Favero

DB2 System databases
(in response to Lizette Koehler)
Lizette

You mention that it would be nice if a cross reference existed of what
tables go with what table spaces.

Most of that information does exist in the SQL Reference manual in the
Appendix, the section marked "DB2 Catalog Tables", subsection "Table
spaces and indexes". What isn't listed there is available in the DB2
Diagnostics Guide and Reference.

--
Willie
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 aspect.
>
> What purpose would knowing the DSNDB02/03/05 do for your job function?
>
> 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 IBM does
> what it does. So that they do not exist does not cause me any issues.
>
> Over the years (I started with DB2 V1.3) IBM has added and removed
> elements without much fanfare.
>
> This is definitely one of those areas where it would be nice if there
> was a cross reference table of what tables belong to what tablespaces.
> Which you can find some of the information through various searches.
> I learn a lot by just doing lists against some of the SYSIBM.SYS*
> tables and see how the associations work.
>
> Humans typically love things in sequence, but I find that only valid
> for numbers. If you have colors in a sequence how would you do that,
> 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 as
> numbers. But rather as just another way to specify a name. So I
> sometimes for fun, will label things out of order just to annoy my
> coworkers. So a program with lots of loops I might code Loop1 followed
> by Loop4 followed by LoopA, and just make things chaotic. You could
> not assume that you would go from Loop1 to Loop2 in some of my code.
>
> Lizette
>
> *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 information on
> DSNDB02,DSNDB03 & DSNDB05,are the database available in DB2?
>
> 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.
>
> Lucky
>
> ------------------------------------------------------------------------
>
> -----End Original Message-----

Ted MacNeil

DB2 System databases
(in response to Colin Clayton)
I tend to agree.
This haphazard approach to labels is a great way to confuse future maintainers.

(No smiley)

-
Ted MacNEIL
[login to unmask email]
Twitter: @TedMacNEIL

-----Original Message-----
From: "Clayton, Colin" <[login to unmask email]>
Date: Fri, 23 Aug 2013 09:24:15
To: [login to unmask email]<[login to unmask email]>
Reply-To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 System databases

So no programming standards at your site then Lizette ? :)

Colin

From: Lizette Koehler [mailto:[login to unmask email]
Sent: 22 August 2013 18:55
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 System databases

This is a good question and probably more of a historical aspect.

What purpose would knowing the DSNDB02/03/05 do for your job function?

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 IBM does what it does. So that they do not exist does not cause me any issues.

Over the years (I started with DB2 V1.3) IBM has added and removed elements without much fanfare.

This is definitely one of those areas where it would be nice if there was a cross reference table of what tables belong to what tablespaces. Which you can find some of the information through various searches. I learn a lot by just doing lists against some of the SYSIBM.SYS* tables and see how the associations work.

Humans typically love things in sequence, but I find that only valid for numbers. If you have colors in a sequence how would you do that, 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 as numbers. But rather as just another way to specify a name. So I sometimes for fun, will label things out of order just to annoy my coworkers. So a program with lots of loops I might code Loop1 followed by Loop4 followed by LoopA, and just make things chaotic. You could not assume that you would go from Loop1 to Loop2 in some of my code.



Lizette




From: Lucky Raps [mailto:[login to unmask email]
Sent: Thursday, August 22, 2013 9:36 AM
To: [login to unmask email]<mailto:[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 information on DSNDB02,DSNDB03 & DSNDB05,are the database available in DB2?

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.



Lucky

________________________________

-----End Original Message-----

-----End Original Message-----

Mick Graley

DB2 System databases
(in response to William Favero)

Hi Willie,

I believe the SCT01 to SCT02 change happened later than that. It happened
on one the DB2 upgrades I worked on and the first one I worked on as a DB2
systems type was v2.3 to v3.1. It may have even been v3.1 to v4.1 as that
was a much bigger upgrade as I remember. DB2 v1.1 and DSNDB03/05 are before
my time!

Cheers,

Mick.




From: Willie Favero <[login to unmask email]>
To: [login to unmask email]
Date: 22/08/2013 18:28
Subject: [DB2-L] - RE: DB2 System databases



BTW, in case you come across the directory table SCT02 and start wondering
what happened to SCT01... SCT01 vanished at the same time the catalog was
changed when we moved form DB2 v1.1 to DB2 v1.2.
--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA

On 8/22/2013 11:47 AM, Lucky Raps wrote:





No, out of interest. I asked. But in one of the presentation, i read
about DSNDB02.


http://www.iiug.org/idug06/C04.pdf





Thanks


Lucky



-----End Original Message-----



Site Links: View post online View mailing list online Send new post via
email Unsubscribe from this mailing list Manage your subscription
** ** ** Attend the 2013 EMEA IDUG DB2 Tech Conference ** ** **
--> --> Barcelona, Spain 13 - 18 October 2013 <-- <--
http://www.idug.org/p/cm/ld/fid=273

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2
Attachments

  • graycol.gif (<1k)

William Favero

DB2 System databases
(in response to Mick Graley)
Since it's Friday, I guess going off on a history tangent will be OK.

In DB2 v1.1, a plan was one big chunk. When it was loaded, the entire
plan had to be loaded; not a very storage friendly process in the old
MVS/370 days. These plans were stored in a directory object called SCT01.

DB2 v1.2 solved this issue with the introduction of plan segmentation.
A plan would now be broken up into segments and only the segment
necessary to execute an SQL statement would get loaded into the buffers.

Because of this change to segmented plans, it was decided it would be a
more straightforward release migration by introducing a plan table
structure that accounted for plan segmentation rather than use the old
that would require conversion. That new v1.2 directory structure was
called SCT02.

SCT02 has been used for plans since DB2 v1.2.

When packages were introduced in DB2 v2.3, a completely new table
structure was introduced to support packages called SPT01.

Today we have SCT02 for plans and SPT01 for packages.

--
Willie
My DB2 blog --> http://it.toolbox.com/blogs/db2zos/
Houston, TX, USA

On 8/23/2013 9:40 AM, Mick P Graley wrote:
>
> Hi Willie,
>
> I believe the SCT01 to SCT02 change happened later than that. It
> happened on one the DB2 upgrades I worked on and the first one I
> worked on as a DB2 systems type was v2.3 to v3.1. It may have even
> been v3.1 to v4.1 as that was a much bigger upgrade as I remember. DB2
> v1.1 and DSNDB03/05 are before my time!
>
> Cheers,
>
> Mick.
>
>
> Inactive hide details for Willie Favero ---22/08/2013 18:28:55---BTW,
> in case you come across the directory table SCT02 and staWillie Favero
> ---22/08/2013 18:28:55---BTW, in case you come across the directory
> table SCT02 and start wondering what happened to SCT01..
>
> From: Willie Favero <[login to unmask email]>
> To: [login to unmask email]
> Date: 22/08/2013 18:28
> Subject: [DB2-L] - RE: DB2 System databases
>
> ------------------------------------------------------------------------
>
>
>
> BTW, in case you come across the directory table SCT02 and start
> wondering what happened to SCT01... SCT01 vanished at the same time
> the catalog was changed when we moved form DB2 v1.1 to DB2 v1.2.
> --
> Willie
> My DB2 blog --> _http://it.toolbox.com/blogs/db2zos/_
> Houston, TX, USA
>
> On 8/22/2013 11:47 AM, Lucky Raps wrote:
>
>
> No, out of interest. I asked. But in one of the presentation, i
> read about DSNDB02.
>
> _http://www.iiug.org/idug06/C04.pdf_
>
> Thanks
>
> Lucky
>
>
> -----End Original Message-----
>
>
>
> -----End Original Message-----

rajendra prasad

RE: DB2 System databases
(in response to William Favero)

Thanks for sharing the information
Could you please share in word document regarding db2 migration process,db2 installation process,zparms and use smp/e process to install

How ever manuals available its long process unable to follow

 

T Rajendra Prasad 

db2dbazos and db2dbaluw