IJ18303: CONNECTIONS NOT CLOSING CAUSING INACTIVE CONNECTION BUILDUP

APAR status

• Closed as program error.

Error description

• Maximo is not closing connections properly, which can cause a
  buildup of long running and inactive connections in the
  database.
  
  STEPS TO REPRODUCE:
  Allow Maximo to run for an extended period of time.
  
  CURRENT ERRONEOUS RESULT:
  Connections will continuously buildup, causing a strain on the
  database.
  
  EXPECTED RESULTS:
  Maximo should close connections properly.
  
  REPORTED IN VERSION:
  Tivoli's process automation engine 7.6.1.1 Build 20190514-1348
  DB Build V7611-365
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CONNECTIONS NOT CLOSING CAUSING INACTIVE CONNECTION BUILDUP  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * add finally block to close database connection               *
  ****************************************************************
  

Problem conclusion

• the block was moved to fix MT issue which cause breaking in
  regular on-prem enviornmnt
  

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

  SYSTEM PERFORMA

• Fixed component ID

  5724R46PF

Applicable component levels