PH18658: NEW FUNCTION FOR DB2 STATISTICS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function for Db2 Statistics
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Db2 v12 for z/OS users of Statistic traces                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Most statistic traces are written                            *
  * every minute and the interval can't be                       *
  * controlled by the customer.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  There is a need for a more frequent statistic interval
  controlled by the customer.
  

Problem conclusion

Temporary fix

Comments

• Addition of a new Db2 subsystem parameter, STATIME_MAIN, that
  specifies the interval from 5 to 60 seconds in 5 second
  increments for writing statistics records. The default is the
   maximum value of 60 seconds which lines up with the current
  one minute implementation.
  See the ++HOLD ACTION text for information on how to set
  STATIME_MAIN to a different value.
  

APAR Information

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

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

  UI69059

Modules/Macros

• DSNTINMF DSNDQWPZ DSNWZIFC DSNTIDXA DSNTIVMD DSNTIJUZ DSNTINST
  DSNTIDXC DSNTIWIA DSNTIDXB DSNTIVIA DSNTIWMD DSNTIWIE DSNTIVIE
  DSN6SYSP DSNWVZXT DSN@XAZP DSNTXAZP DSNTIWPC DSNTIPN  DSNTIVMN
  DSNTIWMN DSNTIVAF DSNTIVIN DSNTIWMS DSNTIVMS DSNTIWAF DSNTIWIN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI69059

     UP20/04/21 P F004

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.