cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR in DB6Connect [dbdb6.c, 1700] CON = 0 (BEGIN)

Former Member
0 Kudos

Dear Team,

I have SAP ECC 6.0 development system, now it is not starting because Dispatcher is down.

Please check the below details are system trace details:-

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  : 09.06.2015 - 17:37:50

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]  Tue Jun 09 17:37:52 2015                          22011  0.022011

4 ETW000  [dev trc    ,00000]  db_con_init called                                    72  0.022083

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

4 ETW000  [dev trc    ,00000]  Loading DB library 'dbdb6slib.dll' ...              106  0.026395

4 ETW000  [dev trc    ,00000]  load shared library (dbdb6slib.dll), hdl 0, addr 00000001864A0000

4 ETW000                                                                            4033  0.030428

4 ETW000  [dev trc    ,00000]      using "F:\usr\sap\MED\SYS\exe\uc\NTAMD64\dbdb6slib.dll"

4 ETW000                                                                              25  0.030453

4 ETW000  [dev trc    ,00000]  Library 'dbdb6slib.dll' loaded                        21  0.030474

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

4 ETW000                                                                              27  0.030501

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

4 ETW000                                                                            339  0.030840

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

4 ETW000                                                                              26  0.030866

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

4 ETW000                                                                              31  0.030897

4 ETW000  [dev trc    ,00000]  New connection 0 created                              37  0.030934

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                                                                              44  0.030978

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

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

4 ETW000                                                                              24  0.031032

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                                                                              39  0.031071

4 ETW000  [dev trc    ,00000]  Tue Jun 09 17:37:53 2015                          656955  0.688026

4 ETW000  [dev trc    ,00000]  DB2 library successfully loaded DB2 library '\\DEVELOPMENT\sapmnt\MED\SYS\global\db6\WINDOWS_AMD64\db6_clidriver\bin\db2app64.dll' successfully loaded

4 ETW000                                                                            4520  0.692546

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

4 ETW000                                                                              46  0.692592

4 ETW000  [dev trc    ,00000]  DB6 shared library (dbdb6slib) patchlevels            18  0.692610

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

4 ETW000                                                                              25  0.692635

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

4 ETW000                                                                              27  0.692662

4 ETW000  [dev trc    ,00000]    (0.9) IA64 alignment errors (note 1245982)          18  0.692680

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

4 ETW000                                                                              95  0.692775

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

4 ETW000                                                                              27  0.692802

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

4 ETW000                                                                              28  0.692830

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

4 ETW000                                                                              45  0.692875

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

4 ETW000                                                                              24  0.692899

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

4 ETW000                                                                              27  0.692926

4 ETW000  [dev trc    ,00000]  Supported features:                                  15  0.692941

4 ETW000  [dev trc    ,00000]  ..retrieving configuration parameters                16  0.692957

4 ETW000  [dev trc    ,00000]  ..done                                              488  0.693445

4 ETW000  [dev trc    ,00000]  Running with UTF-8 Unicode                            22  0.693467

4 ETW000  [dev trc    ,00000]  Running with CLI driver                          416174  1.109641

4 ETW000  [dev trc    ,00000]  Tue Jun 09 17:37:54 2015                          505298  1.614939

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

4 ETW000                                                                              40  1.614979

4 ETW000  [dev trc    ,00000]  &+    DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30082N  Security processing failed with reason "24" ("USERNAME

4 ETW000                                                                              28  1.615007

4 ETW000  [dev trc    ,00000]  &+    AND/OR PASSWORD INVALID").  SQLSTATE=08001                                                                      

4 ETW000                                                                              23  1.615030

4 ETW000  [dev trc    ,00000]  &+                                                                                                                    

4 ETW000                                                                              24  1.615054

4 ETW000  [dev trc    ,00000]  &+                                                                                                                    

4 ETW000                                                                              23  1.615077

4 ETW000  [dev trc    ,00000]  &+                                                                                                                    

4 ETW000                                                                              22  1.615099

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

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

4 ETW000                                                                            490  1.615602

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

Here error is showing DB connect failed with "sapmed" ID but DB is connecting with "medadm" ID, And DB is starting and it status also showing active. how to solve this issue? Please help me.

Thanks & Regards,

Veera

Accepted Solutions (1)

Accepted Solutions (1)

manumohandas82
Active Contributor
0 Kudos

Hi Veera ,

The user should be available  [ If you are already checking  in the server where the DB is installed ] .

If its not create a new user , supply the initial password and execute

dscdb6up -create sapmed <Password>      [ as <sid>adm ]


Thanks ,

Manu

Former Member
0 Kudos

Dear Manu,

Issue had solved. Thanks for your valuable information. It is very helpful for resolving issue.

Actually Some SAP ID's are deleted in OS level, I have recreated new IDs and then given administration, DB and services related authorizations, then restarted the server, then applied your commands in DB level then started the SAP system. Know it is working fine.

Once again thanks for your support.

Thanks & Regards,

Surendra

Answers (1)

Answers (1)

manumohandas82
Active Contributor
0 Kudos

Hi Veera ,

Check whether the user id is locked in the Os level ( sapmed  ) , If its locked unlock it .

If not locked try to login ( as sapmed )  to the OS with the userid /password  . The correct password needs to be updated

Login as <sid>adm

dscdb6up -create sapmed <Password>


Or


dscdb6up sapmed <Password>


Thanks ,

Manu



Former Member
0 Kudos

Dear Manu,

Thanks for your valuable feed back, but no ID available in OS level. Know what to do?

Only these ID's are available in the system:

ID: Administrator/medadm/db2med/guest(disable)/G

Groups: DB2ADMNS_MED/DB2USERS_MED/dbmedadm/dbmedctl/SAP_LocalAdmin/SAP_MED_GlobalAdmin/SAP_MED_LocalAdmin

Thanks & Regards,

Surendra