PH50729: DB2 FOR Z/OS PROFILE (IFCID 402) STATISTICS ENHANCEMENT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• db2ddf db2spm profilesys
  defect 19578 d19578
  Db2 for z/OS profile (IFCID 402) statistics enhancement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Distributed Data Facility (DDF) users.                   *
  * Specifically those that use profiles to                      *
  * monitor connections/threads for remote                       *
  * TCP/IP access to a Db2 for z/OS server.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Db2 for z/OS system profile                                  *
  * enhancement for IFCID402 profile                             *
  * statistics.                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Db2 for z/OS system profile enhancement for IFCID402 profile
  statistics.
  System profile statistics IFCID402 trace data are collected
  and accumulated from the start of DDF. When a profile threshold
  is changed within a STATIME interval, currently there is no
  deterministic way to identify if the IFCID402 trace data is
  associated with the old or new threshold.
  Furthermore, Db2 AI for z/OS DCC uses the IFCID402 warning and
  exception counters to generate alerts. With the current
  IFCID402 behavior, DCC may incorrectly generate exception
  alerts.
  

Problem conclusion

Temporary fix

Comments

• Db2 for z/OS system profiles has been changed to implement a
  new IFCID402 processing behavior. As part of DSN6FAC
  DDF_COMPATIBILITY subsystem parameter, a new RESET_IFCID402
  option value is added which when specified resets
  IFCID402 warning and exception counters when a new profile is
  enabled, or an existing profile's threshold is changed.
  The following system profile monitoring statistics IFCID402
  fields are affected (reset) when
  DDF_COMPATIBILITY=RESET_IFCID402 is specified:
   - QW0402TE
   - QW0402TQ
   - QW0402TF
   - QW0402TW
   - QW0402CE
   - QW0402CW
   - QW0402OE
   - QW0402OW
  The DSN6FAC DDF_COMATIBILITY subsystem parameter is online
  changeable. This means, if the user wants to enable the new
  behavior you would set the DSN6FAC DDF_COMPATIBILITY
  subsystem parameter to RESET_IFCID402 option value by
  updating your customized copy of job DSNTIJUZ and execute the
  job. After assembling DSNTIJUZ with the new value for DSN6FAC
  DDF_COMPATIBILITY, use the -SET SYSPARM command or stop and
  start Db2 to enable the new IFCID402 reset counters
  behavior.
  IFCID106 DDF system parameter is also changed to indicate the
  new value
  RESET_IFCID402 of DDF_COMPATIBILITY:
  QWP9ITZJ   EQU  X'10'    YES=Ignore TZ in TMZ input for Java
  QWP9SPPMJ  EQU  X'08'    YES=Compat for SP parms - Java
  *          EQU  X'04'    Reserved (Not available).
  *          EQU  X'02'    Reserved (Not available)
  QWP9RST402 EQU  X'01'    YES=Reset IFCID402
            DS    CL2      More DDF Compatibility
  Note for Db2 12 for z/OS users:
   - the current implementation of DSN6FAC DDF_COMATIBILITY
     values controls various behaviors in Db2 12. The null
     (default) value has no effect and Db2 12 new function
     behavior is used for all remote client applications.
     Specifying a non-default value disables the new function
     behavior in Db2 12. However, with RESET_IFCID402 option,
     when specified will *enable* the new behavior (resets a
     subset of the system profile monitoring statistics
     IFCID402 counters to zero) and the absence of
     RESET_IFCID402 value will not reset these IFCID402
     counters (old behavior continues).
  Note for Db2 13 for z/OS users:
   - DSN6FAC DDF_COMPATIBILITY subsystem has been removed from
     Db2 13. Therefore, users migrating from Db2 12 to Db2 13
     need to consider the following:
     - The new RESET_IFCID402 behavior is automatically
       enabled in Db2 13.
     - The DSN6FAC DDF_COMPATIBILITY subsystem parameter
       has been removed in Db2 13 (hidden) but the internal
       assembler definition in DSN6FAC is still available. So,
       if users want to disable the RESET_IFCID402 behavior in
       Db2 13 you would need to contact IBM support for
       assistance on how to set FACDDFC.
     - If the RESET_IFCID402 value was not configured in
       Db2 12, then the new reset behavior for IFCID402
       counters will take effect immediately after a successful
       migration to Db2 13.
     - If the RESET_IFCID402 value was configured in Db2 12,
       then after successfully migrating to Db2 13, the same
       reset behavior for IFCID402 counters will remain in
       effect because this is the new default behavior for
       IFCID402 counters in Db2 13.
  

APAR Information

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

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

  UI83963 UI83964

Modules/Macros

• DSNT1MST DSNT1RSP DSNDQWPZ DSNWZIFC DSNWDFND DSNLSSST DSN6FAC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI83963

     UP23/01/18 P F301

• RD10 PSY UI83964

     UP23/01/18 P F301

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.