shared memory connection problem/misconfiguration
I have the following very simple esql program that uses a shared memory
connection:
main()
{
EXEC SQL WHENEVER ERROR STOP;
EXEC SQL connect to 'mydb';
EXEC SQL disconnect 'mydb';
}
About every fifth run of the program, I get the following error:
Program stopped by WHENEVER STOP
sqlca:
sqlcode:-25588
sqlerrm: 'my_ids'
sqlerrp: ''
sqlerrd:
sqlerrd(1)=0
(2)=22
(3)=0
(4)=0
(5)=0
(6)=0
sqlwarn.sqlwarn0:
.sqlwarn1:
.sqlwarn2:
.sqlwarn3:
.sqlwarn4:
.sqlwarn5:
.sqlwarn6:
.sqlwarn7:
Obviously, I have something misconfigured, but the error messages don't really
give me a lot of information about where to look (they suggest the problem is
in the sqlhosts file or at the OS level). This problem only happens when I use
a shared memory connection.
My sqlhosts looks like this:
my_ids onipcshm support andrew
Other info:
# dbaccess -versionProgram Name: dbaccess
Build Version: 11.10.UC1E
Build Number: N494
Build Host: lxvm-l19.lenexa.ibm.com
Build OS: Linux kernel-2.6.9-34.ELsmp glibc-2.3.4-2.19
Build Date: Wed Jun 27 14:47:00 CDT 2007
GLS Version: glslib-4.50.UC1
# esql -V
IBM Informix CSDK Version 3.00, IBM Informix-ESQL Version 3.00.UC3DE
There are no errors in the online.log file or in any OS logs.
Any ideas as to what I have configured incorrectly?
Thanks
Andrew