SQLSTATE=58004 on rollforward

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JDb2 - 20 Dec 2004 08:55 GMT

Hi there..
we had a disaster on our Raid configuration running our DB2 (UDB
7.2.5).
We used Tivoli to get our data backup and we had restore succesfully 17
of 18 db.
We have problem only on the last one :

on rollforward we get this error:

SQL1042C An unexpected system error occurred. SQLSTATE=58004
any hints will be appreciated.

thanks anyway

M.

Reply to this Message

dotyet - 20 Dec 2004 14:20 GMT

i suggest you do the following as well (in addition to what you have
already done):

increase the verbosity of the database instance to level 4 -> diaglevel
4
have a close look at the messages appearing in the diagnostic log file
-> db2diag.log
it may give you some indication in plain english as to what is causing
this system error.

you can post some log output here also, so that others can have a look
at it and try to help.

regards,
dotyet

> Hi there..
> we had a disaster on our Raid configuration running our DB2 (UDB
[quoted text clipped - 11 lines]
>
> M.

Reply to this Message

michele.trimarchi@gmail.com - 21 Dec 2004 13:14 GMT

thanks for your reply.
finally we resolved our problem..
there was not enough memory to process the rollforward, so we tried the
operation on another server and everything worked correctly.
thanks again

JDb2

Reply to this Message

JDb2 - 23 Dec 2004 10:47 GMT

> i suggest you do the following as well (in addition to what you have
> already done):
[quoted text clipped - 11 lines]
> regards,
> dotyet

thank you dotyet for your answer(diaglevel 4).
we resolved our problem simply doing rollforward operazion on another
server with more free memory.

thanks again
JDb2

Reply to this Message