Useful List of SYSIBM tables

SYSCHECKDEP
Column references for CHECK constraints

SYSCHECKS
CHECK constraint specifications

SYSCHECKS2 (V7)
Information about CHECK constraints on DB2 Catalog tables created for V7 or later

SYSCOLAUTH
The UPDATE privileges held by DB2 users on table or view columns

SYSCOLDIST
Cardinality, frequent value, and non-padded frequent value distribution statistics for the first key column of an index key

SYSCOLDIST_HIST (V7)
Column distribution statistics history

SYSCOLSTATS
The partition statistics for selected columns

SYSCOLUMNS
Information about every column of every DB2 table and view

SYSCOLUMNS_HIST (V7)
Historical column statistics

SYSCONSTDEP
Information regarding columns that are dependent on CHECK constraints and user-defined defaults

SYSDATABASE
Information about every DB2 database

SYSDATATYPES
Information about the user-defined distinct types defined to the DB2 subsystem

SYSDBAUTH
Database privileges held by DB2 users

SYSDBRM
DBRM information only for DBRMs bound into DB2 plans

SYSDUMMY1
Contains no information; this table is for use in SQL statements requiring a table reference without regard to data content

SYSFIELDS
Information on field procedures implemented for DB2 tables

SYSFOREIGNKEYS
Information about all columns participating in foreign keys

SYSINDEXES
Information about every DB2 index

SYSINDEXES_HIST (V7)
Historical index statistics

SYSINDEXPART
Information about the physical structure and storage of every DB2 index

SYSINDEXPART_HIST (V7)
Historical index partition statistics

SYSINDEXSTATS
Partitioned index statistics by partition

SYSINDEXSTATS_HIST (V7)
Historical partitioned index statistics by partition

SYSKEYCOLUSE (V7)
Columns that participate in unique constraints (primary key or unique key) from the SYSTABCONST table

SYSKEYS
Information about every column of every DB2 index

SYSPACKAGE
Information about every package known to DB2

SYSPACKAUTH
Package privileges held by DB2 users

SYSPACKDEP
A cross-reference of DB2 objects required for DB2 packages

SYSPACKLIST
The package list for plans bound specifying packages

SYSPACKSTMT
All SQL statements contained in each DB2 package

SYSPARMS
Parameters for defined routines

SYSPROCEDURES
The stored procedures available to the DB2 subsystem

SYSRELS
The referential integrity information for every relationship defined to DB2

SYSRESAUTH
Resource privileges held by DB2 users

SYSROUTINEAUTH
Privileges held by DB2 users on routines

SYSROUTINES
Information about every routine (that is, user-defined functions and stored procedures) defined to the DB2 subsystem

SYSSCHEMAAUTH
Schema privileges granted to users

SYSSEQUENCEAUTH (V8)
Privileges held by DB2 users on SEQUENCE objects

SYSSEQUENCES (V7)
Information about identity columns and SEQUENCE objects

SYSSEQUENCESDEP (V8)
Records the dependencies of identity columns on tables

SYSSTMT
All SQL statements contained in each DB2 plan bound from a DBRM

SYSSYNONYMS
Information about every DB2 synonym

SYSTABAUTH
Table privileges held by DB2 users

SYSTABCONST (V7)
Information about every unique constraint (primary key or unique key) created in DB2 V7 or later

SYSTABLEPART
Information about the physical structure and storage of every DB2 table space

SYSTABLEPART_HIST (V7)
Historical table space partition statistics

SYSTABLES
Information about every DB2 table

SYSTABLES_HIST (V7)
Table statistics history

SYSTABLESPACE
Information about every DB2 table space

SYSTABSTATS
Partitioned table space statistics by partition

SYSTABSTATS_HIST (V7)
Historical partitioned table space statistics by partition

SYSTRIGGERS
Information about every trigger defined to the DB2 subsystem

SYSUSERAUTH
System privileges held by DB2 users

SYSVIEWS
Information about every DB2 views