473,379 Members | 1,533 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

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 6062
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Carl Draus | last post by:
I have a number of DB2 v8.1 FP4a instances that have been running fine on an AIX server for quite some time. I installed alternate FP7 last week and created a new instance at that level today. I'm...
5
by: azgoddess1 | last post by:
During the installation I get these error messages: ***** SQL1390C The environment variable DB2Instance is not defined or is invalid An error ocured while loading the command "C:\Program...
5
by: NG | last post by:
Hi, We are having DB2-V7.2 DB on AIX 5.2 machine. Recently we upgraded our system to fixpack 13 and activated activate AIX asynchronous IO function. Our DB is going to crash recovery with...
6
by: Javier Cortés Cortés | last post by:
i am getting this error when i am trying to access any file(with the ext. aspx) from my remote server. the error is : Server Error in '/' Application....
17
by: JStemper | last post by:
On one of my localhost sites I'm getting a message to run aspnet_regiis -c to correct some scripting issues. When I try to run the listed command I get another error: "You must have...
1
by: Dave | last post by:
I am getting te following error in a ASP.Net app that is running on Win XP Pro (SP2): Server cannot access application directory 'C:\Documents and Settings\dave\My Documents\My Visual Studio...
0
by: tony dong | last post by:
Hi there I use vs.net 2005 with standard sql 2005 under machine\sql2005 for instant when I create webpart, the code get from quickstart as follow: <%@ Page Language="C#" %> <%@ Register...
6
by: Chris Love | last post by:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not...
2
by: le0 | last post by:
guys, this is my first time to deploy website to the server, but every time i access the page this error always appears. ...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.