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.