IBM Support

PI70038: BIGSQL MAY HANG DUE TO A DEADLATCH IN MONITORING ROUTINES.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • BigSQL hang due to a deadlatch in monitoring routines.
    
    Stack may contain the following function calls:
    sqmObjMetricsTable
    sqlbMonitorLRP
    sqlbfix
    sqldFetchDirect
    sqldDataFetch
    sqlischf
    sqlirdk
    sqldIndexFetch
    sqldRowFetch
    sqlrlCatalogScan
    sqlrlCatalogScan
    sqlrwExtTableObjMetricsBuilder
    sqlrwFilteredObjHashTableIterator
    sqlrwGetTableMetrics
    sqlrwGetWLMTableFunctionResult
    sqlrwGetWLMTableFunctionMergedResult
    sqlerTrustedRtnCallbackRouter
    monGetTable
    
    Latches output can be seen as follows:
    SQLO_LT_sqmObjMetricsTable__m_objMetricsLatch
    

Local fix

  • Set the MON_OBJ_METRICS db cfg parm to BASE
    Command:
    db2 update db cfg using MON_OBJ_METRICS BASE immediate
    

Problem summary

  • See error description
    

Problem conclusion

  • The problem is fixed in Version 5.0.0.0 and later fix packs
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI70038

  • Reported component name

    INFO BIGINSIGHT

  • Reported component ID

    5725C0900

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-30

  • Closed date

    2018-03-01

  • Last modified date

    2018-03-01

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

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

Modules/Macros

  • Unknown
    

Fix information

  • Fixed component name

    INFO BIGINSIGHT

  • Fixed component ID

    5725C0900

Applicable component levels

  • R425 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 August 2020