IBM Support

IT31308: IN DB2 PURESCALE EXTENT MOVEMENT MIGHT TIMEOUT AND THEN BRING DBDOWN WHEN LOCKTIMEOUT IS NOT -1

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

  • In pureScale when database configuration parameter LOCKTIMEOUT
    is not the
    default value -1, an extent movement started by an ALTER
    TABLESPACE LOWER HIGH WATER MARK or an ALTER TABLESPACE REDUCE
    MAX could return a lock time out error which in return will
    bring the system down.
    
    Key entries in db2diag.log :
    
    2019-11-28-06.33.02.188901-300 I1072258134A1106     LEVEL:
    Severe
    PID     : 7209176              TID : 66395          PROC :
    db2sysc 0
    INSTANCE: db2inst1              NODE : 000           DB   :
    SAMPLE
    EDUID   : 66395                EDUNAME: db2ExtMovHelper (SAMPLE)
    0
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbEMHelperEDU::sqlbExtentMovementHelperEntryPoint, probe:12217
    MESSAGE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT
              "LockTimeOut - tran rollback Reason code 68"
    DATA #1 : String, 14 bytes
    Error Occurred
    
    
    2019-11-28-06.33.02.189754-300 I1072259241A966      LEVEL: Info
    PID     : 7209176              TID : 66395          PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    SAMPLE
    HOSTNAME: host1
    EDUID   : 66395                EDUNAME: db2ExtMovHelper (SAMPLE)
    0
    FUNCTION: DB2 UDB, base sys utilities,
    sqeLocalDatabase::ForceDBShutdown, probe:16937
    DATA #1 : Pointer, 8 bytes
    0x0000000000000000
    DATA #2 : Boolean, 1 bytes
    false
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x090000001ECF8044 ForceDBShutdown__16sqeLocalDatabaseFi +
    0x364
      [1] 0x09000000212B315C
    sqlbExtentMovementHelperEntryPoint__15sqlbEMHelperEDUFv + 0x49C
      [2] 0x09000000212B2AB8 RunEDU__15sqlbEMHelperEDUFv + 0x38
      [3] 0x090000001E1A4C40 EDUDriver__9sqzEDUObjFv + 0x300
      [4] 0x090000001E086280 sqloEDUEntry + 0x360
      [5] 0x0900000000570E10 _pthread_body + 0xF0
      [6] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    

Local fix

  • Set database configuration parameter LOCKTIMEOUT to -1 after db2
    restart db.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V11.1.4.6                                         *
    ****************************************************************
    

Problem conclusion

  • Upgrade to V11.1.4.6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT31308

  • 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-12-17

  • Closed date

    2021-03-19

  • Last modified date

    2021-03-19

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

  • 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:
20 March 2021