Ok W2K DB2 v8.1 fix pack 5.

On production I took a an online backup of production and copied it
over to my staging environment.
restored the production database on top of staging database redirect.
I copied over all the log files from production box to a temp
directory.

restore was complete with redirect and staging went into roll forward
pending.

RAN:
db2 rollforward db staging to end of logs com complete overflow log
path (d:\temp\logs)
got the following error
SQL1276N Database "WSWSTAGE" cannot be brought out of rollforward
pending
state until roll-forward has passed a point in time greater than or
equal to
"2004-09-30-14.58.53.000000", because node "0" contains information
later than
the specified time.
RAN:
db2 rollforward db staging query status

Rollforward Status

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

Node number = 0
Rollforward status = DB working
Next log file to be read = S0103402.LOG
Log files processed = -
Last committed transaction = 2004-09-25-18.16.23.000000

can not rollforward complete and that log file is in the temp\logs
directory.

Any one have any idea why this would happen and what I could do to get
back my database.

ragingpug@yahoo.com (Steven) wrote in message news:<1089028b.0409300859.7e18fc33@posting.google. com>...
> Ok W2K DB2 v8.1 fix pack 5.
>
> On production I took a an online backup of production and copied it
> over to my staging environment.
> restored the production database on top of staging database redirect.
> I copied over all the log files from production box to a temp
> directory.
>
> restore was complete with redirect and staging went into roll forward
> pending.
>
> RAN:
> db2 rollforward db staging to end of logs com complete overflow log
> path (d:\temp\logs)
> got the following error
> SQL1276N Database "WSWSTAGE" cannot be brought out of rollforward
> pending
> state until roll-forward has passed a point in time greater than or
> equal to
> "2004-09-30-14.58.53.000000", because node "0" contains information
> later than
> the specified time.
> RAN:
> db2 rollforward db staging query status
>
> Rollforward Status
>
> Input database alias = wswstage
> Number of nodes have returned status = 1
>
> Node number = 0
> Rollforward status = DB working
> Next log file to be read = S0103402.LOG
> Log files processed = -
> Last committed transaction = 2004-09-25-18.16.23.000000
>
> can not rollforward complete and that log file is in the temp\logs
> directory.
>
> Any one have any idea why this would happen and what I could do to get
> back my database.

Y need to copy all the active log to your local directory also..