DB2 - Problem description
Problem IT06420 | Status: Closed |
ROLLBACK PERFORMANCE MIGHT BE AFFECTED BY LARGE NUMBER OF DIRTY PAGES | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
If there are large number of dirty pages in buffer pools, ROLLBACK could be affected and has bad performance. The purpose of the APAR is to improve performance in such kind of situations. Detailed dirty page information can be retrieved by 'db2pd -db <dbname> -dirtypage' command, where "<dbname>" is the name of database. Please note: output of the 'db2pd -dirtypage' command could be huge if there are large number of dirty pages. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply DB2 Version 10.1.0.5 * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Problem was first fixed in DB2 UDB version 10.1 fix pack 5. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.01.2015 20.07.2015 20.07.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 |