Introduction to most useful SYSIBM DB2 tables - PART 1

Here are most commonly used SYSIBM tables

SYSIBM.SYSTABLES : Any table or view or alias defined for your application will be present in this table with all the information.

Here I have got great links for tables where you can get details for each column of  SYSIBM tables. For each table there is separate link I have put them all together for quick reference.

http://supportline.microfocus.com/Documentation/books/sx51/rhsqst2l.htm

SYSIBM.SYSCOLUMNS: All the details about columns for any table along with characteristics of each column is defined here.

http://supportline.microfocus.com/Documentation/books/sx51/rhsqst0s.htm

SYSIBM.SYSTABLESPACE :  If any table is table space partitioned, then that table will be present here and partition key limits will be available here. 

http://supportline.microfocus.com/Documentation/books/sx50/rhsqst2j.htm

SYSIBM.SYSKEYS : All the information related to primary or unique key is available here for any table in the application.

http://supportline.microfocus.com/Documentation/books/sx50/rhsqst1h.htm

SYSIBM.SYSINDEXES : Gives the index for all the table. Give cluster ratio which can be used to determine usage of primary or secondary indexes on table.

http://supportline.microfocus.com/Documentation/books/sx51/rhsqst15.htm

SYSIBM.SYSINDEXESPART : If any table is index partitioned then that table will be present here.

http://supportline.microfocus.com/Documentation/books/sx50/rhsqst2j.htm