PH22143: FEBRUARY 2020 RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• February 2020 Release
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The SQL IS NULL does NOT work when used *
  *                      in compound WHERE predicate.            *
  *                                                              *
  *                      SMF70 Sub Type 2 - changes to field     *
  *                      SMF70LGO to have valid offset GMT to    *
  *                      local time                              *
  *                                                              *
  *                      SMF70 Sub Type 1 - changes to field     *
  *                      SMF70LGO to have valid offset GMT to    *
  *                      local time                              *
  *                                                              *
  *                      Length on the Stored procedure appears  *
  *                      to be truncated                         *
  *                                                              *
  *                      SELECT DISTINCT on a DB2 Virtual table  *
  *                      that has RUNSTATS gives incorrect       *
  *                      results                                 *
  *                                                              *
  *                      SELECT statement on SMF data with Time  *
  *                      filtering using BETWEEN with ORDER BY   *
  *                      and JOIN ON gives error                 *
  *                                                              *
  *                      Duplicate ROW_INDEX cols from certain   *
  *                      DVM (sub-) tables                       *
  *                                                              *
  *                      SELECT RUNSTATS on large table gets     *
  *                      s0C3 abend                              *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  The SQL IS NULL does NOT work when used in compound WHERE
  predicate.
  
  SMF70 Sub Type 2 - changes to field SMF70LGO to have valid
  offset GMT to local time
  
  SMF70 Sub Type 1 - changes to field SMF70LGO to have valid
  offset GMT to local time
  
  Length on the Stored procedure appears to be truncated
  
  SELECT DISTINCT on a DB2 Virtual table that has RUNSTATS gives
  incorrect results
  
  SELECT statement on SMF data with Time filtering using BETWEEN
  with ORDER BY and JOIN ON gives error
  
  Duplicate ROW_INDEX cols from certain DVM (sub-) tables
  
  SELECT RUNSTATS on large table gets s0C3 abend
  

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:

  UI68240

Modules/Macros

• AVZ$461E AVZ$461M AVZ$462E AVZ$462M AVZ$IA40 AVZ$IA42 AVZ$IAL1
  AVZ$IAO1 AVZ$K610 AVZ$K611 AVZ$K612 AVZ$K613 AVZ$K614 AVZ$K615
  AVZ$K616 AVZ$K617 AVZ$K620 AVZ$K621 AVZ$K622 AVZ$K623 AVZ$K624
  AVZ$KE32 AVZ$KE33 AVZ$KFE1 AVZ$ME20 AVZ$MEP0 AVZ$N830 AVZ$N850
  AVZ$N860 AVZ$N870 AVZ$N880 AVZCCAPR AVZCDSPS AVZCDSTZ AVZCMQIO
  AVZCSPTB AVZCSQMM AVZMFMIG AVZOIO31 AVZOPPA  AVZOPRUT AVZPB
  AVZSQ29D AVZSQ29N AVZSQ2AD AVZSQ2AN AVZSQ2BD AVZSQ2BN AVZSQ2CD
  AVZSQ2CN AVZSQ2DD AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLAD AVZSQLAN
  AVZSQLBD AVZSQLBN AVZSQLCD AVZSQLCN AVZSQLDD AVZSQLDN AVZWSIMP
  

Fix information

• Fixed component name

  DATA VIRT MGR Z

• Fixed component ID

  5698DVM00

Applicable component levels

• R110 PSY UI68240

     UP20/03/10 P F003

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.