|
Problem IC65080
|
Status: Closed |
DB2 ABENDS WITH SIGNAL 11 WHEN RUNNING "TRANSFER OWNERSHIP OF TABLE HIERARCHY" STATEMENT WHERE THE TABLE IS A REGULAR TABLE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
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. |
| available fix packs: |
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
|
| Solution |
It is fixed in DB2 V9.7 FP2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.12.2009
06.07.2010
06.07.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
