9:08:28 AM TSMTEST : 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,780
Pct Util: 0.1
Max. Pct Util: 0.1
Physical Volumes: 6
Buffer Pool Pages: 131,072
Total Buffer Requests: 69,643
Cache Hit Pct.: 80.90
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 0.38
Percentage Changed: 0.62
Last Complete Backup Date/Time: 12/02/2008 13:54:50
Estimate of Recoverable Space (MB): 0
Last Estimate of Recoverable Space (MB): 12/02/2008 12:41:54
"Conway, Timothy" <Timothy.Conway AT JBSSA DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
12/02/2008 05:43 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?
How about a q db f=d now that the estimate dbreorgstats is finished?
The "q dbv f=d" doesn't really give anything that's affected by the
estimate.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Remco Post
Sent: Tuesday, December 02, 2008 3:04 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Where is the missing 38GB?
Ok, this is an almost empty database with a lot of fragmentation.
I'd say, from what I read in the thread, that an unload/load at this
point will remove a lot of fragmentation, even though the estimate says
nill.
The other option is to run an export server, reformat everything, and
then import server. You'll probably want to save your devconf.txt so you
can easily recreate the stgpools, devclasses and server2server comms you
might have.
On Dec 2, 2008, at 18:20 , 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:
>
> 12:15:11 PM TSMTEST : q stg
>
> Storage Device Estimated Pct Pct High Low Next
> Stora-
> Pool Name Class Name Capacity Util Migr Mig Mig ge Pool
> Pct Pct
> ----------- ---------- ---------- ----- ----- ---- ---
> -----------
> ARCHIVEPOOL DISK 0.0 M 0.0 0.0 90 30
> BACKUPPOOL DISK 123 G 0.0 0.0 90 30
> COPYPOOL-I- IBM3583-1 0.0 M 0.0
> BM3583-1
> COPYPOOL-I- IBM3583-2 0.0 M 0.0
> BM3583-2
> IBM3494-35- 3592E05 0.0 M 0.0 0.0 90 70
> 92
>
> 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".
--
Met vriendelijke groeten,
Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622
|
