dear Thomas, dear Richard, dear all,
Thomas wrote:
> To see when a file was deactivated use this - long running - SELECT statement:
> SELECT HL_NAME, LL_NAME, DATE(BACKUP_DATE) as bkdate, DATE(DEACTIVATE_DATE)
> AS DELDATE, CLASS_NAME FROM ADSM.BACKUPS WHERE STATE = 'INACTIVE_VERSION' AND
> TYPE = 'FILE' AND NODE_NAME = 'UPPER_CASE_NAME' AND FILESPACE_NAME =
> 'Case_Sensitive_Name'
that's what I had in mind :-)
"long running" is quite understated :-D
> This was taken from Richard Sims fabulous ADSM/TSM QuickFacts site at
> http://people.bu.edu/rbs/ADSM.funcdir
I didn't found something like above there.
well, I think my SQL knowledge is too poor to concate the right
terms ...
@Richard:
sure, the adminstrator of the client should have logfiles for more than
2 days, so he could answer this question by himself and with a carefully
configured the size will not grow too much ;-)
thanks & best regards,
Bjørn
> HTH
> Thomas Rupp
>
> -----Ursprüngliche Nachricht-----
> Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag
> von Bjørn Nachtwey
> Gesendet: Montag, 28. April 2008 12:45
> An: ADSM-L AT VM.MARIST DOT EDU
> Betreff: [ADSM-L] file status by server?
>
>
> dear all,
>
> one of my customers has some problems with his server: the machine loses
> data. unfortunately he does not know when it starts.
>
> he thought of lokking at the tsm-logs, but the client logs lasts only
> two days, so he cannot says when the first data was deleted by his
> machine.
>
> my question:
> is there a way to query the TSM-DB when a certain file was marked as
> deleted?
> How can I query which files belonging to a node are going to get
> expired?
>
> Thanks,
>
> Bjørn
--
########################################################################
Dipl.-Ing. Bjørn Nachtwey
Technische Universität Carolo-Wilhelmina zu Braunschweig
Gauss-IT-Zentrum (GITZ) -- Abteilung Server
Hans-Sommer-Straße 65, 38106 Braunschweig
Telephon: +49 (0)531 / 391 - 5535
TeleFax: +49 (0)531 / 391 - 5549
http://www.tu-braunschweig.de/it
mailto: b.nachtwey AT tu-bs DOT de
mailto: c0034031 AT tu-bs DOT de
########################################################################
PGP-Schluessel:
http://www-public.tu-bs.de:8080/~nachtwey/bjoern_nachtwey.asc
PGP-Fingerprint:
B472 526A A903 4AEB 9269 EC0B 9CDE 7465 CE87
########################################################################
|