• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Report of the space usage of all storage pool volumes - TSM Server 6.3

girreis

ADSM.ORG Member
#1
The following query will produce a report of the space usage of all storage pool volumes, summarised by storage pool and status.

SELECT STGPOOL_NAME AS STGPOOL, COUNT(VOLUME_name) AS COUNT, STATUS, CAST(MEAN(EST_CAPACITY_MB/1024) AS DECIMAL(5,2)) AS GB_PER_VOL FROM VOLUMES GROUP BY STGPOOL_NAME,STATUS

But displays error in the "MEAN" on TSM Server 6.3 does not recognize, how to fix the above script?

Grateful for the attention,
Ramon
 

Hema

ADSM.ORG Senior Member
#2
anyone got a reply for this? I have the same issue while trying to find out 'the maximum utilization of a full tape'. Please help. Thank you
 

marclant

ADSM.ORG Moderator
#5
And from what I've seen, the 'MEAN' command is no longer available since TSM switched to DB2.
You can use the AVG( ) function instead of the MEAN( ) function. Example:
Code:
select avg(bytes) from summary where activity='BACKUP'
anyone got a reply for this? I have the same issue while trying to find out 'the maximum utilization of a full tape'. Please help. Thank you
That doesn't sound like a use for mean/average. You'll have to expand on what you are looking for. Are you looking for a list of tapes with utilization or the name of the tape that has the most utilization? Or something else?
 

Hema

ADSM.ORG Senior Member
#6
You can use the AVG( ) function instead of the MEAN( ) function. Example:
Code:
select avg(bytes) from summary where activity='BACKUP'

That doesn't sound like a use for mean/average. You'll have to expand on what you are looking for. Are you looking for a list of tapes with utilization or the name of the tape that has the most utilization? Or something else?

I have the answer found from the same forum

Check the max utilization of a Full Volume
---------------------------------------------------
select STGPOOL_NAME, CAST(AVG(EST_CAPACITY_MB/1024/1024) AS DECIMAL(8,2)) as TB_PER_FULL_VOL from VOLUMES WHERE STATUS='FULL' GROUP BY STGPOOL_NAME
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 14 17.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 50 62.5%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 11.3%
  • Other (please comement)

    Votes: 7 8.8%

Forum statistics

Threads
31,378
Messages
133,647
Members
21,492
Latest member
CamoVan
Top