How do you list DB2 tables?

To list tables run the following commands:

db2

connect to <database>

list tables for schema <schema name>

e.g.

[ db2inst1@tbsmdataserv1 ~]$ db2

db2 => connect to TBSMHIST

Database Connection Information

Database server        = DB2/LINUXX8664 9.7.0
SQL authorization ID   = DB2INST1
Local database alias   = TBSMHIST

db2 => list tables for schema TBSMHISTORY

Table/View                      Schema          Type  Creation time            
——————————- ————— —– ————————–
BASELINE_METRIC_VALUE           TBSMHISTORY     T     2011-06-29-11.16.23.554116
BASELINE_VIEW_RESOURCE_METRIC_> TBSMHISTORY     V     2011-06-29-11.16.24.008677
HISTORY_METRIC_GROUPS           TBSMHISTORY     T     2011-06-29-11.16.22.539959
HISTORY_METRIC_META             TBSMHISTORY     T     2011-06-29-11.16.22.249835
HISTORY_METRIC_ROLES            TBSMHISTORY     T     2011-06-29-11.16.22.657418
HISTORY_METRIC_VALUE            TBSMHISTORY     T     2011-06-29-11.16.23.052770
HISTORY_RESOURCE                TBSMHISTORY     T     2011-06-29-11.16.23.143899
HISTORY_RESOURCE_NAME           TBSMHISTORY     T     2011-06-29-11.16.22.762052
HISTORY_VIEW_GROUPS_METRIC_MET> TBSMHISTORY     V     2011-06-29-11.16.23.673600
HISTORY_VIEW_RESOURCE           TBSMHISTORY     V     2011-06-29-11.16.23.737232
HISTORY_VIEW_RESOURCE_METRIC_M> TBSMHISTORY     V     2011-06-29-11.16.23.766597
HISTORY_VIEW_RESOURCE_METRIC_R> TBSMHISTORY     V     2011-06-29-11.16.23.807009
HISTORY_VIEW_RESOURCE_METRIC_V> TBSMHISTORY     V     2011-06-29-11.16.23.823570
HISTORY_VIEW_ROLES_METRIC_META  TBSMHISTORY     V     2011-06-29-11.16.23.872066
PERIODIC_METRIC_VALUE           TBSMHISTORY     T     2011-06-29-11.16.23.429919
PERIODIC_VIEW_RESOURCE_METRIC_> TBSMHISTORY     V     2011-06-29-11.16.23.903420
PERIODIC_VIEW_RESOURCE_METRIC_> TBSMHISTORY     V     2011-06-29-11.16.23.936359
PERIODIC_VIEW_VALUE_FOR_BASELI> TBSMHISTORY     V     2011-06-29-11.16.23.950819

18 record(s) selected.

db2 =>

Visits: 30059