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 =>

Twitter Feed

OrbData Is your company ready for #GDPR? https://t.co/fGybdNrlCh
4hreplyretweetfavorite
OrbData Setting up Windows PowerShell discoveries with #IBM #TADDM https://t.co/pxMZ2eVPpo

Address

Address:
100 Longwater Avenue, Green Park, Reading, RG2 6GP, U.K.
Tel:
+44 (0) 118 945 0130
E-Mail:
This email address is being protected from spambots. You need JavaScript enabled to view it.

markerFind on Google Maps

About Us

Orb Data brings together People, Process and Technology to deliver the cornerstone of business success: the management of IT infrastructure. At our heart are our people. We have unrivalled experience, helping us to achieve an enviable reputation for excellence in project delivery. Because we’re independent, we identify actual issues and help organisations resolve them –from spec to deployment, and beyond –providing the right solution in terms of best of breed technology and support. We offer a refreshingly simple approach to the way we conduct business. We take pride in our abilities to provide first class solutions to business problems, and to conduct working relationships with honesty and integrity.

Follow Us On:

JoomShaper