|
Problem IC63005
|
Status: Geschlossen |
COMPRESSED ROWS IN THE TABLE AND NO DICTIONARY |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
There is the potential that a table can exist with compressed
rows and no dictionary.
At the point in time when a dictionary is being created and
inserted into a table, it is possible that the dictionary could
be used immediately by other applications yet if an error occurs
in the dictionary insertion thread the dictionary insertion
could still be rolled back removing the new dictionary. This
could result in some compressed rows in the table that do not
have a dictionary to uncompress the rows with. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* An Error encountered during automatic dictionary creation, *
* followed by possibly this message when trying to access the *
* table: *
* *
* SQL1224N The database manager is not able to accept new *
* requests, has *
* terminated all requests in progress, or has terminated the *
* specified request *
* because of an error or a forced interrupt. SQLSTATE=55032 *
* *
* Possible db2diag.log message.. *
* 2009-08-25-13.43.44.443001-240 I114992E488 LEVEL: *
* Warning *
* PID : 31820 TID : 47100679153984PROC : *
* db2sysc *
* INSTANCE: simap NODE : 000 DB : *
* SPDB *
* APPHDL : 0-7 APPID: *
* *LOCAL.simap.090825174329 *
* AUTHID : SIMAP *
* EDUID : 16 EDUNAME: db2agent (SPDB) *
* FUNCTION: DB2 UDB, RAS/PD component, *
* pdEDUIsInDB2KernelOperation, probe:600 *
* DATA #1 : String, 18 bytes *
* _Z13sqldExpandRec *
* DATA #2 : String, 4 bytes *
* sqld *
* *
* Possible stack trace.. *
* <StackTrace> *
* ---FUNC-ADDR---- ------FUNCTION + OFFSET------ *
* 00002AD666467139 ossDumpStackTraceEx + 0x01e5 *
* (/home/hotel50/simap/sqllib/lib64/libdb2osse.so.1) *
* 00002AD666461F5A _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + *
* 0x00cc *
* (/home/hotel50/simap/sqllib/lib64/libdb2osse.so.1) *
* 00002AD6638651B1 sqlo_trce + 0x02eb *
* (/home/hotel50/simap/sqllib/lib64/libdb2e.so.1) *
* 00002AD6638A6A59 sqloEDUCodeTrapHandler + 0x0167 *
* (/home/hotel50/simap/sqllib/lib64/libdb2e.so.1) *
* 00002AD6611ACC10 address: 0x00002AD6611ACC10 ; dladdress: *
* 0x00002AD66119F000 ; offset in lib: 0x000000000000DC10 ; *
* (/lib64/libpthread.so.0) *
* 00002AD662C242AB *
* _Z13sqldExpandRecP8sqeAgentP8SQLD_TCBP18SQLD_TCB_DICT_INFOmP13
* + 0x00f3 *
* (/home/hotel50/simap/sqllib/lib64/libdb2e.so.1) *
* 00002AD661FF7DF4 _Z20sqldExpandAndSetupWAP13SQLD_DFM_WORK + *
* 0x0056 *
* (/home/hotel50/simap/sqllib/lib64/libdb2e.so.1) *
* 00002AD66200649D _Z12sqldReadNormP13SQLD_DFM_WORKl + 0x1bb1 *
* (/home/hotel50/simap/sqllib/lib64/libdb2e.so.1) *
* 00002AD6645024BD address: 0x00002AD6645024BD ; dladdress: *
* 0x00002AD6612B6000 ; offset in lib: 0x000000000324C4BD ; *
* (/home/hotel50/simap/sqllib/lib64/libdb2e.so.1) *
* 00002AD664501613 _Z7sqldfrdP13SQLD_DFM_WORK + 0x05db *
* (/home/hotel50/simap/sqllib/lib64/libdb2e.so.1) *
* 00002AD6644F69FA *
* _Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RID
* + 0x0faa *
* (/home/hotel50/simap/sqllib/lib64/libdb2e.so.1) *
* .. etc. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V97 version 9.07.001 *
**************************************************************** |
| Local-Fix: |
Whenever a dictionary is being created be sure that no other
users are adding rows to the table. The 'ALLOW WRITE ACCESS'
option on the IMPORT command should be avoided if the dictionary
has not yet been created on the target table. |
| 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 6 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 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 |
Fixed in V97 FP1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 05.09.2009
15.12.2009
15.12.2009 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.,
9.7.7.001,
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
