PH25419: AVZ MAY 2020 SERVER RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• May 2020 Server Release
  -When MapReduce is ON and WHERE is used, filtering is only done
  on first ACI task
  -SQLCODE 0 returned after SQL Engine get numeric error in
  sdopstpa
  -IDF:IMS:Cobol Batch Program : Insert hung after processing
  only the first insert statement.
  -SMF 99 Column names HARDWAREGROUPCpuTypeCapCp are incomplete
  -SMF99 records - Subtypes are missing information
  -SMF type 99 table has columns that give errors in the
  calculations/conversion to seconds
  -Mapping of SMF Type 99 Subtype 2 array
  SMF99_RT_DISTRI_NUM_TRANS is not mapped correctly
  -MongoDB Port displaying negative values after server start-up
  -Virtual Table IDMS Creation problem when Index has 14 fields
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When MapReduce is ON and WHERE is used, *
  *                      filtering is only done on first ACI     *
  *                      task SQLCODE 0 returned after SQL       *
  *                      Engine                                  *
  *                      get numeric error in sdopstpa           *
  *                      IDF:IMS:Cobol Batch Program :           *
  *                      Insert hung after processing only       *
  *                      the first insert statement.             *
  *                      SMF 99 Column names                     *
  *                      HARDWAREGROUPCpuTypeCapCp are           *
  *                      incomplete                              *
  *                      SMF99 records - Subtypes are            *
  *                      missing information                     *
  *                      SMF type 99 table has columns that      *
  *                      give errors in the                      *
  *                      calculations/conversion to seconds      *
  *                      Mapping of SMF Type 99 Subtype 2 array  *
  *                      SMF99_RT_DISTRI_NUM_TRANS is not mapped *
  *                      correctly                               *
  *                      MongoDB Port displaying negative        *
  *                      values after server start-up            *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  When MapReduce is ON and WHERE is used, filtering is only
  done on first ACI task SQLCODE 0 returned after SQL Engine
  get numeric error in sdopstpa
  IDF:IMS:Cobol Batch Program : Insert hung after processing
  only the first insert statement.
  SMF 99 Column names HARDWAREGROUPCpuTypeCapCp
  are incomplete
  SMF99 records - Subtypes are missing information
  SMF type 99 table has columns that give errors
  in the calculations/conversion to seconds
  Mapping of SMF Type 99 Subtype 2 array
  SMF99_RT_DISTRI_NUM_TRANS is not mapped correctly
  MongoDB Port displaying negative values after
  server start-up
  

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:

  UI70039

Modules/Macros

• AVZ$500E AVZ$500M AVZ$631E AVZ$631M AVZ$632E AVZ$632M AVZ$M310
  AVZ$M311 AVZ$M312 AVZ$M313 AVZ$M314 AVZ$M315 AVZ$M316 AVZ$M317
  AVZ$M318 AVZ$M319 AVZ$M31A AVZ$M31B AVZ$M31C AVZ$M320 AVZ$M321
  AVZ$M322 AVZ$M323 AVZ$M324 AVZ$M325 AVZ$M326 AVZ$M327 AVZ$M328
  AVZ$M329 AVZ$M32A AVZCIMEV AVZCIMFU AVZCTSRD AVZICSFX AVZMDTBL
  AVZOCLUP AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD AVZODFBN
  AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZOFSQL AVZOINTP AVZOPPA
  AVZOTBEV AVZPB    AVZSFPAR 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 UI70039

     UP20/06/16 P F006

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.