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 RHOSTVerify this by issuing the following commands from the DB2 command line window:
db2 connect to WAS user xxx passwd: xxx
Related reference
Example: Handling