PH35648: MARCH 2021 SERVER RELEASE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• March 2021 Server Release
  -IMS table AFDB01_GCLSEG2 not showing PARENT_SEQ column
  -DVM - SQL used in a view with SQL LEFT OUTER JOIN gives abends
  -VIEW duplicate field using GROUP_CONCAT causing join of 2 views
   to 0c3
  -IDF is checking bound package consistency tokens incorrectly
  -DVM Batch program AVZXMAPD - Need a ++SET where we don't write
   out the 2 bytes length on a VARCHAR
  -IDF - Delete SQL failing - Invalid statement pointer if
   keyword FROM missing
  -Missing fields in SMF99 Subtype 14
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: IMS table AFDB01_GCLSEG2 not showing    *
  *                      PARENT_SEQ column                       *
  *                                                              *
  *                      DVM - SQL used in a view with SQL LEFT  *
  *                      OUTER JOIN gives abends                 *
  *                                                              *
  *                      VIEW duplicate field using              *
  *                      GROUP_CONCAT                            *
  *                      causing join of 2 views to 0c3          *
  *                                                              *
  *                      IDF is checking bound package           *
  *                      consistency tokens incorrectly          *
  *                                                              *
  *                      DVM Batch program AVZXMAPD - Need a     *
  *                      ++SET where we don't write out the      *
  *                      2 bytes length on a VARCHAR             *
  *                                                              *
  *                      IDF - Delete SQL failing - Invalid      *
  *                      statement pointer if keyword FROM       *
  *                      missing                                 *
  *                                                              *
  *                      Missing fields in SMF99 Subtype 14      *
  ****************************************************************
  * RECOMMENDATION: Apply PTF                                    *
  ****************************************************************
  IMS table AFDB01_GCLSEG2 not showing PARENT_SEQ column
  
  DVM - SQL used in a view with SQL LEFT OUTER JOIN gives abends
  
  VIEW duplicate field using GROUP_CONCAT causing join of 2 views
  to 0c3
  
  IDF is checking bound package consistency tokens incorrectly
  
  DVM Batch program AVZXMAPD - Need a ++SET where we don't write
  out the 2 bytes length on a VARCHAR
  
  IDF - Delete SQL failing - Invalid statement pointer if keyword
  FROM missing
  
  Missing fields in SMF99 Subtype 14
  

Problem conclusion

Temporary fix

Comments

• ×**** PE21/04/15 FIX IN ERROR. SEE APAR PH36350  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• AVZ$63EE AVZ$63EM AVZ$M3E0 AVZ$M3E1 AVZ$M3E2 AVZ$M3E3 AVZ$M3E4
  AVZ$M3E5 AVZCCLMR AVZCCLRW AVZCCUCB AVZCPIOU AVZCPRSE AVZMDTBL
  AVZOAPDR AVZODARU AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD
  AVZODFBN AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZOLI9D AVZOLI9N
  AVZOLIAD AVZOLIAN AVZOLIBD AVZOLIBN AVZOLICD AVZOLICN AVZOLIDD
  AVZOLIDN AVZOPMS  AVZOPPA  AVZOPST  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 UI74726

     UP21/04/07 P F104

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.