PI49072: INCREASE CALLS TO THE OPENJPA_SEQUENCE_TABLE TABLE MAY CAUSE ROW LOCKS

IBM Worklight Interim Fix README for 6.0.0.2

APAR status

• Closed as program error.

Error description

• Increase calls to the  OPENJPA_SEQUENCE_TABLE table may cause
  row locks
  

Local fix

• -
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users who work with reports                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The server is fetching data from sequence table too often.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * -                                                            *
  ****************************************************************
  

Problem conclusion

• Code was changed to allocate larger amount of keys each time, by
  that going to the database less.
  

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

  MFPF/WORKLIGHT

• Fixed component ID

  5725I4301

Applicable component levels

• R600 PSY

     UP