Fix IPC for DB2 with Opensuse 15.3: Difference between revisions
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Revision as of 13:13, 5 May 2022
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