PH33646: JANUARY 2021 SERVER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• PH33646
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQL error returns for Subselect query   *
  *                      on DB2 DRDA                             *
  *                                                              *
  *                      Issue 3: UNION operation on virtual     *
  *                      views gives incorrect data on numeric   *
  *                      column. There is no value with 1        *
  *                      or 3 on column population.              *
  *                                                              *
  *                      Issue 2: Unable to fetch dataset on     *
  *                      the below query on VTs.                 *
  *                                                              *
  *                      Issue 1: Union functions give a         *
  *                      duplicate row in between result         *
  *                      set on VTs.                             *
  *                                                              *
  *                      Overflow during numeric conversion      *
  *                      error on Joining ORACLE and Adabas      *
  *                      virtual table.                          *
  *                                                              *
  *                      Studio error on CREATE and SELECT       *
  *                      on VSAM/IAM table gives the error       *
  *                      "Error executing statement.             *
  *                      length == 65536 off == 206576           *
  *                      buffer length == 262144.                *
  *                                                              *
  *                      Remote users display should remove      *
  *                      the total CPU time. This is             *
  *                      displaying an incorrect value.          *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  SQL error returns for Subselect query
  on DB2 DRDA
  
  Issue 3: UNION operation on virtual
  views gives incorrect data on numeric
  column. There is no value with 1
  or 3 on column population.
  
  Issue 2: Unable to fetch dataset on
  the below query on VTs.
  
  Issue 1: Union functions give a
  duplicate row in between result
  set on VTs.
  
  Overflow during numeric conversion
  error on Joining ORACLE and Adabas
  virtual table.
  
  Studio error on CREATE and SELECT
  on VSAM/IAM table gives the error
  "Error executing statement.
  length == 65536 off == 206576
  buffer length == 262144.
  
  Remote users display should remove
  the total CPU time. This is
  displaying an incorrect value.
  

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:

  UI73777

Modules/Macros

• AVZ$500E AVZ$500M AVZ$533E AVZ$533M AVZCRDBD AVZCSVCL AVZDA
  AVZFMFRM AVZMADPW AVZMBTPA AVZMDTBL AVZMFPAR AVZMPAEN AVZOBRIM
  AVZODRTP AVZOINAS AVZOINCM AVZOLI9D AVZOLI9N AVZOLIAD AVZOLIAN
  AVZOLIBD AVZOLIBN AVZOLICD AVZOLICN AVZOLIDD AVZOLIDN AVZOPPA
  AVZORXED 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 UI73777

     UP21/02/05 P F102

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.