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'
This was taken from Richard Sims fabulous ADSM/TSM QuickFacts site at
http://people.bu.edu/rbs/ADSM.funcdir
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
########################################################################
Vorarlberger Illwerke AG ein Unternehmen von illwerke vkw
Rechtsform: Aktiengesellschaft, Sitz: Bregenz, Firmenbuchnummer: FN 59202 m,
Firmenbuchgericht: LG Feldkirch, UID-Nr.: ATU 36737402
|