home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT08192 Status: Geschlossen

CRASH IN HASH JOIN UNION WHEN A QUERY IS INTERRUPTED - REGRESSION FIX FROM
IT03187

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The crash details might look  similar to following in the 
db2daig.log : 
 
015-03-17-19.44.05.665736-240 I60597975A1074     LEVEL: Error 
PID     : 7407                 TID  : 4397748709648PROC : 
db2sysc 0 
INSTANCE: db2inst1               NODE : 000         DB   : MYDB 
APPHDL  : 0-40439              APPID: <> 
AUTHID  :  <> 
EDUID   : 404                  EDUNAME: db2agntp (MYDB) 0 
FUNCTION: DB2 UDB, sort/list services, sqlsFetchNextTempRecord, 
probe:499 
MESSAGE : ZRC=0x80130003=-2146238461=SQLS_INTRP "Interrupt. 
User Cancel." 
          DIA8003C The interrupt  has been received. 
DATA #1 : Codepath, 8 bytes 
1 
DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes 
0x80130003 
DATA #3 : SQLS_MBUFS, PD_TYPE_SQLS_MBUFS, 1464 bytes 
 
.... 
 
2015-03-17-19.45.13.750990-240 I60607086A503      LEVEL: Severe 
PID     : 7407                 TID  : 4397786458384PROC : 
db2sysc 0 
INSTANCE: db2inst1               NODE : 000         DB   : MYDB 
APPHDL  : 0-40267              APPID: <> 
AUTHID  : <> 
EDUID   : 28                   EDUNAME: db2agent (MYDB) 0 
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, 
probe:10 
MESSAGE : DIA0505I Execution of a component signal handling 
function has begun. 
 
2015-03-17-19.45.13.751081-240 I60607590A229      LEVEL: Severe 
PID:7407 TID:4397786458384 NODE:000 Title: **** DRDA ASCB **** 
Dump File: 
<>/sqllib/db2dump/FODC_Trap_2015-03-17-19.45.13.635462_0000/7407 
.28.000.dump.bin 
 
 
The stack trace will have following functions : 
 
0x000003FFF97F9ECE _ZN11sqkfChannel15lockChannelArgsEPKci + 
0x0056 
                (/apps/mtdbp7/sqllib/lib64/libdb2e.so.1) 
0x000003FFF97F3FCA 
_ZN11sqkfChannel13ReceiveBufferEPP10sqkfBufferi + 0x009e 
                (/apps/mtdbp7/sqllib/lib64/libdb2e.so.1) 
0x000003FFF98301EA 
_Z8sqlkqrcvP7sqlkqcbP8sqeAgentPiPP10sqkfBufferS3_ + 0x0236 
                (/apps/mtdbp7/sqllib/lib64/libdb2e.so.1) 
0x000003FFF983B092 _Z8sqlktrcvP9sqlri_taoPi + 0x007a 
                (/apps/mtdbp7/sqllib/lib64/libdb2e.so.1) 
0x000003FFF983DDB4 
_Z18sqlkt_unpack_tupleP9sqlri_taoPiS1_P5sqlcaPjS4_ + 0x0660 
                (/apps/mtdbp7/sqllib/lib64/libdb2e.so.1) 
0x000003FFF98369E0 _Z8sqlktftcP8sqeAgentP9sqlri_taoP5sqlcaPjS5_ 
+ 0x0574 
                (/apps/mtdbp7/sqllib/lib64/libdb2e.so.1) 
0x000003FFFB0EC2E4 _Z8sqlritqaP8sqlrr_cb + 0x01c8 
                (/apps/mtdbp7/sqllib/lib64/libdb2e.so.1) 
0x000003FFFB13423E _Z9sqlrihsjnP8sqlrr_cb + 0x0842 
                (/apps/mtdbp7/sqllib/lib64/libdb2e.so.1) 
... 
 
If a query is interrupted while running  a plan similar to 
following  it  can cause similar  crash, 
                hsjn 
              / 
         union 
  +--------+--------+ 
blah 
 | 
 TQ 
 
This is  a regression from the  APAR IT03187 
 
INTRA_PARALLEL  have to be ON to hit this issue.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 11 or higher.                   * 
****************************************************************
Local-Fix:
Lösung
The problem is first fixed in DB2 V9.7 Fix Pack 11.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.04.2015
09.10.2015
09.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP11
Problem behoben lt. FixList in der Version
9.7.0.11 FixList