RES: SQL Formatting on AIX scripts - SQLDISPLAYMODE
Todd, This problem occurs because SQLDISPLAYMODE is a parameter set only for the current session. Each time you issue dsmadmc comands you are invoking a new session and SQLDISPLAYMODE is reset to NARROW. You can check this issuing Q SQLSESSION after setting SQLDISPLAYMODE. I would create a Server Command Script inside TSM which would have the SQLDISPLAYMODE and the SELECT clauses into it. Once this script is created, you just have to run it from your cron as you do it today (dsmadmc -id=xxx -pa=yyy run my_script_name) Good luck ! Alexandre Bicas Caldeira - [EMAIL PROTECTED] Tivoli Certified Specialist - Tivoli Storage Manager Service IT Solutions - http://www.service.com.br Sao Paulo:(11) 3054-1400 Rua Vicente Pinzon, 144, cj 112 CEP 04547-130 - Sco Paulo - SP Porto Alegre: (51) 212-3666 Curitiba: (41) 363-5586 -Mensagem original- De: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]Em nome de Pucky, Todd M. Enviada em: segunda-feira, 3 de dezembro de 2001 09:44 Para: [EMAIL PROTECTED] Assunto: SQL Formatting on AIX scripts - SQLDISPLAYMODE TSM Server: AIX 4.3.3 I have seen this issue addressed in the adsm archives, but never a clear answer on how to solve it. I plan to use a script in a cron job on AIX, but I need to have SQLDISPLAYMODE set to WIDE. Here is the part of my script where I attempt to set the SQLDISPLAYMODE to WIDE and issue the query. dsmadmc -id=xx -pas=xx set sqldisplaymode wide dsmadmc -id=xx -pas=xx select events.node_name, events.s tatus, nodes.contact from events, nodes where events.domain_name='SERVER' and ev ents.schedule_name='SERVER_0300_0500' and (events.status='Missed' or events.stat us='Failed') and events.node_name=nodes.node_name $eventtmp I have no problems when I issue these commands from the Admin Command Line, but through the AIX script I always get SQL format of NARROW in the results of my query. Any suggestions on how to get the SQLDISPLAYMODE WIDE command to work in the AIX script would be greatly appreciated. Thanks Todd M. Pucky The Timken Company Global Information Systems ** This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. The Timken Company **
Library migration
Hi *SMers ! I have a customer who has 2 Magstar 3590 Libraries and wishes to upgrade them to a single 3494 with two drives... This customer has a particular problem: he manually labeled his 700 tapes using 5-digit labels, and 3494 barcode labels are built with 6-digits ! I know I can buy 6-digit barcode labels with a leading blank, but my main problem is: How TSM will recognize them ?! Will it recognize as a 5-digit or a 5-digit + blank ?! This is a big issue for me because TSM compares the barcode label with the one physically written on the tape, and they should be the same otherwise the tape will be rejected by TSM... Has anyone migrated this kind of labels, even in another tape model ?! Thanks all Alexandre Bicas Caldeira - [EMAIL PROTECTED] Tivoli Certified Specialist - Tivoli Storage Manager Service IT Solutions - http://www.service.com.br Sao Paulo:(11) 3054-1400 Rua Vicente Pinzon, 144, cj 112 CEP 04547-130 - Sco Paulo - SP Porto Alegre: (51) 3212-3666 Curitiba: (41) 363-5586
HP and SAN
Hi guys ! Does anyone know if TSM server for HP-UX is supported in a SAN environent ? A customer needs to connect fiber channel tapes in a HP box, and wishes to use TSM in order to manage the backups. If it's not supported, does anyone inside Tivoli know when it will be ?! Thanks all ! Alexandre Bicas Caldeira - [EMAIL PROTECTED] Tivoli Certified Specialist - Tivoli Storage Manager Service IT Solutions - http://www.service.com.br Sao Paulo:(11) 3054-1400 Rua Vicente Pinzon, 144, cj 112 CEP 04547-130 - Sco Paulo - SP Porto Alegre: (51) 212-3666 Curitiba: (41) 363-5586
SAN - FC Adapters doubt ...
Hi guys, I'm trying to set up a SAN using two IBM 2109-S16 FC Switch, six TSM Servers and a 3494 with 10 3590E drives Four TSM Servers are running smooth (1 M80, 2 Dell with FC Qlogic 2200, 1 SUN450 with FC Qlogic 2200). All of then are PCI Servers. I have two other servers (E3500 and a E1) that are SBUS Servers. Acording to Tivoli web site, all FC Adapters supported in this configuration are PCI ! ! ! Both SBUS Servers have an JNI FC64-1063 FC Adapter which is simillar do JNI FCI-1063 (the PCI Version which is supported)... The FC adapter establishes link to the 2109-S16 (steady green light) but it doesn't find any tape devices... Is anyone using these kind of FC adapters with SAN ? Is there any special firware or device driver that should be installed in these sun boxes in order to put these cards to work ? I updated the switch's firmware do level 2.2.1a but I had no luck... The IBM 2109-S16 is simillar to a Brocade Switch which is used by EMC... These FC64-1063 adapter is the one that is used by most of the SBUS Servers... EMC guys, any tips ?! Thanks you all ! Alexandre Bicas Caldeira - [EMAIL PROTECTED] Tivoli Certified Specialist - Tivoli Storage Manager Service IT Solutions - http://www.service.com.br Sao Paulo:(11) 3040-1960 Rua Helena, 280, Cj 1106 CEP 04552-050 - Sco Paulo - SP Porto Alegre: (51) 212-3666 Curitiba: (41) 262-8320
Netware 5.6 SunOS 5.6
Hi guys, Does anyone know if TSM is compatible with Novell Netware 5.6 and Sun Os 5.6 ?! When I was looking for it at Tivoli site, I found out that one of TSM requirements is Netware 5.1 but the site didn't mention other versions above 5.1 ... Thanks all ___ Alexandre Bicas Caldeira - [EMAIL PROTECTED] Tivoli Certified Specialist - Tivoli Storage Manager Service IT Solutions - http://www.service.com.br Sao Paulo:(11) 3040-1960 Rua Helena, 280, Cj 1106 CEP 04552-050 - Sco Paulo - SP Porto Alegre: (51) 212-3666 Curitiba: (41) 262-8320
Export Problem
Hi TSMers, I have to perform a migration of a TSM Server from a NT box to an AIX box. I have about 2TB of data backed up in 150 DLT tapes. My lirary is a STK9730 with 2 tape drives My problem is: EXPORT SERVER copies the data from the original tapes to any given Device Class. There is no need to do this because, I will have the same TSM Server with the same library and tapes into the AIX box ! Is there a way to copy only the metadata between different plataforms, just like a BACKUP DB does ? Can DUMP DB be used in this case ? Or is there any faster way to do it ? Time is crucial ! Thanks all Alexandre Bicas Caldeira - [EMAIL PROTECTED] Service IT Solutions - http://www.service.com.br Sao Paulo:(11) 3040-1960 Rua Helena, 280, Cj 1106 CEP 04552-050 - Sco Paulo - SP Porto Alegre: (51) 212-3666 Curitiba: (41) 339-3076
RES:
Jack, Have you tried "update vol" ? /reado update vol Volume_name acc=| unav \readw Usually, I update all the volumes that are removed from the library to readonly. Good Luck ____ Alexandre Bicas Caldeira - [EMAIL PROTECTED] Tivoli Certified Specialist - Tivoli Storage Manager Service IT Solutions - http://www.service.com.br Sao Paulo:(11) 3040-1960 Rua Helena, 280, Cj 1106 CEP 04552-050 - Sco Paulo - SP Porto Alegre: (51) 212-3666 Curitiba: (41) 339-3076 -Mensagem original- De: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]Em nome de Palmadesso Jack Enviada em: quarta-feira, 3 de janeiro de 2001 17:42 Para: [EMAIL PROTECTED] Assunto: Kind of quiet today! I hope this is a simple one. I have some volumes that were removed from a 3590 library and then went "unavailable" The volumes are now back in but are all empty. A "q con" for each volume shows there is no data. My problem is how do I make these volumes scratch again? I cannot delete the volumes because I get volume cannot be deleted because volume state is mountable not in lib. How do I make these scratch again? Thanks for any help Jack
TSM API + DELPHI
Has anyonebeen crazy enough to develop something using Inprise Delphi and TSM API ? I've read de redbook about it, but I'm still having some trouble trying to use the TSM DLLs in Delphi... Any tips or free sample code ?!?!?! Thanks Alexandre Bicas Caldeira - [EMAIL PROTECTED] BEGIN:VCARD VERSION:2.1 N:Caldeira;Alexandre;Bicas FN:Alexandre Bicas Caldeira ORG:Service IT Solutions TITLE:Analista TSM TEL;WORK;VOICE:55 11 3040-1960 TEL;WORK;FAX:55 11 3040-1960 ADR;WORK:;;Rua Helena, 280, cj1106;São Paulo;SP;04552-050;Brasil LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Rua Helena, 280, cj1106=0D=0AS=E3o Paulo, SP 04552-050=0D=0ABrasil URL: URL:http://www.service.com.br BDAY:19770104 EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:2905T203256Z END:VCARD
xbsa.o fails with tsm3.73. and Informix 7.31UC5
Hy guys, I'm having the same problem that joel had a few months ago: Does anyone know how to fix it ?! Any tips ?! Joel ?! "After installing TSM 3.7.2 B/A and API clients, Informix OnBar 7.31.UC5-1 fails with the error "XBSA Error (BSAInit): Invalid environment keyword." If I fail back to the 3.7.1 version of /usr/tivoli/tsm/client/api/bin/xbsa.o the backup works. Has anyone had this problem? Were you able to solve it? These soft links exist in /usr/lib: ibsad001.a - /usr/tivoli/tsm/client/api/bin/libXApi.a libApiDS.a - /usr/tivoli/tsm/client/api/bin/libApiDS.a libXApi.a - /usr/tivoli/tsm/client/api/bin/libXApi.a The environmental variables are: BAR_BSALIB_PATH=/usr/tivoli/tsm/client/api/bin/xbsa.o DSMI_DIR=/usr/tivoli/tsm/client/api/bin DSMI_LOG=/usr/tivoli/tsm/client/api/binDSMI_CONFIG=/usr/tivoli/tsm/client/api/bin/dsm.opt" Thanks all ! Alexandre Bicas Caldeira - [EMAIL PROTECTED]Service IT Solutions - http://www.service.com.br Sao Paulo: (11) 3040-1960 Rua Helena, 280, Cj 1106 CEP 04552-050 - São Paulo - SP Porto Alegre: (51) 212-3666 Curitiba: (41) 339-3076 BEGIN:VCARD VERSION:2.1 N:Caldeira;Alexandre;Bicas FN:Alexandre Bicas Caldeira ORG:Service IT Solutions TITLE:Analista TSM TEL;WORK;VOICE:55 11 3040-1960 TEL;WORK;FAX:55 11 3040-1960 ADR;WORK:;;Rua Helena, 280, cj1106;São Paulo;SP;04552-050;Brasil LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Rua Helena, 280, cj1106=0D=0AS=E3o Paulo, SP 04552-050=0D=0ABrasil URL: URL:http://www.service.com.br BDAY:19770104 EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:2808T115518Z END:VCARD
