IV93978: WHEN RUNNING LOCATIONS APPLICATION IMPORT FUNCTION, GET DB2 CURSORS LEAKING.

APAR status

• Closed as program error.

Error description

• Environment:
  IBM WebSphere Application Server 8.5.5.9
  Tivoli's process automation engine 7.6.0.5-IFIX20160914-1206
  Build
  20160611-0100 DB Build V7605-45 HFDB Build HF7605-04
  IBM TPAE Integration Framework
  7.6.0.5-MIF_7605_IFIX.20160920-1010
  Build 20160610-2330 DB Build V7605-50 HFDB Build HF7605-03
  IBM Maximo Asset Management Work Centers 7.6.0.0 Build
  20160610-1318 DB Build V7600-38
  IBM Maximo Asset Management 7.6.0.5 Build 20160611-0100 DB
  Build V7604-01
  Linux 2.6.32-573.el6.x86_64
  DB DB2/LINUXX8664 10.5 (SQL10057)
  
  Concerns/Problem:
  When the customer import 500 location records with Locations
  Application Import function, some DB2 cursors keep opening and
  can not be released.
  This issue also occurs when run the application import to
  delete the imported locations. The DB2 cursors keep opening
  after the locations are deleted.
  
  
  
  Steps to reproduce the issue:
  1. Create a new object structure. Object has LOCATIONS only.
  Check the Support Flat Structure check box.
  2. Exclude all attributes except the below 5 attributes:
  Location
  Description
  Status
  Siteid
  Type
  Parent
  Systemid
  3. From Object Structures application ? select action menu,
  open Add/Modify Application Import support. Add Application =
  Location
  Default File Type = Flat File.
  4. Add the application import function to maxadmin group in
  Security Groups application ? application = Location.
  5. Go to Locations application, open the application import
  dialog box, select the import file.
  6. Before run the application import, run the below query on
  the DB2 command console:
  db2 select agent_id,open_loc_curs,open_rem_curs from
  sysibmadm.snapappl
  When running the application importing, run the above query
  again.
  After finish the application import, run the above query again.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users using the application import to import new      *
  * locations with systems and parents                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Cursor leak when importing locations with systemid and       *
  * parent using the Application Import functionality in the     *
  * Locations app..                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * nonr                                                         *
  ****************************************************************
  

Problem conclusion

• This is fixed in code.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.0.8 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:

Modules/Macros

• Maximo
  

Fix information

• Fixed component name

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels

• R760 PSY

     UP