IBM Support

PH65632: PARALLELISM ENHANCEMENT FOR DGTT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • New function parallelism enhancement for workfile DGTT
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of Db2 13 for z/OS users of        *
    *                 Delclare Global Temp Table (DGTT) created    *
    *                 in Partitioned by Growth (PBG) table space   *
    *                 of work file database running on             *
    *                 parallelism.                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: This is a new function APAR which       *
    *                      enable the parallelism support of a     *
    *                      DGTT table created in PBG table space   *
    *                      which resides in work file database.    *
    ****************************************************************
    This APAR enable parallelism support on a DGTT table created
    in PBG table space which resides in work file database. In
    addition, the algorithm determined the number of pages for
    each child task is also improved specially for partitioned on
    DGTT PBG table when it runs on parallelism with page range
    access.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH65632

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    D10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2025-03-12

  • Closed date

    2025-05-28

  • Last modified date

    2025-07-02

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

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

    UO03399

Modules/Macros

  • DSNTABA  DSNXECWA DSNXOLCM DSNXOLDE DSNXOLDP DSNXOLM1 DSNXRBMN
    DSNXRLPT DSNXRSTP DSNXRSTS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RD10 PSY UO03399

       UP25/06/05 P F506  

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.

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Document Information

Modified date:
02 July 2025