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/