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:

Specifically:

  • SQLCOLUMNS
  • SQLTABLES

Reference: