IBM Support

IT27969: SQL0901N MIGHT OCCUR WITH QUERIES CONTAINING CASCADED SELECTS AND THE SAME LOCAL PREDICATES ON THESE SELECTS

A fix is available

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible in next release.

Error description

  • SQL901N error - "Parent entity not provided" might be observed
when running a query with the following characteristics:
1. The query contains cascaded selects
2. The same local predicate is applied on some of these cascaded
selects including at least the select from a base table and a
select at the higher cascaded level
3. This local predicate references a timestamp constant

<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007F9F5A7AFCA6
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356
		(/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F9F5A7AF8EB ossDumpStackTraceV98 + 0x002b
		(/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F9F5A7ABAD7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
		(/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F9F62013187 sqlo_trce + 0x03c7
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F6217EC0B sqloDumpDiagInfoHandler + 0x020b
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F69D14680 address: 0x00007F9F69D14680 ; dladdress:
0x00007F9F69D05000 ; offset in lib: 0x000000000000F680 ;
		(/lib64/libpthread.so.0)
0x00007F9F69D119B1 pthread_kill + 0x0031
		(/lib64/libpthread.so.0)
0x00007F9F6217E7C2 sqloDumpEDU + 0x0052
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F5CE211DE _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi +
0x129e
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F627CED95 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x0695
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F63C55C17 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x00a7

		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F63C55A39
_Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag + 0x0199
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F60FFE492 _Z10sqlnn_erdsiiiiiz + 0x0172
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61C9B618
_ZN9sqlnq_prd16createPushedPathEP9sqlnq_qunP3loc + 0x0248
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61C80A82 address: 0x00007F9F61C80A82 ; dladdress:
0x00007F9F5AD09000 ; offset in lib: 0x0000000006F77A82 ;
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61C7FE51
_Z23sqlnr_localmagic_actionP10sqlnr_qrwaPiP14sqlnr_progress +
0x0041
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D38EB5
_Z10sqlnr_compPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progre
ss + 0x0225
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D38BAA
_Z9sqlnr_seqPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0x009a
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D388EF _Z9sqlnr_rcciP10sqlnr_qrwaPiP14sqlnr_progress
+ 0x028f
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61C7FC28
_Z25sqlnr_magic_detail_actionP10sqlnr_qrwaPiP14sqlnr_progress +
0x0038
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D38EB5
_Z10sqlnr_compPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progre
ss + 0x0225
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D38BAA
_Z9sqlnr_seqPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0x009a
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D388EF _Z9sqlnr_rcciP10sqlnr_qrwaPiP14sqlnr_progress
+ 0x028f
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61C5281B
_Z19sqlnr_endqtb_actionP10sqlnr_qrwaPiP14sqlnr_progress + 0x004b

		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D38EB5
_Z10sqlnr_compPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progre
ss + 0x0225
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D38BAA
_Z9sqlnr_seqPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0x009a
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D388EF _Z9sqlnr_rcciP10sqlnr_qrwaPiP14sqlnr_progress
+ 0x028f
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61C52305
_Z18sqlnr_start_actionP10sqlnr_qrwaPiP14sqlnr_progress + 0x0125
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D38EB5
_Z10sqlnr_compPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progre
ss + 0x0225
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D38BAA
_Z9sqlnr_seqPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass +
0x009a
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61D388EF _Z9sqlnr_rcciP10sqlnr_qrwaPiP14sqlnr_progress
+ 0x028f
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61B593B1 _Z9sqlnr_exeP9sqlnq_qur + 0x09b1
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F6100810F
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_enviiPP9sqlnq_qur + 0x70bf
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F61001041
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_env + 0x0021
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F62A8FDCE
_Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP
_LOCK_INFOP16sqlra_cached_varPiS5_Pb + 0x10ee
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F62AACCD6
_Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj
jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK
_INFOPP16sqlra_cached_varS8_bSA_Pb + 0x0966
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F62B4DF0F _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x0f3f
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F627DC845
_Z13sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo + 0x0455
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F60921FF7
_Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject +
0x0407
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F60911D6B
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x00eb
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F60912E4E
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x054e
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F60905D2D address: 0x00007F9F60905D2D ; dladdress:
0x00007F9F5AD09000 ; offset in lib: 0x0000000005BFCD2D ;
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F6090C313 address: 0x00007F9F6090C313 ; dladdress:
0x00007F9F5AD09000 ; offset in lib: 0x0000000005C03313 ;
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F6090CFCF _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
0x011f
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F603369E3 _ZN8sqeAgent6RunEDUEv + 0x0de3
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F63C5621E _ZN9sqzEDUObj9EDUDriverEv + 0x01be
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F6217C6BA sqloEDUEntry + 0x057a
		(/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F9F69D0CDD5 address: 0x00007F9F69D0CDD5 ; dladdress:
0x00007F9F69D05000 ; offset in lib: 0x0000000000007DD5 ;
		(/lib64/libpthread.so.0)
0x00007F9F597B8B3D clone + 0x006d
		(/lib64/libc.so.6)
</StackTrace>

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Db2 users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to latest fix pack                                   *
****************************************************************

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT27969
    • 

  • Reported component name
    DB2 FOR LUW
    • 

  • Reported component ID
    DB2FORLUW
    • 

  • Reported release
    B10
    • 

  • Status
    CLOSED  UR1
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2019-02-03
    • 

  • Closed date
    2022-03-10
    • 

  • Last modified date
    2022-03-10
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    
IT38111
    

    • 



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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback