|
Problem IC69083
|
Status: Geschlossen |
NO FILE SYSTEM CACHING NOT HONORED ON GPFS TABLESPACES ON CREATE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When tablespaces are created using default options on GPFS file
system on DB2 9.7, No File System Caching is supposed to be
enabled, and is shown accordingly in db2look output. However,
internally, DB2 still uses the file system caching. It's
visible that file system caching occurs due to the increased
I/O. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Tablespaces created on GPFS file system *
****************************************************************
* PROBLEM DESCRIPTION: *
* When tablespaces are created using default options on GPFS *
* file *
* system on DB2 9.7, No File System Caching is supposed to be *
* *
* enabled, and is shown accordingly in db2look output. *
* However, *
* internally, DB2 still uses the file system caching. It's *
* *
* visible that file system caching occurs due to the increased *
* *
* I/O. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 Fix Pack 3 or higher. *
**************************************************************** |
| Local-Fix: |
This issue can be worked around by explicitly altering the
tablespace in question with no file system caching. |
| verfügbare FixPacks: |
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 |
Fixed in DB2 9.7 Fix Pack 3. The default No File System Caching
is honoured for GPFS, after applying the fix for this defect. |
| Workaround |
This issue can be worked around by explicitly altering the
tablespace in question with no file system caching. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 08.06.2010
23.09.2010
23.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
