Fixes are available
APAR status
Closed as program error.
Error description
The following error is logged into db2diag.log when SQL statement calling NTILE function fails with -901 : 2019-10-29-01.36.58.937361-240 I198590552A912 LEVEL: Severe PID : 21430464 TID : 118528 PROC : db2sysc 1 INSTANCE: xxxxx NODE : 001 DB : xxxx APPHDL : 1-7964 APPID:xxxx THID : xxxxxxxx HOSTNAME: xxxxxxxx EDUID : 118528 EDUNAME: db2agent (SAMPLE) 1 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 46 sqlerrmc: Bad dyn index. idx=4294967294 size=87 (off=5) sqlerrp : SQLNG0C4 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000043 (5) 0xFFFFEEEA (6) 0x00000001 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) FODC_AppErr folder is generated in the DB2DUMP and the stack agent reports the following functions calls : -------Frame------ ------Function + Offset------ 0x0900000000582F94 pthread_kill + 0xD4 0x090000000F9722FC sqloDumpEDU + 0x9C 0x090000000FAE807C sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x11C 0x090000000FAE7B9C sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 0x27C 0x090000001184DC90 sqlnn_erds__FiN41e + 0x110 0x0900000011865A08 sqlngMemBlockLookup__FP9sqlng_blkPvUlRP15sqlngSectObject + 0x888 0x0900000011864A88 sqlngSectResolveDeps__FP9sqlng_blkUl + 0xCC8 0x0900000015EBB238 sqlngSectOptimize__FP9sqlng_blk + 0x78 0x09000000158AE8B0 sqlng_main__FP9sqlnq_qur + 0x2E90 0x0900000013231D64 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_enviT7PP9sqlnq_qur + 0x6004 0x090000001322BCE8 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_env + 0x28 0x09000000151E8CE4 sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0xBE4 0x09000000106E05E4 sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14 SQL P_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0xA84
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See error description * **************************************************************** * RECOMMENDATION: * * None * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT34775
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
2020-11-04
Closed date
2021-03-19
Last modified date
2022-04-03
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:
03 May 2022