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

ADMIN_MOVE_TABLE FAILS WITH SQL2103N RC 17 IF THERE ARE 3 TYPES OF INDEX ON
A TABLE (PRIMARY KEY , UNIQUE , NON UNIQUE )

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
admin_move_table fails with  sql2103n RC 17  if there are 3 
types of index on a table (Primary key , unique , non unique ) 
 
The following testcase demonstrates the problem : 
 
connect to sample; 
 
create tablespace tbs_temp1 ; 
create tablespace systoolspace ; 
create table t1 ( c1 integer not null ,  c2 integer not null ) ; 
alter table t1 add primary key  (c1 ) ; 
create index in1 on t1 (c2 asc ) ; 
create unique index in2 on  t1 ( c2 asc) ; 
 
call sysproc.admin_move_table ('DB2INS10','T1' , 
'TBS_TEMP1','TBS_TEMP1', 'TBS_TEMP1', '', '', '', '', '', 
'MOVE')  ; 
 
Fails with : 
 
SQL2103N  The ADMIN_MOVE_TABLE procedure could not be completed 
because some 
aspect of either the source table or target table is not 
supported by the 
ADMIN_MOVE_TABLE procedure.  Reason code: "17".  SQLSTATE=5UA0M 
 
with db2diag.log entry : 
 
INSTANCE: db2ins10             NODE : 000          DB   : TEST1 
APPHDL  : 0-1507               APPID: 
*LOCAL.db2ins10.120705051415 
AUTHID  : DB2INS10 
EDUID   : 66                   EDUNAME: db2agent (TEST1) 0 
FUNCTION: DB2 UDB, database application extension for utili, 
adminotm_online_table_move, probe:20417 
DATA #1 : String, 8 bytes 
DB2INS10 
DATA #2 : String, 2 bytes 
T1 
DATA #3 : String, 4 bytes 
MOVE 
DATA #4 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2103   sqlerrml: 4 
 sqlerrmc: 17 
 sqlerrp : SQL09076 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0x00000000      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
The following select shows the different index types present : 
 
$ db2 "select indname,indextype,uniquerule from syscat.indexes 
where tabname='T1'" 
 
INDNAME                              INDEXTYPE UNIQUERULE 
-----------------------              --------- ---------- 
SQL120705061145480                  REG       P 
IN1                                              REG       D 
 
IN2                                              REG       U
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fix Pack 7                               * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem first fixed in DB2 V9.7 Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC88315 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.07.2012
31.10.2012
31.10.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList