Fix IPC for DB2 with Opensuse 15.3

From JoBaPedia
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Fix DB2 crashes due to IPC removed on logout 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