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:[EMAIL PROTECTED] Im Auftrag von Bjørn Nachtwey Gesendet: Montag, 28. April 2008 12:45 An: ADSM-L@VM.MARIST.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: [EMAIL PROTECTED] mailto: [EMAIL PROTECTED] ######################################################################## 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
