PI57597: POOR PERFORMANCE INSERTING MANY TRANSACTIONS INTO TRANSACTION TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When performing a transactional recovery that handles a large
  number of transactions, the process of inserting those
  transactions can take a long amount of time.  It was found that
  table ARY_TXNR_URID has many indexes, and it was also
  determined that dropping all indexes on this table, except for
  index ARY_TXNR_URID_IX, greatly improved performance,
  COMPRESS NO will be used for remaining indexes.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Recovery Expert z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When performing a transactional         *
  *                      recovery that handles a large number    *
  *                      of transactions, the process of         *
  *                      inserting those transactions can take   *
  *                      a long amount of time.  It was found    *
  *                      that table ARY_TXNR_URID has many       *
  *                      indexes, and it was also determined     *
  *                      that dropping all indexes on this       *
  *                      table, except for index                 *
  *                      ARY_TXNR_URID_IX, greatly improved      *
  *                      performance, COMPRESS NO will be used   *
  *                      for remaining indexes.                  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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

•    ARY$$SEQ
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R320 PSY UI39358

     UP16/07/27 P F607

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.