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