I've run that select statement.. and here it is....
tsm: TIVOLISVR>select a.stgpool_name,a.maxscratch as
MAX,count(b.volume_name) as USED from stgpools a,volumes b where
a.stgpool_name=b.stgpool_name and a.devclass!='DISK' group by
a.stgpool_name,b.stgpool_name,a.maxscratch
STGPOOL_NAME MAX USED
------------------ ----------- -----------
359POOL4 500 68
359POOL5 500 76
359POOL6 500 62
~Norita Hasan~
-----Original Message-----
From: goc [mailto:goran.k AT VIP DOT HR]
Sent: Wednesday, March 09, 2005 4:25 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: space in storage pool
to be absolutely sure run this query :
select a.stgpool_name,a.maxscratch as MAX,count(b.volume_name) as USED from
stgpools a,volumes b -
where a.stgpool_name=b.stgpool_name and a.devclass!='DISK' -
group by a.stgpool_name,b.stgpool_name,a.maxscratch
okay ?
----- Original Message -----
From: "Norita binti Hassan" <ita AT POS.COM DOT MY>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Wednesday, March 09, 2005 8:49 AM
Subject: Re: space in storage pool
> I've set max is 500 and I don't even reach that figure. Any other reason?
>
> ~Norita Hasan~
>
>
> -----Original Message-----
> From: Stef Coene [mailto:stef.coene AT DOCUM DOT ORG]
> Sent: Wednesday, March 09, 2005 3:42 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: space in storage pool
>
> On Wednesday 09 March 2005 04:49, Norita binti Hassan wrote:
>> Hi,
>>
>> I got this message, but when I checked my storage pool,there's a scratch
>> volume that can be use for this backup. Can anybody explain this ?
> Check the number of scratch volumes the storage pool may use. Maybe this
> maximum is reached.
>
>
> Stef
>
>
> Pos Malaysia Berhad is Malaysia's national postal company
> Visit us online at www.pos.com.my
>
> NOTICE
> This message may contain privileged and/or confidential
> information. If you are not the addressee or authorised
> to receive this email, you must not use, copy, disclose
> or take any action based on this email. If you have
> received this email in error, please advise the sender
> immediately by reply e-mail and delete this message.
> Pos Malaysia Berhad takes no responsibility for the
> contents of this email.
>
Pos Malaysia Berhad is Malaysia's national postal company
Visit us online at www.pos.com.my
NOTICE
This message may contain privileged and/or confidential
information. If you are not the addressee or authorised
to receive this email, you must not use, copy, disclose
or take any action based on this email. If you have
received this email in error, please advise the sender
immediately by reply e-mail and delete this message.
Pos Malaysia Berhad takes no responsibility for the
contents of this email.
|