|
Problem IC63005
|
Status: Closed |
COMPRESSED ROWS IN THE TABLE AND NO DICTIONARY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Fixed in V97 FP1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.09.2009
15.12.2009
15.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.7.001,
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
