Fix IPC for DB2 with Opensuse 15.3
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