SEO

We (Department of computer science, University of Tampere) have a wierd
problem. When I try to precompile a C file on my home directory, I get

$ db2 prep test.sqc

LINE MESSAGES FOR test.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0031C File "test.sqc" could not be opened.
SQL0092N No package was created because of previous
errors.
SQL0091W Precompilation or binding was ended with "2"
errors and "0" warnings.

but when I move the file to /tmp directory, it precompiles ok (and the
compiles and executes).

The system is Linux (2.4.24; gentoo 1.4) and DB2 is 8.1.0 (Enterprise
edition).

The difference between /tmp -directory and my home directory is, that home
directories are nfs mounted.

So, is this some nfs mount problem (root and all db2 dummy users are local,
and thus their home directories are on local disks) or what?

--
Arto V. Viitanen av@cs.uta.fi
University of Tampere, Department of Computer Sciences
Tampere, Finland http://www.cs.uta.fi/~av/

I suspect that you're looking at an environmental problem. My home directory
on the machine I do most of my development on is an NFS mount and its never
been an issue. If you're setting up a inter-partition parallel server, we
even recommend NFS mounting the home.

Do you have a db2instance in your home directory or are you using an
instance in a different account? My only guess is that the DB2 instance
doesn't have the authority to read/write to your home directory.
--
__________________________________________________ ___________________
Doug Doole
DB2 Universal Database Development
IBM Toronto Lab

Visit the DB2 UDB and DB2 Connect Online Support site at:
http://www.ibm.com/software/data/db2...s2unix/support

>>>>> "Douglas" == Douglas Doole <doole@ca.ibm.com> writes:

Douglas> I suspect that you're looking at an environmental problem. My home
Douglas> directory on the machine I do most of my development on is an NFS
Douglas> mount and its never been an issue. If you're setting up a
Douglas> inter-partition parallel server, we even recommend NFS mounting the
Douglas> home.

Douglas> Do you have a db2instance in your home directory or are you using
Douglas> an instance in a different account? My only guess is that the DB2
Douglas> instance doesn't have the authority to read/write to your home
Douglas> directory.

The db2 accounts (db2inst1, dbas and db2fenc1) have their home directories at
the local disk.

It seems that the reason is because of nfs: I made a subdirectory to the
/tmp, and made a symbolic link on my home directory that points to the
subdirectory. Then I changed current directory to the symbolic link directory
(so path contains my /home), and precompilation worked ok.

--
Arto V. Viitanen av@cs.uta.fi
University of Tampere, Department of Computer Sciences
Tampere, Finland http://www.cs.uta.fi/~av/

>>>>> "Douglas" == Douglas Doole <doole@ca.ibm.com> writes:

Douglas> I suspect that you're looking at an environmental problem. My home
Douglas> directory on the machine I do most of my development on is an NFS
Douglas> mount and its never been an issue. If you're setting up a
Douglas> inter-partition parallel server, we even recommend NFS mounting the
Douglas> home.

One more thing: I created a user, who has home directory (and password entry)
on the local computer. This user can precompile (and compile and run) an
embedded SQL program, so problem is on the nfs; it seems.

--
Arto V. Viitanen av@cs.uta.fi
University of Tampere, Department of Computer Sciences
Tampere, Finland http://www.cs.uta.fi/~av/

Unfortunately, I don't have any other great ideas to offer you. I know the
environment can be made to work, but I don't have any advise on debugging
it. Sorry.

--
__________________________________________________ ___________________
Doug Doole
DB2 Universal Database Development
IBM Toronto Lab

Visit the DB2 UDB and DB2 Connect Online Support site at:
http://www.ibm.com/software/data/db2...s2unix/support

In article <webro7up1t.fsf@cs.uta.fi>, Arto Viitanen (av@cs.uta.fi)
says...
>
> The system is Linux (2.4.24; gentoo 1.4) and DB2 is 8.1.0 (Enterprise
> edition).
>
> The difference between /tmp -directory and my home directory is, that home
> directories are nfs mounted.
>
> So, is this some nfs mount problem (root and all db2 dummy users are local,
> and thus their home directories are on local disks) or what?
>
>

A long time ago I ran into a bind problem on AIX because the mount
point didn't have the needed access rights. DB2 was walking from the
current directory to the root directory using some system call which
needed those rights.
We ran a system trace to find out what was going on, maybe you can
run the same kind of trace on Linux?

>>>>> "Douglas" == Douglas Doole <doole@ca.ibm.com> writes:

Douglas> Unfortunately, I don't have any other great ideas to offer you. I
Douglas> know the environment can be made to work, but I don't have any
Douglas> advise on debugging it. Sorry.

A student (he worked as a system manager on summer, so he knows this stuff)
solved the problem. NFS uses rpc.statd to give locks to files. It seems
"db2 prep file.sqc" tries to lock the file. On local disks, the filesystem
(or whatever) gives the lock, but on NFS disks, rpc.statd does them.

Since I only had nfs clients, I had not started the nfs daemon. This meant,
that I also had not started the rpc.statd, so no locks!

Of corse, the error message was wrong. It said that it did not find the SQC
file. It did find, but it could not lock it.

--
Arto V. Viitanen av@cs.uta.fi
University of Tampere, Department of Computer Sciences
Tampere, Finland http://www.cs.uta.fi/~av/