This would give you list of file ordered by expiration date. So you can see
which file "wants" to go away. Of course this returns huge output and for
real work some groupping has to be done (for example on
node_name,description). However be aware that when files are going to
different mgmtclasses through inclexcl list the classes might have
different archive retensions and you will have to use
min(ar_copygroups.retver).
select archives.node_name, archives.filespace_name, -
archives.hl_name, archives.ll_name, mgmtclasses.class_name, -
max(archives.archive_date) as "Archived", -
max(archives.archive_date + -
cast(ar_copygroups.retver as interval day) ) as "Expires"-
from archives, nodes, domains, mgmtclasses, ar_copygroups -
where ar_copygroups.domain_name=mgmtclasses.domain_name -
and ar_copygroups.set_name=mgmtclasses.set_name -
and ar_copygroups.class_name=mgmtclasses.class_name -
and ar_copygroups.copygroup_name='STANDARD' -
and mgmtclasses.domain_name=domains.domain_name -
and mgmtclasses.set_name='ACTIVE' -
and mgmtclasses.class_name = case archives.class_name when 'DEFAULT' -
then (select domains.defmgmtclass from nodes,domains -
where nodes.node_name=archives.node_name -
and nodes.domain_name=domains.domain_name) -
else archives.class_name end -
and nodes.domain_name=domains.domain_name -
and archives.node_name=nodes.node_name -
group by archives.node_name, archives.filespace_name, archives.hl_name, -
archives.ll_name, mgmtclasses.class_name -
order by 7,6
Zlatko Krastev
IT Consultant
Jeff Bach <[EMAIL PROTECTED]> on 27.09.2001 20:48:47
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: Archival with different retentions?
What is a verification process that can be used to make sure archived files
are not going away?
How many times are directories archived?
The information contained in the emails is outstanding. What else is going
to "bite us"?
Jeff Bach
Home Office Open Systems Engineering
Wal-Mart Stores, Inc.
WAL-MART CONFIDENTIAL
-----Original Message-----
From: Richard Sims [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, September 06, 2001 10:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Archival with different retentions?
>This sounds like a good solution. I was under the belief that
when
I did
>something like this that the archival process would start
rebinding
>previously archivals and therefore change the retention. But I
guess that
>is not true.
Matt - From my notes at http://people.bu.edu/rbs/ADSM.QuickFacts :
Archived files, rebinding does not From the TSM Admin. manual,
chapter on
occur Implementing Policies for
Client Data,
topic How Files and
Directories Are
Associated with a
Management
Class:
"Archive copies are never
rebound
because each archive
operation creates
a different archive copy.
Archive copies
remain bound to the
management class
name specified when the
user
archived
them." (Reiterated in the
client B/A
manual, under "Binding and
Rebinding
Management Classes to
Files".)
Beware, however, that
changing the
retention setting of a
management
class's archive copy group
will cause
all archive versions bound
to that
management class to conform
to the new
retention.
Note that you can use an
ARCHmc to
specify an alternate
management class
for the archive operation.
Richard Sims, BU
**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed. If you have received this email
in error destroy it immediately.
**********************************************************************
