> I am running DB2 v7.2 on AIX. It is an OLTP system. We have a batch > job that copies the production database and does a restore/roll > forward to create a report database. The problem is when the > roll-forward step of the job is running, other applications lose > thier connection to the server (ATM machines, etc.).
OK, let me show you a moment from the future. Someday your OLTP server will die and be down for hours to days. At that moment you will go flip a switch and put an exact twin to this machine in operation and it will have an up to the minute copy of your database. As the twin machine will share zero hardware with your production server it will not be down at the same time. Your total unexpected downtime will be 5 to 10 minutes, depending on human factors. What will that twin machine have been doing all this time? Running your reports and extracting data for other users. How will it be kept up to date on your live database? Replication. What do you need to do now? Practice the speach to your boss. "Boss, we have partners and customers who depend on our systems being available all the time. All it will take is one hour of downtime during the middle of the day and we'll fold..." -HJC - ::: 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
