StaleConnectionException on Linux systems

The StaleConnectionException SQL1224 is related to extension shared memory attachment. Linux systems have a semaphore problem causing the DB2 SQL1224 error.

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

 

---