Viewing Db2 Catalog Columns

From the Information display screens for table, index, or trigger, you can enter the BROWSE command, and the Db2 catalog data for that particular object type will display. From this display, you are able to view all catalog columns within a File-AID for Db2 Browse session.

The BROWSE command is not only available from the Table Information, Index Information, and Trigger Information display screens, but it is also available from their dependent information screens. The following table lists the screens from which you can enter BROWSE to display the Db2 catalog data.

Important

The BROWSE command is not available from the following screens:

Table - Remarks/Comment On
Trigger - Trigger Text
Trigger - Remarks/Comment On

Screens Available from BROWSE for Db2 Catalog Data

Screen	Db2 Catalog Table	Display Mode
Table Information	SYSTABLES	Row
Column Information	SYCOLUMNS	Table
Index Information - Table Index Section (only one index on table)	SYSINDEXES	Table
Index Information – Table Index Section (multiple indexes on table)	SYSINDEXES	Table
Related Table Information	SYSRELS	Table
Related Trigger Information - Trigger Selection	SYSTRIGGERS	Table
Table Partition Statistics	SYSTABSTATS	Table
Table Check Constraints	SYSCHECKS	Table
Column Partition Statistics	SYSCOLSTATS	Table
Index Information	SYSINDEXES - For Db2 Version 7 and 8, index is created on column only. For Db2 Version 9, index on expression is created, and the value for IX_EXTENSION_TYPE field is S.	Row
Index Key Information	SYSKEYS SYSKEYTARGETS - Displays only when an index on expression is created. The expression comes from the Derived From column in SYSKEYTARGETS.	Table
Index Partition Information	SYSINDEXPART	Table
Trigger Information	SYSTRIGGERS	Row

Important

The BROWSE command is not available from the following screens:

Table - Remarks/Comment On
Trigger - Trigger Text
Trigger - Remarks/Comment On

The following figure is an example of a Table Information display screen. When you enter the BROWSE command from this screen, the Db2 catalog data displays, as shown in Information Display Screen with Db2 Catalog Data Display.

Table Information Display Screen (Before BROWSE)

Information Display Screen with Db2 Catalog Data Display

File Edit View Options Open Menu Utilities Help
------------------------------------------------------------------------------
File-AID for DB2 Browse SYSIBM.SYSTABLES                        SSID: DSN
COMMAND ===>                                                  SCROLL ===> PAGE
Row 1                                                               MAXCOL 160
     COLUMN NAME        TYPE(LEN)   KEY           COLUMN VALUE
--- ------------------ ---------- ---- ----+---10----+---20----+---30----+---40
001 NAME               VC(128)     PRIM SYSTABLES
         (POS 41-80)
         (POS 81-120)
         (POS 121-128)
002 CREATOR            VC(128)     PRIM SYSIBM
        (POS 41-80)
        (POS 81-120)
        (POS 121-128)
003 TYPE              CHAR(1)         T
004 DBNAME            VC(24)          DSNDB06
005 TSNAME            VC(24)          SYSTSTAB
006 DBID              SMALLINT        6
007 OBID              SMALLINT        19
008 COLCOUNT          SMALLINT        59
009 EDPROC            VC(24)
010 VALPROC           VC(24)
011 CLUSTERTYPE       CHAR(1)
012 CLUSTERRID        INTEGER         0
013 CARD              INTEGER        -1
014 NPAGES            INTEGER         395
015 PCTPAGES          SMALLINT        7
016 IBMREQD           CHAR(1)         Y
017 REMARKS           VC(762)
         (POS 41-80)
         (POS 81-120)
         (POS 121-160)
018 PARENTS           SMALLINT       1
019 CHILDREN          SMALLINT       15
020 KEYCOLUMNS        SMALLINT       2
021 RECLENGTH         SMALLINT       2333
022 STATUS            CHAR(1)        X
023 KEYOBID           SMALLINT       61
024 LABEL             VC(90)
        (POS 41-80)
        (POS 81-90)
025 CHECKFLAG         CHAR(1)
026 CHECKRID          CHAR(4)
027 AUDITING          CHAR(1)
028 CREATEDBY         VC(128)         SYSIBM
         (POS 41-80)
         (POS 81-120)
         (POS 121-128)
029 LOCATION          VC(128)
         (POS 41-80)
         (POS 81-120)
         (POS 121-128)
030 TBCREATOR         VC(128)
         (POS 41-80)
         (POS 81-120)
         (POS 121-128)
031 TBNAME            VC(128)
         (POS 41-80)
         (POS 81-120)
         (POS 121-128)
032 CREATEDTS         TIMESTMP         1985-04-01-00.00.00.000000
033 ALTEREDTS         TIMESTMP         2010-08-09-16.31.49.717119
034 DATACAPTURE       CHAR(1)
035 RBA1              CHAR(6)          ......
036 RBA2              CHAR(6)          .....H
037 PCTROWCOMP        SMALLINT         0
038 STATSTIME         TIMESTMP         2013-04-27-02.30.07.549573
039 CHECKS            SMALLINT         7
040 CARDF             FLOAT(8)         5.1010000000000E+03
041 CHECKRID5B        CHAR(5)
042 ENCODING_SCHEME   CHAR(1)          U
043 TABLESTATUS       VC(30)
044 NPAGESF           FLOAT(8)         3.9500000000000E+02
045 SPACEF            FLOAT(8)         2.0160000000000E+04
046 AVGROWLEN         INTEGER          227
047 RELCREATED        CHAR(1)
048 NUM_DEP_MQTS      SMALLINT         0
049 VERSION           SMALLINT         0
050 PARTKEYCOLNUM     SMALLINT         0
051 SPLIT_ROWS        CHAR(1)
052 SECURITY_LABEL    CHAR(1)
053 OWNER             VC(128)
          (POS 41-80)
          (POS 81-120)
          (POS 121-128)
054 APPEND             CHAR(1)          N
055 OWNERTYPE          CHAR(1)
056 CONTROL            CHAR(1)
057 VERSIONING_SCHEMA VC(128)
           (POS 41-80)
           (POS 81-120)
           (POS 121-128)
058 VERSIONING_TABLE     VC(128)
           (POS 41-80)
           (POS 81-120)
           (POS 121-128)
059 HASHKEYCOLUMNS      SMALLINT          0
******************************* BOTTOM OF DATA ********************************

Viewing Db2 Catalog Columns

On this page