IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 (FITDB) 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
    2021-03-19
    • 





    

  • 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


    








      
          
                    

          

          [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]
          

                    

        
        

        

      


      


        

            

            
Document Information


            

            


                        

            Modified date:
            

            20 March 2021
            

            
            
          

        


        

        


      


    


  





    

  



  
    
      

      
Page Feedback