Hey Folks...
Can anyone tell me where there might be documentation on what tables comprise the catalog and what the columns are within the tables? Thanks in advance...
Mike D.

IBM DB2 9.7 for Linux, UNIX, and Windows
SQL Reference, Volume 1

Appendix D. System catalog views

Thank you!

Hi Cowzz,

Have u asked about the remote db catalog information? If u need to have those details, u couldn't get it within the database. You can get those details using db2cfexp utility.

Eg:
db2cfexp c:\filename.txt (on windows)
db2cfexp /home/db2inst1/filename.txt (on windows)
Execute the cmd based on ur environment & it'll be produced a file along with the catalog info.
If u need to have the column names of the table, u can get them in the syscat.columns table.
By

KK