PH34195: FEBRUARY 2021 SERVER RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• February 2021 Server Release
  -IMS ODBA not honouring explicit Rollbacks
  -SQL function ABS() fails
  -UNION & UNION ALL throwing SYSTEM ABEND X'0C3'
  -Duplicate records returned over connection using MRC
  -Record count of VIEW is not matching to the VT counterpart
  -ABEND X'0C4' on executing DISTINCT on sub table
  -SQL ORDER BY not working
  -SQL JOINs are not working - Getting Time ABEND
  -Error 'error IORC 8, RC 8, Error Code 0, Info Code 0'
   executing SELECT on record 76,30
  -Column NOIDAFF is not selected in virtual table because
   /K/ is in front of it (Server)
  -SQL queries with RIGHT and FULL outer joins on Virtual
   Views gives invalid output, No records are fetching in View 1
  -XOC3 -Abend on logstream running on with out Limit
  -IMS JOINS ON DB2 GIVES ERROR INSTEAD OF RESULTSET
  -SUBSTR(), WHERE CLAUSE ON LEFT JOIN VW, COMPOUND WHERE
   ON A VT FAILING WITH INCORRECT RESULTSET
  -IS NULL/IS NOT NULL gives Incompatible conversion types
   error for String Datatypes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: IMS ODBA not honoring explicit          *
  *                      Rollbacks                               *
  *                                                              *
  *                      ABS() is not working                    *
  *                                                              *
  *                      UNION & UNION ALL throwing SYSTEM       *
  *                      ABEND X'0C3'                            *
  *                                                              *
  *                      Duplicate records returned over         *
  *                      connection using MRC                    *
  *                                                              *
  *                      Record count of VIEW is not matching    *
  *                      to the VT counterpart                   *
  *                                                              *
  *                      ABEND X'0C4' on executing DISTINCT      *
  *                      on sub table                            *
  *                      AMF_M_DG24335_VARIABLE_CHAR             *
  *                                                              *
  *                      SQL ORDER BY not working                *
  *                                                              *
  *                      SQL JOINs are not working - Getting     *
  *                      Time ABEND                              *
  *                                                              *
  *                      Error 'error IORC 8, RC 8, Error        *
  *                      Code 0, Info Code 0' executing SELECT   *
  *                      on record 76, 30                        *
  *                                                              *
  *                      Column NOIDAFF is not selected in       *
  *                      virtual table because /K/ is in front   *
  *                      of it (Server)                          *
  *                                                              *
  *                      SQL queries with RIGHT and FULL outer   *
  *                      joins on Virtual Views gives invalid    *
  *                      output, No records are fetching in      *
  *                      View 1                                  *
  *                                                              *
  *                      XOC3 -Abend on logstream running on     *
  *                      without Limit                           *
  *                                                              *
  *                      IMS JOINS ON DB2 GIVES ERROR INSTEAD    *
  *                      OF RESULTSET                            *
  *                                                              *
  *                      SUBSTR(), WHERE CLAUSE ON LEFT JOIN     *
  *                      VW, COMPOUND WHERE ON A VT FAILING      *
  *                      WITH INCORRECT RESULTSET                *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  IMS ODBA not honoring explicit Rollbacks
  
  ABS() is not working
  
  UNION & UNION ALL throwing SYSTEM ABEND X'0C3'
  
  Duplicate records returned over connection using MRC
  
  Record count of VIEW is not matching to the VT counterpart
  
  ABEND X'0C4' on executing DISTINCT on sub table
  AMF_M_DG24335_VARIABLE_CHAR
  
  SQL ORDER BY not working
  
  SQL JOINs are not working - Getting Time ABEND
  
  Error 'error IORC 8, RC 8, Error Code 0, Info
  Code 0' executing SELECT on record 76, 30
  
  Column NOIDAFF is not selected in virtual table
  because /K/ is in front of it (Server)
  
  SQL queries with RIGHT and FULL outer joins on
  Virtual Views gives invalid output, No records
  are fetching in View 1
  
  XOC3 -Abend on logstream running on
  without Limit
  
  IMS JOINS ON DB2 GIVES ERROR INSTEAD
  OF RESULTSET
  
  SUBSTR(), WHERE CLAUSE ON LEFT JOIN
  VW, COMPOUND WHERE ON A VT FAILING
  WITH INCORRECT RESULTSET
  

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:

  UI74356

Modules/Macros

• AVZ$3D0E AVZ$3D0M AVZ$410E AVZ$410M AVZ$420E AVZ$420M AVZ$4C1E
  AVZ$4C1M AVZ$500E AVZ$500M AVZ$533E AVZ$533M AVZ$JD00 AVZ$K100
  AVZ$K200 AVZ$KC10 AVZ$KC11 AVZ$KC12 AVZ$KC13 AVZCCMAL AVZCDSOP
  AVZCPROC AVZCRDBD AVZCSQOP AVZCSVCL AVZCTGOP AVZCTSOP AVZCTVAL
  AVZDA    AVZFMFRM AVZMADPW AVZMBTPA AVZMDTBL AVZMFPAR AVZMFREF
  AVZMPAEN AVZO#AAC AVZOBRIM AVZOBRMG AVZOBRTV AVZODMWR AVZODRTP
  AVZOGNSM AVZOINAS AVZOINCM AVZOINSQ AVZOIO31 AVZOLI9D AVZOLI9N
  AVZOLIAD AVZOLIAN AVZOLIBD AVZOLIBN AVZOLICD AVZOLICN AVZOLIDD
  AVZOLIDN AVZOMAOT AVZOPPA  AVZOPRUT AVZORXED AVZOSQTS AVZOTBEV
  AVZOWWFI AVZPB    AVZSFPAR AVZSIN00 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 UI74356

     UP21/03/18 P F103

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.