R3trans details for the same.

kjqadm 43> R3trans -d

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'KJQ'"

R3trans finished (0012).

Regards,

Deepesh

SAP Managed Tags:
Support Services

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (3)

kjqadm 46> tail trans.log

4 ETW000 [dev trc ,00000] &+

4 ETW000 24 0.544588

4 ETW000 [dev trc ,00000] &+

4 ETW000 25 0.544613

4 ETW000 [dev trc ,00000] &+

4 ETW000 24 0.544637

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1700] (END) 15 0.544652

4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'KJQ' as 'sapkjq' failed

4 ETW000 90 0.544742

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'KJQ'"

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Please paste the entire contents...

Entire contents of trans.log file.

4 ETW000 R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 18.02.2013 - 11:44:26

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Feb 18 11:44:26 2013 76 0.000076

4 ETW000 [dev trc ,00000] db_con_init called 21 0.000097

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 44 0.000141

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/KJQ/SYS/exe/run/dbdb6slib.so' ...

4 ETW000 39 0.000180

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/KJQ/SYS/exe/run/dbdb6slib.so), hdl 0

4 ETW000 194 0.000374

4 ETW000 [dev trc ,00000] Library '/usr/sap/KJQ/SYS/exe/run/dbdb6slib.so' loaded

4 ETW000 26 0.000400

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/KJQ/SYS/exe/run/dbdb6slib.so

4 ETW000 30 0.000430

4 ETW000 [dev trc ,00000] Version of '/usr/sap/KJQ/SYS/exe/run/dbdb6slib.so' is "700.08", patchlevel (0.21)

4 ETW000 79 0.000509

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/KJQ/SYS/exe/run/dbdb6slib.so

4 ETW000 24 0.000533

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/KJQ/SYS/exe/run/dbdb6slib.so

4 ETW000 28 0.000561

4 ETW000 [dev trc ,00000] New connection 0 created 20 0.000581

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 31 0.000612

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 19 0.000631

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 21 0.000652

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 26 0.000678

4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library '/usr/sap/KJQ/SYS/global/db6/LINUXX86_64/db6_clidriver/lib/libdb2.so' successfully loaded

4 ETW000 3302 0.003980

4 ETW000 [dev trc ,00000] RLIMIT_STACK: current=10485760, max=-1 20 0.004000

4 ETW000 [dev trc ,00000] DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

4 ETW000 15 0.004015

4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 8 0.004023

4 ETW000 [dev trc ,00000] (0.2) DB6: patch collection 06/08 (note 1172220)

4 ETW000 15 0.004038

4 ETW000 [dev trc ,00000] (0.9) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030)

4 ETW000 13 0.004051

4 ETW000 [dev trc ,00000] (0.10) DB6: UR cursor with CC_RELEASE attribute (note 1244963)

4 ETW000 21 0.004072

4 ETW000 [dev trc ,00000] (0.10) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)

4 ETW000 13 0.004085

4 ETW000 [dev trc ,00000] (0.11) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)

4 ETW000 15 0.004100

4 ETW000 [dev trc ,00000] (0.19) DB6: patch collection 11/08 (note 1263885)

4 ETW000 26 0.004126

4 ETW000 [dev trc ,00000] (0.19) DB6: patch collection 11/08 (note 1264825)

4 ETW000 15 0.004141

4 ETW000 [dev trc ,00000] (0.21) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)

4 ETW000 13 0.004154

4 ETW000 [dev trc ,00000] Supported features: 8 0.004162

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 8 0.004170

4 ETW000 [dev trc ,00000] ..done 41 0.004211

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 9 0.004220

4 ETW000 [dev trc ,00000] Running with CLI driver 977 0.005197

4 ETW000 [dev trc ,00000] Mon Feb 18 11:44:27 2013 539272 0.544469

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1700] CON = 0 (BEGIN)

4 ETW000 39 0.544508

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1117N A connection to or activation of database "KJQ" cannot b

4 ETW000 31 0.544539

4 ETW000 [dev trc ,00000] &+ e made because of ROLL-FORWARD PENDING. SQLSTATE=57019

4 ETW000 25 0.544564

4 ETW000 [dev trc ,00000] &+

4 ETW000 24 0.544588

4 ETW000 [dev trc ,00000] &+

4 ETW000 25 0.544613

4 ETW000 [dev trc ,00000] &+

4 ETW000 24 0.544637

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1700] (END) 15 0.544652

4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'KJQ' as 'sapkjq' failed

4 ETW000 90 0.544742

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'KJQ'"

Entire contents of trans.log file.

4 ETW000 R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 18.02.2013 - 11:44:26

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Feb 18 11:44:26 2013 76 0.000076

4 ETW000 [dev trc ,00000] db_con_init called 21 0.000097

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 44 0.000141

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/KJQ/SYS/exe/run/dbdb6slib.so' ...

