The without rolling forward option states that you don't want to roll
forward at all. Try the restore command again and leave that option out
and then issue your rollforward command .

Mark




|---------+--------------------------------------------------------->
| | "Chuck Hamilton " |
| | <db2udbdba-ezmlmshield-x46007775.[Email Address Removed] | azydba.com> |
| | |
| | 08/23/2004 11:19 AM |
| | |
|---------+--------------------------------------------------------->
>----------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: Rollforward Pending |
>----------------------------------------------------------------------------------------------|




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"



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







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