Month: February 2017

I’m not creating a special “DB2” category for this post 🙂

I’ve been looking for metadata, or some kind of data dictionary similar to those available in MS SQL Server or Oracle DB, to describe the tables and columns in a schema in DB2.

The closest match so far seems to be information in the SYSIBM library:

• https://www.waveform.org.uk/~dave/sample/plain/schema_SYSIBM.html

Specifically:

• SQLCOLUMNS
• SQLTABLES

Reference:

• https://chartio.com/resources/tutorials/how-to-view-the-definition-of-a-table-in-ibm-db2/