|
Problem IT28848
|
Status: Closed |
DATABASE RECOVERY IS VERY SLOW FOR XA TRANSACTIONS
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When a Db2 database is used as a resource manager in a
distributed environment, and the application is setup to use
Two-phase commit, there are special log records generated that
are not handled optimally during database recovery. This can
affect crash recovery, database rollforward recovery, as well as
HADR standby log replay, resulting in longer outage time, or
HADR standby falling far behind of the primary database. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DATABASE RECOVERY IS VERY SLOW FOR XA TRANSACTIONS *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* First fixed in v10.5 fp10 *
**************************************************************** |
| Local Fix: |
Stop using XA transaction, or change configuration to use
one-phase commit. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.04.2019
28.06.2020
28.06.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
