IC88985: CHANGING sqm___delete_sqlmon_stmt DB2DIAG.LOG ERROR TO INFORMATIONAL

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Error messages may be seen periodically like below:
    
    2012-11-29-11.11.01.937611-300 E73957A6628        LEVEL: Error
    PID     : 1000000              TID  : 53000       PROC : db2sysc
    0
    INSTANCE: db2inst1              NODE : 000         DB   : Sample
    APPHDL  : 0-36608              APPID:
    10.11.71.32.45186.121129154421
    AUTHID  : DB2INST1
    EDUID   : 53000                EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, database monitor, sqm___delete_sqlmon_stmt,
    probe:502
    DATA #1 : String, 37 bytes
    stmt_entry already on the free list.
    DATA #2 : Pointer, 8 bytes
    0x07800000034d7c80
    DATA #3 : Hexdump, 992 bytes
    
    ********************************
    It is being logged because we have identified a scenario where
    the next statement being attempted to be added to the free list
    of statements is already there on this free list. This will
    reduce the severity of the message to an informational instead
    of error.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of DB2 V9.7                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to fix pack 8                                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in V9.7 fix pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88985

  • 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

    2012-12-10

  • Closed date

    2013-04-01

  • Last modified date

    2013-04-01

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

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

    IC88994 IC91699

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC88985

Modified date:

2013-04-01

Translate my page

Machine Translation

Content navigation