PM46758: THE ICAT HELP FOR NEGATIVE SQL DESCRIBES THE DEFAULT INCORRECTLY AS Y. IN FACT THE DEFAULT IS N.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The ICAT Help for Negative SQL describes the default incorrectly
  as Y. In fact the default is N.
  
  Additional note: In order to run negative SQL reports from the
  sequential files, this option must be set to Y.
  
  Help panel should be updated with the following
  Negative SQL
   If Y is entered, the collector activates IFCIDs
   58,59,60,61,62,64,65 and 66 to the DB2 START TRACE PERFORMANCE
   command. These IFCIDS record start and stop of an SQL event.
  
   The data can only be externalized by running a batch report
   against the sequential file that can be created by
   Near Term History.
  
  
   The default is N.
  
   NOTICE: The above PERFORMANCE TRACEs will cause increased
   overhead in DB2, especially DB2 BATCH work executing many FETCH
   requests.  Each FETCH will be traced.  CPU times will increase.
   Overhead in OMEGAMON collector will also increase due to the
   volume of trace data generated.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   ICAT                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The ICAT help states that the default   *
  *                      for Negative SQL for NTH is Y. This is  *
  *                      incorrect. The default is N.            *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  The default in the help panel was incorrect.
  
  PROBLEM CONCLUSION:
  The default in the help panel was changed to N.
  

Problem conclusion

• The default in the help panel was changed to N.
  
  KEYWORDS : NTH Negative SQL NEGSQL
  

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:

  UK72795 UK72796

Modules/Macros

• KD2BHELP KD2DDICT KD261H9  KD261H9A KD261H9B
  KD261H9C
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R420 PSY UK72795

     UP11/10/14 P F110

• R510 PSY UK72796

     UP11/10/14 P F110

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.