IBM Support

IT23812: INSTANCE TRAP IS POSSIBLE WHEN QUERY AGAINST COLUMN ORGANIZED TABLES WITH OLAP SPECIFICATION IS RUN

Fixes are available

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • IF QUERY WITH OLAP SPECIFICATION IS RUN AGAINST COLUMN ORGANIZED
TABLES INSTANCE COULD TRAP WITH THE FOLLOWING STACK:

sqloEDUCodeTrapHandler
__intel_ssse3_rep_memcpy
ibm_cde8services20SpillableWriteCursor10writeChunk
ibm_cde5query14SpillableDequeINS0_8WorkUnit
ibm_cde5query13OlapEvaluator24manageWorkUnitPoolMemory
ibm_cde5query27LookaheadEvaluatorBaseClassINS_5types7DecimalES3_
S3_S3_Lb0EE13mainOperation
ibm_cde5query13OlapEvaluator26processInputsSynchronously
ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartStateE
PNS0_19OptPredicateTracker
ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_data
ibm_cde5query9Scheduler13evaluateChainEPNS0_17EvaluationRoutine
ibm_cde5query9Scheduler15runWorkerThread

Local fix

  • turn off OLAP in COLUMNAR ORGANIZED logic:

db2set DB2_REDUCED_OPTIMIZATION=COL_NO_OLAP

The pans will move OLAP logic above CTQ lolepop.

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* Columnar organized tables and OLAP specifications            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description.                                       *
****************************************************************
* RECOMMENDATION:                                              *
* Please, install this fix.                                    *
****************************************************************

Problem conclusion

  • See Error Description.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT23812
    • 

  • 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-01-23
    • 

  • Closed date
    2018-03-19
    • 

  • Last modified date
    2018-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


    

  • RB10  PSN
       UP
    • 








      
          
                    

          

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

                    

        
        

        

      


      


        

            

            
Document Information


            

            


                        

            Modified date:
            

            19 March 2018
            

            
            
          

        


        

        


      


    


  





    

  



  
    
      

      
Page Feedback