Re: [ADSM-L] Select with TSM 6.1
2009-04-25 03:19:34
Good point - here are the details from the two tables:
tsm: VISTA1>select used_db_space_mb*100/free_space_mb from db
Unnamed[1]
------------
0
tsm: VISTA1>select used_space_mb*100/free_space_mb from log
Unnamed[1]
---------------------------------
0.02929783269
tsm: VISTA1>select * from db
Session established with server VISTA1: Windows
Server Version 6, Release 1, Level 0.0
Server date/time: 04/24/2009 23:36:20 Last access: 04/24/2009 12:57:11
DATABASE_NAME: TSMDB1
TOT_FILE_SYSTEM_MB: 300374
USED_DB_SPACE_MB: 448
FREE_SPACE_MB: 83814
PAGE_SIZE:
TOTAL_PAGES: 32772
USABLE_PAGES: 32636
USED_PAGES: 23804
FREE_PAGES: 8832
BUFF_HIT_RATIO: 99.7
TOTAL_BUFF_REQ: 558126
SORT_OVERFLOW: 0
LOCK_ESCALATION: 0
PKG_HIT_RATIO: 94.3
LAST_REORG:
FULL_DEV_CLASS: SATA
NUM_BACKUP_INCR: 0
LAST_BACKUP_DATE: 2009-04-24 14:38:10.000000
PHYSICAL_VOLUMES: 1
tsm: VISTA1>select * from log
TOTAL_SPACE_MB: 8192.00
USED_SPACE_MB: 1.11.
FREE_SPACE_MB: 8158.88
ACTIVE_LOG_DIR: c:\tsminst1\log
MIRROR_LOG_DIR: c:\tsminst1\logmirror
AFAILOVER_LOG_DIR: c:\tsminst1\archlogfailover
ARCH_LOG_DIR: c:\tsminst1\archlog
tsm: VISTA1>
Joerg Pohlmann
250-245-9863
|
|
|