RE: Level 0 Archive Run Time Dramatically Increased

Eric, If you are seeing a significant number of writes during your level 0 backup, you may be encountering Informix bug #101062. 101062 ARCHIVE PERFORMANCE DEGRADATION WHEN MANY CALLS TO ARC_VERY_OLD_PAGE() If so, I recommend that you contact Informix Technical Support. Informix's Tech Info Center contains a description of this software defect. At last year's IWUC conference, users complained about a 10-fold increase in backup time when the ARC_VERY_OLD_PAGE routine was updating timestamps during backup processing. The Informix developers informed us that this issue had been addressed in the IDS release AFTER 9.2. Rick Bernstein ALARIS Medical Systems, Inc. -----Original Message----- From: Eric The Half A Bee [mailto:glynb@my-deja.com] Sent: Tuesday, January 18, 2000 2:49 AM To: informix-list@iiug.org Subject: Level 0 Archive Run Time Dramatically Increased In the last 2 working days we have experienced run times for our Level 0 Archive increasing from 15 minutes to some 75 minutes. We have checked the tape drive being used and all appears to be ok. There have been no mass data uploads in this period. In fact, we are unaware of any changes to the base data that may have caused such an increase in the Archive run time. Anyone out there got any ideas of what could have caused such a dramatic increase in the Level 0 run times ? We always run our Level 0 Archive with the engine in Quiescent mode - mainly because previously 15 minutes was acceptable. Needless to say, 75 minutes will not be! onstat -d output :- Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 1 days 02:06:45 -- 552960 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 8fc5413c 1 2 1 1 M informix rootdbs 8fc54b80 2 1 2 1 N informix plogdbs 8fc54c3c 3 1 3 1 N informix llogdbs 8fc54cf8 4 1 4 2 N informix maxdbs1 4 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname 8fc541f8 1 1 512 256000 254155 PO- /usr/informix/livechk1a 8fc542d4 1 1 512 256000 0 MO- /usr/informix/livechk3a 8fc54810 2 2 512 51712 459 PO- /usr/informix/livechk2a 8fc548ec 3 3 512 256512 459 PO- /usr/informix/livechk4a Informix Dynamic Server 7.31.UC2 SCO OpenServer 5.0.4 Regards Eric -- If it always works, why don't parachutists pull the emergency 'chute first? Sent via Deja.com http://www.deja.com/ Before you buy.