IC88985: CHANGING sqm___delete_sqlmon_stmt DB2DIAG.LOG ERROR TO INFORMATIONAL

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows

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 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