ADSM-L

Re: [ADSM-L] Is their a way to find out - when was the last time a restore was performed for a TSM node.

2007-11-15 09:51:21
Subject: Re: [ADSM-L] Is their a way to find out - when was the last time a restore was performed for a TSM node.
From: William Boyer <bjdboyer AT COMCAST DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 15 Nov 2007 09:36:45 -0500
Again, searching the actlog or the summary table for the restore information is 
fine as long as what you're looking for is within
the retention of the ACTLOGRETENTION and SUMMARYRETENTION values you've set. Or 
if you're saving the actlog on a regular basis you
can search it still. But if it's past those retention values, your kinda SOL. 
You can dig the information out of the accounting
records, but again only if you have accounting on.

I'm not sure if some of the OEM monitoring packages (TSMManager, ServerGraph) 
capture and retain this information or not. Might be
an option for you, too.

Bill Boyer
"My problem was caused my a loose screw at the keyboard" - ??


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Rejean Larivee
Sent: Thursday, November 15, 2007 9:02 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Is their a way to find out - when was the last time a restore was 
performed for a TSM node.

Hello,
and if you want more granularity, you can also use the "REPORTRETRIEVE YES"
server option. With this option, message ANR0411I will be logged in the TSM 
activity log when a file is restored. For example :

<timestamp> ANR0411I Session 8 for administrator COLIND-TUC logged in as node 
COLIND-TUC
  restored or retrieved Backup object: node COLIND-TUC, filespace 
\\colind-tuc\c$, object\CODE\TESTDATA\ XXX.OUT

Rejean Larivee
IBM Tivoli Storage Manager support
IBM Global Technology Services

**********************************************************************************************************

Visit our new IBM Tivoli Storage Manager support page:
http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html


Expand IBM Tivoli product knowledge through our Support Technical Exchange.

http://www-306.ibm.com/software/sysmgmt/products/support/supp_tech_exch.html

**********************************************************************************************************

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/12/2007
11:40:08 AM:

> As long as the last restore was within the retention you've set for 
> the summary table. QUERY STATUS to find out the current valut.
> SET SUMMARYRETENTION to set/change.
>
> Same as for a previous suggestion for querying the actlog. The restore 
> has to be within the ACTLOG retention value.
>
> Only long term retention of this data is in the accounting data (SET 
> ACCOUNTING ON). It doesn't say restore for the record, but you could 
> query that nodename and look at fields 18 and 19 for "retrieved backup 
> objects".
>
> Bill Boyer
> "Nothing is foolproof to a sufficiently talented fool." - Murphy
>
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of Ribeiro, Ricardo
> Sent: Monday, November 12, 2007 10:25 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Is their a way to find out - when was the last time a 
> restore was performed for a TSM node.
>
> Just run this statement...
> SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE'
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of CAYE PIERRE
> Sent: Monday, November 12, 2007 8:23 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Is their a way to find out - when was the last 
> time a restore was performed for a TSM node.
>
> Sorry I miss a word... It is for backup only, not restore
>
> > -----Message d'origine-----
> > De : ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] De la 
> > part de Andrew Raibeck Envoyé : lundi 12 novembre 2007 16:05 À :
> > ADSM-L AT VM.MARIST DOT EDU Objet : Re: [ADSM-L] Is their a way to find out 
> > - when was the last time a restore was performed for a TSM node.
> >
> > I am sure I must be missing something obvious, else I am going to 
> > learn a new trick... how do you determine from QUERY FILESPACE F=D 
> > when a node last performed a restore?
> >
> > Regards,
> >
> > Andy
> >
> > Andy Raibeck
> > IBM Software Group
> > Tivoli Storage Manager Client Product Development Level 3 Team Lead 
> > Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet
> > e-mail: storman AT us.ibm DOT com
> >
> > IBM Tivoli Storage Manager support web page:
> > http://www.ibm.com/software/sysmgmt/products/support/IBMTivoli
> > StorageManager.html
> >
> > 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" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/12/2007
> > 07:49:17 AM:
> >
> > > That did the trick. Thanks for the tip
> > >
> > > Regards,
> > >
> > > Kamran
> > >
> > > -----Original Message-----
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> > On Behalf
> > > Of CAYE PIERRE
> > > Sent: Monday, November 12, 2007 4:07 AM
> > > To: ADSM-L AT VM.MARIST DOT EDU
> > > Subject: Re: [ADSM-L] Is their a way to find out - when was
> > the last
> > > time a restore was performed for a TSM node.
> > >
> > > You can also query filespaces : q fi f=d
> > >
> > > > -----Message d'origine-----
> > > > De : ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] De la 
> > > > part de Kamran Rao Envoyé : vendredi 9 novembre 2007 21:12 À :
> > > > ADSM-L AT VM.MARIST DOT EDU Objet : [ADSM-L] Is their a way to
> > find out -
> > > > when was the last time a restore was performed for a TSM node.
> > > >
> > > > Hello,
> > > >
> > > >
> > > >
> > > > Just curious to know if their a way to find out - when
> > was the last
> > > > time a restore was performed for a particular TSM node.
> > > >
> > > >
> > > >
> > > > Regards,
> > > >
> > > >
> > > >
> > > > Kamran H. Rao
> > > >
> >=