470,631 Members | 1,572 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,631 developers. It's quick & easy.

SQL10004C An I/O error occurred while accessing the database directory.

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-
Oct 23 '06 #1
1 5760
Nvm.. being dense again.

Wrong NFS version. Unable to use locking.
DB2 really really wants locking ;)

-R-

Jurgen Haan wrote:
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-
Oct 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Carl Draus | last post: by
6 posts views Thread by Javier Cortés Cortés | last post: by
17 posts views Thread by JStemper | last post: by
6 posts views Thread by Chris Love | last post: by
2 posts views Thread by le0 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.