ADSM-L

Re: [ADSM-L] Select with TSM 6.1

2009-04-25 03:19:34
Subject: Re: [ADSM-L] Select with TSM 6.1
From: Joerg Pohlmann <jpohlman AT CA.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 24 Apr 2009 23:39:17 -0700
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

<Prev in Thread] Current Thread [Next in Thread>