|
Problem IT33218
|
Status: Closed |
DB2 SERVER TERMINATES ABNORMALLY IN THE SQLDFETCHLARGEROW FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
In rare circumstances, LOB data can be corrupted when a table is
populated by the LOAD utility when DB2_4K_DEVICE_SUPPORT=ON set.
The corruption can take one of two forms:
- "extended row" LOB data becomes corrupted. This is detectable
by Db2 and causes the abnormal termination.
- "normal" LOB data becomes corrupted. This is undetectable by
Db2.
The following stack will be generated when "extended row"
corruption is detected:
[0] 0x00007F762CCF476E
_ZN16sqeLocalDatabase15ForceDBShutdownEi + 0x18E
[1] 0x00007F7628198AA5
_Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi + 0x935
[2] 0x00007F762819A30A
_Z18sqldEndDumpBadPageP8sqeAgentP11SQLB_FIX_CBmiiii + 0x8A
[3] 0x00007F76281C7D59
_Z17sqldFetchLargeRowP13SQLD_DFM_WORKP13SQLDX_MINI_LDm + 0x2F9
[4] 0x00007F76281D7B0B _Z15sqldFetchRowExtP13SQLD_DFM_WORK +
0x31B
[5] 0x00007F76281CEF79 _Z12sqldReadNormP13SQLD_DFM_WORKl +
0x989
[6] 0x00007F76281D0501 /home/.../sqllib/lib64/libdb2e.so.1 +
0x2B71501
[7] 0x00007F76281D1DC8 _Z7sqldfrdP13SQLD_DFM_WORK + 0x4F8
[8] 0x00007F76281241FA
_Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RIDmP
12SQLD_ID_LISTP9SQLP_LSN8 + 0xFFA
The corruption can be detected by a SELECT query that reads the
corrupt row/column or a utility such as RUNSTATS that does the
same.
The corruption will not be detected by utilities that operate on
a page-by-page basis, such as BACKUP.
The corruption is unrecoverable and the affected table will need
to be recreated and repopulated. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Upgrade to Db2 version 11.5.4.0 or higher. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 version 11.5.4.0 or higher. *
**************************************************************** |
| Local Fix: |
The corruption can be prevented, but not reversed, by any of the
following:
- Disable the use of DB2_4K_DEVICE_SUPPORT if not strictly
required for the environment.
- Use LOAD with the "DISK_PARALLELISM 1" option.
- Use INSERT or INGEST instead of LOAD. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.06.2020
30.06.2020
30.06.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
