I set up a hot backup database a few years ago that used multiple roll
forwards. Now this goes back to V4.1 so you may have to validate this on
current versions. But what I did was backed up a database and FTP'ed the
backup to a different server where it was restored. Then I installed the
USEREXIT on the database to handle the log archive. The userexit basically
FTP'ed the log file from the server to the hot backup where the backup
resided.
Like you we did not want the time to activate the hot backup to include
rolling forward all the logs. So every hour I scripted the command to
rollforward the database to end of logs. I DID NOT USE THE "AND STOP"
clause. When we finally needed to activate our hot backup, we issued the
"roll forward ... to end of logs and stop". This activated our hot backup
and effectively ended the relationship between the two databases. After we
corrected whatever problem on the main server that caused us to use the hot
backup, we backed up the database again, and started the entire process all
over again.
Liek I said I built this is a V4.1 environment and have not tried it since.
But I'll bet money it still works. It should also be easy to try.
> -----Original Message-----
> From: Bruce Allen [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 6:30 AM
> To: [EMAIL PROTECTED]
> Subject: DB2EUG: Multiple Roll Forward runs
>
> Hi All,
> We are testing Roll forward recovery on AIX using DB2 V6. The complication
> is we will have many Gb of logs to process, but not enough log space to
> fit them all on. We are using TSM (old ADSM) to backup the database, and
> the logs after the logs have been archived to disk.
>
> The manuals all talk about a single roll forward (and rerunning for log
> errors), but we are wanting to do multiple roll forward operations; viz.
> use say 2 areas on disk and have TSM writing to one are while the other
> area is being read by the Roll Forward. The next roll forward uses the
> other area, and so on until all of the logs are processed.
>
> I have not found anything in the manual to say it can or can not be done.
> Any thoughts? Is anyone using TSM to archive the logs (db2uext2.cadsm)?
> Does it take TSM long to retireve the log file for for roll forward?
>
> Thanks,
> Bruce Allen
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
