RE: Threadlib and Informix error -931
Gagan,
My sincere apologies for this very short-sighted reply, i didn't even
bother to read the whole email, just assumed that 'finderr -931' is it.
I very vaguely remember something about multi-threaded clients and
shared memory connections. From your mail i see that you are using
network connections, maybe just double check.
Regards,
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org] On Behalf Of Willem Roos
> Sent: 04 April 2005 12:43
> To: gagan.haloi@gmail.com; informix-list@iiug.org
> Subject: RE: Threadlib and Informix error -931
>
>
> $ finderr -931> -931 Cannot locate servicename service/tcp service in
> /etc/services.
>
> The service servicename is not listed in the network
> configuration file
> /etc/services (UNIX) or \\etc\\services (DOS). Check the
> $INFORMIXDIR/etc/sqlhosts file, and check that the service
> name for the
> desired server is correct. If so, contact your network
> administrator to
> find out why the service is not known. If you are using IBM Informix
> OnLine
> for NetWare, check the \\etc\\services file on the client for the
> required entries.
> $
>
> > -----Original Message-----
> > From: owner-informix-list@iiug.org
> > [mailto:owner-informix-list@iiug.org] On Behalf Of
> > gagan.haloi@gmail.com
> > Sent: 04 April 2005 10:26
> > To: informix-list@iiug.org
> > Subject: Threadlib and Informix error -931
> >
> > I am getting Informix error -931 and ISAM error -8 while
> using thread
> > lib in my program on HP11i server
> >
> > Find below a sample program
> > $>cat 1.ec
> > ==========
> > $include sqlca;
> > void main()
> > {
> > EXEC SQL DATABASE cdu_bookings;
> > printf("SQL: %d, ISAM: %d\\n", sqlca.sqlcode, sqlca.sqlerrd[1] );
> >
> > }
> >
> > Compile the program with and without the thread libraries
> > $>export THREADLIB=posix
> > $>esql -thread 1.ec -o 1_with_thread
> > $>esql 1.ec -o 1_no_thread
> >
> > If I run program "1_with_thread" it gives me SQL err -931 and ISAM
> > error -8.
> >
> > $>1_no_thread
> > SQL: 0, ISAM: 0
> >
> > $>1_with_thread
> > SQL: -931, ISAM: 8
> >
> > I have checked the /etc/services and sqlhost file. They are OK.
> >
> > Find below the comfiguration
> >
> > $>env|grep INF
> > INFORMIXDIR=/usr/informix_7.31UC
> > INFORMIXSERVER=dev25_srv> >
> > $>grep dev25_srv $INFORMIXDIR/sqlhosts
> > dev25_srv onsoctcp sterling.apis.dhl.com
> dev25_srv.exec
> > g=dev25_pri_grp
> >
> > $>grep "dev25_srv.exec" /etc/services
> > dev25_srv.exec 7104/tcp
> >
> > $>grep NETTYPE $INFORMIXDIR/etc/onconfig.dev25
> > NETTYPE soctcp,2,350,NET # Configure poll thread(s)> > for nettype
> >
> > $>grep -h Ver $INFORMIXDIR/etc/*-cr
> > INFORMIX LIBASF LIBRARY Version 9.30.HC1
> > INFORMIX ODBC LIBRARY Version 3.31.0000.HC1
> > INFORMIX-Client SDK Version 2.40.HC1
> > INFORMIX LIBDMI LIBRARY Version 2.20.HC1
> > INFORMIX EMBEDDED SQL for C Version 9.30.HC1
> > INFORMIX LIBGEN LIBRARY Version 9.30.HC1
> > INFORMIX LIBGLS LIBRARY Version 3.10.HC1
> > INFORMIX-4GL Interactive Debugger Version 7.30.HC4
> > INFORMIX-4GL Version 7.30.HC4P1
> > INFORMIX-4GL Rapid Development System Version 7.30.HC4P1
> > Informix Dynamic Server Version 7.31.UD6W4
> > INFORMIX-SQL Version 7.30.HC4P1
> > INFORMIX LIBOS LIBRARY Version 9.30.HC1
> > INFORMIX LIBSQL LIBRARY Version 9.30.HC1
> >
> > $>swlist -l product|grep lib
> > Curses-Color B.11.11 Curses library with
> color support
> > Judy-lib B.11.11.04.13 Judy Library and Related files
> > PHCO_23370 1.0 lint(1) library patch
> > PHCO_25569 1.0 libc cumulative header
> file patch
> > PHCO_27037 1.0 libpam_unix cumulative patch
> > PHCO_28481 1.0 cumulative 10.20 libc
> > compatibility support
> > PHCO_28605 1.0 libnss_files cumulative patch
> > PHCO_29028 1.0 libsec cumulative patch
> > PHCO_29328 1.0 libc manpage cumulative patch
> > PHCO_29955 1.0 libc cumulative patch
> > PHKL_26074 1.0 libaudit.a cumulative patch
> > PHKL_28765 1.0 VM panic with shared libs and
> > large pages
> > PHNE_23574 1.0 libnss_dns DNS backend patch
> > PHSS_24207 1.0 libm patch
> > PHSS_27367 1.0 Shared libF90 B.11.01.12
> > PHSS_27700 1.0 CPSlib Cumulative
> Patch (OMP V2.0
> > for 11.11)
> > PHSS_28880 1.0 HP aC++ -AA runtime
> > libraries (aCC
> > A.03.50)
> > libiconv 1.9.2 libiconv
> >
> > Please help me finding out the problem.
> >
> > Thanks
> > -Gagan
> >
> >
>
> Disclaimer
> http://www.shoprite.co.za/disclaimer.html
>
> sending to informix-list
>
Disclaimer
http://www.shoprite.co.za/disclaimer.html
sending to informix-list