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.
|