A fix is available
APAR status
Closed as program error.
Error description
When migratedDB.py is executed, depending on the chosen slice size a lot of database connections can be used up and may not be freed properly
Local fix
N/A
Problem summary
Problem Description: The migrateDb.py migration script might terminate with the following exception: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001 Problem Summary: The migrateDb.py migration script might terminate with the following exception: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][3.64.82] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill() - insufficient data (-1). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001 at com.ibm.db2.jcc.am.bd.a(bd.java:321) at com.ibm.db2.jcc.t4.a.a(a.java:501) at com.ibm.db2.jcc.t4.a.a(a.java:496) at com.ibm.db2.jcc.t4.x.b(x.java:334) at com.ibm.db2.jcc.t4.x.c(x.java:360) at com.ibm.db2.jcc.t4.x.c(x.java:473) at com.ibm.db2.jcc.t4.x.v(x.java:1241) at com.ibm.db2.jcc.t4.y.a(y.java:47) at com.ibm.db2.jcc.t4.b.c(b.java:1349) at com.ibm.db2.jcc.t4.b.b(b.java:1221) at com.ibm.db2.jcc.t4.b.b(b.java:788) at com.ibm.db2.jcc.t4.b.a(b.java:760) at com.ibm.db2.jcc.t4.b.a(b.java:421) at com.ibm.db2.jcc.t4.b.a(b.java:396) at com.ibm.db2.jcc.t4.b.<init>(b.java:334) at com.ibm.db2.jcc.t4.T4XAConnection.<init>(T4XAConnection.java:32) at com.ibm.db2.jcc.DB2PooledConnection.<init>(DB2PooledConnection.j ava:199) at com.ibm.db2.jcc.DB2XAConnection.<init>(DB2XAConnection.java:56) at com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource. java:167) at com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource. java:135) at com.ibm.bpe.database.ConnectionHandler.getConnection(ConnectionH andler.java:152) at com.ibm.bpe.database.WiAssocBucketMigrationWorker.execute(WiAsso cBucketMigrationWorker.java:106) at com.ibm.bpe.database.WiAssocBucketMigrationThread.run(WiAssocBuc ketMigrationThread.java:111) For XA or pooled data sources, the migrateDb.py scripts opens too many connections to the database. Problem Conclusion: This iFix limits the number of active database connections and closes closes database connections earlier.
Problem conclusion
Problem fixed iFix available on top of V751 FP1
Temporary fix
Comments
APAR Information
APAR number
JR43708
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-08-09
Closed date
2013-01-07
Last modified date
2013-01-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
R751 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
12 October 2021