How to find table and column in DB2 with tbspaceid tableid specified in error message How to find table and column in DB2 with tbspaceid tableid specified in error message database database

How to find table and column in DB2 with tbspaceid tableid specified in error message


Apparently at the package level, DB2 only works with the IDs and not the names.

You can find them back using the following query:

SELECT C.TABSCHEMA, C.TABNAME, C.COLNAMEFROM SYSCAT.TABLES AS T,SYSCAT.COLUMNS AS CWHERE T.TBSPACEID = 2AND T.TABLEID = 19AND C.COLNO = 0AND C.TABSCHEMA = T.TABSCHEMAAND C.TABNAME = T.TABNAME