If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Z/OS Version 8 SYSIBM table documentation?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-14-07, 12:32
db2dcs db2dcs is offline
Registered User
 
Join Date: Feb 2005
Location: United States
Posts: 20
Z/OS Version 8 SYSIBM table documentation?

We are running Z/OS DB2 version 8 - but just in 'compatibility mode'.
That is the mode where they don't yet convert the DB2 catalogue.

Soon we will be entering 'new function' mode and by then the DB2 catalogue will be converted to the version 8 format.

To prepare for this, I want to get a sneak preview of how the SYSIBM db2 catalogue tables have changed. We have some dynamic processes that read these tables, and that will probably require some adjustments.

Where can I get documentation that will provide me with the structures of the SYSIBM db2 catalogue tables for Z/OS version 8 ?

thank-you for anyone who can assist.
db2dcs
Reply With Quote
  #2 (permalink)  
Old 11-14-07, 13:06
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
You can find the catalog tables in the manual:

http://publib.boulder.ibm.com/infoce...ls.htm#rctabls
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
  #3 (permalink)  
Old 11-14-07, 13:10
nidm nidm is offline
Registered User
 
Join Date: May 2003
Posts: 113
I think you are right that V8 CM hasn't convert the catalog table yet.

One way to verify it, you can try look at syscolumns

SELECT NAME, COLTYPE, LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = 'SYSTABLES' AND TBCREATOR = 'SYSIBM'.

then compare the column type and length with v7 sql ref, to see whether they are the same.

Quote:
Originally Posted by db2dcs
We are running Z/OS DB2 version 8 - but just in 'compatibility mode'.
That is the mode where they don't yet convert the DB2 catalogue.

Soon we will be entering 'new function' mode and by then the DB2 catalogue will be converted to the version 8 format.

To prepare for this, I want to get a sneak preview of how the SYSIBM db2 catalogue tables have changed. We have some dynamic processes that read these tables, and that will probably require some adjustments.

Where can I get documentation that will provide me with the structures of the SYSIBM db2 catalogue tables for Z/OS version 8 ?

thank-you for anyone who can assist.
db2dcs
Reply With Quote
  #4 (permalink)  
Old 11-14-07, 14:22
nidm nidm is offline
Registered User
 
Join Date: May 2003
Posts: 113
need to take my words back. V8 CM already change some catalog definition.

Quote:
Originally Posted by nidm
I think you are right that V8 CM hasn't convert the catalog table yet.

One way to verify it, you can try look at syscolumns

SELECT NAME, COLTYPE, LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = 'SYSTABLES' AND TBCREATOR = 'SYSIBM'.

then compare the column type and length with v7 sql ref, to see whether they are the same.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On