4 ETW000 39 0.000180

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/KJQ/SYS/exe/run/dbdb6slib.so), hdl 0

4 ETW000 194 0.000374

4 ETW000 [dev trc ,00000] Library '/usr/sap/KJQ/SYS/exe/run/dbdb6slib.so' loaded

4 ETW000 26 0.000400

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/KJQ/SYS/exe/run/dbdb6slib.so

4 ETW000 30 0.000430

4 ETW000 [dev trc ,00000] Version of '/usr/sap/KJQ/SYS/exe/run/dbdb6slib.so' is "700.08", patchlevel (0.21)

4 ETW000 79 0.000509

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/KJQ/SYS/exe/run/dbdb6slib.so

4 ETW000 24 0.000533

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/KJQ/SYS/exe/run/dbdb6slib.so

4 ETW000 28 0.000561

4 ETW000 [dev trc ,00000] New connection 0 created 20 0.000581

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 31 0.000612

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 19 0.000631

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 21 0.000652

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 26 0.000678

4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library '/usr/sap/KJQ/SYS/global/db6/LINUXX86_64/db6_clidriver/lib/libdb2.so' successfully loaded

4 ETW000 3302 0.003980

4 ETW000 [dev trc ,00000] RLIMIT_STACK: current=10485760, max=-1 20 0.004000

4 ETW000 [dev trc ,00000] DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]

4 ETW000 15 0.004015

4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 8 0.004023

4 ETW000 [dev trc ,00000] (0.2) DB6: patch collection 06/08 (note 1172220)

4 ETW000 15 0.004038

4 ETW000 [dev trc ,00000] (0.9) DB6: reduce calls to REG_LIST_VARIABLES (note 1232030)

4 ETW000 13 0.004051

4 ETW000 [dev trc ,00000] (0.10) DB6: UR cursor with CC_RELEASE attribute (note 1244963)

4 ETW000 21 0.004072

4 ETW000 [dev trc ,00000] (0.10) DB6: DB6_DBSL_RUNSTATS_V8 with sampling rate (note 1245458)

4 ETW000 13 0.004085

4 ETW000 [dev trc ,00000] (0.11) DB6: trace warnings on setting SQL_ATTR_CHAINING_BEGIN (note 1247697)

4 ETW000 15 0.004100

4 ETW000 [dev trc ,00000] (0.19) DB6: patch collection 11/08 (note 1263885)

4 ETW000 26 0.004126

4 ETW000 [dev trc ,00000] (0.19) DB6: patch collection 11/08 (note 1264825)

4 ETW000 15 0.004141

4 ETW000 [dev trc ,00000] (0.21) DB6: SUBSITUTE_VALUES causes wrong estimated statement si (note 1277235)

4 ETW000 13 0.004154

4 ETW000 [dev trc ,00000] Supported features: 8 0.004162

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 8 0.004170

4 ETW000 [dev trc ,00000] ..done 41 0.004211

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 9 0.004220

4 ETW000 [dev trc ,00000] Running with CLI driver 977 0.005197

4 ETW000 [dev trc ,00000] Mon Feb 18 11:44:27 2013 539272 0.544469

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1700] CON = 0 (BEGIN)

4 ETW000 39 0.544508

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL1117N A connection to or activation of database "KJQ" cannot b

4 ETW000 31 0.544539

4 ETW000 [dev trc ,00000] &+ e made because of ROLL-FORWARD PENDING. SQLSTATE=57019

4 ETW000 25 0.544564

4 ETW000 [dev trc ,00000] &+

4 ETW000 24 0.544588

4 ETW000 [dev trc ,00000] &+

4 ETW000 25 0.544613

4 ETW000 [dev trc ,00000] &+

4 ETW000 24 0.544637

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1700] (END) 15 0.544652

4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'KJQ' as 'sapkjq' failed

4 ETW000 90 0.544742

2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'KJQ'"

Hi,

Have you maintained the host entry of your DB server hostname in the host file?

Try to ping the DB servername and check whether it resolves.

Thanks and Regards,

V imal

I have created a separate backup server which is going to be used for online backup. Completed all the process of backup and restoration from DB2, still, sap is unable to connect to the database and hence unable to start sap services.

Thanks & Regards,

Deepesh

Please, suggest me what should I do.

Thanks & Regards,

Deepesh

Yes, maintained the host entry of the DB server and checked ping status, its pinging but still unable to connect to the DB.

Regards,

Deepesh

This is R3trans version 6.14 (release 700 - 03.11.09 - 14:15:00). 2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SRD/SYS/exe/run') or dbms_type ('ORA')" R3trans finished (0012).

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

Can you please attach the trans.log.

You can get the trans.log from the place where you executed the R3trans -d command

THanks and Regards,

Vimal

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count