IBM Support

IT26427: DB2 MAY CRASH WITH COREDUMP IF WINDOWS SYSTEM IS IN SHUTDOWN STATE DURING FETCH PROCESSING.

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

  • Db2 may crash with coredump (Linux/UNIX) or userdump (Windows)
under the following conditions in
federation environment.

- Error handling is needed internally when windows system is
shutdown.
- Continue fetching data after error received.

When encounter the issue, the following are reported in
db2diag.log


2018-0x-2x-1x.0x.3x.302000+540 I16995275242F1250    LEVEL: Error
PID     : 3210                 TID : 9876           PROC
:db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB  
:TESTDBB
APPHDL  : 0-xxxxx              APPID: APPL.SAMP1.D0123456789
AUTHID  : DB2ADMIN             HOSTNAME: TESTSERVER1
EDUID   : 9999                 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, mssql wrapper, Mssql_Server::get_error_info,
probe:7
MESSAGE : ODBC error txt:
DATA #1 : Hexdump, 142 bytes
0x00000163DE586A80 : 5B4D 6963 726F 736F 6674 5D5B 4F44 4243
[Microsoft][ODBC
0x00000163DE586A90 : 2053 514C 2053 6572 7665 7220 4472 6976 SQL
Server Driv
0x00000163DE586AA0 : 6572 5D5B 5351 4C20 5365 7276 6572 5D53
er][SQL Server]S
0x00000163DE586AB0 : 4855 5444 4F57 4E20 82AA 9069 8D73 9286
HUTDOWN ...i.s..
0x00000163DE586AC0 : 82C5 82B7 8142 0000 0000 0000 0000 0000
.....B..........
0x00000163DE586AD0 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x00000163DE586AE0 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x00000163DE586AF0 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x00000163DE586B00 : 0000 0000 0000 0000 0000 0000 0000
..............




2018-04-24-12.07.46.942000+540 I16995286076F624     LEVEL: Error
PID     : 3210                 TID : 9876           PROC :
db2syscs.exe
INSTANCE: DB2                  NODE : 000           DB   :
TESTDB
APPHDL  : 0-xxxxx              APPID: APPL.SAMP1.D0123456789
AUTHID  : DB2ADMIN             HOSTNAME:TESTSERVER1
EDUID   : 9999                 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:9
MESSAGE : Error in agent servicing application with PRODUCT
SIGNATURE:
DATA #1 : Hexdump, 8 bytes
0x00000163C314C5FC : 5153 5130 3730 3330
&#160;<Snipped>


Stacktrace in a trap file is as  follows:

<StackTrace>
sqlpCreateWakeUpList
sqpLoggwEdu::sqlpgwlp
sqpLoggwEdu::sqlpLoggwMain
sqpLoggwEdu::RunEDU
sqlzRunEDU
sqloEDUEntry
</StackTrace>

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Windows System                                               *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 V11.1 FP4                                     *
****************************************************************

    



Problem conclusion


    

  • FIRST FIXED IN V11 FP4

    



Temporary fix


    

  • &#160;NONE

    



Comments


    

  • 



APAR Information




    

  • APAR number
    IT26427
    • 

  • 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-09-26
    • 

  • Closed date
    2019-03-10
    • 

  • Last modified date
    2019-03-10
    • 





    

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

    • 

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

    
IT26754
    

    • 



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:
            

            10 March 2019
            

            
            
          

        


        

        


      


    


  





    

  



  
    
      

      
Page Feedback