IV46183: CONNECTION IS CLOSED

APAR status

• Closed as program error.

Error description

• com.ibm.db2.jcc.am.SqlNonTransientConnectionException:
  [jcc][t4][10335][10366][3.64.96] Invalid operation: Connection
  is
  closed.
  ERRORCODE=-4470, SQLSTATE=08003
  
  
  The error is happening in our SCE+ TEST environment (with
  environment
  details below). The error occurs at different steps, without a
  certain
  pattern (at least so far).
  

Local fix

• No workaround
  

Problem summary

• Problem summary:
  Larger number of open database connections .
  
  maxOperations = getMaxConcurrentServerOperations(conn,
  overLimit);
  
  It is defined inside do - while loop . So , the database
  connection will be alive as soon as loop executes which finally
  result in a large number of open database connection.
  

Problem conclusion

• Conclusion:
  Added following piece of code in ServerOperationHelper.java .
  above do - while loop .
  
  conn = ConnectionManager.getConnection();
  +              maxOperations =
  getMaxConcurrentServerOperations(conn, overLimit);
  +              if (conn != null) {
  +                try {
  +                  ConnectionManager.closeConnection(conn);
  +                }
  +                catch (Throwable t) {
  +                  t.printStackTrace();
  +                }
  +              }
  
  Logic here is connection will immediately get closed after
  getting the value of maxOperations .
  
  Fix included on TSAM 7.2.4.3
  

Temporary fix

Comments

APAR Information

• 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

  TSAM (& INSTALL

• Fixed component ID

  5724W7800

Applicable component levels