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

PACKED DESCRIPTOR OF A RANGE PARTITION TABLE CAN GET CORRUPTED WHEN
ATTACHING A PARTITION.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The packed descriptor of a Range Partition Table can get 
corrupted when attaching a partition, if the target table 
column(s) have statistics collected, and does not have default 
values defined on its column(s); but the source column(s) 
has/had default values. (The corruption is confined to a wrong 
stats_offset for the column packed descriptor) 
 
In DPF environment, the -901 trap happens during the attach: 
 
alter table t2 attach partition t1p0 starting from (0) ending at 
(9) from table t1p0 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Packed 
descriptor 
corruption found. Please run RUNSTATS on this table".) 
SQLSTATE=58004 
 
In non-DPF environment, the -901 trap happens during set 
integrity: 
 
set integrity for t2 immediate checked 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "Packed 
descriptor 
corruption found. Please run RUNSTATS on this table".) 
SQLSTATE=58004 
 
The top of stack looks like this: 
Stack #1             Signal #12        Timestamp 
2014-04-28-05.22.20.930414 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        sqlo_trce 
3        sqloDumpDiagInfoHandler 
4        __restore_rt 
5        pthread_kill 
6        sqloDumpEDU 
7        sqldDumpContext 
8        sqlrr_dump_ffdc 
9        sqlzeDumpFFDC 
10       sqlzeSqlCode 
11       sqlrrSqlCode 
12       sqlrlc_systables_fetch_from_disk 
13       sqlrlc_systables_load_entry 
14       sqlrlc_load_entry 
15       sqlrlc_request_ulock 
16       sqlrlc_find_request_usage_lock 
17       sqlrlc_systables_fetch
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 9.7 Fix Pack 10                                * 
****************************************************************
Local-Fix:
Lösung
Fixed in DB2 9.7 Fix Pack 10
Workaround
No Local Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.05.2014
01.12.2014
01.12.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList