PH39943: SEPTEMBER 2021 RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• September 2021 Release
  - UNION/UNION ALL ISSUE WITH NULL WHEN DB2 VT IS IN QUERY
  - Support for handling DB2 32k varchar view - Server
  - Sync Issue Between ASM and MetalC in AVZ
  - Load 4 rows instead 1 row
  - Count is returning incorrect values on Logstream VT
    when MapReduce is Enabled on VT
  - LOGSTREAM reading using map/reduce drops all but
    last record in final logstream buffer
  - Memory Objects not freed up after UNION/UNION ALL
    query execution
  - Full outer join with parent and sub table giving incorrect
    results
  - Copy Book for DVM virtual table definition of Db2 table
  - Server return error message - SQL error code -104 during
    Prepare processing
  - DMF/metadata catalog issues
  - RIGHT () on Varchar is not working and getting ABEND
  - Insert CURRENT_DATE, CURRENT_TIMESTAMP into DB2 VT fails
  - NullPointerException when creating virtual view
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: UNION/UNION ALL ISSUE WITH NULL WHEN    *
  *                      DB2 VT IS IN QUERY                      *
  *                      Support for handling DB2 32k varchar    *
  *                      view - Server                           *
  *                      Sync Issue Between ASM and MetalC       *
  *                      in AVZ                                  *
  *                      Load 4 rows instead 1 row               *
  *                      Count is returning incorrect values on  *
  *                      Logstream VT when MapReduce is Enabled  *
  *                      on VT                                   *
  *                      LOGSTREAM reading using map/reduce      *
  *                      drops all but last record in final      *
  *                      logstream buffer                        *
  *                      Memory Objects not freed up after       *
  *                      UNION/UNION ALL query executions        *
  *                      Full outer join with parent and sub     *
  *                      table giving incorrect results          *
  *                      Copy Book for DVM virtual table         *
  *                      definition of Db2 table                 *
  *                      Data Virtualization Manager return      *
  *                      error message - SQL error code -104     *
  *                      during Prepare processing, DB2 ssid     *
  *                      DB1B error text = DSNT408I SQLCODE      *
  *                      = -104, ERROR: ILLEGAL SYMBOL ".51"     *
  *                      DMF/metadata catalog issues             *
  *                      RIGHT () on Varchar is not working and  *
  *                      getting abend                           *
  *                      Insert CURRENT_DATE, CURRENT_TIMESTAMP  *
  *                      into DB2 VT fails                       *
  *                      NullPointerException when creating      *
  *                      virtual view                            *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  UNION/UNION ALL ISSUE WITH NULL WHEN DB2 VT IS IN QUERY
  Support for handling DB2 32k varchar view - Server
  Sync Issue Between ASM and MetalC in AVZ
  Load 4 rows instead 1 row
  Count is returning incorrect values on Logstream VT when
  MapReduce is Enabled on VT
  LOGSTREAM reading using map/reduce drops all but last
  record in final logstream buffer
  Memory Objects not freed up after UNION/UNION ALL
  query executions
  Full outer join with parent and sub table giving
  incorrect results
  Copy Book for DVM virtual table definition of Db2
  table
  Data Virtualization Manager return error message -
  SQL error code -104 during Prepare processing,
  DB2 ssid DB1B error text = DSNT408I SQLCODE =
  -104, ERROR: ILLEGAL SYMBOL ".51"
  DMF/metadata catalog issues
  RIGHT () on Varchar is not working and getting abend
  Insert CURRENT_DATE, CURRENT_TIMESTAMP into DB2 VT fails
  NullPointerException when creating virtual view
  

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:

  UI77462

Modules/Macros

• AVZCD2CL AVZCDSHM AVZCMTCL AVZCOPDM AVZCPRCL AVZCSQLM AVZCSQOP
  AVZCSVCL AVZCVPGT AVZCVPPT AVZOBRSR AVZODF9D AVZODF9N AVZODFAD
  AVZODFAN AVZODFBD AVZODFBN AVZODFCD AVZODFCN AVZODFDD AVZODFDN
  AVZODMMG AVZOINSQ AVZOIO31 AVZOLI9D AVZOLI9N AVZOLIAD AVZOLIAN
  AVZOLIBD AVZOLIBN AVZOLICD AVZOLICN AVZOLIDD AVZOLIDN AVZOPFU
  AVZOPMS  AVZOPPA  AVZOSCFU AVZOSVTP AVZOTBEV AVZPB    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 UI77462

     UP21/10/26 P F110

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.