[ashleytn]

SQL1266N Database "TEST" has been rolled forward to
"2106-02-06-06.28.15.000000", which is past the specified point-in-time.

db2 => rollforward database TEST to 2106-02-06-06.28.15.000000 and stop

************************************************** ****
I got this error. any ideas? thanks

SQL1262N The point-in-time specified for rolling forward database "test" is
not valid.

[Osias Correa]

You should try issuing this command as it is the last commited transaction you'd have,

db2 => rollforward database TEST to 2001-12-04-19.39.07.00 and stop

since it is in this following warning message

SQL1266N Database "TEST" has been rolled forward to
"2106-02-06-06.28.15.000000", which is past the specified point-in-time.
Rollforward Status

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

Node number = 0
Rollforward status = DB working
Next log file to be read = S0000003.LOG
Log files processed = -
Last committed transaction = 2001-12-04-19.39.07.000000

[cchattoraj]

I'm not sure I understand what the timestamp is (I am aware that it is CUT) - why are you trying to rollforward to the year 2106?

If you are trying to determine the minimum point in time to rollforward to, specify a date before the backup - the database will return the minimum point in time to rollforward to. Use that timestamp in the rollforward command. Or if you want to rollforward through all logs, then specify that - ie rollforward database <dbname> to the end of logs and stop <<-- check syntax in manual.