cancel
Showing results for 
Search instead for 
Did you mean: 

NW 7.3 is stuck during startup (strdbs.cmd)

Former Member
0 Kudos

Hello,

I have got a problem to start up my NW 7.3 (Windows/maxdb). The only process which appears in process list is strdbs.cmd and it remains yellow (now for two hours or more). When I right-click the process and choose Developer Trace, nothing happens - syslog is also empty. The system was running fine until last week.

Does anybody know this issue or are there another checks I can perform?

Thanks in advance!

Václav

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

my problem was solved in this thread: http://scn.sap.com/message/13953450

I renamed the files NWD.dbm.shi and NWD.dbm.shm in MaxDB workdir, after that the Netweaver is actually running

Thanks a lot for your help guys!

Regards,

Václav

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi guys,

thanks for your fast replies! I restarted the server, but without success. I'm not aware of any updates or patches, kernel version should be unchanged since installation (one year ago).

I performed "r3trans -d" with following result in trans.log:

4 ETW000 r3trans version 6.19 (release 720 - 24.08.10 - 14:38:42).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 27.03.2013 - 12:38:07

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]  Wed Mar 27 12:38:07 2013                                               17616  0.017616

4 ETW000  [dev trc     ,00000]  db_con_init called                                                       543  0.018159

4 ETW000  [dev trc     ,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                 545  0.018704

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

4 ETW000  [dbcon.c     ,00000]  *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000                                                                                                 531  0.019268

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

But I get the same result when I perform "r3trans -d" on another Netweaver (7.0), which is actually running.

Which additional checks can I perform?

Thanks,

Václav

Former Member
0 Kudos

Hi,

Please go to /usr/sap/SID/SYS/profile .. .Open DEFAULT.PFL and add the entry

dbms_type=ADA

As well as login as sidadm and set the environmental variable DBMS_TYPE = ADA and restart the server and check.

Hopefully it should work.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hi,

I tried your suggestion with the "ADA"-parameter (in the default profile and environment var), but unfortunately without success.

Do you have another idea what could cause the problem?

Thanks & regards

Václav

Former Member
0 Kudos

Did you restart the server after setting the environmental variable?

Former Member
0 Kudos

I restarted the server several times, but the process still remains "yellow" But thanks for this hint! What else can I check?

former_member188883
Active Contributor
0 Kudos

Hi Vaclav,

1) please check using dbmgui whether your database is online

2) Check the results from R3trans -d are positive. In case the result is same as mentioned above

     login with sid<adm>

     open the command prompt perform following

     set dbms/type=ADA 

    and then again run R3trans -d

This should work, then you have set the same variable in users profile. My computer > properties> advanced --> environment variable.

3) If step (1) and (2) are positive then , open the start profile

    Comment the line where it executes start database. This is not required as in step 1 you have ensured your database is already online.

4) Take restart of SAP. Check the results again.

Hope this helps.

Regards,

Deepak Kori

AtulKumarJain
Active Contributor
0 Kudos

Hi Vaclav,

Could you please restart the system again and check the work dir for log .

and please update the content of diff log which you found in work dir after restart like stderr* dev_disp, dev_ms .

Best Regards,

Atul

Former Member
0 Kudos

Hi Atul,

I restarted the system and looked for dev_w* and dev_disp, but both were not updated. dev_ms odes not exist in "DVEBMGS00\work". Here is the content of stderr4:

D:\usr\sap\HP3\DVEBMGS00\work>set DBNAME=NWD

D:\usr\sap\HP3\DVEBMGS00\work>set DBNAME=NWD

D:\usr\sap\HP3\DVEBMGS00\work>if "" == "" (set DB_USERKEY="c" )  else (set DB_USERKEY="c_J2EE" )

D:\usr\sap\HP3\DVEBMGS00\work>dbmcli -U "c" db_state  1>adatmp


Unfortunatelly there is not so much info in stderr*, but I hope it helps a little bit.

