IBM Support

IV26410: DATABASE LOCKING IN ITNM POLLER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Product: Tivoli Network Manager
    Version: 3.8
    Component: Poller
    
    Symptoms;
    Under specific conditions a lock can be held on DB2 tables that
    prevents other applications acheiving a similar lock.
    

Local fix

  • Restart the ncp_poller process to release the lock.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All ITNM 3.8 and 3.9 Users                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Under specific conditions a lock can be held on DB2 tables   *
    * that                                                         *
    * prevents other applications achieving a similar lock.        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * fix pack | 3.9.0-ITNMIP-FP0003                               *
    * fix pack | 3.8.0-ITNMIP-FP0007                               *
    ****************************************************************
    

Problem conclusion

  • The underlying cause is the way in which DB2 applies locking. In
    the default mode (that we use), each individual statement is an
    implicit transaction. It is only when that transaction is
    committed that resources such as locks are released.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV26410

  • Reported component name

    NC/PREC DISCOVY

  • Reported component ID

    5724O52DS

  • Reported release

    380

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-08-20

  • Closed date

    2012-11-10

  • Last modified date

    2013-04-04

  • 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

    NC/PREC DISCOVY

  • Fixed component ID

    5724O52DS

Applicable component levels

  • R380 PSN

       UP

  • R380 PSY

       UP

  • R390 PSN

       UP

  • R390 PSY

       UP

[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"380"}]

Document Information

Modified date:
03 October 2021