ADSM-L

Re: restore data

2004-02-24 08:14:35
Subject: Re: restore data
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 24 Feb 2004 06:14:09 -0700
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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

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 <Mgul AT GARANTI.COM DOT TR>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
02/24/2004 04:23
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Geetha Thanu
Sent: Wednesday, February 25, 2004 2:08 AM
To: ADSM-L AT VM.MARIST DOT EDU
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  <sujay_dinakar AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
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.

<Prev in Thread] Current Thread [Next in Thread>