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 IT02983 Status: Geschlossen

INSTANCE CRASH WHEN RUNSTATS ON TEMPORARY TABLE AND INDEX NAME OMITS SCHEMA
NAME

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
If a runstats is invoked against a user temporary table and the 
index clause explicitly specifies index names but omits the 
index schema name, i.e. index name is not fully-qualified, the 
instance crashes with a signal 11. 
 
db2diag.log entry indicates that a db2sysc process is brought 
down with a signal 11 (0x0B) 
 
e.g. 
 
2014-06-27-03.24.55.682213-240 E492764A469          LEVEL: Error 
PID     : 7930224              TID : 258            PROC : 
db2wdog 3 [db2inst1] 
INSTANCE: db2inst1               NODE : 003 
HOSTNAME: hostname 
EDUID   : 258                  EDUNAME: db2wdog 3 [db2inst1] 
FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:8117 
DATA #1 : Process ID, 4 bytes 
9437226 
DATA #2 : Hexdump, 8 bytes 
0x0A000000003FDD80 : 0000 0101 0000 000B 
........ 
 
 
The stack becomes corrupted, and no FODC_Trap is generated. A 
core dump is generated, and db2sysc trapped in function strncpy 
(called by sqlrLocalRunstats). 
 
This problem exists only in v10.1; v9.7 and previous releases 
require fully-qualified index names in the index clause of the 
runstats command.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to v10.1 Fix Pack 5.                                  * 
****************************************************************
Local-Fix:
Modify the runstats command to use fully-qualified index names.
Lösung
Fixed in v10.1 Fix Pack 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.07.2014
15.07.2015
15.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList