PH12041: SYSTEM PROFILE MONITORING PROFILE SEARCH IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• db2ddf db2spm profilesys
  Performance improvements related to system profile monitoring
  profile searching.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Distributed Data Facility (DDF) users,                   *
  * specifically those with profiles to monitor                  *
  * threads and connections for remote TCP/IP                    *
  * access to a Db2 for z/OS server.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Db2 System Profile Monitoring                                *
  * improvements:                                                *
  *  * IFI READS capability for                                  *
  *    IFCID 402 class 4 statistics                              *
  *    records                                                   *
  *  * Add new statistical counters                              *
  *    for monitoring threads and                                *
  *    connections, including high                               *
  *    water marks for the IFCID 402                             *
  *    class 4 statistics record                                 *
  *  * Add the ability to set the queue                          *
  *    depth for MONITOR THREADS profiles                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  A Db2 for z/OS server can utilize profiles to monitor
  connections and threads that access Db2 using TCP/IP network
  connections.  The MONITOR THREADS and MONITOR CONNECTIONS
  profiles can specify an ATTRIBUTE2 value in order to govern how
  many threads and connections to monitor.  However, it is often
  difficult for system administrators to determine an initial
  setting for this value.  Db2 keeps statistical counters in the
  DRDA statistics records but it does not provide the same kind
  of information at a System Profile level.
  Also, in many cases system administrators don't want threads
  (work) to be queued but instead want them to be immediately
  rejected in order to allow the work to be executed on another
  server. Therefore, controlling the number of thread requests to
  be queued is an important function which Db2 currently does not
  support.
  

Problem conclusion

• Db2 for z/OS server processing is being enhanced to provide the
  following improvements.
   * New IFCID 402 fields are added to the DSNDQW05 macro:
     - QW0402TC - current active thread counter
     - QW0402TS - current suspended thread counter
     - QW0402TH - high water thread counter since DDF started
     - QW0402CC - current connections counter
     - QW0402CH - high water connections counter since DDF
                  started
   * A monitor program, using the IFI READS function, can now
     request synchronous data from IFCID 402 trace records.
   * When the number of requests exceeds the number of threads
     allowed by the DSN_PROFILE_ATTRIBUTES ATTRIBUTE2 column
     value, the DSN_PROFILE_ATTRIBUTES ATTRIBUTE3 column can now
     be used to specify the number of requests that can be queued
     waiting for a thread to complete. The ATTRIBUTE3 value must
     be a whole number that is either zero or less than or equal
     to the value of ATTRIBUTE2.  When a zero value is specified
     for ATTRIBUTE3, requests are not queued but instead the
     connection is terminated with a -30041 SQLCODE.
  

Temporary fix

Comments

• ×**** PE20/04/01 FIX IN ERROR. SEE APAR PH12041  FOR DESCRIPTION
  ×**** PE20/04/02 FIX IN ERROR. SEE APAR PH24008  FOR DESCRIPTION
  ×**** PE21/03/04 PTF IN ERROR. SEE APAR PH30080  FOR DESCRIPTION
  ×**** PE21/03/24 FIX IN ERROR. SEE APAR PH35691  FOR DESCRIPTION
  

APAR Information

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

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

  UI67630

Modules/Macros

• DSNXVSUM DSNDQW05 DSNLAGNT DSNWVZCK DSNLQDIS DSNLSSST DSNXVCFD
  DSNLTEXC DSNTSTRT DSNLTACT DSNXVTBL DSNWARDS DSNWVINT DSNLCTRC
  DSNLILNR DSNLIRTR DSNT1MST DSNT1RSP DSNLEDDA DSNLQINA DSNLJTIN
  DSNLTACC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI67630

     UP20/02/11 P F002

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.