12/2/2008 12:41:46 PM ANR0984I Process 1 for ESTIMATE DBREORG started in
the BACKGROUND at 12:41:46 PM.
12/2/2008 12:41:46 PM ANR1782W ESTIMATE DBREORG process 1 started - server
performance may be degraded while this process is running.
12/2/2008 12:41:46 PM ANR0405I Session 78 ended for administrator ZFORRAY
(WinNT).
12/2/2008 12:41:53 PM ANR1784I A database reorganization would reduce the
database utilization by an estimated 0 MB.
12/2/2008 12:41:53 PM ANR0987I Process 1 for ESTIMATE DBREORG running in
the BACKGROUND processed 1344 items with a completion state of SUCCESS at
12:41:54 PM.
12/2/2008 12:41:53 PM ANR0381I Buffer pool statistics were successfully
reset.

12:42:33 PM   TSMTEST : q dbvol f=d

Volume Name (Copy 1): /opt/tivoli/tsm/server/bin/db.dsm
         Copy Status: Sync'd
Volume Name (Copy 2):
         Copy Status: Undefined
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 16
Allocated Space (MB): 16
     Free Space (MB): 0

Volume Name (Copy 1): /tsmpool/db/db2.dsm
         Copy Status: Sync'd
Volume Name (Copy 2):
         Copy Status: Undefined
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 10,240
Allocated Space (MB): 10,240
     Free Space (MB): 0

Volume Name (Copy 1): /tsmpool/db/db1.dsm
         Copy Status: Sync'd
Volume Name (Copy 2):
         Copy Status: Undefined
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 10,240
Allocated Space (MB): 10,240
     Free Space (MB): 0

Volume Name (Copy 1): /home/tsmdb/db3.dsm
         Copy Status: Sync'd
Volume Name (Copy 2):
         Copy Status: Undefined
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 5,120
Allocated Space (MB): 5,120
     Free Space (MB): 0

Volume Name (Copy 1): /tsmpool/db/db4.dsm
         Copy Status: Sync'd
Volume Name (Copy 2):
         Copy Status: Undefined
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 10,240
Allocated Space (MB): 10,240
     Free Space (MB): 0

Volume Name (Copy 1): /tsmpool/db/db5.dsm
         Copy Status: Sync'd
Volume Name (Copy 2):
         Copy Status: Undefined
Volume Name (Copy 3):
         Copy Status: Undefined
Available Space (MB): 20,480
Allocated Space (MB): 17,408
     Free Space (MB): 3,072



km <km AT GROGG DOT ORG>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
12/02/2008 12:40 PM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: [ADSM-L] Where is the missing 38GB?






On 02/12, Zoltan Forray/AC/VCU wrote:
> I have a test TSM server (5.5.1) which is producing some strange DB
> statistics.
>
> **************************************************
> *** ---> Q DB F=D
> **************************************************
>
>
>                    Available Space (MB): 56,336
>                  Assigned Capacity (MB): 53,264
>                  Maximum Extension (MB): 3,072
>                  Maximum Reduction (MB): 14,360
>                       Page Size (bytes): 4,096
>                      Total Usable Pages: 13,635,584
>                              Used Pages: 15,676
>                                Pct Util: 0.1
>                           Max. Pct Util: 0.1
>                        Physical Volumes: 6
>                       Buffer Pool Pages: 131,072
>                   Total Buffer Requests: 249
>                          Cache Hit Pct.: 100.00
>                         Cache Wait Pct.: 0.00
>                     Backup in Progress?: No
>              Type of Backup In Progress:
>            Incrementals Since Last Full: 4
>          Changed Since Last Backup (MB): 211.15
>                      Percentage Changed: 344.82
>          Last Complete Backup Date/Time: 08/20/2008 09:49:38
>      Estimate of Recoverable Space (MB):
> Last Estimate of Recoverable Space (MB):
>
>
> With an assigned capacity of 52GB yet only 0.1% utilized (52MB?), it
says
> I can only reduce the DB by 13GB ????
>
> So, where is the remaining 38GB of DB usage ?
>
> There are 5-Disk STG volumes (empty/0% utilized), 2-Nodes with NO
> filespaces, defined.  "Q STG" shows:
>
...
> I did a "DSMSERV AUDITDB FIX=YES"  and the only thing it complained (and
> fixed) about was old schedules for non-existing nodes.  Also did an
> "EXPIRE INVENTORY".

The DB is probably fragmented. Try:

 ESTIMATE DBREORGSTATS
 Q DBVOL F=D