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

ADMIN_MOVE_TABLE FAILS WITH SQL1191N IF TABLE CONTAINS A LOB COLUMN AND
COMPRESSION IS TURNED ON

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
ADMIN_MOVE_TABLE fails with SQL1191N if table to be moved 
contains a LOB column and compression is turned on. 
 
The error message the client receives is: 
 
SQL2102N  The ADMIN_MOVE_TABLE procedure could not be completed 
because of an internal failure during the execution of the 
procedure. 
Reason code: "22". SQLSTATE=5UA0M 
 
And the message file contains: 
 
SQL1191N  Column "<LOB columname>" specified in the METHOD 
parameter does not exist. 
 
This is similiar problem than reported in APAR IT02861 which is 
specific for XML columns.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 11.                      * 
****************************************************************
Local-Fix:
don't specify COPY_USE_LOAD if possible
Lösung
First fixed in DB2 Version 9.7 Fix Pack 11.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.10.2014
09.10.2015
09.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP11
Problem behoben lt. FixList in der Version
9.7.0.11 FixList