Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT10265 Status: Closed

Instance may trap when select and insert on a column organized table are
issued at the same time.

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
Instance may crash due to a small timing hole when SELECT and 
INSERT on a column organized table are issued at the same time. 
 
db2agntcol asserted with the following: 
2015-07-01-10.48.46.499958-420 I2525273E4048         LEVEL: 
Error 
PID     : 11013                TID : 46913298622784  KTID : 
26323 
PROC    : db2sysc 
INSTANCE: stevpear             NODE : 000            DB   : FRED 
APPHDL  : 0-22                 APPID: 
*LOCAL.stevpear.150701174417 
AUTHID  : STEVPEAR             HOSTNAME: zeeman 
EDUID   : 59                   EDUNAME: db2agntcol (FRED) 
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:549 
DATA #1 : String, 569 bytes 
AssertionFailedException: An assertion 
'pageIsInconsistentWithPMI == true' failed. Additional info: 
Unable to access target page from page map: 
   ExclusivePageAccess:      FALSE 
   mColumnGroupIndex:        2 
   pageReadCount:            120 
   mCurrentPageID:           65 
   pageDesc.mStartTSN:       5552 
   pageDesc.mEndTSN:         18446744073709551614 
   page.pgColGroupNumber:    2 
   page.pgStartTSN:          5563 
   currentTSN:               5552 
   mTableAccessor.tableName: T 
   page is inconsistent with PMI: 0 
Thrown at PageIteratorForTSNRange.cpp : 549
Problem Summary:
DB2AGNTCOL ASSERTED WITH "AN ASSERTION 'PAGEISINCONSISTENTWITHPM 
I == TRUE' FAILED. ADDITIONAL INFO: UNABLE TO ACCESS TARGET PAGE
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.07.2015
20.01.2016
17.08.2016
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.7 FixList