db2 database crash

[Former Member]

Hi All,

I am new to SAP DB2,

We are using SAP PI 7.3 with database as DB2 server when restarted the system unable to start up the database.

Please below attached log.

Regards,

Sandeep Singh

1db2diag.txt.zip

[AtulKumarJain · Accepted solution]

Hi Sandeep,

Please check below link

http://www-01.ibm.com/support/docview.wss?uid=swg1IC76890

you can try below step to free memory resources

1. db2stop

run db2_kill if it fails or does not return.

.

2. ps -ef   grep

- make sure there are no processes running under the instance user

   ID. if there are, kill them.

.

3. ipclean

.

4.ipcs -a   grep

- this should come back with no output. If it does, ipclean failed

to clear up the IPC resources, and you will have to delete them

yourself using ipcrm -q (for message queues),

-m (for shared memory) or

-s (for semaphores).

Best Regards,

Atul

[former_member188883]

Hi Sandeep,

Could you check whether db2 license has been applied on the system.

Additional share which OS version you have install PI 7.3

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

db2 license has been applied on the system, os version is RHEL 6.2

Regards,

Sandeep Singh

[former_member215961]

Hi,

The db2 log server detected a lock and cannot start db:

Detected kernel config that is incompatible with DB2 NUMA support.

2013-05-07-15.02.55.884014+480 I3849E278           LEVEL: Severe

PID     : 11180                TID  : 140547614037792PROC : db2star2

INSTANCE: db2ids               NODE : 000

FUNCTION: DB2 UDB, base sys utilities, sqleInitEventLog, probe:5

RETCODE : ZRC=0x900003DE=-1879047202

2013-05-07-15.02.55.884170+480 I4128E357           LEVEL: Severe

PID     : 11180                TID  : 140547614037792PROC : db2star2

INSTANCE: db2ids               NODE : 000

FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:580

MESSAGE : ECF=0x900003DE=-1879047202=ECF_TRCAPI_MUTEX_LOCK_ERROR

          Trace facility mutex unexpected lock error

2013-05-07-15.02.55.959094+480 I4486E298           LEVEL: Event

PID     : 11104                TID  : 140227586066208PROC : db2start

INSTANCE: db2ids               NODE : 000

FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:190

DATA #1 : <preformatted>

Single node stopped [-1032].

Please see if there the server stoped sucsessfully. Then you can remove the lock and start db again.

Cheers

[former_member215961]

Hi,

Try to start it again : startsap or db2start from a db2 command line.

It's a know error :

www-01.ibm.com/support/docview.wss?uid=swg1IC76890

Cheers

[Former Member]

Hi Sargan,

Already tried the above link no luck

Regards,

Sandeep Singh

[former_member215961]

Please set SHMAX kernel parameter and try to start it again.

Cheers