IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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":"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:
03 May 2022