DB2 - Problembeschreibung
Problem IC90794 | Status: Geschlossen |
ADMIN_MOVE_TABLE FAILS WITH SQL0206N WHEN RANGE PARTITION KEY REFERS TO A COLUMN NAME GREATER THAN 8 CHARACTERS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Using admin_move_table against a table with range partition defined. And the range partition key refer to a column name that's greater than 8 characters. e.g. Create table: CREATE TABLE DWH_H.FACT_AJUSTES_PRUEBA ( KEY_CERO SMALLINT , KEY_UNO SMALLINT , KEY_UNOMENOS SMALLINT , KEY_MEDIOPAGO SMALLINT , CLAVEHORA SMALLINT , KEY_CHAR CHARACTER , FECHAGRABACION DATE , FECHA DATE , CLAVEENTIDAD SMALLINT , KEY_MARCA SMALLINT , KEY_CLASE SMALLINT , CLAVEAFINIDAD INTEGER , CLAVEENCARGADO BIGINT , KEY_CUENTA INTEGER , KEY_TARJETA INTEGER , CLAVETIPOAJUSTE SMALLINT , MONTO INTEGER , RECCOUNT SMALLINT , CLAVE1 SMALLINT , CLAVE2 SMALLINT ) PARTITION BY RANGE (FECHAGRABACION) ( PARTITION PT_MINIMO STARTING FROM (MINVALUE) ENDING AT ('2006-01-01-00.00.00') EXCLUSIVE , PARTITION PT_200601 STARTING FROM ('2006-01-01-00.00.00') ENDING AT ('2006-02-01-00.00.00') EXCLUSIVE , .. Note: PARTITION BY RANGE (FECHAGRABACION) db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('DWH_H','FACT_AJUSTES_PRUEBA','A4R#BTAB D', 'A4R#BTABD', ' A4R#BTABD', NULL, ' ',' ', NULL, ' ', 'MOVE')" SQL0206N "FECHAGR" is not valid in the context where it is used. SQLSTATE=42703 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 UDB Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v10.1 Fix Pak 3 * **************************************************************** | |
Local-Fix: | |
Move table manually by export/import. | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Problem first fixed in DB2 v10.1 Fix Pak 3 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC95305 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.03.2013 24.10.2013 24.10.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 | |
10.1.0.3 |