PH52947: QUERYING VIRTUAL VIEW ON COBOL LINKED TABLE GETS ROW ADDRESS ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When querying a virtual view containing a WHERE clause on a
  virtual table linked to a DB2 table, the query fails with the
  following in the server trace:
  Error accessing result set data for column column-name, table
  table-name due to row address not available
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: PH52947                                 *
  *                      Querying virtual view on COBOL linked   *
  *                      table gets row address error            *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  PH52947
  Querying virtual view on COBOL linked table gets row address
  error
  

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

• AVZCCAPS AVZCCUBU AVZCPRHL AVZCSWEV AVZO319D AVZO319N AVZO31AD
  AVZO31AN AVZO31BD AVZO31BN AVZO31CD AVZO31CN AVZO31DD AVZO31DN
  AVZO649D AVZO649N AVZO64AD AVZO64AN AVZO64BD AVZO64BN AVZO64CD
  AVZO64CN AVZO64DD AVZO64DN AVZOBRSQ AVZOBRSR AVZOCKLM AVZSFPAR
  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 UI91163

     UP23/03/30 P F303

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.