Thanks.. Turns out I figured out what that error meant in my case. I was doing a wildcard restore which is considered a "no query restore" since I'm using a wildcard instead of specifying the actual file names. TSM is simply telling me which files were unavailable. So I used the GUI to restore the actual files in that directory using a point in time and I get a different error, ANR0548W.
Now I did a quick "q vol" on these volumes and they are all a part of my onsite backup pool. The tapes that I have are offsite copypool tapes. According to the below help on ANR0548W if I retry the operation it should ask for the copypool tape. It doesn't.. it just spits out the same below errors again. I'm guessing that either I have a problem with my DB or tape (less likely), the data isn't in a copy pool at all (equally unlikely) or the offsite copypool volume it wants is status unavailable and perhaps TSM just doesn't tell me that's the root of the problem? I would really like to make it so it requests the copypool tape first and not my primary pool's tapes. Is there someway of doing this? My database is huge (100GB). I set my primary pool volumes all to access destroyed. I set those tapes that I do have (some offsite ocpypool tapes that I care about) to acc=reado. Just seem to be having trouble getting the data to restore now. ANR1424W Read access denied for volume A00773 - volume access mode="destroyed". ANR0548W Retrieve or restore failed for session 107 for node MDCTXUDSE261 (WinNT) processing file space \\mdctxudse261\d$ 2 for file \LOTUS\ DOMINO stored as Backup - data integrity error detected. ANR1424W Read access denied for volume A02539 - volume access mode="destroyed". ANR0548W Retrieve or restore failed for session 107 for node MDCTXUDSE261 (WinNT) processing file space \\mdctxudse261\d$ 2 for file \LOTUS\DOMINO\ DATA stored as Backup - data integrity error detected. ANR1424W Read access denied for volume A00773 - volume access mode="destroyed". ANR0548W Retrieve or restore failed for session 107 for node MDCTXUDSE261 (WinNT) processing file space \\mdctxudse261\d$ 2 for file \LOTUS\ DOMINO stored as Backup - data integrity error detected. ANR1424W Read access denied for volume A02539 - volume access mode="destroyed". ANR0548W Retrieve or restore failed for session 107 for node MDCTXUDSE261 (WinNT) processing file space \\mdctxudse261\d$ 2 for file \LOTUS\DOMINO\ DATA stored as Backup - data integrity error detected. ANR1424W Read access denied for volume A02033 - volume access mode="destroyed". ANR0548W Retrieve or restore failed for session 107 for node MDCTXUDSE261 (WinNT) processing file space \\mdctxudse261\d$ 2 for file \LOTUS\DOMINO\DATA\ NAMES.NSF stored as Backup - data integrity error detected. ANR1424W Read access denied for volume A00773 - volume access mode="destroyed". ANR0548W Retrieve or restore failed for session 107 for node MDCTXUDSE261 (WinNT) processing file space \\mdctxudse261\d$ 2 for file \ LOTUS stored as Backup - data integrity error detected. tsm: MDCTXUTSM03>help anr0548w ---------------------------------------------------------------------------- --- ANR0548W Retrieve or restore failed for session session number for node node name (client platform) processing file space filespace filespace id for file file name stored as storage repository - data integrity error detected. Explanation: The server ends a file retrieval operation for the specified session because an internal database integrity error has been encountered on the server. System Action: The server ends the specified session and continues operation. User Response: Re-try the restore or retrieve operation and if the file is also backed up in a copy storage pool, the operation will attempt to read the file from the alternate location. Gerald Wichmann Manager, Systems Engineering Data Restoration ZANTAZ, Inc. 925.598.3099 (w) -----Original Message----- From: Richard Sims [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 3:53 PM To: [EMAIL PROTECTED] Subject: Re: ANR0836W No query restore >When attempting to do a restore I'm getting the messages below.. There is no >other accompanying information. Anyone know what it means? There is nothing >in the messages guide that sheds any light as to this ANR.. ... Gerald - I have real-world notes on a variety of messages in http://people.bu.edu/rbs/ADSM.QuickFacts including that one. May help. Richard Sims, BU This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm) service. For more information, visit us at www.zantaz.com. IMPORTANT: This electronic mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by telephone or directly reply to the original message(s) sent. Thank you.