IBM Support

PI40375: DB2 UET LOAD JOB CANNOT BE CANCELLED AFTER HITTTING MAX CPU TIME

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This fix will eliminate the hang and the job will terminate with
    S322.
    It WILL BE RESTARTABLE with a stopped utility.
    Then options are running the ABPMAINT utility to term the
    utility and clean up the ABP status tables OR just run the job
    again to load more rows until it completes or gets another S322.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Utilities Enhancement Tool.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: This fix will eliminate the hang and    *
    *                      the job will terminate with             *
    *                      S322. It WILL BE RESTARTABLE with a     *
    *                      stopped utility. Then options are       *
    *                      running the ABPMAINT utility to term    *
    *                      the utility and clean up the ABP        *
    *                      status tables OR just run the job       *
    *                      again to load more rows until it        *
    *                      completes or gets another S322.         *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI40375

  • 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-05-04

  • Closed date

    2015-06-29

  • Last modified date

    2015-08-03

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

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

Modules/Macros

  •    ABPGPSQL
    

Fix information

  • Fixed component name

    DB2 UTIL ENHANC

  • Fixed component ID

    5655T5800

Applicable component levels

  • R220 PSY UI28935

       UP15/07/08 P F507

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:
12 February 2021