Re: Informix 5 SQLEXECD question

Webb, Eric wrote: In addition to Passad's notes you also need to set DBPATH to the servername from sqlhosts for each engine in the environment of the appropriate sqlexecd. Art S. Kagel > 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