PH41662: UNION ALL STORAGE MANAGEMENT AND MRC SUPPORT FOR UNION ALL SQL

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• UNION ALL storage management and MRC support for UNION ALL SQL
  - UNION ALL of 2 Db2 uses a lot of memory - Phase 1
  - UNION ALL of n number of Db2 uses a lot of memory
    and runs long - Phase 2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH41662                                 *
  *                      UNION ALL of n number of Db2 uses a     *
  *                      lot of memory and runs long - Phase 2   *
  *                      UNION ALL of 2 Db2 uses a lot of        *
  *                      memory - Phase 1 UNION ALL of 2 Db2     *
  *                      uses a lot of memory - Phase 1          *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH41662
  UNION ALL of n number of Db2 uses a lot of memory and runs long
  - Phase 2
  UNION ALL of 2 Db2 uses a lot of memory - Phase 1 UNION ALL of
  2 Db2 uses a lot of memory - Phase 1
  

Problem conclusion

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

• AVZ$532E AVZ$532M AVZCBDBK AVZCBKRW AVZCCM64 AVZCCRDC AVZCCUBI
  AVZCCUBU AVZCD2CL AVZCDBIF AVZCDCCB AVZCDSEY AVZCFAPI AVZCFIRQ
  AVZCFR64 AVZCGTCM AVZCIDCL AVZCIMCL AVZCISCL AVZCPREV AVZCPRHL
  AVZCRDBD AVZCSQCM AVZCSQOP AVZCSVCL AVZCTGOP AVZCTROF AVZCTRON
  AVZDRATH AVZEISER AVZMFMIG AVZO319D AVZO319N AVZO31AD AVZO31AN
  AVZO31BD AVZO31BN AVZO31CD AVZO31CN AVZO31DD AVZO31DN AVZO649D
  AVZO649N AVZO64AD AVZO64AN AVZO64BD AVZO64BN AVZO64CD AVZO64CN
  AVZO64DD AVZO64DN AVZOAOPR AVZOAUCK AVZOBJ   AVZOBRIM AVZOBRSQ
  AVZOCKLM AVZOCXA0 AVZOCXIN AVZODARU AVZODBTP AVZODF9D AVZODF9N
  AVZODFAD AVZODFAN AVZODFBD AVZODFBN AVZODFCD AVZODFCN AVZODFDD
  AVZODFDN AVZODT9N AVZODTAN AVZODTBN AVZODTCN AVZODTDN AVZOFIST
  AVZOFSQL AVZOHOPA AVZOINAS AVZOINBR AVZOINCM AVZOINSM AVZOINSQ
  AVZOINXM AVZOMAIN AVZOPPA  AVZOPPT  AVZOPST  AVZOSVTP AVZOTBEV
  AVZOTBRU AVZPB    AVZPRIMP AVZSQ29D AVZSQ29N AVZSQ2AD AVZSQ2AN
  AVZSQ2BD AVZSQ2BN AVZSQ2CD AVZSQ2CN AVZSQ2DD AVZSQ2DN AVZSQL9D
  AVZSQL9N AVZSQLAD AVZSQLAN AVZSQLBD AVZSQLBN AVZSQLCD AVZSQLCN
  AVZSQLDD AVZSQLDN
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI78836

     UP22/02/01 P F201  

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.