I am not able to get the db2 database activated.I get the following message when starting SAP:
n4shost:n4sadm 59> startsap
Checking db6 db Database
------------------------------
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
------------------------------
******************************************************************************
* This is Saposcol Version COLL 20.94 700 - v2.00, Intel x86 with Linux, 2007/02/16
* Usage: saposcol -l: Start OS Collector
* saposcol -k: Stop OS Collector
* saposcol -d: OS Collector Dialog Mode
* saposcol -s: OS Collector Status
* Starting collector (create new process)
******************************************************************************
saposcol on host n4shost started
Running /usr/sap/N4S/SYS/exe/run/startdb
08/21/2009 04:51:27 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
Database activated
R3trans connect failed
DB startup failed
Here is the output of r3trans -d
n4shost:n4sadm 63> r3trans -d
CORRECT>R3trans -d (y|n|e|a)? yes
This is R3trans version 6.14 (release 700 - 11.04.07 - 14:28:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'N4S'"
R3trans finished (0012).
Here is the output of the translog:
4 ETW000 R3trans version 6.14 (release 700 - 11.04.07 - 14:28:00).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 21.08.2009 - 05:23:40
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Fri Aug 21 05:23:40 2009 266 0.000266
4 ETW000 [dev trc ,00000] db_con_init called 65 0.000331
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 56 0.000387
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/N4S/SYS/exe/run/dbdb6slib.so' ...
4 ETW000 47 0.000434
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/N4S/SYS/exe/run/dbdb6slib.so), hdl 0
4 ETW000 486 0.000920
4 ETW000 [dev trc ,00000] Library '/usr/sap/N4S/SYS/exe/run/dbdb6slib.so' loaded
4 ETW000 22 0.000942
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/N4S/SYS/exe/run/dbdb6slib.so
4 ETW000 37 0.000979
4 ETW000 [dev trc ,00000] Version of '/usr/sap/N4S/SYS/exe/run/dbdb6slib.so' is "700.08", patchlevel (0.107)
4 ETW000 243 0.001222
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/N4S/SYS/exe/run/dbdb6slib.so
4 ETW000 27 0.001249
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/N4S/SYS/exe/run/dbdb6slib.so
4 ETW000 44 0.001293
4 ETW000 [dev trc ,00000] New connection 0 created 54 0.001347
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 34 0.001381
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 36 0.001417
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 26 0.001443
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.001469
4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library '/usr/sap/N4S/SYS/global/db6/LINUX_32/db6_clidriver/lib/libdb2.so' successfully loaded
4 ETW000 24086 0.025555
4 ETW000 [dev trc ,00000] RLIMIT_STACK: current=8388608, max=0 100 0.025655
4 ETW000 [dev trc ,00000] DB6 (DB2 UDB) UNICODE database interface 700.08 [opt]
4 ETW000 82 0.025737
4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 45 0.025782
4 ETW000 [dev trc ,00000] (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037)
4 ETW000 53 0.025835
4 ETW000 [dev trc ,00000] (0.8) Support of SDBUPDEXCL (note 847616) 33 0.025868
4 ETW000 [dev trc ,00000] (0.9) DB6: use export file for dbdb6slib (note 835135)
4 ETW000 50 0.025918
4 ETW000 [dev trc ,00000] (0.9) DB6: Core in getAndBindSQLDA (note 833183)
4 ETW000 93 0.026011
4 ETW000 [dev trc ,00000] (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)
4 ETW000 50 0.026061
4 ETW000 [dev trc ,00000] (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474)
4 ETW000 49 0.026110
4 ETW000 [dev trc ,00000] (0.15) DB6: wrong CAST for short string ABAP type (note 861905)
4 ETW000 105 0.026215
4 ETW000 [dev trc ,00000] (0.17) DB6: special characters in sidadm passwd (note 865839)
4 ETW000 49 0.026264
4 ETW000 [dev trc ,00000] (0.21) DB6: no SAP_INFO comments (note 873889)4 ETW000 62 0.026326
4 ETW000 [dev trc ,00000] (0.22) DB6: hints: get correlation names from view texts (note 868888)
4 ETW000 48 0.026374
4 ETW000 [dev trc ,00000] (0.23) DB6: hints: get correlation names from view texts (note 868888)
4 ETW000 48 0.026422
4 ETW000 [dev trc ,00000] (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402)
4 ETW000 61 0.026483
4 ETW000 [dev trc ,00000] (0.27) DB6: activate value compression (note 886231)
4 ETW000 47 0.026530
4 ETW000 [dev trc ,00000] (0.28) DB6: optimization guidelines on views part 2 (note 868888)
4 ETW000 117 0.026647
4 ETW000 [dev trc ,00000] (0.30) DB6: no SQL trace for SQLCancel (note 892111)
4 ETW000 48 0.026695
4 ETW000 [dev trc ,00000] (0.33) DB6: append SAP_TA comment (note 873889)
4 ETW000 64 0.026759
4 ETW000 [dev trc ,00000] (0.34) DB6: activate value compression with quoted names (note 886231)
4 ETW000 48 0.026807
4 ETW000 [dev trc ,00000] (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)
4 ETW000 62 0.026869
4 ETW000 [dev trc ,00000] (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)
4 ETW000 91 0.026960
4 ETW000 [dev trc ,00000] (0.50) DB6: reread passwords for secondary connections (note 931742)
4 ETW000 64 0.027024
4 ETW000 [dev trc ,00000] (0.52) DB6: double quote table names in optguidelines (note 868888)
4 ETW000 49 0.027073
4 ETW000 [dev trc ,00000] (0.54) DB6: error handling in DBSL CLP (note 940260)
4 ETW000 83 0.027156
4 ETW000 [dev trc ,00000] (0.69) DB6: technical support of DB2 CLI driver (note 962892)
4 ETW000 71 0.027227
4 ETW000 [dev trc ,00000] (0.73) DB6: log table name on TRUNCATE failure (note 970743)
4 ETW000 61 0.027288
4 ETW000 [dev trc ,00000] (0.79) DB6: column type XML in index size calculation (note 982993)
4 ETW000 88 0.027376
4 ETW000 [dev trc ,00000] (0.82) DB6: CAST for SSTRING data types (note 989568)
4 ETW000 90 0.027466
4 ETW000 [dev trc ,00000] (0.86) DB6: long runtimes for R3szchk (note 1000847)
4 ETW000 2141 0.029607
4 ETW000 [dev trc ,00000] (0.88) DB6: patch collection Dec 06 (note 1005574)
4 ETW000 69 0.029676
4 ETW000 [dev trc ,00000] (0.96) DB6: patch collection Jan 07 (note 1017852)
4 ETW000 75 0.029751
4 ETW000 [dev trc ,00000] (0.97) DB6: CLP commands with DB2 CLI Driver (note 1024102)
4 ETW000 50 0.029801
4 ETW000 [dev trc ,00000] (0.99) DB6: SUBSTITUTE VALUES with FAE statements (note 1028779)
4 ETW000 49 0.029850
4 ETW000 [dev trc ,00000] (0.107) DB6: patch collection Apr 07 (note 1047194)
4 ETW000 49 0.029899
4 ETW000 [dev trc ,00000] Supported features: 45 0.029944
4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 34 0.029978
4 ETW000 [dev trc ,00000] ..done 226 0.030204
4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 37 0.030241
4 ETW000 [dev trc ,00000] Running with CLI driver 9609 0.039850
4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1634] CON = 0 (BEGIN)
4 ETW000 52965 0.092815
4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication
4 ETW000 34 0.092849
4 ETW000 [dev trc ,00000] &+ protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected:
4 ETW000 23 0.092872
4 ETW000 [dev trc ,00000] &+ "192.168.192.0". Communication function detecting the error: "connect". Protocol specific error code(s): "101",
4 ETW000 24 0.092896
4 ETW000 [dev trc ,00000] &+ "*", "*". SQLSTATE=08001
4 ETW000 24 0.092920
4 ETW000 [dev trc ,00000] &+
4 ETW000 39 0.092959
4 ETW000 [dev trc ,00000] &+
4 ETW000 25 0.092984
4 ETW000 [dev trc ,00000] &+
4 ETW000 23 0.093007
4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1634] (END) 15 0.093022
4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'N4S' as 'sapn4s' failed
4 ETW000 194 0.093216
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'N4S'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.