PK62808: QLACMDWT NON-ZERO WHEN MAX DBAT HAS NOT BEEN EXCEEDED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DDFL09 DB2INACTIVE defects pk62808 dpk62808 DCR DJ1061
  Also see APAR PK54350.
  Accounting record IFCID 0003 QLAC field QLACMDWT contains a
  non-zero value when maximum DBATs was *not* exceeded.
  The value is very small.
  The field description in SNDSMACS(DSNDQLAC) does not accurately
  describe the field.
  *****************************************************
  Additional symptoms and keywords:
    DSNDQLAC.QLACMDWT QLACMDWT MAXDBAT SYSPRMT
    IFCID 0003 3 IFCID0003 IFCID3 accounting trace
    DSNTIPR DDF THREADS INACTIVE
    DSN6FAC CMTSTAT INACTIVE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  *                 Specifically where DB2 is configured with    *
  *                 DDF THREADS = INACTIVE specified             *
  *                 (DSN6FAC CMTSTAT INACTIVE).                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect QLACMDWT description.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The QLACMDWT description incorrectly indicates that a value is
  only provided if the DB2 z/OS subsystem was in fact MAXDBAT
  constrained.
  Due to the performance and throughput characteristics of DDF
  Inactive Thread support logic, a non zero value may be provided
  even though the subsystem may not have been MAXDBAT constrained
  in which case the value will reflect a very small delay. This
  delay significantly increases as the subsystem reaches or
  exceeds its configured maximum number of Database Access agents
  (DSNZPARM DSN6SYSP MAXDBAT, SYSPRMT, defined threshold). Minor
  QLACMDWT delays may also be observed if DB2 was below the
  MAXDBAT threshold but DB2 had to dynamically create a DBAT in
  order to service the SQL. QLACMDWT description changes are
  necessary in order to clarify its meaning.
  

Problem conclusion

• DSNDQLAC has been changed to clarify the QLACMDWT description
  as follows:
    QLACMDWT  TOTAL ELAPSED TIME SPENT
              WAITING FOR AN AVAILABLE
              DATABASE ACCESS AGENT.
  

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:

  UK35191 UK35192

Modules/Macros

• DSNDQLAC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK35191

     UP08/04/18 P F804

• R910 PSY UK35192

     UP08/04/18 P F804

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.