Fix IPC for DB2 with Opensuse 15.3

From JoBaPedia
Revision as of 13:13, 5 May 2022 by Joachim (talk | contribs) (Created page with "= Fix DB2 crashes due to IPC on Opensuse 15.3 = == Diagnosis == after an OS update recently DB2 stops shortly after starting. Messages in the diaglog look like this: 2022-05-05-14.15.13.311305+120 I68340E1888 LEVEL: Severe (OS) PID : 25701 TID : 139866616620800 PROC : db2sysc 0 INSTANCE: db2mspr NODE : 000 HOSTNAME: job4 EDUID : 12 EDUNAME: db2thcln 0 FUNCTION: DB2 UDB, oper system services, sqloWait...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Fix DB2 crashes due to IPC on Opensuse 15.3

Diagnosis

after an OS update recently DB2 stops shortly after starting. Messages in the diaglog look like this:

2022-05-05-14.15.13.311305+120 I68340E1888           LEVEL: Severe (OS)
PID     : 25701                TID : 139866616620800 PROC : db2sysc 0
INSTANCE: db2mspr              NODE : 000
HOSTNAME: job4
EDUID   : 12                   EDUNAME: db2thcln 0
FUNCTION: DB2 UDB, oper system services, sqloWaitEDUWaitPost, probe:100
MESSAGE : ZRC=0x8300002B=-2097151957
          
CALLED  : OS, -, semop                            OSERR: EIDRM (43)
DATA #1 : timeout value, 4 bytes
-1

Application errors state DB2 is in an inconsistent state or it cannot handle new requests.

Cause

Opensuse has changed a systemd login parameter. Change it back and all is good again :)

Remedy

edit /etc/systemd/logind.conf and make sure this option is set:

[Login]
...
RemoveIPC=no

Restart the login daemon for the change to take effect

systemctl restart systemd-logind

Restart DB2

sudo su - db2mspr -c db2start