Re: TSM and Linux
Patrick You don't mention your version of TSM server or h/w platform and this is a fairly old APAR but I thought I'd mention it. APAR IC47731 deals with poor performance on Linux kernel 2.6 on zSeries. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Patrick Boutilier Sent: 27 February 2007 14:27 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM and Linux Mark Scott wrote: Morning all Does anyone have any experiences good or bad running Linux as a TSM Server? We are a reasonable size environment currently running AIX as our server and Linux/Windows and Aix clients. The question has been asked for various reasons to change processors and flavour. All feed back would be appreciated. We started using TSM on Linux back when Redhat 8 was in production. It has worked well for us except for one thing. Every time we try to update the OS to anything using a 2.6 kernel (CentOS 4.4 for example) the TSM server performs terribly under load. For example, at 10:00pm when about 15 machines start a backup you can not get an admin console to start for about 5 to 10 minutes. We always end up going back to RedHat 8 with 2.4.x kernel. From all the testing we have done it appears that the 2.6.x kernel is the problem. Regards Mark Mark Scott Enterprise Storage Tivoli Team Leader Bunnings Group Limited 126 Pilbara Street, Welshpool WA 6106 Locked Bag 20, Welshpool DC WA 6985 Phone : (08) 9365 1779 Fax :(08) 9350 6686 Mobile : 0408925402 E-mail : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Bunnings Legal Disclaimer: 1) This email is confidential and may contain legally privileged information. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this email in error, please notify us immediately by return email and delete the document. 2) All emails sent to and sent from Bunnings Group Limited. are scanned for content. Any material deemed to contain inappropriate subject matter will be reported to the email administrator of all parties concerned.
Re: TSM BA WebClient fails to launch
Dave Is this of any use http://www-1.ibm.com/support/docview.wss?uid=swg21215383 Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David McClelland Sent: 23 February 2007 14:04 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM BA WebClient fails to launch Hi Guys, I'm at a bit of a loss here - has anyone come across something similar to this, or might be able to point me in the direction of some further investigation? Problem statement: When attempting to launch the TSM Backup-Archive Web Client for a given client in a web browser it fails to launch - the error that I see in IE (6.0.3790) is 'exception: java.lang.NumberFormatException: For input string . ' . The dsmcad on the client (Solaris 5.8 SPARC TSM BA Client 5.3.4.4) is running, and the dsmwebcl.log shows the session starting ('23-02-2007 13:54:23 (dsmcad) ANS3006I Processing request for the TSM Web Client (xx.xx.xx.xx).' but nothing more. The dsmerror.log reveals the cryptic '23-02-2007 13:54:24 --cdLocalToUcs converter does not exist!'. # java -version java version 1.4.2_04 Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05) Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode) Further info: The same web browser from the same host works absolutely fine to launch the TSM BA Web Client for other clients which are as far as I can tell almost identical (from the same build image, same OS level, same Java version, same TSM BA client version, same $PATH and other env settings). I'm a little at a loss and I don't quite know where to look next - Googles on strings such as 'cdLocalToUcs' and ''exception: java.lang.NumberFormatException: For input string . ' have yielded either nothing or nothing that I can understand! Any clues or further (probably Java) logfiles I should be looking for? Many Thanks, David McClelland London, UK This email was sent to you by Reuters, the global news and information company. To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Limited. Reuters Limited is part of the Reuters Group of companies, of which Reuters Group PLC is the ultimate parent company. Reuters Group PLC - Registered office address: The Reuters Building, South Colonnade, Canary Wharf, London E14 5EP, United Kingdom Registered No: 3296375 Registered in England and Wales
Re: TSM BA WebClient fails to launch
David I remembered having a similar problem and vaguely recollected that it was to do with missing OS patches or locales, so I was able to slightly refine my search parameters. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David McClelland Sent: 23 February 2007 14:54 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM BA WebClient fails to launch Hey Leigh, Looks like a good hit, so it may well be - I'll check with the host and feed back. Now why on earth did that not show up when *I* did a search...? Cheers, David Mc -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Leigh Reed Sent: 23 February 2007 14:39 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM BA WebClient fails to launch Dave Is this of any use http://www-1.ibm.com/support/docview.wss?uid=swg21215383 Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David McClelland Sent: 23 February 2007 14:04 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM BA WebClient fails to launch Hi Guys, I'm at a bit of a loss here - has anyone come across something similar to this, or might be able to point me in the direction of some further investigation? Problem statement: When attempting to launch the TSM Backup-Archive Web Client for a given client in a web browser it fails to launch - the error that I see in IE (6.0.3790) is 'exception: java.lang.NumberFormatException: For input string . ' . The dsmcad on the client (Solaris 5.8 SPARC TSM BA Client 5.3.4.4) is running, and the dsmwebcl.log shows the session starting ('23-02-2007 13:54:23 (dsmcad) ANS3006I Processing request for the TSM Web Client (xx.xx.xx.xx).' but nothing more. The dsmerror.log reveals the cryptic '23-02-2007 13:54:24 --cdLocalToUcs converter does not exist!'. # java -version java version 1.4.2_04 Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_04-b05) Java HotSpot(TM) Client VM (build 1.4.2_04-b05, mixed mode) Further info: The same web browser from the same host works absolutely fine to launch the TSM BA Web Client for other clients which are as far as I can tell almost identical (from the same build image, same OS level, same Java version, same TSM BA client version, same $PATH and other env settings). I'm a little at a loss and I don't quite know where to look next - Googles on strings such as 'cdLocalToUcs' and ''exception: java.lang.NumberFormatException: For input string . ' have yielded either nothing or nothing that I can understand! Any clues or further (probably Java) logfiles I should be looking for? Many Thanks, David McClelland London, UK This email was sent to you by Reuters, the global news and information company. To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Limited. Reuters Limited is part of the Reuters Group of companies, of which Reuters Group PLC is the ultimate parent company. Reuters Group PLC - Registered office address: The Reuters Building, South Colonnade, Canary Wharf, London E14 5EP, United Kingdom Registered No: 3296375 Registered in England and Wales This email was sent to you by Reuters, the global news and information company. To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Limited. Reuters Limited is part of the Reuters Group of companies, of which Reuters Group PLC is the ultimate parent company. Reuters Group PLC - Registered office address: The Reuters Building, South Colonnade, Canary Wharf, London E14 5EP, United Kingdom Registered No: 3296375 Registered in England and Wales
Re: TAPEPOOL made up of mixed LTO2 LTO3 media
Bill, This is not in direct answer to your question, but I ran into a problem with HP LTO3 drives. I have assumed you are replacing the old HP drives with new HP drives. Take a look at IC49307, you may need to incorporate a server upgrade if you encounter this problem. Also take a look at this URL for supported f/w releases for the drives. http://www-1.ibm.com/support/docview.wss?rs=663uid=swg21193425 Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Dourado Sent: 21 February 2007 11:58 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TAPEPOOL made up of mixed LTO2 LTO3 media Importance: High Hi, We are about to replace our all HP LTO-2 tape drives by LTO-3, in our NEO 4000 library. My question is, seeing the new drives can read and write both LTO-2 and LTO-3 media, can any given existing tapepool be made up of both LTO-2 and LTO-3 media ? My problem is that I don't have enough tape slots in the library and don't want to introduce a large number of LTO-3 tapes in one go. Also a few of our LTO-2 tapes are fairly new and it would be a shame to write them off. (TSM Server for Windows 5.3) Thanks Bill ** This electronic mail message, including any attachments, is a confidential communication exclusively between Babcock International Group PLC or its subsidiary company and the intended recipient(s) indicated as the addressee(s). It contains information which is private and may be proprietary or covered by legal professional privilege. If you receive this message in any form and you are not the intended recipient you must not review, use, disclose or disseminate it. We would be grateful if you could contact the sender upon receipt and in any event you should destroy this message without delay. Anything contained in this message that is not connected with the business of Babcock International Group PLC is neither endorsed by nor is the liability of this company. Babcock International Group PLC Company number 2342138 Registered in England 2 Cavendish Square London W1G 0PX Telephone: +44(0)20 7291 5000 Fax: +44(0)20 7291 5055 Website: www.babcock.co.uk **
Re: Error restoring SQL database
Eric, It's possible that the primary sequential tape volume that the data resides on has a problem. Are you able to see which volume the restore requires and check the status of the volume. It could be unavailable or destroyed or you may need to perform an audit on it. If you don't know what tape it is asking for, the following select command will list the all tape volumes that have data on for that node. You may have to check the status of them all. select distinct(volume_name) from volumeusage where node_name='' and stgpool_name='y' Also, you may need to check that your library is online and that you have sufficient mount points for the restore. If you do find that the primary volume has an issue, you may have to recall a copy pool volume. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: 13 February 2007 11:10 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Error restoring SQL database Importance: High Hi *SM-ers! Our SQL guys are trying to restore a SQL database. They receive the following error: ANS1314E File data currently unavailable on server In the TSM activity log I see the following message: ANR0548W Retrieve or restore failed for session 2337961 for node KL1007W9-SQL (TDP MSSQL Win32) processing file space KL1007W9\data\0001 2 for file \Zeus\ full stored as Backup - error detected. Error detected. Right... How do I find what kind of error? Thank you very much for your reply!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: Failed Exckange Restore ACN5798E..
Bo Have you set the Exchange DB to accept a restore. I am assuming that you are using Exchange2000 or E2K3. From the Exchange System Admin Open the Mailbox Store Properties dialog box. On the Database tab, select the This database can be overwritten by a restore check box Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Nielsen, Bo Sent: 13 February 2007 13:29 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Failed Exckange Restore ACN5798E.. Hi In a Exchange MSCluster, I try to restore a DB, but get the Errorcode: ACN5798E MS Exchange API HRESERESTOREADDDATABASE() failed with HRESULT: 0xc7fe1f42 - I have made a failover to the other node, but it doesn't work. TSM server 5.3.4 TDP vers. 5.2.1 aOaRegards Bo Nielsen
Re: Pricing model for 5.4
This is my dreaded interview question...please explain the current TSM pricing model. Even if I was lucky enough to pick the correct current model, I would be hard pushed to explain it in rational terms and it appears IBM salesman don't fair much better. All I would say is that, I've worked in large shops that seem to spend a great deal of money, yet aren't able/willing to negotiate competitive pricing and relatively small shops that have an amazing discount. Whatever the model, whatever the price, I think that you have to negotiate as aggressively as possible. While I am TSM through and through, there are other enterprise products out there and letting the salesperson know that and the fact that the cost differential is making the change look very attractive, often makes them think again. You can always invite the reporter of the SearchStorage article into the negotiations with you! Where possible, I've always tried to make a salesman work for the extortionate amounts of commission they earn. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 08 February 2007 20:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Pricing model for 5.4 Ok, this will be my last. Having never seen what we were paying for licences you can obviously come to the conclusion you have. I can't and won't post that info but I have data to prove it. I can tell you that IBM has been drooling waiting for our contract to expire I'm sure. The past year has seen some interesting things IBM has tried to do here. Can't get into detail so let's just say there has been a lot of angry people. So when I say that our costs have gone up that's an understatement. Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Remco Post Sent: Thursday, February 08, 2007 12:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Pricing model for 5.4 Gill, Geoffrey L. wrote: Just one of my pet peves with this product. I just went through this with someone and it looks to me like the changes that were made since the last time have dramatically increased the cost here. Having to contact someone to figure out pricing makes no sense when you can find pricing for most anything else you want on the internet. Oh sure, I would expect that you need to contact someone to get better pricing before you buy, but to not have a way to at least figure out something on your own is unsatisfactory to me. The only change I've seen is that multi-core CPU's are actually cheaper that in the old model (100 points for 2 x86 cores rather than 2 lisences, even better for UltraSPARC T1), so how you manage to increase cost beats me. Since 100 points are (more or less) the same as 1 license, I expect to pay less, not more. Since IBM has some interesting volume discounts, nobody ever pays list-prices. Of course we all know or discount... I estemate investments in new licenses on the cost for last year, not to hard. And yes, I only buy new licenses once a year, doing so more often is a PITA ;-) Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Longo Sent: Tuesday, February 06, 2007 4:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Pricing model for 5.4 I second the motion, Steve! TSM should be able to track/mange the license scheme. Or they should provide an additional tool to do it - without charging you $100K for the tool! David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5509 [EMAIL PROTECTED] Steven Harris [EMAIL PROTECTED] 2/6/2007 7:11 PM Hi All, I was looking at the TSM 5.4 announcement letter and notice that 5.4 now attracts Processor Value Unit pricing. The (AP) announcement letter points you to the PVU announcement letter AP06-0154, which contains a lot of justification and not much else. It in turn points you to a website for detailed information - but this is just the passport advantage portal. I have a few concerns. First, PVU pricing may mean an effective price rise, although it is hard to tell without detailed information. Certainly its a change. Second, why is it so hard to find definitive information? This should be widely published on a publicly available website. Third, yet again the administrative burden of tracking licencing requires detailed hardware information to be maintained and correlated with the TSM usage. Again, the product has not been enhanced to automatically collect and maintain this information, providing a significant overhead for administrators and a lack of assurance that licencing
Re: VTL's (looking for info)
Geoff The last time I posted an enquiry regarding VTL's, I received some info from some people at Sepaton. I think that they subscribe to the list for this purpose. It wasn't a hard sell or anything like that, they just asked if they could send me some literature and I accepted. The literature was informative and their products looked good. Unfortunately, the powers that be here wanted to stay with what they know and we ended up with another physical tape library. If nobody contacts you from Sepaton, I would be happy to provide you with the details of the gentleman on a personal mail. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 06 February 2007 02:15 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] VTL's (looking for info) Does anyone have a doc or a link to anything that discusses the pro's and con's of a VTL? Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED]
Re: exporting scripts
I too couldn't find any documentation, hence my convoluted method of trying achieve the goal. Now that I know the command, I found some reference in a posting from 2001 and also reference in TSM 5.1 and 4.2 documentation. It's a shame that IBM won't (re)-document it, but thanks to this thread, I certainly won't be forgetting it. David, I appreciate your help. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: 31 January 2007 20:32 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] exporting scripts I learned about q script format=macro either on this list or at Share. I also could not find it documented in the TSM doc so I opened a PMR with TSM support. Matthew Armstrong eventually reported that The product is considered working as designed and there is essentially nowhere further we can go with this issue. and therefore they could not take a doc apar against it. So I guess it will continue to be secret information that you find out about on adsm-l! David Ehresman Choudarapu, Ramakrishna (GTI) [EMAIL PROTECTED] 1/25/2007 12:46 PM Looks great! But where is it documented? I do not see f=macro on HELP QUERY SCRIPT!!! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: Thursday, January 25, 2007 12:37 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] exporting scripts q script f=macro script.mac will create a file script.mac which contains DEFINE statements to recreate all your scripts. Just move the file to your new system and execute it with a macro script.mac command. David Leigh Reed [EMAIL PROTECTED] 1/25/2007 12:25 PM Geoff, I am doing the exact same thing at the moment. I think that there should be an easier way than this, but this is what I have so far select distinct 'query script',name,'f=raw outputfile=',name from scripts scripts.scr This gives you a text file of the format below for every script that you have (you will have to delete a space between outputfile and scriptname) query script scriptname f=raw outputfile=scriptname You can then run this file as a macro/script to output all of your scripts in raw format to an individual text file with the respective script name as the filename. You can then copy these files to your new server. Using find and replace or text editing tools you can slightly modify your generated script from above to the format def script scriptname file=filename Then run this script and it will generate all your scripts on your new server. I have to add that using the select to generate the original script is not my own work, I stole it from a previous posting enquiring how to script a number of move datas, but it is neat. Credit the original poster (IIRC WP) If I find a better way, I'll let you know, likewise visa versa. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 25 January 2007 16:40 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] exporting scripts I think this has been asked before but I can't seem to find anything so hopefully my asking again won't be a big deal. I am trying to figure out if there is a way to export all of my scripts from one server so I can import them to another. I have tried to manually create these scripts but sometimes the 5.3 GUI chokes and won't let me, even though I have copied them exactly. If anyone has any thoughts on the easiest way to accomplish this I would appreciate it. This second server is for testing so I'm not looking to make anything permanent. Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED] If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
Re: [SPAM: 12.500] [ADSM-L] Error running Image Backup online
Robert, Do you have any disk quota s/w running on this machine that may restrict the size of a file written to disk? Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Ouzen Ouzen Sent: 31 January 2007 09:36 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 12.500] [ADSM-L] Error running Image Backup online Hi to all When trying to backup with the image feature a windows 2003 client online I got the following error: 01/31/2007 11:20:44 ANS1259E The image snapshot operation failed. Diagnostic text: SnapshotCallback: snapStatus = 1, snapRc = 6. 01/31/2007 11:20:44 ANS1425E The image operation for volume \\tssrv03\c$ cannot be retried because of a severe error. 01/31/2007 11:20:50 ANS1228E Sending of object '\\tssrv03\c$' failed 01/31/2007 11:20:50 ANS1346E The image snapshot operation failed. The SNAPSHOTCACHELocation does not contain enough space for this snapshot image backup. 01/31/2007 11:20:50 ANS1813E Image Backup processing of '\\tssrv03\c$' finished with failures. I search the ANS1259E and ANS1346E errors , my disk C: is not compress and tried too the SNAPSHOTCACHELocation to another partition with plenty room with the same result. I did it on a lot others Windows2003 client with no problem !!! Any others ideas ? My Tsm client version is 5.3.4.8 Regards Robert Ouzen
Re: SAP offline backup problems
Chris This is a MS resource issue. It is common when backing up large filesystems or large files. While the following posting doesn't relate to offline SAP backups with the TDP specifically, I think that it is the same underlying cause. It is probably the latter part of the posting that is most useful, regarding MS KB articles. See if it helps. http://msgs.adsm.org/cgi-bin/get/adsm0405/200/1.html Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Chris McKay Sent: 29 January 2007 15:25 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SAP offline backup problems Hi, Would anyone have any ideas?? When I run an offline backup of our SAP Oracle database it very frequently fails with the following 00:25:21: BKI4007E: File 'L:\ORACLE\PRD\SAPDATA3\BTABI_10\BTABI.DATA10' cannot be read Reason: errno(1450) Insufficient system resources exist to complete the requested service. This error continues for a random number of files then continues to work properly. This runs as scheduled, on a weekly basis, and occasionally works. I've checked the actlog and it dosen't look like anything else is running on the TSM server at the time this backup kicks in. Also I never have a problem with online backups. The TSM server is running on Windows at version 5.3, and the SAP Oracle database server is also a Windows server using the TDP for Oracle. Any ideas would be appreciated. Chris McKay Systems Administrator Phone: (905) 713-1211 Ext. 3046 __ This message is for the sole use of the intended recipients and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not an intended recipient, please contact the sender by reply email and destroy all copies of the original message. Thank you for your cooperation.
Re: exporting scripts
Geoff, I am doing the exact same thing at the moment. I think that there should be an easier way than this, but this is what I have so far select distinct 'query script',name,'f=raw outputfile=',name from scripts scripts.scr This gives you a text file of the format below for every script that you have (you will have to delete a space between outputfile and scriptname) query script scriptname f=raw outputfile=scriptname You can then run this file as a macro/script to output all of your scripts in raw format to an individual text file with the respective script name as the filename. You can then copy these files to your new server. Using find and replace or text editing tools you can slightly modify your generated script from above to the format def script scriptname file=filename Then run this script and it will generate all your scripts on your new server. I have to add that using the select to generate the original script is not my own work, I stole it from a previous posting enquiring how to script a number of move datas, but it is neat. Credit the original poster (IIRC WP) If I find a better way, I'll let you know, likewise visa versa. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 25 January 2007 16:40 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] exporting scripts I think this has been asked before but I can't seem to find anything so hopefully my asking again won't be a big deal. I am trying to figure out if there is a way to export all of my scripts from one server so I can import them to another. I have tried to manually create these scripts but sometimes the 5.3 GUI chokes and won't let me, even though I have copied them exactly. If anyone has any thoughts on the easiest way to accomplish this I would appreciate it. This second server is for testing so I'm not looking to make anything permanent. Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED]
Re: exporting scripts
See.i knew there had to be an easier way. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: 25 January 2007 17:37 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] exporting scripts q script f=macro script.mac will create a file script.mac which contains DEFINE statements to recreate all your scripts. Just move the file to your new system and execute it with a macro script.mac command. David Leigh Reed [EMAIL PROTECTED] 1/25/2007 12:25 PM Geoff, I am doing the exact same thing at the moment. I think that there should be an easier way than this, but this is what I have so far select distinct 'query script',name,'f=raw outputfile=',name from scripts scripts.scr This gives you a text file of the format below for every script that you have (you will have to delete a space between outputfile and scriptname) query script scriptname f=raw outputfile=scriptname You can then run this file as a macro/script to output all of your scripts in raw format to an individual text file with the respective script name as the filename. You can then copy these files to your new server. Using find and replace or text editing tools you can slightly modify your generated script from above to the format def script scriptname file=filename Then run this script and it will generate all your scripts on your new server. I have to add that using the select to generate the original script is not my own work, I stole it from a previous posting enquiring how to script a number of move datas, but it is neat. Credit the original poster (IIRC WP) If I find a better way, I'll let you know, likewise visa versa. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 25 January 2007 16:40 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] exporting scripts I think this has been asked before but I can't seem to find anything so hopefully my asking again won't be a big deal. I am trying to figure out if there is a way to export all of my scripts from one server so I can import them to another. I have tried to manually create these scripts but sometimes the 5.3 GUI chokes and won't let me, even though I have copied them exactly. If anyone has any thoughts on the easiest way to accomplish this I would appreciate it. This second server is for testing so I'm not looking to make anything permanent. Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED]
Re: Option other than a Backupset: Help!
Joni Without meaning to sound too pedantic, is that not cheating. I know they are the client and they know best but. Surely they should be aiming to understand the real challenges, performance and timing issues that would occur in a real DR. In essence, they are saying that it would be nice to know when the disaster is going to occur, so we can move all our active data onto high performance disk or single dedicated tapes the day before. They are in the wrong business if they can predict disasters. If their current architecture doesn't give them the RTO that they require then surely it is beneficial to demonstrate this, such that investment is injected into the TSM architecture to achieve acceptable restoral timings. Also, what happens in a real DR when the management expect the services to be functional according to the timings of the last DR trial. It's a false dawn. Having said all this, TSM version 5.4 is planned to have the ability to automatically collocate active data, which in essence is what you are looking for. Sorry if this sounds a little harsh, but I don't think you would be doing anybody any favours by manipulating the results. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 23 January 2007 15:40 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Option other than a Backupset: Help! Hi David, They would like backupsets created so that when we have a dr drill they can restore the filesystems that I put in the backupset immediately and very quickly without needing many tape mounts, etc. So it's mainly a performance timing issue. Also, for onsite needs if they ever need to rebuild it would be a lot quicker for them as well. If there is a better way of doing this or another method that makes more sense I am open to any suggestions. Thanks! Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] David E Ehresman [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 01/23/2007 10:04 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: Option other than a Backupset: Help! My first question when I hear a request like this is always why do they want it? I ask because it may be possible to give the customer what they want with a better solution. Customers are good at saying what they need but not always so good at finding the best way to fill that need. What problem is backupsets suppose to address? David Joni Moyer [EMAIL PROTECTED] 1/23/2007 7:13 AM Hello everyone, Several of my customers want backupsets created of their data. I really don't have the extra tape drives to spare to do this, so what might be your suggestion in getting a centralized backup of their critical filesystems? My TSM server is on AIX 5.3 and is at release 5.2.7.1. Any suggestions/help would be greatly appreciated! Thanks! Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED]
Re: Error during WMI backup
Thomas This may help http://www-1.ibm.com/support/docview.wss?uid=swg21083177 Although it denotes that it should have been fixed in client 5.3.2.0. See how you go. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: 23 January 2007 17:06 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Error during WMI backup One of our client backups is consistently failing with messages like the following: ANS1183E An unknown error occurred while processsing system object 'WMI Database': MS API function 'CoCreateInstance' failed with error -2147024882 (0x8007000e) ANS1228E Sending of object '\\jeffstat02\c$\ADSM.SYS\WMI\WMIDBFILE' failed ANS1487E An error occurred while backing up the WMI repository. The database will not be backed up. As far as I can tell, the Microsoft error code indicates insufficient memory. The client is a Windows 2000 system using 5.3.2.0 client code. The server uses 5.3.4.0 code under mainframe Linux. Does anyone know how to fix this?
Re: RoadMap?
I think that TSM 5.4 was due for release this month, however I don't know if it is on schedule. I think the reindeer struggled this year and Santa was late getting to the developers. (Sorry, couldn't resist a belated festive funny) A list of the new features/enhancements that were scheduled to be included follows below. Again, some might not have made the cut. I would imagine that some of the IBM'ers will give you a more detailed corporate line a little later in the day. Possible features; The ability to collocate active data on sequential media (typically sequential access disk for fast restores and reduced size disk pools). Integration of NDMP (Netapps/n-series) backups with TSM storage pools (allows filer-to-TSM-server backups). Support for NDMP v4. Backupset enhancements and improved flexibility (ability to produce point-intime backupsets using data in storage pools at any time). New Incremental backup method using a local disk cache to minimise memory utilisation (can now process an unbounded number of files). Vista Support (and Volume Shadow Copy Service integration). Support for Intel based Mac OS X (and standardised to use normal option file names). Support for hardware tape drive encryption. Various Admin Center updates. Note: Windows 2000 is not supported on ITSM 5.4.
Re: RoadMap? (Offtopic: Executive Briefings)
Timothy, I can't find any official literature on the IBM website, but I googled for it and found an IBM presentation at the URL below; Also, note the disclaimer. http://www.moregroupinc.com/TSM%205.4%20Highlights%20101606.pdf Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: 04 January 2007 15:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? (Offtopic: Executive Briefings) Hi Troy, Can this presentation be viewed on-line? Thanks Barnhart, Troy wrote: Just to add a related, but off-topic, suggestion about TSM 5.4 and IBM... Last fall we (as technicians) were invited to an Executive Briefing at IBM-Tucson about our storage needs. We received a roadmap presentation on TSM 5.4 and other storage concepts. I've been to a couple of IBM's Executive Briefings now. And I want to really advise you all that if you ever get the chance for one of these: Take it... Troy Barnhart, Sr. Systems Programmer [EMAIL PROTECTED] Regional Health, Inc. 353 Fairmont Boulevard Rapid City, South Dakota 57701 PH: 605-716-8352 / FAX: 605-716-8302 -Original Message- From: Leigh Reed [mailto:[EMAIL PROTECTED] Sent: Thursday, January 04, 2007 3:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RoadMap? I think that TSM 5.4 was due for release this month, however I don't know if it is on schedule. I think the reindeer struggled this year and Santa was late getting to the developers. (Sorry, couldn't resist a belated festive funny) A list of the new features/enhancements that were scheduled to be included follows below. Again, some might not have made the cut. I would imagine that some of the IBM'ers will give you a more detailed corporate line a little later in the day. Possible features; The ability to collocate active data on sequential media (typically sequential access disk for fast restores and reduced size disk pools). Integration of NDMP (Netapps/n-series) backups with TSM storage pools (allows filer-to-TSM-server backups). Support for NDMP v4. Backupset enhancements and improved flexibility (ability to produce point-intime backupsets using data in storage pools at any time). New Incremental backup method using a local disk cache to minimise memory utilisation (can now process an unbounded number of files). Vista Support (and Volume Shadow Copy Service integration). Support for Intel based Mac OS X (and standardised to use normal option file names). Support for hardware tape drive encryption. Various Admin Center updates. Note: Windows 2000 is not supported on ITSM 5.4. ***Note: The information contained in this message, including any attachments, may be privileged, confidential, and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the Sender immediately by a reply to sender only message and destroy all electronic or paper copies of the communication, including any attachments.
Database Buffer Allocation Windows2003 (32 bit)
Does anybody have any experience of configuring the following windows boot.ini parameters in conjunction with TSM server; /PAE /3GB With regards to being able to allocate 2GB to the TSM database bufferpool with Windows 2003 Enterprise Edition (32 bit) I have a Windows 2003 EE (32-bit) server with 8GB of RAM. Have applied the /PAE and /3GB switches to the boot.ini, but the TSM server will not start with 2GB. From the reading I have done, it appears that for non-MS apps to take advantage of these switches, they must be LARGEADDRESSAWARE. Does anybody know if the 32-bit TSM server for Windows is Large Address Aware. I know that a solution would be to go to a native 64-bit MS OS or non-MS 64-bit OS, however, there are some management issues preventing this at the moment. Thanks Leigh
Select statement for individual migration processes
I'm trying to construct a select statement that returns the historic details of individual migration processes. The summary table regards migration (per stgpool) as a single entity and returns the total time for all the processes (ie when the last process completes) and the entire amount of data moved (ie summation of bytes transferred for all the migration processes). Is it possible to get the breakdown of each individual migration thread via a select statement? I am trying to avoid calculating it manually by interrogating the activity log. Thanks Leigh
Re: [SPAM: 4.000] [ADSM-L] Restore node syntax
Joni, Try putting quotes around any file paths that have spaces in them. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 07 December 2006 15:16 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] Restore node syntax Hi Everyone, I must be getting the wrong syntax here or something because I keep getting incorrect results. Can anyone see what my mistake might be? Thanks in advance! I am trying to restore 2 files to a temporary location for our NDMP backups using the command line. RESTORE NODE nas_server_2 /root_vdm_14/hmvdm_tst /temp_server_2 filelist=?/STOREMGT/Open Systems/THINGS TO DO.doc?PITD=12/01/2006 PITT=23:00 WAIT=no nas_server_2 = node name /root_vdm_14/hmvdm_tst = source filespace name /temp_server_2 = destination filesystem /STOREMGT/Open Systems/THINGS TO DO.doc = full path name of file I keep getting invalid parameter. I ran this from a command line opened on our GUI. It is AIX 5.3 TSM 5.2.7.1. Any ideas? Thanks! Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED]
Re: [SPAM: 4.000] [ADSM-L] Restore node syntax
Joni Your command line reads in the mail I received that you have question marks around the filelist path. I don't know if the mail client has corrupted these and changed them into question marks, but they should be quotes. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 07 December 2006 15:16 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] Restore node syntax Hi Everyone, I must be getting the wrong syntax here or something because I keep getting incorrect results. Can anyone see what my mistake might be? Thanks in advance! I am trying to restore 2 files to a temporary location for our NDMP backups using the command line. RESTORE NODE nas_server_2 /root_vdm_14/hmvdm_tst /temp_server_2 filelist=?/STOREMGT/Open Systems/THINGS TO DO.doc?PITD=12/01/2006 PITT=23:00 WAIT=no nas_server_2 = node name /root_vdm_14/hmvdm_tst = source filespace name /temp_server_2 = destination filesystem /STOREMGT/Open Systems/THINGS TO DO.doc = full path name of file I keep getting invalid parameter. I ran this from a command line opened on our GUI. It is AIX 5.3 TSM 5.2.7.1. Any ideas? Thanks! Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED]
Re: Vaulting Service
Orin, If you are referring to actually sending your backup data over the internet to a third party vendor (ie outsourcing some/all of your backups). I know that SunGard in the UK actually offer a service known as Vaulting. They do use TSM, however I don't know if the corresponding service exists in the US. You may need to check with your auditors as to whether sending your backup data over the internet would be acceptable (even with encryption). Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Orin Rehorst Sent: 01 December 2006 14:56 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] Vaulting Service Know of anyone using a vaulting service with transmissions over the Internet with TSM? We're at capacity and looking for options. Regards, Orin Orin Rehorst
Re: Second TSM Instance
Guillaume Take a look at the 5.3 Windows Installation Guide (winservinstall.pdf). Chapter 3, after Installing Tivoli Storage Manager Server, there is a section called Installing Multiple Tivoli Storage Manager Servers on a Single machine. The documentation is not that detailed, but if you wanted to see confirmation from IBM that it is possible, that's where it is. You simply use the wizard to add other instances. These instances are denoted in the registry and by default are called Server1, Server2 etc. The instance specific files (dsmserv.opt, volhist, devconfig, etc) are stored in a sub-directory denoted by default as c:\program files\tivoli\tsm\Server1\ etc. You can choose the name of the directories at conception in the wizard. I have a Multi-Instance W2K3 server running with library sharing and it works fine. With the ability to address 4GB RAM and 64-bit OS, W2K3 is becoming a more viable option for larger multi-instance TSM operations. Leigh light blue touch paper and stand back -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gilbert, Guillaume Sent: 28 November 2006 14:28 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 7.700] Re: [ADSM-L] Second TSM Instance I've been searching through IBMs site and the list archives and all I have found on this topic was concerning UNIX. Is it possible to create a second instance of TSM on a Windows 2003 server? Guillaume Gilbert Storage Architect Storage Group, Sun Microsystems [EMAIL PROTECTED] 514.866.8876 Office 514.290.6526 Cell -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Rhodes Sent: November 28, 2006 09:18 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Second TSM Instance When we recently started with multiple instances (on aix),, I implemented it by creating a directory for the each instance that contains the instance specific files. /tsmdata/tsminstance/config I then created a soft link on the dsmserv binary to dsmserv_tsminstance in the normal tsm bin dir. This way a ps -ef | grep dsm shows the symlink name. In the config dir are scripts to start/stop the instance. Here is the start script for our instance TSM1.The actual tsm log and db are on raw volumes. The dsmserv.opt and instance is setup to put volhist, dev config, accnt log, etc, etc in the same directory. fe-bkup3:/tsmdata/tsm1/config==cat rc.start_tsm1.ksh #!/bin/ksh # Set the language # export LANG=en_US # # Max out size of data area # ulimit -d unlimited # # Allow the server to pack shared memory segments # export EXTSHM=ON # setup to run tsmlm2 cd /tsmdata/tsm1/config export PATH=${PATH}:/usr/tivoli/tsm/server/bin export DSMSERV_DIR=/usr/tivoli/tsm/server/bin export DSMSERV_CONFIG=/tsmdata/tsm1/config/dsmserv.opt export DSMSERV_ACCOUNTING_DIR=/tsmdata/tsm1/config # # Start the server in quiet mode. # print $(date '+%D %T') Starting Tivoli Storage Manager Server nohup dsmserv_tsm1quiet fe-bkup3:/tsmdata/tsm1/config==cat kill_tsm1.ksh #!/bin/ksh kill $(cat /tsmdata/tsm1/config/adsmserv.lock | awk '{print $4}') fe-bkup3:/tsmdata/tsm1/config==cat kill9_tsm1.ksh #!/bin/ksh kill -9 $(cat /tsmdata/tsm1/config/adsmserv.lock | awk '{print $4}') Bernaldo de Quiros, Iban 1 iban.bernaldodeq To [EMAIL PROTECTED]ADSM-L@VM.MARIST.EDU Sent by: ADSM:cc Dist Stor Manager Subject [EMAIL PROTECTED] Second TSM Instance .EDU 11/28/2006 06:03 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU
Re: [SPAM: 4.000] [ADSM-L] Litigation!
Orin There are a number of different ways of achieving this and the best method will probably depend on your environment. It may be that a combination of methods may suit for you. You can generate a backupset of the active data using the command 'generate backupset'. For further info, do 'help generate backupset' or take a look at the server reference manual. The main benefit is that it is stored and managed as a single object. You may wish to use this method to get a 'snapshot' of the baclient data for the exchange server. It saves on objects in the DB. Backupsets don't work for TDP data, therefore I would create a new node. Give it a recognisable name, something like Exchsvr_Litigation_15Nov06 Change the TDP nodename in the dsm.opt file to this temp nodename and perform a manual backup of the exchange db. This does assume that you have a window big enough in the evening to run a manual before the scheduled or that you can run a manual full during the day. Providing that you do not backup to this node again, the backup will always be active and never expire. If you are really concerned about expiration, set the retention values that you associate to the new node to no limit. You may also want to take the precaution of marking the tape(s) that the data is written to as read-only and also setting the read-only switch physically on the tapes. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Orin Rehorst Sent: 16 November 2006 14:05 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] Litigation! Yipes, we have pending litigation and an E-discovery. I've been told to freeze our TDP for Exchange backups. How do you do dat? The backups roll off. (Just keeping one backup may be good enough.) Regards, Orin Orin Rehorst
Re: [SPAM: 4.000] [ADSM-L] TSM V5.2, 5.3 IE 7 question
Charles I found that IE7 is virtually unusable with TSM as a WEB GUI. I did raise a speculative call with IBM regarding it. TSM 5.2.x.x goes end of support February 2007, so IBM said there would be no further modifications made to enable use with IE7. TSM 5.3 is not actually supported with the WEB GUI. The special adaptation that IBM made to enable a WEB GUI interface with v5.3 was purely designed 'as-is' with no support offered. Command Line, Admin Centre or browser other than IE7 are your only options. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lamb, Charles P. Sent: 15 November 2006 17:27 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] TSM V5.2, 5.3 IE 7 question Hi.. Has anyone had problems with IE 7 and TSM V5.2 storage manager?? What was the resolution used to fix any problems with IE 7 besides not using IE 7?? Same question about TSM V5.3 since we will be upgrading to TSM V5.3 in February 2007. Tnx's a bunch for your input
Re: Library not recognised - URGENT
Sujay What is the make and model of the new library and what version of TSM server are you running. Have you checked that the version of server you have supports your new library ? For Instance, the new IBM TS3310 is only supported a TSM versions 5.2.7.x and 5.3.2.x and above. Support matrix can be found at http://www-306.ibm.com/software/sysmgmt/products/support/IBM_TSM_Support ed_Devices_for_AIXHPSUNWIN.html Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Sujay Dinakar R. Sent: 14 November 2006 13:37 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 14.000] [ADSM-L] Library not recognised - URGENT Dear All, Recently our IBL 3581 L17 Library is replaced with new one. after connecting the new library Tivoli is not able to recognise the library. Library status is Unknown it says Library intialization failed lb2.0.0.3 we had changed the SCSI ID of the library and tried, the library is defining correctly, where as the define path is giving I/O error. ***Log from the server 11/14/2006 13:07:57 ANR2017I Administrator ADMIN issued command: DEFINE LIBRARY lb4.0.0.3 libtype=scsi 11/14/2006 13:07:57 ANR8400I Library LB4.0.0.3 defined. 11/14/2006 13:07:57 ANR2017I Administrator ADMIN issued command: DEFINE PATH TSMSERVER lb4.0.0.3 srctype=server desttype=library device=lb4.0.0.3 11/14/2006 13:08:17 ANR8840E Unable to open device LB4.0.0.3 with error -1. 11/14/2006 13:08:17 ANR8418E DEFINE PATH: An I/O error occurred while accessing library LB4.0.0.3. 11/14/2006 13:08:17 ANR2017I Administrator ADMIN issued command: ROLLBACK Please any one guide me what should i do?? my entire backup is down??? Regards Sujay Dinakar .R
Re: Sloooow Restore
I think you probably need to adopt a process of elimination. Firstly, you say that it backs up at 8MBps. You don't mention whether you have 100fdx or GB NIC, but at 100fdx this throughput is OK. Next, are you restoring back to the same server that you have backed up from. If so, this more or less eliminates your target h/w and network settings (apart from the overhead of writing to disk as opposed to reading) If you are restoring back to different h/w then as previously mentioned, check the NIC settings and network. Perhaps perform FTP of a largish file(s) from target server to TSM server. So, assuming you are restoring back to the same H/W from whence your backup was taken, I now assume that your backup was going to diskpool and not exceeding the maxsize threshold of storagepool. If so, why not try to move nodedata from the primary pool tape to the primary pool disk. Make sure you don't have the migration threshold set low. Check the throughput of the move nodedata and then attempt the restore from the diskpool. If thoughput is improved from disk, then try to force the restore from a different drive to eliminate drive from equation. Also run cleaning tape through drive. Attempt move data from primary tape to different tape to eliminate specific tape issue. Have you noticed issues with your migration to tape throughput lately. I guess the key thing is to determine whether you have an across the board throughput issue with your tape operations, or it is indeed localised to this 1 TDP restore. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Orin Rehorst Sent: 03 November 2006 13:56 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] Slw Restore TDP for Exchange backs up at 8 MB per second. It restores at 8 MB in 56 seconds! What may be wrong? Environment: OS Win2003, TSM 5.3.2, IBM tape library 3583 LTO 1. TIA Orin Rehorst
Sloooow Restore
Orin, OK, so it's not the same box. I would still try a move nodedata to a disk storage pool for the purpose of eliminating the tape and drive performance. Depending on the occupancy of the TDP node, this could take some time. I assume that you have installed the same version of Baclient and TDP on the temp restore box and that you have copied the opt files and the tdpexc.conf to this box. If you have accepted the default configuration settings regards performance, you may want to revisit these, also you may want to adapt them to suit the resources of this temp h/w (although your problem seems more fundamental than this) Lastly, did you have compression set on the TDP for the backup. When restoring back, the temp machine will need to use CPU resource to uncompress the data. If it is an old machine of low spec it will labour. Do you have compression set on the target NTFS filesystem? Version of Exchange ? Version Baclient? Version of TDP? Leigh
Re: [SPAM: 6.200] [ADSM-L] Command to find the list of all TSM services installed
ps -ef | grep dsm different flavours may vary (use the man page for 'ps' to verify the switches that you require. Leigh -Original Message-o From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: 30 October 2006 09:53 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 6.200] [ADSM-L] Command to find the list of all TSM services installed Hi, The command 'dsmcutil list' gives the list of all TSM services installed **Similarly, could anyone let me know the command equivalent in Unix??? Regards, Srinath G This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies.
Re: Tape TTL
There was some discussion recently about saving the output of your daily actlogs as text files and keeping them (ad infinitum). If you utilise your OS textual search tools to find the message 'ANR8337' or 'ANR8468' along with the volume name, this will give you and accurate value for the number of times that the volume has been mounted/dismounted. Of course, you need to have been keeping your activity logs to start with for this to be of any use. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: 18 October 2006 15:42 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] Re: [ADSM-L] Tape TTL -Paul Zarnowski wrote: - I have long wished that TSM could track statistics for scratch volumes as well. I wonder why they can't track these statistics in the libvol record instead of the volume record. There would still be significant coverage limitations with this approach. Volumes in manual libraries have no libvol records. Volumes ejected from automatic libraries lose their libvol records. Many sites eject copy pool volumes, and some sites even ejectsome of their primary pool volumes.
Re: tsm not recognizing tape unit
This has been somewhat intriguing. With Windows TSM servers post 5.2 and with only IBM devices attached I have always left the TSM device driver set to manual and I have never had the need to start it. However, from the previous postings, it seems that this is not the consensus. I have gone back over the 5.2 and 5.3 Admin Guides and neither appears to be clear about the right configuration. We currently have 2 x W2K servers with IBM LTO devices attached (LTO1 LTO3 in a 3584 library). One server is 5.2 and one is 5.3. I have found that if I change the TSM device driver to start at boot (having to enable Optical Device Support) and then reboot server, all drives are still accessible through TSM. So..from this experience, both appear to work (in my environment). Which method is actually correct, I don't know. However, I would still say that perhaps the problem that Mario is experiencing is rooted somewhere else. I am running with the IBM Tape driver version 6.0.8.2 in both cases and my drives are fiber channel attached via SAN and the f/w version of my LTO3 drives is 5BG4. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thorneycroft, Doug Sent: 11 October 2006 21:10 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 16.000] Re: [ADSM-L] tsm not recognizing tape unit Yes, it does, you also have to enable Windows 2000 and Optical Device Support. This is on a WIN2k Server, Running TSM ver. 5.2 I don't know if it is different on Win2003 or for TSM Ver 5.3, Check the admin guide. The following is copied from the 5.2 admin Guide. Under the heading: Controlling All Devices with the IBM Tivoli Storage Manager Device Driver From the Tivoli Storage Manager Console: 1. From the Tivoli Storage Manager Console, expand the tree to Tivoli Storage Manager Device Driver for the machine that you are configuring. 2. Expand TSM Device Driver and Reports. 3. Click Service Information in the IBM Tivoli Storage Manager Console tree. The Service Information window appears in the right panel. 4. Right click IBM Tivoli Storage Manager Device Driver. A pop-up menu appears. 5. Click Properties in the pop-up menu. The Device Driver Options dialog appears. 6. Click to check the Enable Windows 2000 and Optical Device Support check box. The startup type is set to Boot as a default. 7. Click OK. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Mario Behring Sent: Wednesday, October 11, 2006 12:48 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: tsm not recognizing tape unit No. But, just out of curiosity, is there any difference if it is started at boot time or not ? Mario - Original Message From: Thorneycroft, Doug [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Wednesday, October 11, 2006 4:38:52 PM Subject: Re: tsm not recognizing tape unit Do you have your TSM device driver set to start at boot? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Mario Behring Sent: Wednesday, October 11, 2006 11:58 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: tsm not recognizing tape unit Richard, The device is connected to a SCSI 160 and is being recognized by the SCSI interface during the boot process. Windows 2000 also recognizes the unit. I am updating the firmware and returning the driver to the version you have pointed. The Windows RSM service is disabledbut, what about the TSM Device Driver component? Should I install it? I´ve tried with and without it.some notes at the Admin Guide are saying that I can do either way. Please advise. Mario - Original Message From: Richard van Denzel [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Wednesday, October 11, 2006 4:17:14 AM Subject: Re: tsm not recognizing tape unit Hi Mario, Guessing from your notes, you have ran the install.exe that comes with the driver. The driver you are using is not the latest (6.1.3.8 is). Have you tried using an older driver like 6.0.8.2 (I can e-mail it if you don't have it)? What FW has the LTO3 drive, if not the latest have you tries upgrading the FW on the drive? Is the drive visible on the HBA (Fibre or SCSI) during the BIOS part of the boot process? Is the HBA at a supported FW level? If the HBA is a SCSI-320? If so, have you tried setting it to 160, there is an issue when the drive or library is on a 320 channel. Is the drive visible under W2K? Met vriendelijke groet, with kind regards, Richard van Denzel -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Namens Mario Behring Verzonden: dinsdag 10 oktober 2006 22:45 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] tsm not recognizing tape unit Hi list, I have the following environment: TSM 5.3.2 Server running on a W2K box IBM ULTRIUM III LTO 3580 connected via SCSI I´ve installed the windows certified driver downloaded from the
Re: TSM Device driver is not starting
Mario As the post from Bill alludes to, the TSM device driver is for non-IBM devices, if you only have LTO drives connected, you do not need the TSM device driver started. On my Wintel server with IBM library and LTO drives, it is set to manual and is in a stopped state. If you are still having problems seeing your drives or defining them, then the problem is elsewhere. Check that the IBM Tape driver that you have is at a sufficient level to support LTO3. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mario Behring Sent: 10 October 2006 17:45 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 25.500] Re: [ADSM-L] TSM Device driver is not starting Leigh, The driver installed is the IBM ULTRIUM III 3580 TAPE DRIVE (for Tivoli Storage Manager). Should I uninstall the TSM Device Driver then ?? Thanks. Mario - Original Message From: Leigh Reed [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Tuesday, October 10, 2006 1:31:10 PM Subject: Re: TSM Device driver is not starting Mario You don't mention whether you have already loaded the correct IBM device drivers for LTO3's through Windows device manager, but the below might be of assistance. The way in which the Windows TSM device driver works changed at V5.2. See serwinref.pdf IBM Device Driver for 3570, 3590, and IBM LTO Devices Important: If you currently use 3570, 3590, or IBM LTO devices, you will need to install the IBMTape driver that supports your device. The Tivoli Storage Manager Device Driver will no longer recognize these devices. See the Administrator's Guide for more information and instructions on how to download the drivers and Installation and User Guides. If You need the specific IBM Tape device drivers for Ultrium drives. You can download them from ftp://ftp.software.ibm.com/storage/devdrvr/ Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mario Behring Sent: 10 October 2006 16:54 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 14.000] [ADSM-L] TSM Device driver is not starting Hi list, I have a TSM 5.3.2 Server running on a W2K SP4 with a IBM Ultrium LTO III 3580 connected via SCSI interface. The TSM Device Driver service does not start and I get the following error: The system could not find the device specified Please advise. Thanks Mario
Re: SQL Query for monthly backups
Ian I think that this might to do what you are looking for. select distinct date(backup_date) as backup_date, node_name,hl_name, ll_name from backups where node_name='NODE_MONTHLY' order by Backup_date Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Smith, I (Ian) Sent: 11 October 2006 10:39 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.700] [ADSM-L] SQL Query for monthly backups Hi I am trying to find out all the successful backups for a monthly node - going back for years. I am using the following select: select node_name,hl_name,ll_name,backup_date from backups where node_name='NODE_MONTHLY' order by backup_date Is there anyway to get a DISTINCT on the backup date? So I can just get an idea of dates where backups ocurred, as the above output is just too much. Is there any better way of doing this? _ Ian Smith SAN/TSM Specialist Hitachi Data Systems Certified Professional IBM Tivoli Storage Manager Certified Consultant IT Infrastructure Rabobank International Thames Court, One Queenhithe London EC4V 3RL t: +44 (0)20 7809 3046 f: +44 (0)20 7809 3599 m: +44 (0)7843 689914 Mailto: [EMAIL PROTECTED] _ This email (including any attachments to it) is confidential, legally privileged, subject to copyright and is sent for the personal attention of the intended recipient only. If you have received this email in error, please advise us immediately and delete it. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the viruses in this email or attachments. We exclude any liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided in this email or its attachments, unless that information is subsequently confirmed in writing. If this email contains an offer, that should be considered as an invitation to treat. _
Re: TSM Server Disk Upgrade
Bill, For primary disk STGPOOLS that do not have caching turned on, I would update all the volumes to be read-only, make sure that a backup to copypool has completed and then migrate them down to zero. You can query the content of the volumes afterwards to be doubly sure that they are empty. You can then delete the volumes and redefine them as necessary after your disk upgrade/reorg. If by any chance there is data on them, TSM will tell you. If you have any dirs diskpools that are on areas of disk that will be affected by your reorg/upgrade, I would define new volume(s) that are possibly on local disk/disk unaffected, then mark the vols read-only and perform a move data. For any primary disk stgpools that have caching turned on; if memory serves me correctly the best way to empty them out, is with a move data to the next stg pool (tape pool). Again, mark all the volumes read-only to ensure no new data can be written to them. No data will be moved, but the cached copies will be purged. From help move data When you move files from a random access volume, the server erases any cached copies of files on the volume. For the db log volumes; If you have enough disk spare that will not be affected by your upgrade (ie local disk), you could define db copy volumes on this disk and TSM will synchronise them. This process does take time and you will most certainly experience a performance degradation, but it will ensure TSM stays operational during the disk upgrade. When the sync is complete, you can delete the old volumes. This may not help you reorganise your DB vols, as the db copy vols have to be at least the same size as the originals. When your disk upgrade is finished you can perform the process again and define db copy volumes and sync back. As always with this type of work, I would ensure that at least one good DB backup is performed before commencing the process. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Dourado Sent: 10 October 2006 09:58 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] TSM Server Disk Upgrade Hello, We are planning a disk upgrade mainly to increase the number and size of DISKPOOLS. The upgrade will be carried out by one our Server Administrators; my question is a disk upgrade on a TSM Server different from that of an ordinary server ? OR Will we have to treat the database, logs and diskpools in a special manner? Would disabling caching on the diskpools speed up copying/ghosting , is there a way of making sure the caches are purged ? Any other advice on achieving s successful disk upgrade on a TSM server would be appreciated. TSM Server for Windows 5.2.0.0 Thanks Bill ** This electronic mail message, including any attachments, is a confidential communication exclusively between Babcock International Group PLC or its subsidiary company and the intended recipient(s) indicated as the addressee(s). It contains information which is private and may be proprietary or covered by legal professional privilege. If you receive this message in any form and you are not the intended recipient you must not review, use, disclose or disseminate it. We would be grateful if you could contact the sender upon receipt and in any event you should destroy this message without delay. Anything contained in this message that is not connected with the business of Babcock International Group PLC is neither endorsed by nor is the liability of this company. Babcock International Group PLC Telephone: +44(0)20 7291 5000 Fax: +44(0)20 7291 5055 Website: www.babcock.co.uk **
Re: TSM Device driver is not starting
Mario You don't mention whether you have already loaded the correct IBM device drivers for LTO3's through Windows device manager, but the below might be of assistance. The way in which the Windows TSM device driver works changed at V5.2. See serwinref.pdf IBM Device Driver for 3570, 3590, and IBM LTO Devices Important: If you currently use 3570, 3590, or IBM LTO devices, you will need to install the IBMTape driver that supports your device. The Tivoli Storage Manager Device Driver will no longer recognize these devices. See the Administrator's Guide for more information and instructions on how to download the drivers and Installation and User Guides. If You need the specific IBM Tape device drivers for Ultrium drives. You can download them from ftp://ftp.software.ibm.com/storage/devdrvr/ Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mario Behring Sent: 10 October 2006 16:54 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 14.000] [ADSM-L] TSM Device driver is not starting Hi list, I have a TSM 5.3.2 Server running on a W2K SP4 with a IBM Ultrium LTO III 3580 connected via SCSI interface. The TSM Device Driver service does not start and I get the following error: The system could not find the device specified Please advise. Thanks Mario
Re: [SPAM: 6.200] [ADSM-L] Backup Failures
Srinath, I think that as others have said before, the RC=1914 is a fairly generic SQL Backup API error. More information is required for further help. Depending on how you have structured your scripts for logging, there should be a logfile, either sqlfull.log or sqlincr.log, tdpsql.log, dsierror.log that will give more detailed information than just the RC=1914. Failing that, try a manual log backup of the database and post the output. e.g. From TDP directory tdpsqlc backup Pirate log To give you an idea of the kind of format of error that would be of more help, it might look something like this [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80041070) Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: 05 October 2006 09:46 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 6.200] [ADSM-L] Backup Failures Hi All, I am regularly getting having this schedule failed. When I check the TSM logs, I see the following. These 4 databases fail regularly. Could anyone help out on how to troubleshoot this issue? 10/03/2006 00:08:37 ANE4993E (Session: 3071, Node: GBCWBLEIPSF3-SQL) TDP MSSQL ACO3002 Data Protection for SQL: log backup of database distribution from server GBCWBLEIPSF3 failed, rc = 1914. (SESSION: 3071) 10/03/2006 00:09:24 ANE4993E (Session: 3071, Node: GBCWBLEIPSF3-SQL) TDP MSSQL ACO3002 Data Protection for SQL: log backup of database Pirate from server GBCWBLEIPSF3 failed, rc = 1914. (SESSION: 3071) 10/03/2006 00:09:26 ANE4993E (Session: 3071, Node: GBCWBLEIPSF3-SQL) TDP MSSQL ACO3002 Data Protection for SQL: log backup of database Pirate_Audit from server GBCWBLEIPSF3 failed, rc = 1914. (SESSION: 3071) 10/03/2006 00:09:26 ANE4993E (Session: 3071, Node: GBCWBLEIPSF3-SQL) TDP MSSQL ACO3002 Data Protection for SQL: log backup of database Pirate_Audit from server GBCWBLEIPSF3 failed, rc = 1914. (SESSION: 3071) SCHEDULED_START ACTUAL_START DOMAIN_NAME SCHEDULE_NAME NODE_NAME STATUS RESULT 2006-10-03 12:00:00.00 2006-10-03 12:01:23.00 EXOMSSQL MSSQL_SEV3_LOG GBCWBLEIPSF3-SQL Failed 402 Thanks and Regards Srinath G This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies.
Re: Select Statement Syntax
Joni, Try this and see if it makes any difference, it will manipulate the returned backup_start and backup_end to only be 16 chars and thus loose the .00 I feel sure that there is tidier way to do this, but I have yet to find it. Suggestions gladly appreciated. In the meantime this might help. select node_name,filespace_name, substr(char(backup_start),1,16) as BACKUP_START, substr(char(backup_end),1,16) as BACKUP_END from filespaces where node_name like 'NAS%' or node_name like 'SERVER%' Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: 05 October 2006 14:00 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] Select Statement Syntax Hello Everyone, I have been trying to figure out how to have the syntax of the below output so that it will all go on 1 line, but so far I have been very unsuccessful. Here is the statement I am issuing: select node_name,filespace_name,backup_start,backup_end from filespaces where node_name like 'NAS%' or node_name like 'SERVER%' And here is the output: NODE_NAME FILESPACE_NAME BACKUP_START BACKUP_END -- -- -- -- NAS_SERVER_2_OFFS- / 2006-10-04 2006-10-04 ITE 21:20:32.00 21:23:03.00 NAS_SERVER_2_OFFS- /.etc_common 2006-10-04 2006-10-05 ITE 21:20:32.00 02:34:44.00 NAS_SERVER_2_OFFS- /apache2006-10-04 2006-10-05 ITE 21:20:32.00 02:21:08.00 NAS_SERVER_2_OFFS- /clearcase_prod2006-10-04 2006-10-04 ITE 21:20:32.00 22:36:12.00 As you can see the node_name column wraps. I tried to do a left justify and I also tried to make it 20 characters wide, but I guess I am doing something wrong because I continue to get the same output. I was also wondering if there is a way to change the backup_start to go on 1 line as well and to make it include the date and the time to be just hh:mm:ss? Thank you in advance for any pointers you might have! Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED]
Re: Default Include/Exclude Lists
Rao For Windows specifically open a Windows Baclient command line, type q inclexcl This will list all the details for that specific machine. I think the ones that you are specifically interested are denoted operating system under the source heading. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rao, Kamran Sent: 04 October 2006 16:40 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] Default Include/Exclude Lists Hello, I was just wondering if anyone knows of a place where I can find the latest default include/exclude list for various platforms, specifically for windows nodes. Help would be greatly appreciated. Kamran H. Rao Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient (s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
TDP for SQL Management Classes
Adrian You don't mention whether you are using the same nodename or different. I see that you mention 3 opt files. I think that the key to this is that you must use 3 different nodenames; sql_daily, sql_monthly, sql_yearly. The reason is that if you use the same nodename, the TDP rebinds all previous backups to the MC you specify with the current full. Therefore you won't achieve what you are looking for. Also with the separate nodename approach, I find it easier to manage the schedules, the occupancy and the tapes. If you are looking to see if the backups are in the correct management classes, select * from backups where node_name='sqlservername' and class_name='monthly' If you want to get detail on specific dbs, you can use the hl_name select * from backups where node_name='sqlservername' and class_name='monthly' and hl_name='\master\' Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Compton Sent: 03 October 2006 09:09 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] TDP for SQL Management Classes Hi, I am having problems trying to setup the following and wonder if anyone can shed some light on this or have done so themselves. I am backing up a number of SQL Databases. I am not worried about the sizes, or whuich databases, but only require to do a full backup including any logs. I have a daily schedule running and keep the versions for a week. I want to also have a full backup/archive at month end (keep for 1 year) and also a yearly(keep for 7 years) backups I have setup 3 different sql.cmd files i.e Daily, monthly and yearly, and at the end of each of the include statement in the 3 opt files(also daily, monthly and yearly), put the relevant management classes. Will this provide me with what I am looking to achieve. I am trying to find out where to look to see that the backups have gone to the correct management classes. Any assistance would be most appreciated. Kind regards Adrian Compton
Re: Is it possible to limit what goes into the schedule log?
With the 5.3 baclient, a new parameter was introduced to limit the size of the logs schedlogmax errorlogmax Also, previous parameters pruned the size of the logs in terms of days schedlogretention errorlogretention The juicy nuggets are generally in the dsmerror.log. Using a pattern searching tool like 'grep' or 'find' will ease your trawling through the logs. However, I am not aware of any method to control the verbosity of the dsmsched.log. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Angus Macdonald Sent: 29 September 2006 09:59 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] [ADSM-L] Is it possible to limit what goes into the schedule log? I'm just implementing TSM 5.3. Is it possible to limit what goes into the BA client log file (dsmsched.log)? I really don't need to know every single file that is processed successfully. Exceptions or folders only would be fine. A typical client log is over 100MB a day so I either have to rollover a lot or trawl through a vast mass of irrelevance to get to the juicy nuggets. Angus
Re: Is it possible to limit what goes into the schedule log?
Apologies.I stand corrected. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: 29 September 2006 12:16 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] Re: [ADSM-L] Is it possible to limit what goes into the schedule log? Know thy toolkit... There is a client option called QUIET which eliminates detail, which of course discards information which may be useful in security and problem analysis. Auditors may object to such loss of record-keeping. Richard Sims
Re: [SPAM: 9.000] Re: [ADSM-L] BMR - unlike hardware
I must confess that it has been a while since I have performed a W2K BMR and although I have always just copied back the files post restore for W2K3 BMR's, I had recalled that this was not possible in W2K as some of the files were held exclusively by the OS. However, finding a W2K machine, I can now see that this is not the case and it is definitely far easier to just copy the files back immediately after the restore for both and only use the recovery console/in-place upgrade in the event of a failed boot. I think that in some quarters, Wintel BMR's are seen as a 'fine art' or in some way not standard or excessively problematic. Hopefully Geoff, you will have gained some confidence in that there are many people who have performed a high number of Wintel BMR's without incident. I think there will always be the occasional exception and this would be true of the other platforms and OS's. I still think that performing a DR trial of your business critical Wintel systems on a regular basis gives the greatest piece of mind. One typo in my original posting, it should have read For Windows2003, they are as follows c:\windows\system32\hal.dll c:\windows\system32\ntkrnlpa.exe c:\windows\system32\ntoskrnl.exe Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of TSM_User Sent: 28 September 2006 02:09 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 9.000] Re: [ADSM-L] BMR - unlike hardware While the recovery console could be used you can also choose to copy the files out, perform the restore and then copy the files back before you reboot. You only need to use the RC if you forget to copy the files back before you reboot. I've posted the use of the in-place upgrade many times to ensure the new hardware on the new server is properly enumerated. Still, I always use the approach of copying out the files and then back in after the restore first. With windows 2000 I've found this works about 80% of the time, with Windows 2003 almost 95% of the time. For the time when it doesn't work the in-place upgrade does. For that process you do not have to use the RC at all to copy any files first. Kyle Leigh Reed [EMAIL PROTECTED] wrote: Geoff In my mind, the MS Recovery Console is the key to achieving successful restores back to dissimilar h/w in the Wintel area. After installing your vanilla MS OS (that is to be restored over), you need to take a copy of the OS files that are specific to your h/w. Then, if they are overwritten with different versions by your restore, you can put them back with the RC upon reboot. These files can be found in Device Manager-- Computer and then under the driver details of the Properties of your processor(s). For Windows2000, they are as follows c:\winnt\system32\hal.dll c:\winnt\system32\kernel32.dll c:\winnt\system32\ntdll.dll c:\winnt\system32\ntkrnlpa.exe c:\winnt\system32\ntoskrnl.exe c:\winnt\system32\win32k.sys c:\winnt\system32\winsrv.dll For Windows2003, they are as follows c:\windows\system32\hal.dll c:\winnt\system32\ntkrnlpa.exe c:\winnt\system32\ntoskrnl.exe If after you complete the restore of your system drive and you reboot and get a blue screen or worse, all is not lost. The Microsoft Recovery Console is an extremely useful tool. From the RC, you can copy the above original files from a floppy or the root of the system drive to the system32 directory. Also, the RC will enable you to disable devices or services on boot. One important point to note, the RC requires the LOCAL administrator password to be entered before it can be used, therefore ensure that you know the local passwords to all your machines. The following IBM Technote is also very useful for Wintel system restores http://www-1.ibm.com/support/docview.wss?rs=663context=SSGSG7q1=116481 2uid=swg21164812loc=en_UScs=utf-8lang=en Above all else, the key to restoring back to dissimilar h/w is practice. Where possible, try to trial restore as many of your Wintel systems back to unlike h/w. I know it is obvious, but it is far easier to solve any arising issues in a DR trial environment, than at 3am with somebody looking over your shoulder, asking every 5 minutes when will it be ready ? Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 23 September 2006 00:15 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] Re: [ADSM-L] BMR - unlike hardware What kind of system are you concerned with? I'm looking for some basic info on all platforms anyone has experience with, Windows being the biggest concern. After hearing some remarks this morning in a meeting concerning bringing back a server from scratch, and how long it took, I'm flabbergasted. Then again nobody called me to ask for help either. To add to this are there any issues anyone is aware of for servers that have been virtualized but still use TSM for their backups? Would the process be the same? Thanks, Geoff
Re: BMR - unlike hardware
My original post regarding W2K BMR's was from memory and I recalled for some reason that the system files weren't copied back immediately after the system_object restore. I thought that this was because they were locked/owned by the OS. I checked this morning and realised that this is not the case. However, it may well have been to do with the way W2K replaces files on reboot and Windows File Protection. See posting http://www.mail-archive.com/adsm-l@vm.marist.edu/msg67895.html In the case of W2K3, I think that VSS and System File Protection (SFP) come into play. I also think that the differences in experiences may be accounted for by determining what version of W2K3 was being restored (ie W2K3 initial release or W2K3 SP1/W2K3 R2). The following article probably gives a better explanation. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vss/base/backing_up_and_restoring_system_state_under_vss.asp I still think that with either W2K or W2K3, if you make copies of the system files before restore, you can then copy them back after the system_object or system_state restore. If you encounter problems on reboot, then use MS Recovery Console to copy back your original system files. Finally, if all else fails, attempt an in-place recovery. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Schaub, Steve Sent: 28 September 2006 11:09 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 9.000] Re: [ADSM-L] BMR - unlike hardware This is interesting, since my experience has been that we have had more success with W2K than W2K3 (using the copy-out/restore/copy-back you describe). I always seem to run into a brick wall with the way W2K3 does it's replace-on-reboot for system files being restored. Maybe I'm trying to copy back too early or too late - can you provide some detail on what is working for you? Steve Schaub Systems Engineer, WNI BlueCross BlueShield of Tennessee 423-535-6574 (desk) 423-785-7347 (cell) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of TSM_User Sent: Wednesday, September 27, 2006 9:09 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] BMR - unlike hardware While the recovery console could be used you can also choose to copy the files out, perform the restore and then copy the files back before you reboot. You only need to use the RC if you forget to copy the files back before you reboot. I've posted the use of the in-place upgrade many times to ensure the new hardware on the new server is properly enumerated. Still, I always use the approach of copying out the files and then back in after the restore first. With windows 2000 I've found this works about 80% of the time, with Windows 2003 almost 95% of the time. For the time when it doesn't work the in-place upgrade does. For that process you do not have to use the RC at all to copy any files first. Kyle Leigh Reed [EMAIL PROTECTED] wrote: Geoff In my mind, the MS Recovery Console is the key to achieving successful restores back to dissimilar h/w in the Wintel area. After installing your vanilla MS OS (that is to be restored over), you need to take a copy of the OS files that are specific to your h/w. Then, if they are overwritten with different versions by your restore, you can put them back with the RC upon reboot. These files can be found in Device Manager-- Computer and then under the driver details of the Properties of your processor(s). For Windows2000, they are as follows c:\winnt\system32\hal.dll c:\winnt\system32\kernel32.dll c:\winnt\system32\ntdll.dll c:\winnt\system32\ntkrnlpa.exe c:\winnt\system32\ntoskrnl.exe c:\winnt\system32\win32k.sys c:\winnt\system32\winsrv.dll For Windows2003, they are as follows c:\windows\system32\hal.dll c:\winnt\system32\ntkrnlpa.exe c:\winnt\system32\ntoskrnl.exe If after you complete the restore of your system drive and you reboot and get a blue screen or worse, all is not lost. The Microsoft Recovery Console is an extremely useful tool. From the RC, you can copy the above original files from a floppy or the root of the system drive to the system32 directory. Also, the RC will enable you to disable devices or services on boot. One important point to note, the RC requires the LOCAL administrator password to be entered before it can be used, therefore ensure that you know the local passwords to all your machines. The following IBM Technote is also very useful for Wintel system restores http://www-1.ibm.com/support/docview.wss?rs=663context=SSGSG7q1=116481 2uid=swg21164812loc=en_UScs=utf-8lang=en Above all else, the key to restoring back to dissimilar h/w is practice. Where possible, try to trial restore as many of your Wintel systems back to unlike h/w. I know it is obvious, but it is far easier to solve any arising issues in a DR trial environment, than at 3am with somebody looking over your shoulder, asking every 5 minutes when
Re: BMR - unlike hardware
Geoff In my mind, the MS Recovery Console is the key to achieving successful restores back to dissimilar h/w in the Wintel area. After installing your vanilla MS OS (that is to be restored over), you need to take a copy of the OS files that are specific to your h/w. Then, if they are overwritten with different versions by your restore, you can put them back with the RC upon reboot. These files can be found in Device Manager-- Computer and then under the driver details of the Properties of your processor(s). For Windows2000, they are as follows c:\winnt\system32\hal.dll c:\winnt\system32\kernel32.dll c:\winnt\system32\ntdll.dll c:\winnt\system32\ntkrnlpa.exe c:\winnt\system32\ntoskrnl.exe c:\winnt\system32\win32k.sys c:\winnt\system32\winsrv.dll For Windows2003, they are as follows c:\windows\system32\hal.dll c:\winnt\system32\ntkrnlpa.exe c:\winnt\system32\ntoskrnl.exe If after you complete the restore of your system drive and you reboot and get a blue screen or worse, all is not lost. The Microsoft Recovery Console is an extremely useful tool. From the RC, you can copy the above original files from a floppy or the root of the system drive to the system32 directory. Also, the RC will enable you to disable devices or services on boot. One important point to note, the RC requires the LOCAL administrator password to be entered before it can be used, therefore ensure that you know the local passwords to all your machines. The following IBM Technote is also very useful for Wintel system restores http://www-1.ibm.com/support/docview.wss?rs=663context=SSGSG7q1=116481 2uid=swg21164812loc=en_UScs=utf-8lang=en Above all else, the key to restoring back to dissimilar h/w is practice. Where possible, try to trial restore as many of your Wintel systems back to unlike h/w. I know it is obvious, but it is far easier to solve any arising issues in a DR trial environment, than at 3am with somebody looking over your shoulder, asking every 5 minutes when will it be ready ? Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 23 September 2006 00:15 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.000] Re: [ADSM-L] BMR - unlike hardware What kind of system are you concerned with? I'm looking for some basic info on all platforms anyone has experience with, Windows being the biggest concern. After hearing some remarks this morning in a meeting concerning bringing back a server from scratch, and how long it took, I'm flabbergasted. Then again nobody called me to ask for help either. To add to this are there any issues anyone is aware of for servers that have been virtualized but still use TSM for their backups? Would the process be the same? Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED]
Re: Best Practices DISK for DB, LOG, and STGPOOL JigSaw Puzzle
Bernard If you search for partial page write in the archives, there are many postings covering the pros and cons of the log settings (ie H/W mirror, TSM mirror - Parallel/Sequential) The partial page write scenario is that to which Phillip was referring. As always, there is a trade off between performance and protection. The Admin Guide has a chapter on Protecting and Recovering your Server. Take a look at the part that is called Mirroring the Database and Recovery Log Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bernaldo de Quiros, Iban 1 Sent: 19 September 2006 13:52 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Best Practices DISK for DB, LOG, and STGPOOL JigSaw Puzzle Hi all, Why to use TSM Mirror function for DB and RLOG if this can be supplied by Hardware RAID ¿? Using TSM mirror as far as I know could improve server performance... But is it recommended to have the two phylosophies HW RAID and TSM mirror ¿? Or only one of them... Pro's/Con's or preferences for HW RAID or TSM mirror ¿? Regards, Iban Bernaldo De Quiros Y Marquez Technical Specialist Sun Microsystems, Inc. Serrano Galvache, 56 Madrid 28033 ES Phone +34 91 767 6233 Mobile + 34 659 01 91 12 Email [EMAIL PROTECTED] -Mensaje original- De: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] En nombre de Richard Sims Enviado el: jueves, 14 de septiembre de 2006 17:21 Para: ADSM-L@VM.MARIST.EDU Asunto: Re: [ADSM-L] Best Practices DISK for DB, LOG, and STGPOOL JigSaw Puzzle On Sep 14, 2006, at 10:59 AM, Bernaldo de Quiros, Iban 1 wrote: Hi Richard, There's a lot of great stuff here and good advices !! But I have two last questions... 1-Will you share the same physical disk with database and storage pool ¿? Never mix conflicting access-pattern subsystems in storage areas - that can be as bad as tape and disk on the same I/O path. It is essential that your database be as high-performance as possible, so keep it separate. 2-Will you spread database volumes over the same physical disk or over different physical disks ¿? Or will you make both ¿? In a non-RAID environment, I would spread over physical disks, to the extent reasonable. If very large disks, you may want a few partitions on the disk; but then try to use 15,000 rpm disks. But I prefer using raw logical volumes and hardware RAID 1+0 (striping and mirroring) for best performance. And beyond that there are sophisticated disk subsystems out there which offer further opportunities. Remember that TSM uses one thread per disk volume, so you gain by having a reasonable number of volumes. Look back in the List archives for information posted from the hard- won experiences of other contributors, as there's lots of good advice in our collective efforts. Richard Sims
Solaris library configuration
Margaret I notice that you are running 5.3.3.0. A quick look at the interim fixes for 5.3.3.1-5.3.3.3 in the README.DEVICES showed IC49207 TSM FAILS TO DEFINE THE LIBRARY PATH IN A SPECTRA LOGIC 2K. I appreciate that you mention that you are using a T50, therefore it's not an exact match. Just a thought. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Margaret Clark Sent: 24 August 2006 00:36 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 9.500] [ADSM-L] Solaris library configuration We are trying to configure TSM server 5.3.3.0 on a Sun Solaris 10, using a Spectra Logic T50 tape library with Qlogic SG-XPCI1FC-QF2 HBA and two IBM drives. Following the instructions in Implementing IBM Tape in Unix Systems, we modified the Qlogic adapter configuration file /kernel/drv/qlc.conf to add persistent bindings for the SCSI IDs: hba1-SCSI-target-id-8-fibre-channel-name=21110090a5402218; hba1-SCSI-target-id-9-fibre-channel-name=21130090a5402218; Then we edited /kernel/drv/IBMtape.conf to take out all the boilerplate definitions and add the following: name=IBMtape class=scsi target=8 lun=0 name=IBMtape class=scsi target=8 lun=1 name=IBMtape class=scsi target=9 lun=0 name=IBMtape class=scsi target=9 lun=1 We checked /kernel/drv/st.conf and found targets 8 and 9 were already commented out. Then we rebooted, and had a try at creating a library using the ISC Administration Center. It failed with the following error: The server encountered an I/O error while processing the request. For more information, see the activity log in the server's properties notebook. Additional information from the server: ANR8418E DEFINE PATH: An I/O error occurred while accessing library GWLIB. The activity log showed this: ANR2017I Administrator ADMIN issued command: DEFINE LIBRARY GWLIB libtype=SCSI autolabel=YES shared=NO (SESSION: 135) Aug 23, 2006 4:11:16 PM ANR8400I Library GWLIB defined.(SESSION: 135) Aug 23, 2006 4:11:16 PM ANR1434W No files have been identified for automatically storing device configuration information.(SESSION: 135) Aug 23, 2006 4:11:16 PM ANR2017I Administrator ADMIN issued command: DEFINE PATH GW_BACKUP_SERVER GWLIB srctype=server desttype=library device=/devices/pseudo/[EMAIL PROTECTED]:ibmcontrol (SESSION: 135) Aug 23, 2006 4:11:16 PM ANR8310E An I/O error occurred while accessing library GWLIB.(SESSION: 135) Aug 23, 2006 4:11:16 PM ANR8418E DEFINE PATH: An I/O error occurred while accessing library GWLIB.(SESSION: 135) Aug 23, 2006 4:11:16 PM ANR2017I Administrator ADMIN issued command: DELETE LIBRARY GWLIB (SESSION: 135) Aug 23, 2006 4:11:16 PM ANR8410I Library GWLIB deleted.(SESSION: 135) We tried using /dev/rmt/1lb instead of /devices/pseudo/[EMAIL PROTECTED]:ibmcontrol but it did no good. What are we doing wrong? Some more info: from /var/adm/messages Aug 23 09:25:52 predator genunix: [ID 936769 kern.info] tsalarm0 is /pseudo/[EMAIL PROTECTED] Aug 23 10:02:18 predator scsi: [ID 365881 kern.info] /[EMAIL PROTECTED],60/SUNW,[EMAIL PROTECTED]/[EMAIL PROTECTED],0/[EMAIL PROTECTED],0 (st56): Aug 23 10:02:18 predatorIBM Ultrium Gen 3 LTO Aug 23 10:02:18 predator scsi: [ID 799468 kern.info] st56 at fp0: name w21130090a5402218,0, bus address 10526 Aug 23 10:02:18 predator genunix: [ID 936769 kern.info] st56 is /[EMAIL PROTECTED],60/SUNW,[EMAIL PROTECTED]/[EMAIL PROTECTED],0/[EMAIL PROTECTED],0 Aug 23 10:02:18 predator scsi: [ID 799468 kern.info] sgen0 at fp0: name w21110090a5402218,1, bus address 10426 Aug 23 10:02:18 predator genunix: [ID 936769 kern.info] sgen0 is /[EMAIL PROTECTED],60/SUNW,[EMAIL PROTECTED]/[EMAIL PROTECTED],0/[EMAIL PROTECTED],1 Aug 23 10:02:18 predator scsi: [ID 365881 kern.info] /[EMAIL PROTECTED],60/SUNW,[EMAIL PROTECTED]/[EMAIL PROTECTED],0/[EMAIL PROTECTED],0 (st57): Aug 23 10:02:18 predatorIBM Ultrium Gen 3 LTO Aug 23 10:02:18 predator scsi: [ID 799468 kern.info] st57 at fp0: name w21110090a5402218,0, bus address 10426 Aug 23 10:02:18 predator genunix: [ID 936769 kern.info] st57 is /[EMAIL PROTECTED],60/SUNW,[EMAIL PROTECTED]/[EMAIL PROTECTED],0/[EMAIL PROTECTED],0 from the cfgadm -o show_FCP_dev -al command Ap_Id Type Receptacle Occupant Condition c3 fc-fabricconnectedconfigured unknown c3::210100e08ba4e966 unknown connectedunconfigured unknown c3::210100e08ba4ef25 unknown connectedunconfigured unknown c3::21110090a5402218,0 tape connectedconfigured unknown c3::21110090a5402218,1 med-changer connectedconfigured unknown c3::21130090a5402218,0 tape connectedconfigured unknown c3::500a098c8647b06f unknown connectedunconfigured unknown c3::500a098c8667b2c6 unknown connectedunconfigured unknown ls -al in /dev/rmt drwxr-xr-x 2 root sys 1024 Aug 23 06:07 .
Re: Restore from directory with dots in name
Matthew This APAR might shed some light, although I think it is going to be a case of working as designed. http://www-1.ibm.com/support/docview.wss?uid=swg1IC35332 Your extract from the dsmsched.log might be from the system_object(W2K) / system_state(W2K3) backup, not part of the actual incremental C: drive file backup. Was it in the section between the following Incremental backup of volume '\\lons111013\c$' Successful incremental backup of '\\lons111013\c$' Or before this Successful incremental backup of 'System State' (or system_object w2k). If the entry in the log shows it as part of the system backup, you won't be able to restore it individually. Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Large, M (Matthew) Sent: 23 August 2006 10:58 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.700] [ADSM-L] Restore from directory with dots in name Hi All, I got a request to restore this filename: C:\WINDOWS\SYSVOL\sysvol\eu.rabonet.com\scripts\EUAMS\eu_ams_users.xls But for some reason neither the GUI or the command line recognise any directory deeper than eu.rabonet.com This has been extracted from the dsmsched.log: 08/22/2006 21:27:30 Normal File--36,864 \\lons111013\c$\WINDOWS\SYSVOL\sysvol\eu.rabonet.com\scripts\EUAMS\eu_am s_users.xls [Sent] So it's definitely been processed by the server. Problem is that the GUI won't display any directory deeper than eu.rabonet.com and the command line says there's nothing to restore, even if I state an inactive version of that file. I've opened a call with IBM, but I was just wondering if anyone's seen this behaviour before? Clients are 5.2.4.4 and the TSM server is 5.2.7.1 on W2K3 Thanks, Matthew TSM Consultant ADMIN ITI Rabobank International 1 Queenhithe, London EC4V 3RL 0044 207 809 3665 _ This email (including any attachments to it) is confidential, legally privileged, subject to copyright and is sent for the personal attention of the intended recipient only. If you have received this email in error, please advise us immediately and delete it. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the viruses in this email or attachments. We exclude any liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided in this email or its attachments, unless that information is subsequently confirmed in writing. If this email contains an offer, that should be considered as an invitation to treat. _
Re: Alerting on ANR9999D
Matthew, Using TSM Operational Reporting, under the hourly default monitoring report, we added in a new Variable ANR select count(*) as ANR from actlog where msgno= and date_time between current_timestamp- 1 hour and current_timestamp Then with an active rule if ANR0 then send out an email alert. This will notify you within the hour of an ANR message occurring. You will still have to query the activity log and interpret the message and then determine the action. TSM OR is Windows specific. Unix shell scripts crontab could be used to develop a similar outcome. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Large, M (Matthew) Sent: 14 August 2006 16:24 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Alerting on ANRD Afternoon Richard, Yep, you just confirmed my suspicions. Just had to make sure I wasn't blindly missing another solution (well documented ANRD guide would be a dream..) More training for the OPS! Cheers, Matthew -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: 14 August 2006 13:52 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Alerting on ANRD On Aug 14, 2006, at 6:59 AM, Large, M (Matthew) wrote: ...How do you alert against these unpredictable messages? Good morning, Matthew - Your adjective adeptly summarizes the situation: these messages are unpredictable, being Dignostic messages to provide internals info to allow TSM Support personnel to pursue a fuzzy situation. Once a cause can be nailed down per a solid customer event, the situation can either be resolved and become a footnote in history, or be formalized as a standard message to describe a reasonable thing which may occur from time to time. I would not look for a definitive explanation of an ANRD message, then. In writing an Ops guide, I would expect ANRD messages to be referred to the TSM administrator for pursuit, rather than being handled by an operator, as these messages may indicate issues which go beyond a simple remediation step, and likely need to be pursued with the vendor. Richard Sims _ This email (including any attachments to it) is confidential, legally privileged, subject to copyright and is sent for the personal attention of the intended recipient only. If you have received this email in error, please advise us immediately and delete it. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the viruses in this email or attachments. We exclude any liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided in this email or its attachments, unless that information is subsequently confirmed in writing. If this email contains an offer, that should be considered as an invitation to treat. _
Re: Migrating windows clients to AIX
I was obviously not having a good day yesterday. I got the poster's name wrong and the gist of the question. Apologies Stuart and all. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: 09 August 2006 18:55 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Migrating windows clients to AIX On Wed, 9 Aug 2006 10:19:08 +0100, Pitt, Stuart [EMAIL PROTECTED] said: I have the opportunity of moving all my windows clients to an lpar on a P5. [...] I'm guessing that I can't just export the TSM DB from the windows server and put it on the AIX server. Terms of art are important here: You _can_ export the TSM server to the new arch, using e.g. export server TOSERVER or such. You cannot restore a backed-up database to a different architecture. If you can get the database-export-import process to complete inside your outage window, then all you have left to do is make sure that you can define the libraries and devclasses identically (or 'with identical function') in both environments. This will not be trivial. But if I'm remembering past conversations about this correctly, the data format on stgpool tapes does not change between TSM server architectures. Is there anything else I can try. At the risk of tooting my own horn: http://open-systems.ufl.edu/services/NSAM/whitepapers/50ways.html recorded all the ways I could come up with to move data from one server to another. I'll repeat the encouragement to nitpick about my examples, or add more; last update of the list was some time ago. The list was compiled in the environment of same-architecture transition; the addition of 'appropriate for moving between platforms' decoration to the options would probably be a good idea. Depending on your time pressure, you might be able to use same-arch methods to calve a new TSM server which would exist only to be a smaller chunk, perhaps of a size manageable for export to the P5 instance. For example, split the windows server, and zap every node except the target node from the new one, and then export-import that server, in a timeframe short enough to be acceptable. - Allen S. Rout - Beep.
Re: How I can delete archived directory entries?
Roland I know that it doesn't strictly follow logic, but this works for me del archive filespec -subdir=yes Because of the nature of the command, run a small test in your own environment to ensure that it performs as my env. does. arch testfilespec -subdir=yes q arch testfilespec del arch testfilespec -subdir=yes q arch testfilespec Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of LFD Steinmetz, Roland Sent: 10 August 2006 09:58 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How I can delete archived directory entries? Hi all, With DELETE ARCHIVE ... I can delete archived files entries. How I can delete the first and second archived directory entries? query archive -fromdate=08-08-2006 /* Size Archive Date - TimeFile - Expires on - Description ------ 96 B 08-08-2006 20:07:34/oradata 07-09-2006 ARC_ONLDB_AD030 272 B 08-08-2006 20:07:34/oradata/arch 07-09-2006 ARC_ONLDB_AD030 104,857,088 B 08-08-2006 20:07:42/oradata/arch/1_2764.arc 07-09-2006 ARC_ONLDB_AD030 104,857,088 B 08-08-2006 20:07:54/oradata/arch/1_2765.arc 07-09-2006 ARC_ONLDB_AD030 43,975,168 B 08-08-2006 20:08:04/oradata/arch/1_2766.arc 07-09-2006 ARC_ONLDB_AD030 242,176 B 08-08-2006 20:08:09/oradata/arch/1_2767.arc 07-09-2006 ARC_ONLDB_AD030 Mit freundlichen Grüßen Roland Steinmetz -- Thüringer Landesfinanzdirektion (LFD) Zentrum für Informationsverarbeitung (ZIV) Systemtechnik und Datenbankadministration --
Re: How I can delete archived directory entries?
Roland, I should also have clarified that the description needs to be included to determine which archive you wish to delete. Therefore it should read del arch filespec -subdir=yes -desc=description The testing of this with dummy data still stands. Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of LFD Steinmetz, Roland Sent: 10 August 2006 09:58 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How I can delete archived directory entries? Hi all, With DELETE ARCHIVE ... I can delete archived files entries. How I can delete the first and second archived directory entries? query archive -fromdate=08-08-2006 /* Size Archive Date - TimeFile - Expires on - Description ------ 96 B 08-08-2006 20:07:34/oradata 07-09-2006 ARC_ONLDB_AD030 272 B 08-08-2006 20:07:34/oradata/arch 07-09-2006 ARC_ONLDB_AD030 104,857,088 B 08-08-2006 20:07:42/oradata/arch/1_2764.arc 07-09-2006 ARC_ONLDB_AD030 104,857,088 B 08-08-2006 20:07:54/oradata/arch/1_2765.arc 07-09-2006 ARC_ONLDB_AD030 43,975,168 B 08-08-2006 20:08:04/oradata/arch/1_2766.arc 07-09-2006 ARC_ONLDB_AD030 242,176 B 08-08-2006 20:08:09/oradata/arch/1_2767.arc 07-09-2006 ARC_ONLDB_AD030 Mit freundlichen Grüßen Roland Steinmetz -- Thüringer Landesfinanzdirektion (LFD) Zentrum für Informationsverarbeitung (ZIV) Systemtechnik und Datenbankadministration --
Re: [SPAM: 9.500] [ADSM-L] AW: [ADSM-L] How I can delete archived directory entries?
Roland The syntax of the command in the documentation reads as follows delete archive options filespec The options are then detailed in Table 73 (TSM 5.3 Baunix.pdf) One of the options is subdir. However, a subdir example is not included and it is a little unclear of the exact functionality. I just learned through *careful* trial and error. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of LFD Steinmetz, Roland Sent: 10 August 2006 13:01 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 9.500] [ADSM-L] AW: [ADSM-L] How I can delete archived directory entries? Leigh, Thanks for the answer, i have test and i can delete all archived files and directories with the command 'del arch filespec -subdir=yes -desc=description'. In the documentation for this command i can read: The delete archive command deletes a r c h i v e d f i l e s from Tivoli Storage Manager server storage. ... A connection with directories I can not found.? Roland -Ursprüngliche Nachricht- Von: Leigh Reed [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 10. August 2006 13:38 An: ADSM-L@VM.MARIST.EDU Betreff: Re: [ADSM-L] How I can delete archived directory entries? Roland, I should also have clarified that the description needs to be included to determine which archive you wish to delete. Therefore it should read del arch filespec -subdir=yes -desc=description The testing of this with dummy data still stands. Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of LFD Steinmetz, Roland Sent: 10 August 2006 09:58 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How I can delete archived directory entries? Hi all, With DELETE ARCHIVE ... I can delete archived files entries. How I can delete the first and second archived directory entries? query archive -fromdate=08-08-2006 /* Size Archive Date - TimeFile - Expires on - Description ------ 96 B 08-08-2006 20:07:34/oradata 07-09-2006 ARC_ONLDB_AD030 272 B 08-08-2006 20:07:34/oradata/arch 07-09-2006 ARC_ONLDB_AD030 104,857,088 B 08-08-2006 20:07:42/oradata/arch/1_2764.arc 07-09-2006 ARC_ONLDB_AD030 104,857,088 B 08-08-2006 20:07:54/oradata/arch/1_2765.arc 07-09-2006 ARC_ONLDB_AD030 43,975,168 B 08-08-2006 20:08:04/oradata/arch/1_2766.arc 07-09-2006 ARC_ONLDB_AD030 242,176 B 08-08-2006 20:08:09/oradata/arch/1_2767.arc 07-09-2006 ARC_ONLDB_AD030 Mit freundlichen Grüßen Roland Steinmetz -- Thüringer Landesfinanzdirektion (LFD) Zentrum für Informationsverarbeitung (ZIV) Systemtechnik und Datenbankadministration --
Re: [SPAM: 5.033] [ADSM-L] Migrating windows clients to AIX
Paul, TSM DB backups are OS specific, you will not be able to restore a DB backup from your Windows TSM server to a newly built AIX server. The only way to achieve what you want is as you have said, either through exporting the nodes over a period of time or simply backing up the nodes afresh to the new AIX server and letting the old data on you Windows TSM servers expire. I guess it comes down to the retentions that you have set for your Windows clients and how long you are willing to keep the old Windows TSM architecture in production. For the export route, you used to have to ensure that your export could complete before your next backup, otherwise the incoming backup would create a new filespace denoted 1. Now, IBM have introduced the mergefilespace option that allows you to merge the export into an already existing filespace. As I recall, there were some nasty APARs with this functionality in earlier releases, therefore it might be prudent to check the server version you are running against the fix list and see if there are any known issues with export node mergefilespace=yes. If you go down the export node to server route, I would recommend you have GB network capability on both servers. (normally a given these days I know, but just thought I'd better mention it) Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Pitt, Stuart Sent: 09 August 2006 10:19 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 5.033] [ADSM-L] Migrating windows clients to AIX Hi List, I have the opportunity of moving all my windows clients to an lpar on a P5. We currently backup all windows clients to windows TSM servers. Now what I'm after is how I go about this and move all my data. I'm guessing that I can't just export the TSM DB from the windows server and put it on the AIX server. I know I can do server to server exports, but there's the time involved to do this. I can also just start afresh and let the data expire on the windows servers. Is there anything else I can try. Regards Stuart Pitt, IBM Certified Deployment Professional TSM 5.2 IBM Certified Administrator TSM V 5 Data Management and Implementation RWE npower Trigonos Building Swindon Tel Int 7 322 3253 Tel Ext 01793 893253 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this email is intended only for the use of the intended recipient at the email address to which it has been addressed. If the reader of this message is not an intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination or copying of the message or associated attachments is strictly prohibited. If you have received this email in error, please contact the sender by return email or call 01793 87 and ask for the sender and then delete it immediately from your system.Please note that neither RWE npower nor the sender accepts any responsibility for viruses and it is your responsibility to scan attachments (if any). *
Re: restore directly from copy pool tapes
Just one point of note. upd stgpool stgpoolname acc=unavailable Specifies that **client nodes** cannot access files stored on volumes in the storage pool. ** Server processes can move files within the volumes in the storage pool and can also move or copy files from this storage pool to another storage pool. However, no new writes are permitted to volumes in the storage pool from volumes outside the storage pool.** In a DR, may not strictly be what you want. update vol * wherestgpool=primarytapepoolname access=unavailable Specifies that **neither client nodes nor server** processes can access files stored on the volume. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Large, M (Matthew) Sent: 09 August 2006 16:01 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] restore directly from copy pool tapes Wanda wrote: Look at the parms for the update vol command - All you have to do is enter update vol * wherestgpool=primarytapepoolname access=unavailable (or DESTROYED) update vol * wherestgpool=copypoolname access=readonly I find it much easier to just update the storage pool Tsm: upd stgpool stgpoolname acc=reado Just a thought.. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: 09 August 2006 15:55 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] restore directly from copy pool tapes Easy as pie. When you restore the TSM data base, it wil show that your primary tape pool tapes are still readwrite, and your offsite tapes are offsite. But, your primary pool tapes are actually burned up, and your copypool tapes have presumably been retrieved from your vault and are now at your recovery site. Look at the parms for the update vol command - All you have to do is enter update vol * wherestgpool=primarytapepoolname access=unavailable (or DESTROYED) update vol * wherestgpool=copypoolname access=readonly Now check your copypool tapes into your library (if you have one at your recovery site), status=PRIVATE. When you start a restore on one of your clients, TSM checks to see what tape is needed. When it sees the primarypool tape is marked UNAVAILABLE, it will automatically switch over and mount the copypool tape instead. The gotcha: At your offsite location, your tape drives may not have the same /dev/rmtx names they did at your primary location. BUT, when you reload your TSM data base, the drive path definitions get reloaded as well. So you may have a bit of patching to do before you can start your restores. Wanda Prather I/O, I/O, It's all about I/O -(me) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Hammersley Sent: Wednesday, August 09, 2006 10:40 AM To: ADSM-L@VM.MARIST.EDU Subject: restore directly from copy pool tapes I'm working on a disaster recovery scenario where our TSM server (AIX) and tape library (3584)that has 90 LTO tapes in tape pools is destroyed and several other servers are destroyed. We have approx. 85 copy pool tapes off site. Our thought is to recreate the TSM server via mksysb, restore the TSM database, etc. Then get several of our critical other systems up and restore their data by using the copy pool tapes and then recreate the tapes in the tape pools in the tape library. How does one set up the recreated TSM server so that it does not think that the tape pool tapes are in the tape library ? How does one restore from copy pool tapes ? Are we going about this in a realistic way ? Thank you. Richard _ This email (including any attachments to it) is confidential, legally privileged, subject to copyright and is sent for the personal attention of the intended recipient only. If you have received this email in error, please advise us immediately and delete it. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the viruses in this email or attachments. We exclude any liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided in this email or its attachments, unless that information is subsequently confirmed in writing. If this email contains an offer, that should be considered as an invitation to treat. _
Re: TSM monitoring
I have used custom Perl scripts, ServerGraph and TSM Operational Reporting. Custom Perl Scripts Are obviously very flexible and given the Perl knowledge and time (neither of which I have great deal of), you can get them to do almost anything. I did also use some of the Perl scripting developed by Richard Sims for the accounting report. You can find it at http://people.bu.edu/rbs/adsm-report ServerGraph I found this to be a very good management tool. You do need a little bit of expertise to get it all set up, although I haven't used the Windows version. I found the development team very willing to accommodate new ideas and incorporate them into future releases. I would say that the product is higher end and is reflected in the price. TSM Operational Reporting In my view, a much underrated tool. It's free, that is, it comes with TSM. Only runs on windows, so you may need a separate server if your TSM server(s) are Unix. Functionality is limited to really only SQL queries, but with a little practice and some ingenuity, you can squeeze a little extra out of it. It comes with a number of standard reports and they can give you a feel for how the product works. From there on, you can start to tailor your own reports/monitors. I've never used TSM Manager, but it seems from the posts that it's popular. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 02 August 2006 17:53 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM monitoring I'm curious what folks are using to monitor TSM and send alerts for missed and failed backups. Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Re: Need help with Bare Metal backup/restore
Ila I find that this Technote is the best overview for BMR of the Windows variety. It covers the process with and without ASR. http://www-1.ibm.com/support/docview.wss?rs=663context=SSGSG7q1=116481 2uid=swg21164812loc=en_UScs=utf-8lang=en Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ila Patel Sent: 03 August 2006 16:06 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Need help with Bare Metal backup/restore Can anyone please tell me if it possible to do a bare metal backup/restore of windows XP from incremental nightly backups? Enduser makes change weekly. beside ASR. Ila
Re: [SPAM: 4.300] [ADSM-L] TSM server crash
Paul A search of the IBM website with the error, returns the following Technote http://www-1.ibm.com/support/docview.wss?uid=swg21241015 It's not strictly related to IBM Director, but you never know. I have had problems with Anti-Virus s/w kernel stack settings in the past, however, again not strictly the scenario that you have. You may have to disable the anti-virus service in Recovery Console, which will allow you to boot and then you can change the registry setting. http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2002071208532048?OpenDocumentExpandSection=2Src=w Hope this is of some use. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dudley Sent: 26 July 2006 12:07 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.300] [ADSM-L] TSM server crash I wonder if anyone else has had a similar issue... We have a TSM server (5.2) running on a Windows 2000 server. This runs on an IBM x346 hardware. This server also has IBM Storage Management software on it which has been happily running on there for around a year. Today I also installed IBM Director on this server. To complete the installation we have to reboot the server. Upon reboot the server now crashes just as it finishes starting up Windows with unexpected_kernel_mode_trap on the blue screen of death... If we boot up the server in safe mode it boots up OK however we cannot get any TSM services to run, and it won't let me un-install IBM Director. We took all the hard disks out of this x346 and put them in another x346 to boot up but the same error occurred. As we can see the TSM data storage disks (the D and the E drive) when we boot up in safe mode we would rather not blow everything away by re-installing Windows and having to recreate TSM from scratch and restore all the data from the tapes. I realise that this is mainly a Windows issue now, but if anyone else was in a similar situation with their TSM server I would like to know if you were able to get around it. Thanks Paul  Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: Newbie questions - File locations
Gary For windows based servers, the server scripts - if you mean the TSM command scripts. They are stored in the TSM database, therefore not ordinarily** accessible outside of TSM. (ie located in a Windows directory file structure) To view the server scripts, run the following from the TSM server command line. Query script f=d (q scr f=d)detailed format Query script f=l(q scr f=l) line format, probably more useful If you are familiar with the select statements; Select * from scripts **However, you can also output the script to a text file using the following command query script test format=raw outputfile=c:\tsmscripts\test.txt Conversely, you can create a script in TSM from a text file define script test file=c:\tsmscripts\test.txt For the drives that are being backed up, from a TSM command prompt; query filespace * (q fil *) Again, if you are familiar with select statements, the following will give you a list of the NTFS filespaces (drives). select node_name,filespace_name from filespaces where filespace_type='NTFS' The include/excludes are a little more difficult. To my knowledge there is no central repository. The only method I am aware of is to visit each server and investigate the dsm.opt file or the inclexcl file, as specified in the dsm.opt. One last point, as a large number of the posters are stateside, you may find replies will be scarce (today) as it is July 4th, Independence Day. Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Matthews, Gary Sent: 04 July 2006 09:47 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Newbie questions - File locations Hi, New to TSM ( but learning - picking up bits slowly from this list :-) ) , looking after a W2K3 system that was set up by someone else. Trying to collate some data that's hasn't been documented anywhere, and was hoping you guys could help. 1) Where are the server scripts kept? 2) Drives being backed up and include/excludes have not been documented - I know you can check through the GUI on each client but where are these selections kept? Are they in easily accessible files? TIA Gary This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
Re: Help Configure Exclude Command
Gidi As per your example and assuming that the directory structure is a date and the date format is mmdd Exclude.dir M:\Manam\200[0-5][0,1][0-9][0-3][0-9] This will exclude 2000-2005. Change the first value in square brackets to read [2-5] if you want to exclude 2002-2005 as in your example. Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gideon Brown Sent: 04 July 2006 14:29 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Help Configure Exclude Command Hi All! I need to exclude thousands of directories starting :2002,2003,2004,2005 (Example:M:\Manam\20040505) in a win3k client, so that i'll state only to first 4 chars. Can anyone write me the correct syntax? Many Thanks! Gidi Gideon Brown Sytem Administrator 03-5319085,052-8395641 [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. **1**1***
Re: Help Configure Exclude Command
Gidi Thinking about it again and actually re-reading your original request, I have probably over complicated things, although what I gave you will ensure that you only exclude directories that explicitly match the mmdd format. But nevertheless, it should give you a feel for the syntax. What you are probably looking for is something a little more like this; as per your example. Exclude.dir M:\manam\200[2-5]* N.B. This will also exclude the directory M:\manam\2002must_be_backed_up This could be an issue. It is always good policy to be as explicit with your excludes as possible. The classic example is setting up a home directory for a temp and calling their home directory temp, but having a high level global exclude for directories called temp. Especially, if the temp is filling in as PA for the finance director. Obviously, I am speaking from an experience of a friend, not myself you understand! Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gideon Brown Sent: 04 July 2006 14:29 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Help Configure Exclude Command Hi All! I need to exclude thousands of directories starting :2002,2003,2004,2005 (Example:M:\Manam\20040505) in a win3k client, so that i'll state only to first 4 chars. Can anyone write me the correct syntax? Many Thanks! Gidi Gideon Brown Sytem Administrator 03-5319085,052-8395641 [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. **1**1***
Re: TSM Server on Sol 10
Sam If using Solaris10, take a look at the following on the IBM website IC49092: TSM SERVER WILL CRASH ON START UNDER SOLARIS 10 WITH LATEST SUN PATCH INSTALLED. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Sam Sheppard Sent: 21 June 2006 19:41 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Server on Sol 10 Top of message -- 06-21-06 11:40 S.SHEPPARD (SHS)Re: [ADSM-L] TSM Server o Ah yes. That's the place. Thanks much. Sam ---` Top of message -- 06-21-06 11:23 ..NETMAIL () Re: [ADSM-L] TSM Server o Date: Wed, 21 Jun 2006 14:22:18 -0400 From: Richard Sims [EMAIL PROTECTED] Subject: Re: [ADSM-L] TSM Server on Solaris 10? To: ADSM-L@VM.MARIST.EDU _Top_of_Message_ Use the TSM Support Page, http://www.ibm.com/software/sysmgmt/products/support/ IBMTivoliStorageManager.html and click on Server requirements and there select Solaris, and be pleased. Richard Sims On Jun 21, 2006, at 2:09 PM, Sam Sheppard wrote: We are about to install a new TSM 5.3 server on a Solaris 10 box. Documentation in the install guide says nothing about Solaris 10, only that Solaris 8 or 9 is required. My assumption is that 10 will work fine, but I wanted to check of anyone had any insights or gotchas on this installation. Thanks Sam Sheppard San Diego Data Processing Corp. (858)-581-9668 ---`
Re: Delete Backup Data - client version
Cops I have just tried it with the GUI with a 5.3.4.0 client where the data was backed up with the 5.3.4.0 client and I have the same issue as you. The GUI doesn't seem to show inactive directories, and their sub-directories which *should* be available for the option 'delete inactive' or 'delete all' However, using the tried and tested methodology of troubleshooting, I used the command line. The command line does indeed show the inactive objects available for delete UNDER the high level directory structure, but not the directory itself (probably a *feature* and why it doesn't show in the GUI) If your directory was called 'actlogs', then from the TSM command line, type delete backup c:\actlogs\* -deltype=inactive -pick This will show the items, remove the '-pick' and you will delete them I don't need to tell you that using a wild card with this operation could be extremely dangerous if you make a mistake with pathname, so take care. Otherwise you are into DB restore territory. Failing this, raise a PMR with IBM support and wait for the GUI to get fixed. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Copperfield Adams Sent: 21 June 2006 17:39 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Delete Backup Data - client version Hi, I am hoping to use 'Delete Backup Data' function of a 5.3.4 client (Server version 5.2.6.4). I have a large folder (150gb) that was renamed and, consequently backed up again with a different name and the original marked inactive - when this occured the client version was 5.2.3.11. When I browse 'Delete Inactive Objects' I don't see this inactive folder and its contents. Is this because the backup and inactivation was done using a 5.2.x client? Is there another way round this - if I create a management class with 0 value retention won't I need to restore the inactive data in order to rebind it to the new mgmclass? Any help appreciated. This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Any views or opinions presented or expressed are those of the author(s) and may not necessarily represent those of the Company or of any WWAV Rapp Collins Group Company and no representation is given nor liability accepted for the accuracy or completeness of any information contained in this email unless expressly stated to the contrary. If you are not the intended recipient or have received this e-mail in error, you may not use, disseminate, forward, print or copy it, but please notify the sender that you have received it in error. Whilst we have taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses, we cannot accept liability for any damage sustained as a result of software viruses and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer systems may be viewed by other company personnel and agents. Registered Office: 1 Riverside, Manbre Road, London W6 9WA This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs.
Re: Files stuck in disk stgpool
Roger Just a thought. What about the MAXNUMMP parameter on the node. Setting it to zero. My initial thoughts were that it would be counter productive for restores, in that, you would not be able to mount a tape for a restore operation. However, a help UPD NODE, shows the following A value of zero specifies that a node cannot acquire any mount point for a client data store operation. The MAXNUMMP value is not evaluated or enforced during client data read operations such as restore, retrieve, and HSM recall. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Deschner Sent: 05 June 2006 16:50 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Files stuck in disk stgpool I'm looking for a strategy to attack a strange problem of stuck files and failing migration. In one heirarchy, I have a file size limit of 10g for the disk storage pool, and also a limit of 10g for the tape pool it migrates to. The idea is to prevent a client backup session from ever mounting a tape directly, which is very inefficient. We are using client compression. There exists a client somewhere, who has a 9.99gb file that is of a type that is already compressed (a jpeg photo, or a zip file, for instance). The server compares its 9.99gb size to the 10gb limit, and says OK, back it up, and it comes down the wire into the disk storage pool. However, when it arrives, it has grown by being recompressed, so that now it is larger than 10gb. Now it's stuck in the disk stgpool, and cannot be migrated to tape. Migration processes repeatedly fail and are restarted. Things grind to a halt. This has now happened twice. My only fix is to temporarily raise the tape pool's limit to get the stuck file migrated. However, this could allow a client backup session to mount a tape. Anybody got any better ideas? Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED]
Re: the MACRO command, but on the server?
Jim, I'm not sure if I get exactly what you want to achieve, but can you use the CMD option of the MOVE DRM command. If you do HELP MOVE DRM and take a look at the CMD option, you may find that TSM has already catered for what you are trying to do. HTH Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jim Zajkowski Sent: 30 May 2006 15:26 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] the MACRO command, but on the server? Hey folks, Is there a way to have TSM execute a command file, but one stored on the server? Here's what I'm trying to do: I want to be able to do a MOVE DRM from my desktop (where I have dsmadmc running locally), have it generate the checkin script, and then execute that script. The reason is that we're using named private volumes for our offsites, but scratch tapes for our db backups, and I want to issue the correct checkin status. Why not just execute dsmadmc on the server? I could, and I probably will, but I'm eventually planning on constructing a click-and-drool applet to make this easier for my other admins when I'm on vacation, and I prefer location independence -- the app may run on a different box entirely. Any ideas? --Jim
Re: [SPAM: 3.700] Re: [ADSM-L] Select Statements
One other reference point that I have used, apart from all the excellent previous suggestions, is the TSM Operational Reporting (if you run it). Drill down through Reports--Operational Reports--Custom Report. Select the Properties of the Custom Report and then settings. This will show a large number of very useful select statements. They are mostly for monitoring/reporting purposes, but I found them useful in coming to terms with the constructs and syntax. Also good for getting to understand substr and cast. The actual raw text files with all the select commands are macro files .mac and the path is as follows; C:\Program Files\Tivoli\TSM\console Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Laura Mastandrea Sent: 25 May 2006 21:09 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 3.700] Re: [ADSM-L] Select Statements Where do you get the syntax information for the select statement? i.e. substr , etc. Thank you. To ADSM-L@VM.MARIST.EDU cc From Sent by Leigh Reed [EMAIL PROTECTED] on 05/25/2006 05:04 AM ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Subject Re: [ADSM-L] Select Statements Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Roger I recently had to query the summary table for info regarding the database backups. My requirement was to report how long the database backups were taking. I found that the following select query sufficed. select substr(char(end_time-start_time),3,8) as backup_duration from summary where activity='FULL_DBBACKUP' I know this is not exactly what you are asking, but from the construct, you should be able alter it to do exactly the things you require. Also, the following query will return all the fields that are available for database backups in the summary table select * from summary where activity='FULL_DBBACKUP' HTH Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: 24 May 2006 21:24 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select Statements Hi, I am new to the this list and need some advice. I am trying to create a select statement I can run to monitor the Database Backups of our TSM Servers. I know there are fields in the SUMMARY portion of the table that has Start Time, End Time, Activity, Entity, Volume Name and Successful fields, but I am not sure as to how to put all this together in a nice script that can email to a group of individuals the status. I am not sure if I need to query several parts of the database in order to compile this info or not. Can anyone help me out? Thank You, Roger DISCLAIMER: This communication, along with any documents, files or attachments, is intended only for the use of the addressee and may contain legally privileged and confidential information. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of any information contained in or attached to this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately and destroy the original communication and its attachments without reading, printing or saving in any manner. This communication does not form any contractual obligation on behalf of the sender or, the sender's employer, or the employer's parent company, affiliates or subsidiaries.
TSM Server on W2K3 and MS KB913409
I have just found a MS Knowledge base article relating to an issue where programs that allocate a large block of contiguous memory in Microsoft Windows Server 2003 fail to start or fail intermittently. For example, a program that allocates a 1.5-gigabyte (GB) block of memory when the program starts or after it starts. This strikes me as a good fit for database buffers with TSM. There is an MS hotfix available and the full fix will be released in SP2 later in the year. I was just wondering if anybody who is running TSM and W2K3 has encountered this error. If so, was the hotfix successful ? It is possible that I may have to implement a W2K3 TSM server in the near future and may not be able to wait for SP2 release (if MS achieve target date). Thanks Leigh
Re: Select Statements
Roger I recently had to query the summary table for info regarding the database backups. My requirement was to report how long the database backups were taking. I found that the following select query sufficed. select substr(char(end_time-start_time),3,8) as backup_duration from summary where activity='FULL_DBBACKUP' I know this is not exactly what you are asking, but from the construct, you should be able alter it to do exactly the things you require. Also, the following query will return all the fields that are available for database backups in the summary table select * from summary where activity='FULL_DBBACKUP' HTH Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: 24 May 2006 21:24 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select Statements Hi, I am new to the this list and need some advice. I am trying to create a select statement I can run to monitor the Database Backups of our TSM Servers. I know there are fields in the SUMMARY portion of the table that has Start Time, End Time, Activity, Entity, Volume Name and Successful fields, but I am not sure as to how to put all this together in a nice script that can email to a group of individuals the status. I am not sure if I need to query several parts of the database in order to compile this info or not. Can anyone help me out? Thank You, Roger
Re: Select Statements
select * from volhistory where type='BACKUPFULL' and date_time(current_timestamp-1 day) You can use 'hour' instead of 'day' to get further granularity -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: 25 May 2006 17:24 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select Statements Thank You Sandeep, I made changes since some of the fields didn't work for me, but this is what I have: SELECT DATE_TIME AS DATE,TYPE,VOLUME_NAME,LOCATION FROM VOLHISTORY WHERE TYPE='BACKUPFULL' But, what I would like to do is pull just the last or most current BACKUPFULL or BACKUPINCR information. I have been looking for some sort of a CURRENT TIMESTAMP or something on those lines? Is there something I can add to get this info? Rog On May 25, 2006, at 3:19 AM, Sandeep Jain wrote: Hi, You can use below select statement to view the full db backup details. SELECT DATE_TIME AS DATE TIME,TYPE,BACKUP_SERIES,VOLUME_NAME FROM VOLHISTORY WHERE TYPE='BACKUPFULL' REPLACE 'BACKUPFULL' WITH 'BACKUPINCR' IF YOU TAKE INCREMENTAL BACKUP With Best Regards, Sandeep Jain ** Legal Disclaimer *** * ** This email may contain confidential and privileged material for the sole use of the intended recipient. Any unauthorized review, use or distribution by others is strictly prohibited. If you have received the message in error, please advise the sender by reply email and delete the message. Thank you. *** * * -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: Thursday, May 25, 2006 1:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select Statements Hi, I am new to the this list and need some advice. I am trying to create a select statement I can run to monitor the Database Backups of our TSM Servers. I know there are fields in the SUMMARY portion of the table that has Start Time, End Time, Activity, Entity, Volume Name and Successful fields, but I am not sure as to how to put all this together in a nice script that can email to a group of individuals the status. I am not sure if I need to query several parts of the database in order to compile this info or not. Can anyone help me out? Thank You, Roger This email has been scanned for any virus infection at the sending end.
Re: Domino Backups
Geoff I believe that the purpose of the incremental schedule for Domino backups is to 'catch' any new db's (.nsf files) that have been created since the last Full backup or to backup any db's whose DBIID has changed. Certain Domino functions cause the DBIID to change and the outcome of these functions warrant a backup of that particular db. Compaction or compression is such a function. Therefore I would say that a node doing an incremental to a new server with no previous backups, would treat all the db's as new and a Full backup would occur. Would it be possible to export the node from the current server to the new server on the day of the migration. Obviously if the occupancy is considerably large, it may not be achievable in a day. It might be possible to export only the active data. Thus giving the new server a copy of all the db's and negating the need for a full, but also minimising the amount of data on the new server. I must admit to never having tried the export node allactive with a domino filespace before, but I have no reason to believe that it would not operate any differently. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 02 May 2006 05:16 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Domino Backups I was wondering if someone could answer this that has knowledge having done something similar. The scenario is a Domino server does a full backup of all DB's on Sunday. Sometime during the week the node will be migrated to now back up to a new TSM server. The next schedule is actually an Incremental. Will it really be doing a FULL since it has never backed up to this server or will it really do a small incremental? I'm trying to avoid a manual full if it doesn't need it. We do want a full for all DB's so we don't have a full on one system and incrementals on another. Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Re: TSM BA client on Exchange 4-way cluster hangs
Wanda, I don't have experience with this exact configuration, but in the past anti-virus s/w has caused me problems on clusters. Obviously, the local A/V sw is not a problem as it only occurs when you bring the exchange resources online to the node. However, you might have specific Exchange related AV resources coming across. Your system administrators may not be keen to do this, if the box is live, but you could try to take any AV cluster resources offline and see if this solves the problem. Just a thought. Regards the clusternode setting, it does not need to be set to yes for the local backup and the 5.3.3.0 client will actually give you an error saying that it will not allow you to backup the local drives with clusternode yes. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: 25 April 2006 21:29 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM BA client on Exchange 4-way cluster hangs Windows 2003, Exchange 2003, 4-node cluster, 3 active 1 passive. BAclient 5.3.2.2. TDP For Exchange NOT installed yet. Have installed the Windows baclient, trying to get a backup of the C: drive and system state before we start installing the TDP for Exchange and all the appropriate schedulers. On NODE4 (the passive node), got the baclient installed and backed up the C: drive. Then used the cluster admin app to move Exchange resources from one of the other nodes to NODE4. Now the Baclient won't open. Just hangs at the splash screen with msg initializing. Domain is C:, E;, SYSTEM SERVICES, SYSTEM STATE. A reboot clears things up. But once the resources get moved back to NODE4, same result - GUI hangs. (And this is the baclient, not the TDP client) Results are the same whether I have CLUSTERNODE YES in the dsm.opt file or not. (Is CLUSTERNODE YES required for the client instance that is to back up the local resources only?) Any hints? No error messages, eventually have to kill the process with Task Manager.
Re: 3584 library: problems with some trays
Did anybody get a resolution to this problem. We are looking to upgrade the firmware on our 3584 to 5770, but I am concerned that we may suffer from the problems people have described with this thread. I raised a call with IBM and they have come back with the fact that it may be to do with a barcode scanner that has been installed upside down. Solution is to ensure that the barcode scanner is installed correctly. I'm not exactly sure why the upgrade to firmware 5770 exposes this incorrect installation and that previous to this, it has not been a problem. Has anybody else received the same advice and did it solve the issue of 'loosing' slots. Thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Durkee Sent: 22 March 2006 15:55 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] 3584 library: problems with some trays just a guess from memory, ce and cleaning cartridge locations? [EMAIL PROTECTED] 03/20/06 02:18PM Hi there, Some time ago we experienced a power failure that lasted long enough to make us shut down our 3584 library. This was done gracefully, and when the power came back we turned the library back on. The TSM server was also gracefully shut down and turned back on. After TSM came back, I did an AUDIT LIBRARY which exited with a failure; two tapes which TSM thought were in the library, weren't (according to the library) so TSM took them out of its inventory. The strange thing was that the tapes were indeed in the library. Some investigation revealed that the library was somehow blind to tapes in the last row of the first and second column, but this only happened after a library initialization due to a powerup or open/close of the entire front door. This happens with every tape I tried, so the labels aren't the problem. A tape which is perfectly well recognized in any slot doesn't show up in the lowest slot in column 1 and 2. The library doesn't detect anything there, it'll also let you move a tape to a full slot using the control panel. Of course, this results in an error (94 80: slot unexpectedly full). IBM is already on this, and it's no big problem because I can easily work around it by leaving the first row almost completely empty. This results in the problematic slot not to be used, because our tape rotation isn't that high. I was interested if this symptom perhaps looks familiar to someone here. We're on library code 5770, and the TSM symptoms are errors about slots being unexpectedly full and TapeAlerts about the library inventory being inconsistent. Thanks, -- Jurjen Oskam - CONFIDENTIALITY NOTICE: This message is confidential, intended only for the named recipient(s) and may contain information that is privileged, or exempt from disclosure under applicable law. If you are not the intended recipient(s), you are notified that the dissemination, distribution or copying of this message is strictly prohibited. If you receive this message in error, or are not the named recipient(s), please notify the sender by reply e-mail, delete this e-mail from your computer, and destroy any copies in any form immediately. Receipt by anyone other than the named recipient(s) is not a waiver of any attorney-client, work product, or other applicable privilege. This message and all contents may be reviewed by authorized parties of the Catholic Health System other than those named in the message header. The contents of this message do not bind the Catholic Health System to any contract, position, or course of action unless the sender is specifically authorized to enter into contracts on behalf of the Catholic Health System. The contents of this message do not necessarily constitute an official representation of the Catholic Health System.
Re: TS3310 with TSM 5.3.2.0 on W2K3.
Robert, Have you downloaded the IBM Tape drivers. I know that generally, these drivers are only mentioned when in conjunction with LTO tape drives, however they also come with the following files that relate to the medium changers. Ibmcgbs2k3.sys Ibmcg2k3.sys Ibmcgft2k3.sys You can download the zip file from ftp://ftp.software.ibm.com/storage/devdrvr/Windows/Win2003/Latest/ Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Clark Sent: 07 March 2006 04:28 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TS3310 with TSM 5.3.2.0 on W2K3. Has anyone had any luck getting a TS3310 working with TSM 5.3.2.0 on W2K3 EE SP1? When I get to the point that I'm configuring devices on the TSM console, I get error message ANRE2080. Various docs seem to indicate that the TS3310/3576 is supported on 5.3.2.0. It appears that TSM Device Driver doesn't recognize the media changer. Something similar to IC34862. Any ideas? Confidentiality Notice: The content of this communication, along with any attachments, is covered by federal and state law governing electronic communications and may contain confidential and legally privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, use or copying of the information contained herein is strictly prohibited. If you have received this communication in error, please immediately contact us by email at [EMAIL PROTECTED] Thank you
Re: Offsite library via fiber (Specifically VTL)
Wanda I would be intrigued to know your thoughts on why you went specifically with a VTL with TSM and not a more generic 'low cost' disk arrangement with sequential files. It is a decision that I am trying to come to terms with myself and have not yet settled in my mind which I prefer. Apart from price, if you take into consideration ease of management/configuration and performance, what decision making processes did those 2 variables lead you through. Did you go with IBM TS7510 or EMC CDL or a n other ? I guess the last $64M question is, are you happy with the decision you made ? Many thanks Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: 13 February 2006 19:31 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Offsite library via fiber We're doing just that. Easy to set up if your offsite location is within fibre distance. Only we are putting the VTL (primary pool) OFFSITE and the 3584 (copy pool) ONSITE. Why? 1) Tapes jam. Drives break. The 3584 is very reliable, but still mechanical. Easier to have it onsite, near us, to manage. The VTL is essentially lights out, so it will live offsite. 2) IF we have a disaster, having the VTL offsite means we can do DR restores without being limited by the number of tape drives we have. Cool idea, huh? Means we only need 2 drives in our 3584. Collocation tape mounts are no longer an issue. And another cool thing: 3) We're even putting a spare Windows server offsite with the VTL, and making it a backup domain controller. TSM is already installed on it, but inactive. If we have a disaster, all we have to do is restore the TSM DB. We can start restoring files then to any machine we can get IP connectivity to. Our domain is still up, we don't have to recover AD. I can hardly wait for the tornado! Wanda Prather I/O, I/O, It's all about I/O -(me) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman Sent: Friday, February 10, 2006 3:54 PM To: ADSM-L@VM.MARIST.EDU Subject: Offsite library via fiber We're thinking of a TSM upgrade that would include a VTL onsite library and an IBM 3584 library for copy pool tape. We would locate the 3584 in our offsite storage location and access it via fiber. The tapes would remain in the 3584 since they would already be offsite. Anyone have any experience with a setup like this? Daivd Ehresman University of Louisville
Re: Database mirroring, again
I've always been from the many spindles, small disks, JBOD, TSM s/w mirror camp. In the past, I have seen a DB performance increase, by moving the DB architecture to the above configuration. However, like many, I have watched the threads closely and I'm seriously going to consider the RAID0 striping option with my next major implementation. Not sure which way I will be going regards the mirroring (H/W vs S/W). I've been involved in a DB corruption, caused by H/W mirroring and coupled with the fact that the previous DB backup was corrupt, it wasn't pretty. Conversely, I have been through a number of 'unscheduled' server downs, with TSM mirroring and never had a DB corruption. I have been experimenting with a Wintel server and an old Compaq FC RAID array with 12 x 18GB disks and so far the RAID0 option is coming out on top. I appreciate that it's Wintel and Compaq, but the TR budget doesn't stretch. It's certainly a step in the right direction, a Linux TSM install test will be my next move. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: 07 February 2006 03:26 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Database mirroring, again On Mon, 6 Feb 2006 13:07:08 -0600, Roger Deschner [EMAIL PROTECTED] said: Hardware 2x2 SSA RAID10 (2-way striped mirrored pairs), raw volumes, 4 dbvols per virtual RAID volume (hdisk), which is still 2 dbvols per real disk. I think the number volumes/spindle is increasingly irrelevant in the days of multi-GB caches in storage subsystems. My SSA is one thing, a sharkesque gizmo is quite another. There has been some discussion of relative database corruption risk with TSM mirroring versus hardware or OS mirroring. [...] I've been feeling myself change opinion on this, recently. The reliable-storage level here is between the log and the db, no? I think I'll be experimenting with OS- or hardware-level protection the next time we have a DB architecture question. Tho, with the DS6800, it may be a long long LONG time. :) - Allen S. Rout
Re: Database mirroring, again
Mark I totally agree with your logic and in any other environment, hardware mirroring would be a given. However, a few years back, I was involved in a database corruption scenario. An unscheduled outage took down a TSM server. At the time, the database was H/W mirrored with battery backed up cache. A partial page write occurred, that was mirrored to both plexes. When bringing the system back up, TSM deemed the DB to corrupt and a DB restore was required The advice from IBM at the time, was that you should always use TSM s/w mirroring with MIRRORWRITE Sequential. I have carried on adhering to this through the years, however, I would be interested in hearing if this is no longer the case and the partial page write scenario is no longer an issue. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark Stapleton Sent: 07 February 2006 14:22 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Database mirroring, again ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 02/06/2006 01:07:08 PM: I know we've been over this, but times change, and technology changes. Conventional Wisdom on this list has been that the best disk layout for your TSM Database is: JBOD disks, Raw volumes, mirrored by TSM, with 2 dbvols per physical volume. One note about conventional wisdom: *always* mirror with hardware when possible. Hardware mirroring is faster and more stable. (Hardware anything--mirroring, compression, encryption, etc.--is almost always faster and more stable.) The only reason TSM ever contained dbvol and logvol mirroring abilities was to accommodate the ADSM server port to Windows, which at the time had no mirroring capabilities. -- Mark Stapleton ([EMAIL PROTECTED]) US Bank Backup and Recovery Management Office 262.790.3190 -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. ==
Re: TSM Database Size Growing Since Upgrading to 5.2.4.5
It's just a shot in the dark, but the last time this kind of thing started happening, W2K system objects weren't being expired correctly and it was these filespace occupancies that were clearly increasing the db and storage. I say 'clearly', it only really became evident after 6 months. I'm not at this level of code, so can't check and I would hope that I am wrong and the bug hasn't been reintroduced, but it is something to look at and check off the list as not being the problem. May want to check W2K3 system state and system services also. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Cowen Sent: 25 January 2006 19:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Database Size Growing Since Upgrading to 5.2.4.5 Graph your occupancy (num_files) by domain for each server and see if it shows uniform growth. If not, drill down to node occupancies (num_files), and so on. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Carlson Sent: Wednesday, January 25, 2006 2:39 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Database Size Growing Since Upgrading to 5.2.4.5 I might have thought that too if it wasn't all 3 instances. I graphed my database sizes back to 2004 (I have them in a mysql database), and it is striking the growth curve since 11/12/2005. Jack Coats wrote: No unusual new clients being added? Retaining more data? Change of include/exclude files? ... Just grasping for straws... -Original Message- Subject: [ADSM-L] TSM Database Size Growing Since Upgrading to 5.2.4.5 On November 11th, we upgraded our 3 tsm instances from 5.2.1 to 5.2.4.5. Since then, our three databases have grown at an alarming rate. They have grown: 56GB to 75GB (33%, 19Gb growth) 46GB to 65GB (41%, 19Gb growth) 53GB to 63GB (18%, 10Gb growth) Anyone have problems like this? Thanks. Privileged and Confidential: The information contained in this e-mail message is intended only for the personal and confidential use of the intended recipient(s). If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. SPECIAL NOTICE All information transmitted hereby is intended only for the use of the addressee(s) named above and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of confidential and privileged information is prohibited. If the reader of this message is not the intended recipient(s) or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that you must not read this transmission and that disclosure, copying, printing, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED. Anyone who receives confidential and privileged information in error should notify us immediately by telephone and mail the original message to us at the above address and destroy all copies. To the extent any portion of this communication contains public information, no such restrictions apply to that information. (gate02)
Re: System object restore problem
Thomas I'm not sure that you can actually do this. While from a high level logical view, you might think that the steps that you are taking will work; however, all BMR's that I have performed, especially in the Windows environment, I would always restore back to a target machine that has an identical name and I think that any Windows BMR documentation would always allude to this also. My guess is that you have a need to give the machine a different name because you are restoring it on your live network. Obviously in a full DR test or real DR, the original machine would not be visable and therefore you can give the target machine for the restore, the actual name. For DR tests, I find it useful to have a dedicated DR restore VLAN. You can then firewall/traffic filter this VLAN from your live prod VLANs. You only need enable port 1500 outbound from the VLAN (or what ever port you have configured for TSM data access). This enables you to give the identical machine names to the servers you are restoring and also ensures that when the restore is complete, they don't interfere with your live prod servers. Failing this, if you have a spare NIC in your TSM server, create a restore LAN segment from this. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: 24 January 2006 21:25 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] System object restore problem We just went through a disaster recovery test, using the following process for each Windows 2000 system involved: 1.Give the replacement system a different computer name than its production counterpart. 2.Execute a 'rename node' command against the recreated TSM database to change the node name matching the production computer name to a node name matching the replacement system computer name. 3.Execute 'rename filespace' commands to make the corresponding changes to computer names embedded in UNC volume names. 4.Restore the C drive. 5.Restore the system object. 6.Restore the remaining drives. At step 5 the attempt to restore the system object finished almost instantly, with no data movement. This was true whether the GUI or the command line client was used. The 'query systemobject' claimed that there were no matching files. I called IBM and was told that a system object cannot be restored to a system with a different computer name than the system that backed up the system object. We were using 5.2.6.0 server code under mainframe Linux. We were, in most cases, installing 5.3.2.0 client code on the replacement Windows systems (one Windows administrator tried the 5.1.5.0 client code and got the same results). Some of the original production systems had been running 5.3.2.0 client code, and some had been using lower client levels. Several of the Windows administrators confirmed my recollection that the process described above had been used successfully at our previous disaster recovery test 14 months earlier. We are then using 5.2.2.0 server code and a variety of 5.1 and 5.2 client code levels. This raises a number of questions: 1.Why did our test recovery process stop working? 2.Is there any way to get the process to start working again? 3.Nearly every book or article about disaster recovery emphasizes the importance of testing. Why did Tivoli introduce a restriction that seems to have been designed to make disaster recovery testing nearly impossible?
Re: System object restore problem
Thomas, One other thing. You mention that you have actually managed to complete this method successfully with 5.1.x.x and 5.2.x.x code. Bear in mind that there were a number of bugs with the early levels of code regarding the backup of W2K system objects. So while it may have worked for you, there may have been underlying problems for others, which have subsequently been solved, but unfortunately have scuppered your internal DR procedures. I really think that your only option is to build a dedicated restore LAN segment and then use the original machine names for the Windows BMRs. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: 24 January 2006 21:25 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] System object restore problem We just went through a disaster recovery test, using the following process for each Windows 2000 system involved: 1.Give the replacement system a different computer name than its production counterpart. 2.Execute a 'rename node' command against the recreated TSM database to change the node name matching the production computer name to a node name matching the replacement system computer name. 3.Execute 'rename filespace' commands to make the corresponding changes to computer names embedded in UNC volume names. 4.Restore the C drive. 5.Restore the system object. 6.Restore the remaining drives. At step 5 the attempt to restore the system object finished almost instantly, with no data movement. This was true whether the GUI or the command line client was used. The 'query systemobject' claimed that there were no matching files. I called IBM and was told that a system object cannot be restored to a system with a different computer name than the system that backed up the system object. We were using 5.2.6.0 server code under mainframe Linux. We were, in most cases, installing 5.3.2.0 client code on the replacement Windows systems (one Windows administrator tried the 5.1.5.0 client code and got the same results). Some of the original production systems had been running 5.3.2.0 client code, and some had been using lower client levels. Several of the Windows administrators confirmed my recollection that the process described above had been used successfully at our previous disaster recovery test 14 months earlier. We are then using 5.2.2.0 server code and a variety of 5.1 and 5.2 client code levels. This raises a number of questions: 1.Why did our test recovery process stop working? 2.Is there any way to get the process to start working again? 3.Nearly every book or article about disaster recovery emphasizes the importance of testing. Why did Tivoli introduce a restriction that seems to have been designed to make disaster recovery testing nearly impossible?
Re: Exchange restore slowdown
Steve, It's a shot in the dark, but did you see Del Hoobler's posting regarding the slowdown in backup performance of TDP Exchange when you apply TSM 5.3 client/API code. You don't mention your client code level and I appreciate that the posting related to backup performance, but I thought it might be worth a shout. http://msgs.adsm.org/cgi-bin/get/adsm0512/204.html Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Schaub, Steve Sent: 24 January 2006 21:58 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Exchange restore slowdown Environment: 5.2.2.0 TSM server on AIX using 3592 tape ESS disk. TDP 5.2.1.0 on Exchange 2003 server running as a vm under ESX 2.5.2 We have several corrupted mailboxes in the 2 stores on a particular Exchange server. We are trying to restore to a recovery group on a different server, where we will then use export and merge to piece the affected users back to health. What is happening is that we get the first 8-9GB (compressed figure) within half an hour, but then the restore slows to a crawl - it has been running for 4.5 hours now and is only up to 14.7GB (guessing we have around 22GB total to restore). The same tape has been mounted the entire time, there is no other process running to conflict, the TSM server and the recovery server are both underutilized in terms of cpu/memory/network. Has anyone ever seen this type of behavior or have a suggestion where I can look next to try to find the bottleneck? did I mention that this store is the one used by the execs? nuff said on that. Steve Schaub Systems Engineer, WNI BlueCross BlueShield of Tennessee 423-752-6574 (desk) 423-785-7347 (cell) Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: ANR1639I
Is the machine part of a cluster ? This can happen when the cluster fails over and the cluster node connects to the TSM server with a new active node and hence a new IP address and GUID. I have also seen this with multi-honed machines. Ie more than one NIC. Sometimes, if the routing has changed and the node has established a connection through a different NIC and hence a different IP address. Failing this, somebody could have established a connection to the TSM server using the nodename KULDB21P but not from the machine that is normally associated with the nodename KULDB21P. I find that the above happens when somebody copies the dsm.opt/dsm.sys file from another machine but forgets to change the nodename. HTH Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dksh Cssc Sent: 11 January 2006 05:03 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] ANR1639I Hi all, 1. Could anyone enligthen me the attributes of some of the nodes that were changed automatically without human intervention? 2. Checked from the TSM messages information that this message will not bring any harm but would like to know why it happened and what are the things that could affect it from happening? 01/11/06 10:10:54 ANR1639I Attributes changed for node KULDB21P: TCP Address from to 10.208.14.26. (SESSION: 249836) This message repeated for a few days, not only on this particular node but other nodes also. Thanks and Warmest Regards,
Re: restore speed question
Alex I hate restores that don't go as fast as I want them to, especially when it's 3 o'clock in the morning, so I'll have a stab at what might be wrong. The nature of your problem does seem very intermittent and the fact that some times you do achieve an acceptable speed makes it difficult. Firstly, I think you need to know what primary pool tapes your data is across. As Troy mentioned, if you are not collocating (or collocating by group), then the data is going to be spread across a large number of tapes. Even if you are collocating (all data on one tape), remember that you are restoring the active data only, the tape will contain all the previous and deleted versions (depending upon your backup copy group parameters). During the restore, the tape will have to skip between these; while this is happening, your aggregate network performance will decrease, as nothing is being restored. The following command will list the primary volumes that the node data is across select volume_name from volumeusage where node_name='xxx' and copy_type='backup' and stgpool_name='PRIMARY_TAPE_POOL' group by volume_name If this returns a large number of tapes, then you have 2 options available to you. Use a 'multi-thread' restore, by increasing the resourceutilization setting in the client dsm.opt file and also increasing the MAXNUMMP parameter. This will enable you to restore multiple tapes concurrently (depending on the number of drives that you have available). Please note that multi-threading only works with No Query Restores. The second option is as Troy alluded to with a MOVE NODEDATA, but if memory servers me right, the elusive 'Active only' switch is still not available, therefore the tape restore will still have to skip through the data that is not active. If all of the above is completely evident to you, then we are back to the old favourite; try FTP'ing a large directory of files from the TSM server to the target restore server, this should test out your network and filesystem performance. The only other suggestion would be to take a look at what your TSM server is doing at the time of the restore. - are you doing the restore at night when a large number of backups are occurring - is expiration running at the time of the restore - during the restore, keep issuing 'q sess' commands and see if the restore is 'clocking up' recw, sendw, commw time. One other thing I have just remembered, if you are doing a full BMR and you have restored the OS first and rebooted, your restored OS may have virus scanning enabled and if it is set to scan on write, when you restore the remaining drive(s), every file will be scanned before it is written, this will definitely slow down your restore. Task manager should show the virus scanner chewing up CPU. HTH Merry Xmas One and All. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Alexander Lazarevich Sent: 21 December 2005 19:47 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] restore speed question TSM server 5.3.1 on 2K server. Libraries are one Overland Neo 4100 with 2 LTO2 drives, and an Overland Neo 4100 with 2 LTO3 drives. I'm restoring a windows client workspace. Client is running TSM backup client version 5.3.0. Originally, the client was 5.1.9.0, and it was with this version that we first created the backup of the workspace drive on the client. Now I'm trying to restore that workspace filespace to the new system. The restore started fine, 30MB+/sec in our GigE network. But at times the restore speed slows to a halt, and restore speeds are less than 1MB/sec, sometimes only 200-300K/sec. Then a little later it will start to go 30MB/sec again. It is switching back and forth, sometimes in the middle of a file! The server is currently trying to restore an 86MB file, but it's doing so only at 300K/sec. Being that the workspace is 244GB, this is unacceptable speed. The client data is on the LTO2 library. There is absolutely nothing unusal in the logs that would indicate any kind of problem on the drive or the tape. No errors are being reported whatsoever. The client filespace is NOT compressed on the client side. Compression happens on the drives (HP). The client hardware is excellent, dual AMD opteron, with 3G SATA drives in striped RAID, XP Pro. Plus the client at times restores at 30+MB/sec so I know it can do it. Network on the client is not busy, and the network switch is not saturated, in fact there is very little network activity. It just seems like the server decides to go fast at times and then sometimes very slow. But with nothing in the logs I don't know what to troubleshoot. Any idea where to start troubleshooting this problem? Anyone seen this type of behavior before? Thanks! Alex
Re: restore speed question
Sorry Alex, I understand the deal now. I have restored SQL and Exchange databases from LTO tape to NTFS filesystems (of similar size to same filesystem) and also monitored the IP network throughput and FC throughput during this operation. I have found the performance to be uniform across the duration. As Richard has stated, you are into elimination territory now. Previous to Richard's post, I was going to suggest checking LTO drive firmware and seeing if there was any known bugs in your release, or moving the data from the current tape to another, to eliminate that specific piece of media. However, as Richard suggested, moving the data to disk and then restoring from disk, takes the tape drives right out of the equation and moves the focus straight onto the network/target machine disk filesystem. I know you have clarified the situation, but just so I'm sure the 32GB file that you are restoring is a single 32GB NTFS file, your not restoring a TSM image or backupset. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Alexander Lazarevich Sent: 22 December 2005 13:09 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] restore speed question Thanks for the responses all, but it's not a tape mounting issue. I wasn't clear enough in my original post, but I am watching the actlog while the restore is taking place, and I'm sitting next to the library, so I can tell when it's doing anything: remounting, rewinding, etc. What I'm saying is this: The server is restoring a single 32GB file, and starts doing so at 30+MB/sec. At some point, DURING the restore of that SAME 32GB file, the server suddenly slows down the restore, to 200-300K/sec. The server has NOT switched tapes, and is NOT rewinding even the SAME tape. It is still restoring that same 32GB file, but suddenly does so at a slower speed. I know the drives have some kind of burst speed and normal speed. Maybe something is wacked out with that function? Any other ideas? Alex On Thu, 22 Dec 2005, Leigh Reed wrote: Alex I hate restores that don't go as fast as I want them to, especially when it's 3 o'clock in the morning, so I'll have a stab at what might be wrong. The nature of your problem does seem very intermittent and the fact that some times you do achieve an acceptable speed makes it difficult. Firstly, I think you need to know what primary pool tapes your data is across. As Troy mentioned, if you are not collocating (or collocating by group), then the data is going to be spread across a large number of tapes. Even if you are collocating (all data on one tape), remember that you are restoring the active data only, the tape will contain all the previous and deleted versions (depending upon your backup copy group parameters). During the restore, the tape will have to skip between these; while this is happening, your aggregate network performance will decrease, as nothing is being restored. The following command will list the primary volumes that the node data is across select volume_name from volumeusage where node_name='xxx' and copy_type='backup' and stgpool_name='PRIMARY_TAPE_POOL' group by volume_name If this returns a large number of tapes, then you have 2 options available to you. Use a 'multi-thread' restore, by increasing the resourceutilization setting in the client dsm.opt file and also increasing the MAXNUMMP parameter. This will enable you to restore multiple tapes concurrently (depending on the number of drives that you have available). Please note that multi-threading only works with No Query Restores. The second option is as Troy alluded to with a MOVE NODEDATA, but if memory servers me right, the elusive 'Active only' switch is still not available, therefore the tape restore will still have to skip through the data that is not active. If all of the above is completely evident to you, then we are back to the old favourite; try FTP'ing a large directory of files from the TSM server to the target restore server, this should test out your network and filesystem performance. The only other suggestion would be to take a look at what your TSM server is doing at the time of the restore. - are you doing the restore at night when a large number of backups are occurring - is expiration running at the time of the restore - during the restore, keep issuing 'q sess' commands and see if the restore is 'clocking up' recw, sendw, commw time. One other thing I have just remembered, if you are doing a full BMR and you have restored the OS first and rebooted, your restored OS may have virus scanning enabled and if it is set to scan on write, when you restore the remaining drive(s), every file will be scanned before it is written, this will definitely slow down your restore. Task manager should show the virus scanner chewing up CPU. HTH Merry Xmas One and All. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL
Re: [SPAM: 4.815] [ADSM-L] TDP FOR SQL DATABASES 5.2
Laura You say that LAN free is not an option, therefore you are restoring over your IP network. Firstly, can you confirm that you have a GB NIC in your TSM server and GB NIC in your target restore SQL server. My maths is not the best but with basic rough calculations at 100M bits/sec, you get approx 10MBytes/sec. That's 600MB per minute and 36GB per hour. Your backup statistics would suggest that you are indeed running at 100Mbits/sec, although I don't know whether you have set compression on the TDP and therefore not sending a full 50GB of SQL data over the network. Generally SQL db's compress fairly well. Other than the network speed the other key thing that prolongs a TDP SQL restore is the formatting of the SQL tablespace, so that it is ready for a restore. This is out of TSM's hands, it is an SQL operation and can take some considerable time. You can verify this by identifying that the restore session goes into a commwait state and stays in this state until SQL confirms that the area to which the restore is destined has been formatted and is ready to accept the restore. You may also need to up your TSM server setting for commtimeout, as if the tablespace format operation takes longer than your commtimeout value, the session will be dropped by the server and the restore will fail. The only way to circumvent this, is if you have the tablespace preformatted by SQL before you issue the restore from the TDP. The 9840B's are not the fastest drives for transferring single large files (19MB/sec native), but 3 of them running concurrently should acheive the performance you are looking for. If you have GB NICs and you also have the tablespace already preformatted, then your next stop would be the target OS CPU utilisation (if the db was compressed at source and hence needs to be uncompressed on the restore) and disk speed. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Laura Mastandrea Sent: 01 December 2005 17:05 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 4.815] [ADSM-L] TDP FOR SQL DATABASES 5.2 We have been evaluating this product and have not been able to achieve the necessary performance throughput on the restores we require. I'd like to know if anyone else out there is successfully using this product. Environment: AIX 5.2 and TSM Server 5.2.4.2 6 STK 9840 B tape drives, but we always backup directly to a 1 TB disk pool Windows 2003 TSM client 5.3.0.8 SQL Server 2000 SP3 Test database 50 GB Backup times are 42 minutes and restore times are 73 minutes with 6 stripes. Our production databases will be 3 to 4 times bigger than this test database. The TSM buffer is 4096. The node is non-collocated, but we have tried with collocated. The best we could do was get the migration from disk to stripe across 3 volumes. IBM's recommendation is to go LAN free, but that is not an option at this point. Thank you. DISCLAIMER: This communication, along with any documents, files or attachments, is intended only for the use of the addressee and may contain legally privileged and confidential information. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of any information contained in or attached to this communication is strictly prohibited. If you have received this message in error, please notify the sender immediately and destroy the original communication and its attachments without reading, printing or saving in any manner. This communication does not form any contractual obligation on behalf of the sender or, the sender's employer, or the employer's parent company, affiliates or subsidiaries.
Re: TSM Bmr ??
I agree with everything that has been said so far and the performance posting regarding Christie BMR was impressive. However, I'm not sure whether I'd want to shell out the cost per server, however good the results/efficiency. While TSM is not strictly designed to BMR Windows systems back to different hardware, I have used it successfully, on many occasions, to accomplish this. The IBM technote, previously mentioned does contain most of what is required, but for me, when restoring to dis-similar hardware, I would always take a copy (to floppy) of the following files, pre-restore. W2K C:\%systemroot%\system32\hal.dll C:\%systemroot%\system32\kernel32.dll C:\%systemroot%\system32\ntdll.dll C:\%systemroot%\system32\ntkrnlpa.exe C:\%systemroot%\system32\ntoskrnl.exe C:\%systemroot%\system32\win32k.sys C:\%systemroot%\system32\winsrv.dll W2K3 C:\%systemroot%\system32\hal.dll C:\%systemroot%\system32\ntkrnlpa.exe C:\%systemroot%\system32\ntoskrnl.exe If after the full TSM restore process (as detailed in IBM technote), the machine reboots to a blue screen, then you can use the MS Recovery Console to copy the system files back to the system root from the floppy. Very rarely with some RAID controllers that have additional functionality (failover, redundancy), I have had to disable certain devices/services from booting (again from MS Recovery Console). This has had to be a fairly intuitive process and I would imagine not scriptable in s/w, unless on a case by case basis. The only other point to note is that certain levels of past TSM clients have a bug in them where they incorrectly merge the registry thus overwriting the disk controller driver and not obeying the keys not to restore. See IC38716 You will still have to re-install the NIC drivers, or drivers for other PCI cards/peripherals, but you would hope that the hardware supplier would have these readily available. JMEW Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: 28 November 2005 21:53 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Bmr ?? do you have the link for cristies bmr, and how much is it tim - Original Message - From: Barnhart, Troy [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Monday, November 28, 2005 4:17 PM Subject: Re: TSM Bmr ?? I'm a big fan of the Cristie's BMR for Windows and RedHat Linux. They are pretty slick. I can restore a box from scratch in under 10 minutes. My only caveat for dislike hardware restores is using newer hardware. i.e. their driver support for older hardware. We had problems getting older drivers to work correctly - such as old HP LH3 Netservers. But, with our newer IBM xSeries - very smooth... Regards, Troy Troy Barnhart, Sr. Systems Programmer, [EMAIL PROTECTED] Rapid City Regional Hospital, Rapid City, South Dakota, 57701 ph: 605-719-8068 / fax: 605-719-4206 - Original Message - From: Prather, Wanda [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Monday, November 28, 2005 4:02 PM Subject: Re: TSM Bmr ?? What I meant was, to a different TYPE machine, i.e., disklike hardware, not just a different machine. The Christie Bare Metal add-on product supports restoring Windows to unlike hardware. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: Monday, November 28, 2005 4:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM Bmr ?? you said that windows does not support restoring a registry to a different machine, but isnt that what happens when i follow the instructions in the Disaster Recovery Strategies with TSM pdf. is tsm ever going to support restoring to dislike hardware ? tim - Original Message - From: Prather, Wanda [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Monday, November 28, 2005 3:40 PM Subject: Re: TSM Bmr ?? http://support.microsoft.com/default.aspx?scid=kb;en-us;249694 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: Monday, November 28, 2005 3:37 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM Bmr ?? is there documentation that describes the differences between the same machine after a hard drive failure and restoring to different hardware at a hot site i am attempting the later tim - Original Message - From: Prather, Wanda [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Monday, November 28, 2005 3:26 PM Subject: Re: TSM Bmr ?? IT's not a TSM issue, it's a Windows issue. Microsoft does not support restoring a registry to a different machine. That being said, they used to have a procedure in the knowledge base that you can try. Check there. How you test BMR, depends on what you are trying to do. You need different procedures for different possible disasters; Procedures needed to restore back to the same machine after a hard drive failure, are simpler than the case where you are restoring to different hardware at a hot site.
SQL select for file size
I know that this question has been addressed before, but I just want to check that the situation remains the same with the current releases, or if anybody has come up with a cheeky workaround/better solution. I am looking for a relatively efficient way of finding out how much data in size is stored by TSM for certain files or file types (ie. .mp3 .wav .avi ) I can get a list of the files with select ll_name,hl_name from backups where node_name='XXX' and filespace_id=x and ll_name like'%.MP3%' If I know what volumes the node/filespace resides on, I can get the file size with select node_name,filespace_name,file_name,file_size from contents where volume_name='XXX' Is the file size accurate or is it the size of the aggregate that the file is contained within ? (They all seem a little too rounded for my liking) Also, this is not particularly easy in a non-colocated environment. So, is listing the volumes that the node/filespace is stored on and then selecting from the contents of this list of volumes the only way. And, even if this is scripted, is it accurate or is it just the size of the aggregates. Knowing that the GUI will list the filesize but it doesn't seem readily available from SQL queries is truly a Friday afternoon annoyance. Leigh
Re: Version of 5.2 server and DB question
Farren I echo everything that Troy said in his posting. You appear to be a Sun shop, so I'll give you an idea of what I have done in the past. I have found that it has been beneficial. I have taken a pair of SCSI attached D1000's and populated them with 12 x 9GB ultra2 disks. The D1000's have been EOL for a long time but you can pick them up cheaply from 2nd user brokers. If you're concerned about maintenance, sometimes their so cheap you can buy an additional chassis with 12 disks as a spare. I believe the D2's were the replacement model for the D1000's, but it appears they have gone EOL also. For a ~30GB db area, I would format a 3GB raw partition on 11 of the disks on the outer cyclinders and then define a TSM dbvol for each of the 3GB partitions. I have done the same with the second D1000 and define TSM dbcopy volumes I would then use the 12th disk in each chassis as the log volume (TSM mirrored). OK, you could be restricted to a 9GB log, but if that is a problem then buy an 18GB for the 12th disk. I would try to ensure that they are attached to SCSI controller cards that are on different busses. This whole approach has worked well in the past with E450's V480's and DB sizes ranging from 30GB-50GB. Like Troy says, I'm sure that there are plenty of organisations out there who have just one SAN attached disk system where they have their TSM DB on a RAID5 or RAID0 array and also have their storage pools on another array on the same SAN disk system. The big disk vendors will probably tell you that the latest and greatest SAN controllers with umpteen GB of cache will outperform something as basic as 12 x Ultra SCSI 9GB 10Krpm disks, but I am yet to be convinced (in a TSM DB environment), or maybe I'm just plain cynical. The other benefit to this approach is that if you encounter performance issues, it is easier to pin things down. You're DB is on a separate controller with separate H/W and disk dedicated to it alone. The only downside (IMO) to this approach is that you have to ensure you have an automated alert (SNMP) for disk failures in the cheap disk chassis. You wouldn't want to loose a disk in one of the chassis's without knowing and loose another in the copy in quick succession. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Farren Minns Sent: 17 November 2005 11:29 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Version of 5.2 server and DB question Hi all I'm about to be getting a new server and can at last install TSM 5.2 on Solaris. Is it best to go right up to the latest version of that release (5.2.6.4 I believe)? Also, as I can plan things a bit better on this new server I want to size my DB a bit more efficiently. Now, I know this is an old question with many posts but I couldn't seem to get a concrete answer. My DB is only 14GB and 80% used, so I think I'll allocate 30GB to give me loads of space for growth. So, is it best to have 3*10GB volumes, or 30*1GB etc. Basically should I have more smaller ones, and if so how small is too small? Thanks Farren Minns John Wiley Sons Ltd ## The information contained in this e-mail and any subsequent correspondence is private and confidential and intended solely for the named recipient(s). If you are not a named recipient, you must not copy, distribute, or disseminate the information, open any attachment, or take any action in reliance on it. If you have received the e-mail in error, please notify the sender and delete the e-mail. Any views or opinions expressed in this e-mail are those of the individual sender, unless otherwise stated. Although this e-mail has been scanned for viruses you should rely on your own virus check, as the sender accepts no liability for any damage arising out of any bug or virus infection. ##
Re: Storage pool usage
Richard, What did the accounting log say for the transfer ? I know that you said there was no compression set, but it would be good to know that the results from the accounting log for the session matched that of what was reported in the activity log. You can check the accounting log with the following select bytes,entity,number from summary where entity='nodename' and number=session number Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Mochnaczewski Sent: 17 November 2005 15:57 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Storage pool usage But I never saw any tapes being used by the backup process ? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of David E Ehresman Sent: Thursday, November 17, 2005 10:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Storage pool usage The client sends an estimate of the amount of data it is sending. If a file is calculated to be too big to fit in the 1st storagepool, it is written to the 2ndard stgpool (usually tape) instead. [EMAIL PROTECTED] 11/17/05 10:22 AM Hi *, I have a 300Gb storage pool which I used last night to send a 306Gb Oracle database using RMAN ( no compression on the backup ). I checked the usage of the storage pool after the backup, and it only shows 60% used. However,I checked the activity log and I condfirmed that 306Gb of data was sent to the server and I did a q con on the volumes in the storage pool and all the files are there. Shouldn't the storage pool show 100% used ? No migrations ever happened during the backup the whole time it ran. Shouldn't a migration to tape have kicked off as I had exceeded the storage pool capacity ( we set migration to 100 during the night to not allow migrations unless absolutely necessary ) ? Rich
Re: Strange problem deleting filespaces
Richard, If I am understanding you correctly, you have performed the following Database backup to tape of a TSM server version 5.1.1.0 You have then tried to restore this database backup of a TSM server 5.1.1.0 to a TSM server version 5.2.6.3. This is not supported. You can only restore db backups back to a server of the same release that they came from. You have to upgrade the tsm server from 5.1.1.0 to 5.2.6.3 without doing a db restore. What you could do is the following; On your new system, install 5.1.1.0 and restore the db backup to this and then upgrade this new system from 5.1.1.0 to 5.2.6.3. You can then get a feel for how long the upgrade process will take and also do some testing on the new system to see if you have any issues. Apologies if I have not understood your email correctly and you are indeed doing an upgrade. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard van Denzel Sent: 15 November 2005 15:20 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Strange problem deleting filespaces Hi All, I've got a strange problem when I try do delete old filespaces. The scenario: I've made a backup of the old 5.1.1.0 database. On the new system I installed TSM 5.2.6.3 on the new system and restored the database there. So far so good. To start freshly on all clients we decided to delete all the old filespaces and than this: 11/10/05 13:48:55 ANR2017I Administrator ADMIN issued command: DELETE FILESPACE lima 1 t=any data=any namet=fsid wait=no (SESSION: 2669) 11/10/05 13:48:55 ANR0984I Process 63 for DELETE FILESPACE started in the BACKGROUND at 13:48:55. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:55 ANR0800I DELETE FILESPACE / (fsId=1) for node LIMA started as process 63. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:55 ANR0802I DELETE FILESPACE / (fsId=1) (backup/archive data) for node LIMA started. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:55 ANRD sstxn.c(369): ThreadId19 SS commit prohibited - transaction failed. Callchain of previous message: 0x10016400 outDiagf - 0x102DBD08 ssPrepareTxn - 0x1008F8C0 CollectVotes - 0x1009064C tmEnd - 0x102B0C70 DeleteBackups - 0x102B1904 imFSDeletionThread - 0x10007B80 StartThread - 0xD004B57C _pthread_body - (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:55 ANR1181E sstxn.c(372): Data storage transaction 0:56957 was aborted. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:55 ANR2183W imfsdel.c(1838): Transaction 0:56957 was aborted. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:55 ANR0826I DELETE FILESPACE LIMA for node / encountered a transaction failure. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:55 ANR0827I DELETE FILESPACE / (fsId=1) will be retried for node LIMA. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:55 ANRD sstxn.c(369): ThreadId19 SS commit prohibited - transaction failed. Callchain of previous message: 0x10016400 outDiagf - 0x102DBD08 ssPrepareTxn - 0x1008F8C0 CollectVotes - 0x1009064C tmEnd - 0x102B0C70 DeleteBackups - 0x102B1904 imFSDeletionThread - 0x10007B80 StartThread - 0xD004B57C _pthread_body - (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:55 ANR1181E sstxn.c(372): Data storage transaction 0:56966 was aborted. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:56 ANR2183W imfsdel.c(1838): Transaction 0:56966 was aborted. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:56 ANR0826I DELETE FILESPACE LIMA for node / encountered a transaction failure. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:56 ANR0827I DELETE FILESPACE / (fsId=1) will be retried for node LIMA. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:56 ANRD sstxn.c(369): ThreadId19 SS commit prohibited - transaction failed. Callchain of previous message: 0x10016400 outDiagf - 0x102DBD08 ssPrepareTxn - 0x1008F8C0 CollectVotes - 0x1009064C tmEnd - 0x102B0C70 DeleteBackups - 0x102B1904 imFSDeletionThread - 0x10007B80 StartThread - 0xD004B57C _pthread_body - (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:56 ANR1181E sstxn.c(372): Data storage transaction 0:56973 was aborted. (SESSION: 2669, PROCESS: 63) 11/10/05 13:48:56 ANR2183W imfsdel.c(1838): Transaction 0:56973 was aborted. (SESSION: 2669, PROCESS:
Re: Recovery Log Pinned
Vince, I forgot something else, if it is 2 of your servers illustrating the same behaviour, the offending operation could be a server to server function that you may be running. Leigh -A TSM cowboy with too much time on my hands- -Although if I want to keep getting work, I shouldn't refer to myself as a cowboy- -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Vincent RATAJSZCZAK Sent: 14 November 2005 10:27 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Recovery Log Pinned Hi TSM Cow Boys/Girls I would like to abuse of your busy time. I discover that 2 of my several servers have a recovery Log pinned. I use the TSM/ADSM QuickFacts which point me to IBM site article swg21054574 I'm unable to find this article on the net, neither the IBM site. Someone would be kind enough to send me this article or shortly explain me how to resolve a log pinned, please ? Regards Vince
Re: Recovery Log Pinned
Vince I'm not sure where you got that reference number from, but my bookmarked page of Richard's quick facts gives the following references. IBM Technotes: 1084167; 1105651; 1105830 I have just done a quick check on the IBM website and all 3 of the above are still available. I don't know the full specifics of your problem, but generally a recovery log gets pinned by a long running backup or long running process. If there are other high db transaction processes occurring at the same time, this is where your long starts to fill up and the 'concern' starts to set in. If you have a backup session running over a low bandwidth comms link and it is currently backing up a large file (ie Exchange database), this could pin the log. It could also be a session backing up over a 100Mbps link, but the link is not performing as it should (ie duplex mismatch) and therefore a large file backup is taking considerably longer and thus pinning the log. It could also be a process (migration, reclamation) that is transferring a single large file and it is taking longer than it should. (ie tape problem causing poor tape throughput). The command 'show logpinned' should give you the session id or process id of the offending operation. Cancel the session or process and the log will drop back down to a manageable amount. If you are unable to cancel the session or process, cancel any high db transaction processes that are adding to the log (ie expiration), this could give you breathing space. Lastly, if your log is not at the maximum size, you could consider extending it temporarily to allow the processes/sessions to complete, without the log filling. Hope that this is of some use. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Vincent RATAJSZCZAK Sent: 14 November 2005 10:27 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Recovery Log Pinned Hi TSM Cow Boys/Girls I would like to abuse of your busy time. I discover that 2 of my several servers have a recovery Log pinned. I use the TSM/ADSM QuickFacts which point me to IBM site article swg21054574 I'm unable to find this article on the net, neither the IBM site. Someone would be kind enough to send me this article or shortly explain me how to resolve a log pinned, please ? Regards Vince
Re: TSM database engine
One additional point to the proprietary nature of the database. It is my understanding that a large consideration for the design of the database, is down to TSM's random access storage pools and the ability of the database technology to employ 'bit vectors' to track the location of allocated and free blocks in the random access storage pools. With the growing popularity of sequential disk volumes, it *might* be the case that random access storage pools could be 'phased out' and thus negating the need for bit vectors in the database architecture. At this point, a move to DB2 for the back end db technology could be a real possibility. Please feel free to correct my understanding if it is way off the mark. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: 10 November 2005 21:13 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM database engine My understand is that it is the old DB1 database and pretty much proprietary. I also heard that IBM has (had ?) plans to move to DB2 with V6 (this is speculation, of course). Kurt Beyers [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 11/10/2005 03:48 PM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] TSM database engine Hi, I've just got a question out of curiosity concerning the TSM database: -is it a DB2 database? -is it a modified DB2 database -or is it a complete propietry database -or based on another database engine You should know it as a TSM admin although it is just theoretical knowledge. best regards, Kurt
Re: Oracle RMAN compression ratio
Richard I am assuming that when you say RMAN, you mean RMAN in conjunction with the TDP. The TSM activity log lists the amount of data that RMAN/TDP has *transmitted from* the Oracle database and through the TDP (pre-compression). The accounting log shows the amount of data that was received by the TSM server (post-compression). This should give you your compression ratio. Eg Extract from activity log 07-11-2005 19:09:42 ANE4991I (Session: 8351, Node: ) TDP Oracle NT ANU0599 ANU2535I File \adsmorc\orcnt\bph35taj_1_1 = 8060928 bytes sent Output from the following select command select bytes,entity,number from summary where entity='XX' and number=8351 (Number is the session number gained from the activity log) BYTES ENTITY NUMBER -- --- 8060939 XX 8351 As you can see from my example, the bytes are almost identical, which is correct as we are not compressing this particular Oracle backup at the client end. In your case, you should see that the number of bytes returned by the select command(Post-Compression) will be less than the number of bytes shown by the TDP in the activity log and thus get your compression ratio. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Mochnaczewski Sent: 07 November 2005 20:27 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Oracle RMAN compression ratio Hi Everybody, Is it possible to determine the compression ratio of a database backed up using RMAN to TSM ? I would like to see some stats for the backup size of the database when having compression enabled or disabled on the client. Rich
Re: Problem after time change
Farren There definitely was a client(s) that suffered from this problem and we logged in over the weekend to ensure that none of our current clients suffered from the problem. (To be on the safe side) My recollection was that the clients that suffered were only Windows and the 2 fix patches were as follows Ver 3.7.2.17 Ver 4.1.1.16 Looking at the ftp site, your client (5.2.0.6) was released in early 2003, therefore you would think that through 6 clock changes, albeit only 3 going backwards, somebody would have noticed it if the bug had been re-introduced, even though it may be specific to your config (ie W2K3 and NAS). We have a wide range of version 5 clients in existence and none of them exhibited the bug at the weekend. However, we don't have 5.2.0.6. Maybe it's worth making a support call to IBM. If it's any help, I have pasted the text from the original alert readme from the version 4 client below, it does have some tips on circumvention or workaround. A problem with the switch between Daylight Savings Time (DST) and Standard Time (STD) has just been discovered for the Windows TSM clients. BACKGROUND When Windows NT and 2000 systems automatically switch between DST and STD, the time attributes for files stored on NTFS file systems will be shifted by one hour. This is because NTFS displays time information as an offset from Greenwich Mean Time (GMT). Thus when the DST change is made, the offset from GMT is changed, causing the timestamps on your NTFS files to also change.(Note: Time information for Event Viewer events is affected in the same manner, but that is not pertinent to this discussion.) Further information on this subject is available in the Microsoft Knowledge Base, item Q129574. If you point your web browser to Microsoft's MSDN site, http://msdn.microsoft.com, and search on Q129574 (without the quotes), you will find the information. THE PROBLEM When the system automatically adjusts between DST and STD, the TSM 3.7.2 (and higher) clients will see that the modification time has changed for all files on NTFS systems, and will proceed to back everything up accordingly, even if the file has not really changed. This will occur only once after the time change, and thereafter incremental backups will proceed as normal. However, this will almost certainly affect the amount of data backed up by each client, effectively causing a full backup on all NTFS file systems. This could have a large impact on network and TSM server resources. The following bullets summarize the conditions under which this problem can occur: - TSM client is running on Windows NT 4.0 or Windows 2000. TSM clients running on Windows 9x-based operating systems (Windows 95, 98) are not affected. - The TSM client level is 3.7.2.x or higher (including all 4.1.x levels). TSM client levels below 3.7.2.x are not affected, as the problem was introduced in the 3.7.2.x code. - The file systems are formatted for NTFS. FAT and FAT32 file systems are unaffected by this problem. - The operating system's time zone settings are configured to automatically adjust for DST. You can check this by right-clicking on the Windows task bar and selecting the Adjust Date/Time item in the pop-up menu. (Alternatively, you can double-click on the clock display in the task bar.) Either of these actions will bring up the Date/Time Properties dialog. Click on the Time Zone tab and you should see the Automatically adjust clock for daylight saving changes checkbox. If the box is checked (the default installation setting), then your system is configured to automatically adjust for DST. Users in regions that do not observe DST (such as Arizona) will be unaffected by this problem, provided that the system's time zone settings are similarly configured to not observe DST. WHAT IBM/TIVOLI IS DOING ABOUT THIS Here are the actions that we are taking or have taken to date: 1) We have opened a severity 1 APAR, IC28544, to address this problem. 2) We have designed and built fixtests for the 3.7.2 and 4.1.1 Windows clients. The fixtest version numbers are 3.7.2.17 and 4.1.1.17. The fixtests should be available in a little while. They will be posted to the anonymous FTP server ftp.software.ibm.com in the following locations: Version 4.1.1.17: Directory /storage/tivoli-storage-management/patches/client/v4r1/Windows/v411/sing le Package name start with: IP22088_17 V3.7 PTF 2: Directory /storage/tivoli-storage-management/patches/client/v3r7/Windows/v372/i386 /single Package name starts with: IP21933_17 A follow-up note will be posted when the fixtests are actually available for download. 3) Even with the availability of a fixtest, most customers will be unable to roll it out in time for the time change. We have documented circumventions for this problem (see below), as the DST to STD switch is
Re: Slow restoratoins when large backups are happening?
Matt, I'm in agreement with Troy's posting below. If you are seeing high i/o wait on your TSM database volume(s), then this is a good contender for the root of some/all of your problem. The interesting point is your post says 'volume' singular. I would be a good idea to get your database spread across as many physical disks as possible and preferably on a different controller and different bus to that which is handling your diskpool and tape operation. If your server is from the Unix world, then consider using raw disk for your DB volumes instead of a filesystem. Try to configure TSM db volumes the same size as you have configured the raw disk. If you can afford 15Krpm disk then go for this. A 'possible' configuration for TSM database disk layout could be a separate SCSI attached chassis of 12 x 18GB 15Krpm disks. Only configure each disk with a raw partition of 4GB starting from the outermost sector (ie limit the head movement). Configure TSM for 12 x 4GB db volumes. If using TSM s/w database mirroring, consider duplicating the above arrangement on a separate controller. I appreciate that there is wastage here but it IMO it's worth it, if better performance is required. The main thing is to get your DB spread over as many physical spindles as possible, if RAW disk is an option, use it. Configure TSM db volumes equal to your physical partitions and use the outer most sectors of the disk where possible. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Troy Frank Sent: 24 October 2005 21:35 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Slow restoratoins when large backups are happening? What's the layout of the db volumes? ie. how many dbvol's do you have, and how many arrays/spindles/controllers are they spread out across? The other thing I forgot to ask before was what OS the tsm server is on. Another thing to look at is what your db cache-hit percentage is. Could be there's a lot of disk contention due to insufficient db buffering. Troy Frank Network Services University of Wisconsin Medical Foundation 608.829.5384 [EMAIL PROTECTED] 10/24/2005 2:58 PM There's also performance internal to the tsm server to consider. The large server backups could be monopolizing your network throughput, scsi card throughput, pci/pci-x bus throughput, or some combination of all the above. System performance monitoring shows hardly any network I/O during this situation. After all there is incremental backups running, it's not backing up much. On the restorations, it was 10,000 files for 8 GB. again not much. One issue I have seen is high i/o wait on the TSM database volume, which is why I know I have a database I/O issue, but, cancelling the larger backups should not cause the restoration to suddenly jump from sending a few hundred mb per hour to a gig every 5 minutes. Which is why I think it's an internal TSM issue and not a hardware performance issue. But maybe it is. I Just need more input into what to look for. Matt Glanville Confidentiality Notice follows: The information in this message (and the documents attached to it, if any) is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. 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 prohibited and may be unlawful. If you have received this message in error, please delete all electronic copies of this message (and the documents attached to it, if any), destroy any hard copies you may have created and notify me immediately by replying to this email. Thank you.
Re: Query for schedule and node
Geoff, I'm not 100% sure, but I think that what you're asking for is the classic SQL union of 2 select statements. As I understand it, this is possible in a traditional DB2, but the union intersect operations are not available in the TSM SQL subset. The closest I can manage is the following select A.SCHEDULE_NAME,NODE_NAME,ACTION,STARTDATE,STARTTIME,DURATION from client_schedules A, associations Unfortunately, this gives you the duplicate information for every nodename in the schedule. You want the much tidier output of a single entry for each schedule, nodename, etc etc and then a following list of the nodenames. I can't get this in one single select statement. The only solution I can manage would be to script it. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: 13 October 2005 21:13 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Query for schedule and node Hello all, I'm wondering if anyone has a query for this. Something broken out by schedule name with the nodes associated with each schedule. I'm looking for schedule name, Action, Date/Time, Period and Duration, Platform and the node names associated with each schedule. Thanks, Geoff Gill TSM Administrator SAIC M/S-G1b (858)826-4062 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Re: [SPAM: 10.200] Re: [ADSM-L] Slow backup performance
backup performance .EDU 07/10/2005 07:25 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Oops, I don't know if there is an iperf for Netware. Do other clients have the same problems from the network the NW server is on? Also you did not specify what kind of network is between server and client(s) (100Mb/1000Mb)? Met vriendelijke groet, With kind regards, Richard van Denzel. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Leigh Reed Sent: vrijdag 7 oktober 2005 10:37 To: ADSM-L@VM.MARIST.EDU Subject: Re: Slow backup performance If you have already checked this and it is very obvious to you, please don't be offended, but it has been a very common occurrence throughout the life of network backups. Have you checked that your NIC is hard coded to 100MB Full Duplex and your switch is also the same. You could also check if your switch is showing any CRC errors. Lastly, try an FTP from client server to TSM server to establish if the network is performing outside of TSM. Again, if I'm teaching you to suck hen produce, apologies. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Ambrose Sent: 07 October 2005 07:42 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Hello, We're currently experiencing backup failures/extreme slowness on a Netware 6.5 SP2 server TSM Client 5.3.0 TSM Server 5.2.0 TSA's up to date as recommended by Client Doco Client Logs 10/05/2005 14:43:19 ANS1809W Session is lost; initializing session reopen procedure. 10/05/2005 14:43:19 ANS1809W Session is lost; initializing session reopen procedure. 10/05/2005 14:44:15 sessRecvVerb: Error -50 from call to 'readRtn'. 10/05/2005 14:44:15 ANS1999E Incremental processing of 'SYS:' stopped. 10/05/2005 14:48:24 ANS1999E Incremental processing of 'INF:' stopped. 10/05/2005 14:48:25 ANS1017E Session rejected: TCP/IP connection failure Server Logs 10/05/05 14:39:53 ANR0481W Session 2177 for node SERVERNAME (NetWare) terminated - client did not respond within 180 seconds. 10/05/05 14:41:10 ANR0406I Session 2178 started for node SERVERNAME (NetWare) (Tcp/Ip xxx.xxx.xxx.xxx(19578)). Currently we have had a backup running for 24 hours and all that has been transfered is 4.19 gig and 255,000 files scanned. Has anyone else experienced similar issue's Any help on this would be appreciated Regards Cameron The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If you are not the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the original message. Thank you.
Re: [SPAM: 6.500] Re: [ADSM-L] Slow backup performance
Cameron If I understand your scenario correctly, you have 5GB worth of data, with approx 80,000 files and very little change data. In my experience 80,000 files is small and the catalogue that would be sent from the TSM server would be small also. Can you watch the client session during an incremental backup and determine how much data (catalogue information) is SENT to the client and how long this takes. Also from the dsmsched.log, how long is it between the backup starting the first entry of '* Processed 500 files *'. This will give you an idea of the time that it takes to transmit the catalogue from the TSM server to the client and scan the first 500 files. If this is greater than one hour, I would still say that your network is at fault. Also, if you are concerned about the file scan times or performance, why don't you try a selective backup of a volume to a dummy nodename. This would negate the whole filescan performance issue and give you true network performance. You can always delete the node and associated data after testing. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Ambrose Sent: 11 October 2005 12:30 To: ADSM-L@VM.MARIST.EDU Subject: [SPAM: 6.500] Re: [ADSM-L] Slow backup performance Guys, Thanks for the info, I'll double check the network settings. Though I have changed the COMMtimeout value from 180secs to 1800 secs as suggested by Richard Simms, which has stopped the session restart error messages and infact the backup seems to be error free. As for the speed, I'm still leaning towards a tsm netware client/ Netware OS issue. I say this because last night I performed a test backup on a 10gig volume (50% full) that hadn't had any changes and it still took 10 hours to scan only 8 odd files. The Client itself hovered around 87-89% utilisation. When this server was netware 6.0 it used to flatline on 100% when performing a backup with the same slow performance. We thought once we'd upgraded to 6.5 with the additional memory required with 6.5, that performance would improve. Unfortunately it hasn't yet. Has anyone experienced this before? Regards Cameron Richard van Denzel [EMAIL PROTECTED] To NL ADSM-L@VM.MARIST.EDU Sent by: ADSM: cc Dist Stor Manager Subject [EMAIL PROTECTED] Re: Slow backup performance .EDU 07/10/2005 07:25 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Oops, I don't know if there is an iperf for Netware. Do other clients have the same problems from the network the NW server is on? Also you did not specify what kind of network is between server and client(s) (100Mb/1000Mb)? Met vriendelijke groet, With kind regards, Richard van Denzel. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Leigh Reed Sent: vrijdag 7 oktober 2005 10:37 To: ADSM-L@VM.MARIST.EDU Subject: Re: Slow backup performance If you have already checked this and it is very obvious to you, please don't be offended, but it has been a very common occurrence throughout the life of network backups. Have you checked that your NIC is hard coded to 100MB Full Duplex and your switch is also the same. You could also check if your switch is showing any CRC errors. Lastly, try an FTP from client server to TSM server to establish if the network is performing outside of TSM. Again, if I'm teaching you to suck hen produce, apologies. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Ambrose Sent: 07 October 2005 07:42 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Hello, We're currently experiencing backup failures/extreme slowness on a Netware 6.5 SP2 server TSM Client 5.3.0 TSM Server 5.2.0 TSA's up to date as recommended by Client Doco Client Logs 10/05/2005 14:43:19 ANS1809W Session is lost; initializing session reopen procedure. 10/05/2005 14:43:19 ANS1809W Session is lost; initializing session reopen procedure. 10/05/2005 14:44:15 sessRecvVerb: Error -50 from call to 'readRtn'. 10/05/2005 14:44:15 ANS1999E Incremental processing of 'SYS:' stopped. 10/05/2005 14:48:24 ANS1999E Incremental processing of 'INF:' stopped. 10/05/2005 14:48:25 ANS1017E Session rejected: TCP/IP connection failure Server Logs 10/05/05 14:39:53 ANR0481W Session 2177 for node SERVERNAME (NetWare) terminated - client did not respond within 180 seconds. 10/05/05 14:41:10 ANR0406I Session 2178 started for node SERVERNAME
Re: Slow backup performance
If you have already checked this and it is very obvious to you, please don't be offended, but it has been a very common occurrence throughout the life of network backups. Have you checked that your NIC is hard coded to 100MB Full Duplex and your switch is also the same. You could also check if your switch is showing any CRC errors. Lastly, try an FTP from client server to TSM server to establish if the network is performing outside of TSM. Again, if I'm teaching you to suck hen produce, apologies. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Ambrose Sent: 07 October 2005 07:42 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Hello, We're currently experiencing backup failures/extreme slowness on a Netware 6.5 SP2 server TSM Client 5.3.0 TSM Server 5.2.0 TSA's up to date as recommended by Client Doco Client Logs 10/05/2005 14:43:19 ANS1809W Session is lost; initializing session reopen procedure. 10/05/2005 14:43:19 ANS1809W Session is lost; initializing session reopen procedure. 10/05/2005 14:44:15 sessRecvVerb: Error -50 from call to 'readRtn'. 10/05/2005 14:44:15 ANS1999E Incremental processing of 'SYS:' stopped. 10/05/2005 14:48:24 ANS1999E Incremental processing of 'INF:' stopped. 10/05/2005 14:48:25 ANS1017E Session rejected: TCP/IP connection failure Server Logs 10/05/05 14:39:53 ANR0481W Session 2177 for node SERVERNAME (NetWare) terminated - client did not respond within 180 seconds. 10/05/05 14:41:10 ANR0406I Session 2178 started for node SERVERNAME (NetWare) (Tcp/Ip xxx.xxx.xxx.xxx(19578)). Currently we have had a backup running for 24 hours and all that has been transfered is 4.19 gig and 255,000 files scanned. Has anyone else experienced similar issue's Any help on this would be appreciated Regards Cameron
Re: Microsoft Volume Shadow Copy failed.
Tim Are you running W2K3 SP1 ? The whole VSS thing was very flakey pre SP1 and there were a number of MS hot fixes relating to VSS. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tim Brown Sent: 05 October 2005 12:14 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Microsoft Volume Shadow Copy failed. Has anyone seen this error on a Windows 2003 client 10/04/2005 20:33:58 VssQuerySystemWriters(): pAsync-QueryStatus() returns hr=E_UNEXPECTED 10/04/2005 20:33:58 ANS1948E Query system components via Microsoft Volume Shadow Copy failed. Tim Brown Systems Specialist Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: [EMAIL PROTECTED] Phone: 845-486-5643 Fax: 845-486-5921
Re: Linux 5.2 TSM Install Error
Aaron, Firstly, if you are still trying to install on FC3, it's not strictly supported. Supported platforms can be found at http://www-1.ibm.com/support/docview.wss?rs=663context=SSGSG7uid=swg21 052223loc=en_UScs=utf-8lang=en It's been a while since I've done this and things may have changed with later kernel releases but the error that you are seeing below is because the standard FC3 distro does not contain certain libraries that the license acceptance tool requires. Also ensure that you do have the license rpm. I'm not a Linux expert but I googled the errors and found articles relating to missing rpm's. You may find that you have to add one, get a different error, google it, add another etc. In the supported platforms doc, it may be worth noting the following For TSM Version 5.2 Linux kernel 2.4.x (for x=2, or later) glibc 2.2.2 libstdc++ 2.9.x (for x=6, or later) RPM 3.0.x or 4.0 (for x=0, or later) On the point of not being able to connect to the server when it's installed, I think that Richard Sims hit the nail on the head. FC is a hardened version of Linux and as such has firewalling set as default. On the FC install process you will be asked if you wish to have firewalling enabled (default) and also SELinux. With the SELinux options, you can specify additional TCP ports ie 1500, 1501, 1580 etc. If this is all purely for testing you can get by, but if you are thinking of production I would recommend an officially supported version of Linux. Leigh -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Becar Sent: 02 October 2005 20:13 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Linux 5.2 TSM Install Error Anyone know why this is? [EMAIL PROTECTED] tsm1]# ls i686 install_server license noarch ppc64 README #README# s390 s390x TSM_1st LINUX SERVER C54RWML.tar [EMAIL PROTECTED] tsm1]# ./install_server Preparing License Agreement LoadJavaVM: unable to open DLL (/tmp/license/jre/bin/classic/libjvm.so) /tmp/license/jre/bin/classic/libjvm.so: cannot restore segment prot after reloc: Permission denied JRE error attempting to evoke the license acceptance tool. Error code 1. Please call customer support. [EMAIL PROTECTED] tsm1]# Thanks! Aaron