Database and recovery log info

List all information from db table

tsm: SERVER1> SELECT * FROM db

AVAIL_SPACE_MB: 85000

CAPACITY_MB: 80000

MAX_EXTENSION_MB: 5000

MAX_REDUCTION_MB: 11808

PAGE_SIZE: 4096

USABLE_PAGES: 20480000

USED_PAGES: 16856530

PCT_UTILIZED: 82.3

MAX_PCT_UTILIZED: 85.2

PHYSICAL_VOLUMES: 17

BUFF_POOL_PAGES: 65536

TOTAL_BUFFER_REQ: 5555310

CACHE_HIT_PCT: 98.6

CACHE_WAIT_PCT: 0.0

BACKUP_RUNNING: NO

BACKUP_TYPE:

NUM_BACKUP_INCR: 0

BACKUP_CHG_MB:

BACKUP_CHG_PCT: 14.5

LAST_BACKUP_DATE: 2007-07-22 16:11:23.000000

DB_REORG_EST:

DB_REORG_EST_TIME:

TSM database utilization (%)

tsm: SERVER1> SELECT pct_utilized FROM db

PCT_UTILIZED

------------

82.3

TSM log recovery utilization (%)

tsm: SERVER1> SELECT pct_utilized FROM log

PCT_UTILIZED

------------

0.0

Selecting specific columns from db table

tsm: SERVER1> SELECT avail_space_mb,capacity_mb, pct_utilized, max_pct_utilized,last_backup_date FROM db

AVAIL_SPACE_MB CAPACITY_MB PCT_UTILIZED MAX_PCT_UTILIZED LAST_BACKUP_DATE

-------------- ----------- ------------ ---------------- ------------------

85000 80000 82.3 85.2 2007-07-22

16:11:23.000000

Number of database volumes not synchronized

tsm: SERVER1> SELECT COUNT(*) FROM dbvolumes WHERE ( NOT copy1_status='Synchronized' OR NOT -

copy2_status='Synchronized' OR NOT copy3_status='Synchronized' )

Unnamed[1]

-----------

0

Number of log volumes not synchronized

tsm: SERVER1> SELECT COUNT(*) FROM logvolumes WHERE ( NOT copy1_status='Synchronized' OR NOT -

copy2_status='Synchronized' OR NOT copy3_status='Synchronized' )

Unnamed[1]

-----------

0