Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
On Solaris with NFS file system, table space with "no system caching" system caching" leads to the following warning messages in db2diag.log: 2007-06-19-11.42.12.630291+120 E43817A441 LEVEL: Warning PID : 4993 TID : 1 PROC : db2agent (CFW) 0 INSTANCE: db2cfw NODE : 000 DB : CFW APPHDL : 0-1229 APPID: *LOCAL.db2cfw.070619094109 AUTHID : DB2CFW FUNCTION: DB2 UDB, oper system services, sqlo_enable_dio_cio_using_ioctl, probe:30 DATA #1 : <preformatted> Unsupported file system type nfs for Direct I/O. 2007-06-19-11.42.12.636181+120 E44259A605 LEVEL: Warning (OS) PID : 4993 TID : 1 PROC : db2agent (CFW) 0 INSTANCE: db2cfw NODE : 000 DB : CFW APPHDL : 0-1229 APPID: *LOCAL.db2cfw.070619094109 AUTHID : DB2CFW FUNCTION: DB2 UDB, oper system services, sqlo_enable_dio_cio_using_ioctl, probe:30 MESSAGE : ZRC=0x83000000=-2097152000=SQLZ_RC_UD_FAKE "place holder for class start. Do not use." CALLED : OS, -, unspecified_system_function DATA #1 : File name, 49 bytes /db2/CFW/sapdata1/NODE0000/CFW#LOADI.container000
Local fix
N/A
Problem summary
ON SOLARIS, DIRECT I/O (DIO) SHOULD WORK ON NFS FILE SYSTEM.
Problem conclusion
First fixed in V9.1 FP5
Temporary fix
N/A
Comments
APAR Information
APAR number
IZ03816
Reported component name
DB2 UDB ESE SOL
Reported component ID
5765F4102
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-08-29
Closed date
2008-07-30
Last modified date
2008-07-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDB ESE SOL
Fixed component ID
5765F4102
Applicable component levels
R910 PSN
UP
Document Information
Modified date:
30 July 2008