Fix IPC for DB2 with Opensuse 15.3: Difference between revisions

From JoBaPedia
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