Thank's for your response. But it's not exactly what i would like. I would like to execute a simulate retreive before executing my command :
dsmc retrieve -preservepath=complete -filelist=c:\?\files d:\?\target\ where c:\?\files is the file which contain the name of the files to retreive d:\?\target\ is the target space. My cartridges are out of my library, they are not coded "offsite", i would like to simulate the retreive command to get all volumes which will be reclaimed. If i use the sql command : select volume_name from contents where file_name = aaaaaaaa, the server fall down.It's too voluminous.more than millions objects in the table. DFrance <[EMAIL PROTECTED]>@VM.MARIST.EDU> le 29/11/2002 06:56:07 Veuillez répondre à "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Envoyé par : "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Pour : [EMAIL PROTECTED] cc : Objet : Re: Which cartridge must to be monted whith a retreive Try doing a sample retrieve for the desired package-description and filespec; it should skip tapes marked "unavailable", logging messages to the activity log... those messages will tell you which tapes you need... ANR1420W Read access denied for volume volume name - volume access mode = "unavailable". Explanation: An attempt to access the named volume for reading fails because the volume status is unavailable. System Action: The volume is not used for read access. Don France Technical Architect -- Tivoli Certified Consultant Tivoli Storage Manager, WinNT/2K, AIX/Unix, OS/390 San Jose, Ca (408) 257-3037 mailto:[EMAIL PROTECTED] (change aye to a for replies) Professional Association of Contract Employees (P.A.C.E. -- www.pacepros.com) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Eric LANGUILLE Sent: Wednesday, November 27, 2002 11:40 PM To: [EMAIL PROTECTED] Subject: Which cartridge must to be monted whith a retreive I would like to execute a simulate with a retreive to know which cartridges will be demanded. We have in pool offsite some cartridges (near 200). If we have a demand for retreived some files, we can't mount cartridge after cartridge in the library IBM 3494. The Operators want to have a list before. So, if we have a list, it's easy to get all the cartridges, and after chekin on them, the final customer can execute the real retreive. Do you have an experience on this subject? ___ Ce message est strictement confidentiel. Son intigriti n'est pas assurie sur Internet. Le contenu de ce message ne peut engager la responsabiliti d'Atos Origin. Si vous n'jtes pas destinataire du message, merci d'en avertir immidiatement l'expiditeur et de le ditruire. This e-mail is privileged and may contain confidential information intended only for the person(s) named above. If you receive this e-mail in error, please notify the sender immediately by telephone or return e-mail.=
