IBM Support

IC76542: DB2_EVMON_STMT_FILTER DOES NOT FILTER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This issue is easily reproducible against the sample database
    (db2sampl)
    
    Using the following shell script:
    
       MONITOR_NAME=EVMON_STMT
    
       # the following should record only the "CALL" statements
       db2set DB2_EVMON_STMT_FILTER='${MONITOR_NAME}:12'
       db2stop force
       db2start
    
       db2 connect to sample
       db2 delete from stmt_${MONITOR_NAME} where 1=1
    
       db2 create event monitor ${MONITOR_NAME} for statements write
    to table
       db2 set event monitor ${MONITOR_NAME} state 1
       db2 "select FIRSTNME, LASTNAME from employee where
    EMPNO='000230'"
       db2 set event monitor ${MONITOR_NAME} state 0
       db2 "select start_time, sequence_no, stmt_operation,
    substr(stmt_text,1,50) statement from stmt_${MONITOR_NAME}"
    
    
    
    The last select statement will show the following output :
    
    
    START_TIME                 SEQUENCE_NO STMT_OPERATION
    STATEMENT
    -------------------------- ----------- --------------------
    --------------------------------------------------
    2011-05-20-10.34.48.981832 00004                          1
    select FIRSTNME, LASTNAME from employee where EMPN
    2011-05-20-10.34.49.089473 00004                          4
    select FIRSTNME, LASTNAME from employee where EMPN
    2011-05-20-10.34.49.089473 00004                          7
    select FIRSTNME, LASTNAME from employee where EMPN
    2011-05-20-10.34.49.089473 00004                          6
    select FIRSTNME, LASTNAME from employee where EMPN
    2011-05-20-10.34.49.093972 00004                          8
    
      5 record(s) selected.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description above                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 Fix Pack 5                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 version 9.7 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76542

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

  • Closed date

    2011-12-23

  • Last modified date

    2011-12-23

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

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

    IC76692

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC76542

Modified date: 23 December 2011