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 |