Hi, Thanks for all who are helping me to solve my problems. The problem with the select * command was as tols it is case sensitive. when I gave CDFD, I can see the contents of the volume. Evry thing is fine. When I checked the volume is marked as scratch. scratch volume? yes. when I tried to change to private, using update libvolume command it is saying updated but again scartch says yes. May be this is the reason that when I restore data from it, it is saying unavailabe.
Now how to change the status of the volume from scratch to private. Thanks once again Geetha Thanu ---------REPLY TO------------- Date:Tue Feb 24 21:14:09 CST 2004 FROM: Andrew Raibeck <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: restore data Don't forget to put the volume name in upper case. SQL string comparisons are case sensitive, and TSM stores tape volume names in upper case: select * from contents where volume_name='CDFD11' Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Murat GUL <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/24/2004 04:23 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Re: restore data Hi Geetha, Your command is not correct.Try this command ; select * from contents where volume_name='cdfd11' MG -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Geetha Thanu Sent: Wednesday, February 25, 2004 2:08 AM To: [EMAIL PROTECTED] Subject: Re: restore data Hi, The command I gave was select * from the contents volume_name=cdfd11 Is it correct? Its not taking the command. The access mode is readonly. It is very well present in the autolib (library), but if i try to restore data from it is setting the mode as unaccessible. Thanks Geetha Thanu Bioinformatics CDFD,Hyderabad. ---------REPLY TO------------- Date:Tue Feb 24 17:10:25 CST 2004 FROM: sujay dinakar <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: restore data Hi Check wether the database contains filenames for that volume select * from contents where volume_name=[your volume name] If it reports any files. Check wether the use is locked or not Change the Access mode to Readonly. Dinakar __________________________________ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools - This message and attachments are confidential and intended solely for the individual(s) stated in this message.If you received this message although you are not the addressee you are responsible to keep the message confidential .The sender has no responsibility for the accuracy or correctness of the information in the message and its attachments.Our company shall have no liability for any changes or late receiving,loss of integrity and confidentiality,viruses and any damages caused in anyway to your computer system. Bu mesaj ve ekleri mesajda gonderildigi belirtilen kisi/kisilere ozeldir ve gizlidir.Bu mesajin muhatabi olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj iceriginin gizliligi ve bu gizlilik yukumlulugune uyulmasi zorunlulugu tarafiniz icin de soz konusudur.Mesaj ve eklerinde yer alan bilgilerin dogrulugu ve guncelligi konusunda gonderenin ya da sirketimizin herhangi bir sorumlulugu bulunmamaktadir.Sirketimiz mesajin ve bilgilerinin size degisiklige ugrayarak veya gec ulasmasindan, butunlugunun ve gizliliginin korunamamasindan, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan sorumlu tutulamaz. -
