Hi Andrew,
thanks a lot - all of your examples helps a lot !
What I am really trying to find out is the time/date when I can delete
some obsolete archive-copygroups like
Policy Domain Name: U12345
Policy Set Name: STANDARD
Mgmt Class Name: ARCHIVE_10Y
Copy Group Name: STANDARD
Copy Group Type: Archive
Retain Version: 3,653
Retention Initiation: Creation
Retain Minimum Days:
Copy Serialization: Static
Copy Frequency: CMD
Copy Mode: Absolute
Copy Destination: NONE
Last Update by (administrator): MANAG_W
Last Update Date/Time: 03/16/05 12:49:15
Managing profile:
It is just for 'cleanup' - not now but someday.
At the same time some other archive classes are still used to archive data
and therefore must stay untouched.
( Unfortunately those obsolete archive-classes have the data inside
one tape storagepool mixed with still usable ones - so I can not determine
those obsolete archive-class just by the occupancy... )
Maybe it will take some years when files that are bound to those 'old' classes
will
leave through the expiration-process.
My solution is to simply check from time to time if there ar still files bound
to a specific (obsolete) archive-class - and if no files are bound ( by any
node in that domain) then I can delete it.
Really great would be the following:
Is it possible to get the date/time when the 'last'
file will expire in a given (archive)class-name and a given
domain-name/or-nodename ?
Greetings
Rainer
Andrew Raibeck wrote:
>
> Hi Rainer,
>
> What is it you are *really* trying to find out? Depending on the size of
> your database, mining the ARCHIVES table can be a slow process when maybe
> you don't quite need that level of detail?
>
> You can find out who has any archived data by querying the occupancy
> table:
>
>query occupancy type=archive
>
> That will show you which nodes have any archived data, and how many
> objects they have.
>
> If you still want to mine the ARCHIVES table, then perhaps it would be
> best for you to run one SELECT against the entire table, store the results
> in a file, then use some other utiity to mine that data:
>
>dsmadmc -id=you -pa=xx -comma select * from archives > archives.out
>
> With that said...
>
> If you want to find out how many objects a given node has archived, you
> can do something like this:
>
>select node_name, class_name, count(*) \
> from archives \
> group by node_name, class_name
>
> If you want to know what specific object by node name:
>
>select filespace_name || hl_name || ll_name \
> as "FILE NAME" \
> from archives \
> where node_name='YOURNODE' and class_name='YOURCLASS'
>
> Depending on your specific needs, you can create variations of these.
>
> For your other question, the BACKRETENTION and ARCHRETENTION settings for
> the policy domain might be useful.
>
> Regards,
>
> Andy
>
> Andy Raibeck
> IBM Software Group
> Tivoli Storage Manager Client Development
> Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED]
> Internet e-mail: [EMAIL PROTECTED]
>
> The only dumb question is the one that goes unasked.
> The command line is your friend.
> "Good enough" is the enemy of excellence.
>
> "ADSM: Dist Stor Manager" wrote on 2005-03-15
> 06:25:40:
>
> > Hello,
> > we have discontinued a way to archive data on some special hardware
> > and the archive-copygrous are now modified with a 'copy
> destination'named NONE
> > that points to nothing and will give an error message if someone is
> > using that.
> > One question is : can someone help me with a select command that shows
> > those files or just the number of files that are bound to an
> > archive management class in a
> > policy domain and is stored by a node ?
> > Alternatively a select that shows those files or just the number of
> > files that are
> > bound to an archive management class in a policy domain and is
> > stored in a given storagepool ?
> > I need that because some day those obsolete archive copygroups
> > should be deleted
> > -the archive data is not unlimited by time- if not needed anymore.
> >
> > My other question is: is there a way to make management classes kind of
> > unseen to the client if those archive managementclasses / archive
> copygroups
> > are not usable anymore and just defined at the server for not to
> > lose the data ?
> >
> > ... or is there something else what can be done ?
> >
> > Greetings and Thanks a lot in advance !
> > Rainer
> >
> > --
> >
> --
> > Rainer Wolf Mail:
> [EMAIL PROTECTED]
> > Kommunikations und Informationszentrum Tel/Fax: ++49 731
> 50-22482/22471
> > Abt. Infrastruktur, Uni Ulm