PH25623: JULY 2020 MAINTENANCE UPDATES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• July 2020 Maintenance Updates
  
  PH24996
  * PROBLEM DESCRIPTION: The value in column FIELD_DUAL_ACTUAL   *
  *                      of the table DB2PM_EXCEPTIONS is        *
  *                      always BP0 regardless what field it is. *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  Workarea does not cleaned up, so old value is kept for all
  fields which have no qualification values.
  
  PROBLEM CONCLUSION:
  Workarea was cleaned up to prevent put previous values
  in actual record.
  
  PH24967
  * PROBLEM DESCRIPTION: 1.Long table name in explain is parsed  *
  *                      Incorrectly.                            *
  *                      2.Support unqualified table in SQLPA    *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  1. Statement with table name wraping over two rows returns
  syntax error in explain.
  2. SQLPA returns -204 when unqualified table is used in query.
  
  PROBLEM CONCLUSION:
  1.Correct long table name parser error.
  2.Support unqualified table name in SQLPA by setting
  BATSQLID=YES in RKD2PAR(OMPEOPTS).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: PDB                                          *
  *                 PE Server Subtask                            *
  *                 PWH                                          *
  *                 Explain                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: July 2020 Maintenance Update.           *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  July 2020 Maintenance Update
  

Problem conclusion

• July 2020 Maintenance Update
  

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:

  UI70644

Modules/Macros

• DGOFEDPM DGOVMSTR DGOZBEXP DGOZPC2  DGOZSQPA KD5AGENT KDPATR
  KDPBAR   KDPCAT   KDPDOC   KDPDSEXP KDPDSQLS KDPHDSQL KDPJSTMS
  KDPJSTPS KDPJSTPW KDPMAP   KDPMSMAN KDPPLEX  KDPVRTMS KO25DSQL
  KO2APC72 KO2APC7K KO2APC7S KO2OSQPB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI70644

     UP20/07/22 P F007

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.