PH31663: DATA VIRTUALIZATION MANAGER SERVER NOVEMBER 2020 RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• PH31663
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Left Outer Join is not fetching the     *
  *                      correct results from the Right table.   *
  *                      Capture Copybook member name in DVM     *
  *                      metadata for use with WKC/ICP4D         *
  *                      SQL Union queries with sub-table joins  *
  *                      not working with SMF Virtual Views      *
  *                      Sporadic S0C4 Abend when running query  *
  *                      against SMF Maps                        *
  *                      Need REFRESH MAP job for AVZ            *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  Left Outer Join is not fetching the correct results from the
  Right table.
  Capture Copybook member name in DVM metadata for use with
  WKC/ICP4D
  SQL Union queries with sub-table joins not working with SMF
  Virtual Views
  Sporadic S0C4 Abend when running query against SMF Maps
  Need REFRESH MAP job for AVZ
  

Problem conclusion

Temporary fix

Comments

• ×**** PE21/03/02 FIX IN ERROR. SEE APAR PH34962  FOR DESCRIPTION
  

APAR Information

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

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

  UI73177

Modules/Macros

• AVZ$3D0E AVZ$3D0M AVZ$410E AVZ$410M AVZ$420E AVZ$420M AVZ$JD00
  AVZ$K100 AVZ$K200 AVZCRDBD AVZCSQOP AVZCSVCL AVZMDTBL AVZMFREF
  AVZO#AAC AVZOBRMG AVZODMWR AVZOINAS AVZOIO31 AVZOLI9D AVZOLI9N
  AVZOLIAD AVZOLIAN AVZOLIBD AVZOLIBN AVZOLICD AVZOLICN AVZOLIDD
  AVZOLIDN AVZOMAOT AVZOTBEV AVZOWWFI AVZSFPAR AVZSIN00 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 UI73177

     UP20/12/18 P F012

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.