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

ADMIN_MOVE_TABLE FAILED WITH SQL0104N IF THE SOURCE TABLE HAS NO INDEX AND
THE 1ST COLUMN SIZE EXCEEDS THE MAX KEY LENGTH LIMIT

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
If the source table has no index and the first column size 
exceeds the max key size limit, then AMT would fail with 
SQL0104N. For example, the table below has DESCRIPTION column 
with VARCHAR(4000) which exceeds the max key length limit (2048 
bytes for the table space with 8K page size) as the 1st column, 
and there is no index defined on the table: 
 
CREATE TABLE "WCS     "."PARTROLEDS"  ( 
        "DESCRIPTION" VARCHAR(4000) , 
                  "PARTROLE_ID" INTEGER NOT NULL , 
                  "LANGUAGE_ID" INTEGER NOT NULL , 
                  "OPTCOUNTER" SMALLINT ) 
                 IN "TAB8K" ; 
 
$ db2 "select substr(colname,1,30), colno FROM SYSCAT.COLUMNS 
WHERE tabname='PARTROLEDS' order by colno" 
 
1                              COLNO 
------------------------------ ------ 
DESCRIPTION                         0 
PARTROLE_ID                         1 
LANGUAGE_ID                         2 
OPTCOUNTER                          3 
 
  4 record(s) selected. 
 
$ db2 "call sysproc.admin_move_table( 'WCS', 'PARTROLEDS', 
'TBS16', 'TBS16_I', 'TBS16_L', '', '', '', '', '', 'MOVE,TRACE' 
)" 
SQL0104N  An unexpected token "," was found following 
""WCS"."PARTROLEDS"(". 
Expected tokens may include:  "<space>".  SQLSTATE=42601 
 
And the ADMIN_MOVE_TABLE trace like: 
. . (10600)EXIT: adminotm_Otm_getColumns                 | 0 | 4 
. . (3116)ENTRY: adminotm_Otm_generateIdent              | 
0x2aaac1be7fc0 | 129 | PARTROLEDS | g | 128 
. . (3141)EXIT: adminotm_Otm_generateIdent               | 0 | 
PARTROLEDSAJd0#jg 
. . (2292)ENTRY: adminotm_StoredProcedure_execDirect 
| CREATE INDEX "WCS"."PARTROLEDSAJd0#jg" ON 
"WCS"."PARTROLEDS"(,"PARTROLE_ID","LANGUAGE_ID","OPTCOUNTER") | 
0x2aabcea07d70 
. . . (711)ENTRY: adminotm_fillSqlca             | 3 | 65542 | 
0x2aabcea07d70 
. . . . (728)DATA: adminotm_fillSqlca            | 1 |  SQL0104N 
An unexpected token "," was found following 
""WCS"."PARTROLEDS"(".  Expected tokens may include:  "<space>". 
SQLSTATE=42601
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using ADMIN_MOVE_TABLE procedure                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 Fix Pack 4 or higher                    * 
****************************************************************
Local-Fix:
To create an index before the move.
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 V10.1 Fix Pack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.11.2013
02.06.2014
02.06.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.4 FixList