Thanks a lot!

Václav

Former Member
0 Kudos

Hi,

so I checked if I can connect with maxdb studio to the database, but without success. The studio is stuck during "Getting state of database", I can't even close it.

Then I tried r3trans -d (before that I used the set command, logged on as sidadm). Now I get a more info in trans.log:

4 ETW000 r3trans version 6.19 (release 720 - 24.08.10 - 14:38:42).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 28.03.2013 - 09:53:54

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]  Thu Mar 28 09:53:54 2013                                                   0  0.000000

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

4 ETW000  [dev trc     ,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                 129  0.000129

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

4 ETW000  [dev trc     ,00000]  Loading DB library 'dbsdbslib.dll' ...                                   121  0.000282

4 ETW000  [dev trc     ,00000]  DlLoadLib success: LoadLibrary("dbsdbslib.dll"), hdl 0, addr 000007FEEA870000

4 ETW000                                                                                               10366  0.010648

4 ETW000  [dev trc     ,00000]      using "D:\usr\sap\HP3\SYS\exe\uc\NTAMD64\dbsdbslib.dll"               29  0.010677

4 ETW000  [dev trc     ,00000]  Library 'dbsdbslib.dll' loaded                                            26  0.010703

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library dbsdbslib.dll                   117  0.010820

4 ETW000  [dev trc     ,00000]  Version of 'dbsdbslib.dll' is "720.00", patchlevel (0.65)                266  0.011086

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library dbsdbslib.dll                   25  0.011111

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dbsdbslib.dll                 125  0.011236

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                   102  0.011338

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=-1,command=39,arg_p=0000000000000000)            32  0.011370

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    78  0.011448

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000000202F860)            47  0.011495

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    23  0.011518

4 ETW000  [dev trc     ,00000]  New connection 0 created                                                  21  0.011539

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  57  0.011596

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000014254F468)            61  0.011657

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    23  0.011680

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

4 ETW000  [dev trc     ,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  30  0.011730

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection:                          21  0.011751

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  40  0.011791

4 ETW000  [dev trc     ,00000]  { DbSlSdbConnect(con_info_p=0000000000000000)                            226  0.012017

4 ETW000  [dev trc     ,00000]  DBSDBSLIB : version 720.00, patch 0.065 (Make PL 0.68)                    65  0.012082

4 ETW000  [dev trc     ,00000]  MAXDB shared library (dbsdbslib) patchlevels (last 10)                    25  0.012107

4 ETW000  [dev trc     ,00000]    (0.065) Send wp type to the database (note 1340617)                     38  0.012145

4 ETW000  [dev trc     ,00000]    (0.062) Row counter limit set to 65535 (note 1340617)                  126  0.012271

4 ETW000  [dev trc     ,00000]    (0.054) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000                                                                                                  46  0.012317

4 ETW000  [dev trc     ,00000]    (0.053) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000                                                                                                  32  0.012349

4 ETW000  [dev trc     ,00000]    (0.047) Connection table corrected (note 1466271)                       32  0.012381

4 ETW000  [dev trc     ,00000]    (0.045) Unknown primary key (note 1459400)                              33  0.012414

4 ETW000  [dev trc     ,00000]    (0.039) Define your own command buffersize (note 1340617)               34  0.012448

4 ETW000  [dev trc     ,00000]    (0.031) Dbm commands support added (note 1420733)                       33  0.012481

4 ETW000  [dev trc     ,00000]    (0.027) Count of records for bulk insert optimized (note 1340617)       34  0.012515

4 ETW000  [dev trc     ,00000]    (0.021) Connect with special xuser key (note 1390464)                   34  0.012549

4 ETW000  [dev trc     ,00000]                                                                            18  0.012567

4 ETW000  [dev trc     ,00000]   -> init()                                                                52  0.012619

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=10) : 00000000023DB5C0 (26 bytes allocated)           64  0.012683

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=16) : 00000000023DB5F0 (58 bytes allocated)          120  0.012803

