PH08077: QUERY OF IMS VIRTUAL TABLE WITH SECONDARY INDEX FAILS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When querying a virtual table qualifying on columns that
  participate in an IMS secondary index, the query fails
  with an AK status code.
  After tracing the SSA, we discovered the product generated
  a qualified SSA using a field name from a child segment
  instead of the field name from the XDFLD statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Query of IMS Virtual Table with         *
  *                      secondary index fails                   *
  ****************************************************************
  .
  

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$060E AVZ$060M AVZ$G600 AVZCSCHE AVZDFDIV AVZOCMRU AVZODMMG
  AVZOHOPA AVZOIMSR AVZOIO31 AVZOPPA  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 UI62237

     UP19/04/02 P F904

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.