DB2 - Problembeschreibung
Problem IC73936 | Status: Geschlossen |
SEVERE SQLDREADTABLEINFO DB2DIAG.LOG FOR INTERRUPTED QUERY. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
After a query was interrupted, the db2diag.log may report : 2011-01-13-04.40.25.716609+000 I1286353A7696 LEVEL: Severe PID : 29229284 TID : 22296 PROC : db2sysc 2 INSTANCE: db2inst1 NODE : 002 DB : SAMPLE APPHDL : 0-19566 APPID: 9.122.128.160.57849.101213022 AUTHID : db2inst1 EDUID : 22296 EDUNAME: db2agntp (SAMPLE) 2 FUNCTION: DB2 UDB, data management, sqldReadTableInfo, probe:10089 MESSAGE : Fail positioning record within the page DATA #1 : Hexdump, 1424 bytes 0x0700000115BFC720 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0700000115BFC730 : 0000 0000 2010 0000 0000 0000 0000 0000 .... ........... 0x0700000115BFC740 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0700000115BFC750 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ ... The message is misleading as it does not indicate a serious problem and only appears if a statement is accessing a table and is interrupted whilst doing so. The problem is timing dependent and should not be seen very regularly. The db2diag.log message is the only symptom, as the interrupt is further handled correctly. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * Misleading and incorrect severe error message raised in the * * db2diag.log coming from function SQLDREADTABLEINFO * **************************************************************** * RECOMMENDATION: * * Upgrade DB2 to V9.7 fixpak 4 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
This problem was first fixed in V9.7 Fixpak 4 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.01.2011 24.05.2011 24.05.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7. | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |