IBM Support

IT27809: DB2 LOCK EVENT MONITOR REPORT: LOCK MODE HELD IS NONE IN PURESCALE

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

  • Incorrect Lock mode held output from lock event monitor , we
    have gotten the correct lock mode in sqlplGetHolderTidhdl ,
    while we missed the lock mode parameter in monitoring related
    code 
    
    
    381354  data DB2 UDB lock manager sqlplGetHolderTidhdl fnc
    (3.3.35.282.0.1037)
            pid 6816152 tid 55483 cpid 5309066 node 0 probe 1037
            bytes 28
    
            Data1   (PD_TYPE_SQLP_TIDHDL,4) Transaction ID handle:
            3 (User)
            Data2   (PD_TYPE_SQLP_LOCK_MODE,8) Lock Mode:
            SQLP_LOIX (.IX) - Intention Exclusive Lock
    
    381356  data DB2 UDB lock manager sqlplGetBlockerTidhdl fnc
    (3.3.35.305.0.1109)
            pid 6816152 tid 55483 cpid 5309066 node 0 probe 1109
            bytes 28
    
            Data1   (PD_TYPE_SQLP_TIDHDL,4) Transaction ID handle:
            3 (User)
            Data2   (PD_TYPE_SQLP_LOCK_MODE,8) Lock Mode:
            SQLP_LOIX (.IX) - Intention Exclusive Lock
    
    Example output as below , "Lock mode held none" was output in
    the event monitor 
    -------------------------------------------------------
    Event ID               : 1
    Event Type             : LOCKWAIT
    Event Timestamp        : 2018-12-20-11.30.08.383184
    Partition of detection : 1
    -------------------------------------------------------
    Participant No 1 requesting lock 
    ----------------------------------
    Lock Name            : 0x00030008000000000000000054
    Lock wait start time : 2018-12-20-11.30.08.082151
    Lock wait end time   : 2018-12-20-11.30.28.144015
    Lock Type            : TABLE
    Lock Specifics       : 
    Lock Attributes      : 00080000
    Lock mode requested  : Share
    Lock mode held       : none------>>>
    Lock Count           : 0
    Lock Hold Count      : 0
    Lock rrIID           : 0
    Lock Status          : Waiting
    Lock release flags   : 00000000
    Tablespace TID       : 3
    Tablespace Name      : IBMDB2SAMPLEREL
    Table FID            : 8
    Table Schema         : DB2SDIN1
    Table Name           : T1
    deadlock.txt (9%)
    deadlock.txt (10%)
    Attributes            Requester                        Owner    
    
    --------------------- ------------------------------  
    ------------------------------  
    Participant No        1                                2        
    
    Application Handle    12320                            012781  
    
    Application ID        *N1.db2sdin1.181220164248      
    *N0.db2sdin1.181220172141       
    Application Name      db2bp                            db2bp    
    
    Authentication ID     DB2SDIN1                         DB2SDIN1
    
    Requesting AgentID    81728                            82499    
    
    Coordinating AgentID  81728                            82499    
    
    Agent Status          UOW Executing                    UOW
    Waiting                     
    Application Action    No action                        No action
    
    Lock timeout value    20                               0        
    
    Lock wait value       300                              0        
    
    Workload ID           1                                1        
    
    Workload Name         SYSDEFAULTUSERWORKLOAD          
    SYSDEFAULTUSERWORKLOAD          
    Service subclass ID   13                               13      
    
    Service superclass    SYSDEFAULTUSERCLASS            
    SYSDEFAULTUSERCLASS             
    Service subclass      SYSDEFAULTSUBCLASS              
    SYSDEFAULTSUBCLASS              
    Current Request       Open Cursor                      Execute
    Immediate               
    TEntry state          1                                2 
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.5 or later                             *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.5 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27809

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-01-17

  • Closed date

    2019-10-31

  • Last modified date

    2019-10-31

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

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

    IT30808

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

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

Document Information

Modified date:
31 October 2019