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.