Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2014 at 11:08 AM

    In db2diag.log following error is displayed:

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2014 at 01:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 31, 2015 at 08:24 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded