IBM Support

IC76636: INTERRUPTING CLIENT MIGHT LEAD TO ENGINE HANG DUE TO AGENT STUCK IN SEMOP().

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In this example 'db2look' was used as the client.
    After interrupting 'db2look' using CTRL-C we can see that the
    'db2look' process is gone as it does not appear in the 'ps'
    output
    anymore.
    
    
    $ ps -ef | grep db2look | grep -v grep
    
    However, db2look still appears in the list of applications.
    
    $ db2 list applications
    
    Auth Id  Application    Appl.      Application Id
                                     DB       # of
             Name           Handle
                                     Name    Agents
    -------- -------------- ----------
    --------------------------------------------------------------
    -------- -----
    E95Q7A   db2look        97         *LOCAL.e95q7a.110408030010
                                     SAMPLE   1
    
    $ db2pd -db sample -locks
    
    Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days
    00:04:13 -- Date 04/05/2011 13:34:33
    
    Locks:
    Address            TranHdl    Lockname                   Type
       Mode Sts Owner      Dur HoldCount  Att  ReleaseFlg
    0x07000000303505C0 2          4442324C32473032E3E6718241
    Internal P ..S  G   2          1   0          0x00 0x40000000
    0x0700000030350E80 2          00000001000000010001240056
    Internal V ..S  G   2          1   0          0x00 0x40000000
    0x0700000030350A80 2          00000005000000000000000054 Table
       .IN  G   2          1   1          0x00 0x40000000
    0x0700000030351C80 2          00000061000000000000000054 Table
       .IN  G   2          1   1          0x00 0x40000000
    0x0700000030351A80 2          0000000C000000000000000054 Table
       .IN  G   2          1   1          0x00 0x40000000
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * In this example 'db2look' was used as the client.            *
    *                                                              *
    * After interrupting 'db2look' using CTRL-C we can see that    *
    * the                                                          *
    * 'db2look' process is gone as it does not appear in the 'ps'  *
    *                                                              *
    * output                                                       *
    *                                                              *
    * anymore.                                                     *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * $ ps -ef | grep db2look | grep -v grep                       *
    *                                                              *
    *                                                              *
    *                                                              *
    * However, db2look still appears in the list of applications.  *
    *                                                              *
    *                                                              *
    *                                                              *
    * $ db2 list applications                                      *
    *                                                              *
    *                                                              *
    *                                                              *
    * Auth Id  Application    Appl.      Application Id            *
    *                                                              *
    *                                 DB      # of                 *
    *                                                              *
    *         Name          Handle                                 *
    *                                                              *
    *                                 Name    Agents               *
    *                                                              *
    * -------- -------------- ----------                           *
    *                                                              *
    * ------------------------------------------------------------ *
    * --                                                           *
    * -------- -----                                               *
    *                                                              *
    * E95Q7A  db2look        97        *LOCAL.e95q7a.110408030010  *
    *                                 SAMPLE  1                    *
    *                                                              *
    *                                                              *
    * $ db2pd -db sample -locks                                    *
    *                                                              *
    *                                                              *
    *                                                              *
    * Database Partition 0 -- Database SAMPLE -- Active -- Up 0    *
    * days                                                         *
    * 00:04:13 -- Date 04/05/2011 13:34:33                         *
    *                                                              *
    *                                                              *
    *                                                              *
    * Locks:                                                       *
    *                                                              *
    * Address            TranHdl    Lockname                  Type *
    *                                                              *
    *   Mode Sts Owner      Dur HoldCount  Att  ReleaseFlg         *
    *                                                              *
    * 0x07000000303505C0 2          4442324C32473032E3E6718241     *
    *                                                              *
    * Internal P ..S  G  2          1  0          0x00 0x40000000  *
    * 0x0700000030350E80 2          00000001000000010001240056     *
    *                                                              *
    * Internal V ..S  G  2          1  0          0x00 0x40000000  *
    * 0x0700000030350A80 2          00000005000000000000000054     *
    * Table                                                        *
    *   .IN  G  2          1  1          0x00 0x40000000           *
    * 0x0700000030351C80 2          00000061000000000000000054     *
    * Table                                                        *
    *   .IN  G  2          1  1          0x00 0x40000000           *
    * 0x0700000030351A80 2          0000000C000000000000000054     *
    * Table                                                        *
    *   .IN  G  2          1  1          0x00 0x40000000           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB version 9.7 fixpack 5.                    *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76636

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-25

  • Closed date

    2011-12-08

  • Last modified date

    2011-12-08

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

    IC76437

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC76636

Modified date: 08 December 2011