maxscratch
Hi guys! I never used the maxscratch value for our VTL libraries, but I'm just wondering how it works. From the TSM Reference manual: MAXSCRatch Specifies the maximum number of scratch volumes that the server can request for this storage pool. This parameter is optional. You can specify an integer from 0 to 1. By allowing the server to request scratch volumes as needed, you avoid having to define each volume to be used. What is meant by scratch volumes here? The total amount of scratch tapes when you start with an empty TSM server or the amount of scratches in the current situation? For instance, I have a server with 4000 private tapes and 1000 scratch tapes. Should I set it to 1000 or 5000? Thanks for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: maxscratch
Hi Steven! So if I understand your explanation correctly, for a storagepool used by one server only, the maxscratch should always be equal to the total amount of volumes in this pool? So when adding new scratches, one has to raise the maxscratch with an equal amount? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Steven Langdale Sent: donderdag 9 oktober 2014 10:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: maxscratch Eric It's the max number of vols that can be used from the scratch pool by the particular stgpool. so in your instance (assuming you have a single stgpool with all 4000 private takes in it AND it got them from the scratch pool), if you set it to 1000 you won't be able to use anymore new scratch tapes until the usage goes below 1000. You can look as it as a way to stop a single stpool stealing all of the scratch tapes. Steven On 9 October 2014 08:53, Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com wrote: Hi guys! I never used the maxscratch value for our VTL libraries, but I'm just wondering how it works. From the TSM Reference manual: MAXSCRatch Specifies the maximum number of scratch volumes that the server can request for this storage pool. This parameter is optional. You can specify an integer from 0 to 1. By allowing the server to request scratch volumes as needed, you avoid having to define each volume to be used. What is meant by scratch volumes here? The total amount of scratch tapes when you start with an empty TSM server or the amount of scratches in the current situation? For instance, I have a server with 4000 private tapes and 1000 scratch tapes. Should I set it to 1000 or 5000? Thanks for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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
Lotus Domino mail archiving
Dear TSM-ers, We are currently backing up several Lotus Domino version 9 servers by using the Data Protection for IBM Domino 7.1 client. I don't know much about this client, but it's working as designed. The Lotus Notes department now wants to implement Lotus Domino mail archiving to manage the users mailbox sizes. If I understand this process correctly the archiving is managed by a separate Domino archiving server. However, I can't find much information about the integration with TSM. Can we backup this server too by using the DP for Domino client? I hope someone who is using this product can shed some light on this matter for me, thanks in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 MSSQL VSS and best practice
Hi Steven! If you are going to use the legacy backup method be sure to upgrade to 7.1.0.1 first because otherwise the legacy parameter in your tdpsql.cfg file is not processed properly. The client works but issues an error that the software is not properly configured. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Steven Harris Sent: vrijdag 25 juli 2014 5:56 To: ADSM-L@VM.MARIST.EDU Subject: TDP for MSSQL VSS and best practice -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All Having managed to finally get my customers to set up some new infrastructure with V6 TSM servers, I'm now going through the process of upgrading clients. The 5.5 TDP for SQL has long been in use, is well understood and is stable. The new TDP version 7.1 that we are moving to now has the option of VSS or legacy backups. I understand that VSS backups are essential if we need to offload backup processing or use hardware snapshots, or multiple local VSS restore points in the one day, but most of our SQL apps are small backup-in-full-once-a-day affairs. I feel inclined to continue to use legacy backup for these, mostly because of the set-up overhead and complexity for VSS. What is best practice? If you use both legacy and VSS, what criteria inform that choice? Does TSM for VE significantly affect the equation? (I don't have that yet, but the writing is on the wall) Regards Steve. Steven Harris TSM Admin, Canberra Australia. -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.22 (MingW32) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJT0dU5AAoJENyzJ5R4j0ydwIIIAKUo6HIXeG76Q5yveRi19UnZ JNGZQTdJaUK7K915GCxTA7NlC0HL5H8E9vs889kWR1oERWDQ3C/bd7+jZQ/cPBIG rWZK4vq8hsyQPKiV0Bn4V8C/o/kiOIRc8pg5V/lqvP14bbYKC29zMbwQysT+gXkZ gOICtZommjeNphA0xeve1x0abdhorqATk97xmsbdPI59JGIcG1fU4aUhsCABSY/P T0soM6XsBqZGw43Pzht2R6Ky5S7OSUhiYQgMWLCzbHCBAVgWxO+slOK/8jciZr9L C85KGMIcO+k+HBAPZIPZ8hLmM+l7K7biUhbPCgF33WryXeTbLZH94mg/ymH2rmE= =gl+l -END PGP SIGNATURE- 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
Tape corruption
Hi TSM-ers! We are using two kind of virtual tape solutions. The old solution is based on the DL4100 from EMC, the new solution is based on the DataDomain form EMC. Because we are using them as a virtual tape server one is also bound to the shortcomings of the tape protocol. If there is some kind of hick-up or congestion during the data transfer, there is no retry, the I/O just fails. I have seen multiple cases where migrations were temporarily saturating the fiber adapters of the Data Domain server or one of the switches in between and this caused an write I/O error. This resulted in a corrupted virtual tape which I think this is strange. If TSM is moving data from the diskpool to a tapepool and this I/O fails and results in an I/O error, why does it delete that data from the diskpool? The data block move should be rolled back is such a case, right? In the case where we are using the DL4100 we are using a primary and a copypool. Most of the times the data which is lost was backed up earlier by the backup stgpool of the diskpool and thus can be restored from the copypool, but in the DataDomain situation we use the DD replication and then the data on the corrupted tapes is gone forever! Thanks for any clarification in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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
GSKit 8?
Hi TSM-ers! Does anybody know where to download the required GSKit 8 files for the 7.1 Linux BA client? It's not in the tar file I downloaded from the IBM FTP server... Thank you very much for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: GSKit 8?
Hi Erwann! Never mind, I found it. I wasn't looking properly. Thanks for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Erwann Simon Sent: woensdag 14 mei 2014 15:33 To: ADSM-L@VM.MARIST.EDU Subject: Re: GSKit 8? Hi Eric, I've downloaded 7.1.0.2 yesterday and it contains those gskit packages. Can you share the link you've used ? On 14 mai 2014 15:26:52 CEST, Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com wrote: Hi TSM-ers! Does anybody know where to download the required GSKit 8 files for the 7.1 Linux BA client? It's not in the tar file I downloaded from the IBM FTP server... Thank you very much for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 -- Erwann SIMON Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté. 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 a Linux client
Hi guys! I'm not really an Linux expert, but I'm trying to upgrade a 6.2 client to 7.1 on a Linux nodes. When I follow the commands from the manual to install the API client (rpm -i TIVsm-API64.x86_64.rpm) it fails with several of the following messages: file /opt/tivoli/tsm/client/api/bin64/sample/dapiutil.c from install of TIVsm-API64-7.1.0-0.x86_64 conflicts with file from package TIVsm-API64-6.2.4-0.i586 file /opt/tivoli/tsm/client/api/bin64/sample/dpsthread.h from install of TIVsm-API64-7.1.0-0.x86_64 conflicts with file from package TIVsm-API64-6.2.4-0.i586 file /opt/tivoli/tsm/client/api/bin64/sample/dsmapips.h from install of TIVsm-API64-7.1.0-0.x86_64 conflicts with file from package TIVsm-API64-6.2.4-0.i586 I tried the -U switch, but that doesn't help either. What am I doing wrong here? Isn't it possible to upgrade the client and should I uninstall 6.2.4 first? Thanks again for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering 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
Stand-alone download 7.1 Storage Agent for Linux
Hi TSM-ers! Does anybody know if there is a separate downloadable 7.1 Storage Agent for Linux available? I don't see it on the FTP servers and from Passport Advantage I can only download it packaged together with the Linux Server which forces me to install the storage agent through the installation wizard (which uses Java, IBM Deployment Engine etc.) which is quite an overhead for the installation of the SE only... Thank you very much for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 SQL server error
Remco, It's more than a mistake in an icon. We now have to change our restore procedures and tell our users to ignore an error message when they are in the GUI or to ignore the configuration wizard when it starts. If they do not ignore the wizard and just click the next buttons all configuration files will be overwritten and this will cause the BA client to fail! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: woensdag 7 mei 2014 21:02 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Op 7 mei 2014, om 16:39 heeft Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com het volgende geschreven: Hi Del! Ok... Hm... I don't think our SQL guys will be very charmed by the work around (ignoring the error)... not ignore the error, ignore a mistake in an icon... Don't make things bigger than they are :) And I can't blame them. To my opinion these kind of bugs should not be fixed in a new (maintenance) release but it should be fixed through an immediately available fix release... However, thank you VERY much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: woensdag 7 mei 2014 16:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Hi Eric, Yes... this is APAR IC99653. http://www-01.ibm.com/support/docview.wss?uid=swg1IC99653 For now, you can remove the LOCALDSMAGENTNODE option and ignore the red X saying it isn't configured. You can still perform the legacy backup operations. Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014 09:40:57 AM: From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 05/07/2014 09:41 AM Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! The tdpsql.cfg file indeed contained the LOCALDSMAGENTNODE entry. As soon as he removes this line and starts the TDP GUI the wizard starts with the message that the TDP client has not been configured. And when he configures it through the wizard the LOCALDSMAGENTNODE line is added again... The backup method is set to legacy in the tdpsql.cfg Thank you very much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: woensdag 7 mei 2014 14:09 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Hi Eric, No. You should just be able to use legacy style backups. My guess is that the configuration wizard inadvertently added some entries causing this. Check the tdpsql.cfg file. 1. Remove the LOCALDSMAGENTNODE entry (if there is one.) 2. Make sure the BACKUPMETHOD is: BACKUPMETHOD LEGACY Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014 08:00:45 AM: From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 05/07/2014 08:01 AM Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Remco! Has this changed than? We have been using the (older) TDP client for multiple years but I never had to grant the BA client for TDP clients! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: woensdag 7 mei 2014 9:27 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error you need to grant proxy rights to the fs client for the sql client (or vv) for VSS based backups to work, legacy backups work without such proxy rights (and without the error message). Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM Eric- van.l...@klm.com het volgende geschreven: Hi TSMers! Our SQL department is testing the TDP 6.4.1 client on their SQL Server 2012 servers. Backup and restore is working fine, but they keep on receiving the following error: ANS1532E: Proxy Rejected: Proxy authority has not been granted to this node Like I said, the restore works, but it's a bit annoying and I don't understand where it's coming from, we do not use a fromnode or something... Thank you very much for your help in advance! Kind 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
Re: TDP for SQL server error
Hi Del! I will ask our SQL department for their preferred solution. Thank you VERY much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: woensdag 7 mei 2014 17:07 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Hi Eric, I agree. There is a fix for it and it is being tested now. It is targeted for the 7.1.0.1 interim and will be available once the testing has completed. If you decide you need an immediate fix, you can always open a PMR and ask for a patch. Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014 10:39:00 AM: From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 05/07/2014 10:40 AM Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! Ok... Hm... I don't think our SQL guys will be very charmed by the work around (ignoring the error)... And I can't blame them. To my opinion these kind of bugs should not be fixed in a new (maintenance) release but it should be fixed through an immediately available fix release... However, thank you VERY much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering 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
TDP for SQL server error
Hi TSMers! Our SQL department is testing the TDP 6.4.1 client on their SQL Server 2012 servers. Backup and restore is working fine, but they keep on receiving the following error: ANS1532E: Proxy Rejected: Proxy authority has not been granted to this node Like I said, the restore works, but it's a bit annoying and I don't understand where it's coming from, we do not use a fromnode or something... Thank you very much for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 SQL server error
Hi Remco! Has this changed than? We have been using the (older) TDP client for multiple years but I never had to grant the BA client for TDP clients! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: woensdag 7 mei 2014 9:27 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error you need to grant proxy rights to the fs client for the sql client (or vv) for VSS based backups to work, legacy backups work without such proxy rights (and without the error message). Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com het volgende geschreven: Hi TSMers! Our SQL department is testing the TDP 6.4.1 client on their SQL Server 2012 servers. Backup and restore is working fine, but they keep on receiving the following error: ANS1532E: Proxy Rejected: Proxy authority has not been granted to this node Like I said, the restore works, but it's a bit annoying and I don't understand where it's coming from, we do not use a fromnode or something... Thank you very much for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622 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 SQL server error
Hi Rick! No, we always use a different nodes for the BA client and the TDP client. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick Harderwijk Sent: woensdag 7 mei 2014 9:30 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Eric, Long shot: do you use the same node name for the SQL backup as for the reguler OS backup? If not, maybe it detects the hostname of the machine but the dsm.opt has a different (TDPSQL) node name so it thinks you are trying to proxy? Cheers, Rick On Wed, May 7, 2014 at 9:05 AM, Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com wrote: Hi TSMers! Our SQL department is testing the TDP 6.4.1 client on their SQL Server 2012 servers. Backup and restore is working fine, but they keep on receiving the following error: ANS1532E: Proxy Rejected: Proxy authority has not been granted to this node Like I said, the restore works, but it's a bit annoying and I don't understand where it's coming from, we do not use a fromnode or something... Thank you very much for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: TDP for SQL server error
Hi Del! The tdpsql.cfg file indeed contained the LOCALDSMAGENTNODE entry. As soon as he removes this line and starts the TDP GUI the wizard starts with the message that the TDP client has not been configured. And when he configures it through the wizard the LOCALDSMAGENTNODE line is added again... The backup method is set to legacy in the tdpsql.cfg Thank you very much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: woensdag 7 mei 2014 14:09 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Hi Eric, No. You should just be able to use legacy style backups. My guess is that the configuration wizard inadvertently added some entries causing this. Check the tdpsql.cfg file. 1. Remove the LOCALDSMAGENTNODE entry (if there is one.) 2. Make sure the BACKUPMETHOD is: BACKUPMETHOD LEGACY Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014 08:00:45 AM: From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 05/07/2014 08:01 AM Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Remco! Has this changed than? We have been using the (older) TDP client for multiple years but I never had to grant the BA client for TDP clients! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: woensdag 7 mei 2014 9:27 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error you need to grant proxy rights to the fs client for the sql client (or vv) for VSS based backups to work, legacy backups work without such proxy rights (and without the error message). Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM Eric- van.l...@klm.com het volgende geschreven: Hi TSMers! Our SQL department is testing the TDP 6.4.1 client on their SQL Server 2012 servers. Backup and restore is working fine, but they keep on receiving the following error: ANS1532E: Proxy Rejected: Proxy authority has not been granted to this node Like I said, the restore works, but it's a bit annoying and I don't understand where it's coming from, we do not use a fromnode or something... Thank you very much for your help in advance! Kind 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 SQL server error
Hi Del! Ok... Hm... I don't think our SQL guys will be very charmed by the work around (ignoring the error)... And I can't blame them. To my opinion these kind of bugs should not be fixed in a new (maintenance) release but it should be fixed through an immediately available fix release... However, thank you VERY much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: woensdag 7 mei 2014 16:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Hi Eric, Yes... this is APAR IC99653. http://www-01.ibm.com/support/docview.wss?uid=swg1IC99653 For now, you can remove the LOCALDSMAGENTNODE option and ignore the red X saying it isn't configured. You can still perform the legacy backup operations. Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014 09:40:57 AM: From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 05/07/2014 09:41 AM Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! The tdpsql.cfg file indeed contained the LOCALDSMAGENTNODE entry. As soon as he removes this line and starts the TDP GUI the wizard starts with the message that the TDP client has not been configured. And when he configures it through the wizard the LOCALDSMAGENTNODE line is added again... The backup method is set to legacy in the tdpsql.cfg Thank you very much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: woensdag 7 mei 2014 14:09 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Hi Eric, No. You should just be able to use legacy style backups. My guess is that the configuration wizard inadvertently added some entries causing this. Check the tdpsql.cfg file. 1. Remove the LOCALDSMAGENTNODE entry (if there is one.) 2. Make sure the BACKUPMETHOD is: BACKUPMETHOD LEGACY Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 05/07/2014 08:00:45 AM: From: Loon, EJ van (SPLXM) - KLM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 05/07/2014 08:01 AM Subject: Re: TDP for SQL server error Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Remco! Has this changed than? We have been using the (older) TDP client for multiple years but I never had to grant the BA client for TDP clients! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: woensdag 7 mei 2014 9:27 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error you need to grant proxy rights to the fs client for the sql client (or vv) for VSS based backups to work, legacy backups work without such proxy rights (and without the error message). Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM Eric- van.l...@klm.com het volgende geschreven: Hi TSMers! Our SQL department is testing the TDP 6.4.1 client on their SQL Server 2012 servers. Backup and restore is working fine, but they keep on receiving the following error: ANS1532E: Proxy Rejected: Proxy authority has not been granted to this node Like I said, the restore works, but it's a bit annoying and I don't understand where it's coming from, we do not use a fromnode or something... Thank you very much for your help in advance! Kind 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 For information, services
VTL label unreadable, I'm stuck.
Hi TSM-ers! In one of my virtual libraries I found 4 tapes which were unavailable. I updated them to read-only and issued a move data for them. This failed due to the following error: 04/22/2014 14:39:13 ANR8355E I/O error reading label for volume 020408 in drive TVTL_TLSP2_1_DR38 This looks like an unlabeled tape, but it's a private tape used in a primary storage pool! So I tried relabeling it with overwrite=yes: 04/22/2014 14:59:11 ANR8816E LABEL LIBVOLUME: Volume 020408 in library TVTL_TLSP2_1 cannot be labeled because it is currently defined in a storage pool or in the volume history file. Now what... I can't read the data on the tape since the label is corrupt and I can't relabel it because there is data on it! Thank you very much for your suggestions in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: LAN-free to disk
Hi Joerg! Thank you very much for your reply! Strange thing is that I cannot find anything about this in the TSM manuals, nor can I find a technote how to setup something like that... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Joerg Pohlmann Sent: donderdag 20 maart 2014 16:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: LAN-free to disk Eric, you can use GPFS. Joerg - Original Message - From: EJ van Loon (SPLXM) - KLM eric-van.l...@klm.com To: ADSM-L@VM.MARIST.EDU Sent: Thursday, March 20, 2014 7:58:31 AM Subject: [ADSM-L] LAN-free to disk Hi guys! I read in several IBM documents lines like TSM also supports some configurations with LAN-free to disk-based storage pools and ... If you are implementing one of TSM's supported LAN-free to disk solutions... but I cannot find any details about these supported configurations. I know one had to buy Sanergy in the past, but as far as I can see it no longer exists... Thanks in advance for your reply! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: LAN-free to disk
Hi Angela! Both articles talk about LAN-free to tape, not to disk... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Angela Robertson Sent: vrijdag 21 maart 2014 0:23 To: ADSM-L@VM.MARIST.EDU Subject: Re: LAN-free to disk There is an article in the TSM wiki re: using LAN-free with TSM VE: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Tivoli%20Storage%20Manager/page/Recommendations%20for%20Using%20LAN-free%20with%20Tivoli%20Storage%20Manager%20for%20Virtual%20Environments There's also info in the IBM Knowledge Center at http://www-01.ibm.com/support/knowledgecenter/SSGSG7_7.1.0/com.ibm.itsm.srv.doc/t_lanfree_config_win.html . If you want LAN-free info for FlashCopy Manager, I can post links, but I don't think that's the question. If you cannot find what you want in the IBM Knowledge Center, you can use the Feedback link at the bottom. When you use that Feedback link, the people who write the information are supposed to get the feedback. We can get the content you need published. Angela Angela Robertson IBM Software Group Durham, NC 27703 aprob...@us.ibm.com ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 03/20/2014 11:20:18 AM: From: Joerg Pohlmann jpohlm...@shaw.ca To: ADSM-L@vm.marist.edu Date: 03/20/2014 11:27 AM Subject: Re: [ADSM-L] LAN-free to disk Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Eric, you can use GPFS. Joerg - Original Message - From: EJ van Loon (SPLXM) - KLM eric-van.l...@klm.com To: ADSM-L@VM.MARIST.EDU Sent: Thursday, March 20, 2014 7:58:31 AM Subject: [ADSM-L] LAN-free to disk Hi guys! I read in several IBM documents lines like TSM also supports some configurations with LAN-free to disk-based storage pools and ... If you are implementing one of TSM's supported LAN-free to disk solutions... but I cannot find any details about these supported configurations. I know one had to buy Sanergy in the past, but as far as I can see it no longer exists... Thanks in advance for your reply! Kind regards, Eric van Loon AF/KLM Storage Engineering 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
LAN-free to disk
Hi guys! I read in several IBM documents lines like TSM also supports some configurations with LAN-free to disk-based storage pools and ... If you are implementing one of TSM's supported LAN-free to disk solutions... but I cannot find any details about these supported configurations. I know one had to buy Sanergy in the past, but as far as I can see it no longer exists... Thanks in advance for your reply! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 statement to list fs not backed up sorted on size
Hi Skylar! Thank you very much for your help! The end result looks like this, just so it's available for others in the ADSM-L archives: SELECT f.node_name as Node Name,f.filespace_name as Filespace Name,o.physical_mb as MB Stored,date(f.backup_end) as Last Backup Date FROM filespaces f, occupancy o WHERE (days(f.backup_end) (days(current_date)-30)) and f.node_name=o.node_name and f.filespace_name=o.filespace_name ORDER BY o.physical_mb DESC Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Skylar Thompson Sent: donderdag 13 maart 2014 17:37 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL statement You'll want to do a join across both tables on the node name. Something like this: SELECT f.node_name,f.filespace_name,o.physical_mb - FROM filespaces f - INNER JOIN occupancy o ON f.node_name=o.node_name - WHERE - (days(f.backup_end) (days(current_date)-30)) - ORDER BY o.physical_mb DESC On Thu, Mar 13, 2014 at 05:16:37PM +0100, Loon, EJ van (SPLXM) - KLM wrote: Dear TSM-ers, I'm trying to generate a SQL statement to create a list of filespaces which are not backed up for more than 30 days, sorted on their occupancy size. This is what I've got so far: select node_name, filespace_name, physical_mb from occupancy where filespace_name in (select filespace_name from filespaces where (days(filespaces.backup_end) (days(current_date)-30))) order by physical_mb desc It doesn't work however, because filespace names are not unique. As soon as a different node is found with the same filespace_name it's listed too and that's not what I'm aiming for. I guess nested SQL is not the way to go, but I don't know the solution. Thanks you very much for your help in advance!!! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 -- -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine 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 statement
Dear TSM-ers, I'm trying to generate a SQL statement to create a list of filespaces which are not backed up for more than 30 days, sorted on their occupancy size. This is what I've got so far: select node_name, filespace_name, physical_mb from occupancy where filespace_name in (select filespace_name from filespaces where (days(filespaces.backup_end) (days(current_date)-30))) order by physical_mb desc It doesn't work however, because filespace names are not unique. As soon as a different node is found with the same filespace_name it's listed too and that's not what I'm aiming for. I guess nested SQL is not the way to go, but I don't know the solution. Thanks you very much for your help in advance!!! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: Moving Oracle and DB2 nodes between servers.
Hi Steve! This is exactly the reason why we decided for the hybrid migration scenario after all. It's a big bang method, but it saved a lot of people an enormous amount of work... The only thing I do not agree with is what your DBA tell you about how RMAN works. RMAN by default knows nothing about what's really stored in TSM. It does not sync with TSM by default, so when you delete obsolete objects through RMAN it just deletes TSM files on your new server which are not there (yet). You need to run tdposync to sync TSM with RMAN afterwards. So, when a node is exported to the new server, you have to remove (through tdposync) the objects which RMAN removed from it's catalog between the time of the node switch and the time of the finish of the export. Or you can decide to hold the RMAN job/task which removes the obsolete backups until all data is exported to the new server. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Steven Harris Sent: dinsdag 11 maart 2014 11:47 To: ADSM-L@VM.MARIST.EDU Subject: Moving Oracle and DB2 nodes between servers. Hi All I'm planning a slow, node-by-node migration from V5 to V6 for one of my customers. The database is too big to do anything else. For most types of node, this is not an issue, Move the node to the new server, wait for most of the data to expire and export/import the remainder (there is some 7-year retention on just about every B/A node). Oracle is an issue. As soon as we switch an Oracle node to the new server, the backups on the old server will cease expiring. Further the DBAs tell me that RMAN for Oracle 8i will see that its catalog and TSM don't match and will remove all the rman entries for the old backups. Apparently Oracle 9i just marks them as invalid. I know that there are at least some backups that need to be kept for longer than the standard, so I can't just go and delete everything after 40 days or whatever. The customer is very rigid about keeping data and won't be talked around. This has me at a complete loss. Our biggest node backs up 2.5 TB per day and we usually keep 40 days worth so an export/import of everything is not going to fly and there is the issue of how to sync up on the receiving side anyway. I might be able to use fromdate/time and todate/time to select just the files that I need. I also have a similar issue with DB2, although I've discovered that I can delete a DB2 backup using the BA command line, at least under AIX. There is however no utility similar to tdposync for DB2, so even if I had the data from the V5 server I don't know how to tell DB2 that it is there. Has anyone wrestled these particular demons, and how did it work out? The DBAs are way outside their comfort zone and I'm just as uncomfortable. Thanks Steve Steven Harris TSM Admin Canberra Australia 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: Database Backup best practice
Well, isn't it actually the other way around? You should set your REUSEDelay to the amount of days you keep your database backups. In case of a failure you will probably always want to restore the most recent database backup, but if that one fails too for some reason, you will have to fall back on older database backups. Of course this means losing backup information and it's for your shop to decide what is acceptable. We keep our database backups for 3 days (twice a day) and thus the REUSEDelay is set to 3 days. Since we don't use physical tape I think 3 days (equals 6 backups) is long enough. Keeping database backups for a longer period of time means a higher REUSEDelay and thus requires more scratch volumes. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ehresman,David E. Sent: maandag 17 februari 2014 15:31 To: ADSM-L@VM.MARIST.EDU Subject: Re: Database Backup best practice You should keep at least as many TSM DB backups as the largest REUSEDelay on your storagepools. David -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tom Taylor Sent: Monday, February 17, 2014 9:27 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Database Backup best practice Good morning Running TSM 6.3.4 I have read the admin guide best practice section on backing up the database and I have also done some google searching but I cannot find a straight answer on this... How many backups of the database should I keep available? I always do a full backup, is there any reason to keep any of the older full backups if I have a recent good one? Thomas Taylor System Administrator Jos. A. Bank Clothiers Cell (443)-974-5768 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: Restoring Linux 6.1 server DB to new machine
Hi Zoltan! It's probably a permission issue on the dsmserv.dbid, checkout the IBM Technote 21641644: http://www-01.ibm.com/support/docview.wss?uid=swg21641644 Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan Forray Sent: maandag 10 februari 2014 20:20 To: ADSM-L@VM.MARIST.EDU Subject: Restoring Linux 6.1 server DB to new machine I am testing a restore and conversion/upgrade of my last 6.1 server, before it becomes a pumpkin in April! I am having issues following the wonderful, detail, draft manual, since it doesn't give specifics as to who I should be when I perform various tasks. For instance, after installing and configuring 6.1, the restore process says to do a dsmserv removedb TSMDB1. But it fails to tell me (and the command failed) that I should be logged in as the DB2 instance user (tsminst1), not root. Yes, all filesystems have the proper ownership. So, I figured I would need to stay as the DB2 instance (vs root), for the restore process. While most of the restore process seemed to go OK, I had some errors that seem to indicate I should have been root. In the beginning of the dsmserv restore db, I got this error: *rm: cannot remove `/tsmarchlog': Permission denied* *mkdir: cannot create directory `/tsmarchlog': File exists* Of course this confused me since I needed to define these for the install process and the book didn't say I should delete it, so why would the restore try to recreate them? But since the empty directory was already there with the proper ownership, I ignored it. Then after the restore ran for 2-hours (200GB DB and low-power test machine), it ends with this: *ANR4917I Point-in-time database restore with snapshot complete, restore date 01/16/2014 09:18:53 AM.* *ANR0222E Error opening for write disk definition file dsmserv.dbid.* *Error 2104 updating database ID file.* *ANR2988W Attempt to add the last backup db volume used entry back in to the volume history was unsuccessful.* The ever helpful user manual for ANR0222E says Attempt to determine the cause of the write error and correct it. - Thanks, guys.. This sounds more serious? Before I waste another 2-hours, should I start all over again, doing the restore via root or is this something I can correct, and how? Thoughts? Suggestions? -- *Zoltan Forray* TSM Software Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html 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 Statement
Hi Jeff! Thank you VERY much for your reply! You did put me on the right track. It resulted in the most complex SQL statement I ever created: select a.node_name as Nodename,count(*) as - Amount of backup files older than 30 days from backups a,nodes b - where ((days(current_date) - days(backup_date) = 30)) and a.node_name - like '%-ORC' and a.state='ACTIVE_VERSION' and a.node_name=b.node_name - and b.contact like 'Airpas%' group by a.node_name But it's working. Thanks!!! And don't forget the a.node_name like statement to limit the amount of nodes, otherwise it will go through the entire backups table, which is quite a lengthy process. Kind regards, Eric van Loon AF/KLM Storage Engineering From: White, Jeff [mailto:jeff.wh...@uuplc.co.uk] Sent: maandag 30 december 2013 12:42 To: Loon, EJ van - SPLXM Subject: SQL Statement Hi Eric Try this: select a.node_name, count(*) from backups a, nodes b where a.node_name = b.node_name and b.contact like 'Airpas%' group by a.node_name Jeff White The information contained in this e-mail is intended only for the individual to whom it is addressed. It may contain legally privileged or confidential information or otherwise be exempt from disclosure. If you have received this Message in error or there are any problems, please notify the sender immediately and delete the message from your computer. You must not use, disclose, copy or alter this message for any unauthorised purpose. Neither United Utilities Group PLC nor any of its subsidiaries will be liable for any direct, special, indirect or consequential damages as a result of any virus being passed on, or arising from the alteration of the contents of this message by a third party. United Utilities Group PLC, Haweswater House, Lingley Mere Business Park, Lingley Green Avenue, Great Sankey, Warrington, WA5 3LP Registered in England and Wales. Registered No 6559020 www.unitedutilities.com www.unitedutilities.com/subsidiaries 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 statement
Hi guys! I'm trying to make an SQL statement which uses the Nodes table and the Backups table. It should do a count (*) from backups for files older than 30 days but only when the Contact field starts with 'Airpas. Here is what I got so far: select nodes.node_name as Nodename,count(*) as Amount of backup files older than 30 days from nodes, backups where ((days(nodes.current_date) - days(nodes.backup_date) = 30)) and nodes.contact like 'Airpas%' and backups.state='ACTIVE_VERSION' group by nodes.node_name It's not correct and it probably has to do with the count(*) part, because I don't know how you can specify that the count(*) is related to the backups table. Can somebody help me here please? Thanks you very much in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: Space reclamation is ended for volume
Hi Mickael! Audit the volume like this: Audit vol S:\TSM_FILE_DEVCLASS\16AA.BFS This will show you the files which are corrupted on the volume. It could be that the volume was corrupted after a successful backup stgpool, so first try a restore: Restore volume S:\TSM_FILE_DEVCLASS\16AA.BFS If the restore is successful the volume should be empty afterwards, if not you will have to perform an audit again but with the fix=yes: Upd vol S:\TSM_FILE_DEVCLASS\16AA.BFS access=readonly Audit vol S:\TSM_FILE_DEVCLASS\16AA.BFS fix=yes Bear in mind that the corrupted files will be deleted from TSM. If these files are Backup/archive client files it's not a very big issue: they will be backed up again during the next backup cycle. Are the files part of a TDP backup then things are different, in that case your whole backup series is corrupted and you will have to schedule a new full backup for that TDP client a.s.a.p. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of mik Sent: donderdag 12 december 2013 9:54 To: ADSM-L@VM.MARIST.EDU Subject: Space reclamation is ended for volume Hi everybody, My problem __ ANRD_1627081930 (ssrecons.c:784) Thread52: Byte count mismatch for object 0.206273217 source: 0.62939, target: 0.920075 (PROCESS: 327) ANRD Thread52 issued message from: (PROCESS: 327) ANR1092E Space reclamation is ended for volume S:\TSM_FILE_DEVCLASS\16AA.BFS. An internal server error was detected. (PROCESS: 327) ANRD Thread52 issued message 1092 from: (PROCESS: 327) __ I try to update volume S:\TSM_FILE_DEVCLASS\16AA.BFS access=readonly and perform a move data but i have this ANR0984I Process 54 for MOVE DATA started in the BACKGROUND at 09:32:18. ANR1140I Move data process started for volume S:\TSM_FILE_DEVCLASS\16AA.BFS (process ID 54). ANR8340I FILE volume S:\TSM_FILE_DEVCLASS\4508.BFS mounted. ANR8340I FILE volume S:\TSM_FILE_DEVCLASS\16AA.BFS mounted. ANR0513I Process 54 opened output volume S:\TSM_FILE_DEVCLASS\4508.BFS. ANR0512I Process 54 opened input volume S:\TSM_FILE_DEVCLASS\16AA.BFS. ANRD_1627081930 (ssrecons.c:784) Thread59: Byte count mismatch for object 0.206273217 source: 0.62939, target: 0.920075 ANRD Thread59 issued message from: ANR1156W Move data process terminated for volume S:\TSM_FILE_DEVCLASS\16AA.BFS - internal server error detected. ANRD Thread59 issued message 1156 from: ANR0985I Process 54 for MOVE DATA running in the BACKGROUND completed with completion state FAILURE at 09:32:18. ANR0514I Session 995 closed volume S:\TSM_FILE_DEVCLASS\16AA.BFS. ANR0514I Session 995 closed volume S:\TSM_FILE_DEVCLASS\4508.BFS. Anyone have a idea to correct this error? Regards, Mickael. +-- |This was sent by bobpatrick808...@yahoo.fr via Backup Central. |Forward SPAM to ab...@backupcentral.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
Support for Oracle 9i
Hi guys! We still have several systems running Oracle 9 databases. Some of them can't be upgraded because the application on top of the database does not support Oracle 10 (yet). Anyway, Oracle still delivers sustaining support for Oracle 9, but support for backing up their databases (through the TDP for Oracle 5.5 client) will end by April 30 next year. Same goes for the TDP for ERP client. The 5.5 client is the highest version available for mySAP with an Oracle 9 database and thus it's EOS next April. How do you cope with that? I think IBM should come up with a solution for this, right? Kind regards, Eric van Loon AF/KLM Storage Engineering 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: Support for Oracle 9i
Hi Remco! I heard that IBM will not offer extended support for 5.5. I'll have to check with our sales rep. I do accept that it won't break. It has been running fine for years, so one can say it's proven technology by now. The only problem is that my customers will probably not accept it... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: woensdag 11 december 2013 11:47 To: ADSM-L@VM.MARIST.EDU Subject: Re: Support for Oracle 9i RPQ for extended support? If the DB is important enough that should fly :) Or just accept that it won't break just because support ends Op 11 dec. 2013, om 11:15 heeft Loon, EJ van - SPLXM eric-van.l...@klm.com het volgende geschreven: Hi guys! We still have several systems running Oracle 9 databases. Some of them can't be upgraded because the application on top of the database does not support Oracle 10 (yet). Anyway, Oracle still delivers sustaining support for Oracle 9, but support for backing up their databases (through the TDP for Oracle 5.5 client) will end by April 30 next year. Same goes for the TDP for ERP client. The 5.5 client is the highest version available for mySAP with an Oracle 9 database and thus it's EOS next April. How do you cope with that? I think IBM should come up with a solution for this, right? Kind regards, Eric van Loon AF/KLM Storage Engineering 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 -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622 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 statement generates an ANR9999D
Hi TSM-ers! I'm trying to build an SQL statement to measure expiration performance, but I'm experiencing an ANRD error. I stripped it down to the following statement: select cast(timestampdiff(2,end_time-start_time) as decimal(4,0)) from summary where activity='EXPIRATION' As soon as I enter this command I receive the following error in the activity log: 12/05/2013 13:22:45 ANRD Thread239884 issued message 486 from: (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x00010001ab84 StdPutMsg (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x00010001c2c4 outMsgf (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x00010028334c smEndMessage (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x00010027b96c smExecuteSession (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x0001000a824c psSessionThread (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x0001c468 StartThread (SESSION: 108135) Could someone try this command on his server to see if it's a general bug or if it's caused by something in my databases? I see the same behavior on three different servers... Thanks for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 statement generates an ANR9999D
Hi Ronald! Thanks for trying! I'm running 6.2.5.0. I just discovered that when I change 4,0 to 8,0 it works. Looks like a bug to me... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ronald Le Large Sent: donderdag 5 december 2013 14:17 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL statement generates an ANRD Eric, I can execute the sql without receiving the ANR I run it on V 6.3.3.0 Kind regards, Ronald Le Large Information technology officer Storage Management | Dir. 2.8.4.1 European Patent Office -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: Thursday, December 05, 2013 2:07 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL statement generates an ANRD Hi TSM-ers! I'm trying to build an SQL statement to measure expiration performance, but I'm experiencing an ANRD error. I stripped it down to the following statement: select cast(timestampdiff(2,end_time-start_time) as decimal(4,0)) from summary where activity='EXPIRATION' As soon as I enter this command I receive the following error in the activity log: 12/05/2013 13:22:45 ANRD Thread239884 issued message 486 from: (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x00010001ab84 StdPutMsg (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x00010001c2c4 outMsgf (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x00010028334c smEndMessage (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x00010027b96c smExecuteSession (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x0001000a824c psSessionThread (SESSION: 108135) 12/05/2013 13:22:45 ANRD Thread239884 0x0001c468 StartThread (SESSION: 108135) Could someone try this command on his server to see if it's a general bug or if it's caused by something in my databases? I see the same behavior on three different servers... Thanks for your help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: TDP for SQL Server
Hi Del! Our SQL guys did some testing with the new SQL client. When you install 6.4.0 and 6.4.1 afterwards the wizards starts fine. In fact the following thing changed: In the early days we installed the TDP client and copied the license file afterwards. This always worked, but not anymore. When you copy the license file BEFORE installing the TDP client, the wizard starts fine. So one first has to copy the license file to C:\Program Files\Tivoli\TSM\TDPSql and then you can immediately install the 6.4.1 client, which starts the wizard. This is an acceptable work-around for the SQL guys, the only thing to keep in mind is that part of the 6.4.1 client is the installation of the .NET 4.5 framework which requires a reboot! Not very desirable in a production environment, so this has to be carefully planned. Anyway, thank you very much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: vrijdag 1 november 2013 15:58 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, What happens if you install 6.4.0 first, then follow it with an upgrade to 6.4.1? The book is written to follow that method since it is the best practice method to get the paid (base) license installed first, then follow it with the PTF (fix) package. This is slightly different than the BA client, since the BA client does not have the requirement of the license file. Thanks, Del Del Hoobler Tivoli Storage Manager Development IBM Software Group - Cloud Smarter Infrastructure IBM Corporation ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013 09:01:24 AM: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 11/01/2013 09:03 AM Subject: Re: TDP for SQL Server Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! I removed the 6.3 client and installed 6.4.1. This installer is also not working according to the manual. Here's what I did: I downloaded 6.4.1 from the FTP site, downloaded 6.4.0 from Passport Advantage I extracted the sqlclient.lic from the 6.4.0 package I extracted the 6.4.1 package to C:\tsm_images (again, a different installer: 7z. Why?!?) I executed SetupFCM.exe from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win. It installed the framework, the server had to be rebooted and the FCM installation continued afterwards. You stated that I had to copy the license file to c:\Program Files\TSM\TDPsql afterwards, but that directory does not exist yet! I then installed the TDP client manually from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win\fcm\x64\sql\6410\enu by running the setup.exe. The directory to c:\Program Files\TSM\TDPsql then was created and I could copy the license file to it. After clicking the TDP for SQL link the setup wizard started and we could successfully configure the TDP client. Now it works. So, the SetupFCM does not start the TDPsql installation afterwards which seems to be a bug to me since the manual does not specify that you have to do this manually afterwards. Thanks for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: vrijdag 1 november 2013 11:46 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, This may have been an issue with the 6.3.1 version. Did you get the latest 6.4.1 package? http://www-01.ibm.com/support/docview.wss?uid=swg24035560 After installing it, make sure the sqlclient.lic is in the C:\Program Files\Tivoli\TSM\TDPSql directory. (or wherever you installed DP for SQL.) After doing so, start the MMC GUI. On the left hand side of the MMC GUI you should see a treeview that looks something like this: IBM Tivoli Data Protection - IBM Tivoli Storage Manager - Dashboard - SERVER1 - Manage + Configuration + Diagnostics + Learning If you are not seeing this, open a PMR, maybe something else is wrong with the configuration seeing the license file. Thanks, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013 06:09:01 AM: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 11/01/2013 06:09 AM Subject: Re: TDP for SQL Server Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! According to the manual I have to run setupfcm.exe. This indeed installs a link in the start menu to the TDP for SQL client. As soon as I click it, it start the console with IBM Tivoli Data Protection listed, with IBM Tivoli FlashCopy Manager underneath, along with the license file not found error. The manual than states that the TSM configuration wizard should start. It does
SQL query in v6 server
Hi TSM-ers! We just migrated a second server to v6 and now I need to 'patch' TSM Operational Reporter. Among others, the following SQL statement no longer works: select node_name, platform_name, date(lastacc_time) from nodes where cast((current_timestamp-lastacc_time)days as decimal) =2 and contact like 'Component Team Linux%%' It must have something to do with the cast part, because when I leave that out it works fine. I have a hard time finding the correct information about rewriting your SQL queries, so if somebody could help me out, I'll appreciate it! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 query in v6 server
Thank you all for your help, I really appreciate it! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Colwell, William F. Sent: woensdag 20 november 2013 17:40 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL query in v6 server Hi Eric, the timestampdiff function will do what you need. This works - select node_name, platform_name, date(lastacc_time) - from nodes - where cast(timestampdiff(16, current_timestamp - lastacc_time) as decimal(4,1)) 2 The first number in timestampdiff can be - 1 Fractions of a second 2 Seconds 4 Minutes 8 Hours 16 Days 32 Weeks 64 Months 128 Quarters 256 Years For full details on this and other functions, download the db2 9.7 sql reference volume 1. Bill Colwell Draper Lab -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: Wednesday, November 20, 2013 10:40 AM To: ADSM-L@VM.MARIST.EDU Subject: SQL query in v6 server Hi TSM-ers! We just migrated a second server to v6 and now I need to 'patch' TSM Operational Reporter. Among others, the following SQL statement no longer works: select node_name, platform_name, date(lastacc_time) from nodes where cast((current_timestamp-lastacc_time)days as decimal) =2 and contact like 'Component Team Linux%%' It must have something to do with the cast part, because when I leave that out it works fine. I have a hard time finding the correct information about rewriting your SQL queries, so if somebody could help me out, I'll appreciate it! Kind regards, Eric van Loon AF/KLM Storage Engineering 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
Export server-to-server slooooooooooow
Hi guys! We just completed our first server migration (hybrid method) from 5.5 to 6.2. Everything went smoothly, but now I want to export the missing data (written to the v5 server after the database backup) to the v6 server, but the export process is running s slw! Anybody know why this is? There is no load on the source server en plenty of bandwith on the target server, but export is crawling (about 5 Gb/hour). Thanks for any help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 SQL Server
Hi Del! According to the manual I have to run setupfcm.exe. This indeed installs a link in the start menu to the TDP for SQL client. As soon as I click it, it start the console with IBM Tivoli Data Protection listed, with IBM Tivoli FlashCopy Manager underneath, along with the license file not found error. The manual than states that the TSM configuration wizard should start. It does not. The manual states that you can start the wizard manually by clicking Manage Configuration Wizard, but there is no Manage option to click! Thanks again for your help. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: maandag 28 oktober 2013 14:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, You might want to get the latest version, 6.4.1. http://www-01.ibm.com/support/docview.wss?uid=swg24035560 This has the latest support and fixes. As Wanda stated, after you install, you need to run the setup wizard. Here is a pointer to some installation/configuration steps: http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.sql .doc/t_dpsql_quick_inst_cfg.html If you are still having issues, please call support. Thanks, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013 09:10:41 AM: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 10/28/2013 09:12 AM Subject: Re: TDP for SQL Server Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! We have installed the 6.3.1.0 client and copied the license file from the 6.3.0.0 distribution (from Passport Advantage) into this directory, but as soon as the DP for SQL Manager Console icon is clicked, the console comes up with only the Flashcopy Manager listed... Thanks for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: maandag 28 oktober 2013 12:05 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, This is expected. FlashCopy Manager, Data Protection for SQL, and Data Protection for Exchange now share the same MMC GUI interface. To make sure you have the correct product installed, look for a file called sqlclient.lic in the C:\Program Files\Tivoli\TSM\TDPSql directory. Thanks, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013 05:45:50 AM: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 10/28/2013 05:47 AM Subject: TDP for SQL Server Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi guys! We are trying to install the TDP for SQL Server 6.3.1.0 client on one of our SQL server, but instead of installing the TDP client it installs the FlashCopy Manager client. The console does not list the TDP for SQL client after installation... Thank you very much for any help. Kind regards, Eric van Loon AF/KLM Storage Engineering 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
Re: TDP for SQL Server
Hi Del! I removed the 6.3 client and installed 6.4.1. This installer is also not working according to the manual. Here's what I did: I downloaded 6.4.1 from the FTP site, downloaded 6.4.0 from Passport Advantage I extracted the sqlclient.lic from the 6.4.0 package I extracted the 6.4.1 package to C:\tsm_images (again, a different installer: 7z. Why?!?) I executed SetupFCM.exe from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win. It installed the framework, the server had to be rebooted and the FCM installation continued afterwards. You stated that I had to copy the license file to c:\Program Files\TSM\TDPsql afterwards, but that directory does not exist yet! I then installed the TDP client manually from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win\fcm\x64\sql\6410\enu by running the setup.exe. The directory to c:\Program Files\TSM\TDPsql then was created and I could copy the license file to it. After clicking the TDP for SQL link the setup wizard started and we could successfully configure the TDP client. Now it works. So, the SetupFCM does not start the TDPsql installation afterwards which seems to be a bug to me since the manual does not specify that you have to do this manually afterwards. Thanks for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: vrijdag 1 november 2013 11:46 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, This may have been an issue with the 6.3.1 version. Did you get the latest 6.4.1 package? http://www-01.ibm.com/support/docview.wss?uid=swg24035560 After installing it, make sure the sqlclient.lic is in the C:\Program Files\Tivoli\TSM\TDPSql directory. (or wherever you installed DP for SQL.) After doing so, start the MMC GUI. On the left hand side of the MMC GUI you should see a treeview that looks something like this: IBM Tivoli Data Protection - IBM Tivoli Storage Manager - Dashboard - SERVER1 - Manage + Configuration + Diagnostics + Learning If you are not seeing this, open a PMR, maybe something else is wrong with the configuration seeing the license file. Thanks, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013 06:09:01 AM: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 11/01/2013 06:09 AM Subject: Re: TDP for SQL Server Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! According to the manual I have to run setupfcm.exe. This indeed installs a link in the start menu to the TDP for SQL client. As soon as I click it, it start the console with IBM Tivoli Data Protection listed, with IBM Tivoli FlashCopy Manager underneath, along with the license file not found error. The manual than states that the TSM configuration wizard should start. It does not. The manual states that you can start the wizard manually by clicking Manage Configuration Wizard, but there is no Manage option to click! Thanks again for your help. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: maandag 28 oktober 2013 14:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, You might want to get the latest version, 6.4.1. http://www-01.ibm.com/support/docview.wss?uid=swg24035560 This has the latest support and fixes. As Wanda stated, after you install, you need to run the setup wizard. Here is a pointer to some installation/configuration steps: http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.db.s ql .doc/t_dpsql_quick_inst_cfg.html If you are still having issues, please call support. Thanks, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013 09:10:41 AM: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 10/28/2013 09:12 AM Subject: Re: TDP for SQL Server Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! We have installed the 6.3.1.0 client and copied the license file from the 6.3.0.0 distribution (from Passport Advantage) into this directory, but as soon as the DP for SQL Manager Console icon is clicked, the console comes up with only the Flashcopy Manager listed... Thanks for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: maandag 28 oktober 2013 12:05 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, This is expected. FlashCopy Manager, Data Protection for SQL, and Data Protection for Exchange now share the same MMC GUI interface. To make sure you
Re: TDP for SQL Server
Hi Del! I will have to try this on a different machine. I will let you know next week. If that's the new way to install the client, I think it has not improved compared to the old way. We always installed the most recent patch level and added the license file afterwards. It's much easier and faster, don't you agree? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: vrijdag 1 november 2013 15:58 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, What happens if you install 6.4.0 first, then follow it with an upgrade to 6.4.1? The book is written to follow that method since it is the best practice method to get the paid (base) license installed first, then follow it with the PTF (fix) package. This is slightly different than the BA client, since the BA client does not have the requirement of the license file. Thanks, Del Del Hoobler Tivoli Storage Manager Development IBM Software Group - Cloud Smarter Infrastructure IBM Corporation ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013 09:01:24 AM: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 11/01/2013 09:03 AM Subject: Re: TDP for SQL Server Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! I removed the 6.3 client and installed 6.4.1. This installer is also not working according to the manual. Here's what I did: I downloaded 6.4.1 from the FTP site, downloaded 6.4.0 from Passport Advantage I extracted the sqlclient.lic from the 6.4.0 package I extracted the 6.4.1 package to C:\tsm_images (again, a different installer: 7z. Why?!?) I executed SetupFCM.exe from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win. It installed the framework, the server had to be rebooted and the FCM installation continued afterwards. You stated that I had to copy the license file to c:\Program Files\TSM\TDPsql afterwards, but that directory does not exist yet! I then installed the TDP client manually from C:\tsm_images\6.4.1.0-TIV-TSMSQL-Win\fcm\x64\sql\6410\enu by running the setup.exe. The directory to c:\Program Files\TSM\TDPsql then was created and I could copy the license file to it. After clicking the TDP for SQL link the setup wizard started and we could successfully configure the TDP client. Now it works. So, the SetupFCM does not start the TDPsql installation afterwards which seems to be a bug to me since the manual does not specify that you have to do this manually afterwards. Thanks for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: vrijdag 1 november 2013 11:46 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, This may have been an issue with the 6.3.1 version. Did you get the latest 6.4.1 package? http://www-01.ibm.com/support/docview.wss?uid=swg24035560 After installing it, make sure the sqlclient.lic is in the C:\Program Files\Tivoli\TSM\TDPSql directory. (or wherever you installed DP for SQL.) After doing so, start the MMC GUI. On the left hand side of the MMC GUI you should see a treeview that looks something like this: IBM Tivoli Data Protection - IBM Tivoli Storage Manager - Dashboard - SERVER1 - Manage + Configuration + Diagnostics + Learning If you are not seeing this, open a PMR, maybe something else is wrong with the configuration seeing the license file. Thanks, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 11/01/2013 06:09:01 AM: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 11/01/2013 06:09 AM Subject: Re: TDP for SQL Server Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Del! According to the manual I have to run setupfcm.exe. This indeed installs a link in the start menu to the TDP for SQL client. As soon as I click it, it start the console with IBM Tivoli Data Protection listed, with IBM Tivoli FlashCopy Manager underneath, along with the license file not found error. The manual than states that the TSM configuration wizard should start. It does not. The manual states that you can start the wizard manually by clicking Manage Configuration Wizard, but there is no Manage option to click! Thanks again for your help. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: maandag 28 oktober 2013 14:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, You might want to get the latest version, 6.4.1
TDP for SQL Server
Hi guys! We are trying to install the TDP for SQL Server 6.3.1.0 client on one of our SQL server, but instead of installing the TDP client it installs the FlashCopy Manager client. The console does not list the TDP for SQL client after installation... Thank you very much for any help. Kind regards, Eric van Loon AF/KLM Storage Engineering 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 SQL Server
Hi Del! We have installed the 6.3.1.0 client and copied the license file from the 6.3.0.0 distribution (from Passport Advantage) into this directory, but as soon as the DP for SQL Manager Console icon is clicked, the console comes up with only the Flashcopy Manager listed... Thanks for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: maandag 28 oktober 2013 12:05 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, This is expected. FlashCopy Manager, Data Protection for SQL, and Data Protection for Exchange now share the same MMC GUI interface. To make sure you have the correct product installed, look for a file called sqlclient.lic in the C:\Program Files\Tivoli\TSM\TDPSql directory. Thanks, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 10/28/2013 05:45:50 AM: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 10/28/2013 05:47 AM Subject: TDP for SQL Server Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi guys! We are trying to install the TDP for SQL Server 6.3.1.0 client on one of our SQL server, but instead of installing the TDP client it installs the FlashCopy Manager client. The console does not list the TDP for SQL client after installation... Thank you very much for any help. Kind regards, Eric van Loon AF/KLM Storage Engineering 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
Data Protection for Lotus Domino
Hi all! We are currently migrating part of our company from Netbackup to TSM. They currently backup their Lotus Domino servers to tape (through the SAN) by using Netbackup for Lotus Notes and they achieve an average throughput around 10 Mb/sec. This performance is acceptable for the customer. It's achieved because Netbackup is able to use multiple backup streams. We installed Data Protection for Lotus Domino and we see an average throughput of less than 1 Mb/sec. Tracing showed that the client is mostly waiting for the Domino server. My guess is that we can achieve 10 Mb/sec too if we were able to use some kind of parallelism with TDP, but I cannot find a way to do this, other than backing up each database individually at the same time... Not very convenient. Does anybody have some tips to boost TDP performance in some way? Thank you very much for any help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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
ANR8235W
Hi TSM-ers! I installed two new servers on AIX and both are working fine. The only thing I notice is the following message at server startup: ANR8235W This server is not configured to use TCP/IP to connect to the database manager. I can't find anything useful on the IBM web site, only cases where this message was presented and the server couldn't be started. My servers are running fine! To make is even more confusing, this is what's in the Messages guide: ANR8235W (Windows): Requested number of NETBIOS sessions are not available on adapter network adapter number, proceeding with available sessions. So one message id seems to be used for two different reasons??? Thanks for any help in advance! Kind regards, Eric van Loon Air France/KLM Storage Engineering 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: Antwort: [ADSM-L] ANR8235W
Hi Rainer! I installed 6.2.5.0. I will ignore the message, although I think it should be properly documented by IBM.. Thank you very much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rainer Holzinger Sent: donderdag 25 juli 2013 10:52 To: ADSM-L@VM.MARIST.EDU Subject: Antwort: [ADSM-L] ANR8235W Hi Eric, which TSM Server level did you install? I noticed this from TSM Server levels before 6.3 as well, as there has been the possibiliy to use IOCP or TCP/IP for communications between thze TSM Server and DB2. Default was to use IOCP there, TCP/IP had to be done manually. Since TSM V6.3 TCP/IP is used by default to prevent the communication limit of max. 1024 sessions for ICOP. The message you are getting is nothing serious, even if it's a warning. Hope this helps. Best regards, Rainer Von:Loon, EJ van - SPLXM eric-van.l...@klm.com An: ADSM-L@VM.MARIST.EDU Datum: 25.07.2013 10:44 Betreff:[ADSM-L] ANR8235W Gesendet von: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hi TSM-ers! I installed two new servers on AIX and both are working fine. The only thing I notice is the following message at server startup: ANR8235W This server is not configured to use TCP/IP to connect to the database manager. I can't find anything useful on the IBM web site, only cases where this message was presented and the server couldn't be started. My servers are running fine! To make is even more confusing, this is what's in the Messages guide: ANR8235W (Windows): Requested number of NETBIOS sessions are not available on adapter network adapter number, proceeding with available sessions. So one message id seems to be used for two different reasons??? Thanks for any help in advance! Kind regards, Eric van Loon Air France/KLM Storage Engineering 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: Deduplication/replication options
Hi Sergio! Another thing to take into consideration: if you have switched from PVU licensing to sub-capacity licensing in the past: TSM sub-capacity licensing is based on the amount of data stored in your primary pool. If this data is stored on a de-duplicating storage device you will be charged for the gross amount of data. If you are using TSM de-duplication you will have to pay for the de-duplicated amount. This will probably save you a lot of money... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Sergio O. Fuentes Sent: dinsdag 23 juli 2013 19:20 To: ADSM-L@VM.MARIST.EDU Subject: Deduplication/replication options Hello all, We're currently faced with a decision go with a dedupe storage array or with TSM dedupe for our backup storage targets. There are some very critical pros and cons going with one or the other. For example, TSM dedupe will reduce overall network throughput both for backups and replication (source-side dedupe would be used). A dedupe storage array won't do that for backup, but it would be possible if we replicated to an identical array (but TSM replication would be bandwidth intensive). TSM dedupe might not scale as well and may neccessitate more TSM servers to distribute the load. Overall, though, I think the cost of additional servers is way less than what a native dedupe array would cost so I don't think that's a big hit. Replication is key. We have two datacenters where I would love it if TSM replication could be used in order to quickly (still manually, though) activate the replication server for production if necessary. Having a dedupe storage array kind of removes that option, unless we want to replicate the whole rehydrated backup data via TSM. I'm going on and on here, but has anybody had to make a decision to go one way or the other? Would it make sense to do a hybrid deployment (combination of TSM Dedupe and Array dedupe)? Any thoughts or tales of woes and forewarnings are appreciated. Thanks! Sergio 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 licence problem on Linux --tsm v 6.3.3.
Hi Vikas! Within Passport Advantage you will find the package IBM Tivoli Storage Manager V6.3.3 Linux s390x Server and Storage Agent, Multilingual(CICI9ML). This one contains the license files. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 9:44 To: ADSM-L@VM.MARIST.EDU Subject: TSM licence problem on Linux --tsm v 6.3.3. Helllo All, I have done a fresh install of a new tsm server with v 6.3.3. on linux. But unable to register licenses. I have tried giving full file name and paths but same result. tsm: TSMDEESW101reg lice file=*.lic ANR2852I Current license information: ANR9638W License registration is not supported on this server. ANS8001I Return code 3. As understood, TSM license file should be installed from base version of 6.3 i.e V6.3.0 but I am unable to find it anywhere on Passport advantage or on IBM ftp site. I have tried copying license file from a v 6.2.3 server, but that doesnt work either. I also tried searching that licence file in v6.3.1 but no luck. Has anybody faced the similar issues on v 6.3? Could you please advise? I also raised a call with IBM but they say they don't deal with licences problems. thanks Grüße Vikas Arora* * *e Mail* : vikar...@gmail.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
Re: TSM licence problem on Linux --tsm v 6.3.3.
Hi Vikas! I pasted the wrong one in here, you need the following package: IBM Tivoli Storage Manager V6.3.3 Linux x86_64 Server and Storage Agent, Multilingual(CICI7ML) Sorry! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 11:17 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM licence problem on Linux --tsm v 6.3.3. Hello, Thanks for your prompt response, Will it be also compatible on* Linux x86_64 * in my case? IBM Tivoli Storage Manager V6.3.3 *Linux s390x* Server and Storage Agent, Multilingual(CICI9ML) thanks Grüße Vikas Arora* * *e Mail* : vikar...@gmail.com On 24 July 2013 11:03, Loon, EJ van - SPLXM eric-van.l...@klm.com wrote: Hi Vikas! Within Passport Advantage you will find the package IBM Tivoli Storage Manager V6.3.3 Linux s390x Server and Storage Agent, Multilingual(CICI9ML). This one contains the license files. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 9:44 To: ADSM-L@VM.MARIST.EDU Subject: TSM licence problem on Linux --tsm v 6.3.3. Helllo All, I have done a fresh install of a new tsm server with v 6.3.3. on linux. But unable to register licenses. I have tried giving full file name and paths but same result. tsm: TSMDEESW101reg lice file=*.lic ANR2852I Current license information: ANR9638W License registration is not supported on this server. ANS8001I Return code 3. As understood, TSM license file should be installed from base version of 6.3 i.e V6.3.0 but I am unable to find it anywhere on Passport advantage or on IBM ftp site. I have tried copying license file from a v 6.2.3 server, but that doesnt work either. I also tried searching that licence file in v6.3.1 but no luck. Has anybody faced the similar issues on v 6.3? Could you please advise? I also raised a call with IBM but they say they don't deal with licences problems. thanks Grüße Vikas Arora* * *e Mail* : vikar...@gmail.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 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 licence problem on Linux --tsm v 6.3.3.
Hi Vikas! This should be the base level for 6.3. The TSM server code on Passport Advantage should always be the base code, along with the licenses, upgrades can be downloaded from the public FTP server, without an IBM id. Have you tried an installation through the installation wizard? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 11:36 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM licence problem on Linux --tsm v 6.3.3. Hi Eric, I have installed from the same package and there are no licence file in it. Normally, It should have this license rpm file ( from 6.2) , but not there in the code package mentioned above. I also looked in V6.3.1 ( Linux x86_64) also but no luck. degtlun:~ # rpm -qa |grep -i TIVsm-license *TIVsm-license-6.2.1-0* Do you know if or where I can locate base level for v6.3.0, which normally contains licences files? Grüße Vikas Arora* * *e Mail* : vikar...@gmail.com On 24 July 2013 11:30, Loon, EJ van - SPLXM eric-van.l...@klm.com wrote: Hi Vikas! I pasted the wrong one in here, you need the following package: IBM Tivoli Storage Manager V6.3.3 Linux x86_64 Server and Storage Agent, Multilingual(CICI7ML) Sorry! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 11:17 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM licence problem on Linux --tsm v 6.3.3. Hello, Thanks for your prompt response, Will it be also compatible on* Linux x86_64 * in my case? IBM Tivoli Storage Manager V6.3.3 *Linux s390x* Server and Storage Agent, Multilingual(CICI9ML) thanks Grüße Vikas Arora* * *e Mail* : vikar...@gmail.com On 24 July 2013 11:03, Loon, EJ van - SPLXM eric-van.l...@klm.com wrote: Hi Vikas! Within Passport Advantage you will find the package IBM Tivoli Storage Manager V6.3.3 Linux s390x Server and Storage Agent, Multilingual(CICI9ML). This one contains the license files. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 9:44 To: ADSM-L@VM.MARIST.EDU Subject: TSM licence problem on Linux --tsm v 6.3.3. Helllo All, I have done a fresh install of a new tsm server with v 6.3.3. on linux. But unable to register licenses. I have tried giving full file name and paths but same result. tsm: TSMDEESW101reg lice file=*.lic ANR2852I Current license information: ANR9638W License registration is not supported on this server. ANS8001I Return code 3. As understood, TSM license file should be installed from base version of 6.3 i.e V6.3.0 but I am unable to find it anywhere on Passport advantage or on IBM ftp site. I have tried copying license file from a v 6.2.3 server, but that doesnt work either. I also tried searching that licence file in v6.3.1 but no luck. Has anybody faced the similar issues on v 6.3? Could you please advise? I also raised a call with IBM but they say they don't deal with licences problems. thanks Grüße Vikas Arora* * *e Mail* : vikar...@gmail.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 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
Re: TSM licence problem on Linux --tsm v 6.3.3.
Hi Vikas! I'm using 6.2 servers and I used both the AIX as the Linux version from Passport Advantage to install the license files. So I don't know why it's not included in the 6.3 code... IBM? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 12:32 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM licence problem on Linux --tsm v 6.3.3. Yes, but it is the same through installation wizard too. Do you have the same version on linux? does it work for you? Thanks Grüße Vikas Arora* * *e Mail* : vikar...@gmail.com On 24 July 2013 11:46, Loon, EJ van - SPLXM eric-van.l...@klm.com wrote: Hi Vikas! This should be the base level for 6.3. The TSM server code on Passport Advantage should always be the base code, along with the licenses, upgrades can be downloaded from the public FTP server, without an IBM id. Have you tried an installation through the installation wizard? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 11:36 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM licence problem on Linux --tsm v 6.3.3. Hi Eric, I have installed from the same package and there are no licence file in it. Normally, It should have this license rpm file ( from 6.2) , but not there in the code package mentioned above. I also looked in V6.3.1 ( Linux x86_64) also but no luck. degtlun:~ # rpm -qa |grep -i TIVsm-license *TIVsm-license-6.2.1-0* Do you know if or where I can locate base level for v6.3.0, which normally contains licences files? Grüße Vikas Arora* * *e Mail* : vikar...@gmail.com On 24 July 2013 11:30, Loon, EJ van - SPLXM eric-van.l...@klm.com wrote: Hi Vikas! I pasted the wrong one in here, you need the following package: IBM Tivoli Storage Manager V6.3.3 Linux x86_64 Server and Storage Agent, Multilingual(CICI7ML) Sorry! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 11:17 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM licence problem on Linux --tsm v 6.3.3. Hello, Thanks for your prompt response, Will it be also compatible on* Linux x86_64 * in my case? IBM Tivoli Storage Manager V6.3.3 *Linux s390x* Server and Storage Agent, Multilingual(CICI9ML) thanks Grüße Vikas Arora* * *e Mail* : vikar...@gmail.com On 24 July 2013 11:03, Loon, EJ van - SPLXM eric-van.l...@klm.com wrote: Hi Vikas! Within Passport Advantage you will find the package IBM Tivoli Storage Manager V6.3.3 Linux s390x Server and Storage Agent, Multilingual(CICI9ML). This one contains the license files. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: woensdag 24 juli 2013 9:44 To: ADSM-L@VM.MARIST.EDU Subject: TSM licence problem on Linux --tsm v 6.3.3. Helllo All, I have done a fresh install of a new tsm server with v 6.3.3. on linux. But unable to register licenses. I have tried giving full file name and paths but same result. tsm: TSMDEESW101reg lice file=*.lic ANR2852I Current license information: ANR9638W License registration is not supported on this server. ANS8001I Return code 3. As understood, TSM license file should be installed from base version of 6.3 i.e V6.3.0 but I am unable to find it anywhere on Passport advantage or on IBM ftp site. I have tried copying license file from a v 6.2.3 server, but that doesnt work either. I also tried searching that licence file in v6.3.1 but no luck. Has anybody faced the similar issues on v 6.3? Could you please advise? I also raised a call with IBM but they say they don't deal with licences problems. thanks Grüße Vikas Arora* * *e Mail* : vikar...@gmail.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
Re: Problems creating instance on stand-by node
Hi Erwann! Thanks to your link it's now working! The caveat was that in our shop the TSM code is installed on a separate filesystem (through a softlink in /opt/tivoli). Apparently TSM or DB2 doesn't like softlinks because it will translate them to the target path. So the softlinks in the sqllib directory of the instance were not pointing to /opt/tivoli/tsm/db2 but to the target filesystem /mount/data00602/tsm/db2. The filesystem name was different between the two nodes and thus DB2 wasn't working after a take-over. By keeping the name identical between both nodes we fixed the issue. Again, thank you very much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Erwann Simon Sent: dinsdag 16 juli 2013 17:24 To: ADSM-L@VM.MARIST.EDU Subject: Re: Problems creating instance on stand-by node Hi Eric, You may see this technote instead which is more recent and more complete : http://www-01.ibm.com/support/docview.wss?uid=swg27036658 See the difference between configuring Tivoli Storage Manager server on a secondary node for PowerHA with a shared DB2 instance (probably your case) and configuring Tivoli Storage Manager server on a secondary node for PowerHA with a separate DB2 instance (what I used to do). In the first case there is only one DB2 instance, and it is located on shared disk. In the second case, there is one instance per cluster node, on local/non-shared disk. -- Best regards / Cordialement / مع تحياتي Erwann SIMON - Mail original - De: EJ van Loon - SPLXM eric-van.l...@klm.com À: ADSM-L@VM.MARIST.EDU Envoyé: Mardi 16 Juillet 2013 17:09:57 Objet: [ADSM-L] Problems creating instance on stand-by node Hi TSM-ers! I installed the TSM 6.2.5.0 server code on two AIX nodes in a PowerHA cluster. Both TSM instances are running fine on their own default node. Now I'm trying to make the TSM servers HA ready by registering the DB2 instance op the stand-by node, using the db2icrt command. I'm using technote 1452772 as reference, since the installation guide seems to be incomplete. A failover was performed and according to the instructions I now have to create the empty DB2 instance on the stand-by node by issuing the following command: /opt/tivoli/tsm/db2/instance/db2icrt -u tsm_abu2 tsm_abu2 This however results in the following error: DBI1082E The file or directory /appl/tsm_abu2/sqllib already exists Of course this directory exists: it was created during the initial creation of the instance on the primary node! Could you please help me in solving this problem? Thank you very much for your help! Kind 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 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: Domino 9 and TSM
I think you're out of luck. The 'latest' Domino client for Linux is 5.5.3 (quite old) and it only supports Domino 7 and 8... Kind regards, Eric -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of ppfister Sent: dinsdag 16 juli 2013 9:20 To: ADSM-L@VM.MARIST.EDU Subject: Domino 9 and TSM we have a Tivoli TSM 6.1.2 Server and want to backup our Dominio 9 servers. Question: - is there a domino client for Linux x86 64bit to backup domino Version 9 servers ? - Can we use 6.1.2 TSM Server to backup Domino 9 Server ? thnks +-- |This was sent by philipp.pfis...@webgate.biz via Backup Central. |Forward SPAM to ab...@backupcentral.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
Re: Domino 9 and TSM
Hi Chavdar! Data Protection for Domino 6.3 is not for Domino on Linux on x86, it's only for AIX, Windows and Linux on zSeries... By the way, it doesn't support Domino 9 either. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Chavdar Cholev Sent: dinsdag 16 juli 2013 16:08 To: ADSM-L@VM.MARIST.EDU Subject: Re: Domino 9 and TSM Hi Philip, latest TSM (TDP) for domino is v6.3 available in passport advantage with CI3LMML On 7/16/2013 10:19, ppfister wrote: we have a Tivoli TSM 6.1.2 Server and want to backup our Dominio 9 servers. Question: - is there a domino client for Linux x86 64bit to backup domino Version 9 servers ? - Can we use 6.1.2 TSM Server to backup Domino 9 Server ? thnks +- +- |This was sent by philipp.pfis...@webgate.biz via Backup Central. |Forward SPAM to ab...@backupcentral.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
Problems creating instance on stand-by node
Hi TSM-ers! I installed the TSM 6.2.5.0 server code on two AIX nodes in a PowerHA cluster. Both TSM instances are running fine on their own default node. Now I'm trying to make the TSM servers HA ready by registering the DB2 instance op the stand-by node, using the db2icrt command. I'm using technote 1452772 as reference, since the installation guide seems to be incomplete. A failover was performed and according to the instructions I now have to create the empty DB2 instance on the stand-by node by issuing the following command: /opt/tivoli/tsm/db2/instance/db2icrt -u tsm_abu2 tsm_abu2 This however results in the following error: DBI1082E The file or directory /appl/tsm_abu2/sqllib already exists Of course this directory exists: it was created during the initial creation of the instance on the primary node! Could you please help me in solving this problem? Thank you very much for your help! Kind 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: Problems creating instance on stand-by node
Hi Erwann, Thank you VERY much for the link to the document! In my case it's probably a mix of one and two. I'm installing an active-active cluster, so two servers with their own (shared) instance dir, so I guess this also requires both instances to be configured on both nodes... In that case I'm stuck again because of the error down below. Tomorrow I will try if option one works. Thanks again! Kind regards, Eric van Loon Hi Eric, You may see this technote instead which is more recent and more complete : http://www-01.ibm.com/support/docview.wss?uid=swg27036658 See the difference between configuring Tivoli Storage Manager server on a secondary node for PowerHA with a shared DB2 instance (probably your case) and configuring Tivoli Storage Manager server on a secondary node for PowerHA with a separate DB2 instance (what I used to do). In the first case there is only one DB2 instance, and it is located on shared disk. In the second case, there is one instance per cluster node, on local/non-shared disk. -- Best regards / Cordialement / ?? ?? Erwann SIMON - Mail original - De: EJ van Loon - SPLXM eric-van.l...@klm.com À: ADSM-L@VM.MARIST.EDU Envoyé: Mardi 16 Juillet 2013 17:09:57 Objet: [ADSM-L] Problems creating instance on stand-by node Hi TSM-ers! I installed the TSM 6.2.5.0 server code on two AIX nodes in a PowerHA cluster. Both TSM instances are running fine on their own default node. Now I'm trying to make the TSM servers HA ready by registering the DB2 instance op the stand-by node, using the db2icrt command. I'm using technote 1452772 as reference, since the installation guide seems to be incomplete. A failover was performed and according to the instructions I now have to create the empty DB2 instance on the stand-by node by issuing the following command: /opt/tivoli/tsm/db2/instance/db2icrt -u tsm_abu2 tsm_abu2 This however results in the following error: DBI1082E The file or directory /appl/tsm_abu2/sqllib already exists Of course this directory exists: it was created during the initial creation of the instance on the primary node! Could you please help me in solving this problem? Thank you very much for your help! Kind 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 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 Running out of Scratch Tapes
If you first run a checkin libvol before labeling them, TSM won't probably find any tapes to label. Run the following command to checkout all new tapes: Checkout libvol libraryname volumename checkl=n remove=n Now run the following command to label them: Label libv libraryname search=y labels=b checkin=scratch This will put a label on the tapes and check them in as scratch. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Adeel Mehmood Sent: dinsdag 9 juli 2013 15:12 To: ADSM-L@VM.MARIST.EDU Subject: Re: : TSM Running out of Scratch Tapes Dear All, below steps has been used to checkin the new or offsite tapes as SCRATCH to the library . Please advise , if they can be improved further to solve this issue checkin libvolume sl3kacslib search=yes status=scratch checklabel=no label libvolume sl3kacslib search=yes overwrite=no checkin=scratch Thx, Adeel -Original Message- From: Richard Sims [mailto:r...@bu.edu] Sent: Tuesday, July 9, 2013 3:47 PM To: Adeel Mehmood Subject: Re: : TSM Running out of Scratch Tapes Those messages, in conjunction with your statement that these are new tapes, indicates that the problem is simply that you have not labeled them, as is fundamental when adding new tapes to a library. See that message number in http://people.bu.edu/rbs/ADSM.QuickFacts. Richard On Jul 9, 2013, at 1:31 AM, Adeel Mehmood ad.mehm...@diyarme.com wrote: Dears , We are receiving below errors and the Scratch tapes goes to ZERO 07/04/2013 22:58:44 ANR8355E I/O error reading label for volume 001736 in drive DRIVE15 (mt10.0.0.2). (SESSION: 32773) 07/04/2013 23:04:23 ANR8355E I/O error reading label for volume 000588 in drive DRIVE4 (mt7.0.0.1). (SESSION: 32799) 07/04/2013 23:04:35 ANR8355E I/O error reading label for volume 000482 in drive DRIVE15 (mt10.0.0.2). (SESSION: 32806) 07/04/2013 23:10:55 ANR8355E I/O error reading label for volume 001058 in drive DRIVE4 (mt7.0.0.1). (SESSION: 34240) 07/04/2013 23:11:01 ANR8355E I/O error reading label for volume 002081 in drive DRIVE15 (mt10.0.0.2). (SESSION: 34242) 07/04/2013 23:15:49 ANR8355E I/O error reading label for volume 000468 in drive DRIVE15 (mt10.0.0.2). (SESSION: 34242) 07/04/2013 23:16:21 ANR8355E I/O error reading label for volume 000828 in drive DRIVE4 (mt7.0.0.1). (SESSION: 34240) 07/04/2013 23:20:33 ANR8355E I/O error reading label for volume 002284 in drive DRIVE15 (mt10.0.0.2). (SESSION: 34242) 07/04/2013 23:21:13 ANR8355E I/O error reading label for volume 002084 in drive DRIVE4 (mt7.0.0.1). (SESSION: 34240) 07/04/2013 23:26:29 ANR8355E I/O error reading label for volume 001367 in drive DRIVE15 (mt10.0.0.2). (SESSION: 34255) 07/04/2013 23:28:24 ANR8355E I/O error reading label for volume 000386 in drive DRIVE4 (mt7.0.0.1). (SESSION: 34215) 07/04/2013 23:36:08 ANR8355E I/O error reading label for volume 001804 in drive DRIVE15 (mt10.0.0.2). (SESSION: 34215) 07/04/2013 23:37:04 ANR8355E I/O error reading label for volume 002323 in drive DRIVE4 (mt7.0.0.1). (SESSION: 34255) 07/04/2013 23:44:47 ANR8355E I/O error reading label for volume 001814 in drive DRIVE15 (mt10.0.0.2). (SESSION: 34255) 07/04/2013 23:45:05 ANR8355E I/O error reading label for volume 002535 in drive DRIVE4 (mt7.0.0.1). (SESSION: 24769) Thanks best regards, Adeel Mehmood D I S C L A I M E R The information in this email and in any files transmitted with it, is intended only for the addressee and may contain confidential and/or privileged material. Access to this email by anyone else is unauthorized. If you receive this in error, please contact the sender immediately and delete the material from any computer. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is strictly prohibited. Statement and opinions expressed in this e-mail are those of the sender, and do not necessarily reflect those of the company. 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
Re: Question for Linux tape experts
Hi Erwann! I forwarded the script to one of our script guru's and he found it quite useful. Thank you VERY much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Erwann Simon Sent: woensdag 3 juli 2013 11:40 To: ADSM-L@VM.MARIST.EDU Subject: Re: Question for Linux tape experts Hi, Here's a script modified from various ones found on the Internet : # cat get_serial.sh #!/bin/bash # work with udev for IBM SCSI tape device persistent naming support SYSFS=/sys echo IBMDEV;SERIAL;WWN for IBMDEV in /dev/IBMtape[0-9] do DEVPATH=/class/lin_tape/$(basename $IBMDEV) NAME=$(echo $DEVPATH|sed -e 's/.*\/\([a-zA-Z]*\)[0-9n]*$/\1/') # lin_tape does not have the IOCTL that scsi_id uses however it # has a sysfs entry pointing to the generic device which does # support that IOCTL SYMLINKPATH=$SYSFS$DEVPATH/device/generic if [ ! -d $SYMLINKPATH ] ; then exit 1 fi cd $SYMLINKPATH GDEVICEPATH=$(pwd -P|sed -e '{ s/\/sys\(.*\)/\1/ }') # WWN=$(/sbin/scsi_id -gus $GDEVICEPATH) # TAPE_ID=$(/sbin/scsi_id -p 0x80 -gs $GDEVICEPATH) set ${TAPE_ID} SERIAL=$3 # echo ${IBMDEV};${SERIAL};${WWN} | sed -e s/\/dev\/// done exit 0 Example running on an RHEL 5 (I don't have an RHEL 4 with devices attached, here MHVTL) # sh get_serial.sh IBMDEV;SERIAL;WWN IBMtape0;XYZZY_A1;350223344ab000100 IBMtape1;XYZZY_A2;350223344ab000200 IBMtape2;XYZZY_A3;350223344ab000300 IBMtape3;XYZZY_A4;350223344ab000400 -- Best regards / Cordialement / مع تحياتي Erwann SIMON - Mail original - De: EJ van Loon - SPLXM eric-van.l...@klm.com À: ADSM-L@VM.MARIST.EDU Envoyé: Mardi 2 Juillet 2013 11:52:43 Objet: [ADSM-L] Question for Linux tape experts Hi TSM-ers! I have got a question for Linux experts and specifically expert on tape drives in Linux. We've got some problems with lin_tape on Linux. Our Storage Agent installation scripts use the command cat /proc/scsi/IBMtape to retrieve the serial information of the tape drives. The problem is that this causes a panic on some hosts. IBM identified this to be a known bug in lin_tape 1.66 which has been solved in lin_tape 1.69 and higher, however, 1.66 is the highest release available for RHEL4 servers... So, I'm looking for a way to avoid the cat command, but I need a way to retrieve the drive serials and link them to the Linux tape drive. Does anyone have an alternative method we can use? Thank you very much for any help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: IdleTimeOut
Hi Faisal! The storage agent option file was lacking the idletimeout parameter which causes it to default to 15 minutes. Problem fixed! Thank you very much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Faisal Khan Sent: maandag 1 juli 2013 17:05 To: ADSM-L@VM.MARIST.EDU Subject: Re: IdleTimeOut Hi Eric, Please check the Commtimeout and Idletimeout parameters of Storage Agent Options file. Ideally, they should match with TSM server counterparts. For example: Let's assume following: Name of TSM Server: TSMSERVER Name of Storage Agent Server: STA Then, you can run following command to query the Storage Agent Options file TSMSERVERSTA:q opt You can update the parameters of Storage Agent Options file using setopt command as below: TSMSERVERSTA:setopt CommTimeout value STA:setopt Idletimeout value Alternatively, you can update the dsmsta.opt file in the TSM Storage Agent Client and restart the Storage Agent service. Kind Regards, Faisal Khan On Mon, Jul 1, 2013 at 5:50 PM, Loon, EJ van - SPLXM eric-van.l...@klm.comwrote: Hi Andy! The QVIPCOS8 is a LAN free Linux client. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Andrew Raibeck Sent: vrijdag 28 juni 2013 17:22 To: ADSM-L@VM.MARIST.EDU Subject: Re: IdleTimeOut Eric, what does the Origin: QVIPCOS8 part of the message refer to? Best regards, - Andy __ __ Andrew Raibeck | Tivoli Storage Manager Level 3 Technical Lead | stor...@us.ibm.com IBM Tivoli Storage Manager links: Product support: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivol i_ Storage_Manager Online documentation: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Ti vo li Documentation Central/page/Tivoli Storage Manager Product Wiki: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Ti vo li +Storage+Manager/page/Home ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 2013-06-28 11:11:20: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 2013-06-28 11:12 Subject: Re: IdleTimeOut Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Dwight! I thought of that too, but that's set to one hour: tsm: QVIP4q opt resourcetimeout Server Option Option Setting - Resource Timeout 60 Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Dwight Cook Sent: vrijdag 28 juni 2013 16:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: IdleTimeOut Is it maybe getting killed because it is waiting on a resource and hitting your resourcetimeout? Like a tdp backup going straight to tape and no tape drives available? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: Friday, June 28, 2013 9:35 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] IdleTimeOut Hi TSM-ers! A client session gets cancelled after 15 minutes: 06/28/2013 13:46:35 ANR0482W (Session: 1638708, Origin: QVIPCOS8) Session 183 for node QVIP4 (Linux/x86_64) terminated - idle for more than 15 minutes. (SESSION: 1638708) However, IdleTimeOut is set to 9 hours: tsm: QVIP4q opt IdleTimeOut Server Option Option Setting - IdleTimeOut 540 Any idea what's causing the session to be canceled after 15 minutes? Thanks for any suggestion in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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
Question for Linux tape experts
Hi TSM-ers! I have got a question for Linux experts and specifically expert on tape drives in Linux. We've got some problems with lin_tape on Linux. Our Storage Agent installation scripts use the command cat /proc/scsi/IBMtape to retrieve the serial information of the tape drives. The problem is that this causes a panic on some hosts. IBM identified this to be a known bug in lin_tape 1.66 which has been solved in lin_tape 1.69 and higher, however, 1.66 is the highest release available for RHEL4 servers... So, I'm looking for a way to avoid the cat command, but I need a way to retrieve the drive serials and link them to the Linux tape drive. Does anyone have an alternative method we can use? Thank you very much for any help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: IdleTimeOut
Hi Andy! The QVIPCOS8 is a LAN free Linux client. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Andrew Raibeck Sent: vrijdag 28 juni 2013 17:22 To: ADSM-L@VM.MARIST.EDU Subject: Re: IdleTimeOut Eric, what does the Origin: QVIPCOS8 part of the message refer to? Best regards, - Andy Andrew Raibeck | Tivoli Storage Manager Level 3 Technical Lead | stor...@us.ibm.com IBM Tivoli Storage Manager links: Product support: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_ Storage_Manager Online documentation: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivo li Documentation Central/page/Tivoli Storage Manager Product Wiki: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home/wiki/Tivo li +Storage+Manager/page/Home ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 2013-06-28 11:11:20: From: Loon, EJ van - SPLXM eric-van.l...@klm.com To: ADSM-L@vm.marist.edu, Date: 2013-06-28 11:12 Subject: Re: IdleTimeOut Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi Dwight! I thought of that too, but that's set to one hour: tsm: QVIP4q opt resourcetimeout Server Option Option Setting - Resource Timeout 60 Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Dwight Cook Sent: vrijdag 28 juni 2013 16:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: IdleTimeOut Is it maybe getting killed because it is waiting on a resource and hitting your resourcetimeout? Like a tdp backup going straight to tape and no tape drives available? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: Friday, June 28, 2013 9:35 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] IdleTimeOut Hi TSM-ers! A client session gets cancelled after 15 minutes: 06/28/2013 13:46:35 ANR0482W (Session: 1638708, Origin: QVIPCOS8) Session 183 for node QVIP4 (Linux/x86_64) terminated - idle for more than 15 minutes. (SESSION: 1638708) However, IdleTimeOut is set to 9 hours: tsm: QVIP4q opt IdleTimeOut Server Option Option Setting - IdleTimeOut 540 Any idea what's causing the session to be canceled after 15 minutes? Thanks for any suggestion in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 For information, services and offers, please
Re: retver
Hi! Thank you for your help! I didn't check the other servers thoroughly enough: the setting was right (nolim) on two other servers and wrong (0) on the other two. I changed it to nolim on all servers so the problem should be fixed now. Have a nice weekend! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of francs Sent: vrijdag 28 juni 2013 9:39 To: ADSM-L@VM.MARIST.EDU Subject: retver Hi Eric DP for ERP(SAP) backups uses the archive copygroup, but it uses it's own versioning. That's why they tell you to configure it to NOLIMIT or . If retver=0 is set then your backups will be deleted by TSM and not ERP/backint. As to why the other servers are retaining the backups you would have to check the management class, assigned to that backup, in the SAP config file (initSID.utl) and look up the archive copygroup setting on TSM. 2013/6/27 Loon, EJ van - SPLXM Eric-van.Loon at klm.com Hi guys! What happens when you archive to a mgmtclass with an achive copygroup with retver=0? I have one server which is used for backing up SAP databases and I noticed that the copygroup uses retver=0, while this should be NOLIMIT to my knowledge. Users are complaining that backups are disappearing on this server. Backint logging shows no delete commands so the data is not deleted on the client side. However, the retver is set to 0 on other TSM servers too and on these server data is kept correctly... Thanks for any help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 was sent by fswanep...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.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
IdleTimeOut
Hi TSM-ers! A client session gets cancelled after 15 minutes: 06/28/2013 13:46:35 ANR0482W (Session: 1638708, Origin: QVIPCOS8) Session 183 for node QVIP4 (Linux/x86_64) terminated - idle for more than 15 minutes. (SESSION: 1638708) However, IdleTimeOut is set to 9 hours: tsm: QVIP4q opt IdleTimeOut Server Option Option Setting - IdleTimeOut 540 Any idea what's causing the session to be canceled after 15 minutes? Thanks for any suggestion in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: IdleTimeOut
Hi Dwight! I thought of that too, but that's set to one hour: tsm: QVIP4q opt resourcetimeout Server Option Option Setting - Resource Timeout 60 Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Dwight Cook Sent: vrijdag 28 juni 2013 16:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: IdleTimeOut Is it maybe getting killed because it is waiting on a resource and hitting your resourcetimeout? Like a tdp backup going straight to tape and no tape drives available? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: Friday, June 28, 2013 9:35 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] IdleTimeOut Hi TSM-ers! A client session gets cancelled after 15 minutes: 06/28/2013 13:46:35 ANR0482W (Session: 1638708, Origin: QVIPCOS8) Session 183 for node QVIP4 (Linux/x86_64) terminated - idle for more than 15 minutes. (SESSION: 1638708) However, IdleTimeOut is set to 9 hours: tsm: QVIP4q opt IdleTimeOut Server Option Option Setting - IdleTimeOut 540 Any idea what's causing the session to be canceled after 15 minutes? Thanks for any suggestion in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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
retver
Hi guys! What happens when you archive to a mgmtclass with an achive copygroup with retver=0? I have one server which is used for backing up SAP databases and I noticed that the copygroup uses retver=0, while this should be NOLIMIT to my knowledge. Users are complaining that backups are disappearing on this server. Backint logging shows no delete commands so the data is not deleted on the client side. However, the retver is set to 0 on other TSM servers too and on these server data is kept correctly... Thanks for any help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 MySAP prereq
Hi guys! One of our engineers is trying to install Data Protection for MySAP on a Linux RHEL6 server. When he issues the backfm command he receives the error that libncurses.so.5 cannot be found. The 64-bit version of libncurses.so.5 is installed on the system, for some reason Data Protection for MySAP requires the 32-bit version: # ldd /opt/tivoli/tsm/tdp_r3/ora64/backfm linux-gate.so.1 = (0x00a3d000) libncurses.so.5 = not found libc.so.6 = /lib/libc.so.6 (0x0046d000) /lib/ld-linux.so.2 (0x00e46000) In the past (on RHEL5) they solved this by installing both the 32-bit and the 64-bit version, but for RHEL6 there is no 32-bit version... Does anybody know why the 64-bit Data Protection for MySAP client requires a 32-bit file? Thanks in advance for any reply! Kind regards, Eric van Loon AF/KLM Storage Engineering 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.6 reorg
Hi Jerome! The performance of the unload/load process is hardly predictable. Performance varies enormously during the unload process and seems to be related to the amount of fragmentation. You can get an idea about your fragmentation by running the following SQL query: SELECT CAST((100 - (CAST(MAX_REDUCTION_MB AS FLOAT) * 256 ) / - (CAST(USABLE_PAGES AS FLOAT) - CAST(USED_PAGES AS FLOAT) ) * 100) AS - DECIMAL(4,2)) AS PERCENT_FRAG FROM DB The read performance of the database is also crucial to the unload performance, if possible place your database on (multiple) SSD disks. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Swartz, Jerome Sent: donderdag 4 april 2013 13:33 To: ADSM-L@VM.MARIST.EDU Subject: TSM 5.6 reorg Hi All, I am about to reorg my 200GB TSM DB this weekend. Anyone know approximately how long it will take to complete? Thanks Jerome ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.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
Re: TSM 5.6 reorg
Hi Jerome! I doubt it will be possible in 10 hours. Anyway, 8% seems kind of low to me, not much fragmentation. What are you hoping to gain from the unload/load? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Swartz, Jerome Sent: donderdag 4 april 2013 15:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM 5.6 reorg Thanks Eric, Fragmentation is at 8.02%. No spare storage available to will have to recover to tape. Is this something that could be achieved in 8-10 hours time? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: 04 April 2013 03:12 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM 5.6 reorg Hi Jerome! The performance of the unload/load process is hardly predictable. Performance varies enormously during the unload process and seems to be related to the amount of fragmentation. You can get an idea about your fragmentation by running the following SQL query: SELECT CAST((100 - (CAST(MAX_REDUCTION_MB AS FLOAT) * 256 ) / - (CAST(USABLE_PAGES AS FLOAT) - CAST(USED_PAGES AS FLOAT) ) * 100) AS - DECIMAL(4,2)) AS PERCENT_FRAG FROM DB The read performance of the database is also crucial to the unload performance, if possible place your database on (multiple) SSD disks. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Swartz, Jerome Sent: donderdag 4 april 2013 13:33 To: ADSM-L@VM.MARIST.EDU Subject: TSM 5.6 reorg Hi All, I am about to reorg my 200GB TSM DB this weekend. Anyone know approximately how long it will take to complete? Thanks Jerome ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.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 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
Re: TSM 5.6 reorg
Oke, but isn't buying extra space much cheaper than you spending a whole day recovering 40 Gb? Anyway, it's your party, but for me wouldn't be worth the work and risk... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Swartz, Jerome Sent: donderdag 4 april 2013 15:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM 5.6 reorg The estimate recoverable space is 40GB! -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: 04 April 2013 03:30 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM 5.6 reorg Hi Jerome! I doubt it will be possible in 10 hours. Anyway, 8% seems kind of low to me, not much fragmentation. What are you hoping to gain from the unload/load? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Swartz, Jerome Sent: donderdag 4 april 2013 15:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM 5.6 reorg Thanks Eric, Fragmentation is at 8.02%. No spare storage available to will have to recover to tape. Is this something that could be achieved in 8-10 hours time? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: 04 April 2013 03:12 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM 5.6 reorg Hi Jerome! The performance of the unload/load process is hardly predictable. Performance varies enormously during the unload process and seems to be related to the amount of fragmentation. You can get an idea about your fragmentation by running the following SQL query: SELECT CAST((100 - (CAST(MAX_REDUCTION_MB AS FLOAT) * 256 ) / - (CAST(USABLE_PAGES AS FLOAT) - CAST(USED_PAGES AS FLOAT) ) * 100) AS - DECIMAL(4,2)) AS PERCENT_FRAG FROM DB The read performance of the database is also crucial to the unload performance, if possible place your database on (multiple) SSD disks. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Swartz, Jerome Sent: donderdag 4 april 2013 13:33 To: ADSM-L@VM.MARIST.EDU Subject: TSM 5.6 reorg Hi All, I am about to reorg my 200GB TSM DB this weekend. Anyone know approximately how long it will take to complete? Thanks Jerome ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.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
Re: Moving TSM server from AIX to Linux
From the 6.4 manuals: Restriction: In most cases, you cannot upgrade your server to run on an operating system that is different from the operating system that it currently runs on. For example, you cannot upgrade a server that is running on an AIX(r) system to a server on a Linux system. The only exception is a cross-platform upgrade from a V5 server that is running on z/OS(r) to a V6.3 or later server on AIX or Linux on System z(r). For more information about the cross-platform upgrade, see Migrating Tivoli Storage Manager V5 servers on z/OS systems to V6 on AIX or Linux on System z. So although it might work, it's not supported! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: donderdag 4 april 2013 16:23 To: ADSM-L@VM.MARIST.EDU Subject: Re: Moving TSM server from AIX to Linux Haven't tried it with v6, but that's how I moved a server from solaris to suse linux. The linux was running as a guest under VM on our mainframe. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of James Choate Sent: Thursday, April 04, 2013 9:50 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Moving TSM server from AIX to Linux Is it really as easy as just installing a new server on the new platform and then restoring a db? I wasn't aware that you could restore a db across platforms. I thought you would have to export/import the nodes out of the AIX server into the Linux server. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Thursday, April 04, 2013 7:36 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Moving TSM server from AIX to Linux Shouldn't be a big deal. However, tougher with v6 than v5. You should be able to restore a db backup after installing the new server. Then, define storage pools, tape drives, and libraries as necessary. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Troy A Cross Sent: Thursday, April 04, 2013 9:28 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Moving TSM server from AIX to Linux ADSM-L mailing list, I've been tasked with the project to move our TSM server from AIX to Linux (prefer RedHat or CentOS). Any pointers? Thanks, Troy Troy Allen Cross Information Technology Manager 2 Youngstown State University 410 Meshel Hall, Computer Services One University Plaza Youngstown, OH 44555 (330) 941-1697 (Office) (330) 941-1473 (FAX) 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: Not enough space in /opt to 'upgrade'
Hi Remco! Even when you use the -repair switch, the repair fails because of the free space in /opt/tivoli/tsm... This is definitely broken! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: maandag 18 maart 2013 22:36 To: ADSM-L@VM.MARIST.EDU Subject: Re: Not enough space in /opt to 'upgrade' Hi Eric, yes, one of the better features of the installer... it doesn't know that TSM is already installed so it doesn't account for the 2 GB freed by uninstalling the old version. I'm still wondering what the use of this deployment agent is, because I have found nothing positive about it On 18 mrt. 2013, at 17:16, Loon, EJ van - SPLXM eric-van.l...@klm.com wrote: Hi guys! I'm running a TSM test server (AIX) and after successfully upgrading it to 6.2 I uninstalled all 5.5 packages. Apparently too much was deleted, because now the server won't start: = $ ./dsmserv exec(): 0509-036 Cannot load program ./dsmserv because of the following errors: 0509-150 Dependent module libdb2.a(shr_64.o) could not be loaded. 0509-022 Cannot load module libdb2.a(shr_64.o). 0509-026 System error: A file or directory in the path name does not exist So I tried installing the 6.2 code again, but it fails because it checks /opt/tivoli/tsm for the amount of space available. There is 800 Mb. free which is not enough for a new installation, but since this is an 'upgrade' which will replace 99% of all files, it is large enough. Is there any way to have the installer skip this space check? Thanks for any help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 -- Met vriendelijke groeten/Kind regards, Remco Post r.p...@plcs.nl +31 6 24821622 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
Not enough space in /opt to 'upgrade'
Hi guys! I'm running a TSM test server (AIX) and after successfully upgrading it to 6.2 I uninstalled all 5.5 packages. Apparently too much was deleted, because now the server won't start: = $ ./dsmserv exec(): 0509-036 Cannot load program ./dsmserv because of the following errors: 0509-150 Dependent module libdb2.a(shr_64.o) could not be loaded. 0509-022 Cannot load module libdb2.a(shr_64.o). 0509-026 System error: A file or directory in the path name does not exist So I tried installing the 6.2 code again, but it fails because it checks /opt/tivoli/tsm for the amount of space available. There is 800 Mb. free which is not enough for a new installation, but since this is an 'upgrade' which will replace 99% of all files, it is large enough. Is there any way to have the installer skip this space check? Thanks for any help in advance! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 error
Hi TSM-ers! I'm trying to retrieve all image backups for a specific node. I'm issuing the following query: select * from backups where node_name='KL127EAC' and type like 'IMAGE%' This returns the following error: ANR2921E The SQL data type of expression 'TYPE' is ENUMERATED(OBJECT_TYPE); expecting a character string expression. This query works fine: select * from backups where node_name='KL127EAC'and type='IMAGE' works fine... That's where where my limited SQL knowledge stops. Thank you very much for any help! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 error
Hi Rick! Yes, I tried IMAGE*, it returns the same error... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick Harderwijk Sent: dinsdag 12 maart 2013 11:14 To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL error Eric, Maybe the wildcard % is not valid for the datatype of TYPE which is ENUMERATED(OBJECT_TYPE). Have you tried * ? Rick On Tue, Mar 12, 2013 at 10:49 AM, Loon, EJ van - SPLXM eric-van.l...@klm.com wrote: Hi TSM-ers! I'm trying to retrieve all image backups for a specific node. I'm issuing the following query: select * from backups where node_name='KL127EAC' and type like 'IMAGE%' This returns the following error: ANR2921E The SQL data type of expression 'TYPE' is ENUMERATED(OBJECT_TYPE); expecting a character string expression. This query works fine: select * from backups where node_name='KL127EAC'and type='IMAGE' works fine... That's where where my limited SQL knowledge stops. Thank you very much for any help! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: Antwort: [ADSM-L] SQL error
Hi Ulli! Unfortunately the same error: ANR2921E The SQL data type of expression 'BACKUPS.TYPE' is ENUMERATED(OBJECT_TYPE); expecting a character string expression. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ullrich Mänz Sent: dinsdag 12 maart 2013 11:11 To: ADSM-L@VM.MARIST.EDU Subject: Antwort: [ADSM-L] SQL error Hi Eric, try to add the table name as follows: select * from backups where backups.node_name='KL127EAC' and backups.type like 'IMAGE%' good luck regards Ulli Ullrich Mänz Data Center Services FRITZ MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil +49 170 7678 434 Fax: +49 69 3801 3500 10 Web: http://www.fum.de Amtsgericht Ulm, Handelsregister-Nummer: HRB 1936 Geschäftsführer: Heribert Fritz Inhaber: Imtech N.V., Gouda, Niederlande Von:Loon, EJ van - SPLXM eric-van.l...@klm.com An: ADSM-L@VM.MARIST.EDU, Datum: 12.03.2013 10:50 Betreff:[ADSM-L] SQL error Gesendet von: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hi TSM-ers! I'm trying to retrieve all image backups for a specific node. I'm issuing the following query: select * from backups where node_name='KL127EAC' and type like 'IMAGE%' This returns the following error: ANR2921E The SQL data type of expression 'TYPE' is ENUMERATED(OBJECT_TYPE); expecting a character string expression. This query works fine: select * from backups where node_name='KL127EAC'and type='IMAGE' works fine... That's where where my limited SQL knowledge stops. Thank you very much for any help! Kind regards, Eric van Loon AF/KLM Storage Engineering 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: Antwort: [ADSM-L] SQL error
Hi Rick! This one works like a charm! Thank you very much! And Andy, thanks for the explanation! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick Harderwijk Sent: dinsdag 12 maart 2013 12:13 To: ADSM-L@VM.MARIST.EDU Subject: Re: Antwort: [ADSM-L] SQL error Eric, How about select * from backups where node_name='KL127EAC' and cast(type as char) like 'IMAGE%' Cheers, Rick On Tue, Mar 12, 2013 at 11:57 AM, Loon, EJ van - SPLXM eric-van.l...@klm.com wrote: Hi Ulli! Unfortunately the same error: ANR2921E The SQL data type of expression 'BACKUPS.TYPE' is ENUMERATED(OBJECT_TYPE); expecting a character string expression. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ullrich Mänz Sent: dinsdag 12 maart 2013 11:11 To: ADSM-L@VM.MARIST.EDU Subject: Antwort: [ADSM-L] SQL error Hi Eric, try to add the table name as follows: select * from backups where backups.node_name='KL127EAC' and backups.type like 'IMAGE%' good luck regards Ulli Ullrich Mänz Data Center Services FRITZ MACZIOL Software und Computervertrieb GmbH Ludwig Str. 180D, 63067 Offenbach, Germany Mobil +49 170 7678 434 Fax: +49 69 3801 3500 10 Web: http://www.fum.de Amtsgericht Ulm, Handelsregister-Nummer: HRB 1936 Geschäftsführer: Heribert Fritz Inhaber: Imtech N.V., Gouda, Niederlande Von:Loon, EJ van - SPLXM eric-van.l...@klm.com An: ADSM-L@VM.MARIST.EDU, Datum: 12.03.2013 10:50 Betreff:[ADSM-L] SQL error Gesendet von: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hi TSM-ers! I'm trying to retrieve all image backups for a specific node. I'm issuing the following query: select * from backups where node_name='KL127EAC' and type like 'IMAGE%' This returns the following error: ANR2921E The SQL data type of expression 'TYPE' is ENUMERATED(OBJECT_TYPE); expecting a character string expression. This query works fine: select * from backups where node_name='KL127EAC'and type='IMAGE' works fine... That's where where my limited SQL knowledge stops. Thank you very much for any help! Kind regards, Eric van Loon AF/KLM Storage Engineering 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 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
prerequisite checker
Hi TSM-ers! I would like to install the 6.2 AIX server on an existing 5.5 server. The 6.3 server comes with a tool called the prerequisite checker, which I was hoping to use before installing 6.2. I'm a bit confused by the manual, it states: Ensure that the appropriate installation package is downloaded and that its files are extracted. A prerequisite checker is part of the installation package. It says extracted, so not installed. However, if I download the 6.3 server from Passport Advantage it's a .bin file, which can only be installed as far as I know, right? So how do I just extract the prerequisite checker from this package? Thanks for your help in advance! Kind 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: prerequisite checker
Hi Rainer! I know it's not part of 6.2, so I looked at the 6.3 package on Passport Advantage, but the server code comes in one just one package, a .bin file, so no separate prereqcheck.bin... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rainer Holzinger Sent: donderdag 7 februari 2013 12:22 To: ADSM-L@VM.MARIST.EDU Subject: AW: [ADSM-L] prerequisite checker Hi Eric, as far as I know, there is no prerequisite checker devlivered with TSM V 6.2, it came with 6.3 (or even 6.3.3). In TSM 6.3 the prerequisite checker don't need to be installed, it comes from extracting the TSM V6 Server Package. The file name is 'prereqcheck.bin. Hope this helps. Best regards, Rainer Holzinger Empalis Consulting GmbH Wankelstr. 14 D-70563 Stuttgart -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Loon, EJ van - SPLXM Gesendet: Donnerstag, 7. Februar 2013 11:45 An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] prerequisite checker Hi TSM-ers! I would like to install the 6.2 AIX server on an existing 5.5 server. The 6.3 server comes with a tool called the prerequisite checker, which I was hoping to use before installing 6.2. I'm a bit confused by the manual, it states: Ensure that the appropriate installation package is downloaded and that its files are extracted. A prerequisite checker is part of the installation package. It says extracted, so not installed. However, if I download the 6.3 server from Passport Advantage it's a .bin file, which can only be installed as far as I know, right? So how do I just extract the prerequisite checker from this package? Thanks for your help in advance! Kind 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: prerequisite checker
Hi Rainer! I found it, it's inside the bin file itself. Thanks for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rainer Holzinger Sent: donderdag 7 februari 2013 12:40 To: ADSM-L@VM.MARIST.EDU Subject: AW: [ADSM-L] prerequisite checker Hi Eric, right, but you have to extract the package for example by: ./TSM_V6.3.3_AIX_Server.bin Ensure that you have enough disk space available for the extract, And it will take a while. After the extract completed you will find 'prereqcheck.bin'. Best regards, Rainer -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Loon, EJ van - SPLXM Gesendet: Donnerstag, 7. Februar 2013 12:31 An: ADSM-L@VM.MARIST.EDU Betreff: Re: [ADSM-L] prerequisite checker Hi Rainer! I know it's not part of 6.2, so I looked at the 6.3 package on Passport Advantage, but the server code comes in one just one package, a .bin file, so no separate prereqcheck.bin... Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rainer Holzinger Sent: donderdag 7 februari 2013 12:22 To: ADSM-L@VM.MARIST.EDU Subject: AW: [ADSM-L] prerequisite checker Hi Eric, as far as I know, there is no prerequisite checker devlivered with TSM V 6.2, it came with 6.3 (or even 6.3.3). In TSM 6.3 the prerequisite checker don't need to be installed, it comes from extracting the TSM V6 Server Package. The file name is 'prereqcheck.bin. Hope this helps. Best regards, Rainer Holzinger Empalis Consulting GmbH Wankelstr. 14 D-70563 Stuttgart -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Loon, EJ van - SPLXM Gesendet: Donnerstag, 7. Februar 2013 11:45 An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] prerequisite checker Hi TSM-ers! I would like to install the 6.2 AIX server on an existing 5.5 server. The 6.3 server comes with a tool called the prerequisite checker, which I was hoping to use before installing 6.2. I'm a bit confused by the manual, it states: Ensure that the appropriate installation package is downloaded and that its files are extracted. A prerequisite checker is part of the installation package. It says extracted, so not installed. However, if I download the 6.3 server from Passport Advantage it's a .bin file, which can only be installed as far as I know, right? So how do I just extract the prerequisite checker from this package? Thanks for your help in advance! Kind 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 For information, services and offers
Re: backup Systemstate error
Hi Mike! From your error messages down below: initializeSnapshotSet() failed, check Microsoft Application event log for VSS errors, did you check the Application even log? What did it say? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Michael P Hizny Sent: maandag 21 januari 2013 14:51 To: ADSM-L@VM.MARIST.EDU Subject: backup Systemstate error Hi, We have a windows 2008 R2 server being backup up to a TSM 6.2.2.30 server using client version 6.4.0. The client was upgraded from 6.3 to try to fix this problem. We are getting a failure of the systemstate backup. I have deleted the TSM systemstate file system to try to fix this to no avail. We have also restarted the server. The rest of the file system backups run fine. Has anyone seen this before? The backjup domain is set to all-local. We have also tried taking the systemstate out of the backup and the results are the same. Here are the logs: Dsmsched.log: 01/20/2013 18:00:21 --- SCHEDULEREC OBJECT BEGIN NT_SERVER_SCHEDULE 01/20/2013 18:00:00 01/20/2013 18:00:21 Incremental backup of volume '\\sparrow\c$' 01/20/2013 18:00:21 Incremental backup of volume '\\sparrow\e$' 01/20/2013 18:00:21 Incremental backup of volume 'SYSTEMSTATE' 01/20/2013 18:01:06 ANS1959I Removing previous incomplete group '\System State\0\SystemState' Id:0-145799926 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'ASR' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'This is the path to the boot BCD store and the boot managers. All the files in this directory need to be backed up.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'Select this volume (\??\Volume{6fe50a41-cff1-11e0-8fb1-806e6f6e6963}) if it is a critical volume. Critical volumes are those which ASR must restore.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'Select this volume (C:) if it is a critical volume. Critical volumes are those which ASR must restore.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'Select to include disk #0 (of signature 0x80) for ASR restore.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'Select to include disk #1 (of signature a35bb97c-c8f9-4cf6-934d-329b30fc20e5) for ASR restore.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'COM+ REGDB Writer' component 'COM+ REGDB' using shadow copy. 01/20/2013 18:01:07 Backing up object 'Performance Counters Writer' component 'Performance Counters' using shadow copy. 01/20/2013 18:01:07 Backing up object 'Registry Writer' component 'Registry' using shadow copy. 01/20/2013 18:01:07 Backing up object 'System Writer' component 'System Files' using shadow copy. 01/20/2013 18:01:08 Backing up object 'Task Scheduler Writer' component 'Tasks Store' using shadow copy. 01/20/2013 18:01:08 Backing up object 'VSS Metadata Store Writer' component 'VSS Express Writer Metadata Store' using shadow copy. 01/20/2013 18:01:08 Backing up object 'FSRM Writer' component 'FSRM global configuration, including template definitions, file group definitions, classification properties and rules, file management and report settings that apply to the entire system' using shadow copy. 01/20/2013 18:01:08 Backing up object 'FSRM Writer' component 'FSRM classification module configuration, captured when the module registers with FSRM' using shadow copy. 01/20/2013 18:01:08 Backing up object 'FSRM Writer' component 'FSRM configuration on volume E:\, including its quota configuration, file screen configuration, and file screen audit logs' using shadow copy. 01/20/2013 18:01:08 Backing up object 'FSRM Writer' component 'FSRM reports, classification and file management logs repository, including any scheduled, incident, and on-demand reports and logs' using shadow copy. 01/20/2013 18:01:08 Backing up object 'WMI Writer' component 'Windows Managment Instrumentation' using shadow copy. 01/20/2013 18:01:15 ANS5283E The operation was unsuccessful. 01/20/2013 18:01:15 ANS1228E Sending of object 'SPARROW\SystemState\NULL\System State\SystemState' failed 01/20/2013 18:01:15 ANS5283E The operation was unsuccessful. . . . 01/20/2013 20:22:54 ANS1512E Scheduled event 'NT_SERVER_SCHEDULE' failed. Return code = 12. 01/20/2013 20:22:54 Sending results for scheduled event 'NT_SERVER_SCHEDULE'. 01/20/2013 20:22:54 Results sent to server for scheduled event 'NT_SERVER_SCHEDULE'. Dsmerror.log: 01/20/2013 18:01:15 ANS1327W The snapshot operation for 'SPARROW\SystemState\NULL\System State\SystemState' failed with error code: -1. 01/20/2013 18:01:15 ANS5250E An unexpected error was encountered. TSM function name : BaStartSnapshot TSM function : initializeSnapshotSet() failed, check Microsoft Application event log for VSS errors TSM return code : -1 TSM file :
Re: backup Systemstate error
Hmm... Just a wild guess, but could this be related? http://support.microsoft.com/kb/2582068 Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Michael P Hizny Sent: maandag 21 januari 2013 15:49 To: ADSM-L@VM.MARIST.EDU Subject: Re: backup Systemstate error The application log shows that the TsmVssPlugin reports that the writers received a backup request. There are entries for the Registry, ASR, Performance, Comm,, System, Task, etc writers basically saying that they received a backup request. They are informational. The only one that shows an error ist he following and it points me back to the TSM log: VSS processing encountered error 'VSS_E_PROVIDER_VETO' in the Volume Shadow Copy API 'AddToSnapshotSet'. For more information, see the IBM Tivoli Storage Manager client error log. Michael Hizny Assistant Director of Networking Binghamton University 607-777-4739 (office) 607-777-4009 (fax) mhi...@binghamton.edu -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: Monday, January 21, 2013 9:11 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] backup Systemstate error Hi Mike! From your error messages down below: initializeSnapshotSet() failed, check Microsoft Application event log for VSS errors, did you check the Application even log? What did it say? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Michael P Hizny Sent: maandag 21 januari 2013 14:51 To: ADSM-L@VM.MARIST.EDU Subject: backup Systemstate error Hi, We have a windows 2008 R2 server being backup up to a TSM 6.2.2.30 server using client version 6.4.0. The client was upgraded from 6.3 to try to fix this problem. We are getting a failure of the systemstate backup. I have deleted the TSM systemstate file system to try to fix this to no avail. We have also restarted the server. The rest of the file system backups run fine. Has anyone seen this before? The backjup domain is set to all-local. We have also tried taking the systemstate out of the backup and the results are the same. Here are the logs: Dsmsched.log: 01/20/2013 18:00:21 --- SCHEDULEREC OBJECT BEGIN NT_SERVER_SCHEDULE 01/20/2013 18:00:00 01/20/2013 18:00:21 Incremental backup of volume '\\sparrow\c$' 01/20/2013 18:00:21 Incremental backup of volume '\\sparrow\e$' 01/20/2013 18:00:21 Incremental backup of volume 'SYSTEMSTATE' 01/20/2013 18:01:06 ANS1959I Removing previous incomplete group '\System State\0\SystemState' Id:0-145799926 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'ASR' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'This is the path to the boot BCD store and the boot managers. All the files in this directory need to be backed up.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'Select this volume (\??\Volume{6fe50a41-cff1-11e0-8fb1-806e6f6e6963}) if it is a critical volume. Critical volumes are those which ASR must restore.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'Select this volume (C:) if it is a critical volume. Critical volumes are those which ASR must restore.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'Select to include disk #0 (of signature 0x80) for ASR restore.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'ASR Writer' component 'Select to include disk #1 (of signature a35bb97c-c8f9-4cf6-934d-329b30fc20e5) for ASR restore.' using shadow copy. 01/20/2013 18:01:07 Backing up object 'COM+ REGDB Writer' component 'COM+ REGDB' using shadow copy. 01/20/2013 18:01:07 Backing up object 'Performance Counters Writer' component 'Performance Counters' using shadow copy. 01/20/2013 18:01:07 Backing up object 'Registry Writer' component 'Registry' using shadow copy. 01/20/2013 18:01:07 Backing up object 'System Writer' component 'System Files' using shadow copy. 01/20/2013 18:01:08 Backing up object 'Task Scheduler Writer' component 'Tasks Store' using shadow copy. 01/20/2013 18:01:08 Backing up object 'VSS Metadata Store Writer' component 'VSS Express Writer Metadata Store' using shadow copy. 01/20/2013 18:01:08 Backing up object 'FSRM Writer' component 'FSRM global configuration, including template definitions, file group definitions, classification properties and rules, file management and report settings that apply to the entire system' using shadow copy. 01/20/2013 18:01:08 Backing up object 'FSRM Writer' component 'FSRM classification module configuration, captured when the module registers with FSRM' using shadow copy. 01/20/2013 18:01:08 Backing up object 'FSRM Writer' component 'FSRM configuration on volume E:\, including its quota configuration, file screen configuration, and file screen
TSM Device Driver
Hi TSM-ers! We have been using TSM on AIX for quite a while (since ADSM 2.1) and we always used the Atape driver. In fact I always thought one had to use the Atape driver, unless you use a drive which isn't supported by Atape, in that case you should use the TSM device driver. The 6.3 installation manual states: The Tivoli Storage Manager device driver is preferred for use with the Tivoli Storage Manager server. We are using a (virtual) 3584 library, should we use Atape or the TSM device driver? Thanks for your help! Kind 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 6.3 AF.cluster errors.
Hi Vik! This looks very much like APAR IC78933 (http://www-01.ibm.com/support/docview.wss?uid=swg1IC78933) but that should be fixed in 6.3.1 according to the APAR. I would check with support if I was you. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vikas Arora Sent: donderdag 13 december 2012 10:00 To: ADSM-L@VM.MARIST.EDU Subject: TSM 6.3 AF.cluster errors. Hallo All, I am facing a problem in one of our TSM server, where backup stg is failing with below error. Enviornemnt : TSM server 6.3.1.0 running on windows server 2008. Does anyone know a quick solution to this problem? Many thanks in advance 12/13/2012 09:54:03 ANR0103E aftxn.c(1594): Error updating row in table AF.Clusters. (SESSION: 59597, PROCESS: 2141) *12/13/2012 10:57:08 ANRD_0465510862 AddCluCurVolId(aftxn.c:2015) Thread45: Invalid colloc list encountered with numVols 1, numSlots 10, listSize -4, intListSize 32, colSize 28. (SESSION: 59597, PROCESS: 2141)* 12/13/2012 10:57:08 ANRD Thread45 issued message from: (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF8526A99 OutDiagToCons()+159 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF85204EC outDiagfExt()+fc (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF7F5EDAA AfFreeTxnDesc()+bda (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF7F60338 AfEndTxn()+ee8 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF7F60B13 AfPrepareTxn()+83 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF7F38A59 bfPrepareTxn()+289 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF84DC4AB tmFindOldestDbTxn()+24b (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF84DCE16 tmEndX()+e6 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF7F4A444 AfFindOrAddGroup()+1fd4 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF7F4BFA6 AfGetPrimaryPool()+e36 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF7F4E23D AfCopyVolume()+24d (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF7F8B7A2 AfBackupPoolThread()+182 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 07FEF7D482A4 startThread()+124 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 74651D9F endthreadex()+43 (SESSION: 59597, PROCESS: 2141) 12/13/2012 10:57:08 ANRD Thread45 74651E3B endthreadex()+df (SESSION: 59597, PROCESS: 2141) Vik. 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: AUDIT VOL with WAIT=YES ?
Hi Roger! Bear in mind that tapes with read or write errors will not always show up as read-only. In the past I came across multiple tapes with read or write errors which were still readwrite. In our shop I have TSMOR report all read-only tapes, unavailable tapes and also all tapes with number of read/write errors 0. We always do a move data against all of these volumes. I have seen multiple times that a tape had write errors, an move data showed numerous corrupted objects which could not be moved and the strange thing is that I could restore these objects from the copypool! This means that these objects were ok in the past and got corrupted somewhere down the line, probably during the last write action to the tape. By the way, we only use virtual tapes (EMC DL4106), reuse delay is 3 days. Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Roger Deschner Sent: vrijdag 9 november 2012 4:34 To: ADSM-L@VM.MARIST.EDU Subject: Re: AUDIT VOL with WAIT=YES ? I wound up using Alex Paschal's method - thanks! I am not worried (yet!) about damaged files. There are probably very few of them anyway. I am only doing a FIX=NO audit to see where the problems are. I'm capturing the results by Q ACTLOG ... SEARCH='PROCESS: ' and parsing msg ANR4133I for the audit results. If FIX=NO does not find any damaged files, as reported in ANR4133I, then the disk file volume is changed to READWRITE automatically. If the FIX=NO audit does find something wrong, then I will deal with it manually and carefully. I did not want to use Eric van Loon's suggestion of MOVE DATA, because that would really fill up this storage pool, considering we use a reuse delay. The advantage of AUDIT is that it does not cause any data movement other than one read pass, and most of the volumes will not have any problems. Thanks again, to both Eric and Alex. That was the obvious solution - a sleep loop querying processes after starting the AUDIT command. The improvement I added was to get the actual results via Q ACTLOG after it was finished. Roger Deschner University of Illinois at Chicago rog...@uic.edu ==I have not lost my mind -- it is backed up on tape somewhere.= On Tue, 6 Nov 2012, Alex Paschal wrote: Hi, Roger. I don't have one already made, but this should get you started. Hopefully there won't be too many typos. #!/usr/bin/ksh dsmadmc -id=id -pa=pa audit vol /path/file1 sleep 10 while dsmadmc -id=id -pa=pa -comma q pr | grep -qi audit ; do sleep 10 done dsmadmc -id=id -pa=pa update vol /path/file1 acc=readw On 11/6/2012 3:17 PM, Roger Deschner wrote: Does anybody have a script or program that can issue a TSM AUDIT VOLUME command and wait for it to finish - as though WAIT=YES existed? I keep getting r/o vols in my DEVCLASS FILE storage pools. I want to audit them before changing them back to r/w. I want an automatic process to do that, one at a time. I could have set up this storage pool with preallocated files instead of letting the operating system allocate and remove scratch volume files, but dsmfmt on 55TB of space to prepare the fixed volume files would take a very long time, like about a CPU-year. Roger Deschner University of Illinois at Chicago rog...@uic.edu ==I have not lost my mind -- it is backed up on tape somewhere.= 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: AUDIT VOL with WAIT=YES ?
Hi Roger! Why don't you use a MOVE DATA against r/o volumes? It has a WAIT=YES parameter and it's better than using the AUDIT VOLUME command. When you have a read error on a primary pool volume, the audit command (with FIX=YES) removes the backup data from the tape. Not a problem for backup data from the BA client, it gets backed up again next time, but it is a problem when this is TDP data. Your whole backup series is corrupted and you should schedule a new full backup as soon as possible. So my opinion is that r/o issues shouldn't be fixed automatically and unattended. Kind regards, Eric van Loon Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Roger Deschner Sent: woensdag 7 november 2012 0:18 To: ADSM-L@VM.MARIST.EDU Subject: AUDIT VOL with WAIT=YES ? Does anybody have a script or program that can issue a TSM AUDIT VOLUME command and wait for it to finish - as though WAIT=YES existed? I keep getting r/o vols in my DEVCLASS FILE storage pools. I want to audit them before changing them back to r/w. I want an automatic process to do that, one at a time. I could have set up this storage pool with preallocated files instead of letting the operating system allocate and remove scratch volume files, but dsmfmt on 55TB of space to prepare the fixed volume files would take a very long time, like about a CPU-year. Roger Deschner University of Illinois at Chicago rog...@uic.edu ==I have not lost my mind -- it is backed up on tape somewhere.= 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
client option set to exclude systemstate
Hi TSM-ers! We are struggling with expiration performance and recovery log utilization for quite some time. I came across flash 21470662 (http://www-01.ibm.com/support/docview.wss?uid=swg21470662) which contains almost all symptoms we see on our servers. To check the most obvious one (log utilization) I would like to exclude the systemstate on all Windows 2008 clients all at once. The easiest option is to do this through a client option set, but I'm not really familiar with them. I defined the flowing one: Optionset: WINDOWS2008_EXCL_SYSTEMSTATE Description: Excludes the systemstate backup on Windows 2008 clients Last Update by (administrator): KLM35757 Managing profile: Option: INCLEXCL Sequence number: 0 Use Option Set Value (FORCE): Yes Option Value: -systemstate Will this one work? Thank you very much for your help in advance! Kind 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: client option set to exclude systemstate
Thanks Gary and Andy! I changed INCLEXCL into DOMAIN. I cannot upgrade to 6.2.4 since we're still running 5.5 and we don't have the (down)time nor the hardware to upgrade to version 6 anytime soon... Kind regards, Eric van Loon -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: vrijdag 14 september 2012 15:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: client option set to exclude systemstate Sir: Use domain, not inclexcl. The value should be -systemstate That should work for you. Also, this problem is supposed to be fixed in server version 6.2.4. Getting ready to test the upgrade soon. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, EJ van - SPLXM Sent: Friday, September 14, 2012 8:35 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] client option set to exclude systemstate Hi TSM-ers! We are struggling with expiration performance and recovery log utilization for quite some time. I came across flash 21470662 (http://www-01.ibm.com/support/docview.wss?uid=swg21470662) which contains almost all symptoms we see on our servers. To check the most obvious one (log utilization) I would like to exclude the systemstate on all Windows 2008 clients all at once. The easiest option is to do this through a client option set, but I'm not really familiar with them. I defined the flowing one: Optionset: WINDOWS2008_EXCL_SYSTEMSTATE Description: Excludes the systemstate backup on Windows 2008 clients Last Update by (administrator): KLM35757 Managing profile: Option: INCLEXCL Sequence number: 0 Use Option Set Value (FORCE): Yes Option Value: -systemstate Will this one work? Thank you very much for your help in advance! Kind 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 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 statement
Wow... Richard, respect! This one works, you again saved my day Here is the final working statement, so it's 'logged' on the ADSM-L list: select node_name, filespace_name, hl_name, ll_name from backups where (upper(ll_name) like '%LOG%' or upper(ll_name) like '%ARCHIVE%' or upper(ll_name) like '%DBDATA%' or upper(ll_name) like '%DBINDEX%' or upper(ll_name) like '%DUMP%' or upper(ll_name) like '%AUDIT%') and upper(hl_name) like '%ORA\_%' ESCAPE '\' and node_name='KL100AT0' Thank you VERY much! Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Richard Sims [mailto:r...@bu.edu] Sent: vrijdag 4 juni 2010 16:07 To: Loon, EJ van - SPLXM Subject: Re: SQL statement On Jun 4, 2010, at 9:23 AM, Loon, EJ van - SPLXM wrote: Hi Richard! Thanks, but still not what I expect, an example of one of the many files returned: KL100AT0,/home,/oracle/xt03js/,statspack_a064.log Since I use upper(hl_name) like '%ORA_%' I would not expect a /oracle/xt03js/ in the list... No, you wouldn't. But... :-) Your thoughts are keyed on dealing with your site's directory name being like mount/data*/ora_* where the architects decided to have an underscore in the name, which is fine. But you're now being defeated by that underscore because, in a Select LIKE, an underscore is a wildcard for any single character! An example of using this: select NODE_NAME, PLATFORM_NAME from NODES where upper(PLATFORM_NAME) like 'LINUX__' to report any Linux86 clients, versus LinuxPPC. Unfortunately, TSM's Select does not conform to the standard that the backslash char be an escape, to turn off the special meaning of the underscore as in like '%ORA\_%' but, fortunately, it allows you to define an escape character, as in like '%ORA\_%' ESCAPE '\' So, mull that over, and give it a try. Life is seldom simple. R. 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: dsmserv UPGRADEDB
This APAR is fixed in 5.5.5 Correction: is projected to be fixed in 5.5.5. This level doesn't exist yet... Kind 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: Deleting ghost/empty volume on V6.1 server
Hi Zoltan! I have seen this behavior too a few months ago. In my case bouncing the server helped, I could delete the volume afterwards. Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Zoltan Forray/AC/VCU Sent: vrijdag 21 mei 2010 16:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: Deleting ghost/empty volume on V6.1 server Yep..Similar error/problem. Never starts/fails immediately 5/21/2010 10:18:57 AM ANR2017I Administrator ZFORRAY issued command: AUDIT VOLUME 086176 fix=yes 5/21/2010 10:18:57 AM ANR1199I Removable volume 086176 is required for audit process. 5/21/2010 10:18:57 AM ANRD_3143370830 AfGetNextContents(afqry.c:899) Thread47192: Missing row for bitfile 0.213369199, readWrite(Yes). 5/21/2010 10:18:57 AM ANRD Thread47192 issued message from: 5/21/2010 10:18:57 AM ANRD Thread47192 0x00c0f622 OutDiagToCons+0x0x142 5/21/2010 10:18:57 AM ANRD Thread47192 0x00c12104 outDiagfExt+0x0x194 5/21/2010 10:18:57 AM ANRD Thread47192 0x0069f41c AfGetNextContents+0x0x31c 5/21/2010 10:18:57 AM ANRD Thread47192 0x005f35b5 bfGetNextContents+0x0x55 5/21/2010 10:18:57 AM ANRD Thread47192 0x004a1eb9 DoAuditVolume+0x0x839 5/21/2010 10:18:57 AM ANRD Thread47192 0x004a360c AdmAuditVolume+0x0xf1c 5/21/2010 10:18:57 AM ANRD Thread47192 0x004826c1 AdmCommandLocal+0x0x3c1 5/21/2010 10:18:57 AM ANRD Thread47192 0x00483528 admCommand+0x0x948 5/21/2010 10:18:57 AM ANRD Thread47192 0x00af2bea SmAdminCommandThread+0x0x1a 5/21/2010 10:18:57 AM ANRD Thread47192 0x00c807f4 StartThread+0x0x84 5/21/2010 10:18:57 AM ANRD Thread47192 0x00336b206367 *UNKNOWN* 5/21/2010 10:18:57 AM ANRD Thread47192 0x00336a6d30ad *UNKNOWN* 5/21/2010 10:18:57 AM ANRD_0036126006 DoAuditVolume(admdvol.c:5449) Thread47192: Error 87 returned from bfGetNextContents. 5/21/2010 10:18:57 AM ANRD Thread47192 issued message from: 5/21/2010 10:18:57 AM ANRD Thread47192 0x00c0f622 OutDiagToCons+0x0x142 5/21/2010 10:18:57 AM ANRD Thread47192 0x00c12104 outDiagfExt+0x0x194 5/21/2010 10:18:57 AM ANRD Thread47192 0x004a242d DoAuditVolume+0x0xdad 5/21/2010 10:18:57 AM ANRD Thread47192 0x004a360c AdmAuditVolume+0x0xf1c 5/21/2010 10:18:57 AM ANRD Thread47192 0x004826c1 AdmCommandLocal+0x0x3c1 5/21/2010 10:18:57 AM ANRD Thread47192 0x00483528 admCommand+0x0x948 5/21/2010 10:18:57 AM ANRD Thread47192 0x00af2bea SmAdminCommandThread+0x0x1a 5/21/2010 10:18:57 AM ANRD Thread47192 0x00c807f4 StartThread+0x0x84 5/21/2010 10:18:57 AM ANRD Thread47192 0x00336b206367 *UNKNOWN* 5/21/2010 10:18:57 AM ANRD Thread47192 0x00336a6d30ad *UNKNOWN* 5/21/2010 10:18:57 AM ANR2667W Audit volume process has skipped volume 086176 due to an error. From: Rick Adamson rickadam...@winn-dixie.com To: ADSM-L@VM.MARIST.EDU Date: 05/21/2010 09:36 AM Subject: Re: [ADSM-L] Deleting ghost/empty volume on V6.1 server Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Did you try to perform an audit on the volume(s) using the fix option? ~Rick Adamson -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Zoltan Forray/AC/VCU Sent: Friday, May 21, 2010 9:33 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Deleting ghost/empty volume on V6.1 server Does anyone have a suggestion on deleting a screwed-up volume on a 6.1.3.4 server? I have tried all the usual methods, with no success. Any attempt to get any info from this volume generates this error: 5/21/2010 7:56:07 AM ANRD_3143370830 AfGetNextContents(afqry.c:899) Thread: Missing row for bitfile 0.213369199, readWrite(No). 5/21/2010 7:56:07 AM ANRD Thread issued message from: 5/21/2010 7:56:07 AM ANRD Thread 0x00c0f622 OutDiagToCons+0x0x142 5/21/2010 7:56:07 AM ANRD Thread 0x00c12104 outDiagfExt+0x0x194 5/21/2010 7:56:07 AM ANRD Thread 0x0069f41c AfGetNextContents+0x0x31c 5/21/2010 7:56:07 AM ANRD Thread 0x0069dc7c AfMoveData+0x0x1cc 5/21/2010 7:56:07 AM ANRD Thread 0x0061d40e bfMoveData+0x0x45e 5/21/2010 7:56:07 AM ANRD Thread 0x0055b458 AdmMoveData+0x0x538 5/21/2010 7:56:07 AM ANRD Thread 0x004826c1 AdmCommandLocal+0x0x3c1 5/21/2010 7:56:07 AM ANRD Thread 0x00483528 admCommand+0x0x948 5/21/2010 7:56:07 AM ANRD Thread 0x00af2bea SmAdminCommandThread+0x0x1a 5/21/2010 7:56:07 AM ANRD Thread 0x00c807f4 StartThread+0x0x84 5/21/2010 7:56:07 AM ANRD Thread 0x00336b206367 *UNKNOWN* 5/21/2010 7:56:07 AM ANRD Thread 0x00336a6d30ad *UNKNOWN* 5/21/2010 7:56:07 AM ANR2209W Volume 086176 contains no data. When I try to DELETE VOLUME ... DISCARDDATA=YES, I get:
Database corruption
Hi TSM-ers! One of our servers have database corruptions. An audit of a copy of the production database restored on our test environment revealed them. Since we do not know the impact of these errors (can all client data be restored, can I restore all primary volumes in case of a restore stgpool?) I definitely like to fix these errors. I ran a AUDITDB ARCHSTORAGE on this server, but that does not fix them, only a full audit does (I have proven this on the test server). The problem is that a full audit runs for 60 hours and I cannot afford a 60 hours downtime. Most of our Oracle and SAP clients haven't got enough achivelog space to survive. I tried several things to trick TSM like create a snapshot on production, immediately followed by a full backup, then restore the snapshot on the test server, perform the full audit on this copy and than create a full backup on the fixed database. This way both fulls have the same sequence number, so I was hoping I could then restore the fixed copy on the production server and apply all incrementals made on the production server. Bad luck, TSM apparently stores timestamp information about previous full backups as part of the incremental backups: ANR4651E Restore of backup series 1733 operation restore is not in sequence; backup is part of another log epoch. Explanation: During a DSMSERV RESTORE DB, a backup volume was mounted that is not in the correct sequence. The current backup operation cannot be restored in this series because it belongs to the same backup series from another point in time. Bummer... The only thing I can think of now is making a snapshot copy and restore it on the test server, perform a full audit here and freeze ALL housekeeping processes on the production server. On the production server perform an EXPORT SERVER FILEDATA=ALL FROMDATE=TODAY-1 FROMTIME=NOW every day at the same time. As soon as the audit finishes on the test server, create a snapshot and restore it on the production server and import all export volumes created. Am I missing anything or should this work? Import as well as export are single processes, so performance can be an issue here... Thank you very much for your replies in advance! Kind regards, Eric van Loon KLM Royal Dutch Airlines /prebrFor 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.brbrKoninklijke 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.brKoninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 3014286 brpre
Re: Database corruption
Hi Neil! It may be able to handle the load, but I don't have the storage capacity on the backend on this server. When you direct the backups to the other server, all BA clients basically start all over again with a 'full' backup and I don't have that capacity on the spare server... Thank you very much for your reply! Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Strand, Neil B. Sent: donderdag 20 mei 2010 14:57 To: ADSM-L@VM.MARIST.EDU Subject: Re: Database corruption Eric, I ran into a similar problem 2 years ago - Corrupted DB. Fortunately, I had a spare server that I quickly set up and moved all backup operations to that server. It took a few days to run through the DB fixes on the corrupt server. After the DB was fixed, I just did server-server exports of all of the old data to the new server. If your test server can temporarily handle the load, you may be able to run backups to it for the 3 or 4 days it takes to fix the corrupt DB and then swing everything back to the original server using server to server exports. Cheers, Neil Strand Storage Engineer - Legg Mason Baltimore, MD. (410) 580-7491 Whatever you can do or believe you can, begin it. Boldness has genius, power and magic. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Loon, EJ van - SPLXM Sent: Thursday, May 20, 2010 7:08 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Database corruption Hi TSM-ers! One of our servers have database corruptions. An audit of a copy of the production database restored on our test environment revealed them. Since we do not know the impact of these errors (can all client data be restored, can I restore all primary volumes in case of a restore stgpool?) I definitely like to fix these errors. I ran a AUDITDB ARCHSTORAGE on this server, but that does not fix them, only a full audit does (I have proven this on the test server). The problem is that a full audit runs for 60 hours and I cannot afford a 60 hours downtime. Most of our Oracle and SAP clients haven't got enough achivelog space to survive. I tried several things to trick TSM like create a snapshot on production, immediately followed by a full backup, then restore the snapshot on the test server, perform the full audit on this copy and than create a full backup on the fixed database. This way both fulls have the same sequence number, so I was hoping I could then restore the fixed copy on the production server and apply all incrementals made on the production server. Bad luck, TSM apparently stores timestamp information about previous full backups as part of the incremental backups: ANR4651E Restore of backup series 1733 operation restore is not in sequence; backup is part of another log epoch. Explanation: During a DSMSERV RESTORE DB, a backup volume was mounted that is not in the correct sequence. The current backup operation cannot be restored in this series because it belongs to the same backup series from another point in time. Bummer... The only thing I can think of now is making a snapshot copy and restore it on the test server, perform a full audit here and freeze ALL housekeeping processes on the production server. On the production server perform an EXPORT SERVER FILEDATA=ALL FROMDATE=TODAY-1 FROMTIME=NOW every day at the same time. As soon as the audit finishes on the test server, create a snapshot and restore it on the production server and import all export volumes created. Am I missing anything or should this work? Import as well as export are single processes, so performance can be an issue here... Thank you very much for your replies in advance! Kind regards, Eric van Loon KLM Royal Dutch Airlines /prebrFor 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.brbrKoninklijke 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.brKoninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 3014286 brpre IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any
Re: Database corruption
Hi Wanda! You don't want tapes to be reclaimed and you definitely don't want pending tapes to become scratch during the audit on the other system. When I restore the fixed database on the production server, it will otherwise try to reclaim volumes which contain other, newer data. Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Prather, Wanda Sent: donderdag 20 mei 2010 16:11 To: ADSM-L@VM.MARIST.EDU Subject: Re: Database corruption I think your reasoning is sound and will work. Not sure why you would need to kill housekeeping on the prod server; why not let it continue to run? You'll still want your copypool tapes created for those 4 days of the audit. Depending on your total daily volume, and if you have GIGE network throughput, you might make less work for yourself with: Restore the DB to the test server Run the audit on the test server Take a DB backup on the test server On the prod server: Do a server-to-server export FILEDATA=ALL FROMDATE=DB backup date FROMTIME=DB backup time Next day Server-to-server export FILEDATA=ALL FROMDATE=today-1 TODATE=now Repeat daily until you can get downtime to swap the DB's back Only reason I can see that wouldn't be easier, is if you have too much incoming data on the prod side to do the server-to-server export in a timely manner. But sometimes server-to-server exports can be faster than exports to tape. Just depends... -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Loon, EJ van - SPLXM Sent: Thursday, May 20, 2010 7:08 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Database corruption Hi TSM-ers! One of our servers have database corruptions. An audit of a copy of the production database restored on our test environment revealed them. Since we do not know the impact of these errors (can all client data be restored, can I restore all primary volumes in case of a restore stgpool?) I definitely like to fix these errors. I ran a AUDITDB ARCHSTORAGE on this server, but that does not fix them, only a full audit does (I have proven this on the test server). The problem is that a full audit runs for 60 hours and I cannot afford a 60 hours downtime. Most of our Oracle and SAP clients haven't got enough achivelog space to survive. I tried several things to trick TSM like create a snapshot on production, immediately followed by a full backup, then restore the snapshot on the test server, perform the full audit on this copy and than create a full backup on the fixed database. This way both fulls have the same sequence number, so I was hoping I could then restore the fixed copy on the production server and apply all incrementals made on the production server. Bad luck, TSM apparently stores timestamp information about previous full backups as part of the incremental backups: ANR4651E Restore of backup series 1733 operation restore is not in sequence; backup is part of another log epoch. Explanation: During a DSMSERV RESTORE DB, a backup volume was mounted that is not in the correct sequence. The current backup operation cannot be restored in this series because it belongs to the same backup series from another point in time. Bummer... The only thing I can think of now is making a snapshot copy and restore it on the test server, perform a full audit here and freeze ALL housekeeping processes on the production server. On the production server perform an EXPORT SERVER FILEDATA=ALL FROMDATE=TODAY-1 FROMTIME=NOW every day at the same time. As soon as the audit finishes on the test server, create a snapshot and restore it on the production server and import all export volumes created. Am I missing anything or should this work? Import as well as export are single processes, so performance can be an issue here... Thank you very much for your replies in advance! Kind regards, Eric van Loon KLM Royal Dutch Airlines /prebrFor 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.brbrKoninklijke 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.brKoninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 3014286 br
Re: Windows 2000 client
Hi Gary! The latest version for Window 2000 is 5.3.6.7 and can be downloaded from IBM: ftp://service.boulder.ibm.com/storage/tivoli-storage-management/patches/ client/v5r3/Windows/Win2000/v536/TSM536C_7_X32.exe Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lee, Gary D. Sent: dinsdag 18 mei 2010 15:22 To: ADSM-L@VM.MARIST.EDU Subject: Windows 2000 client I know this is old, but we have a situation. Tried to instal the latest tsm windows 2000 client I had downloaded. Gave us an error claiming it wasn't the correct client for that op sys. This was a security fix issued by ibm its name was tsm536c_2_x32.exe. On the off chance that it was a corrupt download, went to try and find it again, haven't been able to come up with it. So, what is the latest client fix for win 2000; and where do I find it? Thanks all. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 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: delete volhist
You can never delete that volume from Volhist until you have done a new full successful backup. Well, not officially. You can issue a del volh type=dbb todate=today force=yes which deletes all database backup volumes. Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Christian Svensson Sent: zondag 28 maart 2010 11:50 To: ADSM-L@VM.MARIST.EDU Subject: SV: delete volhist TSM will always keep minimum 1 full TSM DB Backup. You can never delete that volume from Volhist until you have done a new full successful backup. But it is not recommended to only keep 1 full backup, and you can verify that you have a DB Backup by run q volhist Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Skype: cristie.christian.svensson Supported Platform for CPU2TSM:: http://www.cristie.se/cpu2tsm-supported-platforms Från: Mehdi Salehi [ezzo...@googlemail.com] Skickat: den 28 mars 2010 11:44 Till: ADSM-L@VM.MARIST.EDU Ämne: delete volhist Hi, - A TSM server has weekly full and daily incremental database backups. - All volume history information are accidentally deleted by delete volhist type=all todate=today - Can TSM admin restore database backups? Thanks ** 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: TSMManager and clock change
Hi Thomas! From the TSMManager website: After starting the program you will have 30 days in which to evaluate the program, after that time it will only work if supplied with a license file that is purchased from us. So, when there is no license (or the license has expired) you have one month to extend it. Apparently rebooting the Collector gave you another month. TSMManager always reports the license expiration date in the titlebar of your TSMManager Viewer window. Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Thomas Denier Sent: donderdag 18 maart 2010 17:09 To: ADSM-L@VM.MARIST.EDU Subject: TSMManager and clock change We are using TSMManager 4.4. It stopped working just after the clock change on March 14. Most of the operations staff members on duty at the time reported that logon attempts failed with messages stating that the viewer was unable to connect to the collector. One staff member reported a message stating that no licenses were available. TSMManager returned to normal operation after the host system for the collector was rebooted. Did this happen at other TSMManager sites? Is it going to keep happening at every transition to or from daylight saving time? ** 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: Long running backup pinning log
Hi Zoltan! We were experiencing a lot of logpinning about a month ago which all seem related to a handful of clients. Investigation showed that nearly all of them were running with a half-duplex connection instead of a full duplex fixed rate. As soon as this was fixed by the client owner, backups were performing as expected and logpinning was gone too. Just an thought... Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Zoltan Forray/AC/VCU Sent: maandag 8 maart 2010 15:53 To: ADSM-L@VM.MARIST.EDU Subject: Re: Long running backup pinning log Thanks for the heads-up. Unfortunately, from reading the APAR, this box does not seem to have the symptoms. There is no significant gap in backing up each component of systemstate, unless this is hidden because of QUIET. We have changed this to VERBOSE to get more details on where it is slogging. From what I see in the dsmsched log, this is what the last backup that finished (todays is still running), says: 01:43 - Backup started 01:47 - Systemstate backup finished 12:21 - d$ drive backup finished 12:25 - c$ drive backup finished Total objects examined - 72,395 Total objects backed up - 1,725 Total data backed-up (to paraphase) - 93.82Gb I did note the Object compressed by is 87%. Which brings me to the question - Is the total amount backed up after compression? My guess it lots of time spent in compression (IBM - how about some compression algorithm controls (low - medium - high). Haven't ruled out retries - will see when verbose is on. I don't see journaling making that much of a difference. The server has 2GB RAM of which 900M was free when I checked it this morning, so it doesn't seem to be constrained. The backup is currently running and the dsm service was using 10-20% CPU. Zoltan Forray TSM Software Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html From: Andrew Raibeck stor...@us.ibm.com To: ADSM-L@VM.MARIST.EDU Date: 03/05/2010 04:32 PM Subject: Re: [ADSM-L] Long running backup pinning log Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hi Zoltan, Is the long-running backup working on system state? I haven't found a direct cause -- effect relationship to client APAR IC63094, but take a look at that APAR and see if, after applying the fix, the problem you are seeing goes away. I should mention to all: IC63094 describes a problem with long-running system state backups. This APAR may be of interest to you. Best regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/i...@ibmus Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_ Storage_Manager 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 2010-03-05 16:26:01: [image removed] Long running backup pinning log Zoltan Forray/AC/VCU to: ADSM-L 2010-03-05 16:26 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Please respond to ADSM: Dist Stor Manager I recently started having issues with my log going over 80% (5.5.3). Doing a show logpinned usually points to a long (18-hours) running backup session for one particular node. This is starting to happen more and more frequently. Once I kill the session, the log utilization drops to almost nothing since there has been a DB backup run earlier in the day. Any suggestions on how to handle this besides killing the session? The node is a standard 2K3 box using the 6.1.2.0 client. It is just a very slow/busy box. The long backups (times vary from 11-19 hours) often dump 120GB of data. Zoltan Forray TSM Software Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html ** 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
Re: DP for SQL Server backup file size
Hi Del! Is a parameter like the DP for SQL's parameter /STRIPes=n also available for the DP for Exchange client? I checked the manual, but could not find one... Thank you very much for your reply! Kind regards, Eric van Loon KLM Royal Dutch Airlines Hi Eric, Have you considered using the /STRIPes=n option? It allows you to break up the single stream of bytes into n stripes on different parallel sessions. 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 **
Re: DP for SQL Server backup file size
Hi Del! Thank you very much for you reply! As clear as always! Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Del Hoobler Sent: donderdag 25 februari 2010 16:10 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server backup file size Hi Eric, Microsoft had original intentions to add striping into Exchange legacy-style backups, but opted against it, most likely to focus their efforts on VSS backups. DP/Exchange has nothing built in to break apart the storage group list and create multiple streams. The only way to do this is to create and launch separate commands, specifying the individual storage groups. I have heard of a few customers that have written Perl scripts that query the storage groups and then build the commands dynamically in order to do this multiple-instance/parallelism automatically. Thanks, Del ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 02/25/2010 09:11:30 AM: [image removed] Re: DP for SQL Server backup file size Loon, EJ van - SPLXM to: ADSM-L 02/25/2010 09:13 AM Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Please respond to ADSM: Dist Stor Manager Hi Del! Is a parameter like the DP for SQL's parameter /STRIPes=n also available for the DP for Exchange client? I checked the manual, but could not find one... Thank you very much for your reply! Kind regards, Eric van Loon KLM Royal Dutch Airlines Hi Eric, Have you considered using the /STRIPes=n option? It allows you to break up the single stream of bytes into n stripes on different parallel sessions. 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 **
TSM 6.2
Hi TSM-ers! For those of you interested: http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=cainfotype=an appname=iSourcesupplier=897letternum=ENUS210-029 Kind 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: when will tsm for database (ms sql) 6.1 be released?
Hi Zoltan! Like Stefan states: Windows 2008 is not supported. DP for SQL 5.5.x.x supports the 6.1.x.x API client, but not the Windows 2008 OS. Kind regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Zoltan Forray/AC/VCU Sent: dinsdag 16 februari 2010 16:19 To: ADSM-L@VM.MARIST.EDU Subject: Re: when will tsm for database (ms sql) 6.1 be released? Why not? We have 6.x clients backing up MS-SQL with 5.5.3 TDP? Why would you expect IBM to update the 5.5 client to support W2K8 when 6.x already does? From: TSM t...@profi-ag.de To: ADSM-L@VM.MARIST.EDU Date: 02/16/2010 05:45 AM Subject: [ADSM-L] when will tsm for database (ms sql) 6.1 be released? Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU hello, when will tsm for database (ms sql) 6.1 be released? or when will be tsm 5.5 baclient support for windows 2008 r2? os is windows 2008 r2 (x64), sql server 2008 tsm client 5.5 is now not supported for 2008 r2 and i do not want to install tsm 6.1.3 baclient and tsm 5.5.3 for database together. with best regards stefan savoric ** 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 licence file
Hi *SM-ers! Does anybody know of a way to add the sqlclient.lic file to the 5.5.3.0-TIV-TSMSQL-WinX64.exe downloaded from the IBM FTP server? The license file is included in the 5.5.1.0 version downloaded from Passport Advantage, but I don't want my customers to have to install 5.5.1 first and the install 5.5.3 afterwards. 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 **