4 ETW000  [dev trc     ,00000]    STATEMENT_CACHE_SIZE = 1000                                            131  0.012934

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=152000) : 0000000003B3CF90 (152074 bytes allocated)

4 ETW000                                                                                                 212  0.013146

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=2088000) : 0000000008AA0040 (2240090 bytes allocated)

4 ETW000                                                                                                  87  0.013233

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=288000) : 0000000003B62170 (2528106 bytes allocated)

4 ETW000                                                                                                 250  0.013483

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=16144) : 0000000003BA8690 (2544266 bytes allocated)

4 ETW000                                                                                                  84  0.013567

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=32048) : 0000000003BAC5C0 (2576330 bytes allocated)

4 ETW000                                                                                                  94  0.013661

4 ETW000  [dev trc     ,00000]   -> loadClientRuntime()                                                12104  0.025765

4 ETW000  [dev trc     ,00000]  Loading SQLDBC client runtime ...                                         49  0.025814

4 ETW000  [dev trc     ,00000]  Thu Mar 28 09:53:55 2013                                              435101  0.460915

4 ETW000  [dev trc     ,00000]  SQLDBC Module  : D:\sapdb\clients\HP3\pgm\libSQLDBC77.dll                 41  0.460956

4 ETW000  [dev trc     ,00000]  SQLDBC SDK     : SQLDBC.H  7.7.4    BUILD 009-123-173-450                179  0.461135

4 ETW000  [dev trc     ,00000]  SQLDBC Runtime : libSQLDBC 7.8.2    BUILD 023-121-242-871                 70  0.461205

4 ETW000  [dev trc     ,00000]  SQLDBC client runtime is MaxDB 7.8.2.023 CL 242871                        63  0.461268

4 ETW000  [dev trc     ,00000]  SQLDBC supports new DECIMAL interface : 1                                 39  0.461307

4 ETW000  [dev trc     ,00000]  SQLDBC supports VARIABLE INPUT data   : 1                                 23  0.461330

4 ETW000  [dev trc     ,00000]  SQLDBC supports VARIABLE OUTPUT data  : 1                                 23  0.461353

4 ETW000  [dev trc     ,00000]  SQLDBC supports Multiple Streams      : 1                                 23  0.461376

4 ETW000  [dev trc     ,00000]  SQLDBC supports LOB LOCATOR KEEPALIVE : 1                                 22  0.461398

4 ETW000  [dev trc     ,00000]  SQLDBC supports LOB LOCATOR COPY      : 1                                 23  0.461421

4 ETW000  [dev trc     ,00000]  SQLDBC supports BULK SELECT with LOBS : 1                                111  0.461532

4 ETW000  [dev trc     ,00000]   -> getNewConnection()                                                    35  0.461567

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=2160) : 0000000003BB9570 (2578506 bytes allocated)

4 ETW000                                                                                                  35  0.461602

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=1168) : 0000000003BB9E00 (2579690 bytes allocated)

4 ETW000                                                                                                 161  0.461763

4 ETW000  [dev trc     ,00000]   <- getNewConnection(con_hdl=0)                                          221  0.461984

4 ETW000  [dev trc     ,00000]   -> checkEnvironment(con_hdl=0)                                           53  0.462037

4 ETW000  [dev trc     ,00000]   -> connect()                                                             43  0.462080

4 ETW000  [dev trc     ,00000]  INFO : SQLOPT= -I 0 -t 0 -S SAPR3                                        123  0.462203

4 ETW000  [dev trc     ,00000]  Try to connect (DEFAULT) on connection 0 ...                             189  0.462392

4 ETW000  [dbsdbsql    ,00000]  *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

4 ETW000                                                                                               23030  0.485422

4 ETW000  [dev trc     ,00000]   -> SetSapdbCA(errcode=-10709)                                            37  0.485459

