on 11-23-2012 10:33 AM
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
Hi,
For these errors, could you please refer to the followings to see if
these could be helpful for this issue:
1,The remote database server has not been cataloged correctly at the
client. Pls ensure the host entries are cataloged correctly.
2,The database manager configuration file at the server has not been
configured properly with the proper communication parameters. Pls
check the SVCENAME database manager configuration parameter,
the TCP/IP service name or port number is unique.
If database manager configuration parameters have been updated
at the server, the database manager must be stopped for the changes
to take effect. There might be a mismatch between the TCP/IP service
name or port number specified on the server and on the client.
Ensure the service name maps to the correct port number by checking
the services file. You can check this by reading the services file
or checking the output from running the command "netstat -a".
3,A firewall at the remote database server has prevented the connection
from being established. Verify that the firewall is properly
configured to accept connection requests from the client.
4,The DB2COMM environment variable at the server does not specify the
communication protocol used by the client. Check that TCPIP has been
specified. Issue db2set to see what has already been set. Run the
command "db2set DB2COMM = TCPIP" to set the value.
5,Network failure, contact your network team. You can try a test
with SAP tool niping as note 500235.
6. note 1364372
Regards, Premsukh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please read below link:
all the commands are listed in notes.
For the error SQL30081N with RC 79 check the following link, please:
http://www-1.ibm.com/support/docview.wss?uid=swg21164785
Please ensure that the parameter SVCENAME (get dbm cfg) is set on your
db server according SAP Note 584952. This entry must be maintained in
the /etc/service file !
=> SVCENAME=<port number> or <service name>
=> SVCENAME=sapdb2<DBSID> (SAP Note 584952)
Ensure that DB2 environment variable DB2COMM (db2set -all) is set:
=> DB2COMM=TCPIP
Check the client(s):
=> db2 list db directory (to find the NODE name)
=> db2 list node directory (to find HOST/IP-address defined in host
file)
Now check the entries in files:
/etc/hosts
/etc/services
Please check also if server's port is opened by command:
telnet <hostname> <port>
Regards, Premsukh
Hi,
Please check the following
1) in /etc/hosts -- file your new IP address ( as you mentioned unix team changed the IP )
2) Check dbcli.ini file in /usr/sap/KSM/SYS/global/db6 directory for the service for DB2 communication port info and check if IP address their for DB host. For example
; Comment lines start with a semi-colon.
[KSM]
Database=KSM
Protocol=tcpip
Hostname= check the hostname / ip
Servicename=5912
Also check the sercice entries in /etc/services file
sapdb2KSM 5912/tcp
Servicename in db2cli.ini file must be same as in /etc/service file
If non of these steps work, thean perform uncatelog and catelog your database port config.
Regards,
Dipam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.