PH26692: AVZ JUNE 2020 SERVER RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• -There is a problem with SQL Engine parsing IMS Direct DBD
  -UNION/UNION-ALL WITH JGATE/VSAM/DB2 as SUB-SET TABLE GIVES
   SQLCODE = -17042
  -SEQ/VSAM: UNION/UNION ALL with JGATE staff VT as SUBSET
   table gives X'0C7' abend or NO ROWS returned
  -IMS UNION/UNION-ALL query in sub-set gives incorrect result
   with wrong data output
  -Iterative DML failes after a successful Rollback
  -IDF: Numeric field WHERE clause on a UNION/UNION ALL VIRTUAL
   VIEW on JGATE/ORACLE,IMS,VSAM table gives DNSALI error
  -Missing VAR fields from SMF_10101 and SMF_10101_QPAC
  -New IDAA Loader VT needed for CDC SMF records
  -Support for SMF 102 IFCID 0199
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: There is a problem with SQL Engine      *
  *                      parsing IMS Direct DBD                  *
  *                                                              *
  *                      UNION/UNION-ALL WITH JGATE/VSAM/DB2     *
  *                      as SUB-SET TABLE GIVES                  *
  *                      SQLCODE = -17042                        *
  *                                                              *
  *                      SEQ/VSAM: UNION/UNION ALL with          *
  *                      JGATE staff VT as SUBSET table gives    *
  *                      X'0C7' abend or NO ROWS returned        *
  *                                                              *
  *                      IMS UNION/UNION-ALL query in sub-set    *
  *                      gives incorrect result with             *
  *                      wrong data output                       *
  *                                                              *
  *                      Iterative DML failes after a            *
  *                      successful Rollback                     *
  *                                                              *
  *                      IDF: Numeric field WHERE clause on a    *
  *                      UNION/UNION ALL VIRTUAL VIEW on         *
  *                      JGATE/ORACLE,IMS,VSAM table gives       *
  *                      DNSALI error                            *
  *                                                              *
  *                      Missing VAR fields from SMF_10101       *
  *                      and SMF_10101_QPAC                      *
  *                                                              *
  *                      New IDAA Loader VT needed for CDC       *
  *                      SMF records                             *
  *                                                              *
  *                      Support for SMF 102 IFCID 0199          *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  There is a problem with SQL Engine parsing IMS Direct DBD
  
  UNION/UNION-ALL WITH JGATE/VSAM/DB2 as SUB-SET TABLE GIVES
  SQLCODE = -17042
  
  SEQ/VSAM: UNION/UNION ALL with JGATE staff VT as SUBSET table
  gives X'0C7' abend or NO ROWS returned
  
  IMS UNION/UNION-ALL query in sub-set gives incorrect result
  with wrong data output
  
  Iterative DML failes after a successful Rollback
  
  IDF: Numeric field WHERE clause on a UNION/UNION ALL VIRTUAL
  VIEW on JGATE/ORACLE,IMS,VSAM table gives DNSALI error
  
  Missing VAR fields from SMF_10101 and SMF_10101_QPAC
  
  New IDAA Loader VT needed for CDC SMF records
  
  Support for SMF 102 IFCID 0199
  

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:

  UI70339

Modules/Macros

• AVZ$651E AVZ$651M AVZ$E3CE AVZ$E3CM AVZ$E3LE AVZ$E3LM AVZ$E3SE
  AVZ$E3SM AVZ$E3TE AVZ$E3TM AVZ$M510 AVZ$M511 AVZ$M512 AVZ$M513
  AVZ$M514 AVZ$M515 AVZ$U3C0 AVZ$U3L0 AVZ$U3S0 AVZ$U3T0 AVZ$W54E
  AVZ$W54M AVZ$X540 AVZ$X541 AVZ$X542 AVZASIGN AVZASURR AVZCADUP
  AVZOBRTP AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD AVZODFBN
  AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZODMWR AVZOLINK 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 UI70339

     UP20/07/03 P F007

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.