dbmserv process is taking 100% cpu utilization

[Former Member]

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 · Accepted solution]

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:

1. x_cons <SID> sh ac
2. x_cons <SID> sh all
3. dbmcli db_enum
4. 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 · Accepted solution]

Hi yashwanth,

                       Problem is solved , its due to shared memory. 

Refer below link

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

[yashwanthkumar_kethineed · Accepted solution]

Hi,

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

[Former Member · Accepted solution]

Yes I did.

[Former Member · Accepted solution]

Yes I did.