DB2 check table definition

1. Get all your table list

db2 => SELECT DISTINCT NAME FROM SYSIBM.SYSTABLES WHERE CREATOR = CURRENT SCHEMA
or
db2 => SELECT DISTINCT NAME FROM SYSIBM.SYSTABLES WHERE CREATOR = CURRENT_SCHEMA
or specific user
db2 => SELECT DISTINCT NAME FROM SYSIBM.SYSTABLES WHERE CREATOR = '<USER>'

2. Query table definition

db2 => describe select * from <TABLENAME>

 Column Information

 Number of columns: <N>

 SQL type              Type length  Column name                     Name length
 --------------------  -----------  ------------------------------  -----------
 484   DECIMAL                4, 0  <COL1NAME>                                8
 453   CHARACTER                 4  <COL2NAME>                                8