Fixes are available
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows
APAR status
Closed as fixed if next.
Error description
SELECT referencing SYSCAT.TABLES of replication-maintained MQT might hang/crash with SQL0901N Stack: 0x090000000055AF14 pthread_kill + 0xD4 0x0900000008AEDB7C sqloDumpEDU + 0x9C 0x0900000009711550 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x150 0x090000000AA1702C sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x90C 0x0900000008C4AB38 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x158 0x0900000008C4A61C sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 0x27C 0x0900000008C4710C sqlrrSqlCode + 0x18C 0x090000000B146A78 sqlrlc_request_ulock__FP8sqlrr_cbP19sqlrlc_entry_commonP20sqlrlc _anchor_commonPbUiN25PUiP14SQLP_LOCK_INFOT9T8 + 0x1D8 0x090000000B145FE4 sqlrlc_find_request_usage_lock__FP8sqlrr_cbP10sqlrlc_keyUiN23PP1 9sqlrlc_entry_commonPUiP14SQLP_LOCK_INFOT8 + 0x664 0x090000000B140E20 sqlrlc_systables_fetch__FP8sqlrr_cbPUcUsT2T3UiN26P13SQLO_MEM_POO LP14SQLP_LOCK_INFOP21sqlrlc_systables_info + 0x9E0 0x090000000DB83ACC sqlrlGetReplMQTRefreshTimestamp__FP8sqlrr_cbPbPUc + 0x20C 0x0900000009C99ECC sqlra_check_mqt_replication_latency__FP8sqlrr_cbPCUcPb + 0x3AC 0x0900000009C9517C sqlra_find_var_var__FP8sqlrr_cbP17sqlra_cached_stmtPP16sqlra_cac hed_envP14sqlra_cmpl_envUiiT615sqlra_fill_modePiT6N29P14SQLP_ LOCK_INFOT13_PP16sqlra_cached_varN49bT20_PUiT22_ + 0x4D9C 0x0900000009C9C8E8 sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_ P14SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0x848 0x090000000AD59194 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xBF4 0x090000000A4B6E94 IPRA.$sqlrr_process_open_request__FP8sqlrr_cbPbPUlP15db2UCCursor InfoT2 + 0x3594 0x090000000A4AF388 sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x4A8 0x090000000F8A1BC0 sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x4C0 0x090000000F8405F8 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x298 0x090000000F843650 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x2250 0x090000000F80FACC IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xEAC 0x090000000F818594 sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4 0x090000000F80DB70 IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0 0x090000000F80AFB4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x334 0x0900000008C14DA0 RunEDU__8sqeAgentFv + 0xB60 0x0900000008BF78A0 EDUDriver__9sqzEDUObjFv + 0x2E0 0x0900000008AE7814 sqloEDUEntry + 0x374
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1fp5 or later * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT26054
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-08-22
Closed date
2019-01-21
Last modified date
2019-01-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022