PK58086: STATISTICS BATCH REPORT WITH INTERVAL OPTION IN THE GLOBAL REPORT RESULTS FOR DECLARE GLOBAL TEMP TABLE FIELDARE INCORRECT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running a statistics batch report with the following:
  GLOBAL
    INTERVAL(30)
  STATISTICS
    REPORT
     LAYOUT(LONG)
     DDNAME(STRPT1)
    REPORT
     LAYOUT(LONG)
     ORDER(INTERVAL)
     DDNAME(STRPT2)
  .
  Results are incorrect.
  The CREATE INDEX and DROP TABLE fields in the interval report DO
  add up to the value as presented in the STRPT1, however
  the DECLARE GLOBAL TEMP TABLE field does not.
  
  DSNZPARM STATIME=30 parameter is set in DB2 subsystem.
  When running the report with the INTERVAL option removed from
  the GLOBAL, the totals results are good.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 - Batch Reporting                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Values for DECLARE GLOBAL TEMP TABLE    *
  *                      are inaccurately shown in statistics    *
  *                      reports using the INTERVAL option.      *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  Values for DECLARE GLOBAL TEMP TABLE are inaccurately shown
  in statistics reports using the INTERVAL option.
  
  PROBLEM CONCLUSION:
  Correct interval calculation.
  
  KEYWORDS: DECLARE GLOBAL TEMP TABLE
  

Problem conclusion

• Correct interval calculation.
  
  KEYWORDS: DECLARE GLOBAL TEMP TABLE
  

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:

  PK58240 UK32395 UK32396

Modules/Macros

• DGOSACU2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK32395

     UP07/12/20 P F712

• R410 PSY UK32396

     UP07/12/20 P F712

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.