DB2 Roll Forward

[BrianTyler]

Hi,

Our DBA has just left, so we are very short of expertise at the moment.

We run DB2 v8 on AIX.

Each evening, we copy the logfiles to the disaster recovery machine (about 100 logs) and 'roll forward to end of logs'. This seems to work OK.

At period end, we copy the logs as usual, but 'roll forward to a local time'.

This gives an error message, implying that you cannot mix the two types of roll-forward.

This does not seem logical, so I am wondering where to look for the solution required.

Any help would be useful

Brian

 

[BrianTyler]

The first command is the roll forward he did - it failed, but I don't have the error message.

The 2nd command shows what it rolled forward to after the complete - the time is 1 hour different - as expected.

=============================================================
db2 rollforward db cbsdwhps to 2006-09-30-22.30.00.000000 using local time
=============================================================
55ADEVB2DWHP> db2 "ROLLFORWARD DB CBSDWHPS COMPLETE "

Rollforward Status

Input database alias = CBSDWHPS
Number of nodes have returned status = 1

Node number = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = S0101190.LOG - S0102486.LOG
Last committed transaction = 2006-09-30-21.23.12.000000

DB20000I The ROLLFORWARD command completed successfully.

 

[sathyarams]

That may show the CUT (Co-ordinated Universal Time) or GMT ... If you are here in UK, this makes sense to me, as we are in the summer time ...

Sathyaram



For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp