Nov 23, 2012 at 10:33 AM

SAP not starting up after restart

414 Views

Dear all,

I am facing a issue that i cant start DB after restart.Un fortunately OS guys changed IP Again i changed to old IP. If i stsrat DB manually it is coming up ..

Checking required environment variables

R3trans -d:
SQL1063N DB2START processing was successful.
Database activated
R3trans connect failed
This is R3trans version 6.22 (release 720 - 26.10.11 - 13:00:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'KSM'"
R3trans finished (0012)

DB log:

DB2INSTANCE is >db2ksm<
DB2DBDFT is >KSM<

------------------------------ Fri Nov 23 15:51:32 IST 2012
Connect to the database to check the database state:

R3trans check finished with return code: 12
There is no database connect possible -
Database is probably already stopped.

Trans.log:
4 ETW000 [ dev trc,00000] Info: successfully loaded DB2 library '/usr/sap/KSM/SYS/global/db6/LINUXX86_64/db6_clidriver/lib/libdb2.so'
4 ETW000 45 0.024611
4 ETW000 [ dev trc,00000] Running with UTF-8 Unicode 16 0.024627
4 ETW000 [ dev trc,00000] Running with CLI driver. 3632 0.028259
4 ETW000 [ dev trc,00000] Fri Nov 23 15:37:11 2012 667365 0.695624
4 ETW000 [ dev trc,00000] *** ERROR in DB6Connect[dbdb6.c, 1802] CON = 0 (BEGIN) 21 0.695645
4 ETW000 [ dev trc,00000] &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication
4 ETW000 28 0.695673
4 ETW000 [ dev trc,00000] &+ protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "
4 ETW000 22 0.695695
4 ETW000 [ dev trc,00000] &+ 0.0.0.0". Communication function detecting the error: "connect". Protocol specific error code(s): "111", "*", "*
4 ETW000 21 0.695716
4 ETW000 [ dev trc,00000] &+ ". SQLSTATE=08001
4 ETW000 22 0.695738
4 ETW000 [ dev trc,00000] &+
4 ETW000 22 0.695760
4 ETW000 [ dev trc,00000] &+
4 ETW000 24 0.695784
4 ETW000 [ dev trc,00000] &+

4 ETW000 41 0.695825
4 ETW000 [ dev trc,00000] *** ERROR in DB6Connect[dbdb6.c, 1802] (END) 16 0.695841
4 ETW000 [ dbdb6.c ,00000] *** ERROR => DbSlConnect to 'KSM' as 'sapksm' failed 68 0.695909
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'KSM'"
107,2 95%

Thanks,
Thamodaran