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