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

ADMIN_MOVE_TABLE AND DB2CONVERT FAIL WITH SQL2105N (REASON CODE 10) IF THE
TABLE HAS CLUSTER INDEX

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
When using ADMIN_MOVE_TABLE procedure or db2convert utility to 
convert the row-organized table which has cluster index into 
column-organized table, SQL2105N (reason code 10) is returned. 
For example, 
 
create table tab2( c1 char(8) not null, c2 int, c3 char(8) not 
null, c4 int, c5  int) organize by row; 
create unique index c2_indx on tab2(c1 ASC, c3 ASC) PCTFREE 20 
CLUSTER COMPRESS NO ALLOW REVERSE SCANS; 
 
db2convert -d testdb -z db2inst1 -t tab2 -force -opt 
'FORCE,NEW_STATS,REVAL_ALL_OBJECTS' -trace 
 
[SNIPPED] 
 
Table                                   RowsNum         RowsComm 
Status          Progress (%) 
--------------------------------------- --------------- 
--------------- --------------- --------------- 
"DB2INST1"."TAB2"                       0               0 
COPY            Failed 
 
**************************************************************** 
************************************************* 
 Errors: 
**************************************************************** 
************************************************* 
 
---ADMIN_MOVE_TABLE failed for table "DB2INST1"."TAB2" with 
error message below--- 
 CALL 
SYSPROC.ADMIN_MOVE_TABLE('DB2INST1','TAB2','','','','ORGANIZE BY 
COLUMN','','-','','FORCE,NEW_STATS,REVAL_ALL_OBJECTS,NOT_ENFORCE 
D','COPY,TRACE') 
 SQL2105N  The ADMIN_MOVE_TABLE procedure could not be completed 
because a prerequisite for running the procedure was not 
satisfied.  Reason code: "10".  SQLSTATE=5UA0 
 
 
SQL2448N  The db2convert command failed to convert any 
row-organized tables to column-organized tables.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* users who use ADMIN_MOVE_TABLE procedure or db2convert       * 
* utility to convert the row-organized table into              * 
* column-organized table.                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V105FP3.                                      * 
****************************************************************
Local-Fix:
Drop the cluster index and recreate the unique index as 
non-clustered. And cancel the failed move by calling 
ADMIN_MOVE_TABLE and then rerun db2convert command.
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
First fix in V105FP3.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.09.2013
26.11.2014
26.11.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList