I want to connect to two informix database within a single informix instance, but cannot get baan / informix configured correctly to do so.

Operating system: HP-UX 11
Informix: 9.2
Baan: IVc3

Informix databases within the single instance:

1) baan Co 000 & live company
2) arcdb Archive company

I can log into live company OK.
I cannot switch into archive company though - table not found.

I have set up a new group entry in inf_groups for arcdb, and have a user entry in inf_users that is assigned to this group.
This user cannot start baan properly, as it connects to database arcdb, and cannot access the company 000 tables.

The tables for the archive comapny are assigned to a different database defintion, and a new informix process is started when you attempt to access a table in the archive company.

I beleive I need to force baan to use a database name of arcdb when attempting to access the tables for the archive company, but I don't know how to do this.

Any ideas ?

Thanks in advance.

Have you looked at the inf_storage file?

You could have entries like;

*:999:group:01:30:INITIAL 16 NEXT 16 LOCK row CLUSTERED dbspace arcdb
*:999:I::01::dbspace arcdb
*:*:group:01:30:INITIAL 16 NEXT 16 LOCK row CLUSTERED dbspace baan
*:999:I::01::dbspace baan


This will assign all tables in Company 999 (you'll need to change this to your archive company number) and all indexes, to the arcdb DB space. All other companies and tables (including index spaces) will be assigned to the baan DB space.

It is at the database level I want to do the selection. The instance has two databases set-up:

baan - many dbspaces for tables, indexes, etc.
arcdb - dbspace arcdatdbs only.

Just modifing inf_storage isn't sufficient - as I need the BaaN application to select the database arcdb for a single company only. BaaN uses a informix role to sign into the database, the normal one is baanr. I want to force it to use a role arcdbr for the my archive database.

Hope this explains things a bit better.

My local baan support has told me it isn't possible, but that isn't going to stop my trying ...

We have a similar setup, except that we use the same role for both current and archive databases. The permissions are assigned through baan usernames.

Andy

Thanks for the info.

Do you have more than one informix instance or just a single one?

David.

Sorry - I misread your original post.

We have an archive instance, it is not in the same instance as current data.

Our main goal for separate instances was disaster recovery.

We also have company '000' tables in tbase. (fighting to change this..)

As I was looking into more of how our archive db is setup,
I came up with this question:
--Where do you tell Baan the name of the database? (not the instance)


Andy

Baan selects the database from the group on the user in inf_users. The group has to exist in inf_groups. The groups maps to a role in informix with the same name as the group, but with an 'r' on the end.

E.g.

group role
------- --------
baan baanr
arcdb arcdbr

Beware of needing to get to Co 000 tables if these are in informix in the future.