Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Location
    United States
    Posts
    22

    Unanswered: 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

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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

  3. #3
    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

  4. #4
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •