After restoring a DB to the 2nd most recent online backup without rolling
forward, I then tried to roll it forward to a point in time prior to the
most recent backup. When I issue the db2 "rollforward..." command I get...

SQL1261N Database "mtrixprd" is not in rollforward pending state on node(s)
"0", so it does not need to be rolled forward on these nodes.

How can the database not be in rollforward pending state if I specified
"without rolling forward" on the restore command? Here are the commands used
during this test.

db2 backup database MTRIXPRD online load $SSPRODIR/lib/libbexdb2-shared.a
open 2 sessions <<<- taken at 20040820153337
[transactions entered]
db2 "backup database MTRIXPRD online load $SSPRODIR/lib/libbexdb2-shared.a
open 2 sessions"
[additional transactions entered]
db2 force applications all
db2 deactivate db MTRIXPRD
db2 restore database MTRIXPRD load $SSPRODIR/lib/libbexdb2-shared.a open 2
sessions taken at 20040820153337 without rolling forward
db2 "rollforward db MTRIXPRD to 2004-08-23.08.00.00 using local time and
complete"


DB2 & UDB email list listserv db2-l LazyDBA home page