Thanks.
The number of objects that have expired is really what I'm looking for and it
sounds like this will do it. I don't necessarily need the number of bytes.
Thanks
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT vm.marist DOT edu] On Behalf Of
Huebschman, George J.
Sent: Thursday, February 25, 2010 5:30 PM
To: ADSM-L AT vm.marist DOT edu
Subject: [ADSM-L] FW: [ADSM-L] FW: [ADSM-L] Question on Expiration
Eric,
I believe that Remco is correct.
The only way I see to do this is by doing a before/after query of
occupancy:
select * from occupancy where node_name='XYZCLIENT'
But as Remco says, what is the value of knowing the bytes? They space
is on the TSM server; Q DB to find out how utilzed your DB is and do it daily
to find the rate of change.
Geo H.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Remco Post
Sent: Thursday, February 25, 2010 5:17 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] FW: [ADSM-L] Question on Expiration
expiration only deals in objects, reclamation deals in objects and bytes. I
don't believe there is any way for you to find out. I fail to see why this is
operationally important.
On 25 feb 2010, at 23:07, Huebschman, George J. wrote:
> Eric,
> That only shows and object count, not bytes.
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Huebschman, George J.
> Sent: Thursday, February 25, 2010 5:05 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Question on Expiration
>
> Eric,
> Try this:
>
> select nodename, substr (message, 1,9) as MESSAGE, cast(substr
> (message, 44,10)as char (20)) as ObjExpired from actlog where
> msgno=4970 and
> date(date_time)>date(current_timestamp)-1 day
>
> IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason
> therefore recommends that you do not send any confidential or
sensitive information to us via electronic mail, including social security
numbers, account numbers, or personal identification numbers.
Delivery, and or timely delivery of Internet mail is not guaranteed.
Legg Mason therefore recommends that you do not send time sensitive or
action-oriented messages to us via electronic mail.
>
> This message is intended for the addressee only and may contain
privileged or confidential information. Unless you are the intended recipient,
you may not use, copy or disclose to anyone any information contained in this
message. If you have received this message in error, please notify the author
by replying to this message and then kindly delete the message. Thank you.
--
Met vriendelijke groeten/Kind Regards,
Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622
IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason
therefore recommends that you do not send any confidential or sensitive
information to us via electronic mail, including social security numbers,
account numbers, or personal identification numbers. Delivery, and or timely
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends
that you do not send time sensitive or action-oriented messages to us via
electronic mail.
This message is intended for the addressee only and may contain privileged or
confidential information. Unless you are the intended recipient, you may not
use, copy or disclose to anyone any information contained in this message. If
you have received this message in error, please notify the author by replying
to this message and then kindly delete the message. Thank you.
|