home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC82225 Status: Geschlossen

CERTAIN TIME SPENT METRICS RETURNED BY MON_GET_BUFFERPOOL, MON_G
ET_CONTAINER, MON_GET_TABLESPACE AND SNAPSHOTS ARE INCORRECT

Produkt:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problembeschreibung:
The following metrics returned by MON_GET_BUFFERPOOL and the 
corresponding elements from snapshot monitor may be wrongly 
reported -- 
 
POOL_READ_TIME 
POOL_WRITE_TIME 
DIRECT_READ_TIME 
DIRECT_WRITE_TIME 
LOCK_WAIT_TIME_HIGH_WATERMARK (in statistics event monitor) 
 
Also, the following metrics reported by snapshot monitor and 
snapshot functions could be double the value of that reported by 
the new monitoring functions, namely, MON_GET_CONTAINER and 
MON_GET_TABLESPACE -- 
 
DIRECT_READ_TIME 
DIRECT_WRITE_TIME
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Recmmended to upgrade to DB2 for LUW v9.8 fixpack 5.         * 
****************************************************************
Local-Fix:
For the following metrics reported by MON_GET_BUFFERPOOL, divide 
the values by 2 before using them -- 
 
POOL_READ_TIME 
POOL_WRITE_TIME 
DIRECT_READ_TIME 
DIRECT_WRITE_TIME 
LOCK_WAIT_TIME_HIGH_WATERMARK (in statistics event monitor) 
 
For the following metrics reported by snapshots, consider either 
the values for the same metrics reported by MON_GET_CONTAINER 
and MON_GET_TABLESPACE, or divide the values by 2 before using 
them -- 
 
DIRECT_READ_TIME 
DIRECT_WRITE_TIME
Lösung
Fix available on DB2 for LUW v9.8 fixpack 5 onwards.
Workaround
NA
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.03.2012
17.06.2013
17.06.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.8.FP5
Problem behoben lt. FixList in der Version
9.8.0.5 FixList