PI56342: Q APPLY EXHAUSTS MEMORY WHEN WORKLOAD SHIFTS BETWEEN SMALL SIZED AND LARGE SIZED ROW CHANGES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Q Apply exhausts memory when workload shifts between small and
  large sized row changes.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- Q Apply                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Q Apply may end up using excessive   *
  *                      memory for internal row cache when      *
  *                      source workload shifts from small       *
  *                      sized row changes to large sized row    *
  *                      changes.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- Q Apply may aggressively cache internal row structures when
  applying source workload that has very small sized row changes.
  When the workload later shifts to using large sized row
  changes, the cache cannot be effectively reused leading to
  excessive memory usage and memory exhaustion.
  

Problem conclusion

Temporary fix

Comments

• 1- Q Apply is fixed to use less memory for internal row
  structures and to release row cache memory when no longer
  needed.
  ×**** PE16/03/23 FIX IN ERROR. SEE APAR PI56838  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI35094 UI35093 UI35095 UI35096

Modules/Macros

•    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCCMD
  ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQAROW ASNQASUB ASNQCAP
  ASNQCCMD ASNQDEP  ASNQEXRP ASNQMFMT ASNQSPIL ASNQXFMT ASNRBASE
  ASNTDIFF ASNTDSP  ASNTRC   ASN2BASE
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RA21 PSY UI35093

     UP16/02/16 P F602

• RA24 PSY UI35094

     UP16/02/16 P F602

• RA25 PSY UI35095

     UP16/02/16 P F602

• RA26 PSY UI35096

     UP16/02/16 P F602

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.