IBM Support

IT34775: SQL STATEMENT CALLING NTILE FUNCTION FAILS WITH : -901 BAD DYN INDEX. IDX=4294967294 SIZE=87 (OFF=5)

Subscribe

You can track all active APARs for this component.

 

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