Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!mcsun!ukc!slxsys!dircon!sys0001
From: sys0001@dircon.uucp (Ben Knox)
Newsgroups: comp.databases
Subject: Informix transfer problem
Message-ID: <1990Sep25.170902.18376@dircon.uucp>
Date: 25 Sep 90 17:09:02 GMT
Sender: sys0001@dircon.uucp
Reply-To: sys0001@dircon.uucp (Ben Knox)
Organization: The Direct Connection, UK
Lines: 29

I've just transferred an Informix database running under ESQL to a new
machine, but am having problems getting it going. The transfer was done
with cpio and all directory/file permissions and ownerships were preserved.

I keep getting error -349 (Database not selected yet). This only happens
however, when I try to access the database as another user (ie not the
owner of the database). 

The one thing that has changed is the User Number (not the user name!) of 
the owner of the database -- this is running under Xenix. However, a
global chown command was run to all files which belonged to the original
user nunber to make them belong to the new user number. If you look at the
Info for the database tables in SQL, the owner's user name is correctly shown.

Is there something else which needs to be done in order to get things working
again?

I would have thought that if the change in owner number was affecting things,
then surely only the owner's access to the database would be ceased...?
In this case, however, it is all the other users who cannot get access
(and their user numbers and user names have not changed in the move).

Incidentally, although the actual databases were transferred by tar,
the Informix binaries, libraries etc were reinstalled from the distribution
disks.

Regards, Ben
-- 
sys0001@dircon.UUCP   or   sys0001%dircon@ukc.ac.uk