SQLSTATE=58004 on rollforward

[JDb2]

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.

[dotyet]

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

JDb2 wrote:

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.

[michele.trimarchi]

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

[JDb2]

> 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

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