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

ROLLFORWARD OF LOAD REPLACE WITH XML DATA FAILS WITH SQL1042C (U NEXPECTED
SYSTEM ERROR)

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Rollforward of LOAD REPLACE with XML data fails with SQL1042C 
(unexpected system error) 
 
Here are the 10 steps to reproduce the problem: 
 
-- Create database, enable log retain, do initial backup 
db2start; 
create db xmldb; 
update db cfg for xmldb using logretain recovery; 
backup db xmldb; 
connect to xmldb; 
 
-- Create a table, insert one row 
create table t (a int, x xml); 
insert into t values (1, xmlparse(document '<foo />' strip 
whitespace)); 
 
-- LOAD REPLACE anything (or nothing at all) 
load from /dev/null of del xml from . replace into t; 
 
-- Restore the initial database image, and rollforward to end of 
logs 
restore db xmldb replace existing; 
rollforward db xmldb to end of logs and complete;
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Rollforward of LOAD REPLACE with XML data fails with         * 
* SQL1042C (unexpected system error)                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 5 or later.              * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.5 Fix Pack 5. 
This fix should be applied on the DB2 server.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
06.07.2009
21.12.2009
21.12.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP5
Problem behoben lt. FixList in der Version
9.5.0.5 FixList