Re: sql causes server crash

Try this at your statement select "$INFORMIXSERVER", current zeitpunkt, round (sum(cumtime*0.000001),0) Habichtsberg, Reinhard wrote: >Trying to get data from sysmaster (dbtest1) and store them in a database on >a second server (dbtest2) I created a query: > >Script runs on dbtest2. > >#!/bin/sh ># waits_error.sh >. /home/informix/.informix2.rc # set environment >exec dbaccess onstat@dbtest1_tli - <<eof >insert into onstat@dbtest1_tli:waittab >select "$INFORMIXSERVER", current zeitpunkt, round (sum(cumtime/1000000),0) >, reason >from sysmaster@dbtest2_tli:sysseswts where reason != "condition" >and cumtime > 1000 >and sid not in ( select sid from sysmaster@dbtest2_tli:syssessions where pid>= $ >$ ) >group by 2,4; >eof > >Running the query causes a reproducible crash of the server (dbtest2). > >Solaris 9, IDS 9.40FC4 > >Feels for me like a bug that the server crashes. Or is it simply silly to >put queries on sysmaster in this way because it's not a real database but a >shared memory structure? > >Any comments are welcome, >Reinhard. > >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list > > > > >