Greetings.
I am trying to restore a copy of our production database onto a
development server.

I have been backing up my database using the following command for many
months.

db2 "backup database wwaccpac online to usr/db2bups without prompting"

and doing restores on another server using a different dbname using the
following commands;

> db2 restore database WWACCPAC from /var/bups into devacc without
prompting

> db2 rollforward database devacc to end of logs and stop

This worked fine (granted I only did a restore once).

A little while ago I changed one of the tablespaces (temp) as it was
getting full. I then went and tried to do a restore and got told that I
need to defince tablespaces. I did this using the following commands.

db2 restore database WWACCPAC from /var/bups into devacc redirect
without prompting

db2 "set tablespace containers for 0 using (path '/home/db2/tspace0')"
db2 "set tablespace containers for 2 using (path '/home/db2/tspace2')"
db2 "set tablespace containers for 3 using (file
'/home/db2/tspace3/tempspace' 1000)"

db2 restore db wwaccpac continue

Everything works fine... but when I go to execute;


> db2 rollforward database devacc to end of logs and stop

I get this returned

SQL4970N Roll-forward recovery on database "WWACCPAC" cannot reach the
specified stop point (end-of-log or point-in-time) because of missing log
file(s) on node(s) "0".


I understand what this problem is, but not sure how to fix it. Do i have
to copy the log files over from my production machine ?? I have
included a dump of what db2diag.log is saying for your information.

Thanks
Ben


2003-08-19-16.29.24.981617 Instance:db2 Node:000
PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062924
base sys utilities sqleFirstConnect Probe:100

DiagData
a3fb ffff ....

2003-08-19-16.29.25.046360 Instance:db2 Node:000
PID:1982(db2agent (idle)) TID:8192 Appid:*LOCAL.db2.030A69062924
base sys utilities sqlelost Probe:40

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBA3".

2003-08-19-16.29.25.372944 Instance:db2 Node:000
PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
data protection sqlufrol Probe:980 Database:WWACCPAC

ADM1602W Rollforward recovery has been initiated.

2003-08-19-16.29.25.460904 Instance:db2 Node:000
PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
data protection sqlufrol Probe:1210 Database:WWACCPAC

ADM1603I DB2 is invoking the forward phase of the database rollforward
recovery.

2003-08-19-16.29.25.494756 Instance:db2 Node:000
PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
recovery manager sqlpForwardRecovery Probe:720 Database:WWACCPAC

Invoking database rollforward forward recovery,
lowtranlsn 00000000ACE1E152 minbufflsn 00000000ACE1E152

2003-08-19-16.29.25.574882 Instance:db2 Node:000
PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
recovery manager sqlprecm Probe:125 Database:WWACCPAC

Using parallel recovery with 3 agents 3 QSets 21 queues and 2 chunks


2003-08-19-16.29.25.689482 Instance:db2 Node:000
PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
recovery manager sqlprDoForwardPhase Probe:770 Database:WWACCPAC

Rollforward is not able to reach the end of online backup timestamp

2003-08-19-16.29.25.759068 Instance:db2 Node:000
PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
recovery manager sqlpForwardRecovery Probe:1230 Database:WWACCPAC

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x801000BB".

2003-08-19-16.29.25.803514 Instance:db2 Node:000
PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
data protection sqlufrol Probe:8180 Database:WWACCPAC

ADM1611W The rollforward recovery phase has been completed.

Benjamin Stewart wrote:

> Greetings.
> I am trying to restore a copy of our production database onto a
> development server.
>
> I have been backing up my database using the following command for many
> months.
>
> db2 "backup database wwaccpac online to usr/db2bups without prompting"
>
> and doing restores on another server using a different dbname using the
> following commands;
>
> > db2 restore database WWACCPAC from /var/bups into devacc without
> prompting
>
> > db2 rollforward database devacc to end of logs and stop
>
> This worked fine (granted I only did a restore once).
>
> A little while ago I changed one of the tablespaces (temp) as it was
> getting full. I then went and tried to do a restore and got told that I
> need to defince tablespaces.

When you do restore this time, where does the backup file come from? If it is
the same one as the first time, or it is from production system. Then you
need copy all the active/archived log files from production system. (I think
you know which log files you need to copy.)

> I did this using the following commands.
>
> db2 restore database WWACCPAC from /var/bups into devacc redirect
> without prompting
>
> db2 "set tablespace containers for 0 using (path '/home/db2/tspace0')"
> db2 "set tablespace containers for 2 using (path '/home/db2/tspace2')"
> db2 "set tablespace containers for 3 using (file
> '/home/db2/tspace3/tempspace' 1000)"
>
> db2 restore db wwaccpac continue
>
> Everything works fine... but when I go to execute;
>
> > db2 rollforward database devacc to end of logs and stop
>
> I get this returned
>
> SQL4970N Roll-forward recovery on database "WWACCPAC" cannot reach the
> specified stop point (end-of-log or point-in-time) because of missing log
> file(s) on node(s) "0".
>
> I understand what this problem is, but not sure how to fix it. Do i have
> to copy the log files over from my production machine ?? I have
> included a dump of what db2diag.log is saying for your information.
>
> Thanks
> Ben
>
> 2003-08-19-16.29.24.981617 Instance:db2 Node:000
> PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062924
> base sys utilities sqleFirstConnect Probe:100
>
> DiagData
> a3fb ffff ....
>
> 2003-08-19-16.29.25.046360 Instance:db2 Node:000
> PID:1982(db2agent (idle)) TID:8192 Appid:*LOCAL.db2.030A69062924
> base sys utilities sqlelost Probe:40
>
> DIA0001E An internal error occurred. Report the following error code :
> "ZRC=0xFFFFFBA3".
>
> 2003-08-19-16.29.25.372944 Instance:db2 Node:000
> PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
> data protection sqlufrol Probe:980 Database:WWACCPAC
>
> ADM1602W Rollforward recovery has been initiated.
>
> 2003-08-19-16.29.25.460904 Instance:db2 Node:000
> PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
> data protection sqlufrol Probe:1210 Database:WWACCPAC
>
> ADM1603I DB2 is invoking the forward phase of the database rollforward
> recovery.
>
> 2003-08-19-16.29.25.494756 Instance:db2 Node:000
> PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
> recovery manager sqlpForwardRecovery Probe:720 Database:WWACCPAC
>
> Invoking database rollforward forward recovery,
> lowtranlsn 00000000ACE1E152 minbufflsn 00000000ACE1E152
>
> 2003-08-19-16.29.25.574882 Instance:db2 Node:000
> PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
> recovery manager sqlprecm Probe:125 Database:WWACCPAC
>
> Using parallel recovery with 3 agents 3 QSets 21 queues and 2 chunks
>
> 2003-08-19-16.29.25.689482 Instance:db2 Node:000
> PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
> recovery manager sqlprDoForwardPhase Probe:770 Database:WWACCPAC
>
> Rollforward is not able to reach the end of online backup timestamp
>
> 2003-08-19-16.29.25.759068 Instance:db2 Node:000
> PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
> recovery manager sqlpForwardRecovery Probe:1230 Database:WWACCPAC
>
> DIA0001E An internal error occurred. Report the following error code :
> "ZRC=0x801000BB".
>
> 2003-08-19-16.29.25.803514 Instance:db2 Node:000
> PID:1982(db2agent (WWACCPAC)) TID:8192 Appid:*LOCAL.db2.030A69062925
> data protection sqlufrol Probe:8180 Database:WWACCPAC
>
> ADM1611W The rollforward recovery phase has been completed.