IBM Support

PI57245: OPTMODE OVERRIDE SPECIFIED IN DB2SORTI NOT HONORED

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Although an optimization mode can be requested by a user. DB2
    Sort cannot always honor that mode if there are memory
    constraints at the time of execution.
    
    Message CNK555I indicates the optimization mode in effect.
    
    This PTF enhances the message to include the following text when
    the user’s requested optimization mode cannot be honored:
    
    OPTMODE=CPU WAS FORCED BASED ON THE AMOUNT OF MEMORY AVAILABLE
    AT RUN TIME
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Sort z/OS.                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Although an optimization mode can be    *
    *                      requested by a user. DB2 Sort cannot    *
    *                      always honor that mode if there are     *
    *                      memory constraints at the               *
    *                      time of execution. Message CNK555I      *
    *                      indicates the  optimization mode in     *
    *                      effect.                                 *
    *                      This PTF enhances the message to        *
    *                      include the following text when the     *
    *                      user's requested optimization mode      *
    *                      can not be honored:                     *
    *                      OPTMODE=CPU WAS FORCED BASED ON THE     *
    *                      AMOUNT OF MEMORY AVAILABLE              *
    *                      AT RUN TIME                             *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI57245

  • Reported component name

    DB2 SORT FOR Z/

  • Reported component ID

    5655W4200

  • Reported release

    210

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-15

  • Closed date

    2016-04-13

  • Last modified date

    2016-05-04

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

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

    UI37025

Modules/Macros

  •    CNKANLZM CNKDSOP  CNKKQ019 CNKKQ132 CNKKQ154
    CNKNC539 CNKNC541 CNKT206  CNKT253  CNKT254  CNK0PCAL CNK4MSET
    CNK4MSGS
    

Fix information

  • Fixed component name

    DB2 SORT FOR Z/

  • Fixed component ID

    5655W4200

Applicable component levels

  • R210 PSY UI37025

       UP16/04/19 P F604

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0"}]

Document Information

Modified date:
31 March 2021