|
Problem IC95234
|
Status: Geschlossen |
NEGATIVE NUMBER IS RETURNED FOR PROCESSING TIME OR WAIT TIME COUNTER FROM MON_GET TABLE FUNCTION |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users on DB2 V10.5 FP 2 and lower *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local-Fix: |
No Local Fix |
| verfügbare FixPacks: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
Problem Fixed In 10.5.0.3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.08.2013
03.03.2014
03.03.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
