FW: Slow Informix backups every 8 days?
Anyone else care to pitch in an Informix opinion? It would much appreciated. It is obvious to me that TSM is not the booger here, but somehow it keeps ending up in my court. Too bad it's not Night Court, I'd send in Bull Shannon... -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 6:44 PM To: Bell, Charles (Chip) Subject: Re: Slow Informix backups every 8 days? On Apr 19, 2006, at 1:04 PM, Bell, Charles ((Chip)) wrote: > What can I gather from this? > > START_TIME: 2006-04-19 01:00:53.00 > END_TIME: 2006-04-19 04:27:26.00 > ACTIVITY: BACKUP > NUMBER: 1917621 > ENTITY: INFORMIX_PHAR > COMMMETH: Tcp/Ip > ADDRESS: 10.10.154.19:54898 >SCHEDULE_NAME: PHAR_INFORMIX_NIGHTLY > EXAMINED: 0 > AFFECTED: 1 > FAILED: 0 >BYTES: 18896547851 > IDLE: 0 > MEDIAW: 0 >PROCESSES: 1 > SUCCESSFUL: YES > VOLUME_NAME: > DRIVE_NAME: > LIBRARY_NAME: > LAST_USE: >COMM_WAIT: 12352 > NUM_OFFSITE_VOLS: Chip - That's a whopping communications wait... where the server spent waiting 3.4 hours for the client to speak. This is making me suspect that the Informix side of the middleware involved in the backup is blocked by Informix, possibly due to a held lock in the Informix database or the like. You may want to use some combination of lsof and truss commands to see what's going on there. I'm disappointed that no Informix customers have chimed in, as they have expertise in that area, where I've had no experience. Richard - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Re: Slow Informix backups every 8 days?
It happened again this morning, but this time one day earlier. No shortcoming from the TSM server side. Why do I get all of the goofy stuff? :^) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Tuesday, April 18, 2006 11:34 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Slow Informix backups every 8 days? Chip - This is a case where the server records need to be examined. Look in the TSM server Activity Log for what's happening during that period, and review the TSM accounting records for the recorded wait time values. If need be, perform Query SEssion during the backups to see what clients may be waiting on (drives, volumes, etc.). Just looking at the client side of things gives you only half the story. Richard Sims - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Re: Slow Informix backups every 8 days?
Chip - This is a case where the server records need to be examined. Look in the TSM server Activity Log for what's happening during that period, and review the TSM accounting records for the recorded wait time values. If need be, perform Query SEssion during the backups to see what clients may be waiting on (drives, volumes, etc.). Just looking at the client side of things gives you only half the story. Richard Sims
Re: Slow Informix backups every 8 days?
364 Completed backup logical log 10863. 2006-04-12 00:57:10 16888 18364 /digi/informix/bin/onbar_d: process exit 0 (0x 00) 2006-04-12 01:22:44 34224 19658 Completed level 0 backup test_dbs. 2006-04-12 01:22:47 34224 19658 Process 34224 19658 completed. 2006-04-12 02:19:50 34250 23246 /digi/informix/bin/onbar_d -l 2006-04-12 02:19:50 34250 23246 Begin backup logical log 10864. 2006-04-12 02:19:50 34250 23246 Successfully connected to Storage Manager. 2006-04-12 02:19:56 34250 23246 Completed backup logical log 10864. 2006-04-12 02:19:56 34250 23246 /digi/informix/bin/onbar_d: process exit 0 (0x 00) 2006-04-12 04:11:26 21288 19658 Completed level 0 backup prod_dbs. 2006-04-12 04:11:27 21288 19658 Process 21288 19658 completed. 2006-04-12 04:11:27 19658 34038 Begin backup logical log 10865. 2006-04-12 04:11:27 19658 34038 Successfully connected to Storage Manager. 2006-04-12 04:11:28 19194 11898 /digi/informix/bin/onbar_d -l 2006-04-12 04:11:29 19194 11898 WARNING: A log backup is already running. Can' t start another. 2006-04-12 04:11:32 19658 34038 Completed backup logical log 10865. 2006-04-12 04:11:32 19658 34038 /digi/informix/bin/onbar_d: process exit 0 (0x 00) 2006-04-12 04:11:34 19194 11898 /digi/informix/bin/onbar_d: process exit 152 ( 0x98) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Alexander Verkooijen Sent: Tuesday, April 18, 2006 4:34 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Slow Informix backups every 8 days? I do not claim to have any knowledge of Informix but the behaviour you describe suggests that you use a backup schema of a full backup every 8 days and incrementals/differentials on the other 7 days. Just guessing... Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing & Networking Services > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Bell, Charles (Chip) > Sent: maandag 17 april 2006 16:45 > To: ADSM-L@VM.MARIST.EDU > Subject: Slow Informix backups every 8 days? > > Client OS AIX 4.3.3 > > Informix Dynamic Server Version 7.31.UD4 > > TDP for Informix v4.1.3 TSM v5.1.5 > > > > Why would the client back up in a way that is considered normal (45 > mins. to 1 hr), but every 8th day take well over 3 hrs? Has > anyone seen > this happen every 'x'th day at their site? > > > > God bless you!!! > > Chip Bell > Network Engineer I > IBM Tivoli Certified Deployment Professional (ITSM 5.2) > Baptist Health System > Birmingham, AL > Office (205) 715-5106 > Pager (205) 817-0357 > Home (256) 739-0947 > > > > > > > - > Confidentiality Notice: > The information contained in this email message is privileged and > confidential information and intended only for the use of the > individual or entity named in the address. If you are not the > intended recipient, you are hereby notified that any dissemination, > distribution, or copying of this information is strictly > prohibited. If you received this information in error, please > notify the sender and delete this information from your computer > and retain no copies of any of this information. > > - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Re: Slow Informix backups every 8 days?
I do not claim to have any knowledge of Informix but the behaviour you describe suggests that you use a backup schema of a full backup every 8 days and incrementals/differentials on the other 7 days. Just guessing... Regards, Alexander Alexander Verkooijen Senior Systems Programmer High Performance Computing SARA Computing & Networking Services > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Bell, Charles (Chip) > Sent: maandag 17 april 2006 16:45 > To: ADSM-L@VM.MARIST.EDU > Subject: Slow Informix backups every 8 days? > > Client OS AIX 4.3.3 > > Informix Dynamic Server Version 7.31.UD4 > > TDP for Informix v4.1.3 TSM v5.1.5 > > > > Why would the client back up in a way that is considered normal (45 > mins. to 1 hr), but every 8th day take well over 3 hrs? Has > anyone seen > this happen every 'x'th day at their site? > > > > God bless you!!! > > Chip Bell > Network Engineer I > IBM Tivoli Certified Deployment Professional (ITSM 5.2) > Baptist Health System > Birmingham, AL > Office (205) 715-5106 > Pager (205) 817-0357 > Home (256) 739-0947 > > > > > > > - > Confidentiality Notice: > The information contained in this email message is privileged and > confidential information and intended only for the use of the > individual or entity named in the address. If you are not the > intended recipient, you are hereby notified that any dissemination, > distribution, or copying of this information is strictly > prohibited. If you received this information in error, please > notify the sender and delete this information from your computer > and retain no copies of any of this information. > >
Slow Informix backups every 8 days?
Client OS AIX 4.3.3 Informix Dynamic Server Version 7.31.UD4 TDP for Informix v4.1.3 TSM v5.1.5 Why would the client back up in a way that is considered normal (45 mins. to 1 hr), but every 8th day take well over 3 hrs? Has anyone seen this happen every 'x'th day at their site? God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional (ITSM 5.2) Baptist Health System Birmingham, AL Office (205) 715-5106 Pager (205) 817-0357 Home (256) 739-0947 - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.