Skip to Content
author's profile photo Former Member
Former Member

DB2 not able to connect (0012)

Suddenly I had started to face " Not able to connect database,session terminated " from SAPGUI ,so I stopped the SID and started it again now the dispatcher turns into gray colour and I Could not do login.

I ran r3trans -d

not able to connect DB (0012)

trans.log :

4 ETW000 r3trans version 6.14 (release 700 - 25.01.08 - 14:11:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 10.08.2008 - 15:49:47

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] Sun Aug 10 15:49:57 2008 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

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

4 ETW000 [dev trc ,00000] Loading DB library 'dbdb6slib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dbdb6slib.dll), hdl 0 5548 0.005548

4 ETW000 [dev trc ,00000] using "G:\usr\sap\SID\SYS\exe\uc\NTI386\dbdb6slib.dll"

4 ETW000 28 0.005576

4 ETW000 [dev trc ,00000] Library 'dbdb6slib.dll' loaded 14 0.005590

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbdb6slib.dll

4 ETW000 23 0.005613

4 ETW000 [dev trc ,00000] Version of 'dbdb6slib.dll' is "700.08", patchlevel (0.144)

4 ETW000 267 0.005880

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbdb6slib.dll

4 ETW000 23 0.005903

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbdb6slib.dll

4 ETW000 25 0.005928

4 ETW000 [dev trc ,00000] New connection 0 created 24 0.005952

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 33 0.005985

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

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

4 ETW000 22 0.006025

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 29 0.006054

4 ETW000 [dev trc ,00000] DB2 library successfully loaded DB2 library '
hostname\sapmnt\SID\SYS\global\db6\WINDOWS_I386\db6_clidriver\bin\db2app.dll' successfully loaded

4 ETW000 430443 0.436497

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

4 ETW000 32 0.436529

4 ETW000 [dev trc ,00000] DB6 shared library (dbdb6slib) patchlevels 14 0.436543

4 ETW000 [dev trc ,00000] (0.8) DB6: V8.2.2 optguidelines in OPEN SQL (note 150037)

4 ETW000 22 0.436565

4 ETW000 [dev trc ,00000] (0.8) Support of SDBUPDEXCL (note 847616) 15 0.436580

4 ETW000 [dev trc ,00000] (0.9) DB6: use export file for dbdb6slib (note 835135)

4 ETW000 21 0.436601

4 ETW000 [dev trc ,00000] (0.9) DB6: Core in getAndBindSQLDA (note 833183)

4 ETW000 21 0.436622

4 ETW000 [dev trc ,00000] (0.10) DB6: link dbdb6slib.dll on windows with libdb6.obj (note 761159)

4 ETW000 87 0.436709

4 ETW000 [dev trc ,00000] (0.10) DB6: DUPLICATE_KEY on MERGE -> repeat (note 851474)

4 ETW000 25 0.436734

4 ETW000 [dev trc ,00000] (0.15) DB6: wrong CAST for short string ABAP type (note 861905)

4 ETW000 22 0.436756

4 ETW000 [dev trc ,00000] (0.17) DB6: special characters in sidadm passwd (note 865839)

4 ETW000 22 0.436778

4 ETW000 [dev trc ,00000] (0.21) DB6: no SAP_INFO comments (note 873889)

4 ETW000 21 0.436799

4 ETW000 [dev trc ,00000] (0.22) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000 23 0.436822

4 ETW000 [dev trc ,00000] (0.23) DB6: hints: get correlation names from view texts (note 868888)

4 ETW000 23 0.436845

4 ETW000 [dev trc ,00000] (0.26) DB6: DB6_DBSL_CLP_COMMAND STRING_BAD_REF (note 883402)

4 ETW000 22 0.436867

4 ETW000 [dev trc ,00000] (0.27) DB6: activate value compression (note 886231)

4 ETW000 21 0.436888

4 ETW000 [dev trc ,00000] (0.28) DB6: optimization guidelines on views part 2 (note 868888)

4 ETW000 22 0.436910

4 ETW000 [dev trc ,00000] (0.30) DB6: no SQL trace for SQLCancel (note 892111)

4 ETW000 22 0.436932

4 ETW000 [dev trc ,00000] (0.33) DB6: append SAP_TA comment (note 873889)

4 ETW000 21 0.436953

4 ETW000 [dev trc ,00000] (0.34) DB6: activate value compression with quoted names (note 886231)

4 ETW000 22 0.436975

4 ETW000 [dev trc ,00000] (0.36) DB6: Repeat isolated DDL statements after SQL0911 (note 901338)

4 ETW000 23 0.436998

