DB2 - Problem description
Problem IT03542 | Status: Closed |
ROLLBACK PERFORMANCE MIGHT BE AFFECTED BY LARGE NUMBER OF DIRTY PAGES | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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 users of version 9.7 on Linux, Unix and Windows * * platforms. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to DB2 LUW Version 9.7 Fix Pack 10 or higher levels. * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
First fixed in DB2 LUW Version 9.7 Fix Pack 10. | |
Workaround | |
N/A | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.08.2014 10.11.2014 10.11.2014 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.10 |