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 =>
Hits: 23041