PM34587: NEW LAYOUT FOR DSN_STATEMNT_TABLE REPORT BLOCK IN COMPONENT BATCH-EXPLAIN

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• The DSN_STATEMNT_TABLE report block in Batch-Explain has
  a new block layout. The block starts with EXPLAIN TABLE
  and has 2 block columns. The report field labels are the
  full DSN_STATEMNT_TABLE column names. If the report field
  value is a long name or a long value, it is marked with
  an asterisk (*) at the end of the report field value,
  and reported at the end of the block in its full length.
  All 15 columns for DB2 V10 are supported.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Explain                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DSN_STATEMNT_TABLE report block in  *
  *                      Batch-Explain has a new block layout.   *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  The DSN_STATEMNT_TABLE report block in Batch-Explain has
  a new block layout. The block starts with EXPLAIN TABLE
  and has 2 block columns. The report field labels are the
  full DSN_STATEMNT_TABLE column names. If the report field
  value is a long name or a long value, it is marked with
  an asterisk (*) at the end of the report field value,
  and reported at the end of the block in its full length.
  All 15 columns for DB2 V10 are supported.
  
  KEYWORDS:
  BATCH-EXPLAIN REPORT-BLOCK DSN_STATEMNT_TABLE
  

Problem conclusion

Temporary fix

Comments

• PROBLEM SUMMARY:
  The DSN_STATEMNT_TABLE report block in Batch-Explain has
  a new block layout. The block starts with EXPLAIN TABLE
  and has 2 block columns. The report field labels are the
  full DSN_STATEMNT_TABLE column names. If the report field
  value is a long name or a long value, it is marked with
  an asterisk (*) at the end of the report field value,
  and reported at the end of the block in its full length.
  All 15 columns for DB2 V10 are supported.
  

APAR Information

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

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

  UK65823

Modules/Macros

•    DGO@TNM3 DGOYBLOK DGOYMAIN DGOYPATH DGOYRNM0
  DGOYRNM1 DGOYRPT1 DGOYSEEE DGOYSTAB DGOYTNM0 DGOYTNM3 HKDB510J
  KDB510J
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK65823

     UP11/03/17 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.