protocol being used: "TCP/IP". Communication API being used: "SOCKETS

[Former Member]

Hi,

We are performing Oracle to DB2 database migration .

In Adjust nametab phase below error is being faced:

Execution of the command "/usr/sap/SBX/SYS/exe/run/dipgntab -rwr40 -srctt DDNTT -srctf DDNTF -dsttt DDNTT -dsttf DDNTF -ttonly TT" finished with return code 255. Output:

ERROR in initialization (can't get R/3-version)

ERROR in initialization (can't get R/3-version)

Log file dipgntab.log contains :

ERROR in initialization (can't get R/3-version)

We tried to catalog the DB,edited /etc/services for sapdb2<SID> .

Manually entered above entry in services file against desired port 5912.

In trans.log it says :[finished with 0012]

DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication

protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".  Location where the error was detected:

17x.xxx.xxx.x".  Communication function detecting the error: "connect".  Protocol specific error code(s): "111",

SQLSTATE=08001

ERROR in DB6Connect[dbdb6.c, 1832] (END)

ERROR => DbSlConnect to '<SID>' as 'sapsid' failed

no connect possible: "DBMS = DB6

--- DB2DBDFT = '<SID>'

Also we set DB2CONN parameter to TCPIP...still same error is being faced.

Please suggest.

[Former Member · Accepted solution]

In db2diag.log following error is displayed:

DIA3202C The TCP/IP call "connect" returned an errno="111".

[Sriram2009 · Accepted solution]

Hi Vineet

Check this IBM link about database connection
IBM SQL30081N TCPIP communication errors - United States

BR

SS

[Former Member · Accepted solution]

HI Sriram,

Same link was followed up  few hours ago,but could not resolve it.

Thanks & Regards,

Vineet

[Sriram2009 · Accepted solution]

Hi Vineet

1.  Could you share your OS/DB & SAP version SP level in details?

2 During the migration are you using the latest version SAP kernel & DBSL patch?

BR

SS

[Former Member · Accepted solution]

Hi SS,

Please find below details:

OS : SUSE LINUX 11

DB : Oracle to DB2 10.5

SAP : ECC 6.0

Kernel : 7.21

DBSL shared library version

721.02

patch number

201

We had done DB migration with same export twice on this server itself ,and this is third time we are doing with the export,we never faced this issue before.

We have uninstalled our previous migrations and then only proceeded with this one.

Thanks,

Vineet

[Former Member · Accepted solution]

Hi SS,

Issue has been resolved.

We stopped ongoing installation,started sapinst with option

sapinst_skip_errorstep=true ,it completed installation and later

executed the dipgntab command manually.

Thanks for the support.

Regards,

Vineet

[Sriram2009 · Accepted solution]

Hi

could you share solution in detail pls?

BR

SS

[Former Member · Accepted solution]

Hi SS,

We stopped the installation.

Restarted it using below command:

./sapinst sapinst_skip_errorstep= true

It skipped the step of nametab,and completed installation.

Once installation was complete,the login screen was crashing giving dump "DBIF_RSQL_SQL_ERROR" SQL error code  -99999.

Then stopped the services,executed below command [ SID is SBX]:

with user sbxadm

"/usr/sap/SBX/SYS/exe/run/dipgntab -rwr40 -srctt DDNTT -srctf DDNTF -dsttt DDNTT -dsttf DDNTF -ttonly TT"  

Post completion of step, issue resolved completely.

Please revert for clarifications.

Regards,

Vineet

[Sriram2009 · Accepted solution]

Hi

Thanks & close the thread

BR

SS

[former_member642382]

Thanks so much for the valuable response. Issue got resolved.

[Former Member]

This message was moderated.

[Former Member]

Hi,

Faced with same error,but this time above mentioned workaround did not work.

Tried with below things and issue resolved:

1>On DB server log in as root and execute below for repairing file permissions:

<db2_sw_dir>/instance/db2iupdt db2<sid>

2> db2 grant dbadm on database to user  sap<SID>

Regards,

Vineet