Re: Informix Connect
Here's the "pei" log:
2004-04-21 23:19:56.370000 Starting Daemon INFORMIX-SQL Version
7.23.UC13
Command Line = /usr/informix/lib/sqlexecd pei -l /tmp/pei.log
INFORMIXDIR = /usr/informix
dbservername = pei
nettype = setlitcp
hostname = eptsco
servicename = sqlexec
options =
2004-04-21 23:33:59.840000 sqlexec eptsco informix -p(null)
2004-04-21 23:34:02.340000 sqlexec eptsco informix -p(null)
2004-04-21 23:34:34.100000 sqlexec eptsco informix -p(null)
2004-04-21 23:36:28.270000 sqlexec eptsco informix -p(null)
2004-04-21 23:36:52.370000 sqlexec eptsco informix -p(null)
2004-04-21 23:39:20.860000 sqlexec eptsco informix -p(null)
2004-04-21 23:39:33.140000 sqlexec eptsco informix -p(null)
2004-04-21 23:40:52.890000 sqlexec eptsco informix -p(null)
2004-04-21 23:41:22.680000 sqlexec eptsco informix -p(null)
2004-04-21 23:42:01.200000 sqlexec eptsco informix -p(null)
2004-04-21 23:42:07.650000 sqlexec eptsco informix -p(null)
2004-04-21 23:42:59.320000 sqlexec eptsco informix -p(null)
2004-04-21 23:45:48.410000 sqlexec eptsco informix -p(null)
2004-04-21 23:49:32.880000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:35.200000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:36.300000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:38.550000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:42.470000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:44.570000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:48.160000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:49.630000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:55.250000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:56.860000 sqlexec eptsco informix -p(null)
2004-04-21 23:58:59.510000 sqlexec eptsco informix -p(null)
2004-04-21 23:59:00.320000 sqlexec eptsco informix -p(null)
2004-04-21 23:59:02.350000 sqlexec eptsco informix -p(null)
2004-04-21 23:59:04.280000 sqlexec eptsco informix -p(null)
2004-04-21 23:59:06.800000 sqlexec eptsco informix -p(null)
2004-04-22 01:00:03.890000 sqlexec eptsco informix -p(null)
2004-04-22 23:19:55.060000 Starting Daemon INFORMIX-SQL Version
7.23.UC13
Command Line = /usr/informix/lib/sqlexecd pei -l /tmp/pei.log
INFORMIXDIR = /usr/informix
dbservername = pei
nettype = setlitcp
hostname = eptsco
servicename = sqlexec
options =
2004-04-22 23:33:45.560000 sqlexec eptsco informix -p(null)
2004-04-22 23:33:48.900000 sqlexec eptsco informix -p(null)
2004-04-22 23:34:21.780000 sqlexec eptsco informix -p(null)
2004-04-22 23:36:20.420000 sqlexec eptsco informix -p(null)
2004-04-22 23:36:45.330000 sqlexec eptsco informix -p(null)
2004-04-22 23:39:16.680000 sqlexec eptsco informix -p(null)
2004-04-22 23:39:30.420000 sqlexec eptsco informix -p(null)
2004-04-22 23:41:06.390000 sqlexec eptsco informix -p(null)
2004-04-22 23:41:37.690000 sqlexec eptsco informix -p(null)
2004-04-22 23:42:17.600000 sqlexec eptsco informix -p(null)
2004-04-22 23:42:24.620000 sqlexec eptsco informix -p(null)
2004-04-22 23:43:19.480000 sqlexec eptsco informix -p(null)
2004-04-22 23:46:11.960000 sqlexec eptsco informix -p(null)
2004-04-22 23:49:59.610000 sqlexec eptsco informix -p(null)
2004-04-22 23:58:47.760000 sqlexec eptsco informix -p(null)
2004-04-22 23:58:48.810000 sqlexec eptsco informix -p(null)
2004-04-22 23:58:51.110000 sqlexec eptsco informix -p(null)
2004-04-22 23:58:55.000000 sqlexec eptsco informix -p(null)
2004-04-22 23:58:56.650000 sqlexec eptsco informix -p(null)
2004-04-22 23:58:59.580000 sqlexec eptsco informix -p(null)
2004-04-22 23:59:00.740000 sqlexec eptsco informix -p(null)
2004-04-22 23:59:06.090000 sqlexec eptsco informix -p(null)
2004-04-22 23:59:07.600000 sqlexec eptsco informix -p(null)
2004-04-22 23:59:09.390000 sqlexec eptsco informix -p(null)
2004-04-22 23:59:10.320000 sqlexec eptsco informix -p(null)
2004-04-22 23:59:12.580000 sqlexec eptsco informix -p(null)
2004-04-22 23:59:14.820000 sqlexec eptsco informix -p(null)
2004-04-22 23:59:17.730000 sqlexec eptsco informix -p(null)
2004-04-23 01:00:04.000000 sqlexec eptsco informix -p(null)
And here's the "pei2" log:
2004-04-21 23:19:56.400000 Starting Daemon INFORMIX-SQL Version
7.23.UC13
Command Line = /usr/informix/lib/sqlexecd pei2 -l /tmp/pei2.log
INFORMIXDIR = /usr/informix
dbservername = pei2
nettype = setlitcp
hostname = eptsco
servicename = sqlexe2
options =
2004-04-22 23:19:55.100000 Starting Daemon INFORMIX-SQL Version
7.23.UC13
Command Line = /usr/informix/lib/sqlexecd pei2 -l /tmp/pei2.log
INFORMIXDIR = /usr/informix
dbservername = pei2
nettype = setlitcp
hostname = eptsco
servicename = sqlexe2
options =
What now?
Thanks,
Tom
On Wed, 21 Apr 2004 15:02:31 -0400, "Art S. Kagel"
<kagel@bloomberg.net> wrote:
>On Wed, 21 Apr 2004 16:01:59 -0400, Tom wrote:
>
>> I think I got it...
>
>Yes, that's it.
>
>> #!/bin/ksh
>> # S90informixse
>> # startup/shutdown informix standard engine daemon # #
>> ******************************************************************* # # VER
>> DATE WHO COMMENTS
>> #
>> # 1.0 03-03-1996 CXT First write.
>> # 1.1 01-02-1997 CXT Change default informix server name to standard
>> "pei".
>>
>>
>> # ******************* STANDARD ENGINE 7 PROCESS *********************
>>
>> case $1 in # test 1st argument
>> start ) INFORMIXDIR=${INFORMIXDIR:-"/usr/informix"} # set informix
>> dir
>> export INFORMIXDIR # export
>> variable
>> SQLEXEC=$INFORMIXDIR/lib/sqlexec # define engine
>> export SQLEXEC # export
>> variable
>> INFORMIXSERVER=pei # define server>> export INFORMIXSERVER # export
>> variable
>> $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the
>> daemon
>> INFORMIXSERVER=pei2 # define>> server
>> export INFORMIXSERVER # export
>> variable
>> $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the
>> daemon
>> ;; # terminator
>> stop ) ;; # do nothing if
>> shutdown
>> esac # end-case test
>>
>> # ******************* END OF SCRIPT *********************************
>>
>> It doesn't look like it is logging to me.
>
>No, it's not. If it was the line would look like:
>
>$INFORMIXDIR/lib/sqlexecd -l $INFORMIXDIR/sqexecd.log $INFORMIXSERVER
>
>if memory serves (it's been awhile).
>
>Art S. Kagel