suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT26427 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem 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
 


Stacktrace in a trap file is as  follows:


sqlpCreateWakeUpList
sqpLoggwEdu::sqlpgwlp
sqpLoggwEdu::sqlpLoggwMain
sqpLoggwEdu::RunEDU
sqlzRunEDU
sqloEDUEntry
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Windows System                                               *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 V11.1 FP4                                     *
****************************************************************
Local Fix:
Solution
Workaround
 NONE
BUG-Tracking
forerunner  : 
follow-up : IT26754 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.09.2018
10.03.2019
10.03.2019
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)