Informix 5 SQLEXECD question
Posted in 2006
Topics: Networking & sqlhosts Configuration, Platform-Specific Issues
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