|
Problem IC63558
|
Status: Closed |
SLOW RESTORE INTO A NEW DATABASE ON AIX DUE TO HAVING ONLY 3 PREFETCHERS STARTED. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
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. |
| available fix packs: |
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
|
| Solution |
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 |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.10.2009
21.01.2011
21.01.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
| 9.7.0.3
|
|
| 9.7.0.3
|
|
