How do I find out the details of a DB2 table?

Either run

# db2 describe table

Or

Select distinct(name), ColType, Length from Sysibm.syscolumns where tbname = 'table_name';

 

Hits: 271