PH05316: SQL ENGINE NOT PASSING WHERE PREDICATES DOWN INTO VIEW OF AN IMSJOIN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When executing SQL on Virtual Views that contain virtual IMS tab
  and applying WHERE predicates to the view, a table scan results
  when a qualified key is being used in the WHERE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQL engine not passing where predicates *
  *                      down into view of an IMS join           *
  ****************************************************************
  

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

• AVZ10001 AVZCCMTC AVZCCPNA AVZCEVIF AVZCEVTY AVZCFAPI AVZCFUNC
  AVZCGBLV AVZCGVVL AVZCMTCL AVZCOPBO AVZCPTVL AVZCRQIF AVZCS1HD
  AVZCTPIF AVZCVDEV AVZO319D AVZO319N AVZO31AD AVZO31AN AVZO31BD
  AVZO31BN AVZO31CD AVZO31CN AVZO649D AVZO649N AVZO64AD AVZO64AN
  AVZO64BD AVZO64BN AVZO64CD AVZO64CN AVZOACDA AVZOALUE AVZOAUCK
  AVZOAUMG AVZOBOFU AVZOBOSU AVZOCMRU AVZOCOSD AVZOCOSH AVZODARU
  AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD AVZODFBN AVZODFCD
  AVZODFCN AVZODRTP AVZOFSQL AVZOHOPA AVZOHTRU AVZOINAS AVZOIO31
  AVZOLINK AVZOMAOT AVZOPCSX AVZOPMS  AVZOPPA  AVZOPPT  AVZOPST
  AVZOPVT  AVZOSDRU AVZOSVTP AVZOTBRU AVZOTPIN AVZOVDMG AVZPB
  AVZSIN00 AVZSQ29D AVZSQ29N AVZSQ2AD AVZSQ2AN AVZSQ2BD AVZSQ2BN
  AVZSQ2CD AVZSQ2CN AVZSQL9D AVZSQL9N AVZSQLAD AVZSQLAN AVZSQLBD
  AVZSQLBN AVZSQLCD AVZSQLCN
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI60199

     UP18/12/13 P F812

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.