IBM Support

PI36125: LONG RUNTIMES IN PACKAGE ABPGPSQL

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Tablespace scans can result in long runtimes when deleting rows
from SYSIBM.SYSTABLESPACESTATS in package ABPGPSQL.  The delete
is currently performed using DBNAME and NAME.  The delete will
be changed to use DBID and PSID in order to utilize index
DSNRTX01.

Local fix

  •

Problem summary

  • ****************************************************************
* USERS AFFECTED: Users of DB2 Utilities Enhancement Tool.     *
****************************************************************
* PROBLEM DESCRIPTION: Tablespace scans can result in long     *
*                      runtimes when deleting rows from        *
*                      SYSIBM.SYSTABLESPACESTATS in package    *
*                      ABPGPSQL.  The delete is currently      *
*                      performed using DBNAME and NAME.  The   *
*                      delete will be changed to use DBID and  *
*                      PSID in order to utilize index          *
*                      DSNRTX01.                               *
****************************************************************
* RECOMMENDATION: APPLY the PTF.                               *
****************************************************************
Code has been changed to correct this condition.

Problem conclusion

  • APPLY the PTF.

Temporary fix

  •

Comments

  •

APAR Information

  • APAR number

    PI36125

  • Reported component name

    DB2 UTIL ENHANC

  • Reported component ID

    5655T5800

  • Reported release

    220

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-03-02

  • Closed date

    2015-05-12

  • Last modified date

    2015-06-01

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

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

Modules/Macros

  •    ABPGCOMM

Fix information

  • Fixed component name

    DB2 UTIL ENHANC

  • Fixed component ID

    5655T5800

Applicable component levels

  • R220 PSY UI27555

       UP15/05/19 P F505

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.2.0"}]

Document Information

Modified date:
03 April 2021

Page Feedback