PH33985: OMEGAMON DB2 SQLACTIVITY TRACE SHOW NON DISPLAYABLE DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Omegamon DB2 SQLACTIVITY Trace show non displayable data
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM                *
  *                 users of components:                         *
  *                 - Enhanced 3270 User Interface               *
  *                 - Classic Interface                          *
  *                 - Object Analysis                            *
  *                 - Batch SQLACTIVITY TRACE                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: April 2021 Maintenance Update.          *
  *                                                              *
  *                      Abend0C4-11 when starting thread        *
  *                      history from E3270UI.                   *
  *                                                              *
  *                      SQLACTIVITY Trace show non displayable  *
  *                      data in host variables values.          *
  *                                                              *
  *                      Curr Wait TCB Time  garbage symbols     *
  *                      on ZTDTL screen when Acctg(1) only      *
  *                      is active                               *
  *                                                              *
  *                      ABEND S378-14 IN KO2CMVSF               *
  *                      OFFSET 000C30                           *
  *                                                              *
  *                      No extent information displayed from    *
  *                      Object Analysis in classic interface    *
  *                      and TEP for Db2 version 11 systems.     *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  April 2021 Maintenance Update.
  
  Implement code fixes to resolve abend0C4-11.
  
  SQLACTIVITY Trace did not process correctly
  unprintable symbols in Host Variables.
  
  Curr Wait TCB Time field is incorrect
  on ZTDTL screen if Acctg(1) only is active
  
  Abend during executing IWMDEXTR WLM  macro
  
  Error collecting Db2 V11 extent information.
  

Problem conclusion

• April 2021 Maintenance Update.
  
  Implement code fixes for E3270UI Thread History to resolve
  abend0C4-11.
  
  Implement code fixes to see host variables values as Hex string
  when not printable symbols have been detected.
  
  Changed the code to display "N/A" for Curr Wait TCB Time
  on ZTDTL screen if Acctg(1) only is active
  
  Prevent abend and display the message KO2O1940E
  if the WLM service is not running.
  
  Corrected error in Object Analysis extent data collection for
  Db2 V11 subsystems.
  
  Keywords:
  KO2CDBCB O2CNAG BATCH SQLACTIVITY ACCOUNTING
  S378-14 0C4 KO2CMVSF WLM ZOJAS ZOJA1 ZOJA2
  ZTDTL CURR WAIT TCB TIME
  

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:

  UI75129

Modules/Macros

• DGOAFGEN DGOAFORM DGORPHVA DGORRHVA KDPJSTMS KDPJSTPS KDPJSTPW
  KDPMSMAN KDPVRTMS KO2ABROW KO2CMVSF KO2CNAGB KO2ED012 KO2ED01K
  KO2ED01S KO2OTHAB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI75129

     UP21/04/30 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.