SQL 1042c - unexpected system error occurred with rollforward recovery

[Michelle]

Hi,

I'm trying to rollforward my database to end of logs and complete, the
first error message i get is - SQL6063N rollforward recovery on
database X has stopped on node "0" due to change in log file size,
when i re-issue the command I get the " unexpected system error
occured"

I also dropped the db and restored it again, but still getting the
same errors.

Can anyone help?
Thanks
Michelle

[Blair Adamache]

Can you restore an offline backup of the database?

Michelle wrote:

Hi,

I'm trying to rollforward my database to end of logs and complete, the
first error message i get is - SQL6063N rollforward recovery on
database X has stopped on node "0" due to change in log file size,
when i re-issue the command I get the " unexpected system error
occured"

I also dropped the db and restored it again, but still getting the
same errors.

Can anyone help?
Thanks
Michelle

[Michelle]

Hi Blair,

No I can't restore an offline backup as I don't have any!
Any suggestions? Even how this was caused?

Thanks
michelle
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<c5**********@hanover.torolab.ibm.com>...

Can you restore an offline backup of the database?

Michelle wrote:

Hi,

I'm trying to rollforward my database to end of logs and complete, the
first error message i get is - SQL6063N rollforward recovery on
database X has stopped on node "0" due to change in log file size,
when i re-issue the command I get the " unexpected system error
occured"

I also dropped the db and restored it again, but still getting the
same errors.

Can anyone help?
Thanks
Michelle

[Burkhard Schultheis]

Michelle schrieb:

No I can't restore an offline backup as I don't have any!
Any suggestions? Even how this was caused?

Look at sqllib/db2dump/db2diag.log. We had this error, too. It was
caused by an online backup. Since the start of the online backup logging
was not made. I restored from old ixf files. See
<c4*************@ID-100086.news.uni-berlin.de> and
<c4*************@ID-100086.news.uni-berlin.de>.

Regards,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: [phone], Fax: [phone]