IBM Support

IT31088: EXPLICT REBIND AND ATTACH/DETACH/ADD PARTITION MAY DEADLOCK

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • DEADLOCK was occurred explicit rebind and attach/detach/add
    partition concurrently.
    
    Program A
    ALTER TABLE TABLEA DETACH PARTITION P061 INTO P61;
    ALTER TABLE TABLEA ADD PARTITION P061 STARTING FROM ('023')
    ENDING AT ('028')
    rebind package spserver;
    
    Program B
    ALTER TABLE TABLEA DETACH PARTITION P061 INTO P61;
    ALTER TABLE TABLEA ADD PARTITION P061 STARTING FROM ('023')
    ENDING AT ('028')
    rebind package spserver;
    
    Executed Program A and B concurrently, then DEADLOCK was
    occurred.
    
    Here is a sample of DEADLCK report.
    -------------------------------------------------------
    Event ID               : 10
    Event Type             : DEADLOCK
    Event Timestamp        : 2019-11-09-02.00.59.568645
    Partition of detection : 0
    -------------------------------------------------------
    
    Deadlock Graph
    --------------
    Total number of deadlock participants : 2
    Participant that was rolled back      : 1
    Type of deadlock                      : local
    
    Participant     Participant     Deadlock Member Application
    Handle
    Requesting Lock Holding Lock
    --------------- --------------- ---------------
    ------------------
    1               2               0               045836
    2               1               0               045680
    
    
    Participant No 1 requesting lock
    ----------------------------------
    Lock Name            : 0x000100000A00030BCB1B7C20C3
    Lock wait start time : 2019-11-09-02.00.55.139364
    Lock wait end time   : 2019-11-09-02.00.59.568645
    Lock Type            : CATALOG
    Lock Specifics       : loadingID:00000000,loadingBytes:0A00030B
    CB1B7C20
    Lock Attributes      : 00000000
    Lock mode requested  : Exclusive
    Lock mode held       : Exclusive
    Lock Count           : 0
    Lock Hold Count      : 0
    Lock rrIID           : 0
    Lock Status          : Waiting
    Lock release flags   : 00000000
    Tablespace TID       :
    Tablespace Name      :
    Table FID            :
    Table Schema         :
    Table Name           :
    
    Participant No 2 requesting lock
    ----------------------------------
    Lock Name            : 0x0000000E000000000050002252
    Lock wait start time : 2019-11-09-02.00.55.360624
    Lock wait end time   : 2019-11-09-02.00.59.568645
    Lock Type            : ROW
    Lock Specifics       : ROWID=34,DATA_PARTITION_ID=0,PAGEID=80
    Lock Attributes      : 00040000
    Lock mode requested  : Share
    Lock mode held       : Exclusive
    Lock Count           : 0
    Lock Hold Count      : 0
    Lock rrIID           : 0
    Lock Status          : Waiting
    Lock release flags   : 00000000
    Tablespace TID       : 0
    Tablespace Name      : SYSCATSPACE
    Table FID            : 14
    Table Schema         : SYSIBM
    Table Name           : SYSPLANDEP
    
    
    Attributes            Requester                        Requester
    --------------------- ------------------------------
    ------------------------------
    Participant No        1                                2
    Application Handle    045836                           045680
    Application ID        *N0.db2inst1.191113004057
    XX.X.XXX.XXXX.38685.191108170055
    Application Name      db2bp                            db2bp
    Authentication ID     DB2INST1                          DB2INST1
    Requesting AgentID    89240                            105695
    Coordinating AgentID  89240                            105695
    Agent Status          Recompiling                      UOW
    Executing
    Application Action    No action                        No action
    Lock timeout value    60                               60
    Lock wait value       5000                             5000
    Workload ID           1                                107
    Workload Name         SYSDEFAULTUSERWORKLOAD
    BATUSER1_WL
    Service subclass ID   13                               22
    Service superclass    SYSDEFAULTUSERCLASS
    BAT_MED_CLASS
    Service subclass      SYSDEFAULTSUBCLASS
    SYSDEFAULTSUBCLASS
    Current Request       Rebind                           Execute
    Immediate
    TEntry state          2                                2
    TEntry flags1         00000000                         00000020
    TEntry flags2         00000200                         00000200
    Lock escalation       no                               no
    Client userid
    Client wrkstnname
    Client applname                                        TESTPGM
    Client acctng
    Utility ID
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 V11.1 Mod 4 FixPack 6                         *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Db2 UDB Version 11.1 Mod 4 FixPack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31088

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-11-26

  • Closed date

    2021-03-29

  • Last modified date

    2021-03-29

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

    IT31070

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
31 March 2021