PH64530: INCONSISTENT BEHAVIOR ACROSS DVM AND MSSQL WHEN USING WITH UR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DVM with MSSQL behaves incorrectly when WITH UR keyword is used
  in combination with ORDER BY, GROUP BY EXISTS etc.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH64530                                 *
  *                      Inconsistent behavior across DVM and    *
  *                      MSSQL when using WITH UR.               *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH64530
  Inconsistent behavior across DVM and
  MSSQL when using WITH UR.
  

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

• AVZCUSPW AVZOBRSQ AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD
  AVZODFBN AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZOMABR AVZOVSED
  AVZSQ29D AVZSQ29N AVZSQ2BN AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N
  AVZSQLBN AVZSQLCN AVZSQLDN
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UO02095

     UP25/02/19 P F502

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.