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

EXCESSIVE LOCK TIMEOUT MESSAGE MAY BE LOGGED IN DB2DIAG.LOG WITH ERROR
LEVEL

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
You may see the following messages being logged in the 
db2diag.log, but these are only informational. 
 
Snippet of db2diag.log: 
 
2010-09-07-15.57.24.522944-240 I828017A551        LEVEL: Error 
PID    : 29536                TID  : 44          PROC : db2sysc 
0 
INSTANCE: db2lr1              NODE : 000        DB  : LR1 
APPHDL  : 0-45621              APPID: *LOCAL.db2lr1.100907195426 
AUTHID  : DB2LR1 
EDUID  : 44                  EDUNAME: db2agent (LR1) 0 
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::fetch, 
probe:40 
RETCODE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT 
          "LockTimeOut - tran rollback Reason code 68" 
DATA #1 : Hex integer, 4 bytes 
0x0000000D 
 
2010-09-07-15.57.24.523547-240 I828569A510        LEVEL: Error 
PID    : 29536                TID  : 44          PROC : db2sysc 
0 
INSTANCE: db2lr1              NODE : 000        DB  : LR1 
APPHDL  : 0-45621              APPID: *LOCAL.db2lr1.100907195426 
AUTHID  : DB2LR1 
EDUID  : 44                  EDUNAME: db2agent (LR1) 0 
FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, 
probe:70 
RETCODE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT 
          "LockTimeOut - tran rollback Reason code 68"
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 Version 9.5 GA through to Fix Pack 6 servers on Linux,   * 
* Unix and Windows platforms.                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Excessive lock timeout messages dump to db2diag.log in error * 
* level.                                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 Version 9.5 Fix Pack 7.                            * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 9.5 Fix Pack 7 and all subsequent Fix 
Packs.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.09.2010
15.11.2010
15.11.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP7
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList