Marty, I haven't had this problem. However, if you want to prove that it is down to the log being closed, there is a registry variable. Have a look at the v7.2 manuals and it is fairly obvious - but its name escapes me at the moment.
If you can't find it, let me know. Regards, Jeremy "Killen, Martin W - CNF" wrote: > Hi Listers, > > We have a situation where our shop requires 7 X 24 access. We have been > running for over a year with on-line backups running daily. The > applications folks have been noticing a slow down during the last 5 minutes > of the backups. The applications folks have noticed that on some occasions > it takes 25 seconds for one open cursor statement. We believe that this is > being caused by the Active log being closed and written to disk. The > concern is that for those 5 minutes the accesses to the tables slows down > considerably and causes a backlog of requests. We have found an issue with > one set of the SQL and are creating an index to support this access. We > have also talked about reducing the size of our logs to speed up the close > and write. Currently we have logfile_sz set to 2000. Has anyone else > experienced this type of slow down at the end of their on-line backups? If > so, what if anything did you do to alleviate the problems. TIA.. > > Marty Killen > Sr. DB2 DBA > CNF Inc. > 503-450-2681 > [EMAIL PROTECTED] > IBM Certified Solutions Expert > DB2 UDB V7.1 Database Administration for OS/390 > DB2 UDB V7.1 Database Administration for > UNIX, Windows & OS/2 > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
