|
Problem IC69083
|
Status: Closed |
NO FILE SYSTEM CACHING NOT HONORED ON GPFS TABLESPACES ON CREATE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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. |
| Problem Summary: |
****************************************************************
* 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. |
| available fix packs: |
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 |
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. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.06.2010
23.09.2010
23.09.2010 |
| 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.3
|
 |
| 9.7.0.3
|
|
