Question Re: dbmserv process is taking 100% cpu utilization in Technology Q&A

dbmserv process is taking 100% cpu utilization

Former Member — Tue, 20 Nov 2012 05:40:43 GMT

Hi,

Due to network problem server is restarted unexpectedly.

While starting the sap , dbmserv process is taking 100% cpu utilization.

I am not able to connect to the database with the dbmcli command,it also hangs.

Please help on this ....

yashwanthkumar_kethineed — Tue, 20 Nov 2012 18:39:50 GMT

Hello,

Please provide more information about the problem:

What is version of MaxDB Installed ?

Post the output of command "ps -ef | grep dbmsrv"

Let me know the result of following commands:

x_cons <SID> sh ac
x_cons <SID> sh all
dbmcli db_enum
dbmcli -d <SID> -u control,<password> -uSQL superdba,<password> sql_execute select * from running_commands

In any case, usually this kind of issues can be avoided by implementing the latest MaxDB patch.

Regards.

Yashwanth

Former Member — Wed, 21 Nov 2012 12:21:23 GMT

Hi yashwanth,

Problem is solved , its due to shared memory.

Refer below link

yashwanthkumar_kethineed — Wed, 21 Nov 2012 17:28:21 GMT

Hi,

Did you rename the *.shm and *.shi files ?

Former Member — Thu, 22 Nov 2012 05:25:08 GMT

Yes I did.

Former Member — Thu, 22 Nov 2012 05:25:10 GMT

Yes I did.