IBM Support

DB2 error causes InterChange Server to shutdown immediately.

Troubleshooting


Problem

InterChange Server stops during processing due to DB2 error.

Symptom

Following DB2 error message is observed in ICS log:

"A connection to data source jdbc:db2:datasource cannot be made.    
[info]:: (SQLState [HY001]:[IBM][CLI Driver] CLI0120E  Memory allocation
failure. SQLSTATE=HY001DB specific error:-99999)]"

After this error message the log states that ICS was shutdown immediately.

Cause

This technote is applicable if you are on DB2 version earlier than v8.1 fix pack 16(which is also known as v8.2 fix pack 9). There is a known memory allocation problem in the mentioned versions of DB2. If ICS encounters database issues then it will shutdown immediately.

Diagnosing The Problem

If the InterChange Server log includes the DB2 error listed in the "Symptom" section of this technote, open the db2diag.log file under DB2 directory. For more information about the problem, search the following message for the time stamp that corresponds to the DB2 error in the InterChange Server log:

2006-11-19-20.14.28.108305-300 E303462C556        LEVEL: Severe
(OS)
PID     : 214536               TID  : 1           PROC :
db2agent
(instance) 2
INSTANCE: db2sabit             NODE : 002
APPHDL  : 2-1447               APPID: OA53A72C.PBC0.037D90011428
FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs,
probe:100
CALLED  : OS, -, malloc
OSERR   : ENOMEM (12) "There is not enough memory available
now."
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
152096768


The resolution for this issue applies if you encounter the above message.

Please refer to this DB2 technote which has more information on the error in db2diag.log: http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg1IY96458

Resolving The Problem

To prevent the InterChange Server shutdown problem, upgrade to DB2 Universal Database V8.1 fix pack 16( also known as v8.2 fixpack 9) or higher.

For information about InterChange Server compatibility with DB2, refer to the following technote: http://www-01.ibm.com/support/docview.wss?rs=693&uid=swg27006396.

[{"Product":{"code":"SSBTEG","label":"WebSphere InterChange Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"4.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg21381776