CPU Usage MAXCPU 2

[Former Member]

Hi there,

We are running MaxDB 7.6.05.09 64bit on an SLES 9 64bit.

MAXCPU is 2.

sdb 6978 0.0 0.0 108616 6120 ? Ssl Sep20 0:00 /sapdb/PF1/db/pgm/kernel PF1

sdb 6984 4.4 11.9 1887800 976996 ? Sl Sep20 195:23 /sapdb/PF1/db/pgm/kernel PF1

Question:

Why does the second database kernel Process not use any CPU Time?

Is this normal? (0:00 vs 195:23 seconds)

Regards

Manuel

[markus_doehr2 · Accepted solution]

Yes.

MaxDB is a multi-THREADED database, you will see only one process but it has many threads. The fist process is just the "starter", it forks the second one which is then the actual database.

You can check the threads by using

ps -ef -L

To see what the database threads are doing, login as sqd<SID> and execute

x_cons <SID> sh ac 1

Markus

[Former Member · Accepted solution]

Hi Markus,

thx 4 answer.

I knew that MaxDB is a Multithreaded DB, but the Starter Process confused me

Regards

Manuel