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 IC61813 Status: Closed

UNPROCESSED XML LOG RECORDS DURING ROLLFORWARD

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
During a rollforward operation of a table containing XML data, 
there is a possibility that some 
XML log records could be unintentionally ignored.  This can only 
happen if the XML data is in a separate table space 
from that of the base table data and if there is also no LOB or 
Long Field columns in the table. 
 
This APAR corrects the issue and ensures that all XML log 
records are processed during rollforward operations.  This 
APAR also ensures that an error message will be returned if the 
user incorrectly attempts to rollforward through only 
the XML log records, and not the associated base table log 
records as well.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* XML Users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If XML log records are ignored during roll forward then      * 
* users may find XML tables are missing                        * 
* updates/inserts/deletes.                                     * 
* If the users incorrectly attempt to roll forward only the    * 
* XML tablespace log records without rolling forward through   * 
* the base data table as well, then no error message returned  * 
* and the procedure appears to succeed.                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 9.05.005                                          * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
This APAR corrects both conditions.  After installing this APAR 
none of the XML log records will be ignored during roll forward 
operations. 
If the user attempts to roll forward the XML tablespace only 
then an error will be returned.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
30.06.2009
17.02.2010
17.02.2010
Problem solved at the following versions (IBM BugInfos)
9.5.5.005
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.5 FixList
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.