Re: no access to Informix SE with sqlexecd
On 7 Nov 2005 02:38:36 -0800, t.ellinger@gemos.com <t.ellinger@gemos.com> wrote: > > I have a problem accessing an Informix SE 7.20.UC2 database through > ODBC (Informix Connect 2.81). The connection worked fine until a reboot > of the server. One problem is SE 7.20 - that should have been retired long ago. However, SE is less prone to Y2K problems than IDS was. When I login as root: > > The sqlexecd process is running: > > ps -ef | grep sqlexecd | more > > root 519 1 1 10:00:53 ? 00:00:00 > /usr/informix/lib/sqlexecd > > When I try to restart it, I get the following error message: > > # $INFORMIXDIR/lib/sqlexecd ifx_se > 2005-11-07 11:32:11.611143 daemon err = -25553: Cannot open file > 'rds.iem' That probably means your Informix environment is incorrect - the message file has gone astray. The sqlexecd service is in the sqlhosts file: > > ifx_se setlitcp ifxserver sqlexecd > > INFORMIXSERVER and INFORMIXDIR are set in the environment. > > Does anybody know what is going wrong? > Have you validated that sqlexecd appears in /etc/services? Is your host still called ifxserver? Do you need a FQDN (ifxserver.gemos.com<http://ifxserver.gemos.com>; )? What changed between this reboot and the previous one? -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ sending to informix-list