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