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 <jdbach AT WAL-MART DOT COM> on 27.09.2001 20:48:47
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
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:rbs AT BU DOT EDU]
        Sent:   Thursday, September 06, 2001 10:16 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        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.
**********************************************************************