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:[email protected]] On Behalf Of Huebschman, George J. Sent: Thursday, February 25, 2010 5:30 PM To: [email protected] 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:[email protected]] On Behalf Of Remco Post Sent: Thursday, February 25, 2010 5:17 PM To: [email protected] 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:[email protected]] On Behalf > Of Huebschman, George J. > Sent: Thursday, February 25, 2010 5:05 PM > To: [email protected] > 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 [email protected] +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.
