IC90979: NEGATIVE NUMBER IS RETURNED FOR PROCESSING TIME OR WAIT TIME COUNTER FROM MON_GET TABLE FUNCTION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • On highly OLTP environments it is possible for a counter for the
    number of processing times or wait times to become negative.
    
    For example, the following query could return a negative value
    on highly OLTP environments:
    
    db2 "select TOTAL_APP_SECTION_EXECUTIONS from
    table(mon_get_workload(NULL,-1)) as T where workload_name like
    '%USER%' "
    
    TOTAL_APP_SECTION_EXECUTIONS
    ----------------------------
                     -7058505513
    
    This can occur with the following table functions:
    MON_GET_CONNECTION
    MON_GET_PKG_CACHE_STMT
    MON_GET_SERVICE_SUBCLASS
    MON_GET_UNIT_OF_WORK
    MON_GET_WORKLOAD
    
    
    When the counter is returned by a table function that returns an
    XML document, the counter is defined to be a
    "xs:nonNegativeInteger".  In this case the value can become a
    massive value rather than a negative value.   For example, the
    IPC_RECVS_TOTAL counter reported by MON_GET_CONNECTION_DETAILS
    is "18446744072615334103".
    
    This can occur with the following table functions:
    MON_GET_ACTIVITY_DETAILS
    MON_GET_CONNECTION_DETAILS
    MON_GET_PKG_CACHE_STMT_DETAILS
    MON_GET_SERVICE_SUBCLASS_DETAILS
    MON_GET_UNIT_OF_WORK_DETAILS
    MON_GET_WORKLOAD_DETAILS
    
    
    The following counters are susceptible to this issue:
    
    agent_waits_total
    audit_file_writes_total
    audit_subsystem_waits_total
    diaglog_writes_total
    direct_read_reqs
    direct_write_reqs
    ida_recvs_total
    ida_sends_total
    ipc_recvs_total
    ipc_sends_total
    lock_waits
    log_disk_waits_total
    num_log_buffer_full
    tcpip_recvs_total
    tcpip_sends_total
    total_app_commits
    total_app_rollbacks
    total_app_section_executions
    total_compilations
    total_implicit_compilations
    total_loads
    total_reorgs
    total_runstats
    total_section_sorts
    wlm_queue_assignments_total
    

Local fix

  • No Local Fix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users on DB2 V97 FP8 and lower                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V97 FP9                                       *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 V97 FP9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90979

  • 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

    2013-03-20

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

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

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

    IC91440 IC95234

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • 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 #:

IC90979

Modified date:

2013-12-17

Translate my page

Machine Translation

Content navigation