Skip to Content
0
Former Member
Oct 01, 2013 at 03:27 PM

DB2 database not getting activated

106 Views

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'"