Path: utzoo!attcan!uunet!decwrl!nsc!pyramid!infmx!aland
From: aland@informix.com (alan denney)
Newsgroups: comp.databases
Subject: Re: Informix transfer problem
Summary: check groups, and perms
Message-ID: <1990Oct4.075211.161@informix.com>
Date: 4 Oct 90 07:52:11 GMT
References: <1990Sep25.170902.18376@dircon.uucp>
Sender: news@informix.com (Usenet News)
Organization: INFORMIX Professional Services ("Peace thru Normalization")
Lines: 44

In article <1990Sep25.170902.18376@dircon.uucp> sys0001@dircon.uucp (Ben Knox) writes:
>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.

That's cuz Informix doesn't store uids -- just user names. 

You make no mention of *groups*, however -- that is probably the
problem.  All .dbs directories must be owner = creating dba, group =
informix, permissions 770.  The files within the .dbs must be same
owner and group, perms 660.  The group-id is probably the problem.

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

If you are using a different port, you may need to resize the index
nodes in the index files.  If so, bcheck each table and use the -s
option to resize old index files to the new node size.

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

Doing otherwise is just *asking* for trouble...

>Regards, Ben


--
Alan Denney  # aland@informix.com # {pyramid|uunet}!infmx!aland

 "These tests will have no effect on your grades.  They will merely
  determine your future social status and financial success, if any."
            - Matt Groening