DB2 - Problembeschreibung
Problem IC92741 | Status: Geschlossen |
ONLINE BACKUP PERFORMANCE DEGRADATION AND ABNORMAL BACKUP IMAGE FILE SIZE VARIATIONS IN V10.1 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
in v10.1, an Online Backup may perform poorer then previous releases. Also, there may be an abnormally large variance in the size of the backup sequence files. When more then one tablespace exist, Online Backup will parallelize the processing of tablespaces. Before reading extents for a tablespace in parallel, Backup must flush dirty bufferpool pages for this tablespace to disk. Prior to v10.1 this flush was performed in parallel by the backup db2bm edus. In v10.1 this action is performed in serial by the backup db2agent edu. If flushing of the bufferpools takes a relatively long time (because the bufferpools contain many dirty pages, or there is a lot of other concurrent transaction activity) then it will take longer for Backup's parallel db2bm edus to begin processing some tablespaces. Also, when more then one path is specified in the Online Backup command, this defect can result in abnormally large variations in the size of the backup sequence files, usually one being much larger then others (small variations are normal). These problems do not affect releases prior to 10.1. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply inclusive fixpack. * **************************************************************** | |
Local-Fix: | |
One potential method to help alleviate the issue is to decrease the Backup PARALLELISM value. Another potential method to help alleviate the issue is to disable TRACKMOD configuration parameter (if you to do not need incremental or delta backups). | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.06.2013 13.05.2014 13.05.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.4 |