IBM Support

IC75525: EVMON_FORMAT_UE_TO_TABLES DOES NOT OUTPUT ANYTHING IF PARTIAL EVENT EXISTS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • EVMON_FORMAT_UE_TO_TABLES does not output anything if partial
    event exists.
    
    The UE table included the incomplete events.
    In case of EVMON_FORMAT_UE_TO_TABLES:
        Did not output complete events information to relational
    table,
    
    Partial event is mentioned at the following URL.
    http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?t
    opic=/com.ibm.db2.luw.sql.rtn.doc/doc/r0054909.html
    
    $ db2 "SELECT count(*) FROM TABLE (EVMON_FORMAT_UE_TO_XML...
    
    1
    -----------
              1
    
    Before fix,
    EVMON_FORMAT_UE_TO_TABLES returned SQL443N with 0 record.
    $ db2 call EVMON_FORMAT_UE_TO_TABLES(...)
    SQL0443N
    $ db2 "select count(*) from lock_event"
    
    1
    -----------
              0
    
    After fix, EVMON_FORMAT_UE_TO_TABLES returned SQL443N,but
    inserted record.
    
    $ db2 call EVMON_FORMAT_UE_TO_TABLES(...)
    SQL0443N
    $ db2 "select count(*) from lock_event"
    
    1
    -----------
              1
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * EVMON_FORMAT_UE_TO_TABLES does not output anything if        *
    * partial                                                      *
    * event exists.                                                *
    *                                                              *
    *                                                              *
    *                                                              *
    * The UE table included the incomplete events.                 *
    *                                                              *
    * In case of EVMON_FORMAT_UE_TO_TABLES:                        *
    *                                                              *
    *     Did not output complete events information to relational *
    *                                                              *
    * table,                                                       *
    *                                                              *
    *                                                              *
    *                                                              *
    * Partial event is mentioned at the following URL.             *
    *                                                              *
    * http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.j *
    * sp?t                                                         *
    * opic=/com.ibm.db2.luw.sql.rtn.doc/doc/r0054909.html          *
    *                                                              *
    *                                                              *
    *                                                              *
    * $ db2 "SELECT count(*) FROM TABLE (EVMON_FORMAT_UE_TO_XML... *
    *                                                              *
    *                                                              *
    *                                                              *
    * 1                                                            *
    *                                                              *
    * -----------                                                  *
    *                                                              *
    *           1                                                  *
    *                                                              *
    *                                                              *
    *                                                              *
    * Before fix,                                                  *
    *                                                              *
    * EVMON_FORMAT_UE_TO_TABLES returned SQL443N with 0 record.    *
    *                                                              *
    * $ db2 call EVMON_FORMAT_UE_TO_TABLES(...)                    *
    *                                                              *
    * SQL0443N                                                     *
    *                                                              *
    * $ db2 "select count(*) from lock_event"                      *
    *                                                              *
    *                                                              *
    *                                                              *
    * 1                                                            *
    *                                                              *
    * -----------                                                  *
    *                                                              *
    *           0                                                  *
    *                                                              *
    *                                                              *
    *                                                              *
    * After fix, EVMON_FORMAT_UE_TO_TABLES returned SQL443N,but    *
    *                                                              *
    * inserted record.                                             *
    *                                                              *
    *                                                              *
    *                                                              *
    * $ db2 call EVMON_FORMAT_UE_TO_TABLES(...)                    *
    *                                                              *
    * SQL0443N                                                     *
    *                                                              *
    * $ db2 "select count(*) from lock_event"                      *
    *                                                              *
    *                                                              *
    *                                                              *
    * 1                                                            *
    *                                                              *
    * -----------                                                  *
    *                                                              *
    *           1                                                  *
    ****************************************************************
    * 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

  • LOG_PARTIAL_EVENTS option don't apply to
    EVMON_FORMAT_UE_TO_TABLES.
    It only apply to EVMON_FORMAT_UE_TO_XML.
    So the only way to look at  the partial event is to use
    EVMON_FORMAT_UE_TO_XML with  LOG_PARTIAL_EVENTS option and
    format the separate XML document under sqllib/dump.
    There is no way to got those partial event into event table.
    It is a limitation for the EVMON_FORMAT_UE_TO_TABLES.
    

APAR Information

  • APAR number

    IC75525

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

  • Closed date

    2012-01-17

  • Last modified date

    2012-01-17

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

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

    IC91696

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7"}]

Document Information

Modified date:
18 September 2021