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
