PK87913: INCORRECTLY MISS CLASSIFICATION ON INDEPENDENT ENCLAVES THAT ARE CREATED FOR ZIIP OFFLOAD THAT ARE SUBSYSTEM TYPE DB2

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Incorrect or Missed CLASSIFICATION ON INDEPENDENT ENCLAVEs that
    are Created FOR ZIIP OFFLOAD when workload enclaves exist under
    the subsystem type "DB2" for parallel tasks.
    Note:  This involves joint cooperation with WLM APAR OA26104.
    DB2PARALL/K
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 users that exploit CP query        *
    *                 parallelism in remote stored procedurs       *
    *                 and UDFs.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: System slowdown while running remote    *
    *                      stored procedures and UDFs with CP      *
    *                      query parallelism.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DB2 incorrectly assigned high priority to child tasks for
    remote stored procedures, causing system slowdown.
    

Problem conclusion

  • DB2 has been enhanced to use work-dependent enclaves while
    creating parallel tasks in a stored procedure or UDF.
    
    Work-dependent enclaves will be considered a part of the
    underlying enclave's transaction. For more information
    regarding work-dependent enclaves, please refer to the
    closing text of WLM APAR OA26104.
    

Temporary fix

Comments

  • ž**** PE09/12/09 FIX IN ERROR. SEE APAR PM03139  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PK87913

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-03

  • Closed date

    2009-08-28

  • Last modified date

    2011-05-18

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

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

    UK49700

Modules/Macros

  •    DSNDTMT  DSNTTRUN DSNTTTC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK49700

       UP09/09/15 P F909

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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PK87913

Modified date:

2011-05-18

Translate my page

Machine Translation

Content navigation