Re: SQL querying
Hi Norman! This query returns the number of failed files, not the filename of the failed files. That what I was looking for... The only place I can think of is the activity log and there is only one index on this table (DATE_TIME). The performance of a SELECT * FROM ACTLOG is ok, but as soon as you add WHERE statement to it, it becomes very slow. Groetjes, Eric van Loon -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Norman Bloch Sent: vrijdag 25 juli 2008 15:05 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL querying Hi Eric, I use the following query to be warned if there are failed files, on a given node archive, over the past 24hours, from summary table : select failed as F_A3 from summary where activity = 'ARCHIVE' and entity = 'MYNODE' and cast((current_timestamp-start_time) days as integer ) 1 Replace ARCHIVE with BACKUP and it should also do the trick. Regards. Norman Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 23/07/2008 16:35 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] SQL querying Hi *SM-ers! I'm trying to create an SQL query to extract failed files from the activity log. When I do a select * from actlog all goes well, but as soon as I replace the * with things like nodename, date_time, message to filter the output, the query becomes slower and slower. Is there a possibility in TSM to put the output of a slightly filtered q actlog (eg. Select * from actlog where originator='CLIENT') in a temporary table space which one can use in different queries later on? Thank you very much for you help in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: SQL querying
Hi Stef! I know, but I want reports only to be generated by TSMOR, which cannot use third-party tools. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stef Coene Sent: woensdag 23 juli 2008 19:55 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL querying On Wednesday 23 July 2008, Loon, E.J. van - SPLXM wrote: Hi *SM-ers! I'm trying to create an SQL query to extract failed files from the activity log. When I do a select * from actlog all goes well, but as soon as I replace the * with things like nodename, date_time, message to filter the output, the query becomes slower and slower. Is there a possibility in TSM to put the output of a slightly filtered q actlog (eg. Select * from actlog where originator='CLIENT') in a temporary table space which one can use in different queries later on? It is faster / easier to do a select * from actlog and dump the output to a file. I prefer perl to process the content of the file. Stef ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TSM upgrade to 5.5.1
Hi guys! I decided to open a PMR for the TSMOR bug and support told me there already is an open APAR for this problem: APAR= IC57290 SER= ANR2906E UNEXPECTED SQL LITERAL TOKEN - 'RUS' ERROR FROM OPERATIONAL REPORTING ERROR DESCRIPTION: The following select statement is issued for Operational Reporting: 07/09/2008 10:52:27 ANR2017I Administrator ADMIN issued command: select option_value as LANG from options where UPPER(option_value) in ('CHS','ZH_CN','CHT','ZH_TW','DEU','DE_DE','AMENG','EN_US','ENG','ESP','ES_ES','FRA','FR_FR','ITA','IT_IT','JPN','JA_JP','KOR','KO_KR','PTB','PT_ BR')'RUS','RU_RU') (SESSION: 31) Invalid command syntax of the select statement results in the following error message: 07/09/2008 10:52:27 ANR2906E Unexpected SQL literal token - 'RUS'. (SESSION: 31) This problem was introduced in the 5.5.1 server code level. Platforms affected: 5.5.1 Initial Impact: Medium Additional Keywords: or o/r op report LOCAL FIX: The problem can be circumvented by stopping the TSMReptSvc service and exiting the management console (mmc), then replacing the 5.5.1 tsmrept.exe with the the one from the 550GA install package and restarting the service. The management console can be started and the report refreshed to verify the problem has been resolved. The 550GA tsmrept.exe may be in the C:\tsm_images\5.5.0.0-TIV-TSMSRV-Windows\TSM32\server\program files\Tivoli\TSM\console directory unless the directory was deleted after the GA install. It's a pitty that I could not find this APAR through the IBM website. It could have saved me opening a PMR... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of Phillip Burgess Sent: donderdag 17 juli 2008 16:58 To: ADSM-L AT VM.MARIST DOT EDU Subject: Re: TSM upgrade to 5.5.1 Try running Ops reporting on your test server ;) It fails immediately when you run any report, due to a spelling mistake in the language query ! Other than that we have been running it for two days without any problem on Windows. Phil From: Björn Rackoll [mailto:backup AT RRZ.UNI-HAMBURG DOT DE] Sent: Thu 17/07/2008 15:02 To: ADSM-L AT VM.MARIST DOT EDU Subject: [ADSM-L] TSM upgrade to 5.5.1 Hi, currently we have TSM 5.3.4.2 running on AIX 5.3 (and an IBM 3494 tape library with eight 3592 drives, Atape 10.7.3.0) and are planning to upgrade to 5.5.1.0 soon. I've already tested this upgrade on my test machine, and it worked fine. This absence of any problem made me even a bit suspicious. :-) My questions: - Which kind of tests would you recommend performing before you'd declare a new TSM version 'ready for production'? I've read Technote 1196013 and the relevant section in ADSM.QuickFacts. Performing a simple backup and restore from different clients worked fine, LAN-free is not used. - Do you know of any pitfalls in 5.5.1.0 or should it be safe to use on the server? Regards, -- Bjoern Rackoll University of Hamburg Regionales Rechenzentrum Zentrale Dienste Schlueterstr. 70 20146 Hamburg Tel.: +49 (0)40 42838 - 63 11 Fax: +49 (0)40 42838 - 62 70 E-Mail: backup AT rrz.uni-hamburg DOT de ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
SQL querying
Hi *SM-ers! I'm trying to create an SQL query to extract failed files from the activity log. When I do a select * from actlog all goes well, but as soon as I replace the * with things like nodename, date_time, message to filter the output, the query becomes slower and slower. Is there a possibility in TSM to put the output of a slightly filtered q actlog (eg. Select * from actlog where originator='CLIENT') in a temporary table space which one can use in different queries later on? Thank you very much for you help in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Snaopshot failure
Hi Tim! Could this Technote be related? http://www-1.ibm.com/support/docview.wss?uid=swg21306799 Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: dinsdag 22 juli 2008 15:13 To: ADSM-L@VM.MARIST.EDU Subject: Snaopshot failure Getting error on 5.5.0 Windows 2003 client, anyone seen this 07/21/2008 20:30:17 ANS1327W The snapshot operation for 'D:' failed with error code: -1. 07/21/2008 20:30:17 ANS1228E Sending of object '\\derby\d$' failed 07/21/2008 20:30:17 ANS5283E The operation was unsuccessful. 07/21/2008 20:30:17 ANS1377W The client was unable to obtain a snapshot of '\\derby\d$'. The operation will continue without snapshot support. 07/21/2008 20:36:53 ANS1327W The snapshot operation for 'C:' failed with error code: -1. 07/21/2008 20:36:53 ANS1228E Sending of object '\\derby\c$' failed 07/21/2008 20:36:53 ANS5283E The operation was unsuccessful. 07/21/2008 20:36:53 ANS1377W The client was unable to obtain a snapshot of '\\derby\c$'. The operation will continue without snapshot support. 07/21/2008 20:54:04 ANS1512E Scheduled event 'OMS_DAILY55' failed. Return code = 12. Tim Brown Systems Specialist - Project Leader Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TSM upgrade to 5.5.1
Hi Phil! Same here! It seems to be a bug in TSMOR 5.5.1. I didn't feel like reporting it to IBM (I know, I know, not very helpfull of me) so I went back to the 5.4 version. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Phillip Burgess Sent: donderdag 17 juli 2008 16:58 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM upgrade to 5.5.1 Try running Ops reporting on your test server ;) It fails immediately when you run any report, due to a spelling mistake in the language query ! Other than that we have been running it for two days without any problem on Windows. Phil From: Björn Rackoll [mailto:[EMAIL PROTECTED] Sent: Thu 17/07/2008 15:02 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM upgrade to 5.5.1 Hi, currently we have TSM 5.3.4.2 running on AIX 5.3 (and an IBM 3494 tape library with eight 3592 drives, Atape 10.7.3.0) and are planning to upgrade to 5.5.1.0 soon. I've already tested this upgrade on my test machine, and it worked fine. This absence of any problem made me even a bit suspicious. :-) My questions: - Which kind of tests would you recommend performing before you'd declare a new TSM version 'ready for production'? I've read Technote 1196013 and the relevant section in ADSM.QuickFacts. Performing a simple backup and restore from different clients worked fine, LAN-free is not used. - Do you know of any pitfalls in 5.5.1.0 or should it be safe to use on the server? Regards, -- Bjoern Rackoll University of Hamburg Regionales Rechenzentrum Zentrale Dienste Schlueterstr. 70 20146 Hamburg Tel.: +49 (0)40 42838 - 63 11 Fax: +49 (0)40 42838 - 62 70 E-Mail: [EMAIL PROTECTED] ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Rebuilding a volume history file
Hi *SM-ers! The filesystem which contains my volume history file was filled to 100% last night, so TSM reported I/O errors while writing to it. I have had the filesystem enlarged, but now I have a volume history file which is missing data. Is there a way to rebuild a volume history file? Thank you very much for any reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Rebuilding a volume history file
Hi! I don't understand your reply. A BAckup VOLHistory just makes a backup of the currently incomplete volume history file. How would that help me? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of TSM User Sent: vrijdag 4 juli 2008 13:09 To: ADSM-L@VM.MARIST.EDU Subject: Re: Rebuilding a volume history file BAckup VOLHistory On Fri, Jul 4, 2008 at 8:02 AM, Loon, E.J. van - SPLXM [EMAIL PROTECTED] wrote: Hi *SM-ers! The filesystem which contains my volume history file was filled to 100% last night, so TSM reported I/O errors while writing to it. I have had the filesystem enlarged, but now I have a volume history file which is missing data. Is there a way to rebuild a volume history file? Thank you very much for any reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Rebuilding a volume history file
Hi Richard (and others)! Thank you very much for your reply! I forgot that the volume history file is generated by the BAckup VOLHistory command and thought it was a file which was continuously updated by TSM. Thank you very much for the update! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: vrijdag 4 juli 2008 14:40 To: ADSM-L@VM.MARIST.EDU Subject: Re: Rebuilding a volume history file On Jul 4, 2008, at 8:29 AM, Loon, E.J. van - SPLXM wrote: Hi! I don't understand your reply. A BAckup VOLHistory just makes a backup of the currently incomplete volume history file. How would that help me? Hi, Eric - The file is a copy of the information in the TSM database, generated by TSM, usually automatically via the VOLUMEHistory server option, but also by manual invocations of the BAckup VOLHistory command. The principal purpose of the file is as a reference to TSM database recovery operations. Richard Sims ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Linux BMR
Hi *SM-ers! Our Linux guys are trying to find a way to do bare metal restores on Linux (Redhat) while using TSM. I was wondering how other companies have implemented this. I there a supported/documented way to do this? Thank you very much for any response in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Speeding up my SQL query
Hi *SM-ers! My TSM Operational Reporter creates a daily report for our Windows guys. Part of this report is a SQL query which returns all missed files. This is the query: select - actlog.nodename as Node Name, - substr(char(actlog.date_time), 1, 16) as Date/Time, - substr(actlog.message, 26) as Message - from actlog,nodes - where - actlog.nodename=nodes.node_name - and (actlog.msgno=4005 or actlog.msgno=4007 or actlog.msgno=4018 or actlog.msgno=4037 or actlog.msgno=4987) - and (actlog.date_time between '%s' and '%s') - and (nodes.contact like 'Windows%%') - order by actlog.nodename The problem is that the query is taking more that 3 hours to complete, probably because it's using non-indexed database tables. Does anyone know how to make this query more efficient? Thank you VERY much for your help in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Speeding up my SQL query
Hi Rama! TSM Operational Reporter only supports SQL queries... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Choudarapu, Ramakrishna (GTS) Sent: vrijdag 16 mei 2008 15:17 To: ADSM-L@VM.MARIST.EDU Subject: Re: Speeding up my SQL query Eric, Did you try Q ACTLOG instead, using NODE=NODE_NAME, MSG=MSGNUM BEGINTIME and ENDTIME parameters, which may be faster than the select, but the resluts may not be as straight and detailed as your select... Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Friday, May 16, 2008 9:01 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Speeding up my SQL query Hi *SM-ers! My TSM Operational Reporter creates a daily report for our Windows guys. Part of this report is a SQL query which returns all missed files. This is the query: select - actlog.nodename as Node Name, - substr(char(actlog.date_time), 1, 16) as Date/Time, - substr(actlog.message, 26) as Message - from actlog,nodes - where - actlog.nodename=nodes.node_name - and (actlog.msgno=4005 or actlog.msgno=4007 or actlog.msgno=4018 or actlog.msgno=4037 or actlog.msgno=4987) - and (actlog.date_time between '%s' and '%s') - and (nodes.contact like 'Windows%%') - order by actlog.nodename The problem is that the query is taking more that 3 hours to complete, probably because it's using non-indexed database tables. Does anyone know how to make this query more efficient? Thank you VERY much for your help in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** This message w/attachments (message) may be privileged, confidential or proprietary, and if you are not an intended recipient, please notify the sender, do not use or share it and delete it. Unless specifically indicated, this message is not an offer to sell or a solicitation of any investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Merrill Lynch. Subject to applicable law, Merrill Lynch may monitor, review and retain e-communications (EC) traveling through its networks/systems. The laws of the country of each sender/recipient may impact the handling of EC, and EC may be archived, supervised and produced in countries other than the country in which you are located. This message cannot be guaranteed to be secure or error-free. This message is subject to terms available at the following link: http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch you consent to the foregoing. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Speeding up my SQL query
Hi Richard! Thank you very much for your reply! Since I'm not much of an SQL wizzard, could you please help met with rebuilding the query? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: vrijdag 16 mei 2008 15:08 To: ADSM-L@VM.MARIST.EDU Subject: Re: Speeding up my SQL query Eric - One thing you can do is use the SQL clause IN rather than a succession of OR conditions to improve the query performance of testing for multiple values. Richard Sims ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Fantasy TSM
Amen, amen amen!!! I still use the good old GUI which still works as long as you don't click on the storagepools option. (a q stgpool format=gui returns an internal error). New TSM customers really should take a look at it (It's part of the Windows 3.1 client and can be installed separately). It's fast, offers al kind of filtering and sorting. IBM should have never abandoned it... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Sung Lee Sent: maandag 5 mei 2008 21:37 To: ADSM-L@VM.MARIST.EDU Subject: Re: Fantasy TSM my list. Administrative gui for windows similar to what we had with ADSM 3.1. I still have this some where althought I don't use it anymore GUI - Yeah bring back pls command - way to go about doing things web interface - was good ISC - no comment ^%$ Thanks, Sung Y. Lee ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TSM being abandoned?
Yeehaw? Are you really waiting for an DB2 database? The TSM database is now very stable and hardly needs any attention. I'm running quite a few product over here which are using a pre-defined DB2 database, but although IBM sells them as install and forget I have never seen a DB2 database run for more that two weeks without manual intervention... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Nicholas Rodolfich Sent: donderdag 17 april 2008 0:03 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM being abandoned? An IBM TSM person told me that TSM v6 will have db2 for its database and they are shootng for an announcement in October. Yeehaw!! Regards, Nicholas Rodolfich Network Administrator (AIX) East Jefferson General Hospital 504-883-6955 (office) 228-223-1187 (mobile) [EMAIL PROTECTED] [EMAIL PROTECTED] 4/16/2008 2:46 PM It is slotted to be released Jan 2009. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: Wednesday, April 16, 2008 2:19 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM being abandoned? Is Version 6 going to be released this Year or Next? regards Colwell, William F. wrote: I have been configuring a new TSM server since last November. At first I wanted a VTL. But when I learned from the Oxford symposium presentations that TSM would have its own dedup in version 6, and considering the cost of the vtl, I ditched it and ordered a lot more of SATA arrays for less money. I think in a few years after v6 is widely installed, VTL's won't look so good for TSM sites. Assuming it all works of course. your VTL vendor may just have been whistling past the graveyard. Bill Colwell -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Zarnowski Sent: Wednesday, April 16, 2008 12:08 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM being abandoned? Deduplicating VTLs fit better into NBU sites. TSM's progressive incremental methodology already reduces the data stream, making deduping VTLs less of a win, though it can still be beneficial. My point is that VTL vendors may not look as positively on TSM as they do on other less-efficient backup solutions, because they don't sell as much VTL product to them. IMHO. ..Paul A VTL vendor said he is seeing a number of mid-sized businesses migrating from TSM to NBU (Symantec). Do you think this is true? My concern is that the pool of support techs will shrink and put us in a bind. Regards, Orin Orin Rehorst Port of Houston IMPORTANT NOTICE: This message and any included attachments are from East Jefferson General Hospital, and is intended only for the addressee(s), and may include Protected Health (PHI) or other confidential information. If you are the intended recipient, you are obligated to maintain it in a secure and confidential manner and re-disclosure without additional consent or as permitted by law is prohibited. If you are not the intended recipient, use of this information is strictly prohibited and may be unlawful. Please promptly reply to the sender by email and delete this message from your computer. East Jefferson General Hospital greatly appreciates your cooperation. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: 5.4 performance issues
Hi Remco! What if you cannot restore a file? IBM will tell you to upgrade the client to a supported level, which you will do. Now you still cannot restore the file. Now IBM will tell you, well, the file was backed up with an unsupported client version. Bad luck... And also, most companies don't allow (and should not allow) using unsupported software usage in a production environment. I would not be surprised if using supported software levels is a requirement to be SOx compliant. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Remco Post Sent: maandag 17 maart 2008 19:33 To: ADSM-L@VM.MARIST.EDU Subject: Re: 5.4 performance issues Steve Roder wrote: Hi All, I wonder, with so many months passing since 5.4 has gone GA, and no usuable, secure 5.4 client, will IBM be extending support of 5.3? so let's look at that question. Support means that IBM will fix any problems you have in running the code. Since apperently, you have no problems running the latest 5.3 client, would you need support? With current performance issues you're better off running 5.3 'without' support that 5.4 or 5.5. If you ever run into problems, IBM will first ask you to upgrade to an supported client-level before thay will be able to help you with your problems. There is a saying in IT: 'Never f*ck with a running system', and that holds here as well. Don't upgrade a perfectly functioning client. It won't stop working on april 1st, really. We are in the process of testing 5.3.5.5, as it fixes the security issue in dsmcad, and does not have the preformance issues of 5.4.x. And then in less than 7 weeks, we will be unsupported. Steve Roder University at Buffalo ([EMAIL PROTECTED] | (716)645-3564) On Fri, 14 Mar 2008, Dave Canan wrote: IBM has had several customers reporting this performance issue after upgrading to level 5.4. APAR IC53531 was originally opened for this for the NetWare platform only. We are now also seeing the same issue for this APAR for customers on UNIX platforms as well. (However, this APAR does not apply to Windows platforms.) For Netware, the interim fix is 5.4.1.4. I do not have the date for the UNIX platforms yet. At 05:02 PM 3/14/2008 -0400, you wrote: Hi All, We recently upgraded the TSM clients on our cryus imap servers from 5.3.0.12 to 5.4.1.2 (and then 5.4.1.5), and since that upgrade, we have seen the backups of about 4.5million files in each of our 12 spools go from about 2.5 hours to approx. 4 days (had we let it run to completion). Anyone else seeing issues with 5.4.x on Solaris clients with millions of files? Other vitals: Server: 5.4.1.2 on AIX Network: GB Client OS Solaris 2.9 Filesystems are VxFS on an Hitachi 9960. We have opened a PMR with IBM, and they want to run some traces, but we have since reverted back to 5.3.0.12, and our 2.5hr backups. We need to run 5.4 to stay supported, and a minimum of 5.4.1.2 for the fix for the security issues in dsmcad, which we use for email restores on these systems. Thanks in advance for any insights anyone can provide. Steve Roder University at Buffalo ([EMAIL PROTECTED] | (716)645-3564) Dave Canan TSM Performance IBM Advanced Technical Support [EMAIL PROTECTED] -- Met vriendelijke groeten, Remco Post ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Upgrading TSM on an AIX server running multiple TSM instances
Hi Richard! In fact it does. Thank you very much! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: maandag 21 januari 2008 19:26 To: ADSM-L@VM.MARIST.EDU Subject: Re: Upgrading TSM on an AIX server running multiple TSM instances IBM Technote 1052631 is the best description. Richard Sims ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Upgrading TSM on an AIX server running multiple TSM instances
Hi *SM-ers! I'm running two TSM server instances on an AIX host. Upgrading them from 5.3 to 5.4.0.0 works fine. I installed the 5.4.0.0 code through smitty, changed the /usr/tivoli/tsm/server path to the second instance and install the 5.4.0.0 code here, using the force (-F) flag. Both instances are on 5.4.0.0 at that point. Now I'm trying the same trick for the upgrade to 5.4.2.0. Upgrading the first instance works fine, but since this is an update, the -F flage is not allowed by smitty during the upgrade of the second instance: Force Apply Failures The following is a list of fileset updates. Updates cannot be specified from the command line when the force flag (-F) is used in combination with the apply flag (-a). Maybe an AIX expert (and I now there are plenty of them on this list) can help me with this one? Thank you VERY much in advance Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TSM v5.5 feedback: problems? plusses?
Hi Timothy! The first 5.5 patch level has yet to be released, so my guess is we'll have to wait a while before seeing the first maintenance release... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: woensdag 16 januari 2008 14:54 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM v5.5 feedback: problems? plusses? Any hints as to when the first maintenance level will appear? Thanks Stapleton, Mark wrote: From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Just wanted to know if anyone's made the jump. We just got in a new server and will be moving from v5.3.1.2 to either 5.4 or 5.5. Just wanted to know what your thoughts were on migrating? The upgrades from 5.3.X upward should go smoothly. Follow the instructions in the relevant TSM server installation guide. The first maintenance level for TSM server 5.5 has yet to appear, and I NEVER install base code of anything in a production environment. 80% of bugs are in base code. In a similar vein, I NEVER install a patch level of TSM in a production environment unless I'm trying to fix a specific problem associated with that patch. Patches are not nearly as thoroughly tested as maintenance levels. In other words, you should be installing 5.4.2.0 on your TSM server. TSM server 5.3.X.X goes out of support on 30 April 2008. Use and abuse. -- Mark Stapleton CDW Berbee System engineer 7145 Boone Avenue North, Suite 140 Brooklyn Park MN 55428-1511 763-592-5963 www.berbee.com ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
TSM locked me out!!!!
Hi *SM-ers! After a long time I tried logging on to my test TSM server, but I couldn't. I canceled the server (kill -9) and started it in the foreground. It seemed to be related to an unexpected system date, so here is what I did: accept date ANR2017I Administrator SERVER_CONSOLE issued command: ACCEPT DATE ANR0894I Current system has been accepted as valid. TSM:AAR1 Ok, so now I enable the sessions again: enable sessions ANR2017I Administrator SERVER_CONSOLE issued command: ENABLE SESSIONS ANR2552I Server now enabled for Client access. TSM:AAR1 And I try connecting through the Windows Admin again: ANR0407I Session 5 started for administrator XI01EL (WinNT) (Tcp/Ip 171.21.240.138(1110)). ANR0420W Session 5 for node XI01EL (WinNT) refused - server disabled for user access. HUH?!?!?!? It's an admin session, so I always should be able to get in! Also, the server IS enabled according to the q status: q status ANR2017I Administrator SERVER_CONSOLE issued command: QUERY STATUS Storage Management Server for AIX-RS/6000 - Version 5, Release 3, Level 5.0 Server Name: AAR1 Server host name or IP address: Server TCP/IP port number: 1503 Server URL: .. Subfile Backup: No Availability: Enabled for Client sessions .. I'm lost! Anybody seen this before? Thanks in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TSM locked me out!!!!
Hi Hendrik! An 'enable sess all' did the trick! I forgot about this parameter... Thank you very much!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Henrik Wahlstedt Sent: donderdag 3 januari 2008 16:24 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM locked me out Hi Eric Try 'enable sess admin' or 'enable sess all'. //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: den 3 januari 2008 16:14 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM locked me out Hi *SM-ers! After a long time I tried logging on to my test TSM server, but I couldn't. I canceled the server (kill -9) and started it in the foreground. It seemed to be related to an unexpected system date, so here is what I did: accept date ANR2017I Administrator SERVER_CONSOLE issued command: ACCEPT DATE ANR0894I Current system has been accepted as valid. TSM:AAR1 Ok, so now I enable the sessions again: enable sessions ANR2017I Administrator SERVER_CONSOLE issued command: ENABLE SESSIONS ANR2552I Server now enabled for Client access. TSM:AAR1 And I try connecting through the Windows Admin again: ANR0407I Session 5 started for administrator XI01EL (WinNT) (Tcp/Ip 171.21.240.138(1110)). ANR0420W Session 5 for node XI01EL (WinNT) refused - server disabled for user access. HUH?!?!?!? It's an admin session, so I always should be able to get in! Also, the server IS enabled according to the q status: q status ANR2017I Administrator SERVER_CONSOLE issued command: QUERY STATUS Storage Management Server for AIX-RS/6000 - Version 5, Release 3, Level 5.0 Server Name: AAR1 Server host name or IP address: Server TCP/IP port number: 1503 Server URL: ... Subfile Backup: No Availability: Enabled for Client sessions ... I'm lost! Anybody seen this before? Thanks in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TSM locked me out!!!!
Hi Richard! Thank you very much for your reply! I checked the technote an it suggests issuing the accept date and enable sess commands, but how can one issue these commands when one cannot get in? I will use the standard kill for the other servers, but I remember that it does not always kill the server... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: donderdag 3 januari 2008 16:37 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM locked me out On Jan 3, 2008, at 10:13 AM, Loon, E.J. van - SPLXM wrote: Hi *SM-ers! After a long time I tried logging on to my test TSM server, but I couldn't. I canceled the server (kill -9) and started it in the foreground. General Unix advice: Always do a simple 'kill PID' on a process (which is equivalent to 'kill -TERM PID'), which gives the process the opportunity to exit cleanly. 'kill -9' is a SIGKILL, which cannot be intercepted by the process, so clean termination cannot be performed, which can result in bad stuff (technical term). It seemed to be related to an unexpected system date... See IBM Technote 1142353 (which doesn't take into account 5.3 changes to the ENable SESSions command: I've submitted feedback on that Technote). Richard Sims ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Strange difference between Primary and Copypool
Hi Larry! Aparently... We don't use collocation (see my erlier post to Helder today). Here is the output from the q devclass: Device DeviceStorageDevice Format Est/Max Mount ClassAccess PoolType Capacity Limit Name StrategyCount (MB) --------- -- DISK Random 1 LTO_CPY Sequential 1LTO DRIVE DRIVES LTO_PRI Sequential 1LTO DRIVE DRIVES And this is the output from your SQL's: select stgpool_name,status,count(*) TOTAL from volumes where scratch='YES' group by stgpool_name, status STGPOOL_NAME STATUS TOTAL -- -- --- DL_LBU3_CPY_1 FILLING 15 DL_LBU3_CPY_1 FULL 395 DL_LBU3_CPY_1 PENDING 26 DL_LBU3_PRI_1 FILLING 23 DL_LBU3_PRI_1 FULL 292 DL_LBU3_PRI_1 PENDING 22 select library_name, last_use, status, count(status) from libvolumes group by library_name,last_use,status LIBRARY_NAME LAST_USE STATUS Unnamed[4] -- -- -- --- DL_LBU3_CPY_1 Scratch 30 DL_LBU3_CPY_1 Data Private411 DL_LBU3_PRI_1 Private 1 DL_LBU3_PRI_1 Scratch102 DL_LBU3_PRI_1 Data Private337 DL_LBU3_PRI_1 DbBackup Private 1 I still cannot explain the difference. I know for sure that storage pools, device classes and virtual tapes are configured equally. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Larry Peifer Sent: woensdag 12 december 2007 19:24 To: ADSM-L@VM.MARIST.EDU Subject: Re: Strange difference between Primary and Copypool Eric - It looks like your system is storing about the same amount of data, 26TB / 27TB, as our system is but I notice that you are using over 300 more LTO2 tapes to store it on. Is that correct? Are you using collocation? What does 'q collocgroup' show? Also, what format are you using for the tape device class? q devclass I find these queries helpful to monitor on a daily basis now that I'm tracking tape issues for IBM PMRs related to our particular issue. select stgpool_name,status,count(*) TOTAL from volumes where scratch='YES' group by stgpool_name, status STGPOOL_NAME STATUS TOTAL TAPEPOOL6 FILLING 5 TAPEPOOL6 FULL 95 TAPEPOOL6 PENDING 8 TAPEPOOL7 FILLING 5 TAPEPOOL7 FULL 102 TAPEPOOL7 PENDING 6 select library_name, last_use, status, count(status) from libvolumes group by library_name,last_use,status LIBRARY_NAME LAST_USE STATUS Unnamed[4] LTOLIB6 Scratch 20 LTOLIB6 DataPrivate108 LTOLIB7 Scratch 11 LTOLIB7 DataPrivate114 LTOLIB7 DbBackupPrivate 3 Larry Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 12/12/2007 05:05 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] Strange difference between Primary and Copypool Hi Larry! We are using EMC DL700 disk libraries which emulate several 3584 libraries with LTO2 tapes. Personally, I find the difference between primary and copy pool tape count in your shop not as shocking as mine though... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Larry Peifer Sent: dinsdag 11 december 2007 23:04 To: ADSM-L@VM.MARIST.EDU Subject: Re: Strange difference between Primary and Copypool Eric, I'm interested in learning more about the particulars of your environment. We have been experiencing some odd behavior with our tape pools after recently upgrading the TSM server to 5.4.0 and the Clients (Windows and Unix) to 5.4.1 clients. We also have a primary tape pool library with a copy pool tape library as an electronic vault. Also, what tape library hardware and tape media are you using? We have IBM 3584 libraries with LTO2 drives and LTO2 tapes using Ultrium2C device type. Our usage is similar
Re: Strange difference between Primary and Copypool
Hi Larry! We are using EMC DL700 disk libraries which emulate several 3584 libraries with LTO2 tapes. Personally, I find the difference between primary and copy pool tape count in your shop not as shocking as mine though... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Larry Peifer Sent: dinsdag 11 december 2007 23:04 To: ADSM-L@VM.MARIST.EDU Subject: Re: Strange difference between Primary and Copypool Eric, I'm interested in learning more about the particulars of your environment. We have been experiencing some odd behavior with our tape pools after recently upgrading the TSM server to 5.4.0 and the Clients (Windows and Unix) to 5.4.1 clients. We also have a primary tape pool library with a copy pool tape library as an electronic vault. Also, what tape library hardware and tape media are you using? We have IBM 3584 libraries with LTO2 drives and LTO2 tapes using Ultrium2C device type. Our usage is similar to you: Storagepool MB TAPEPOOL629154145.05Primary TAPEPOOL728563583.89Copy Seq. Stg. Pool Volumes in Use TAPEPOOL6 106 TAPEPOOL7 112 (includes 4 DBBackup tapes) We have several PMR's (3584 h/w and TSM s/w) open with IBM regarding a large increase in # of tapes used to hold our data after making the upgrade. Andy Huebner [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 12/11/2007 09:29 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] Strange difference between Primary and Copypool I would say it is normal to have a little more data in the primary pool due to on-going backups. We have backups running all the time. Since the primary and copy tapes are created differently I am not surprised that there is a different number of tapes. Has there always been more copy than primary tapes? I would think the tape count could swing the other way. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Tuesday, December 11, 2007 8:05 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Strange difference between Primary and Copypool Hi Jim! My copy pool is an online copy pool. Tapes (in fact virtual tapes) are not checked out, nor removed from the (virtual) library. I didn't state that my copy pool is larger than the primary pool (hence my line although the copy pool (DL_LBU3_CPY_1) contains less data, it uses more tapes!!!) and I also stated that both storage pools are reclaimed at 60%... On a daily bases.. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jim Young Sent: dinsdag 11 december 2007 14:26 To: ADSM-L@VM.MARIST.EDU Subject: Re: Strange difference between Primary and Copypool Hi My theory works if the following is true. 1) the copy pool is offsite. 2) your statement that the copy pool is larger than the primary pool was incorrect. Its the other way round looing at the numbers given. Original sizings Storagepool MB -- - DL_LBU3_CPY_1 26489427.98 DL_LBU3_PRI_1 27658559.10 As the tapes onsite (in the library) can be mounted over and over again putting new data at the end of the volume until full, you have a non-tape wasting process, BUT The offsite tapes are created and then shipped offsite. The offsite tapes can only be recreated from onsite data and as such, unless they trigger the 60% free reclamation they will sit there until 40% utilized, never defraging, just taking up lots of your lovely tapes. Additional waste can be caused by collocation as well. Not knowing if that is used for nodes in this pool i cannot comment. Plus we don't know the size of files you are backing up against the size of the tapes. ie. a 36Gb database file on a 40Gb DLT holds 90% of the tape. I find this SQL useful for identifying tapes that get stuck and not reclaimed. select volume_name, stgpool_name,pct_utilized, status from volumes - where pct_utilized 40 and stgpool_name 'DISKPOOL' - order by pct_utilized, stgpool_name, volume_name Cheers Jim Cattles plc Registered in England No: 543610 Kingston House, Centre 27 Business Park, Woodhead Road, Birstall, Batley, WF179TD. The views and opinions expressed herein are those of the author and not of Cattles plc or any of its subsidiaries.The content of this e-mail is confidential, may contain privileged material and is intended solely for the recipient(s) named above. If you receive this in error, please notify the sender immediately and delete this e-mail. Please note that neither Cattles plc nor the sender accepts any
Re: Strange difference between Primary and Copypool
Hi Andy! I have 3 servers (LBU1, LBU2 and LBU3) running. Checkout their private volume count: DL_LBU1_CPY_1 Private 634 DL_LBU1_PRI_1 Private 643 DL_LBU2_CPY_1 Private 561 DL_LBU2_PRI_1 Private 564 DL_LBU3_CPY_1 Private 441 DL_LBU3_PRI_1 Private 366 Notice that the figures on LBU1 and 2 look fine (the private volume count on the primary pool is slightly larger than the copypool count) but on the amount of private volumes for the copy pool of the LBU3 server is much (more than 20%!!) higher! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andy Huebner Sent: dinsdag 11 december 2007 18:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: Strange difference between Primary and Copypool I would say it is normal to have a little more data in the primary pool due to on-going backups. We have backups running all the time. Since the primary and copy tapes are created differently I am not surprised that there is a different number of tapes. Has there always been more copy than primary tapes? I would think the tape count could swing the other way. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Tuesday, December 11, 2007 8:05 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Strange difference between Primary and Copypool Hi Jim! My copy pool is an online copy pool. Tapes (in fact virtual tapes) are not checked out, nor removed from the (virtual) library. I didn't state that my copy pool is larger than the primary pool (hence my line although the copy pool (DL_LBU3_CPY_1) contains less data, it uses more tapes!!!) and I also stated that both storage pools are reclaimed at 60%... On a daily bases.. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jim Young Sent: dinsdag 11 december 2007 14:26 To: ADSM-L@VM.MARIST.EDU Subject: Re: Strange difference between Primary and Copypool Hi My theory works if the following is true. 1) the copy pool is offsite. 2) your statement that the copy pool is larger than the primary pool was incorrect. Its the other way round looing at the numbers given. Original sizings Storagepool MB -- - DL_LBU3_CPY_1 26489427.98 DL_LBU3_PRI_1 27658559.10 As the tapes onsite (in the library) can be mounted over and over again putting new data at the end of the volume until full, you have a non-tape wasting process, BUT The offsite tapes are created and then shipped offsite. The offsite tapes can only be recreated from onsite data and as such, unless they trigger the 60% free reclamation they will sit there until 40% utilized, never defraging, just taking up lots of your lovely tapes. Additional waste can be caused by collocation as well. Not knowing if that is used for nodes in this pool i cannot comment. Plus we don't know the size of files you are backing up against the size of the tapes. ie. a 36Gb database file on a 40Gb DLT holds 90% of the tape. I find this SQL useful for identifying tapes that get stuck and not reclaimed. select volume_name, stgpool_name,pct_utilized, status from volumes - where pct_utilized 40 and stgpool_name 'DISKPOOL' - order by pct_utilized, stgpool_name, volume_name Cheers Jim Cattles plc Registered in England No: 543610 Kingston House, Centre 27 Business Park, Woodhead Road, Birstall, Batley, WF179TD. The views and opinions expressed herein are those of the author and not of Cattles plc or any of its subsidiaries.The content of this e-mail is confidential, may contain privileged material and is intended solely for the recipient(s) named above. If you receive this in error, please notify the sender immediately and delete this e-mail. Please note that neither Cattles plc nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments(if any). No contracts or agreements may be concluded on behalf of Cattles plc or its subsidiaries by means of email communications. This message has been scanned for Viruses by Cattles and Sophos Puremessage scanning service. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its
Re: Strange difference between Primary and Copypool
Hi Helder! I'm 100% sure reclamation is set to 60% on all storage pools on all servers. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Helder Garcia Sent: woensdag 12 december 2007 12:43 To: ADSM-L@VM.MARIST.EDU Subject: Re: Strange difference between Primary and Copypool Larry, DB backup tapes does not belong to any particular storage pool. Anyway, your environment shows more acceptable numbers than Eric's. A little delta (106 to 112) in the number of tapes is always present due to reclamation running in different moments, incomplete expiration processes an other factors. Eric, are you sure you don't have different collocation settings on the storage pools? On Dec 11, 2007 8:04 PM, Larry Peifer [EMAIL PROTECTED] wrote: Eric, I'm interested in learning more about the particulars of your environment. We have been experiencing some odd behavior with our tape pools after recently upgrading the TSM server to 5.4.0 and the Clients (Windows and Unix) to 5.4.1 clients. We also have a primary tape pool library with a copy pool tape library as an electronic vault. Also, what tape library hardware and tape media are you using? We have IBM 3584 libraries with LTO2 drives and LTO2 tapes using Ultrium2C device type. Our usage is similar to you: Storagepool MB TAPEPOOL629154145.05 Primary TAPEPOOL728563583.89Copy Seq. Stg. Pool Volumes in Use TAPEPOOL6 106 TAPEPOOL7 112 (includes 4 DBBackup tapes) We have several PMR's (3584 h/w and TSM s/w) open with IBM regarding a large increase in # of tapes used to hold our data after making the upgrade. Andy Huebner [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 12/11/2007 09:29 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] Strange difference between Primary and Copypool I would say it is normal to have a little more data in the primary pool due to on-going backups. We have backups running all the time. Since the primary and copy tapes are created differently I am not surprised that there is a different number of tapes. Has there always been more copy than primary tapes? I would think the tape count could swing the other way. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Tuesday, December 11, 2007 8:05 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Strange difference between Primary and Copypool Hi Jim! My copy pool is an online copy pool. Tapes (in fact virtual tapes) are not checked out, nor removed from the (virtual) library. I didn't state that my copy pool is larger than the primary pool (hence my line although the copy pool (DL_LBU3_CPY_1) contains less data, it uses more tapes!!!) and I also stated that both storage pools are reclaimed at 60%... On a daily bases.. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jim Young Sent: dinsdag 11 december 2007 14:26 To: ADSM-L@VM.MARIST.EDU Subject: Re: Strange difference between Primary and Copypool Hi My theory works if the following is true. 1) the copy pool is offsite. 2) your statement that the copy pool is larger than the primary pool was incorrect. Its the other way round looing at the numbers given. Original sizings Storagepool MB -- - DL_LBU3_CPY_1 26489427.98 DL_LBU3_PRI_1 27658559.10 As the tapes onsite (in the library) can be mounted over and over again putting new data at the end of the volume until full, you have a non-tape wasting process, BUT The offsite tapes are created and then shipped offsite. The offsite tapes can only be recreated from onsite data and as such, unless they trigger the 60% free reclamation they will sit there until 40% utilized, never defraging, just taking up lots of your lovely tapes. Additional waste can be caused by collocation as well. Not knowing if that is used for nodes in this pool i cannot comment. Plus we don't know the size of files you are backing up against the size of the tapes. ie. a 36Gb database file on a 40Gb DLT holds 90% of the tape. I find this SQL useful for identifying tapes that get stuck and not reclaimed. select volume_name, stgpool_name,pct_utilized, status from volumes - where pct_utilized 40 and stgpool_name 'DISKPOOL' - order by pct_utilized, stgpool_name, volume_name Cheers Jim Cattles plc Registered in England No: 543610 Kingston House, Centre 27 Business Park, Woodhead Road
Strange difference between Primary and Copypool
Hi *SM-ers! I found something very strange on one of my TSM servers. When I issue the following command: select stgpool_name as Storagepool,sum(physical_mb) as MB from occupancy group by stgpool_name I recieve the following output: Storagepool MB -- - DL_LBU3_CPY_1 26489427.98 DL_LBU3_PRI_1 27658559.10 However, when I issue the following SQL statement: select stgpools.stgpool_name as Seq. Storage Pool, count(volumes.stgpool_name) as Volumes in Use from stgpools,volumes where (stgpools.stgpool_name = volumes.stgpool_name) and (stgpools.devclass 'DISK') group by stgpools.stgpool_name I receive the following output: Seq. Storage Pool Volumes in Use -- -- DL_LBU3_CPY_1 425 DL_LBU3_PRI_1 356 So, although the copypool (DL_LBU3_CPY_1) contains less data, it uses more tapes!!! The tape size is identical, reclaim runs fine (60% for both storagepools) and reuse delay is identical too. I'm lost here... Does anybody have any idea why the copypool uses more volumes volumes than the primary pool? Thank you very much for any reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Strange difference between Primary and Copypool
Hi Jim! My copy pool is an online copy pool. Tapes (in fact virtual tapes) are not checked out, nor removed from the (virtual) library. I didn't state that my copy pool is larger than the primary pool (hence my line although the copy pool (DL_LBU3_CPY_1) contains less data, it uses more tapes!!!) and I also stated that both storage pools are reclaimed at 60%... On a daily bases.. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jim Young Sent: dinsdag 11 december 2007 14:26 To: ADSM-L@VM.MARIST.EDU Subject: Re: Strange difference between Primary and Copypool Hi My theory works if the following is true. 1) the copy pool is offsite. 2) your statement that the copy pool is larger than the primary pool was incorrect. Its the other way round looing at the numbers given. Original sizings Storagepool MB -- - DL_LBU3_CPY_1 26489427.98 DL_LBU3_PRI_1 27658559.10 As the tapes onsite (in the library) can be mounted over and over again putting new data at the end of the volume until full, you have a non-tape wasting process, BUT The offsite tapes are created and then shipped offsite. The offsite tapes can only be recreated from onsite data and as such, unless they trigger the 60% free reclamation they will sit there until 40% utilized, never defraging, just taking up lots of your lovely tapes. Additional waste can be caused by collocation as well. Not knowing if that is used for nodes in this pool i cannot comment. Plus we don't know the size of files you are backing up against the size of the tapes. ie. a 36Gb database file on a 40Gb DLT holds 90% of the tape. I find this SQL useful for identifying tapes that get stuck and not reclaimed. select volume_name, stgpool_name,pct_utilized, status from volumes - where pct_utilized 40 and stgpool_name 'DISKPOOL' - order by pct_utilized, stgpool_name, volume_name Cheers Jim Cattles plc Registered in England No: 543610 Kingston House, Centre 27 Business Park, Woodhead Road, Birstall, Batley, WF179TD. The views and opinions expressed herein are those of the author and not of Cattles plc or any of its subsidiaries.The content of this e-mail is confidential, may contain privileged material and is intended solely for the recipient(s) named above. If you receive this in error, please notify the sender immediately and delete this e-mail. Please note that neither Cattles plc nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments(if any). No contracts or agreements may be concluded on behalf of Cattles plc or its subsidiaries by means of email communications. This message has been scanned for Viruses by Cattles and Sophos Puremessage scanning service. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Sizing virtual tapes
I agree with John. We are currently using 100Gb. volumes in out DL700, but I'm frequently called by user who's restore seems to hang. In most cases the tape is in use by another restore or in use by a backup storagepool/reclamation which first has to finish the file it's backing up or reclaiming. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Schneider, John Sent: donderdag 29 november 2007 15:55 To: ADSM-L@VM.MARIST.EDU Subject: Re: Sizing virtual tapes David, Your question is a good one. On our EMC Disk Libraries we emulate LTO1 tape drives, with 50GB maximum tapes. I believe this improves overall disk utilization for just the reason you mention. You can reclaim the smaller tapes sooner. TSM won't have to wait until ~250GB of data, which may have been written over a period of weeks, expires before the virtual tape is ready to reclaim. Best Regards, John D. Schneider Lead Systems Administrator - Storage Sisters of Mercy Health Systems Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: Thursday, November 29, 2007 8:01 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Sizing virtual tapes How large are you making the max size of your virtual tapes? Why? I let my TS7520 emulating 3592E tapes default to a max size of 460GB but I'm starting to think a smaller size would make more sense. The median size of occupancy for my nodes is around 40GB so I'm thinking that might be a better max size to facilicate reclamination. David ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server full backup failure
Hi Del! I asked our SQL guy to send me his tdpsql.cfg file. It contains the following: BUFFers 3 BUFFERSIze 1024 FROMSQLserver KL109FLE SQLAUTHentication INTegrated SQLBUFFers 0 SQLBUFFERSIze 1024 SQLSERVer KL109FLE STRIPes 1 LOGFile tdpsql.log LOGPrune 60 MOUNTWaitfordata Yes DIFFESTimate 20 LASTPRUNEDate 11/28/2007 01:00:15 LANGuage ENU So it looks like all parameters are already set to the values you suggested. I guess I will have to open a call at support then... Thanks for your help! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 27 november 2007 15:55 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server full backup failure These commands will do the trick: tdpsqlc set BUFFERS=3 tdpsqlc set BUFFERSIZE=1024 tdpsqlc set SQLBUFFERS=0 tdpsqlc set SQLBUFFERSIZE=1024 tdpsqlc set STRIPES=1 You can also set them through the DP/SQL GUI Edit--Configuration. Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 11/27/2007 09:30:12 AM: Hi Del! Thank you very much for your reply!!! I assume these paramaters all have to be specified in the TDP option file? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 27 november 2007 12:40 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server full backup failure Hi Eric, You didn't give any details about the BUFFERS, BUFFERSIZE, SQLBUFFERS, SQLBUFFERSIZE, or STRIPES that you are using. I would start by setting BUFFERS 3 BUFFERSIZE 1024 SQLBUFFERS 0 SQLBUFFERSIZE 1024 STRIPES 1 to see if that helps at all. If not, I suggest that you place a call with IBM Support. This one may need a trace and help from support to solve. Thanks, Del ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
DP for SQL Server full backup failure
Hi TSM-ers! One of our SQL Server 2005 (running DP for SQL Server 5.3.3.0) the full backup fails every time. In the tdpsql.log we see the following messages: 11/23/2007 02:26:44 ACO5436E A failure occurred on stripe number (0), rc = 428 11/23/2007 02:26:44 ACO5407E The SQL server aborted the operation. 11/23/2007 02:26:44 Backup of InTrust_Audit_DB failed. 11/23/2007 02:26:44 ACO5422E Received the following from the MS SQL server: 11/23/2007 02:26:44 [Microsoft][ODBC SQL Server Driver][SQL Server]A nonrecoverable I/O error occurred on file TDPSQL-026C-: 995(The I/O operation has been aborted because of either a thread exit or an application request.). 11/23/2007 02:26:44 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040cc7) Does anyone know what could be the cause? Google-ing for 0x80040cc7 returns one hit. Someone posted the exact same error on a forum, but did not receive a solution... Thanks in advance for any reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server full backup failure
Hi Del! Thank you very much for your reply!!! I assume these paramaters all have to be specified in the TDP option file? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 27 november 2007 12:40 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server full backup failure Hi Eric, You didn't give any details about the BUFFERS, BUFFERSIZE, SQLBUFFERS, SQLBUFFERSIZE, or STRIPES that you are using. I would start by setting BUFFERS 3 BUFFERSIZE 1024 SQLBUFFERS 0 SQLBUFFERSIZE 1024 STRIPES 1 to see if that helps at all. If not, I suggest that you place a call with IBM Support. This one may need a trace and help from support to solve. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 11/27/2007 04:22:28 AM: Hi TSM-ers! One of our SQL Server 2005 (running DP for SQL Server 5.3.3.0) the full backup fails every time. In the tdpsql.log we see the following messages: 11/23/2007 02:26:44 ACO5436E A failure occurred on stripe number (0), rc = 428 11/23/2007 02:26:44 ACO5407E The SQL server aborted the operation. 11/23/2007 02:26:44 Backup of InTrust_Audit_DB failed. 11/23/2007 02:26:44 ACO5422E Received the following from the MS SQL server: 11/23/2007 02:26:44 [Microsoft][ODBC SQL Server Driver][SQL Server]A nonrecoverable I/O error occurred on file TDPSQL-026C-: 995(The I/O operation has been aborted because of either a thread exit or an application request.). 11/23/2007 02:26:44 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040cc7) Does anyone know what could be the cause? Google-ing for 0x80040cc7 returns one hit. Someone posted the exact same error on a forum, but did not receive a solution... Thanks in advance for any reply!!! Kindest regards, Eric van Loon ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server mirroring
Hoi Del! I understand that using the same TSM node for backing up the Principal and the new Principal after a take-over is a solution. So: if ServerA is the principal, one has to execute the backup script on this server. After a take-over, ServerB becomes the principal and one has to execute the backup script (using the same TSM nodename) on ServerB. If I understand you correctly, one has to use external tools to determine which server (ServerA of ServerB) is the current Principal? Thanks again!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: woensdag 14 november 2007 13:36 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server mirroring As Steve suggested, test out your scenario using a common nodename. However, you will need to be careful because both servers will have common databases (like master and msdb)... and you do not want those backups for different servers to get mixed in with each other. You could have a separate line in the backup script on both machines that backs up the mirrored database on both servers (and point to a similar DSM.OPT file) knowing that the backup on the Mirror machine will fail. You can also look into Proxy Node. It allows one node to store data on behalf of another node if the correct permissions are granted from the TSM Server side. There are probably a number of other ways to get your desired result. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 11/14/2007 04:49:03 AM: Hi Del! Let's say ServerA is the Principal and ServerB is the Mirror. Normally you would schedule a DP backup on ServerA. The (mirror-)database on ServerB is running in a state which doesn't allow backing up (restore mode?) Now there is a take-over and ServerB becomes the new Principal. Now you will have to start backing up the database on ServerB. And if everything is switched back to normal, you will be stuck with backups on the ServerB DP node which never expire, since the backup is running on ServerA again. I hope I made myself a little bit more clear? Again, thank you very much for your reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server mirroring
Hi Del! I think our SQL guys will go for the second solution. We use a third-party scheduling tool (Control-M) and failing backups will create a problem report. I will forward your suggestion to them. Again, thank you very much for your reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: donderdag 15 november 2007 13:22 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server mirroring I don't think you need an external tool. The two ways I can think of are just to run the backup on both nodes, knowing that the backup will fail on the secondary node and succeed on the primary node. Or... in the script, you can use an osql command to query the database state and execute the backup only if the database is online. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 11/15/2007 05:33:01 AM: Hoi Del! I understand that using the same TSM node for backing up the Principal and the new Principal after a take-over is a solution. So: if ServerA is the principal, one has to execute the backup script on this server. After a take-over, ServerB becomes the principal and one has to execute the backup script (using the same TSM nodename) on ServerB. If I understand you correctly, one has to use external tools to determine which server (ServerA of ServerB) is the current Principal? Thanks again!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server mirroring
Hi Del! Let's say ServerA is the Principal and ServerB is the Mirror. Normally you would schedule a DP backup on ServerA. The (mirror-)database on ServerB is running in a state which doesn't allow backing up (restore mode?) Now there is a take-over and ServerB becomes the new Principal. Now you will have to start backing up the database on ServerB. And if everything is switched back to normal, you will be stuck with backups on the ServerB DP node which never expire, since the backup is running on ServerA again. I hope I made myself a little bit more clear? Again, thank you very much for your reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 13 november 2007 16:28 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server mirroring There is nothing built into DP for SQL that does that, but I am still trying to understand what the issue is. If you have an automated schedule to back up ALL databases (*) that are active on any given SQL Server instance, it will find that the Principal database is running on the second instance, and back it up from there. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 11/13/2007 10:07:25 AM: Hi Del! I just spoke with the SQL guy and his question is a little bit more clear to me now. The database is running on the Principal and a copy is running on the Mirror. The database is backed up on the Principal. After a take-over the Mirror becomes the new Principal, so the backup should be backed up on another physical Windows node. The only one who knows about the take-over is the Witness, so for the backup application to know on which Windows node to execute the backup, he should talk to the Witness. My SQL guy actually wants to know how he can assure that the backup continues on the other node after a take-over. Thanks again in advance for you reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
DP for SQL Server mirroring
Hi TSM-ers! One of my SQL colleagues asks me whether DP for SQL Server supports the SQL Server 2005 Database Mirroring feature. My first thought was to check the manual Data Protection for Microsoft SQL Server Installation and User's Guide Version 5 release 2, but the word mirroring isn't mentioned once... Thank you very much for your reply in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server mirroring
Hi Del! Thank you very much for your reply! I thought this was a feature which the backup software should be aware of, but apparently not (I'm the TSM Server guru ;-) and definitely not the TDP guru, you know). I will forward your answer to our SQL guys. Thanks again! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 13 november 2007 14:56 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server mirroring In what respect do you mean support? The backup application is not involved with the transfer of the log records with SQL Server mirroring. The SQL Server manages that. I normally point customers to the Microsoft documentation: http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx Where it says things like You must make a backup of the database... and ...restore of the principal database with NORECOVERY, ... customers use Data Protection for SQL to perform those operations. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 11/13/2007 07:38:21 AM: Hi TSM-ers! One of my SQL colleagues asks me whether DP for SQL Server supports the SQL Server 2005 Database Mirroring feature. My first thought was to check the manual Data Protection for Microsoft SQL Server Installation and User's Guide Version 5 release 2, but the word mirroring isn't mentioned once... Thank you very much for your reply in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server mirroring
Hi Del! I just spoke with the SQL guy and his question is a little bit more clear to me now. The database is running on the Principal and a copy is running on the Mirror. The database is backed up on the Principal. After a take-over the Mirror becomes the new Principal, so the backup should be backed up on another physical Windows node. The only one who knows about the take-over is the Witness, so for the backup application to know on which Windows node to execute the backup, he should talk to the Witness. My SQL guy actually wants to know how he can assure that the backup continues on the other node after a take-over. Thanks again in advance for you reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 13 november 2007 14:56 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server mirroring In what respect do you mean support? The backup application is not involved with the transfer of the log records with SQL Server mirroring. The SQL Server manages that. I normally point customers to the Microsoft documentation: http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx Where it says things like You must make a backup of the database... and ...restore of the principal database with NORECOVERY, ... customers use Data Protection for SQL to perform those operations. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 11/13/2007 07:38:21 AM: Hi TSM-ers! One of my SQL colleagues asks me whether DP for SQL Server supports the SQL Server 2005 Database Mirroring feature. My first thought was to check the manual Data Protection for Microsoft SQL Server Installation and User's Guide Version 5 release 2, but the word mirroring isn't mentioned once... Thank you very much for your reply in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Cannot add server to TSMReporter
Hi *SM-ers! I'm trying to add a new TSM server to the TSM Operational Reporter, but when I right-click the tree, the Add a New TSM Server option is grayed out... Does anybody know what could be causing this? Thank you very much in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
DP for SQL Server manual
Hi *SM-ers! When I visit the IBM Information Center website and select the Tivoli Storage Manager for Database 5.4 set, I only see a Data Protection for SQL Server manual, version 5.2. DP for SQL Server 5.3 has been around for a while, hasn't it? Does anybody know where to find a more recent DP for SQL manual? Thank you very much for your reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server manual
Hi Del! Hmm... This manual is dated September 2003 and doesn't mention a word about how to handle SQL Server 2005 database mirroring. Is there a white paper about how to backup a SQL Server 2005 with database mirroring? Thank you very much for your reply Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 10 juli 2007 14:33 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server manual Eric, The latest Data Protection for SQL User's Guide is labeled 5.2. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 07/10/2007 03:36:27 AM: Hi *SM-ers! When I visit the IBM Information Center website and select the Tivoli Storage Manager for Database 5.4 set, I only see a Data Protection for SQL Server manual, version 5.2. DP for SQL Server 5.3 has been around for a while, hasn't it? Does anybody know where to find a more recent DP for SQL manual? Thank you very much for your reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server manual
Hi Del! I will forward this information to our SQL guys. Thank you very much for your reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 10 juli 2007 15:43 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server manual Hi Eric, September 2003 is the correct date for that User's Guide. It was the last time a major release was put out for Data Protection for SQL. And you are correct... SQL Server 2005 is not mentioned in there. Maybe because it wasn't available yet? :-) The SQL Server 2005 support was added as a fixtest on top of 5.2.1. The Data Protection for SQL x64 support was a new package that basically was the 5.2.1 version of the code rebuilt on x64. It was called 5.3.3 because that was the timeframe of the other releases going out at that time. Currently, there are no whitepapers or documentation in regards to database mirroring. We normally point customers to the Microsoft documentation, for example: http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx Then, where it says things like ...restore of the principal database with NORECOVERY, ... customers use Data Protection for SQL to perform those operations. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 07/10/2007 09:24:18 AM: Hi Del! Hmm... This manual is dated September 2003 and doesn't mention a word about how to handle SQL Server 2005 database mirroring. Is there a white paper about how to backup a SQL Server 2005 with database mirroring? Thank you very much for your reply Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
SQL 2005 Database mirroring
Hi *SM-ers! One of our SQL guys asked me whether TDP for Databases supports SQL 2005 Database Mirroring. I don't know any technical details about this feature (I'm 'just' a TSM admin;-) but he says it's a SQL Server 2005 (64-bit) with a principal and a passive mirror server, which is running in a restore mode... Does anybody know which DP for SQL Server release supports this kind of configuration? Thank you very much for your help in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: How to change the default idle timeout for dismounting volumes
Hi William! UPDate DEVclass deviceclassname MOUNTRetention=amount of minutes Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of William Kyndt Sent: vrijdag 15 juni 2007 15:20 To: ADSM-L@VM.MARIST.EDU Subject: How to change the default idle timeout for dismounting volumes Hi, We are currently running TSM version 5.3.2 and using a 3584 library. We have a script that runs daily to eject our offsite volumes to the IO Station, however at times it fails to run correctly because all drives are busy. However when performing a q mount we can see that some of the volumes are no longer been used and are sitting idle. Does anyone know how to change the default idle time which appears to be 60 minutes before the volume is dismounted? Many thanks. William ** The Miller Group Limited - Registered in Scotland - SC018135 Miller Homes Limited - Registered in Scotland - SC255429 Miller Construction (UK) Limited - Registered in Scotland - SC209666 Miller Developments Limited - Registered in Scotland - SC178108 2 Lochside View Edinburgh Park Edinburgh EH12 9DH Disclaimer: The Information in this e-mail is confidential and for use by the addressee(s) only. It may also be privileged. If you are not the intended recipient please notify us immediately on +44 (0) 870 336 5060 and delete the message from your computer: you may not copy or forward it, or use or disclose its contents to any other person. We do not accept any liability or responsibility for: (1) changes made to this email after it was sent, or (2) viruses transmitted through this email or any attachment. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TSM DB Restore
Hi! You probbably have no mount points available. Checkout technote 1083695: http://www-1.ibm.com/support/docview.wss?rs=663context=SSGSG7uid=swg21 083695loc=en_UScs=utf-8lang=en Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of TSM User Sent: woensdag 4 april 2007 16:54 To: ADSM-L@VM.MARIST.EDU Subject: TSM DB Restore Hello out there, I'm trying to restore my production TSM database which was running on a Win2K server on to my dev server running Win2K3 and I get the following error: C:\Tivoli\tsm\serverdsmserv restore db todate=04/03/2007 totime=12:21 ANR0900I Processing options file c:\tivoli\tsm\server1\dsmserv.opt. ANR7800I DSMSERV generated at 11:34:40 on Sep 27 2005. Tivoli Storage Manager for Windows Version 5, Release 3, Level 2.0 Licensed Materials - Property of IBM (C) Copyright IBM Corporation 1990, 2004. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR4726I The ICC support module has been loaded. ANR8200I TCP/IP driver ready for connection with clients on port 1500. ANR0200I Recovery log assigned capacity is 2048 megabytes. ANR0201I Database assigned capacity is 2048 megabytes. ANR4600I Processing volume history file volhist.out. ANR8880W Device type of drive GENDRV_0.0.5 in library LTOLIB1 was determined to be GENERIC_TAPE. ANR4620I Database backup series 8 operation 0 device class HPLTO. ANR4622I Volume 1: TAPE06. ANR4634I Starting point-in-time database restore to date 04/03/2007 12:21:00. ANR0300I Recovery log format started; assigned capacity 2048 megabytes. ANRD icrest.c(2079): ThreadId0 Rc=33 reading header record. ANRD ThreadId0 issued message from: -10587268 outDiagf()+168 -0012C398 Unknown -44393939 Unknown ANR0301I Recovery log format in progress; 4 megabytes of 2048. ANR2032E RESTORE DB: Command failed - internal server error detected. ANRD ThreadId0 issued message 2032 from: -10586D80 outMsgf()+20 -10064525 AdmRestoreDb()+1695 -1000 DllMain()+ -0041 UnknownA NR1792W HBAAPI vendor library failed to load or is missing. TSM Server 5.3.2 Any ideas? ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Ramifications of delete vol xxxxxx discardd=y
Well... Only if the tape contains data from a BA client. If the tape contains TOP data, you will have to reschedule a full database backup for that client. If you have a read-only tape you should check the tape by moving it's data to a new tape, using the MOVE DATA command. If it fails, you can try a restore of the volume from your copypool. If that fails too (because the volume contains files which aren't backed up to your copypool because of read errors) you will have to do an AUDIT VOLUME PREVIEW=YES to see which files are damaged. A Q CONT damaged=yes will show you the damaged files. If the damaged files are all BA client files, you can fix the tape by running an AUDIT VOLUME again without the preview, followed by again a MOVE DATA to empty it. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bob Booth Sent: vrijdag 9 maart 2007 16:40 To: ADSM-L@VM.MARIST.EDU Subject: Re: Ramifications of delete vol xx discardd=y On Fri, Mar 09, 2007 at 09:35:14AM -0600, Bell, Charles (Chip) wrote: Quick question. If I delete a volume to get it back from a read-only access state into the scratch pool, will the next incremental backup for the node data affected back up those files again? Does the database know that there are no longer references for that node data on primary storage? If not, what is the alternative than 'delete vol', restoring the vol from copy stgpool? The data will be backed up once again by TSM. If you do a delete volume on the primary, the references to the copy data will also be deleted, and a backup stg will pick that up as well. hth, bob ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Determining What tapes files are on
Well, not using documented commands that is... If you issue the following SQL statement to retrieve the file's object id: select * from backups where node_name='your nodename' and filespace_name='\\your nodename\driveletter$' and hl_name='\directory path\' and ll_name='filename' you can use the command: Show bfo 0 object id to retrieve object id of the superbit if it's a sub bit object. If you know the superbit object ID a show bfo 0 superbit id shows you the tapes (both primary and copy pool) on which the file is stored. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: zondag 4 maart 2007 12:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: Determining What tapes files are on On Mar 3, 2007, at 11:36 PM, Jones, Eric J wrote: Good Evening. Is there a way to find out what tapes a file/files are stored on(COPYPOOL/TAPEPOOL) without doing a restore? No. See Restoral preview in http://people.bu.edu/rbs/ ADSM.QuickFacts . Richard Sims ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Error restoring SQL database
Hi Andy! No, the log isn't showing more detail. Together with support, I have identified the tapes on which the backup resides. I'm currently running an audit on these tapes. Let's wait for the results... Thanks for now! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: dinsdag 13 februari 2007 14:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: Error restoring SQL database If you haven't already looked up the message, you should do so, as it does provide a little more information. Are you sure that the ANR0548W message is the *only* related message to this condition? When searching the actlog, don't do any filtering, except for the timeframe (I'd start with a timeframe from when the client operation started through when it ended). 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] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageMan ager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 02/13/2007 04:09:59 AM: Hi *SM-ers! Our SQL guys are trying to restore a SQL database. They receive the following error: ANS1314E File data currently unavailable on server In the TSM activity log I see the following message: ANR0548W Retrieve or restore failed for session 2337961 for node KL1007W9-SQL (TDP MSSQL Win32) processing file space KL1007W9\data\0001 2 for file \Zeus\ full stored as Backup - error detected. Error detected. Right... How do I find what kind of error? Thank you very much for your reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Error restoring SQL database
Hi *SM-ers! Our SQL guys are trying to restore a SQL database. They receive the following error: ANS1314E File data currently unavailable on server In the TSM activity log I see the following message: ANR0548W Retrieve or restore failed for session 2337961 for node KL1007W9-SQL (TDP MSSQL Win32) processing file space KL1007W9\data\0001 2 for file \Zeus\ full stored as Backup - error detected. Error detected. Right... How do I find what kind of error? Thank you very much for your reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TSM Server password expired
Hi Pablo! You will have to kill the TSM server and start it in the foreground (dsmserv). Then you will be able to reset your password by issuing the upd admin command. Then switch the server to the background, if your OS allows you top do so. Otherwise, halt your server and restart it again in the background. Good luck! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Pablo Arzuaga Sent: vrijdag 2 februari 2007 14:29 To: ADSM-L@VM.MARIST.EDU Subject: TSM Server password expired My TSM password expired and I can not change it from the console! Does any body have a work arroung for this? Pablo Arzuaga Ticket Pop Networks Network Analyst Cel. 787-458-9063 [EMAIL PROTECTED] www.ticketpop.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Murugan_Pachamallayan Sent: Friday, February 02, 2007 7:29 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Server password expired Hi Arnaud, Thank you for ur information. I am wondering about this problem last two days. Anyway I resolve this problem. Once again Thanks of lots Arnaud. Thanks and Regards Murugan -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of PAC Brion Arnaud Sent: Friday, February 02, 2007 4:14 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Server password expired Hi Murugan, This is probably the bug described here : http://www-1.ibm.com/support/docview.wss?uid=swg1IC49276 You'll have to recreate the server connection in ISC to solve the problem ... Cheers Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Murugan_Pachamallayan Sent: Friday, 02 February, 2007 11:17 To: ADSM-L@VM.MARIST.EDU Subject: TSM Server password expired HI In my TSM V5.3.0 Server password was expired, if I click the Server Name in the dropdown list of Storage Device Tab. I got the following error message. Your ID and password are not valid for this server. Use the server's properties notebook to update your ID and password. I reset the password from command line, even now I open the admin center the same error was occurred. How can I update the server's user Id and password? Please can any one help me out in this regard Thanks and Regards Murugan DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Interesting...
Hi Nick! The error occurred on several files on multiple filesystems. The audits didn't fix the problem since they seemed to crash somewhere. The audit process started, but there was never a process completed message and a q proc, a few seconds after the started, showed no running processes... Today I stopped TSM and started it again and all volumes showed a utilization of 0.0%, like expected. I was able to run an audit on the volumes, but they were all empty to TSM. Let's see how TSM behaves during the next migration. Thanks! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Nicholas Cassimatis Sent: vrijdag 19 januari 2007 20:32 To: ADSM-L@VM.MARIST.EDU Subject: Fw: Interesting... Does the file still exist on the filesystem? If the file was deleted, you may want to recreate it and see if the audit or delete will work then. Nick Cassimatis ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
FW: Return code 650?
Hi Andy! You're right, I should be more specific. I'm running the 5.3.4.0 client on a Windows XP Pro SP2 workstation. I don't have a dsmsched.log, since I backup my pc manually every now and then. You will find the dsmerror.log and my dsm.opt below this message. I'm performing an incremental (complete) through the GUI. Thank you VERY much for your reply in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines DSM.OPT: TCPSERVERADDRESS SPLXMR20T.XM.KLM.NL TCPBUFFSIZE 32 TCPWINDOWSIZE 63 PASSWORDACCESS GENERATE SCHEDMODE PROMPTED ERRORLOGNAMEC:\Program Files\Tivoli\TSM\baclient\dsmerror.log ERRORLOGRETENTION 7 D SCHEDLOGNAMEC:\Program Files\Tivoli\TSM\baclient\dsmsched.log SCHEDLOGRETENTION 7 D RESOURCEUTILIZATION 4 DATEFORMAT 2 NUMBERFORMAT 5 TCPNODELAY YES TXNBYTELIMIT 25600 ENCRYPTIONTYPE AES128 Encryptkey prompt MANAGEDSERVICES WEBCLIENT EXCLUDE C:\TEMP\...\* EXCLUDE.FILE C:\PAGEFILE.SYS EXCLUDE C:\...\TEMPORARY INTERNET FILES\...\* EXCLUDE C:\Documents and Settings\...\Local Settings\Temp\...\* EXCLUDE C:\Documents and Settings\...\Application Data\Sun\Java\Deployment\cache\...\* Exclude.Dir ?:\recycler INCLUDE.ENCRYPT y:\...\* DSMERROR.LOG: 18-01-2007 12:58:13 ANS1327W The snapshot operation for 'C:\ASLog.txt' failed with error code: 650. 18-01-2007 12:58:13 ANS1327W The snapshot operation for 'C:\ASSET.BAT' failed with error code: 650. 18-01-2007 12:58:14 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 12:58:14 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 12:58:14 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 12:58:14 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:04:39 ANS1327W The snapshot operation for 'C:\AUTOEXEC.BAT' failed with error code: 650. 18-01-2007 13:04:39 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:04:39 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\CONFIG.SYS' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\console.txt' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\GetFlashID.txt' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\InfrTool.ini' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\InfrTool.~in' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\IO.SYS' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\IPH.PH' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\MSDOS.SYS' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\pagefile.sys' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\adsm.sys\*' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\Documents and Settings\*' failed with error code: 650. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1376W The client was
Re: FW: Return code 650?
Hi Andy! Scenario 1: no error messages. Scenario 2: no error messages. Scenario 3: The ANS1376W re-occurred, but only once. Please let me know if I can help you further with this. Thanks! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: vrijdag 19 januari 2007 14:08 To: ADSM-L@VM.MARIST.EDU Subject: Re: FW: Return code 650? Hi Eric, There is something very strange going on here. Try these: 1. Use the command line interface. Run: dsmc i Does that make any difference? 2. Start the GUI interface. Click the big Backup button. Then do not check Local. Instead, open up the Local tree. Check the box next to the C: drive (but nothing else -- Local should remain unchecked). Then click the Backup button. Does that make any difference? 3. Repeat #2, but this time check all local drives (but not Local itself), then run the backup. Any difference? I have found that I can reproduce your problem when I check the Local box, or if I start the GUI, then select menu item Action/Backup domain. But scenarios 1 and 2 work for me. Haven't tried #3 yet. 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] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageMan ager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/19/2007 03:19:54 AM: Hi Andy! You're right, I should be more specific. I'm running the 5.3.4.0 client on a Windows XP Pro SP2 workstation. I don't have a dsmsched.log, since I backup my pc manually every now and then. You will find the dsmerror.log and my dsm.opt below this message. I'm performing an incremental (complete) through the GUI. Thank you VERY much for your reply in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines DSM.OPT: TCPSERVERADDRESS SPLXMR20T.XM.KLM.NL TCPBUFFSIZE 32 TCPWINDOWSIZE 63 PASSWORDACCESS GENERATE SCHEDMODE PROMPTED ERRORLOGNAME C:\Program Files\Tivoli\TSM\baclient\dsmerror.log ERRORLOGRETENTION 7 D SCHEDLOGNAME C:\Program Files\Tivoli\TSM\baclient\dsmsched.log SCHEDLOGRETENTION 7 D RESOURCEUTILIZATION 4 DATEFORMAT 2 NUMBERFORMAT 5 TCPNODELAY YES TXNBYTELIMIT 25600 ENCRYPTIONTYPE AES128 Encryptkey prompt MANAGEDSERVICES WEBCLIENT EXCLUDE C:\TEMP\...\* EXCLUDE.FILE C:\PAGEFILE.SYS EXCLUDE C:\...\TEMPORARY INTERNET FILES\...\* EXCLUDE C:\Documents and Settings\...\Local Settings\Temp\...\* EXCLUDE C:\Documents and Settings\...\Application Data\Sun\Java\Deployment\cache\...\* Exclude.Dir ?:\recycler INCLUDE.ENCRYPT y:\...\* DSMERROR.LOG: 18-01-2007 12:58:13 ANS1327W The snapshot operation for 'C:\ASLog.txt' failed with error code: 650. 18-01-2007 12:58:13 ANS1327W The snapshot operation for 'C:\ASSET.BAT' failed with error code: 650. 18-01-2007 12:58:14 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 12:58:14 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 12:58:14 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 12:58:14 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:04:39 ANS1327W The snapshot operation for 'C:\AUTOEXEC.BAT' failed with error code: 650. 18-01-2007 13:04:39 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:04:39 ANS1376W The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\CONFIG.SYS' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\console.txt' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\GetFlashID.txt' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\InfrTool.ini' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\InfrTool.~in' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\IO.SYS' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\IPH.PH' failed with error code: 650. 18-01-2007 13:05:27 ANS1327W The snapshot operation for 'C:\MSDOS.SYS' failed with error code: 650. 18-01-2007
Interesting...
Hi *SM-ers! I have got an interesting situation here. Please have a look at the following entries and TSM's response. DELETE VOLUME /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 ANR2406E DELETE VOLUME: Volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 still contains data. Ok, so the volume isn't empty. Well, let's make it empty then: MOVE DATA /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 ANR2209W Volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 contains no data. Huh? Contains no data? Are you sure? QUERY CONTENT /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 ANR2034E QUERY CONTENT: No match found using this criteria. Right... So it's empty, but it contains data... Well, let's delete is with the discarddata=yes then: DELETE VOLUME /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 discarddata=yes ANR2406E DELETE VOLUME: Volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 still contains data. ??? Now I'm complete lost... What's wrong here? Let's check the volumes status: q volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status --- -- - - /appl/tsm_lbu1/diskpool- DISKPOOL_L- DISK 20.480,0 -99,8 On-Line 1/lbu1_diskpool_114 BU1_1 Utilization is -99,8%... This cannot be right. I seem to have 26 volumes with the same status and I don't know how to solve this. I marked them readonly for now. Any good tips (other that calling support on Monday)? Thanks in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Interesting...
Hi David! Forgot to mention that one: AUDIT VOLUME /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 fix=yes ANRD dsaudit.c(1097): ThreadId44 Erroneous information for volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 was removed from the database. ANRD ThreadId44 issued message from: -0x00010001c2b4 outDiagf -0x00010041afe4 DsAuditEmptyVol -0x000100416cf4 ssAuditEmptyVol -0x0001007624c8 DoAuditVolume -0x000100766cb0 AdmAuditVolume -0x0001001ec730 AdmCommandLocal -0x0001001ed670 admCommand -0x00010050e3a4 SmAdminCommandThread -0x0001e9fc StartThread -0x092c150c _pthread_body ANR2209W Volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 contains no data. It doesn't solve the problem though... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: vrijdag 19 januari 2007 18:09 To: ADSM-L@VM.MARIST.EDU Subject: Re: Interesting... Try Audit Volume The problem seems to go away with current code levels. Loon, E.J. van - SPLXM [EMAIL PROTECTED] 1/19/2007 12:02 PM Hi *SM-ers! I have got an interesting situation here. Please have a look at the following entries and TSM's response. DELETE VOLUME /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 ANR2406E DELETE VOLUME: Volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 still contains data. Ok, so the volume isn't empty. Well, let's make it empty then: MOVE DATA /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 ANR2209W Volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 contains no data. Huh? Contains no data? Are you sure? QUERY CONTENT /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 ANR2034E QUERY CONTENT: No match found using this criteria. Right... So it's empty, but it contains data... Well, let's delete is with the discarddata=yes then: DELETE VOLUME /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 discarddata=yes ANR2406E DELETE VOLUME: Volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 still contains data. ??? Now I'm complete lost... What's wrong here? Let's check the volumes status: q volume /appl/tsm_lbu1/diskpool1/lbu1_diskpool_114 Volume Name Storage Device EstimatedPct Volume Pool NameClass Name Capacity Util Status --- -- - - /appl/tsm_lbu1/diskpool- DISKPOOL_L- DISK 20.480,0 -99,8 On-Line 1/lbu1_diskpool_114 BU1_1 Utilization is -99,8%... This cannot be right. I seem to have 26 volumes with the same status and I don't know how to solve this. I marked them readonly for now. Any good tips (other that calling support on Monday)? Thanks in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Return code 650?
Hi *SM-ers! Today I encountered some warnings during the backup of my pc. For several files and directories I see the following messages in the dsmerror.log: ANS1327W The snapshot operation for 'C:\AUTOEXEC.BAT' failed with error code: 650. The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. I cannot find the meaning of return code 650. It's not a (documented) TSM API return code (source dsmrc.sh) nor is it a (documented) Win32 return code... Thank you very much in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Return code 650?
Hi Andy! Can you explain what's causing the message you are reffering to (The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support)? If TSM wasn't able to obtain a snapshot, a user would like to know why... Also, it's only issued for a few files and directories, not for all... Thanks for your reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: donderdag 18 januari 2007 15:38 To: ADSM-L@VM.MARIST.EDU Subject: Re: Return code 650? Hi Eric, I realize the message appears to be confusing, but the explanation is all there, in the text immediately following the 650. Best 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] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageMan ager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/18/2007 05:39:03 AM: Hi *SM-ers! Today I encountered some warnings during the backup of my pc. For several files and directories I see the following messages in the dsmerror.log: ANS1327W The snapshot operation for 'C:\AUTOEXEC.BAT' failed with error code: 650. The client was unable to obtain a snapshot of the file system. The operation will continue without snapshot support. I cannot find the meaning of return code 650. It's not a (documented) TSM API return code (source dsmrc.sh) nor is it a (documented) Win32 return code... Thank you very much in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ** ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Cross system restore problems
Hi Thomas! Cross-client restore is not supported. That's probably why these messages are not to be found in the messages manual. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: maandag 8 januari 2007 22:40 To: ADSM-L@VM.MARIST.EDU Subject: Cross system restore problems One of our Windows administrators has been attempting a cross-system restore using the -virtualnodename option. The system that backed up the files was a Windows NT system with 5.1.7.0 client code. The system attempting to restore the files is a Windows 2003 system with 5.3.4.3 client code. The TSM server is a mainframe Linux system with 5.3.4.0 server code. The restore restores about seven gigabytes before failing. The last part of the error log is as follows: 01/08/2007 15:10:06 ANS1946W File \\fa001new\e$\Home\jpc101\FY_2002\RADIOL~1.XLS exists, skipping 01/08/2007 15:10:09 ANS1946W File \\fa001new\e$\Home\jpc101\FY_2002\SURVEY~1.XLS exists, skipping 01/08/2007 15:13:14 The 30472th code was found to be out of sequence. The code (4025) was greater than (3839), the next available slot in the string table. 01/08/2007 15:13:14 ANS4039E Error processing '\\fa001new\e$\Home\yxl103\mcare\healthpartners03(a).xls': compressed file is corrupted and cannot be expanded. 01/08/2007 15:13:14 The 12982th code was found to be out of sequence. The code (1771) was greater than (1714), the next available slot in the string table. 01/08/2007 15:13:14 ANS4039E Error processing '\\fa001new\e$\Home\yxl103\mcare\HPCAL02.xls': compressed file is corrupted and cannot be expanded. 01/08/2007 15:13:23 HlClose(): Win32 RC 1336 occured restoring NTFS Security Attributes on object 'E:\Home\yxl103\PO.BOX\MISCFILES\FOXPRO\UVARA20.DBF'. 01/08/2007 15:13:23 HlClose(): Default NTFS Security Attributes have been set. 01/08/2007 15:13:25 Return code 260 unknown 01/08/2007 15:13:25 Unknown system error Please check the TSM Error Log for any additional information The ANS1946W messages shown are the last two of a much larger number of such messages. It would appear that original client had a lot of files with long names imitating the style of the short names generated by Windows. The TSM messages manual was not particularly helpful, since the TSM developers did not see fit to attach message identifiers to most of the messages shown above. Web searches for various text strings in the messages have so far not turned up anything particularly helpful. Does anyone have any suggestions for trouble-shooting this problem? ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
[no subject]
Hi Kerry! This means that the volume is not a scratch volume, probably because it's still in TSM's volume inventory. Check the volume's current status by issuing a q vol 00022 f=d. If you are using DRM, you should use the DRM commands to return the volume. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kerry Campbell Sent: maandag 18 december 2006 14:51 To: ADSM-L@VM.MARIST.EDU Subject: I was trying to check in a tape received from off-site storage to our library. The following command was issued: checkin libv medslib 22 status=scr checkl=yes Some of my tapes would check in just fine but other gave me the following error message: ANR8443E CHECKIN LIBVOLUME 22 IN Library MEDSLIB cannot be assigned a status of scratch ANS8001I Return Code 12 Any help is appreciated. Kerry *** CONFIDENTIALITY NOTICE*** This message and any included attachments are from MedSynergies, Inc. and are intended only for the addressee. The contents in this message contain confidential information belonging to the sender that is legally protected. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or contact MedSynergies, Inc. at [EMAIL PROTECTED] ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Survey Question for Virtual Tape Users: What Vendors are you using for Virtual Tape?
My 2 cents: There is on big advantage for using a VTL over a disk subsystem: compression. We are also using a EMC DL700 which uses in-the-box LTO compatible compression. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Deschner Sent: donderdag 7 december 2006 9:35 To: ADSM-L@VM.MARIST.EDU Subject: Re: Survey Question for Virtual Tape Users: What Vendors are you using for Virtual Tape? I keep hearing it said, that if you're going to buy a great big disk array for TSM, that it works better if you let TSM know it has disks (DEVCLASS=FILE), than if you lie and try to tell it they are virtual tapes. Cheaper too, because you don't have that VTL layer in there. Simpler to administer because it's all done in TSM. Easier to grow later because you're not locked into a single vendor or technology - all the disk box needs to do is support Unix filesystems under your OS. All that lying just adds overhead. We are dividing our workload, between large clients and small clients. Basically, we're dividing them between those who could use collocation on real tape effectively, and those who cannot. The small clients are going to move to an all-disk solution. You could call it virtual tape, except that TSM knows it's disks. Small clients are the situation where backup to disk is effective, because collocation is impractical so in a restore you're mostly waiting for the robot to dance around in his cage mounting and unmounting tapes. This is a huge waste of the robot's time, your time, and most importantly the client's time. SATA drives aren't fast, but they're fast enough to speed up small clients' large restores (e.g. an entire PC hard drive) by several orders of magnitude. The large clients are very much best on collocated real tape. I'd say the test is this: If you have a group of clients that are exploiting collocation correctly and effectively, without wasting too much tape, then that is exactly where they belong - on real tape. We found in a real disaster situation (big server had a large Unix filesystem get corrupted) that by setting RESOURCEUTILIZATION to get multiple restore streams going at once, that we restored that filespace many times faster than by any other possible backup/restore method, TSM or anything else. We also found that setting RESOURCEUTILIZATION high was much more efficient than any attempt to divide up the restore manually. Get several modern SDLT or LTO drives in a RTL (Real Tape Library) streaming data into a GigE pipe at once, and you're moving a lot of data very fast. Restore of large filespace(s) from disk simply cannot beat real tapes, with collocation, and the TSM RESOURCEUTILIZATION setting automating the process of creating multiple restore streams. Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] ==I have not lost my mind -- it is backed up on tape somewhere.= On Wed, 6 Dec 2006, Nancy L Backhaus wrote: Op System AIX 5.3 ML 3 Nightly Backup 2 -2 1/2 TB Library - ADIC I2000 Scalar 18 LTO Tape Drives LTO 2 Tapes 600 slots Clients - 135 (Wintel) AIX -26 (Sybase, SQL, and DB2) We are looking into Virtual Tape Technology for our environment.1 1/2s TB data first backs up to disk then to onsite tape then we make a backup of our onsite tape to a copy stgpool and store those tapes offsite for disaster recovery.The other 1 TB of data is a DB2 database that we back up directly to onsite tape and of course make a copy of the onsite tape to offsite tape for disaster recovery. We can't get our backups done and out the door to meet our RTO objective. We are looking to add a VTL and reduce our tape drive and slot capacity in a new library to offset some of the cost for a virtual tape library.We would like to also take advantage of collocation and setup library sharing too. I would like to know what vendors you are using for virtual tape? Pros/Cons(Any regrets, Success Stories). Thank You. Nancy Backhaus Enterprise Systems (716)887-7979 HealthNow, NY 716-887-7979 CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment
Dutch TSM User Group day November 23rd
To all Dutch TSM users, On November 23rd. We will organize a Dutch TSM User Group event with the following subjects: - TSM 5.4 - Update TSM products (roadmap) - Virtual Tape Library or devclass=file? - HSM Windows demo (Caminosoft) - Reporting, compliance and TSM (Sox etc.) Location is not yet clear. If live demo's are required we will go to PLCS in Hendrik-Ido-Ambacht, otherwise the event will be held at IBM Learning Center in Amsterdam. If you like to attend, please send an e-mail to: [EMAIL PROTECTED] Kindest regards, Eric van Loon ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TDP for Oracle filesets
Hi Charles! The missing bos.rte v5 message means that you are trying to install AIX 5.x software on an older AIX OS. What level of AIX are you running and what is the Oracle level? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bell, Charles (Chip) Sent: maandag 16 oktober 2006 21:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for Oracle filesets When installing the filesets listed below, I get the following from SMIT... Command: failedstdout: yes stderr: no Before command completion, additional instructions may appear below. [MORE...21] -- SELECTED FILESETS: The following is a list of filesets that you asked to install. They cannot be installed until all of their requisite filesets are also installed. See subsequent lists for details of requisites. tivoli.tsm.client.oracle.64bit 5.2.0.0# IBM Tivoli Storage Manager f... MISSING REQUISITES: The following filesets are required by one or more of the selected filesets listed above. They are not currently installed and could not be found on the installation media. bos.rte v5 # Base Level Fileset Should I try installing tivoli.tsm.client.oracle.aix51.64bit ALL instead? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Neil Rasmussen Sent: Friday, October 13, 2006 3:36 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle filesets Chip, You will want the following: tivoli.tsm.client.api.aix51.64bit ALL tivoli.tsm.client.oracle.64bit ALL tivoli.tsm.client.oracle.tools.aix51.64bit ALL However, I just noticed from your first email that you are using Oracle 10g. I would recommend that you upgrade to Data Protection for Oracle 5.3.3 as it contains some APAR fixes that you will need when running Oracle 10g. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Bell, Charles (Chip) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/12/2006 11:04 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: TDP for Oracle filesets Here is what I am seeing available to install. Thanks! * tivoli.tsm.client.api.aix43.32bit ALL * *+ 5.1.5.0 TSM Client - Application Programming Interface * * * * tivoli.tsm.client.api.aix43.64bit ALL * *+ 5.1.5.0 TSM Client - 64 Bit Application Programming Interface * * * * tivoli.tsm.client.api.aix51.64bit ALL * *+ 5.1.5.0 TSM Client - 64 Bit Application Programming Interface * * tivoli.tsm.client.books ALL * *+ 5.1.5.0 TSM BOOKS - Using UNIX Clients - HTML Format * *+ 5.1.5.0 TSM BOOKS - Using UNIX Clients - PDF Format * * * * tivoli.tsm.client.oracle.32bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle on AIX * * * * tivoli.tsm.client.oracle.64bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle on AIX * * tivoli.tsm.client.oracle.aix51.64bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle on AIX * * * * tivoli.tsm.client.oracle.books ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle - HTML F * *+ 5.2.0.0 Tivoli Storage Manager for Databases - Oracle - PDF Format * * * * tivoli.tsm.client.oracle.tools.32bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle Tools on * * tivoli.tsm.client.oracle.tools.64bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle Tools on * * * * tivoli.tsm.client.oracle.tools.aix51.64bit ALL * *+ 5.2.0.0 IBM Tivoli Storage Manager for Databases - Oracle Tools on * -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Neil Rasmussen Sent: Thursday, October 12, 2006 10:50 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle filesets Chip, I am not clear as to which filesets you are seeing, but basically DP Oracle requires the ELA, the TSM API, and the DP Oracle Utilities as well as the DP Oracle fileset itself. If you could list the filesets you are seeing from smitty, I could be a little more specific in my answer. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] Bell, Charles (Chip) [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10/12/2006 06:55 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject TDP for Oracle filesets What filesets would I need to install from physical media, TDP for Oracle 5.3.1, if we are running Oracle 10g on AIX v5.3, 64-bit? When running smitty install, there were many different valid-looking filesets, and I became confused... :-)
Dsmc output on AIX sometimes contains a crlf
Hi *SM-ers! On our AIX clients, the output from the dsmc i command is send to a logfile for further processing. Every now and then, the output from the backup of a file contains a crlf. Instead of: Normal File-- 87,042 /mount/appl00399/lido_apps/lido/etc/0008704600 [Sent] The output looks like this: Normal File-- 87,042 /mount/appl00399/lido_apps/lido/etc/0008704600 [Sent] This causes the output to be garbled. Further processing of the output fails because of this unexpected character. Has anybody seen this behavior before? I browsed through the 5.3.2.0, 5.3.3.0 and 5.3.4.0 APARs, but I haven't found anything related... Thank you very much for any reply in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Backup Retention Period
Hi Norita! For backups: yes. Backup objects are rebound to the new managementclass during the next backup, so all inactive versions older than 30 days will be removed. Archives are not rebound, so changing retention for archives will not change retention for previously made archives. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Norita binti Hassan Sent: woensdag 27 september 2006 6:15 To: ADSM-L@VM.MARIST.EDU Subject: Backup Retention Period Hi all, What happen if I change my backup retention period. I want to change my backup retention period from 90 days to 30 days. Does it expire all the backup done before. Thanks NORITA BINTI HASAN Senior Programmer Enterprise Systems Services Information Communications Tech. Div 6th Floor,Pos Malaysia HQ 50670 Kuala Lumpur * : 03 - 22756638 *: 016 - 6090530 Pos Malaysia Berhad is Malaysia's national postal company Visit us online at www.pos.com.my NOTICE This message may contain privileged and/or confidential information. If you are not the addressee or authorised to receive this email, you must not use, copy, disclose or take any action based on this email. If you have received this email in error, please advise the sender immediately by reply e-mail and delete this message. Pos Malaysia Berhad takes no responsibility for the contents of this email. Email scanned and protected by POS Malaysia ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: TSM 5.3.0 with SAN
Hi Murugan! 1) Yes, you can install it on all clients. I would use the latest version though: 5.3.4.0. 2) Yes, this is possible and documented in the IBM Redbook Backing Up DB2 Using IBM Tivoli Storage Manager (http://www.redbooks.ibm.com/abstracts/sg246247.html?Open) Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Murugan_Pachamallayan Sent: dinsdag 19 september 2006 9:26 To: ADSM-L@VM.MARIST.EDU Subject: TSM 5.3.0 with SAN Hi, I installed TSM Extended Edition 5.3 on Windows 2003 Server, and I have 18 AIX 5.3 Servers and 10 Windows 2003 Server. All are the systems connected through SAN. I have IBM Total Storage 3584 Tape Library with 8 LTO Drives. I have some queries; please can any one help me out in this regard. Queries 1. Can install Tivoli Storage Manager Storage agent 5.3.0 to all the machines or only one machine ? 2. I have 5 DB2 Servers; it is possible to take online backup to the Tape Library. ? Regards, Murugan -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Efim Sent: Monday, September 18, 2006 12:44 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] ISC 601 Hello ! Try this: isc6:23:once:/opt/IBM/ISC/PortalServer/bin/startISC.sh ISC_Portal ISCUSER ISCPASS if you want try to run without restart server 1. change line: isc6:a:once:/opt/IBM/ISC/PortalServer/bin/startISC.sh ISC_Portal ISCUSER ISCPASS 2. run telinit a 3. if all ok , change line back: isc6:23:once:/opt/IBM/ISC/PortalServer/bin/startISC.sh ISC_Portal ISCUSER ISCPASS Efim * Murugan_Pachamallayan [EMAIL PROTECTED] [Mon, 18 Sep 2006 10:29:19 +0530]: Dear list, I have installed ISC 601 on the AIX 5.3 machine. But I could not able to start the services. How can I start the services on the AIX machine. Regards, Murugan DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. -- Efim. DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
How to upgrade a multiple instance TSM server on AIX
Hi *SM-ers! We have an AIX 5.2 server with two TSM instances running on the same AIX partition. We have upgraded the first instance, changed the link to the second instance's install path and rerun SMIT INSTALL to upgrade this instance. The first upgrade runs fine, but I cannot find a way to upgrade the second instance. In SMIT I have selected the following options: INPUT device / directory for software . SOFTWARE to install [tivoli.tsm.server.rte PREVIEW only? (install operation will NOT occur)yes COMMIT software updates?yes SAVE replaced files?no AUTOMATICALLY install requisite software? no EXTEND file systems if space needed?yes OVERWRITE same or newer versions? yes VERIFY install and check file sizes?no DETAILED output?no Process multiple volumes? yes ACCEPT new license agreements? no Preview new LICENSE agreements? no This upgrade fails with the following error: Force Apply Failures The following is a list of fileset updates. Updates cannot be specified from the command line when the force flag (-F) is used in combination with the apply flag (-a). How can I upgrade the second instance when apparently you cannot do a force install when you install an update?? Thank you very much for any reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Making TSM twin-center compliant
Hi *SM-ers! We are about to implement a second (fallback) IT center on another location. The idea is to create a hot standby environment for TSM. We are already using a separate copypool which will be moved to the new remote location, so if the primary pool gets lost, we have all data (up until the last backup stgpool of course) on the remote location. However, in case of a disaster, not only will we have to be able to recover clients (from this copypool), but we also need to continue backup here. This would be no problem if one could promote a TSM copypool to a primary pool. In this case one could just continue making (the forever incremental) backups, but TSM doesn't offer this function (yet). An UPDATE COPYPOOL POOLTYPE=PRIMARY would be very nice to have... The only thing I could think of is creating a standby library which can be connected in case of a disaster to host the new primary pool and start all over with backing up. A waste of money because it will probably (and hopefully) never be used.. How do other twin-centers solve this? Thank you very much for any hints and tips in advance!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Making TSM twin-center compliant
Hi Allen! Thank you very much for your reaction! Correct me if I'm wrong, but as far as I know, you cannot backup to a copypool. Am I wrong here? I cannot wait for the restore storagepool to finish... This will take days and I will have to be able to make client backups immediately. If I was able to convert a copypool into a primary pool, I would be able to backup clients right away. Ok, I would loose my copypool, but in case of a disaster I can live with that for several days. In the meantime I can have my vendor bring in (rental) stuff to rebuild the copypool. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: vrijdag 1 september 2006 16:00 To: ADSM-L@VM.MARIST.EDU Subject: Re: Making TSM twin-center compliant On Fri, 1 Sep 2006 13:17:17 +0200, Loon, E.J. van - SPLXM [EMAIL PROTECTED] said: We are about to implement a second (fallback) IT center on another location. The idea is to create a hot standby environment for TSM. We are already using a separate copypool which will be moved to the new remote location, so if the primary pool gets lost, we have all data (up until the last backup stgpool of course) on the remote location. However, in case of a disaster, not only will we have to be able to recover clients (from this copypool), but we also need to continue backup here. This would be no problem if one could promote a TSM copypool to a primary pool. In this case one could just continue making (the forever incremental) backups, but TSM doesn't offer this function (yet). Sure it does. In fact, you can do exactly as you describe; biggest impact will be that the copy stgpools are usually (very) poorly optimized for client restore. Think of it carefully: Two TSM servers: PRIM, and COPY; COPY is housing the offsites. You lose PRIM, but, since you're good at these things you have the database backed up offsite. You restore the PRIM database on hardware at the remote site. Immediately at that point, you have access to the data in the copy pools, and more importantly, you have the -database- that tells you what you have and don't have. The next incremental will only copy the data you didn't have as of the database backup which you used to do the restore. So, between the time you get PRIM restored at the remote site, and the time when the first of your clients have gotten their acts together, you can be RESTORE STGpool ing as fast as your little tape drives can scurry; as you make progress there (according to your previously determined list of priorities...) your replacement PRIM becomes better and better suited to serve the client restores. From another perspective: Why promote a copystgpool to PRIMARY status? You'll just need to re-organize the new PRIMARY pool and then make a copy pool. Less work to take the well-organized (for a copy stgpool) existing copystgpool and make a new PRIMARY. - Allen S. Rout - There is no copy, there is no primary. There is only data. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Time format Web admin interface
Hi *SM-ers! When I use the 5.2 web admin on one of my TSM servers, the time format is not what I expect it to be. For instance, when I query client events, time is shown as 8:00 PM instead of 20:00. When I query through dsmadmc it is shown as 20:00. Does anybody know where to set the date and time format for the web admin interface? Thank you very much for your help in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: del filesp with +10Mio files
Hi Peter! A delete volume runs as fast (or as slow) as a delete filespace. Actually, it does the very same thing: delete every single object from the database one by one. If the node had it's own tapes, you could mark all it's tapes in both the primary pool and the copy pool destroyed and let do the expire inventory do the work for you... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Peter Duempert Sent: maandag 21 augustus 2006 15:03 To: ADSM-L@VM.MARIST.EDU Subject: del filesp with +10Mio files Hi TSM'ers on the following system I'm faced to delete ca. 15 filespaces holding a total of ca. 30 Mio files. HW: IBM H70, 2GB, SSA + SAN disks OS: AIX 5.3 ML 04 TSM:5.3.3, 60 GB DB on SSA mirrored on SAN, 2 GB LOG ( SSA + SAN) Doing individual del filesp node file_space_name will take days/weeks/months(?) (the biggest filespace owns ca. 19 Mio files). The filespaces are all on collocated nodes, i.e. I could even do: 1. Determine the volumes for nodes' data 2. Either create backupsets of the nodes data to be kept, just to keep the current state or run a selective backup with a different MGMT-class, sending the data to a different set of tapes 3. run del vol volid discard=yes for all the volumes belonging to the node 4. proceed as normal after having finished Questions: -- Q1. Is the sequence of steps 1. - 4. faster than the individual del filesp node filespace_name Q2. Any idea to do it even faster ? -- MfG / Ciao - - - - - - - - - - - - - - - - - - - - - - - - - - - - Peter Dümpert Email: [EMAIL PROTECTED] Rechenzentrum der Technischen Universität Fax : ++49/531/391-5549 D 38092 BraunschweigTel : ++49/531/391-5535 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: SQL Server 2005 support?
Hi Del! Your statement Customer always have the option of not installing a fix release, and waiting for the next PTF or release of that Data Protection client may be true in most cases, but not when new platform support is added. You don't have the option to wait for a new release because you cannot backup your production data in the meantime! We normally use the most recent maintenance levels for all TSM and DP clients. Only when customers encounter a bug which is fixed in a fix release, they will upgrade to that fix release, until the next maintenance release (containing the APAR) is there. The customer will replace their fix level with this new maintenance level a.s.a.p. I think most TSM customers work this way. Why didn't Tivoli add the Windows 2005 support and release this as maintenance release 5.3.0? That was a nice chance of synchronizing the level with other DP clients like DP for Exchange, DP for Lotus Domino and DP for mySAP... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: maandag 7 augustus 2006 17:37 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL Server 2005 support? Hi Eric, Data Protection clients do not have a new release (or even a PTF) near as often as the BA client does. But, there are still situations like this where we try to get customers the support they need, as soon as we can. Sometimes that means, putting this kind of support into a fix release. Customer always have the option of not installing a fix release, and waiting for the next PTF or release of that Data Protection client. Also note that Microsoft made it quite easy for vendors to add SQL Server 2005 support because they made almost everything backward compatible. There were only very minor changes that had to be made. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/07/2006 10:00:00 AM: Hi Del! Thank you very much for your quick reply! I wasn't expecting new support in a fix release... Wouldn't it be more logical to create a 5.2.2.0 version containing 2005 support? Now we have to backup production nodes by using a fix release, which I normally would not recommend... Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
SQL Server 2005 support?
Hi *SM-ers! As far as I can find, DP for SQL Server 5.2.1 is the most recent version for backing up SQL Server databases. It support SQL Server 7.0 and 2000. Does anybody know when SQL Server 2005 will be supported by DP for SQL? Thank you very much for any reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: SQL Server 2005 support?
Hi Del! Thank you very much for your quick reply! I wasn't expecting new support in a fix release... Wouldn't it be more logical to create a 5.2.2.0 version containing 2005 support? Now we have to backup production nodes by using a fix release, which I normally would not recommend... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: maandag 7 augustus 2006 14:45 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL Server 2005 support? Hi Eric, SQL Server 2005 support was added in November of last year, one day following the official launch of SQL Server 2005 by Microsoft. You will need to obtain Data Protection for SQL version 5.2.1.03 (or later) from the following web site: Where: FTP Site: ftp.software.ibm.com Directory: /storage/tivoli-storage-management/patches/tivoli-data-protection/sql/v5 21/x32/ FYI... Data Protection for SQL added Windows x64 support as well. Since the Windows x64 is a new platform, if you want the x64 version, you will need to obtain that from the Passport Advantage download site, or by ordering the CD from IBM. This is because the FTP site does not contain the license file that you need to run the product. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/07/2006 08:27:33 AM: Hi *SM-ers! As far as I can find, DP for SQL Server 5.2.1 is the most recent version for backing up SQL Server databases. It support SQL Server 7.0 and 2000. Does anybody know when SQL Server 2005 will be supported by DP for SQL? Thank you very much for any reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
TDP for SQL configuration error...
Hi *SM-ers! We have got one TDP for SQL (5.2.1) client which refuses to cooperate. It's configured like all other TDP clients with a standard dsm.opt file which contains the correct TCPServeraddress. However, as soon as we start the TDP GUI, it returns: ANS1033E (RC-53) An invalid TCP/IP address was specified. In the directory C:\Program Files\tivoli\TSM\TDPSql a dsierror.log is created with the following lines: 06/26/2006 08:59:43 GetHostnameOrNumber(): gethostbyname(): errno = 11004. 06/26/2006 08:59:43 TcpOpen: Could not resolve host name. 06/26/2006 08:59:43 ANS4039E Could not establish a session with a TSM server or client agent. The TSM return code is -53. 06/26/2006 08:59:43 ANS1033E An invalid TCP/IP address was specified. The TSM server listed in the dsm.opt file is pingable from this client, so it's not a DNS related issue. I'm lost here, how can I see which host name TDP tries to resolve? Is there any tracing I can turn on to reveal this? Thank you very much for any reply in advance!!! Kindest regards, Eric van Loon ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: TDP for SQL configuration error...
Hi Rainer! Like I stated in my post: The TSM server listed in the dsm.opt file is pingable from this client, so it's not a DNS related issue. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rainer Holzinger Sent: woensdag 28 juni 2006 11:36 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL configuration error... Hello Eric, have you checked that your MS SQL host is able to resolve the TCP Hostname of the TSM server? Rainer -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: Wednesday, June 28, 2006 10:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP for SQL configuration error... Hi *SM-ers! We have got one TDP for SQL (5.2.1) client which refuses to cooperate. It's configured like all other TDP clients with a standard dsm.opt file which contains the correct TCPServeraddress. However, as soon as we start the TDP GUI, it returns: ANS1033E (RC-53) An invalid TCP/IP address was specified. In the directory C:\Program Files\tivoli\TSM\TDPSql a dsierror.log is created with the following lines: 06/26/2006 08:59:43 GetHostnameOrNumber(): gethostbyname(): errno = 11004. 06/26/2006 08:59:43 TcpOpen: Could not resolve host name. 06/26/2006 08:59:43 ANS4039E Could not establish a session with a TSM server or client agent. The TSM return code is -53. 06/26/2006 08:59:43 ANS1033E An invalid TCP/IP address was specified. The TSM server listed in the dsm.opt file is pingable from this client, so it's not a DNS related issue. I'm lost here, how can I see which host name TDP tries to resolve? Is there any tracing I can turn on to reveal this? Thank you very much for any reply in advance!!! Kindest regards, Eric van Loon ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e- mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: actlog errors since upgrade to 5.3.3
Hi Lawrence The message is quite self-explanatory: Session 1807 client is down-level - apply IC34693. This APAR can be found at: http://www-1.ibm.com/support/docview.wss?uid=swg1IC34693 Just like Brian suggested, you should upgrade the client to a higher level than 5.1.5.0. The error was fixed in 5.1.5.2, but if I were you, I would jump to the highest maintenance level available for Windows NT, which is 5.1.7.0. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: dinsdag 23 mei 2006 17:58 To: ADSM-L@VM.MARIST.EDU Subject: actlog errors since upgrade to 5.3.3 Here are new error messages that have showed up since the upgrade to 5.3.3. Anyone have an idea what they involve? 05/23/06 11:17:46 ANRD smutil.c(13314): ThreadId33 Session 1807 (SCANIMG, 277, WinNT, 5.1.5.0) attempted to associate itself with nodeid 345 - aborting session(SESSION: 1807) 05/23/06 11:17:46 ANRD ThreadId33 issued message from: -0x1001bb44 outDiagf -0x1014c064 SmAddSessionToAffinityCluster -0x104c234c SmNodeSession -0x1053086c SmSchedSession -0x104dd780 HandleNodeSession -0x104e3ba0 smExecuteSession -0x10577404 SessionThread -0x1000e9e0 StartThread -0xd004c444 _pthread_body (SESSION: 1807) 05/23/06 11:17:46 ANRD smutil.c(13327): ThreadId33 Session 1807 client is down-level - apply IC34693(SESSION: 1807) 05/23/06 11:17:46 ANRD ThreadId33 issued message from: -0x1001bb44 outDiagf -0x1014c0b4 SmAddSessionToAffinityCluster -0x104c234c SmNodeSession -0x1053086c SmSchedSession -0x104dd780 HandleNodeSession -0x104e3ba0 smExecuteSession -0x10577404 SessionThread -0x1000e9e0 StartThread -0xd004c444 _pthread_body (SESSION: 1807) 05/23/06 11:17:46 ANR0484W Session 1807 for node SCANIMG (WinNT) terminated - protocol violation detected.(SESSION: 1807) The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain information that is confidential, privileged, and/or otherwise exempt from disclosure under applicable law. If this electronic message is from an attorney or someone in the Legal Department, it may also contain confidential attorney-client communications which may be privileged and protected from disclosure. If you are not the intended recipient, be advised that you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify the New York State Thruway Authority immediately by either responding to this e-mail or calling (518) 436-2700, and destroy all copies of this message and any attachments. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
TDP for SQL tracing
Hi *SM-ers! I added the trace parameters to the dsm.opt on a client running the DP for SQL Server client. I added the following lines: Tracefile d:\tdptrace\tdptrace.txt Traceflags stats, options, compress Tracemax 100 The tracefile confirmed this: 05/01/2006 21:30:47.745 : Current trace classes enabled: CONFIG, COMPRESS, TIMESTAMP, PREFIX, STATS But it only contains the CONFIG output. No statistics, no compression info, nothing... What am I doing wrong??? Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Installing the Linux client
Hi Richard! Thanks for your reply! We solved the problem. My colleague was trying to install the client through YaST instead of rpm... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard van Denzel Sent: woensdag 26 april 2006 14:53 To: ADSM-L@VM.MARIST.EDU Subject: Re: Installing the Linux client Hi Eric, Did your colleague install the client with rpm -ihv (because rpm -Uhv is for updates only). Also make sure compat-libstdc++ is installed. I just did a fresh install on Fedora Core 5 and all went well. So if the above is not the case I'd rather suspect a problem in SuSe. Regards, Richard van Denzel. Van: ADSM: Dist Stor Manager namens Loon, E.J. van - SPLXM Verzonden: wo 26-4-2006 10:13 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: Re: [ADSM-L] Installing the Linux client Hi David! He receives the error during the installation of the API package... Guess I will have to open a PMR for this. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: dinsdag 25 april 2006 17:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: Installing the Linux client Did he install the API before the BA? It has to be installed first. David [EMAIL PROTECTED] 4/25/2006 9:40:28 AM Hi *SM-ers! One of my Unix colleagues is trying to install the TSM 5.3.3.0 client on a SLES9 distribution. I downloaded the client from ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintena nce/client/v5r3/Linux/Linux86/v533/ and I delivered him the two packages TIVsm-API.i386.rpm and TIVsm-BA.i386.rpm. He is trying to install the client on a new LINUX installation, but it fails with the following error: Package TIVsm-API-5.2.4-0.i386 was not found on the medium. Why does the 5.3 client install fail when there is no 5.2 client installed? It's a new clean installation! Thank you VERY much for any help! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Trying to tun on tracing in the Windows 5.3 client.
Hi *SM-ers! I'm trying to create a trace, using the Windows 5.3.3.0 client. The most recent Trace Facility Guide I could find was SH26-4121-01 for TSM 4.2. I added the following lines to the dsm.opt file: Tracefile c:\temp\trace.txt Traceflags instr When I start dsm.exe, it complains about the traceflags line. The syntax is not correct. When I change it to traceflags all, I can start the TSM client (after waiting for a minute and a trace file which is already more than 100 Mb!), but I only want the instrumental tracing details. Why isn't the instr flag working, while the manual lists this as a valid flag? Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Trying to tun on tracing in the Windows 5.3 client.
Hi Richard! Thank you VERY much for putting me on the right track! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: maandag 1 mei 2006 14:37 To: ADSM-L@VM.MARIST.EDU Subject: Re: Trying to tun on tracing in the Windows 5.3 client. On May 1, 2006, at 8:31 AM, Loon, E.J. van - SPLXM wrote: I'm trying to create a trace, using the Windows 5.3.3.0 client. The most recent Trace Facility Guide I could find was SH26-4121-01 for TSM 4.2. ... Eric - Use the TSM Problem Determination Guide: it is the current reference for tracing. Richard Sims ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Installing the Linux client
Hi Ibán! Please read my question carefully. I stated ...and I delivered him the two packages TIVsm-API.i386.rpm and TIVsm-BA.i386.rpm Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bernaldo de Quiros, Iban 1 Sent: dinsdag 25 april 2006 17:07 To: ADSM-L@VM.MARIST.EDU Subject: Re: Installing the Linux client Perhaps you are missing the client's api which need to be installed with every client. You can download the client's api from IBM ftp like the client. Regards, Ibán. -Mensaje original- De: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] En nombre de Loon, E.J. van - SPLXM Enviado el: martes, 25 de abril de 2006 15:40 Para: ADSM-L@VM.MARIST.EDU Asunto: [ADSM-L] Installing the Linux client Hi *SM-ers! One of my Unix colleagues is trying to install the TSM 5.3.3.0 client on a SLES9 distribution. I downloaded the client from ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintena nce/client/v5r3/Linux/Linux86/v533/ and I delivered him the two packages TIVsm-API.i386.rpm and TIVsm-BA.i386.rpm. He is trying to install the client on a new LINUX installation, but it fails with the following error: Package TIVsm-API-5.2.4-0.i386 was not found on the medium. Why does the 5.3 client install fail when there is no 5.2 client installed? It's a new clean installation! Thank you VERY much for any help! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Installing the Linux client
Hi David! He receives the error during the installation of the API package... Guess I will have to open a PMR for this. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: dinsdag 25 april 2006 17:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: Installing the Linux client Did he install the API before the BA? It has to be installed first. David [EMAIL PROTECTED] 4/25/2006 9:40:28 AM Hi *SM-ers! One of my Unix colleagues is trying to install the TSM 5.3.3.0 client on a SLES9 distribution. I downloaded the client from ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintena nce/client/v5r3/Linux/Linux86/v533/ and I delivered him the two packages TIVsm-API.i386.rpm and TIVsm-BA.i386.rpm. He is trying to install the client on a new LINUX installation, but it fails with the following error: Package TIVsm-API-5.2.4-0.i386 was not found on the medium. Why does the 5.3 client install fail when there is no 5.2 client installed? It's a new clean installation! Thank you VERY much for any help! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Installing the Linux client
Hi *SM-ers! One of my Unix colleagues is trying to install the TSM 5.3.3.0 client on a SLES9 distribution. I downloaded the client from ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintena nce/client/v5r3/Linux/Linux86/v533/ and I delivered him the two packages TIVsm-API.i386.rpm and TIVsm-BA.i386.rpm. He is trying to install the client on a new LINUX installation, but it fails with the following error: Package TIVsm-API-5.2.4-0.i386 was not found on the medium. Why does the 5.3 client install fail when there is no 5.2 client installed? It's a new clean installation! Thank you VERY much for any help! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Atape 8.4.9.0 and LTO3 tsm 5.1.5
Hi Otto! Checkout ftp://ftp.storsys.ibm.com/devdrvr/AIX/Atape.fixlist Ultrium 3 support was added in level 9.0.1.0. Kindest regards, Eric van Loon -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Otto Schakenbos Sent: vrijdag 21 april 2006 19:57 To: ADSM-L@VM.MARIST.EDU Subject: Atape 8.4.9.0 and LTO3 tsm 5.1.5 Dear TSMers, Does anyone know if atape 8.4.9.0 supports lto3? We want to upgrade our 3584 from lto2 to lto3. The library maanger is on aix 5.3 and has the newest atape installed (9.xx) but we still have one library client running tsm 5.1.9.3 on aix 4.3.3 and the atape 8.4.9.0. (yes we are trying to get rid of this guy). The readme is not very clear. Thanks in advance -- Otto Schakenbos System Administrator TEL: +49-7151/502 8468 FAX: +49-7151/502 8489 MOBILE: +49-172/7102715 E-MAIL: [EMAIL PROTECTED] Corporate IT Europe Teleflex Holding GmbH Fronackerstrasse 33-35 71332 Waiblingen GERMANY ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Performance tracing
Hi *SM-ers! One of my customers is complaining about the backup performance of the daily DP for SQL Server. The tdpsql.log shows that performance is 15 Mb/sec. which looks very fine to me for a host which is connected to a 100 MB LAN, but the customer showed me the TDP log from December last year which shows a daily throughput of 25 Mb/sec and more!!! My only guess is that this was caused by compression (how else can you get more than 10 Mb/sec through such a connection) but I would like to see what the client is doing. I was thinking about starting a client trace (at the DP level or at the API level?) to find this answer. What tracing parameters should I specify to see the time it takes for the client to get the data, compress it and send it over the network? I do not want to much detail, since the backup runs during the night for several hours, so a too detailed trace will grow very large... Thank you very much for any hints or tips in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Cleaning Slots on NEO 4000
Hi Bill! I don't know the answer, but I can maybe point you in the right direction. You can download the NEO 2000/4000 User Installation Guide from Overland Storage: http://support.overlandstorage.com/jive/entry.jspa?externalID=3518categ oryID=9 Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Dourado Sent: vrijdag 7 april 2006 13:38 To: ADSM-L@VM.MARIST.EDU Subject: Cleaning Slots on NEO 4000 Hi , I have 58 slots in my NEO 4000 library where 2 are reserved as cleaning slots, and autocleaning is enabled. I am running out of slots and would like to have just one cleaning slot, and later maybe have no cleaning slots reserved at all and autocleaning disabled . My problem is I have no idea how to go about it and I haven't got any NEO 4000 documentation - I am assuming the slots where configured from the Library itself. TSM Server 5.2.2.0 on Windows 2003 Any help would be appreciated. T.I.A Bill *** Disclaimer *** This email and any files transmitted with it contains privileged and confidential information and is intended for the addressee only. If you are not the intended recipient you must not disseminate, distribute or copy this email. Please notify the sender at once that you have received it by mistake and then delete it from your system. Any views expressed in this email are those of the sender and not necessarily those of ALSTEC or its associated companies. Whereas ALSTEC takes reasonable precautions to ensure this email is virus free, no responsibility will be accepted by it for any loss or damage whether direct or indirect which results from the contents of this email or its attachments. ALSTEC Group Limited - Registered in England No.3939840 - www.alstec.com Registered office: Cambridge Road, Whetstone, Leicester. LE8 6LH. England. Telephone: +44 (0)116 275 0750 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: how to define msl 6060 (or neo 4000)
Hi Nigel! I haven't got any experience with non-IBM devices, but as far as I know, you will have to use the TSM Device Support driver for non-IBM tape devices. Did you check the IBM technote for the MSL 6000 series? Here it is: http://www-1.ibm.com/support/docview.wss?rs=663uid=swg21116751 Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Nigel Howard Sent: donderdag 6 april 2006 10:29 To: ADSM-L@VM.MARIST.EDU Subject: how to define msl 6060 (or neo 4000) all, I am using aix 5.3 and tsm5.3.3 with a 3583 3xlto2 quite happily. I want to add a msl 6060 but cannot get tsm/aix to see it. I have tried smit-dev-tsm-dev, cfgmgr but nothing will become available. how do I get to the point where I can DEF LIBR? I also can test a neo 2000 if necessary. I have googled but all hits just mention defining drive onwards... -- regards Nigel . Registered Linux User #266491 . (there are 10 types of people in the world. . those who know binary, and those who don't!) ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Random Access Disk Pools
Hi Rod! TSM stores backups as aggregates. An aggregate can contain multiple client backup files. The client files within an aggregate will expire over time and thus occupy space within the aggregate. When you use a file device class or a tape, you can reclaim the wasted space these expired files occupy within the aggregates by moving unexpired files to new aggregates. This is done through reclamation. Since reclamation is only available for sequential acces storage pools, you cannot reclaim diskpools and thus the wasted space within an aggregate will only be reusable when all the files in an aggregate are expired and the aggregate is deleted. If you have backups with a very long retention in your shop, it could take quite some time before an aggregate becomes completely empty. Hope this clears thing up for you. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Park, Rod Sent: donderdag 6 april 2006 15:31 To: ADSM-L@VM.MARIST.EDU Subject: Re: Random Access Disk Pools anyone? Ideas? -Original Message- From: Park, Rod Sent: Wednesday, April 05, 2006 7:10 AM To: 'ADSM: Dist Stor Manager' Subject: RE: [ADSM-L] Random Access Disk Pools So, can someone explain the difference at the TSM level and aggregate level. Really I'm trying to understand, if I have a primary disk pool that does not migrate, it will be the final onsite resting place of data. As data expires and fragmentation occurs. That space is unusable if I'm not migrating to another primary area? Eventually I'll have to allocate more? Below is what comparison doc showed as consideration of fragmentation for random access pools. Guess I'm not sure what the diff is between tsm level and aggregate level. TSM level - fragmentation will occur as TSM allocates and frees space within the Storage Pool. Migration tends to relieve this fragmentation Aggregate level - fragmentation occurs as files expire within an aggregate. DISK pools cannot reclaim this wasted space until all files in the aggregate have expired -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rushforth, Tim Sent: Tuesday, April 04, 2006 11:21 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Random Access Disk Pools See http://www-1.ibm.com/support/docview.wss?rs=0uid=swg21218415 for comparison of disk vs devclass=file This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you are not the intended addressee, then you have received this email in error and any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please notify us immediately of your unintended receipt by reply and then delete this email and your reply. Tyson Foods, Inc. and its subsidiaries and affiliates will not be held liable to any person resulting from the unintended or unauthorized use of any information contained in this email or as a result of any additions or deletions of information originally contained in this email. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Impact of APAR IC47731
Hi Thomas! For your information: IBM just released all 5.3.3.0 servers on their FTP sites. I checked for you: it contains the fix for APAR IC47731. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: vrijdag 31 maart 2006 18:28 To: ADSM-L@VM.MARIST.EDU Subject: Impact of APAR IC47731 IC47731 has to do with poor TSM server performance under mainframe Linux, resulting from frequent use of the backtrace() function. The APAR mentions poor performance on SLES 9 and RHEL 4, both of which are based on the 2.6 Linux kernel. Does the same problem occur with SLES 8, which is based on the 2.4 kernel? The APAR states that fixing the problem 'gives TSM a big performance boost'. Does anyone who has installled the fix have quantitative information on how big 'big' is? ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
5.3.3.0 clients available
Hi *SM-ers! I noticed that the 5.3.3.0 client code has been made available on the FTP server! Request to Andy Raibeck: could you ask the FTP owner to update the /LATEST subdirectories too? They all still contain the 5.3.2.0 code... Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Prognosis for APAR IC45931
Hi Thomas! APAR IC47731 was fixed in patch level 5.3.2.3 and IC45931 was fixed in 5.3.2.1. The most recent patch level is 5.3.2.4 and your version can be downloaded from ftp://ftp.software.ibm.com/storage/tivoli-storage-management/patches/ser ver/Linux/5.3.2.4/s390x/ IBM just released a new client maintenance level and this probably means we have to wait a few months before a server maintenance release will be made available. In your case, I wouldn't wait for it and use the 5.3.2.4 patch release. Patch releases tend to be much more stable that they were in the past. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: maandag 27 maart 2006 22:20 To: ADSM-L@VM.MARIST.EDU Subject: Prognosis for APAR IC45931 We are running a mainframe Linux TSM server that is nearly out of CPU capacity. We would very much like to move to a code level with the fix for APAR IC47731, which causes a major waste of CPU capacity in mainframe Linux environments. At the moment, all levels with that fix suffer from the open APAR IC45931, which causes performance degradation for 'backup stgpool' processes reading from sequential storage pools. Since we already spend several hours per day running this type of process, this APAR would be a major problem for us. Does anyone know when there is likely to be a maintenace level that fixes both APAR's? ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Unable to archive files when there is no backup copygroup
Hi Andy! I was being hit by APAR IC45627. I had a hard time recreating the problem too, because I was using the 5.3.2.0 client, which already contains the fix for this APAR. The customer experiencing the problem was using the 5.3.0.0 base code. I will have him upgrade his version. Thank you very much for your help! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: donderdag 16 maart 2006 16:32 To: ADSM-L@VM.MARIST.EDU Subject: Re: Unable to archive files when there is no backup copygroup Hi Eric, I do not understand the problem. I made a quick attempt to reproduce the problem you are seeing by creating a domain with no backup managment class, but it has an archive management class, which is the default management class. When I attempt to do an archive from the GUI, I do not see these files as excluded. I am using 5.3.x server and client. What am I missing? Thanks, 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] IBM Tivoli Storage Manager support web page: http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorag eManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 2006-03-16 07:48:51: Hi *SM-ers! We have just implemented an archiving server. We only want archives on this TSM server, so we created policies without a backup copy group. This however causes the BA GUI to see all files as excluded. I checked the TSM website and found Technote 1209666 (http://www-1.ibm.com/support/docview.wss?rs=663context=SSGSG7q1=arc hi ve+copygroupuid=swg21209666loc=en_UScs=utf-8lang=en) which ve+verifies this behavior. So, although we don't want the user to be able to backup to this server, we have to create a backup copy group, which allows him to make backups! Is this really works as designed? This sounds more like bug to me, right? Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: TDP for Exchange: 0xc7fe1f42
Hi Del! Thank you very much for your reply! Yes, they did add the database to the Recovery Storage Group before performing the restore and they did select the this database can be overwritten by a restore option. The Exchange people also checked the storage group name and database name and cannot find any difference. The only thing they can think of causing this is the following: The storage group they are trying to restore is called SG1\MS1. On April 3rd. all mailboxes were moved to another server, the storage group was deleted, the disks were reformatted (with a new cluster size for performance), the storage group was recreated and all mailboxes were moved back. When we try a restore dated April 4th. or later, everything runs file, but when we try to restore a backup dated earlier than April 3rd. we receive the error 0xc7fe1f42. Do you have any idea what could be the cause? Thank you VERY much for your reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: dinsdag 14 maart 2006 18:17 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for Exchange: 0xc7fe1f42 Eric, I need to ask... since you didn't indicate... Did you add the database to the Recovery Storage Group before performing the restore? Does the storage group name AND database name EXACTLY match (including casing and and all characters) the one that was in the backup? The Exchange Server will fail the backup if either of those two things is not true when restoring to the Recovery Storage Group. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 03/14/2006 10:13:01 AM: Hi *SM-ers! A restore of a Exchange 2003 server to a Recovery Storage Group on a recovery server fails with the following message is the tdpexc.log: 03/14/2006 15:25:15 Restore of KL1010WF-SG1 failed. 03/14/2006 15:25:15 ACN5798E MS Exchange API HRESERESTORECOMPLETE() failed with HRESULT: 0xc7fe1f42 - Database not found. 03/14/2006 15:25:15 Total backups inspected: 4 03/14/2006 15:25:15 Total backups requested for restore: 4 03/14/2006 15:25:15 Total backups restored:3 03/14/2006 15:25:15 Throughput rate: 10,664.33 Kb/Sec 03/14/2006 15:25:15 Total bytes transferred: 3,640,110,250 03/14/2006 15:25:15 Elapsed processing time: 333.34 Secs 03/14/2006 15:25:15 ACN0151E Errors occurred while processing the request. What could be the cause of this error? Thank you very much for any reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: TSM 5.3 client release for Netware
Hi Jim! The 5.3.3.0 client maintenance release is scheduled to be released somewhere this month. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bollard Sent: woensdag 15 maart 2006 14:11 To: ADSM-L@VM.MARIST.EDU Subject: TSM 5.3 client release for Netware All, Has anyone an idea when Tivoli are releasing the next patch/maintenance release for the Netware Tivoli client, there are a few major bugs in 5.3.2.2 as it stands and are due to be rectified in the next release of the Netware Tivoli client. Regards, Jim Bollard. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Unable to archive files when there is no backup copygroup
Hi *SM-ers! We have just implemented an archiving server. We only want archives on this TSM server, so we created policies without a backup copy group. This however causes the BA GUI to see all files as excluded. I checked the TSM website and found Technote 1209666 (http://www-1.ibm.com/support/docview.wss?rs=663context=SSGSG7q1=archi ve+copygroupuid=swg21209666loc=en_UScs=utf-8lang=en) which verifies this behavior. So, although we don't want the user to be able to backup to this server, we have to create a backup copy group, which allows him to make backups! Is this really works as designed? This sounds more like bug to me, right? Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
TDP for Exchange: 0xc7fe1f42
Hi *SM-ers! A restore of a Exchange 2003 server to a Recovery Storage Group on a recovery server fails with the following message is the tdpexc.log: 03/14/2006 15:25:15 Restore of KL1010WF-SG1 failed. 03/14/2006 15:25:15 ACN5798E MS Exchange API HRESERESTORECOMPLETE() failed with HRESULT: 0xc7fe1f42 - Database not found. 03/14/2006 15:25:15 Total backups inspected: 4 03/14/2006 15:25:15 Total backups requested for restore: 4 03/14/2006 15:25:15 Total backups restored:3 03/14/2006 15:25:15 Throughput rate: 10,664.33 Kb/Sec 03/14/2006 15:25:15 Total bytes transferred: 3,640,110,250 03/14/2006 15:25:15 Elapsed processing time: 333.34 Secs 03/14/2006 15:25:15 ACN0151E Errors occurred while processing the request. What could be the cause of this error? Thank you very much for any reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: TSM client API upgrade and TDP for oracle
Hi Tae! Not, this is not nessesary. The API client is only used during a backup, so if no backup is running, you can replace all files during installation and no restart is required. However, I would wait a few days before starting the upgrade. The 5.3.3.0 client will be released this month. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tae Kim Sent: vrijdag 10 maart 2006 17:39 To: ADSM-L@VM.MARIST.EDU Subject: TSM client API upgrade and TDP for oracle Hi guys and gals, Currently I am trying to upgrade various AIX TSM clients which are v5.2.2 or V5.1.5 to TSM client version 5.3.2. I thought that clients can be upgraded with out having to upgrade TSM API but I was wrong. I do need to upgrade both the API and the clients. The issue is that these TSM clients also have TDP for oracle running. Will the upgrade of the TSM API require a restart of oracle DB (like when upgrading TDP for oracle you need to restart oracle). Thanks for your input. Tae T. Lists [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 03/10/2006 10:56 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] What table is the q drive WWN and Serial number stored in? Q drive gives a WWN and serial number, however if you just select from the DRIVES table you don't get that. What table is that information stored in? tsm: TSM02q drive * drive01 f=d Library Name: 3584LIB Drive Name: DRIVE01 Device Type: LTO On-Line: Yes Read Formats: ULTRIUM2C,ULTRIUM2,ULTRIUMC,ULTRIUM Write Formats: ULTRIUM2C,ULTRIUM2,ULTRIUMC,ULTRIUM Element: 270 Drive State: EMPTY Allocated to: * WWN: 500507630001F012 * Serial Number: 9110108472 Last Update by (administrator): STACY Last Update Date/Time: 03/09/06 16:16:17 Cleaning Frequency (Gigabytes/ASNEEDED/NONE): NONE tsm: TSM02select * from drives where drive_name='DRIVE01' LIBRARY_NAME: 3584LIB DRIVE_NAME: DRIVE01 DEVICE_TYPE: LTO ONLINE: YES READ_FORMATS: ULTRIUM2C,ULTRIU WRITE_FORMATS: ULTRIUM2C,ULTRIU ELEMENT: 270 ACS_DRIVE_ID: DRIVE_STATE: EMPTY ALLOCATED_TO: LAST_UPDATE_BY: STACY LAST_UPDATE: 2006-03-09 16:16:17.00 CLEAN_FREQ: DRIVE_SERIAL: __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com +=+ This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. +=+ ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Client versions and TSM 5.2.6.4/5.3
Hi Wanda! Where did you find a 5.1.8 client for Windows NT? The newest I can find is 5.1.7.0... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: dinsdag 7 maart 2006 19:51 To: ADSM-L@VM.MARIST.EDU Subject: Re: Client versions and TSM 5.2.6.4/5.3 Well, if you still have Windows NT 4.0 machines, there ISNT a client later than 5.1.8! It's not like you have a choice. We have a few Windows NT 4.0 machines still running 5.1.7, and in fact some Win2K clients still running 4.2. No problems. You just don't get any of the new 5.3 features. I haven't heard of anyone having problems with connecting older clients, even some VERY old Solaris V3 clients. You are just getting the standard disclaimer from IBM. On the other hand, if you are running Win2003, TSM doesn't support the backup of the system state correctly until at least 5.2.3, and you BETTER get a 5.3 client installed. Wanda Prather I/O, I/O, It's all about I/O -(me) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Mochnaczewski Sent: Tuesday, March 07, 2006 1:33 PM To: ADSM-L@VM.MARIST.EDU Subject: Client versions and TSM 5.2.6.4/5.3 Hi Everybody, Has anyone run into any issues with using 5.1.5 clients connecting to TSM 5.2.6.4 or 5.3 ? I read the IBM website and I know 5.1.5 clients are not supported but they may work. When I called IBM they said that these clients may work but once you run into problems the only help they can give is to advise us to upgrade the client version. Rich ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Undo archconversion
Hi Chris! What server and client level are you using? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Christoph Pilgram Sent: dinsdag 7 maart 2006 7:39 To: ADSM-L@VM.MARIST.EDU Subject: Undo archconversion Hi all, During expire inventory sometimes following error-message is written : ANR0106E imarqry.c(4996): Unexpected error 2 fetching row in table Archive.Objects. When I recocnize this message I do an 'undo archconversion - convert archive' for that node. Because this always happens only on one of my unix-clients I would like to know, where this problem comes from and how to permanently fix it. It happens normaly with new archives on that node. When this message comes up, some archives are not displaied when I use the GUI. Thanks for help Chris ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: TSM 5.3 web gui
Hi! I totally agree with Richard. I myself was participating in the TSM 5.3 beta program. During this beta a lot (and I really mean a lot) of the people in the beta forum where complaining about ISC and the ISC concept. It wasn't even working in the beginning, it required a powerful server with at least 2 Gb. of memory and those who managed to make it work, complained about the interface and the very slow response. One would think if that if an interface design project team sees the end result of their work, they would take a few steps back, think and say to each other: Hey, we should drop the idea and not release this to the public. But they didn't. They even ignored all the bad feedback they received from the beta community! I see similar interface design for other IBM products (like the SAN Volume Controller) which is far from intuitive. I wonder if IBM even asks customers to evaluate new interfaces. I doubt it... Kindest regards, Eric van Loon Straying from such basic objectives, and becoming distracted by architecture, results in designs which satisfy only designers...who must think that there's something wrong with the end users if they don't appreciate how wonderful the design is. ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **