Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC65416 Status: Closed

XML SCHEMA REGISTER , UPDATE, COMPLETE STATEMENTS MAY MARK THE DB BAD
DURING A ROLL BACK IF AN ERROR IS ENCOUNTERED

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
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 Summary:
**************************************************************** 
* 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.
available fix packs:
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

Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.01.2010
01.07.2010
01.07.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.