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 IC64337 Status: Geschlossen

MON_LW_THRESH CAN'T BE SET LARGER THAN 5000000

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Setting the monitoring lock wait threshold configuration 
parameter to a value greater than 5000000 microseconds results 
in the following error: 
 
db2 update db cfg using mon_lw_thresh using 6000000 
 
SQL5130N The value specified for the configuration parameter 
"mon_lw_thresh" is not in the valid range of "1000" to 
"5000000". 
 
The documented upper limit for this configuration parameter is 
MAX_INT.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* any                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* users wont be able to set MON_LW_THRESH larger than 5000000  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to latest fixpac                                     * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
MON_LW_THRESH can be set larger than 5000000
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.11.2009
29.04.2010
29.04.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.1 FixList