The DB2 Server for VM and DB2 Server for VSE database management systems maintain a set of tables, called catalog tables, that store information about the database. The catalog tables are automatically updated by the database manager during normal operation and in response to SQL data definition and control statements. Following is a Roadmap.
| Item | Catalog Table | Page |
|---|---|---|
| authorization |
SYSUSERAUTH SYSUSERLIST |
|
| character conversion | SYSSTRINGS |
|
| character set | SYSCHARSETS |
|
| coded character set identifiers |
SYSCCSIDS SYSSTRINGS |
|
| column |
SYSCOLUMNS SYSKEYCOLS |
|
| column update privilege | SYSCOLAUTH |
|
| column with field procedure | SYSFIELDS |
|
| constraint | SYSKEYS |
|
| dbspace |
SYSDBSPACES SYSUSAGE SYSDROP |
|
| dbspace waiting to be dropped | SYSDROP |
|
| default | SYSOPTIONS |
|
| dropped dbspace | SYSDROP |
|
| dropped table | SYSDROP |
|
| field procedures |
SYSFPARMS SYSFIELDS |
|
| foreign key | SYSKEYS |
|
| index |
SYSINDEXES SYSUSAGE |
|
| index column statistics |
SYSCOLSTATS SYSCOLUMNS SYSINDEXES |
|
| key | SYSKEYS |
|
| key column | SYSKEYCOLS |
|
| language for character set | SYSLANGUAGE |
|
| option | SYSOPTIONS |
|
| package |
SYSACCESS SYSUSAGE |
|
| package run privilege | SYSPROGAUTH |
|
| password | SYSUSERAUTH |
|
| privilege |
SYSCOLAUTH SYSPROGAUTH SYSTABAUTH |
|
| primary key | SYSKEYS |
|
| statistics |
SYSCATALOG SYSCOLSTATS SYSCOLUMNS SYSDBSPACES SYSINDEXES |
|
| stored procedures |
SYSPARMS SYSPSERVERS SYSROUTINES |
|
| synonym | SYSSYNONYMS |
|
| table |
SYSCATALOG SYSCOLUMNS SYSUSAGE |
|
| table privilege | SYSTABAUTH |
|
| table waiting to be dropped | SYSDROP |
|
| unique constraint | SYSKEYS |
|
| view |
SYSVIEWS SYSCATALOG SYSCOLUMNS SYSACCESS SYSUSAGE |
|
| view privilege | SYSTABAUTH |
|
Following is a description of the catalog tables:
SYSACCESS Records information
about the tables in which packages are stored.
| CONSTKN | FIRSTROW | TABID | TNAME |
| CREATOR | LINKID | TABTYPE | VALID |
| DBSPACENO | PLABEL | TIMESTAMP |
SYSCATALOG Contains a row for
each table or view in the database, including one for itself and one for each
catalog table.
| AVGROWLEN | DBSPACENO | NCOLS | ROWCOUNT |
| CLUSTERROW | DEPENDENTS | NOVERFLOW | TABID |
| CLUSTERTYPE | INACTIVE | NPAGES | TABLETYPE |
| CREATOR | LFDDBSPACE | PARENTS | TLABEL |
| DATACAPTURE | LFDLINK | PCTPAGES | TNAME |
| DBSPACENAME | LFDTABID | REMARKS |
SYSCCSIDS Contains a row for
every CCSID supported by the database manager.
| CCSID | DBCSID | SUBTYPE |
| CHARNAME | SBCSID |
|
SYSCHARSETS Rows contain
information about various EBCDIC character sets; information is based on
what is specified in the CHARNAME initialization parameter.
| CHARCLASS | CHARTRANS | NAME |
|
SYSCOLAUTH Records grants of
the UPDATE privilege on tables and views when the privilege is granted on a
column-by-column basis.
| COLNAME | GRANTEE | TIMESTAMP |
| CREATOR | GRANTOR | TNAME |
SYSCOLSTATS Keeps column
statistics for a column which is the first column of an index.
| CNAME | FREQ2PCT | TNAME | VAL90 |
| CREATOR | FREQ1VAL | VAL10 |
|
| FREQ1PCT | FREQ2VAL | VAL50 |
|
SYSCOLUMNS Contains a more
detailed description of the database than SYSCATALOG.
| AVGCOLLEN | COLINFO | HIGH2KEY | REMARKS |
| CCSID | COLNO | LENGTH | SUBTYPE |
| CLABEL | COLTYPE | LOW2KEY | SYSLENGTH |
| CNAME | CREATOR | NULLS | TNAME |
| COLCOUNT | FLDPROC | ORDERFIELD |
|
SYSDBSPACES Contains a row for
each PUBLIC and PRIVATE DBSPACE in the database, including those DBSPACEs that
no user has yet acquired.
| DBSPACENAME | FREEPCT | NPAGES | OWNER |
| DBSPACENO | LOCKMODE | NRHEADER | PCTINDX |
| DBSPACETYPE | NACTIVE | NTABS | POOL |
SYSDROP Contains a list of
objects waiting to be dropped.
| DBSPACENO | QUALF | TABID |
SYSFIELDS Contains a row for
each column that has a field procedure associated with it.
| CNAME | FLDLENGTH | FPNAME | TNAME |
| COLNO | FLDTYPE | FPPARMLIST | |
| CREATOR | FPEXITPARML | FPWORKAREA |
SYSFPARMS Holds the field
procedure value block contents for each field procedure.
| CNAME | FPEXITPARM | SEQNO |
| CREATOR | FPNAME | TNAME |
SYSINDEXES Contains a row for
every index currently in existence, including the indexes that the database
manager maintains on its own catalog tables.
| CLUSTER | FIRSTKEYCOUNT | INDEXTYPE | NLEAF |
| CLUSTERRATIO | FULLKEYCOUNT | IPCTFREE | NLEVELS |
| COLNAMES | ICREATOR | KEYLEN | RELEASE |
| COLNUMBERS | IID | KEYTYPE | TNAME |
| CREATOR | INAME | LOCKMODE |
SYSKEYCOLS Contains a row for
every column in every key.
| CCSID | FLDPROC | KEYTYPE | TCREATOR |
| CNAME | KEYNAME | SYSLENGTH | TIMESTAMP |
| DATACODE | KEYORD | TABLEORD | TNAME |
SYSKEYS Contains a row for
each primary and each foreign key.
| DELETERULE | KEYNAME | REFTNAME | TIMESTAMP |
| INAME | KEYTYPE | STATUS | TNAME |
| KEYCOLS | REFTCREATOR | TCREATOR |
|
SYSLANGUAGE Contains the names
of all national languages currently installed, a unique four-character code
for each language, and a brief description of each language.
| LANGID | LANGKEY | LANGUAGE | REMARKS |
SYSOPTIONS Contains the options and defaults that may be
implemented for this database.
| REMARKS | SQLOPTION | VALUE |
The following named rows describe the
options and defaults that may be implemented for this database:
| CCSIDGRAPHIC | DATE | MCCSIDGRAPHIC |
| CCSIDMIXED | DBCS | MCCSIDMIXED |
| CCSIDSBCS | DEFAULT LANGUAGE | MCCSIDSBCS |
| CHARNAME | LDATELEN | RELEASE |
| CHARSUB | LTIMELEN | TIME |
SYSPARMS Describes the parameters for the stored
procedures defined.
| NAME | AUTHID | PARMNAME | SUBTYPE |
| ROUTINEID | ROWTYPE | ORDINAL | CCSID |
| TYPENAME | DATATYPEID | LENGTH | SCALE |
SYSPSERVERS Defines the stored procedure servers where
stored procedures run and puts them in groups.
| PSERVER | SERVGROUP | AUTOSTART | DESCRIPTION |
SYSPROGAUTH Records privileges
of users to run programs, and to grant these privileges to other users.
| CREATOR | GRANTOR | RUNAUTH |
| GRANTEE | PROGNAME | TIMESTAMP |
SYSROUTINES Specifies the load module or phase name and
package name for a given stored procedure.
| NAME | AUTHID | LOADMOD | ROUTINEID |
| PARMCOUNT | LANGUAGE | PARAMETERSTYLE | STAYRESIDENT |
| PROGRAMTYPE | COMMITONRETURN | RESULTSETS | SERVGROUP |
| DEFSERV | RUNOPTS | REMARKS |
SYSSTRINGS Contains a list of
the valid combinations for source and target CCSID tags when using the remote
unit of work feature.
| ERRORBYTE | OUTCCSID | TRANSPROC | TRANSTAB2 |
| INCCSID | SUBBYTE | TRANSTAB1 | TRANSTYPE |
SYSSYNONYMS Contains a row for
every synonym currently in effect.
| ALTNAME | CREATOR | TNAME | USERID |
SYSTABAUTH Records privileges
owned by users to access tables and views, and privileges on tables and views
exercised by programs.
| ALTERAUTH | GRANTOR | SCREATOR | TIMESTAMP |
| DELETEAUTH | INDEXAUTH | SELECTAUTH | TTNAME |
| GRANTEE | INSERTAUTH | STNAME | UPDATEAUTH |
| GRANTEETYPE | REFAUTH | TCREATOR | UPDATECOLS |
SYSUSAGE Records dependencies
of one database object on another.
| BCREATOR | BTYPE | DNAME | TIMESTAMP |
| BNAME | DCREATOR | DTYPE |
|
SYSUSERAUTH Records special
privileges of DBA, RESOURCE, SCHEDULE or CONNECT authority held by a user or a
special privilege exercised by a program.
| AUTHOR | NAME | RESOURCEAUTH |
| DBAAUTH | PASSWORD | SCHEDULEAUTH |
SYSUSERLIST Records special
privileges for access by users who do not have DBA authority.
| AUTHOR | NAME | SCHEDULEAUTH |
| DBAAUTH | RESOURCEAUTH |
|
SYSVIEWS Contains the
definitions of all views.
| SEQNO | VIEWCHECK | VIEWNAME |
| VCREATOR | VIEWMAT | VIEWTEXT |