4 ETW000  [dev trc     ,00000]   -> freeConnection(con_hdl=0)                                             31  0.485490

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003BB9E00, size=1168 (2578506 bytes allocated))

4 ETW000                                                                                                 141  0.485631

4 ETW000  [dev trc     ,00000]     close all opened locators of connection 0                              84  0.485715

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003BB9570, size=2160 (2576330 bytes allocated))

4 ETW000                                                                                                  35  0.485750

4 ETW000  [dev trc     ,00000]  } DbSlSdbConnect(rc=99)                                                   23  0.485773

4 ETW000  [dblink      ,00000]  ***LOG BY2=>sql error -10709 performing CON                              169  0.485942

4 ETW000  [dblink      ,00000]  ***LOG BY0=>Connection failed (RTE:[5] database not running)              27  0.485969

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=41,arg_p=00000001405F8278)             86  0.486055

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    61  0.486116

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=14,arg_p=0000000002025E88)             26  0.486142

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    22  0.486164

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=50,arg_p=0000000002025E80)             54  0.486218

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    58  0.486276

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=13,arg_p=0000000002025EE0)             26  0.486302

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    21  0.486323

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=52,arg_p=0000000002025EA0)             26  0.486349

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    21  0.486370

2EETW169 no connect possible: "DBMS = ADABAS D                         --- DBNAME = ''"

4 ETW000  [dev trc     ,00000]  release memory of the SIBU buffers                                      6176  0.492546

4 ETW000  [dev trc     ,00000]  release memory of the STATEMENT CACHE                                     62  0.492608

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003BAC5C0, size=32048 (2544266 bytes allocated))

4 ETW000                                                                                                  61  0.492669

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003BA8690, size=16144 (2528106 bytes allocated))

4 ETW000                                                                                                  36  0.492705

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003B62170, size=288000 (2240090 bytes allocated))

4 ETW000                                                                                                  34  0.492739

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000008AA0040, size=2088000 (152074 bytes allocated))

4 ETW000                                                                                                  35  0.492774

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003B3CF90, size=152000 (58 bytes allocated))      2669  0.495443

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=00000000023DB5C0, size=10 (32 bytes allocated))            50  0.495493

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=00000000023DB5F0, size=16 (0 bytes allocated))             27  0.495520

I hope this may help to find the problem.

Thanks & Regards

Václav

AtulKumarJain
Active Contributor
0 Kudos

Hi ,

it is clearly updating ETW000  [dbsdbsql    ,00000]  *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))  

Please check you database and once database started please start the x_server

Best Regards,

Atul

Former Member
0 Kudos

Hi,

I tried to start maxdb with command dbmcli -d <db> -u <control user and password> db_online, but nothing happens in cmd window. Is there another way to start it or to check some logfiles? It seems that there is some db issue.

Thanks & Regards

Václav

former_member188883
Active Contributor
0 Kudos

Hi Vaclav,

Could you adjust xuser entries using the SAP note 39439.

Edit  the DEFAULT connection for user DOMAIN\SAPService<SID>

Let us know the results after this.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi,

I updated the xuser entries with following command:

xuser -c <domain>\SAPServiceHP3 -U DEFAULT -u SAPHP3,<password> -d NWD -n <hostname> -S SAPR3 -t 0 -I 0 set

But the process strdbs remains yellow. I also tested sqlcli, the result is "database is not running". Finally I tried r3trans with following result:

4 ETW000 r3trans version 6.19 (release 720 - 24.08.10 - 14:38:42).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time   : 28.03.2013 - 19:32:31

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]  Thu Mar 28 19:32:31 2013                                                   0  0.000000

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

