RHEL or CentOS 6.6 (first seen in kernel level 2.6.32-434.el6) contains a semaphore release defect which may cause DB2 connections to hang when the client and server reside on the same host. Remote connections (i.e. through TCPIP) are not susceptible.
DB2 connections may hang. If a stack is generated from the application process using gstack, the the stack will show the semop() function at the top.
Resolving The Problem
The semaphore release defect is addressed in RHEL bugzilla 1165277.
Please visit the following link for the Redhat publically available patch:
As a workaround, TCP/IP loopback can be used in order to connect to a local database instead of connecting over IPC using the local indirect alias. To create a loopback connection, see Configuring client-to-server connections using the command line processor and use the local hostname and port number when cataloging the TCP/IP node
Was this topic helpful?
16 June 2018