on 2013 Feb 18 5:57 AM
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
Request clarification before answering.
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.
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'"
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.