Re: TSM and DB2
We only use the DB2 API to backup our DB2 databases to TSM Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za Tel : +2721 - 658 1711 Fax : +2786 - 5134272 Mobile : +2782 - 653 8164 Living on Earth is expensive, but it does include a free trip around the sun. -Unknown- -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Jeannine Walter Sent: 10 November 2010 10:16 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM and DB2 Is there anyone out there using TSM (5.5 or 6.x) and backing up DB2 through the DB2 TDP (API)? And I'd like actual DB2 users not just those who have moved to TSM 6 and now think they are DB2 DBAs;-). I'm looking to see how people are backing this up and to get some recommendations. Thanks. Jeannine * If you're going through hell, keep going... -Winston Churchill Jeannine Walter even...@accessus.net ** Read our disclaimer at: http://www.picknpay.co.za/picknpay/content/en/disclaimer If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to it-secur...@pnp.co.za
Re: why create a 12TB LUN
Had an original IBM 4.77MHz in 1991. 640KB Main memory. 360K Floppy drive a 10MB Hard drive. Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Skylar Thompson Sent: 27 May 2010 10:16 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] why create a 12TB LUN I'm around there too. 20MB Seagate MFM drive in an Epson QX-16. This was actually a dual-processor system (8088 for DOS and Z80 for Epson's CPM clone TPM). I had fired it up just for the heck of it a few years ago and it came up without problems. They don't make 'em like they used to. On 05/27/10 13:04, David McClelland wrote: I can beat than - I have a 20MB 'Winchester' HDD inside a working original Compaq Deskpro 8086 from c 1985. Fired her up last week for some photos, still works a treat. (No TSM client for it though...) /DMc Sent from my BlackBerry® wireless device -Original Message- From: Strand, Neil B.nbstr...@leggmason.com Date: Thu, 27 May 2010 14:45:51 To:ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] why create a 12TB LUN Gill, This sounds like an interesting environment. Could you share some of the particulars such as what storage device is providing the LUN, what server OS is using the LUN and what the general reason was for choosing the LUN? Historical note - My first hard disk in my home PC was 20GB Thank you, Neil Strand Storage Engineer - Legg Mason Baltimore, MD. (410) 580-7491 Whatever you can do or believe you can, begin it. Boldness has genius, power and magic. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Gill, Geoffrey L. Sent: Wednesday, May 26, 2010 7:04 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] why create a 12TB LUN I'm guessing many of you will find this quite odd, I know I did, but I had someone come to me and say they were going to ask for a 12TB LUN and wanted to back it up. Without even mentioning the product they want to use, obviously not TSM though, and I'm not even sure it would make difference, how would you manage to get a 12TB LUN backed up daily. I would expect it to be at least 75% full if not more, and even without knowing what percentage of data changes on it, it would seem to me the request seems strange. They're thinking of getting a VTL and backing up through fiber direct, not across the network, but no idea which one or what sort of throughput to expect. Have any of you been approached with this sort of request and if so what was your response? I'm sort of dumbfounded at this point since I've not heard or seen this anywhere. Thanks, Geoff Gill TSM/PeopleSoft Administrator SAIC M/S-B1P 4224 Campus Pt. Ct. San Diego, CA 92121 (858)826-4062 (office) (858)412-9883 (blackberry) IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you. -- -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S048, (206)-685-7354 -- University of Washington School of Medicine Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to it-secur...@pnp.co.za
Restore error - invalid version id's list field found in ObjRtrv verb
Hi, Has anyone seen this warning/error before? I'm trying to restore a file space. TSM Client 5.5.2.2 TSM Server 5.5.2.1 Both Client Server AIX 5.3 09/18/09 11:24:14 ANE4964I (Session: 18, Node: PORTALDEV) Elapsed processing time:00:00:05 (SESSION: 18) 09/18/09 11:24:14 ANR0403I Session 18 ended for node PORTALDEV (AIX). (SESSION: 18) 09/18/09 11:24:18 ANR0406I Session 188895 started for node PORTALDEV (AIX) (Tcp/Ip isportaldevtest(33310)). (SESSION: 188895) 09/18/09 11:25:15 ANR0443W Protocol error on session 188895 for node PORTALDEV (AIX) - invalid version id's list field found in ObjRtrv verb (offset 6). (SESSION: 188895) 09/18/09 11:25:15 ANR0484W Session 188895 for node PORTALDEV (AIX) terminated - protocol violation detected. (SESSION: 188895) 09/18/09 11:25:30 ANR0406I Session 188907 started for node PORTALDEV (AIX) (Tcp/Ip isportaldevtest(33311)). (SESSION: 188907) 09/18/09 11:25:42 ANR0480W Session 188870 for node PORTALDEV (AIX) terminated - connection with client severed. (SESSION: 188870) 09/18/09 11:25:42 ANR0480W Session 188907 for node PORTALDEV (AIX) terminated - connection with client severed. (SESSION: 188907) 09/18/09 11:31:36 ANR0406I Session 188957 started for node PORTALDEV (AIX) (Tcp/Ip isportaldevtest(33316)). (SESSION: 188957) 09/18/09 11:31:36 ANR0406I Session 188958 started for node PORTALDEV (AIX) (Tcp/Ip isportaldevtest(33318)). (SESSION: 188958) 09/18/09 11:32:21 ANR0443W Protocol error on session 188957 for node PORTALDEV (AIX) - invalid version id's list field found in ObjRtrv verb (offset 6). (SESSION: 188957) 09/18/09 11:32:21 ANR0484W Session 188957 for node PORTALDEV (AIX) terminated - protocol violation detected. (SESSION: 188957) 09/18/09 11:32:36 ANR0406I Session 188967 started for node PORTALDEV (AIX) (Tcp/Ip isportaldevtest(33319)). (SESSION: 188967) 09/18/09 11:32:44 ANR0480W Session 188967 for node PORTALDEV (AIX) terminated - connection with client severed. (SESSION: 188967) Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za mailto:jvandenb...@pnp.co.za Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). From: Jacques Van Den Berg Sent: 18 September 2009 11:35 AM To: Rodger Harding Subject: Portal Error Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za mailto:jvandenb...@pnp.co.za Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to it-secur...@pnp.co.za
Re: DB2 - HADR and TSM
Hi Rainer, We backup the primary database as per normal with the db2 command to TSM. We do a full online backup everyday and archive logs to TSM as well. Nothing special. Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Rainer Holzinger Sent: 27 April 2009 03:33 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] DB2 - HADR and TSM Hi all, is somebody having experience to backup DB2 HADR environments with TSM? Or is there some publication available about this scenario? Thank you and best regards, Rainer RHo-Consulting Rainer Holzinger Alter Bahnhof 13 D-93093 Donaustauf phone: +49 9403 969174 mobile: +49 162 2807 888 email: mailto:rainer.holzin...@t-online.de rainer.holzin...@t-online.de CONFIDENTIALITY NOTICE: This e-mail is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the e-mail or use it for any purpose or disclose its contents to any other person. VIRUSES: Although there have been taken steps to ensure that this e-mail and attachments are free from any viruses, the recipient should at its sole discretion take the necessary measures to ensure that the received messages are actually virus free. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to it-secur...@pnp.co.za
Re: DB2 - HADR and TSM
Hi Rainer, We use HADR in our SAP environment. I tread both nodes as separate TSM clients. Both nodes have its own node names. You can only backup the primary node of course. When we do failover we point all our SAP clients to the secondary system. I then run a scheduled backup on the secondary node. Hope this helps. Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: rainer_holzin...@web.de [mailto:rainer_holzin...@web.de] Sent: 27 April 2009 08:27 PM To: Jacques Van Den Berg Cc: 'ADSM: Dist Stor Manager' Subject: RE: [ADSM-L] DB2 - HADR and TSM Hello Jacques, I was more asking about the ongoing backup procedures if your primary HADR nodes goes down for some reason and the DB2 database(s) is/are continued on your standby HADR node. How do you 'failover/failback' your DB2 backup clients in these situations? DB2 HADR looks like some Software cluster and backup procedures are therefore a bit more 'tricky' to implement as this is in HACMP or MSCS clusters. Did you manage this somehow? Best regards, Rainer -Original Message- From: jvandenb...@pnp.co.za [mailto:jvandenb...@pnp.co.za] Sent: Monday, April 27, 2009 4:45 PM To: rainer_holzin...@web.de; ADSM-L@VM.MARIST.EDU Subject: RE: [ADSM-L] DB2 - HADR and TSM Hi Rainer, We backup the primary database as per normal with the db2 command to TSM. We do a full online backup everyday and archive logs to TSM as well. Nothing special. Kind Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : jvandenb...@pnp.co.za Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Rainer Holzinger Sent: 27 April 2009 03:33 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] DB2 - HADR and TSM Hi all, is somebody having experience to backup DB2 HADR environments with TSM? Or is there some publication available about this scenario? Thank you and best regards, Rainer RHo-Consulting Rainer Holzinger Alter Bahnhof 13 D-93093 Donaustauf phone: +49 9403 969174 mobile: +49 162 2807 888 email: mailto:rainer.holzin...@t-online.de rainer.holzin...@t-online.de CONFIDENTIALITY NOTICE: This e-mail is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the e-mail or use it for any purpose or disclose its contents to any other person. VIRUSES: Although there have been taken steps to ensure that this e-mail and attachments are free from any viruses, the recipient should at its sole discretion take the necessary measures to ensure that the received messages are actually virus free. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to it-secur...@pnp.co.za Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to it-secur...@pnp.co.za
Re: Error running DB2 backups using TSM
Hi Lori, Look in the file /usr/tivoli/tsm/client/api/bin/sample/dsmrc.h RC 186 means you don't have an archive copy group. #define DSM_RC_TL_NOACG186 /* Archive req, no archive copy group * Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lori Grimaldi Sent: 03 December 2008 03:15 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Error running DB2 backups using TSM I am trying to run DB2 backups using TSM and I am seeing this in the db2diag.log: 2008-12-02-15.12.28.668662-300 E115842488A361 LEVEL: Error PID : 23938TID : 2199156889936PROC : db2vend (db2logmgr.meth1 - 43 (P /db/db2inst1/db2dump/db2diag.log 2093516L, 115878129C 2092860,11 99% INSTANCE: db2inst1 NODE : 000 EDUID : 43 EDUNAME: db2logmgr (PWLAN) 0 FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108 MESSAGE : Started archive for log file S018.LOG. 2008-12-02-15.13.03.912179-300 E115853025A361 LEVEL: Error PID : 23938TID : 2199156889936PROC : db2vend (db2logmgr.meth1 - 43 (P INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, database utilities, sqluvint, probe:602 DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes TSM RC=0x00BA=186 -- see TSM API Reference for meaning. 2008-12-02-15.13.03.913855-300 E115853387A864 LEVEL: Error PID : 23893TID : 2199367182672PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 43 EDUNAME: db2logmgr (PWLAN) 0 FUNCTION: DB2 UDB, data protection services, sqlpInitVendorDevice, probe:1030 MESSAGE : ZRC=0x86100025=-2045771739=SQLP_MEDIA_VENDOR_DEV_ERR A vendor device reported a media error. DATA #1 : String, 29 bytes Init failed! Vendor rc info: DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes 2093056,1 99% FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3150 MESSAGE : ADM1848W Failed to archive log file S005.LOG to TSM chain 0% from /db/db2inst1/db2backup/db2inst1/PWLAN/NODE/C000/. 2008-12-02-15.14.35.547958-300 E115877076A568 LEVEL: Error PID : 23893TID : 2199367182672PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 43 EDUNAME: db2logmgr (PWLAN) 0 FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3160 MESSAGE : ZRC=0x86100025=-2045771739=SQLP_MEDIA_VENDOR_DEV_ERR A vendor device reported a media error. DATA #1 : preformatted Failed to archive log file S005.LOG to TSM chain 0 from /db/db2inst1/db2backup/db2inst1/PWLAN/NODE/C000/. 2008-12-02-15.14.35.548035-300 E115877645A484 LEVEL: Warning PID : 23893TID : 2199367182672PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 EDUID : 43 EDUNAME: db2logmgr (PWLAN) 0 FUNCTION: DB2 UDB, data protection services, sqlpgCleanFailArchPath, probe:4940 DATA #1 : preformatted Unable to archive log file 5 from failarchpath /db/db2inst1/db2backup/db2inst1/PWLAN/NODE/C000/ for LOGARCHMETH1 due to rc -2045771739. Any ideas? Lori G. Linux on zSeries Team VM Services Delivery - Information Technology Services Americas, Global Services [EMAIL PROTECTED] Linux Information? See http://w3vmlinux.pok.ibm.com Linux Requests? Visit our new workload management tool at: http://linuxonz.pok.ibm.com/service/request They who give have all things; they who withhold have nothing. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: IBM TS3310 vs IBM TS3200
We have a TS3200 on one off our smaller sites. Had issues where it brought our DB2 database to a halt, because the operator tried to eject more than 3 tapes at a time. The I/O station will not open to be able to remove the tapes. All library operation freezes, hence my db2 log file disk pool filled up and could not migrate to tape. I also found the library (robotic part) quite slow. Then again I'm used to a 3584. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Larry Peifer Sent: 22 October 2008 02:04 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] IBM TS3310 vs IBM TS3200 We are debating whether to purchase the IBM TS3310 or the TS3200 tape library for use with our existing TSM environment. We are an AIX shop running 4 Gig interfaces on a 4 Gig FC switch. This equipment will replace our existing IBM 3583 tape library. Any first hand experience would be appreciated. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
GUI baclient does not restore all files
Hi Everyone, I found a very strange problem where my GUI does not replace files when doing a restore even thought it asks me for the option. Has anyone experience this problem before? When doing the restore from command line with the -replace=yes option it will replace the file. Any suggestions? TSM server 5.4.1 TSM BACLIENT 5.4.1 AIX 5.3 Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: TSM Disk pools on EMC issue
Thanks for the info guys. SANDISCOVERY is turned ON at the moment. I have turned it OFF now - just waiting for the go-ahead to reboot the server. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Drew Sent: 30 June 2008 10:11 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Disk pools on EMC issue Same here, We only recently isolated our Clariion problems to this. We would have random days where the HBA's just logged out of the Clariion and would not connect at all, no matter what we did. We had to reboot these P570s multiple times (not pleasant!) until I took a wild guess to turn off SANDISCOVERY. Regards, Shawn Shawn Drew Internet [EMAIL PROTECTED] Sent by: ADSM-L@VM.MARIST.EDU 06/30/2008 11:24 AM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject Re: [ADSM-L] TSM Disk pools on EMC issue I had a client that was trying to connect a CX700 to their AIX TSM system. What they say is that the SANDISCOVER was causing problems and IBM suggested they disable it in the DSMSERV.OPT. Been working ever since. I wasn't involved in the issue, this is just what they told me they found out. But you might want to give it a try. Bill Boyer This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Different db2 retention periods
This will only work for offline backups otherwise you have to keep 10 years of log files for you oldest backup. My 10 cents... Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Herrmann, Boris Sent: 27 June 2008 10:55 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Different db2 retention periods Hi Wanda, thanks for your answer. Use multiple nodenames, e.g: DB2client DB2client-monthly DB2client-yearly Then they can use different management classes with different retentionvalues. But that is exactly my problem. TSM doesn't control the backup versions via tsm management classes. There is only a db2adutl tool to control the TSM Backup versions. With that tool you can do: db2adutl delete full older than x days or db2adutl delete full keep n (means to keep the last n versions) With both options I can't fulfill the requirements. How do other handle this issue? (One thought of me was to EXPORT the TSM Node to tape, or to dump the db2 backup to a file and then backup up this file with tsm and use different management classes). Any ideas or thought are appreciated. With kind regards, Boris Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
TSM Disk pools on EMC issue
Hello, I have an interesting issue where when trying to startup TSM, the EMC storage path's change status to dead. Environment: TSM sever using purely for IBM Commonstore for SAP archiving. TSM database log files on EMC Clarion Storage - mirrored across LUN' on EMC. 2TB of disk pools spread across 4 X 500GB LUN's on EMC storage. My question: Is there a way a can tell TSM not to VARY-ON my disk pool volumes during startup so that I can vary-on them manually once TSM is up? I think that TSM is trying so hard to vary-on these volumes that the EMC path timeout. Has anyone experienced something similar? Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: TSM Disk pools on EMC issue
hdisk15 SP A0 active alive 0 0 Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Rhodes Sent: 30 June 2008 03:08 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Disk pools on EMC issue I think we need some more info. We use EMC storage (DMX and Clariion) for all our TSM disk based storage (db, log, disk storage pools, file device pools). It just works - really well. Is your storage online and available before you start TSM? Are you using filesystems or logical volumes? Are you using PowerPath, or some other mpio driver? What OS are you using for for your TSM server (we use AIX)? Rick Jacques Van Den Berg [EMAIL PROTECTED] To CO.ZAADSM-L@VM.MARIST.EDU Sent by: ADSM: cc Dist Stor Manager Subject [EMAIL PROTECTED] TSM Disk pools on EMC issue .EDU 06/30/2008 08:47 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU Hello, I have an interesting issue where when trying to startup TSM, the EMC storage path's change status to dead. Environment: TSM sever using purely for IBM Commonstore for SAP archiving. TSM database log files on EMC Clarion Storage - mirrored across LUN' on EMC. 2TB of disk pools spread across 4 X 500GB LUN's on EMC storage. My question: Is there a way a can tell TSM not to VARY-ON my disk pool volumes during startup so that I can vary-on them manually once TSM is up? I think that TSM is trying so hard to vary-on these volumes that the EMC path timeout. Has anyone experienced something similar? Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. 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, and delete the original message. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Orphaned DB2 data
Hi, Does your sql select query occ NODE give the same result? We are running DB2 Ver8 9. I delete the backups with db2adutl. This only marks them as inactive in tsm. Tsm expire inventory will the delete them from tsm. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Collins, Brenda Sent: 26 February 2008 05:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Orphaned DB2 data Hi Everyone! I have some issues with DB2 (v8 v9) data. If I run a select statement to show backups on a particular node, it shows many more backups than what the DBA sees when they do a query through db2adutl. When the DBA tried to delete backups older than 45 days, he received the following message: The current delete transaction failed. You do not have sufficient authorization. Attempting to deactivate backup image(s) instead... Success. I do know that over time, they have upgraded DB2 from v8 to v9 but I am not sure that is the reason why I have orphaned data. Any ideas on how to determine what data is orphaned and how to get rid of it in DB2 would be greatly appreciated! TSM Server: 5.4.0.2 OS = AIX 5.3 DB2 - V9 (at this time) TSM Client 5.4.0.0 Thanks, Brenda Collins [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Orphaned DB2 data
Q occ also tells you the number of files which is the number of backups you have in tsm divided by the number of sessions you use to do your db2 backup. Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Collins, Brenda Sent: 26 February 2008 06:00 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Orphaned DB2 data The q occ only provides the total space. The select command I was using shows actual dates. Select node_name,backup_date from backups where node_name='xx' This tells me there are backups out there from almost a year ago when their scripts are designed to delete backups older than 45 days. When the DBA tried to delete them, he received the error message below. Brenda -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Van Den Berg Sent: Tuesday, February 26, 2008 9:51 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Orphaned DB2 data Hi, Does your sql select query occ NODE give the same result? We are running DB2 Ver8 9. I delete the backups with db2adutl. This only marks them as inactive in tsm. Tsm expire inventory will the delete them from tsm. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Collins, Brenda Sent: 26 February 2008 05:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Orphaned DB2 data Hi Everyone! I have some issues with DB2 (v8 v9) data. If I run a select statement to show backups on a particular node, it shows many more backups than what the DBA sees when they do a query through db2adutl. When the DBA tried to delete backups older than 45 days, he received the following message: The current delete transaction failed. You do not have sufficient authorization. Attempting to deactivate backup image(s) instead... Success. I do know that over time, they have upgraded DB2 from v8 to v9 but I am not sure that is the reason why I have orphaned data. Any ideas on how to determine what data is orphaned and how to get rid of it in DB2 would be greatly appreciated! TSM Server: 5.4.0.2 OS = AIX 5.3 DB2 - V9 (at this time) TSM Client 5.4.0.0 Thanks, Brenda Collins [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: DB2 Log Archiving via TSM
Why, do you want it done hourly if its gets automatically archived by DB2 when the log file is full? Just let DB2 do the archiving directly to TSM. We have 21 DB2 databases all archiving directly to one TSM server with no problems. Some of them are pretty busy, writing a log file every few seconds to TSM. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Dourado Sent: 22 August 2007 11:16 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] DB2 Log Archiving via TSM Hi, There seems to be hell of a lot of log archiving going on , and am I wondering if it's because it has been set up incorrectly. I currently have two methods of log archiving 1) The databases were enabled for rollforward recovery using the user exit parameter, where by full logfiles are automatically archived by TSM. 2) I was later asked to archive the logs on an hourly basis(to TSM). To achieve this I used DB2 Task Center to set up hourly schedules. The command script is as follows :- UPDATE DB CFG FOR xyz USING logarchmeth1 USEREXIT logprimary 10 logsecond -1 logfilsiz 2000; Any advice would be appreciated. DB2 V8.1.14.292 TSM SERVER for Windows V5.3.4.0 BA CLIENT 5.3.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 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 ** Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: DB2 backups
Look at this Redbook : sg246247 Backup up DB2 on TSM. It will explain everything. You don't associate it with a schedule. You do the backup from db2 into TSM. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1676 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Britton, Nick Sent: 30 November 2006 05:28 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] DB2 backups Can someone help with understanding how db2 works with the api client. I am new to TSM and I am trying to understand how I backup the DB with the API client. I understand that I install the API and Configure the API. I register the node and associate it with a schedule. But how to you backup the actual databases? * PRIVILEGED AND CONFIDENTIAL * This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e- mail, delete this communication and destroy all copies. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: TSM for DB2
It uses an API not TDP. See the Redbook sg246247 Backup up DB2 on TSM. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1676 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Nicolas Muurmans Sent: Monday, October 23, 2006 3:27 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM for DB2 Someone told me that DB2 has a builtin TSM tdp agent. Sending db2 backups directly to a TSM server instead of a file. How does this work? Where can I read about it? I have tried to google it as best that I can, but I haven't found any satisfactory documentation on the subject. But it may be that i haven't googled it properly :-) Regards Nicolas Muurmans Ventelo Norway. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Gig utilization during backups
Geoff, Check these settings, they apply to 1Gig Ether. original settings: sb_max = 1048576 udp_recvspace = 42080 udp_sendspace = 9216 tcp_recvspace = 16384 tcp_sendspace = 16384 rfc1323=0 The following settings have been applied: no -o sb_max=2097152 no -r -o sb_max=2097152 no -o udp_sendspace=65536 no -r -o udp_sendspace=65536 no -o udp_recvspace=65536 no -r -o udp_recvspace=65536 no -o tcp_recvspace=262144 no -r -o tcp_recvspace=262144 no -o tcp_sendspace=262144 no -r -o tcp_sendspace=262144 no -o rfc1323=1 no -r -o rfc1323=1 Hope this help... Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1676 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: Friday, September 08, 2006 6:50 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Gig utilization during backups I'd like to get some input on what others see on their port utilization during heavy network traffic. With 350+ systems backing up to a single TSM server I'm curious as to why we see only about 50% utilization on the GIG port with max scheduled sessions set to 95. Sessions run extremely long compared to when they were on the old system. What have others seen their systems and what do you have set for max scheduled sessions? I still feel like this system, which has 4 CPU's is not nearly as fast at moving data than my 2 CPU system was and the setup is very similar. AIX 5.3 - TSM 5.3.3.0 - 4 CPU's - 4GB memory - Gig interface Thanks, Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: DB2 nodes unable to delete transaction log archives TSM 5.3.2.3
Can you see it the actual log file is in TSM? db2adutl query logs Are you using db2adutl to delete them? Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1676 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Crosskey, Adam - Resources, ICT Services Sent: Tuesday, August 22, 2006 12:07 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] DB2 nodes unable to delete transaction log archives TSM 5.3.2.3 We have a number of db2 servers (Client\api 5.3.2) unable to remove their transaction log archives from TSM. We get errors like. Unable to delete file S443.LOG at History Entry 656 due to rc 26 All the nodes have 'Archivedelete Yes' Any ideas? Adam Crosskey Systems Engineering Team Oxfordshire County Council 3rd Floor Clarendon House Shoe Lane Oxford OX1 2DP 0845 052 2020 The information in this e-mail, together with any attachments, is confidential. If you have received this message in error you must not print off, copy, use or disclose the contents. The information may be covered by legal and/or professional privilege. Please delete from your system and inform the sender of the error. As an e-mail can be an informal method of communication, the views expressed may be personal to the sender and should not be taken as necessarily representing the views of the Oxfordshire County Council. As e-mails are transmitted over a public network the Oxfordshire County Council cannot accept any responsibility for the accuracy or completeness of this message. It is your responsibility to carry out all necessary virus checks. You should be aware that all emails received and sent by this Council are subject to the Freedom of Information Act 2000 and therefore may be disclosed to other parties under that Act. www.oxfordshire.gov.uk Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: TSM on P5 LPAR
Hi Paul, I'm running a TSM server on a P550 with 2 LPAR's - 3CPU's 12GIG Memory. Running great. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1676 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul van Dongen Sent: Wednesday, August 16, 2006 1:42 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM on P5 LPAR Hello all, Is anybody using TSM server installed on a P5 LPAR with AIX? The question is: Are there any differences between installations on LPAR and single-image (non-partitioned) machines? Environment soulhd be TSM 5.3.3 on AIX 5.3. Thanks in advance, Paul van Dongen -- Outgoing mail has been checked by TrendMicro InterScan VirusWall Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Network tuning question -- AIX to AIX
Hi, We get around 65MB/s. The backups to TSM is not optimized as yet. Very are busy implementing a very big SAP landscape at the moment, so some of my node backups are running in parallel to TSM. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Hans-Dieter Kutz Sent: Wednesday, July 19, 2006 2:35 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Network tuning question -- AIX to AIX On Tue, Jul 18, 2006 at 03:07:06PM +0200, Jacques Van Den Berg wrote: Hi, I assume you are using TSM AIX. We have applied the following settings on AIX for our GIGABIT ETHERS. original settings: sb_max = 1048576 udp_recvspace = 42080 udp_sendspace = 9216 tcp_recvspace = 16384 tcp_sendspace = 16384 The following settings has been applied: no -o sb_max=2097152 no -r -o sb_max=2097152 no -o udp_sendspace=65536 no -r -o udp_sendspace=65536 no -o udp_recvspace=65536 no -r -o udp_recvspace=65536 no -o tcp_recvspace=262144 no -r -o tcp_recvspace=262144 no -o tcp_sendspace=262144 no -r -o tcp_sendspace=262144 Hello Jacques! With the following settings we are getting around 45 Mb/s through the network to our TSM-Server (AIX to AIX) with no Channel: snip # no -a|grep rec tcp_recvspace = 16384 udp_recvspace = 42080 # no -a|grep send tcp_sendspace = 16384 udp_sendspace = 9216 # no -a|grep sb sb_max = 8738140 # lsattr -El en1 alias4 IPv4 Alias including Subnet Mask True alias6 IPv6 Alias including Prefix Length True arp onAddress Resolution Protocol (ARP) True authority Authorized Users True mtu 1500 Maximum IP Packet Size for This Device True netmask 255.255.255.0 Subnet MaskTrue remmtu576 Maximum IP Packet Size for REMOTE Networks True rfc1323 1 Enable/Disable TCP RFC 1323 Window Scaling True tcp_nodelay 1 Enable/Disable TCP_NODELAY Option True tcp_recvspace 873814Set Socket Buffer Space for Receiving True tcp_sendspace 873814Set Socket Buffer Space for SendingTrue # nmon output client --Network-Statistics I/F Name Recv=KB/s Trans=KB/s packin packout insize outsize Peak-Recv Trans en1 178.6 46233.43505.2 32296.552.2 1465.925395.7 50720.6 snip What are your highest thruputs? Cheers, ku -- Princess Leia: Aren't you a little short for a stormtrooper? _ Dieses Mail/Fax ist ausschließlich für den genannten Empfänger bestimmt. Es enthält persönliche oder vertrauliche Informationen. Jede unerlaubte Verbreitung des Inhalts, auch teilweise, ist untersagt. Falls Sie dieses Mail/Fax versehentlich erhielten, informieren Sie bitte unverzüglich den Absender und löschen Sie dieses Mail/Fax endgültig von jedem Rechner, auch Ihrem Mail-/Faxserver. This mail/fax contains private or confidential information and is intended only for the person to which it is addressed. Any unauthorized dissemination, even partly, is prohibited. If you received this mail/fax in error, please contact the sender and delete this mail/fax finally from any computer, including your mail-/faxserver. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Network tuning question -- AIX to AIX
Hi, I assume you are using TSM AIX. We have applied the following settings on AIX for our GIGABIT ETHERS. original settings: sb_max = 1048576 udp_recvspace = 42080 udp_sendspace = 9216 tcp_recvspace = 16384 tcp_sendspace = 16384 The following settings has been applied: no -o sb_max=2097152 no -r -o sb_max=2097152 no -o udp_sendspace=65536 no -r -o udp_sendspace=65536 no -o udp_recvspace=65536 no -r -o udp_recvspace=65536 no -o tcp_recvspace=262144 no -r -o tcp_recvspace=262144 no -o tcp_sendspace=262144 no -r -o tcp_sendspace=262144 I was looking at setting up Etherchannel in our environment. Do you recon it is not worth doing it? What issue did you experience? Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kauffman, Tom Sent: Monday, July 17, 2006 3:59 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Network tuning question -- AIX to AIX We finally figured out that ehterchannel was not doing what we wanted last week, so we re-configured our gigabit ethernet adapters as individual adapters on six separate internal networks. Now I've run into another interesting observation. I can fire up one interface from a client system to my TSM server with the ftp process coverd in the tuning doc (from /dev/zero to /dev/null) and get 110 MB per second over the interface. If I then fire up the second interface on the same client to the TSM server -- I get 110 MB/sec as an aggregate; both interfaces run at 55 to 58 MB/sec. This is not a TSM server constraint; I can get all six interfaces running at 110 MB/sec if I run one process on each of six clients. So it's a client tuning issue -- and not a problem with input from /dev/zero, as these results mirror my TDP/R3 backups this weekend. Any suggestions on what knobs to tweak? Better yet, any suggestions on how to determine what resource constraint I'm hitting? I'm beating my way through the various redbooks that cover network tuning, but this can be time-consuming. TIA Tom Kauffman NIBCO, Inc CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Network tuning question -- AIX to AIX
Re: rfc1323, Yes you right... Setting this to 1 allows you to send big buffers. Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ben Bullock Sent: Tuesday, July 18, 2006 4:12 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Network tuning question -- AIX to AIX Those settings look good, but don't you also have to set this value rfc1323 = 1 so you can take advantage of TCP send and receive sizes larger than 64K? Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Van Den Berg Sent: Tuesday, July 18, 2006 7:07 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Network tuning question -- AIX to AIX Hi, I assume you are using TSM AIX. We have applied the following settings on AIX for our GIGABIT ETHERS. original settings: sb_max = 1048576 udp_recvspace = 42080 udp_sendspace = 9216 tcp_recvspace = 16384 tcp_sendspace = 16384 The following settings has been applied: no -o sb_max=2097152 no -r -o sb_max=2097152 no -o udp_sendspace=65536 no -r -o udp_sendspace=65536 no -o udp_recvspace=65536 no -r -o udp_recvspace=65536 no -o tcp_recvspace=262144 no -r -o tcp_recvspace=262144 no -o tcp_sendspace=262144 no -r -o tcp_sendspace=262144 I was looking at setting up Etherchannel in our environment. Do you recon it is not worth doing it? What issue did you experience? Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kauffman, Tom Sent: Monday, July 17, 2006 3:59 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Network tuning question -- AIX to AIX We finally figured out that ehterchannel was not doing what we wanted last week, so we re-configured our gigabit ethernet adapters as individual adapters on six separate internal networks. Now I've run into another interesting observation. I can fire up one interface from a client system to my TSM server with the ftp process coverd in the tuning doc (from /dev/zero to /dev/null) and get 110 MB per second over the interface. If I then fire up the second interface on the same client to the TSM server -- I get 110 MB/sec as an aggregate; both interfaces run at 55 to 58 MB/sec. This is not a TSM server constraint; I can get all six interfaces running at 110 MB/sec if I run one process on each of six clients. So it's a client tuning issue -- and not a problem with input from /dev/zero, as these results mirror my TDP/R3 backups this weekend. Any suggestions on what knobs to tweak? Better yet, any suggestions on how to determine what resource constraint I'm hitting? I'm beating my way through the various redbooks that cover network tuning, but this can be time-consuming. TIA Tom Kauffman NIBCO, Inc CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Network tuning question -- AIX to AIX
Re: rfc1323, Yes you right... Setting this to 1 allows you to send big buffers. no -o rfc1323=1#To apply the setting immediately no -r -o rfc1323=1 #To apply the setting after the next reboot. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ben Bullock Sent: Tuesday, July 18, 2006 4:12 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Network tuning question -- AIX to AIX Those settings look good, but don't you also have to set this value rfc1323 = 1 so you can take advantage of TCP send and receive sizes larger than 64K? Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Van Den Berg Sent: Tuesday, July 18, 2006 7:07 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Network tuning question -- AIX to AIX Hi, I assume you are using TSM AIX. We have applied the following settings on AIX for our GIGABIT ETHERS. original settings: sb_max = 1048576 udp_recvspace = 42080 udp_sendspace = 9216 tcp_recvspace = 16384 tcp_sendspace = 16384 The following settings has been applied: no -o sb_max=2097152 no -r -o sb_max=2097152 no -o udp_sendspace=65536 no -r -o udp_sendspace=65536 no -o udp_recvspace=65536 no -r -o udp_recvspace=65536 no -o tcp_recvspace=262144 no -r -o tcp_recvspace=262144 no -o tcp_sendspace=262144 no -r -o tcp_sendspace=262144 I was looking at setting up Etherchannel in our environment. Do you recon it is not worth doing it? What issue did you experience? Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kauffman, Tom Sent: Monday, July 17, 2006 3:59 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Network tuning question -- AIX to AIX We finally figured out that ehterchannel was not doing what we wanted last week, so we re-configured our gigabit ethernet adapters as individual adapters on six separate internal networks. Now I've run into another interesting observation. I can fire up one interface from a client system to my TSM server with the ftp process coverd in the tuning doc (from /dev/zero to /dev/null) and get 110 MB per second over the interface. If I then fire up the second interface on the same client to the TSM server -- I get 110 MB/sec as an aggregate; both interfaces run at 55 to 58 MB/sec. This is not a TSM server constraint; I can get all six interfaces running at 110 MB/sec if I run one process on each of six clients. So it's a client tuning issue -- and not a problem with input from /dev/zero, as these results mirror my TDP/R3 backups this weekend. Any suggestions on what knobs to tweak? Better yet, any suggestions on how to determine what resource constraint I'm hitting? I'm beating my way through the various redbooks that cover network tuning, but this can be time-consuming. TIA Tom Kauffman NIBCO, Inc CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message. Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: SQL2062N: Reason code =406
Check file permissions for your errorlog file... Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of zareyna Sent: Monday, July 10, 2006 11:14 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL2062N: Reason code =406 Hi all, Has anyone has ever countered this problem: SQL2062N An error occurred while accessing media /home/db2admin/sqllib/adsm/libtsm.a. Reason code: 406. Below are the steps that I have done: 1. Setup the environment variables as below DSMI_DIR=/usr/tivoli/tsm/client/api/bin64 DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt DSMI_LOG=/usr/tivoli/tsm/client/api/bin64 export DSMI_DIR DSMI_CONFIG DSMI_LOG 2. Copy the dsm.opt and dsm.sys in the /usr/tivoli/tsm/client/api/bin64 /usr/tivoli/tsm/client/api/bin64 # ls -l total 12168 -r 1 root system 108626 Jul 05 12:33 db2uext2.c -rwxrwxrwx 1 root system 763 Jul 10 16:27 dsm.opt -rw-r--r-- 1 root system 782 Sep 17 2005 dsm.opt.smp -rw--- 1 root system 1077 Jul 10 14:08 dsm.sys DSM.OPT SErvername TSM_Server1 DSM.SYS SErvername TSM_SERVER1 COMMMethod TCPip tcpport1500 TCPServeraddress 10.211.214.18 tcpclientaddress 10.211.214.11 passwordaccess generate schedmodeprompted NODENAME PRDDBLA1_DB2 3. Set db2 Userexit=YES, LOGRETAIN= YES 4. Backup database : Offline = SUCCESS 5. Backup database : Online= FAILED (receive the above error prompt: SQL2062N) Our database is DB 8.2.4 running on AIX 5.1 Is there any step that I have missed out? Thanks, Regards, Zareyna Salim Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Backup DB2 using TSM
Hi, No need to use user exits. DB2 Ver 8.2 and TSM 5.3 Read the Redbook sg246247 - Backup DB2 using TSM Chapter 5 Explain everything. We are using many DB2 databases using TSM to do the backups and writing the DB2 logs to TSM as well. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1711 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of zareyna Sent: Tuesday, July 04, 2006 12:09 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Backup DB2 using TSM Hi all, I'm quiet new to TSM and need your expert advice and view. Currently I'm trying to backup a db2 using TSM on the SAN. Base on the manual, there is one step where in need to compile the user exit. Is this step necessary especially on the compiling the file. I don't have the compiler. Thanks, Regards, Zareyna Salim Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: archive hangs
Hi, My settings for udp (send receive) are as follow (1GIG Network): udp_sendspace=65536 udp_recvspace=65536 The rest of the settings are the same. Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1694 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Levi, Ralph Sent: Tuesday, May 02, 2006 1:02 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] archive hangs In an attempt to tune our system (AIX 5.3, TSM 5.2.7) we changed the following AIX parameters and now several archive jobs tend to just die and hangout until they timeout. sb_max = 2097152 tcp_sendspace = 262144 tcp_recvspace = 262144 udp_sendspace = 131072 udp_recvspace = 131072 rfc1323= 1 We made these changes trying get to better throughput on our gig network. (we are now working on 2 problems at once). The gig nics are set to auto_negotiate since AIX does not have a 1000/full setting. The network folks say everything is clean from their end. I would like to resolve the hung condition first and then continue to address the gig speed issues. Does anyone have some ideas. I can remove the options I changed but on face value I believe they should be set like this. Any and all help is appreciated. Have a nice day everyone. Ralph Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: archive hangs
Hi Ralph, As Kurt said, 40Gig/Hour is about right. I have a schedule that kicks off 16 clients and I still get around 40Gig/hour. Database backups however do MUCH better. Regards, Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1694 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Levi, Ralph Sent: Tuesday, May 02, 2006 1:22 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] archive hangs Thanks Jacques. About how much data can you push over the gig network between Tivoli and one client. The best I ever do is about 40 GB an hour. Ralph -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jacques Van Den Berg Sent: Tuesday, May 02, 2006 7:17 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: archive hangs Hi, My settings for udp (send receive) are as follow (1GIG Network): udp_sendspace=65536 udp_recvspace=65536 The rest of the settings are the same. Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : 021 - 658 1694 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Levi, Ralph Sent: Tuesday, May 02, 2006 1:02 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] archive hangs In an attempt to tune our system (AIX 5.3, TSM 5.2.7) we changed the following AIX parameters and now several archive jobs tend to just die and hangout until they timeout. sb_max = 2097152 tcp_sendspace = 262144 tcp_recvspace = 262144 udp_sendspace = 131072 udp_recvspace = 131072 rfc1323= 1 We made these changes trying get to better throughput on our gig network. (we are now working on 2 problems at once). The gig nics are set to auto_negotiate since AIX does not have a 1000/full setting. The network folks say everything is clean from their end. I would like to resolve the hung condition first and then continue to address the gig speed issues. Does anyone have some ideas. I can remove the options I changed but on face value I believe they should be set like this. Any and all help is appreciated. Have a nice day everyone. Ralph Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
SQL2025N An I/O error -50 occurred on media TSM.
Hi, I had the above error last night on a DB2 backup. The error point to my CommTimeOut parameter which is currently set to 60. Can anyone give me an indication as to what is a good value for this parameter? q option I'm running TSM 5.3 on AIX 5.3 Thanks Jacques van den Berg TSM / SAP Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Tel : 021 - 658 1694 Fax : 021 - 658 1699 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
Re: Sanergy ?
Hi, If I can add my little bit. The TSM support guys from IBM talk us out of it. Support/Managing it is apparently quite a nightmare. Regards, Jacques van den Berg TSM / SAP-Storage Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Phone : 021-658 1694 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stef Coene Sent: Friday, March 03, 2006 10:52 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Sanergy ? Hi, I'm looking for some more information on how a TSM client can backup over the SAN to a disk based storage pool (from type FILE or DISK). The platform is AIX. Stef Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]
DB2 expire script for TSM
Hi all, I am looking for a script to expire my DB2 backups from TSM after 3 months. Does anyone have such a script? Regards, Jacques van den Berg Pick 'n Pay IT Email : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone : 021-658 1694 Mobile : 082 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED]