IBM Support

IT27970: SEMAPHORE BY DB2ACD LEFT OVER AFTER DB2STOP

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as Permanent restriction.

Error description

  • When stopping hmon we should be releasing the semaphore, but
    only the semaphore by db2acd is leftover after db2stop.
    This is not a high risk issue. Only this one semaphore is
    leftover and it is cleaned up and replaced with a new one during
    every db2start.
    ----------
    $ db2start
    $ ipcs -s|grep db2inst1
    0xe2d82e74 2136375311 db2inst1 645 1
    0x00000000 2136408425 db2inst1 661 1
    0x00000000 2136473963 db2inst1 661 1
    0x00000000 2136506732 db2inst1 661 1
    0x00000000 2136539501 db2inst1 661 1
    0x00000000 2136572270 db2inst1 661 1
    0x00000000 2136605039 db2inst1 661 1
    0x00000000 2136637808 db2inst1 661 1
    0x00000000 2136670577 db2inst1 661 1
    0xe2d82e73 2136703346 db2inst1 667 1
    0x00000000 2136736115 db2inst1 661 1
    0xe2d82f69 2136834420 db2inst1 661 1 <--(*)
    $ db2stop
    SQL1064N DB2STOP processing was successful.
    $ ipcs -s|grep db2inst1
    0xe2d82f69 2136834420 db2inst1 661 1 <--(*)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * See Error Description                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * See Error Description                                        *
    ****************************************************************
    

Problem conclusion

  • See Error Description
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27970

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-02-04

  • Closed date

    2019-08-15

  • Last modified date

    2019-08-23

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

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

Fix information

Applicable component levels



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: B10

Reference #: IT27970

Modified date: 23 August 2019