onbar too slow

Hi! We have a bunch of Solaris 9 Sparc servers running IDS 9.40. All of them are configured to do onbar backups to disk. Database are on external FC disks and backups images are going to internal disk of Sunfire v880. We have years running that configuration and every single backup has been fast enought. Storage mannager is ISM from the informix original installation. Now have my attention on one of that servers. They had suspended onbar months ago. Now, when I try to do a backup (onbar -b -L 0 dbspace) it takes a lot of time doing it. I checked disk activity with iostat and other admin tools, but everything seems Ok. Only diference I have noted is, they installed and use NetVault client to do another backups. Any of you can make me sugestions or coments about posible tunning of ISM, NSR, onbar, etc ? Thanks for your attention. --Nestor Gomez

9.40? I may be wrong but by that time there used to be an onbar bug commonly called 'Very Old Archive Page' that caused a very big slowdown on archives. It was related (IIR) with different rows versions (from the uncompleterd in-place alter). The work around was running a dummy update on those tables. Walter Milan DBA -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of nestor gomez munoz Sent: Thursday, November 20, 2008 8:17 PM To: ids@iiug.org Subject: onbar too slow [14078] Hi! We have a bunch of Solaris 9 Sparc servers running IDS 9.40. All of them are configured to do onbar backups to disk. Database are on external FC disks and backups images are going to internal disk of Sunfire v880. We have years running that configuration and every single backup has been fast enought. Storage mannager is ISM from the informix original installation. Now have my attention on one of that servers. They had suspended onbar months ago. Now, when I try to do a backup (onbar -b -L 0 dbspace) it takes a lot of time doing it. I checked disk activity with iostat and other admin tools, but everything seems Ok. Only diference I have noted is, they installed and use NetVault client to do another backups. Any of you can make me sugestions or coments about posible tunning of ISM, NSR, onbar, etc ? Thanks for your attention. --Nestor Gomez ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks for your answare, Walter. I follow your 'Very Old Archive Page' idea and found some comments about that. However, I made the test while doing a onbar backup, with onstat -g ath|grep arcbackup, then onstat -g stk <tid> and never found arc_very_old function. So, i'm suposed not to have that bug. thanks again. --Néstor El vie, 21-11-2008 a las 09:40 -0500, Walter Milan escribió: > 9.40? I may be wrong but by that time there used to be an onbar bug commonly > called 'Very Old Archive Page' that caused a very big slowdown on archives. It > was related (IIR) with different rows versions (from the uncompleterd in-place > alter). The work around was running a dummy update on those tables. > > Walter Milan > DBA > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of nestor > gomez munoz > Sent: Thursday, November 20, 2008 8:17 PM > To: ids@iiug.org > Subject: onbar too slow [14078] > > Hi! > We have a bunch of Solaris 9 Sparc servers running IDS 9.40. All of them > are configured to do onbar backups to disk. Database are on external FC > disks and backups images are going to internal disk of Sunfire v880. > We have years running that configuration and every single backup has > been fast enought. Storage mannager is ISM from the informix original > installation. > > Now have my attention on one of that servers. They had suspended onbar > months ago. Now, when I try to do a backup (onbar -b -L 0 dbspace) it > takes a lot of time doing it. I checked disk activity with iostat and > other admin tools, but everything seems Ok. > Only diference I have noted is, they installed and use NetVault client > to do another backups. > > Any of you can make me sugestions or coments about posible tunning of > ISM, NSR, onbar, etc ? > Thanks for your attention. > --Nestor Gomez > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >