IBM Support

PI81647: DSNX812I MIGHT BE ISSUED WHEN IDAA COMMAND IS ISSUED WITH SCOPE(GROUP) AND HIT A FALSE LOCK CONTENTION WHEN THE RESOURCE IS BUSY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DSNX812I message might be returned when IDAA command is issued
    with SCOPE(GROUP) and hit a false lock contention when the
    resource is busy
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 11 for z/OS who use         *
    *                 IBM DB2 Analytics Accelerator                *
    ****************************************************************
    * PROBLEM DESCRIPTION: DSNX812I MIGHT BE ISSUED WHEN DB2       *
    *                      ACCELERATOR COMMAND SUCH AS             *
    *                      STOP/START/DISPLAY ACCEL                *
    *                      IS ISSUED WITH SCOPE(GROUP) AND HIT     *
    *                      A FALSE LOCK CONTENTION WHEN THE        *
    *                      RESOURCE IS BUSY.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DSNX812I MIGHT BE ISSUED WHEN DB2 ACCELERATOR COMMAND SUCH AS
    STOP/START/DISPLAY ACCEL IS ISSUED WITH SCOPE(GROUP) AND HIT A
    FALSE LOCK CONTENTION WHEN THE RESOURCE IS BUSY. FOR EXAMPLE
    THE SAME LOCK HASH ENTRY COULD BE HELD BY LOCK REQUESTS OTHER
    THAN ACCELERATOR COMMAND.
    

Problem conclusion

  • DB2 IS FIXED TO USE ASYNC LOCK REQUEST FOR ACCELERATOR COMMAND
    LOCK TO AVOID FALSE LOCK CONTENTION WHEN SAME HASH ENTRY IS
    HELD BY LOCK REQUEST OTHER THAN ACCELERATOR COMMAND LOCK
    REQUEST.
    ADDITIONAL KEYWORDS: IDAAV4R1/K IDAAV5R1/K IDAAV6R1/K
    MSGDSNX812I
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI81647

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-05-15

  • Closed date

    2017-07-17

  • Last modified date

    2017-09-02

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

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

    UI48893

Modules/Macros

  • DSNX8CMD
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI48893

       UP17/08/02 P F708

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 September 2017