Re: Informix 5 SQLEXECD question

You can try defining SQLHOSTS on the server for example like below, instance1 protocolname machinename service1 instance2 protocolname machinename service2 Start sqlexecd daemons , For instance 1, after setting INFORMIXDIR , start the first sqlexecd, export SQLEXEC=$INFORMIXDIR/lib/sqlturbo export TBCONFIG=tbconfig.instance1 $INFORMIXDIR/lib/sqlexecd service1 For instance 2, after setting INFORMIXDIR, start the second sqlexecd export SQLEXEC=$INFORMIXDIR/lib/sqlturbo export TBCONFIG=tbconfig.instance2 $INFORMIXDIR/lib/sqlexecd service2 Now test this using dbaccess to see if you can access the databases from these two instances. For detailed setup and configuration please refer IBM INFORMIX NET and IBM INFORMIX STAR documentation. For question (3), as you are granting connect privileges by userid, you can connect to the databases using the approprated userid. Thanks prasad Webb, Eric wrote: > I have an Informix 5-based application on AIX and need help with SQLEXECD > (I-Star). Specifically, I am trying to get desktop PCs running reporting > software (e.g., Crystal Reports) and the Client SDK to be able to access my > Informix 5 databases. > > Currently, database A is working this way, with no issues. > > The problem comes when I bring up a second instance, with database B. > Database A continues to work fine, but I cannot get the reporting > applications to talk to or see database B. I've tried several different > methods here, so I'll spare the list of errors. I'm looking for the proper > way to configure such a scenario (sqlexecd daemons, services, sqlhosts, user > ids), where one machine is running two Informix 5 instances, each instance > having a database to be accessed by PCs. To make things difficult, the > application requires that the database be named the same in each instance. > > 1) Do I need one, or two, sqlexecd daemons running (with either one or two > service names, as necessary)? > > 2) How would I configure my sqlhosts file? Is it even relevant in this case > (where PCs are remotely accessing the database engine)? > > 3) Each application runs as a separate user ID, and connect rights have been > granted using the appropriate user ID to each database. When connecting > from Client SDK to each database instance, it is necessary to use the > correct user ID, correct? > > 4) Does the sqlexecd daemon take any environment variables? All I see for a > command-line argument is the service name under which it binds. How does it > know which instances to talk to, where they are, shared memory segments to > use, etc., etc? I don't see that it even cares about the TBCONFIG variable. > > > Thanks, > Eric