4 ETW000  [dev trc     ,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  10  0.000010

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

4 ETW000  [dev trc     ,00000]  Loading DB library 'dbsdbslib.dll' ...                                    85  0.000129

4 ETW000  [dev trc     ,00000]  DlLoadLib success: LoadLibrary("dbsdbslib.dll"), hdl 0, addr 000007FEE9420000

4 ETW000                                                                                              221162  0.221291

4 ETW000  [dev trc     ,00000]      using "D:\usr\sap\HP3\SYS\exe\uc\NTAMD64\dbsdbslib.dll"               25  0.221316

4 ETW000  [dev trc     ,00000]  Library 'dbsdbslib.dll' loaded                                            27  0.221343

4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library dbsdbslib.dll                  7617  0.228960

4 ETW000  [dev trc     ,00000]  Thu Mar 28 19:32:32 2013                                               27059  0.256019

4 ETW000  [dev trc     ,00000]  Version of 'dbsdbslib.dll' is "720.00", patchlevel (0.65)                 32  0.256051

4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library dbsdbslib.dll                   26  0.256077

4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library dbsdbslib.dll               10402  0.266479

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                  8361  0.274840

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=-1,command=39,arg_p=0000000000000000)            30  0.274870

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                  1752  0.276622

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000000202F860)           102  0.276724

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    50  0.276774

4 ETW000  [dev trc     ,00000]  New connection 0 created                                                  22  0.276796

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                               11028  0.287824

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=-1,command=10,arg_p=000000014254F468)            78  0.287902

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    23  0.287925

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

4 ETW000  [dev trc     ,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  30  0.287976

4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection:                          21  0.287997

4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                 165  0.288162

4 ETW000  [dev trc     ,00000]  { DbSlSdbConnect(con_info_p=0000000000000000)                             72  0.288234

4 ETW000  [dev trc     ,00000]  DBSDBSLIB : version 720.00, patch 0.065 (Make PL 0.68)                   926  0.289160

4 ETW000  [dev trc     ,00000]  MAXDB shared library (dbsdbslib) patchlevels (last 10)                    27  0.289187

4 ETW000  [dev trc     ,00000]    (0.065) Send wp type to the database (note 1340617)                     37  0.289224

4 ETW000  [dev trc     ,00000]    (0.062) Row counter limit set to 65535 (note 1340617)                  137  0.289361

4 ETW000  [dev trc     ,00000]    (0.054) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000                                                                                                2787  0.292148

4 ETW000  [dev trc     ,00000]    (0.053) ABAP: Return technical database PPMS information (note 1419552)

4 ETW000                                                                                                  33  0.292181

4 ETW000  [dev trc     ,00000]    (0.047) Connection table corrected (note 1466271)                       35  0.292216

4 ETW000  [dev trc     ,00000]    (0.045) Unknown primary key (note 1459400)                              34  0.292250

4 ETW000  [dev trc     ,00000]    (0.039) Define your own command buffersize (note 1340617)             1831  0.294081

4 ETW000  [dev trc     ,00000]    (0.031) Dbm commands support added (note 1420733)                      173  0.294254

4 ETW000  [dev trc     ,00000]    (0.027) Count of records for bulk insert optimized (note 1340617)      770  0.295024

4 ETW000  [dev trc     ,00000]    (0.021) Connect with special xuser key (note 1390464)                   37  0.295061

4 ETW000  [dev trc     ,00000]                                                                            19  0.295080

4 ETW000  [dev trc     ,00000]   -> init()                                                              2310  0.297390

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=10) : 0000000003C2C470 (26 bytes allocated)           88  0.297478

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=16) : 0000000003C2C4A0 (58 bytes allocated)          121  0.297599

4 ETW000  [dev trc     ,00000]    STATEMENT_CACHE_SIZE = 1000                                           1523  0.299122

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=152000) : 0000000003AACFB0 (152074 bytes allocated)

4 ETW000                                                                                                3167  0.302289

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=2088000) : 00000000089A0040 (2240090 bytes allocated)

4 ETW000                                                                                                  77  0.302366

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=288000) : 0000000003AD2190 (2528106 bytes allocated)

