Hi Grigori,

Got it, and I will learn your script, many thanks!

Regards,
william

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Grigori Solonovitch
Sent: Monday, May 24, 2010 7:32 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Can tsm send report to notify that archived data will be 
expired?

Hello William,



If you are still interesting in script:



1) create script:



define script List_Expired_Archives description="<Node> <days> List of expired 
archives for node"

update script List_Expired_Archives \

"select a.filespace_name as File_System, a.hl_name as Directory_Name, a.ll_name 
as File_Name \

 from archives a, ar_copygroups b \

  where a.class_name = b.class_name \

    and b.set_name = 'ACTIVE' \

    and a.node_name = upper('\$1') \

    and cast((current_timestamp-a.archive_date)days as decimal)+$2 = 
cast(b.retver as decimal)"



2) run script by:



run List_Expired_Archives <Node Name> <number of days from current day>



For example:



run List_Expired_Archives LPAR01 2



to see files from node LPAR01, which will expire after tomorrow.



You have to be ready for long time queries or do not try to do them at all.



Kindest regards,



Grigori G. Solonovitch



Senior Technical Architect



Information Technology  Ahli United Bank Kuwait http://www.ahliunited.com.kw



Phone: (+965) 2231-2274  Mobile: (+965) 99798073  E-Mail: Grigori.Solonovitch 
AT ahliunited DOT com



Please consider the environment before printing this Email





-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
William ZHANG
Sent: Monday, May 24, 2010 12:14 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Can tsm send report to notify that archived data will be 
expired?



Hi,

So, can just report special archived data?  Use SQL query?



thanks





-----Original Message-----

From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Grigori Solonovitch

Sent: Monday, May 24, 2010 4:56 PM

To: ADSM-L AT VM.MARIST DOT EDU

Subject: Re: [ADSM-L] Can tsm send report to notify that archived data will be 
expired?



> Can  TSM  send report to administrator notice that data will be expired at 
> point time?



>If ok, how to do this?







I think it is possible to build queris against table BACKUPS (columns 
DEACTIVATE_DATE and CLASS_NAME), which will provide required information for 
specific node or file space. At the same time, queries to this big table can 
create serious performance problem on TSM server, especially if you need global 
list of files, which will expire on a given date.







Grigori G. Solonovitch







Senior Technical Architect







Information Technology  Ahli United Bank Kuwait http://www.ahliunited.com.kw







Phone: (+965) 2231-2274  Mobile: (+965) 99798073  E-Mail: Grigori.Solonovitch 
AT ahliunited DOT com







Please consider the environment before printing this Email







________________________________

CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.



Please consider the environment before printing this Email.

________________________________
CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.