IBM Support

IC75111: ERROR LOG MESSAGE WAS DUMPED INTO DB2DIAG.LOG WHEN THE EVENT MON ITOR NAME DOES NOTEXIST ON DROP EVENT MONITOR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • following Error log message is dumped into db2diag.log when  the
    event monitor
    name does not exist on drop event monitor.  In this case the
    event monitor
    name is  '@@@@@@1@__DWDPE$'
    
    ----------------------------------------------------------------
    
    2010-11-19-02.33.54.389316-480 I100673A614      LEVEL: Error
    PID     : 421994              TID  : 44723      PROC : db2sysc0
    INSTANCE: db2inst1            NODE : 000        DB   : SAMPLE
    APPHDL  : 0-5374              APPID: x.x.x.x.58916.101119103401
    AUTHID  : DB2ADMIN
    EDUID   : 44723               EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, database monitor, sqm_evmon_mgr::dropEvmon,
              probe:10
    CALLED  : DB2 UDB, catalog services, sqlrlGetEvmonDesc
    RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    DATA #1 : String with size, 16 bytes
              @@@@@@1@__DWDPE$
    
    
    2010-11-19-02.33.54.389490-480 I101288A861     LEVEL: Error
    PID     : 421994              TID  : 44723    PROC : db2sysc0
    INSTANCE: db2inst1            NODE : 000      DB   : SAMPLE
    APPHDL  : 0-5374              APPID: x.x.x.x.58916.101119103401
    AUTHID  : DB2ADMIN
    EDUID   : 44723               EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
              logging func, probe:0
     DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -204   sqlerrml: 16
     sqlerrmc: @@@@@@1@__DWDPE$
     sqlerrp : SQLRL0AF
     sqlerrd : (1) 0x801A006D  (2) 0x00000000  (3) 0x00000000
               (4) 0x00000000  (5) 0xFFFFFFEC  (6) 0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)       (11)
     sqlstate:
    
    
    2010-11-19-02.33.54.482105-480 I102150A745    LEVEL: Warning
    PID     : 421994               TID  : 12456   PROC : db2sysc0
    INSTANCE: db2inst1             NODE : 000     DB   : SAMPLE
    APPHDL  : 0-5387               APPID: *N0.DB2.101119103417
    AUTHID  : DB2ADMIN
    EDUID   : 12456                EDUNAME: db2evmti (DB2STATISTICS)
    FUNCTION: DB2 UDB, database monitor,
              sqm_evmon_ttarget::get_table_info,
              probe:70
    CALLED  : DB2 UDB, data management, sqldGetTableData
    RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT
    DETECTED"
              DIA8003C The interrupt  has been received.
    DATA #1 : String, 118 bytes
              Event Monitor Name: DB2STATISTICS;
              TableName: HISTOGRAMBIN_DB2STATISTICS;
              Unable to get information about the Table!
    
    ----------------------------------------------------------------
    

Local fix

Problem summary

  • following Error log message is dumped into db2diag.log when  the
    event monitor  name does not exist on drop event monitor.  In
    this case the  event monitor  name is  '@@@@@@1@__DWDPE$'
    
    
    ----------------------------------------------------------------
    
    2010-11-19-02.33.54.389316-480 I100673A614      LEVEL: Error
    PID    : 421994              TID  : 44723      PROC : db2sysc0
    INSTANCE: db2inst1            NODE : 000        DB  : SAMPLE
    APPHDL  : 0-5374              APPID: x.x.x.x.58916.101119103401
    AUTHID  : DB2ADMIN
    EDUID  : 44723              EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, database monitor, sqm_evmon_mgr::dropEvmon,
              probe:10
    CALLED  : DB2 UDB, catalog services, sqlrlGetEvmonDesc
    RETCODE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
              "SQLCA has already been built"
    DATA #1 : String with size, 16 bytes
              @@@@@@1@__DWDPE$
    
    
    2010-11-19-02.33.54.389490-480 I101288A861    LEVEL: Error
    PID    : 421994              TID  : 44723    PROC : db2sysc0
    INSTANCE: db2inst1            NODE : 000      DB  : SAMPLE
    APPHDL  : 0-5374              APPID: x.x.x.x.58916.101119103401
    AUTHID  : DB2ADMIN
    EDUID  : 44723              EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
              logging func, probe:0
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA    sqlcabc: 136  sqlcode: -204  sqlerrml: 16
    sqlerrmc: @@@@@@1@__DWDPE$
    sqlerrp : SQLRL0AF
    sqlerrd : (1) 0x801A006D  (2) 0x00000000  (3) 0x00000000
              (4) 0x00000000  (5) 0xFFFFFFEC  (6) 0x00000000
    sqlwarn : (1)      (2)      (3)      (4)        (5)      (6)
              (7)      (8)      (9)      (10)      (11)
    sqlstate:
    
    
    2010-11-19-02.33.54.482105-480 I102150A745    LEVEL: Warning
    PID    : 421994              TID  : 12456  PROC : db2sysc0
    INSTANCE: db2inst1            NODE : 000    DB  : SAMPLE
    APPHDL  : 0-5387              APPID: *N0.DB2.101119103417
    AUTHID  : DB2ADMIN
    EDUID  : 12456                EDUNAME: db2evmti (DB2STATISTICS)
    FUNCTION: DB2 UDB, database monitor,
              sqm_evmon_ttarget::get_table_info,
              probe:70
    CALLED  : DB2 UDB, data management, sqldGetTableData
    RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT
    DETECTED"
              DIA8003C The interrupt  has been received.
    DATA #1 : String, 118 bytes
              Event Monitor Name: DB2STATISTICS;
              TableName: HISTOGRAMBIN_DB2STATISTICS;
              Unable to get information about the Table!
    
    ----------------------------------------------------------------
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC75111

  • 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-03-17

  • Closed date

    2011-12-09

  • Last modified date

    2011-12-09

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

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

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 December 2011