IJ37079: DATABASE CONNECTION LEAK WHEN A USER NAVIGATES TO A TAB AND THE FIELD IS LOADED WITH DATA

APAR status

• Closed as program error.

Error description

• Description:
  Database connection leak when a user navigates to a tab and the
  field is loaded with data.
  
  We are unable to identify the steps. The stack trace shows that
  is was triggered when a user navigates to a Tab and the field is
  loaded.
  
  The code is calling the MboSet.isEmpty method and that is known
  to leak DB connections if there are multiple records in the
  MBOSet.
  The logs show that this is leaked for 5 minutes.
  
  Conn refs:
  1073301
  
  RESULT:
  The DB connection watchdog is generating a warning. MBOSet/DB
  connection related resources are being used too long.
  
  EXPECTED RESULT:
  MBOSet should be closed immediately after it is used. It should
  not leak and generate this warning.
  The isEmpty call can be replaced by a call to notExists.
  notExists does not leak a DB connection.
  
  PRODUCT:
  TPAE 7612
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Database connection leak when a user navigates to a tab and  *
  * the                                                          *
  * field is loaded with data.                                   *
  ****************************************************************
  

Problem conclusion

• _The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Product_
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels