Fixes are available
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
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 program error.
Error description
SELECT referencing SYSCAT.INDEX of a federated object might hang/crash with SQL0901N. -------Stack-------- 0x090000000057EF14 pthread_kill + 0xD4 0x0900000040D15FFC sqloDumpEDU + 0x9C 0x0900000041943630 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 0x150 0x0900000042C59334 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x914 0x0900000040E741B8 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x158 0x0900000040E73C9C sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 0x27C 0x0900000040E7078C sqlrrSqlCode + 0x18C 0x0900000043397978 sqlrlc_request_ulock__FP8sqlrr_cbP19sqlrlc_entry_commonP20sqlrlc _anchor_commonPbUiN25PUiP14SQLP_LOCK_INFOT9T8 + 0x1D8 0x0900000043396EE4 sqlrlc_find_request_usage_lock__FP8sqlrr_cbP10sqlrlc_keyUiN23PP1 9sqlrlc_entry_commonPUiP14SQLP_LOCK_INFOT8 + 0x664 0x090000004592F82C sqlrlc_fed_fetch__FP8sqlrr_cbPUcUsT2T3T2T3UiN28P13SQLO_MEM_POOLP 14SQLP_LOCK_INFOP21sqlrlc_systables_info + 0x3AC 0x090000004592D7E4 sqlnq_cat_look2__FCP20sqlnq_multipart_nameCPP9sqlnq_ftbP3loc21sq lnq_hierarchy_usageCbCPCUiP12sqlnq_stringT5 + 0x4F04 0x090000004592756C sqlnq_cat_look__FCP20sqlnq_multipart_nameCPP9sqlnq_ftbP3loc21sql nq_hierarchy_usageCbCPCUiP12sqlnq_stringT5 + 0x2EC 0x090000004386B1F4 sqlnq_handle_qtb_extref_rec__F20sqlnq_multipart_namePP9sqlnq_qtb iP3loc21sqlnq_hierarchy_usageP9sqlnq_pid + 0x114 0x090000004386EA0C IPRA.$sqlnq_handle_named_ref__F20sqlnq_multipart_nameiP9sqlnq_qt bP9sqlnq_oprT2PP9sqlnq_qtbPP9sqlnq_qunPP9sqlnq_qncPP9sqlnq_pidT6 Pi21sqlnq_hierarchy_usageP9sqlnq_pid + 0x4EC 0x090000004386EDB8 IPRA.$sqlnq_handle_named_ref__F20sqlnq_multipart_nameiP9sqlnq_qt bP9sqlnq_oprT2PP9sqlnq_qtbPP9sqlnq_qunPP9sqlnq_qncPP9sqlnq_pidT6 Pi21sqlnq_hierarchy_usageP9sqlnq_pid + 0x898 0x090000004386EDB8 IPRA.$sqlnq_handle_named_ref__F20sqlnq_multipart_nameiP9sqlnq_qt bP9sqlnq_oprT2PP9sqlnq_qtbPP9sqlnq_qunPP9sqlnq_qncPP9sqlnq_pidT6 Pi21sqlnq_hierarchy_usageP9sqlnq_pid + 0x898 0x090000004386D81C sqlnq_handle_named_ref_in_src__FP12sqlnq_stringiPP9sqlnq_qtbPP9s qlnq_qunPP9sqlnq_qncPP9sqlnq_pidP3loc21sqlnq_hierarchy_usageP20s qlnq_multipart_nameP9sqlnq_pid + 0x2FC 0x09000000442157DC sqlnq_handle_table_ref__FP20sqlnq_multipart_namePP9sqlnq_qunP9sq lnq_qtbP3locP9sqlnq_opr21sqlnq_hierarchy_usageP9sqlnq_pid + 0xADC 0x09000000442143F8 sqlnq_handle_from_table_ref__FP20sqlnq_multipart_namePUciPP9sqln q_qunP9sqlnq_qtbP3locP9sqlnq_opr21sqlnq_hierarchy_usagePP8stknod e_ + 0xF8 0x090000004430B0F0 sqlnq_sem__FPP8stknode_i10actiontypePUcP3loc + 0x7D70 0x0900000044C7CFE4 sqlnp_smactn__FP8sqlnp_cbi + 0x424 0x0900000044C74ED0 sqlnp_parser__FP8sqlnp_cb + 0x3D0 0x0900000045D5C5A8 sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0xDA8 0x090000004571B174 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_enviT7PP9sqlnq_qur + 0x8194 ... ------------
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Fixpack 3 Mod 2 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Fixpack 3 Mod 2
Temporary fix
Comments
APAR Information
APAR number
IT25783
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-07-23
Closed date
2018-08-07
Last modified date
2018-08-07
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
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