DB2 useful SQL and commands

-- columns of a table
SELECT NAME, COLTYPE, LENGTH, SCALE, NULLS, COLNO
  FROM SYSIBM.SYSCOLUMNS WHERE TBNAME='ACCOUNT' ORDER BY COLNO;

-- which packages depend on a table
SELECT DISTINCT DCOLLID, DNAME FROM SYSIBM.SYSPACKDEP
 WHERE BNAME='ACCOUNT';

-- indexes and their columns
SELECT I.NAME, K.COLNAME, K.COLSEQ, K.ORDERING
  FROM SYSIBM.SYSINDEXES I, SYSIBM.SYSKEYS K
 WHERE I.NAME=K.IXNAME AND I.TBNAME='ACCOUNT'
 ORDER BY I.NAME, K.COLSEQ;

-- when were statistics last gathered?
SELECT NAME, STATSTIME, CARDF FROM SYSIBM.SYSTABLES
 WHERE NAME='ACCOUNT';