|
Problem IC63558
|
Status: Geschlossen |
SLOW RESTORE INTO A NEW DATABASE ON AIX DUE TO HAVING ONLY 3 PREFETCHERS STARTED. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When a restore is done on AIX into a new database, by default
only 3 prefetcher processes are started, causing slow restore.
This does not happen when the restore is on existing database,
when NUM_IOSERVERS parameter is set to a higher value.
And when restoring into a new database, there are no means to
set NUM_IOSERVERS database configuration parameter.
This does not happen on Linux where by default 255 prefetcher
processes are started.
The workaround to this issue is to create a dummy database,
update NUM_IOSERVERS to a higher value (ex: 20), then do a
restore. This will cause equal number of prefetcher processes
start as it is defined by NUM_IOSERVERS parameter. |
| Problem-Zusammenfassung: |
SLOW RESTORE INTO A NEW DATABASE ON AIX DUE TO HAVING ONLY 3
PREFETCHERS STARTED. |
| Local-Fix: |
1. Create a dummy database
2. Update NUM_IOSERVERS to a higher values (20 is a good
starting point):
db2 connect to <db_name>
db2 update db cfg using NUM_IOSERVERS 20
3. Start a restore. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
LOCAL FIX:
1. Create a dummy database
2. Update NUM_IOSERVERS to a higher values (20 is a good
starting point):
db2 connect to <db_name>
db2 update db cfg using NUM_IOSERVERS 20
3. Start a restore.
Fixed in DB2 V97 FP3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 06.10.2009
21.01.2011
21.01.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
| 9.7.0.3
|
|
| 9.7.0.3
|
|