4 ETW000 [dev trc ,00000] (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

4 ETW000 23 0.437021

4 ETW000 [dev trc ,00000] (0.50) DB6: reread passwords for secondary connections (note 931742)

4 ETW000 22 0.437043

4 ETW000 [dev trc ,00000] (0.52) DB6: double quote table names in optguidelines (note 868888)

4 ETW000 23 0.437066

4 ETW000 [dev trc ,00000] (0.54) DB6: error handling in DBSL CLP (note 940260)

4 ETW000 21 0.437087

4 ETW000 [dev trc ,00000] (0.69) DB6: technical support of DB2 CLI driver (note 962892)

4 ETW000 22 0.437109

4 ETW000 [dev trc ,00000] (0.73) DB6: log table name on TRUNCATE failure (note 970743)

4 ETW000 22 0.437131

4 ETW000 [dev trc ,00000] (0.79) DB6: column type XML in index size calculation (note 982993)

4 ETW000 23 0.437154

4 ETW000 [dev trc ,00000] (0.82) DB6: CAST for SSTRING data types (note 989568)

4 ETW000 23 0.437177

4 ETW000 [dev trc ,00000] (0.86) DB6: long runtimes for R3szchk (note 1000847)

4 ETW000 22 0.437199

4 ETW000 [dev trc ,00000] (0.88) DB6: patch collection Dec 06 (note 1005574)

4 ETW000 21 0.437220

4 ETW000 [dev trc ,00000] (0.96) DB6: patch collection Jan 07 (note 1017852)

4 ETW000 21 0.437241

4 ETW000 [dev trc ,00000] (0.97) DB6: CLP commands with DB2 CLI Driver (note 1024102)

4 ETW000 22 0.437263

4 ETW000 [dev trc ,00000] (0.99) DB6: SUBSTITUTE VALUES with FAE statements (note 1028779)

4 ETW000 22 0.437285

4 ETW000 [dev trc ,00000] (0.107) DB6: patch collection Apr 07 (note 1047194)

4 ETW000 21 0.437306

4 ETW000 [dev trc ,00000] (0.110) DB6: SAP user names ending with non-ASCII char (note 1054555)

4 ETW000 23 0.437329

4 ETW000 [dev trc ,00000] (0.113) DB6: work process type in application snapshot (note 1059905)

4 ETW000 23 0.437352

4 ETW000 [dev trc ,00000] (0.114) DB6: connect using SAPDBHOST and DB2DB6_SVCENAME (note 1062049)

4 ETW000 22 0.437374

4 ETW000 [dev trc ,00000] (0.117) DB6: patch for execution of long DDL statements (note 1069658)

4 ETW000 23 0.437397

4 ETW000 [dev trc ,00000] (0.122) DB6: SNAPSHOT_TBS_CFG table function is deprecated (note 1077963)

4 ETW000 23 0.437420

4 ETW000 [dev trc ,00000] (0.123) DB6: CLP commands on Windows with V9.1 (note 1080149)

4 ETW000 22 0.437442

4 ETW000 [dev trc ,00000] (0.124) DB6: Set DB2CODEPAGE=819 for non-Unicode (note 1084400)

4 ETW000 22 0.437464

4 ETW000 [dev trc ,00000] (0.126) DB6: reuse optguidelines on FAE statements (note 1087375)

4 ETW000 23 0.437487

4 ETW000 [dev trc ,00000] (0.126) DB6: Enforce DB2CODEPAGE=819 for non-Unicode environments (note 1084400)

4 ETW000 23 0.437510

4 ETW000 [dev trc ,00000] (0.128) DB6: db6_free on invalid memory area (note 1092030)

4 ETW000 22 0.437532

4 ETW000 [dev trc ,00000] (0.133) DB6: statement cache enhancements (note 1101031)

4 ETW000 22 0.437554

4 ETW000 [dev trc ,00000] (0.136) DB6: change for enhancement pack installer (note 1111536)

4 ETW000 22 0.437576

4 ETW000 [dev trc ,00000] (0.138) DB6: improoved table size estimate for DB8 V8 (note 1119934)

4 ETW000 23 0.437599

4 ETW000 [dev trc ,00000] (0.144) I5/OS ldappasswd support for 5250 terminal. (note 1129573)

4 ETW000 24 0.437623

4 ETW000 [dev trc ,00000] (0.144) MSSQL: ODBC fastload on separate connection (note 1131805)

4 ETW000 23 0.437646

4 ETW000 [dev trc ,00000] Supported features: 12 0.437658

4 ETW000 [dev trc ,00000] ..retrieving configuration parameters 14 0.437672

4 ETW000 [dev trc ,00000] ..done 349 0.438021

4 ETW000 [dev trc ,00000] Running with UTF-8 Unicode 15 0.438036

4 ETW000 [dev trc ,00000] Running with CLI driver 352526 0.790562

4 ETW000 [dev trc ,00000] Sun Aug 10 15:49:58 2008 415310 1.205872

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

4 ETW000 30 1.205902

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL8001N An attempt to connect to the database failed due to a pr

4 ETW000 32 1.205934

4 ETW000 [dev trc ,00000] &+ oduct licence problem. SQLSTATE=42968

4 ETW000 29 1.205963

4 ETW000 [dev trc ,00000] &+

4 ETW000 29 1.205992

4 ETW000 [dev trc ,00000] &+

4 ETW000 31 1.206023

4 ETW000 [dev trc ,00000] &+

4 ETW000 28 1.206051

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

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

4 ETW000 8386 1.214452

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

I think the license is expired so anybody can please tell me how to apply the license with steps and what to be licensed

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 11, 2008 at 05:59 AM

    Hello,

    please check SAP note 816773

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.