Re: How can I tell when an archive was performed?

Try looking at the SUMMARY and/or ARCHIVES table in the database:

   select * from summary where activity='ARCHIVE'

You can also look at the ARCHIVES table, maybe something like this:

   set sqldisplaymode wide
   select date(archive_date) as DATE, time(archive_date) as TIME,
          filespace_name || hl_name || ll_name as "FILE NAME"
          from archives

If you are interested strictly in the date(s), then you could do something
like this:

   select distinct archive_date from archives order by archive_date

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Michael Moore <Michael_Moore AT VFC DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/19/2002 11:36
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: How can I tell when an archive was performed?



Unfortunately, I don't have access to the clients.  So, I am trying to get
this information via the server.

Michael Moore
VF Services Inc.
121 Smith Street
Greensboro,  NC  27420-1488

Voice: 336-332-4423
Fax: 336-332-4544




                      "Mr. Lindsay
                      Morris"                  To: ADSM-L AT VM.MARIST DOT EDU
                      <lmorris@SERVERGR        cc:
                      APH.COM>                 Subject:  Re: How can I
tell when an archive was performed?
                      Sent by: "ADSM:
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      09/19/02 02:04 PM
                      Please respond to
                      lmorris






If you have the accounting log (...server/bin/dsmaccnt.log) reaching that
far back (and it does not prune itself automatically, so you probably do,
if
you have accounting turned on at all),
then you can awk your way through that looking for the KB-archived field
being non-zero.

Or maybe, from the client, you could just say "q arch..."?

---------------------------------
Mr. Lindsay Morris
Lead Architect, Servergraph
859-253-8000 ofc
425-988-8478 fax


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Michael Moore
> Sent: Thursday, September 19, 2002 1:06 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: How can I tell when an archive was performed?
>
>
> We do little to no archiving, we tested with it in the past, but our
> infrastructure cannot support full archives on the nodes required.  But,
> someone has done some archiving, other that what we tested with.
>
> I cannot tell by looking at the filespace, due to the fact that
> the node is
> backed up daily.
>
> How can I tell when this took place?
>
> Thanks!!
>
> Michael Moore
> VF Services Inc.
> 121 Smith Street
> Greensboro,  NC  27420-1488
>
> Voice: 336-332-4423
> Fax: 336-332-4544
>