DB2 - Problembeschreibung
Problem IC65416 | Status: Geschlossen |
XML SCHEMA REGISTER , UPDATE, COMPLETE STATEMENTS MAY MARK THE DB BAD DURING A ROLL BACK IF AN ERROR IS ENCOUNTERED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
XML Schema register, update, complete statements may bring DB2 down on a rollback when an error is encountered due to incorrect handling of save points. The database will be marked bad and a restart will be needed. Examples of XML Schema statements that may cause this problem are : db2 "REGISTER XMLSCHEMA http://schemaTest from foo/schemaTest.xsd as schemaTest" db2 "COMPLETE XMLSCHEMA schemaTest Using the following stored procedures to manage XML schema may also cause the problem, if an error is encountered during processing. XSR_ADDSCHEMADOC procedure XSR_COMPLETE procedure XSR_DTD procedure XSR_EXTENTITY procedure XSR_REGISTER procedure XSR_UPDATE procedure | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All environments * **************************************************************** * PROBLEM DESCRIPTION: * * XML SCHEMA REGISTER , UPDATE, COMPLETE STATEMENTS MAY MARK * * THE * * DB BAD DURING A ROLL BACK IF AN ERROR IS ENCOUNTERED * **************************************************************** * RECOMMENDATION: * * Upgrade to V95 FP6 * **************************************************************** | |
Local-Fix: | |
After restart, drop the XML schema using the "DROP XSROBJECT schemaName" statement and try to re-register the schema. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.01.2010 01.07.2010 01.07.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |