IBM Support

PH43668: INFORM THAT REQUESTED QUIESCE NO LOCK YES DOES NOT ENSURE UNLOADED DATA CONSISTENCY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • As unloading data with LOCK YES but QUIESCE NO, for a unload run
    in native mode, can lead to incomplete or inconsistent unloaded
    data, an informational message should be issued about this
    situation.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 High Performance Unload         *
    *                 for z/OS                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: As unloading data with LOCK YES but     *
    *                      QUIESCE NO, for a unload run in native  *
    *                      mode, can lead to incomplete or         *
    *                      inconsistent unloaded data, an          *
    *                      informational message should be issued  *
    *                      about this situation.                   *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    Inform that requested QUIESCE NO LOCK YES does not ensure
    unloaded data consistency.
    

Problem conclusion

  • Code has been changed to fix this problem
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH43668

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-01-27

  • Closed date

    2022-02-21

  • Last modified date

    2022-03-01

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

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

Modules/Macros

  • INZ$$PRM INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R510 PSY UI79279

       UP22/03/01 P F202

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":"5.1.0"}]

Document Information

Modified date:
02 March 2022