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

DB2 ABENDS WITH SIGNAL 11 WHEN RUNNING "TRANSFER OWNERSHIP OF TABLE
HIERARCHY" STATEMENT WHERE THE TABLE IS A REGULAR TABLE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
DB2 abends with signal 11 when "transfer ownership of table 
hierarchy" statement is run on a regular table. 
 
 
The stack trace of the failing process looks like this: 
 
6        sqlrlTransferHierarchy 
7        sqlrlTransferObject 
8        sqlnq_transfer_ownership_end 
9        sqlnq_transfer_ownership_stmt 
10       sqlnp_parser 
11       sqlnp_main 
12       sqlnn_cmpl 
13       sqlnn_cmpl 
14       sqlra_compile_var 
15       sqlra_find_var 
16       sqlra_get_var 
17       sqlri_ddl_get_section 
18       sqlri_ddl_common 
19       sqlriddl 
20       sqlriSectInvoke 
21       sqlrr_execute_immediate 
22       sqlrr_execimmd 
23       sqljs_ddm_excsqlimm 
24       sqljsParseRdbAccessed 
25       sqljsParse 
26       DWinfo20586 
27       DWinfo20542 
28       DWinfo19932 
29       sqljsDrdaAsDriver 
30       sqeAgent::RunEDU 
31       sqzEDUObj::EDUDriver 
32       sqlzRunEDU 
33       sqloEDUEntry 
34       start_thread 
35       __clone
Problem-Zusammenfassung:
DB2 ABENDS WITH SIGNAL 11 WHEN RUNNING "TRANSFER OWNERSHIP OF 
TABLE HIERARCHY" STATEMENT WHERE THE TABLE IS A REGULAR TABLE
Local-Fix:
1. Ensure that the table is a hierarchy table 
 
or 
 
2. Run "TRANSFER OWNERSHIP OF TABLE <tabname>" instead if the 
target is a regular table.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
It is fixed in DB2 V9.7 FP2
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.12.2009
06.07.2010
06.07.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList