Unable to rollforward the database after complete ...

Former Member · ‎2013 Apr 09

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 · ‎2013 Apr 15

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.