sdbstarter many processes

[andreas_zigann]

Hello,

at one server I have got about 700 sdbstarter processes, but only 80 sessions on databases. Installed are three SCM Systems, two with seperated MAXDB and LC and one with a combined LC and MAXDB-Instance.

Independend path is of version 7.6.02.14 from LC instances, SCM databases are of version 7.6.00.35. The ONE-DB SCM-System has version 7.6.00.35.

Regards

Andreas

[markus_doehr2 · Accepted solution]

> at one server I have got about 700 sdbstarter processes

wow...

> Independend path is of version 7.6.02.14 from LC instances, SCM databases are of version 7.6.00.35. The ONE-DB SCM-System has version 7.6.00.35.

I would suggest updating that 7.6.00.35 to a newer version. I remember there were some problems with that (ancient) version.

Markus

[andreas_zigann · Accepted solution]

ok. I will try an update, thanks.

[andreas_zigann]

Hello again.

after three years of silence I get the same error again.

We are using now the following Versions:

LC: 7.6.05.12

DB: 7.6.06.23

We are running at SLES 11, Database and Livecache at one Server.

Actually we have about 3900 processes at this server, nearly all of the Livecache instance mostly in combination with a vserver process:

for exsample:

sdb      15418 28141  0 Dec06 ?        00:00:00 /sapdb/programs/pgm/vserver start

sdb      15419 15418  0 Dec06 ?        00:00:00 /sapdb/LHP/db/pgm/dbmsrv -sdbstarter 1070 1050 A -P 000000030000000A0000000B0000000E

Everyday there are around 500 new processes.

I have done a paramtercheck, everything is ok.

Which application creates these processes?

Which parameters influence the creation?

I thougt about wrong settings in xuser timeout or xuser sqlmode.

Also I thougt about wrong settings at DB59. But it seems all right.

Any idea?

Best Regards

Andreas

[yashwanthkumar_kethineed]

Hello Andreas,

This problem has to be analyzed at the OS level.

Are you an SAP Customer ?

If yes, please create a CSN tickect - with above problem description and provide an OS connection to the affected system.

Regards,Yashwanth

[former_member229109]

   Hello Andreas,

two processes started when DB client connected Remotely to LHP database.

  Is LHP ONEDB for SCM 5.0 system, version – 7.6.05.12?

  “Overview of Processes” - http://maxdb.sap.com/doc/7_6/41/8734b031591035e10000000a114cbd/content.htm

After client closed the connection, the vserver & dbmsrv processes started for this client session should be released.

How many appl. servers do you have on your system?

How many WPs currently connected to the database?

  -> Since 3 years of your first post in this thread there are improvements/fixes made in the database software and you updated the database instances too.

  Reference to SAP notes –  806690 and 1041650

Please post the output of the commands – “sdbregview –l” and “dbmcli db_enum”

->  Is /var/lib/sdb a local directory on the LHP database server?

  Check the errors in the xserver_<DBseverNama>.prt and dbmsrv_<DBserverName>.prt.

-> Please post the output of dbm command  dbm_shm_info.

  Dbmcli –d LHP –u control,<pwd> dbm_shm_info

Then run “ps –ef | grep /sapdb/LHP/db/pgm/dbmsrv” and compare it with list of alive pids listed in PROCESSES section, output of dbm command  dbm_shm_info.

  -> Did you create SAP message where you reported this issue?

   Regards, Natalia Khlopina

[andreas_zigann]

Seems to be a Problem of Database Kernel

[lbreddemann]

How so?

The sdbstarter processes are outside the kernel - so how should the kernel be the issue here?

Have you installed a patch or changed anything?