4 ETW000                                                                                                 237  0.302603

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=16144) : 0000000003B186B0 (2544266 bytes allocated)

4 ETW000                                                                                                  87  0.302690

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=32048) : 0000000003B1C5E0 (2576330 bytes allocated)

4 ETW000                                                                                                  97  0.302787

4 ETW000  [dev trc     ,00000]   -> loadClientRuntime()                                                13037  0.315824

4 ETW000  [dev trc     ,00000]  Loading SQLDBC client runtime ...                                         50  0.315874

4 ETW000  [dev trc     ,00000]  SQLDBC Module  : D:\sapdb\clients\HP3\pgm\libSQLDBC77.dll             563371  0.879245

4 ETW000  [dev trc     ,00000]  SQLDBC SDK     : SQLDBC.H  7.7.4    BUILD 009-123-173-450              27099  0.906344

4 ETW000  [dev trc     ,00000]  SQLDBC Runtime : libSQLDBC 7.8.2    BUILD 023-121-242-871                 79  0.906423

4 ETW000  [dev trc     ,00000]  SQLDBC client runtime is MaxDB 7.8.2.023 CL 242871                        62  0.906485

4 ETW000  [dev trc     ,00000]  SQLDBC supports new DECIMAL interface : 1                                 39  0.906524

4 ETW000  [dev trc     ,00000]  SQLDBC supports VARIABLE INPUT data   : 1                                 23  0.906547

4 ETW000  [dev trc     ,00000]  SQLDBC supports VARIABLE OUTPUT data  : 1                                 23  0.906570

4 ETW000  [dev trc     ,00000]  SQLDBC supports Multiple Streams      : 1                                 23  0.906593

4 ETW000  [dev trc     ,00000]  SQLDBC supports LOB LOCATOR KEEPALIVE : 1                                 23  0.906616

4 ETW000  [dev trc     ,00000]  SQLDBC supports LOB LOCATOR COPY      : 1                                 23  0.906639

4 ETW000  [dev trc     ,00000]  SQLDBC supports BULK SELECT with LOBS : 1                                115  0.906754

4 ETW000  [dev trc     ,00000]   -> getNewConnection()                                                    34  0.906788

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=2160) : 0000000003B29520 (2578506 bytes allocated)

4 ETW000                                                                                                  36  0.906824

4 ETW000  [dev trc     ,00000]   -> sdb_malloc(size=1168) : 0000000003B29DB0 (2579690 bytes allocated)

4 ETW000                                                                                               33907  0.940731

4 ETW000  [dev trc     ,00000]   <- getNewConnection(con_hdl=0)                                        15491  0.956222

4 ETW000  [dev trc     ,00000]   -> checkEnvironment(con_hdl=0)                                           56  0.956278

4 ETW000  [dev trc     ,00000]   -> connect()                                                             46  0.956324

4 ETW000  [dev trc     ,00000]  INFO : SQLOPT= -I 0 -t 0 -S SAPR3                                         97  0.956421

4 ETW000  [dev trc     ,00000]  Try to connect (DEFAULT) on connection 0 ...                             191  0.956612

4 ETW000  [dbsdbsql    ,00000]  *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:[5] database not running))

4 ETW000                                                                                               52965  1.009577

4 ETW000  [dev trc     ,00000]   -> SetSapdbCA(errcode=-10709)                                            38  1.009615

4 ETW000  [dev trc     ,00000]   -> freeConnection(con_hdl=0)                                             32  1.009647

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003B29DB0, size=1168 (2578506 bytes allocated))

4 ETW000                                                                                                9602  1.019249

4 ETW000  [dev trc     ,00000]     close all opened locators of connection 0                            3021  1.022270

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003B29520, size=2160 (2576330 bytes allocated))

4 ETW000                                                                                                  37  1.022307

4 ETW000  [dev trc     ,00000]  } DbSlSdbConnect(rc=99)                                                   23  1.022330

