StaleConnectionException on Linux systems

Linux systems have a semaphore problem causing the DB2 stale connection exception SQL1224 error. This is related to the extension shared memory attachment.

To work around the problem, set the loopback for your database. For example, if your database is WAS, host name is LHOST, and database service port number is 50000, issue the following commands from the DB2 command line window

 db2 catalog TCPIP node RHOST remote LHOST server 50000
 db2 catalog WAS as WASAlias
 db2 uncatalog db WAS
 db2 catalog WASAlias as WAS at node RHOST

Verify this by issuing the following commands from the DB2 command line window

db2 connect to WAS user xxx
passwd: xxx

 

---