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

ADMIN_MOVE_TABLE CAN FAILS DURING CLEANUP WITH SQL0204N

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
ADMIN_MOVE_TABLE CAN FAILS DURING CLEANUP WITH 
SQL0204N 
 
You can get the following: 
 
SQL0204N  "JSEIFERT.STAFFAAWIWmo" is an undefined name. 
SQLSTATE=42704 
 
 
db2start 
db2sampl 
db2 connect to sample 
db2 create table JSEIFERT.STAFF2 like JSEIFERT.STAFF 
db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('JSEIFERT', 'STAFF', 
'STAFF2', '', 'INIT')" 
db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('JSEIFERT', 'STAFF', '', '', 
'COPY')" 
db2trc on -crash DB2.DBAPPEXT_UTIL.adminotm_Otm_cleanup.entry 
db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('JSEIFERT', 'STAFF', '', '', 
'SWAP,TRACE')" 
db2trc off 
db2start 
db2 connect to sample 
db2 'drop table JSEIFERT."STAFFAAWIWmo"' 
db2 "CALL SYSPROC.ADMIN_MOVE_TABLE('JSEIFERT', 'STAFF', '', '', 
'CLEANUP,TRACE')"
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.1 Fixpack 6 or Later.                 * 
****************************************************************
Local-Fix:
Lösung
First Fixed in DB2 LUW v10.1 Fixpack 6.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.04.2015
13.07.2015
13.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList