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