IBM Support

IT22631: DB2 MAY CRASH WHEN PROCESSING EXTENSIVE LIST OF TABLESPACES IN HISTORY FILE

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

  • The problem happens during processing of the history file for
tablespaces information, which goes beyond boundaries of the
allocated memory blocks.

Once this happens, DB2 may crash with following stack:

<StackTrace>
-------Frame------ ------Function + Offset------
0x090000000BBD998C sqlofmblkEx + 0xD4
0x090000000DCB2310 sqluhHandleFree__FPP12SQLUH_HANDLE + 0xD8
0x09000000094B12D0 sqluhClose__FPP12SQLUH_HANDLEb + 0x258
0x09000000089B9AC0 sqluhGetNextHistoryFileEntry + 0x568
0x090000000A84C588 sqlesrvr__FP14db2UCinterface + 0x259A8
0x090000000A87F3C0 sqlesrvr__FP14db2UCinterface + 0x628
0x090000000A87DEDC sqleMappingFnServer__FP5sqldaP5sqlca + 0x3D8
0x090000000A87D788
sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgentP5
sqlca + 0xEE0
0x090000000A85E914 sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo +
0x604
0x090000000C58D864
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x644
0x090000000C5768E0 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x11E4
0x090000000C5768E0 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x11E4
0x090000000C5764D4 @72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0xDD8
0x090000000D2E44E4
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
0x090000000D2E4FF8
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5FC
0x090000000CD3495C RunEDU__8sqeAgentFv + 0x40E1C
0x090000000CCA9738 RunEDU__8sqeAgentFv + 0x124
0x090000000BABEAE4 EDUDriver__9sqzEDUObjFv + 0x130
0x090000000B7502D4 sqloEDUEntry + 0x3A0
</StackTrace>

Local fix

  • N/A

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
****************************************************************

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT22631
    • 

  • 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
    2017-10-02
    • 

  • Closed date
    2018-03-19
    • 

  • Last modified date
    2018-03-19
    • 





    

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

    
IT20510
    

    • 

  • 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":"BU048","label":"IBM Software"},"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