Unable to rollforward the database after complete ...

Former Member · ‎04-09-2013

Dear Friends,

I've restored the DB with its log file to an other server. Since, roll-forwarding was to be completed, I had use the following commands for the same:

db2 rollforward db KJP complete

db2 rollforward db KJP to end of logs and complete.

But after hitting the above commands, it displays an error, i.e.:

db2kjp 83> db2 rollforward db KJP complete

SQL1042C An unexpected system error occurred. SQLSTATE=58004

db2kjp 84> db2 rollforward db KJP to end of logs and complete

SQL1042C An unexpected system error occurred. SQLSTATE=58004.

I'm unable to rectify the same problem and hence, unable to start the SAP services too. Please, suggest what should I do.

trans.log for the same:

:kjpadm 66> tail trans.log

4 ETW000 [dev trc ,00000] &+

4 ETW000 32 0.064430

4 ETW000 [dev trc ,00000] &+

4 ETW000 31 0.064461

4 ETW000 [dev trc ,00000] &+

4 ETW000 31 0.064492

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1700] (END) 18 0.064510

4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'KJP' as 'sapkjp' failed

4 ETW000 100 0.064610

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'KJP'".

Regards,

Deepesh.

Former Member · ‎04-15-2013

Dear Friends,

Pls suggest, how to overcome this rollforward situation, its very urgent.

Regards,

Deepesh

Unable to rollforward the database after complete restoration of DB with its archlogs.