ADSM-L

Réf:Which tape is this file on?

1999-03-16 03:50:35
Subject: Réf:Which tape is this file on?
From: Alain Ricois <Alain.Ricois AT IBESIS DOT COM>
Date: Tue, 16 Mar 1999 08:50:35 +0000
I first update all the volumes to unavailable state
run the restore operation on the client
update the volumes readwrite
extract and format the error messages from the server actlog

It works fine but no backup/restore session using tape, no move data,backuup stg
can run in the same time


Hope this helps 


Alain Ricois
____________________Séparateur de messages____________________
Objet : Which tape is this file on?
Auteur :    "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Date :  16/03/99 17:29

Guru's,

In our continued effort to use ADSM in a cruel and unusual manner we need to
determine which tapes contain a set of files.

So far our best effort involves using a shell script to query volumes in the
stgpool, query contents of these volumes, and grep for file_name.

This seems to work, but I'm sure there must be a nicer way - perhaps via the
SQL interface. So far though my SQL attempts seem remarkably slow to
execute.

Does anyone have a nice *fast* SQL query to determine which tapes contain a
certain set of files?

Thanks,
Steven P.


--------------------------------------------------------------
Groupement d'Interet Economique IBESIS
Groupement d'Interet Economique IBESIS
4, Rue Doguereau
28100 DREUX
France

Tel : +33 (0) 2 37654700 - Fax : +33 (0) 2 37427436

This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to
whom they are addressed.
If you have received this email in error please notify
postmaster AT ibesis DOT com"
--------------------------------------------------------------
=======================================================================
<Prev in Thread] Current Thread [Next in Thread>
  • Réf:Which tape is this file on?, Alain Ricois <=