4 ETW000  [dblink      ,00000]  ***LOG BY2=>sql error -10709 performing CON                            20636  1.042966

4 ETW000  [dblink      ,00000]  ***LOG BY0=>Connection failed (RTE:[5] database not running)              31  1.042997

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=41,arg_p=00000001405F8278)           6580  1.049577

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    66  1.049643

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=14,arg_p=0000000002025E88)             27  1.049670

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    22  1.049692

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=50,arg_p=0000000002025E80)             95  1.049787

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    58  1.049845

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=13,arg_p=0000000002025EE0)             26  1.049871

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    21  1.049892

4 ETW000  [dev trc     ,00000]  { DbSlSdbControl(con_hdl=0,command=52,arg_p=0000000002025EA0)             25  1.049917

4 ETW000  [dev trc     ,00000]  } DbSlSdbControl(rc=0)                                                    21  1.049938

2EETW169 no connect possible: "DBMS = ADABAS D                         --- DBNAME = ''"

4 ETW000  [dev trc     ,00000]  release memory of the SIBU buffers                                      4300  1.054238

4 ETW000  [dev trc     ,00000]  release memory of the STATEMENT CACHE                                    109  1.054347

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003B1C5E0, size=32048 (2544266 bytes allocated))

4 ETW000                                                                                                  62  1.054409

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003B186B0, size=16144 (2528106 bytes allocated))

4 ETW000                                                                                                  36  1.054445

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003AD2190, size=288000 (2240090 bytes allocated))

4 ETW000                                                                                                  34  1.054479

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=00000000089A0040, size=2088000 (152074 bytes allocated))

4 ETW000                                                                                                  34  1.054513

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003AACFB0, size=152000 (58 bytes allocated))      2662  1.057175

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003C2C470, size=10 (32 bytes allocated))            49  1.057224

4 ETW000  [dev trc     ,00000]   -> sdb_free(p=0000000003C2C4A0, size=16 (0 bytes allocated))             26  1.057250

Thanks & Regards

Václav

Former Member
0 Kudos

Hi Vaclav

I dont have much experience with MaxDB but after reading your question I first thought of checking the MaxDB logs which might point to a possible root cause of DB not starting. E.g. knldiag.

Please check this link for a list of MaxDB log files: http://wiki.sdn.sap.com/wiki/display/MaxDB/MaxDB+log+files

DB log files will give some error message and based on that you have to trouble shoot the issue.

For e.g. --> http://scn.sap.com/thread/1713461

-Roshan

Former Member
0 Kudos

Hi Roshan,

Thank you for the link, the list of all available logfiles is very useful. But the maxdb logfiles are not up to date. Here is what I did:

  • Try to start SAP NW in SAP MMC:

  • dbmcli.exe db_enum with following result:

  • But when I perform dbmcli with option db_state or db_online, nothing happens. The maxdb logfiles are not updated

Do you have an idea what I can check as next? It seems to me to be some kind of maxdb problem.

Regards & Thanks a lot

Václav

AtulKumarJain
Active Contributor
0 Kudos

Hi Vaclav,

Please check the

http://scn.sap.com/thread/1982920

please update you maxdb version if possible.

Best Regards,

Atul

Former Member
0 Kudos

Hi Atul,

I will open a discussion in the MaxDB group, too. Maybe someone could help me there. If not, I'll try to Update the database to 7.9.

I will inform you guys on the further progress of my problem. I think the soluition may be interesting for anyone with similar problems.

Thanks & Regards

Václav

Former Member
0 Kudos

Hi,

It seems that there is some memory bottle neck.

Try to restart the server to free up the memory and try starting and check whether it come up or not.

Did you perform any kernel upgrade or any other activity like server patching...etc

Thanks and Regards,

Vimal

AtulKumarJain
Active Contributor
0 Kudos

Hi ,

could you please check you db ,isit up or not.

you can check R3trans -d for connectivity between R3 and DB.

Please provide more log for info.

Best Regards,

Atul