ADSM-L

Re: Tivoli Storage Manager Operational Reporting item

2006-05-03 11:43:44
Subject: Re: Tivoli Storage Manager Operational Reporting item
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 3 May 2006 11:43:09 -0400
The "volume reclamation warning" is issuing this SQL query:

select count(*) as RW from volumes where (status='FULL') AND
(pct_utilized<48)

Don't ask me why they picked 48.

To see this,

In the management console, right click on your Daily Report, select
PROPERTIES.
Click to highlight CUSTOM SUMMARY
Click the SETTINGS button
Scroll down to the VOLUME RECLAMATION WARNING line, click to highlight
it
Click EDIT

That will display the SQL query.  You can change the number from 48 to
something else.
BUT, if you have multiple storage pools, this information doesn't do
much good.
You might want to change the query to include a specific storage pool,
then it will be telling you how many tapes could be reclaimed at that
level.

Wanda Prather
"I/O, I/O, It's all about I/O"  -(me)


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Timothy Hughes
Sent: Wednesday, May 03, 2006 9:43 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Tivoli Storage Manager Operational Reporting item


Hello,


Does anyone who is using Tivoli Storage Manager Operational Reporting
know what the Item >> Volume Reclamation warning # <<< means in the
Custom Summary selection means? I think it's reporting the # of
tape volumes that are reclaimable is that correct?


Thanks for any help in advance!