Hiya...
I'm trying to get db2 LUW 8.2.6 X86_64 working on a netapp.
We're running SLES 10.
The software and instance are created locally, but when I try to create
a database on a path mounted with NFS3, I get the message:
SQL10004C An I/O error occurred while accessing the database directory.
Db2diag reports the following:
2006-10-23-13.57.39.647297+120 E17312E355 LEVEL: Warning (OS)
PID : 20390 TID : 47423380083424PROC : db2
INSTANCE: db2inst NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqcurdir, probe:100
CALLED : OS, -, unspecified_system_function OSERR: ENOENT (2)
DATA #1 : File name, 0 bytes
<zero-length data>
2006-10-23-13.57.46.836152+120 E17668E462 LEVEL: Warning (OS)
PID : 20384 TID : 47828777764464PROC : db2agent
(instance) 0
INSTANCE: db2inst NODE : 000
APPHDL : 0-10 APPID: *LOCAL.db2inst.061023115746
FUNCTION: DB2 UDB, oper system services, sqlormdir, probe:100
CALLED : OS, -, unspecified_system_function OSERR: ENOTEMPTY (39)
DATA #1 : File name, 38 bytes
/data/db2_db/db2inst/NODE0000/sqldbdir
The NFS share is mounted with:
type nfs (rw,hard,nointr,rsize=32768,wsize=32768,bg,tcp)
according to the redbook
http://www.redbooks.ibm.com/redbooks/pdfs/sg246538.pdf this should work.
But alas.
Can anyone help me here?
For sake of simplicity, lets imagine this is about general NFS and not
just NetApp.
Thank you.
-R-