strange session

When i start IDS7.30.FC7 on HP 11: oninit -sinto quiescent mode, my logfile shows: 07:18:39 Quiescent Mode 07:18:39 Checkpoint Completed: duration was 1 seconds. 07:19:01 (20) connection rejected - no calls allowed for sqlexec 07:19:01 listener-thread: err = -27002: oserr = 0: errstr = : Noconnections are allowed in Dynamic Server quiescent mode. 07:20:26 (23) connection rejected - no calls allowed for sqlexec 07:20:26 listener-thread: err = -27002: oserr = 0: errstr = : Noconnections are allowed in Dynamic Server quiescent mode. and so on . and when i put informix into on-line state my logical logs are filling very fast and there is no session in informix ! In my opinion session that fill logical logs ( an trying to connect to IDS in quiescent mode ) is session 53: $ o -g ses Informix Dynamic Server Version 7.30.FC7 -- Quiescent -- Up 00:18:47 -- 655103 2 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 53 informix - 0 - 0 8192 6160 15 informix - 0 - 0 8192 6160 14 informix - 0 - 0 32768 26368 13 informix - 0 - 0 32768 26368 12 informix - 0 - 0 8192 6160 11 informix - 0 - 0 8192 6160 10 informix - 0 - 0 8192 6160 9 informix - 0 - 0 32768 26368 8 informix - 0 - 0 32768 26368 7 informix - 0 - 0 8192 6160 6 informix - 0 - 0 8192 6160 5 informix - 0 - 0 8192 6160 4 informix - 0 - 0 8192 6160 3 informix - 0 - 0 8192 6160 2 informix - 0 - 0 8192 6160 $ o -g ses 53 Informix Dynamic Server Version 7.30.FC7 -- Quiescent -- Up 00:19:37 -- 655103 2 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 53 informix - 0 - 0 8192 6160 Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 53 V c000000132720028 8192 2032 8 1 name free used name free used overhead 0 200 scb 0 144 ostcb 0 64 sqscb 0 5672 fragman 0 80 in few seconds interval that session change its number +1 what happened and why ?

In article <37E47826.1E9515D0@wsisiz.edu.pl>, edem <sztuka@wsisiz.edu.pl> wrote: > When i start IDS7.30.FC7 on HP 11: > oninit -s> into quiescent mode, my logfile shows: > > 07:18:39 Quiescent Mode > 07:18:39 Checkpoint Completed: duration was 1 seconds. > 07:19:01 (20) connection rejected - no calls allowed for sqlexec > 07:19:01 listener-thread: err = -27002: oserr = 0: errstr = : No> connections are allowed in Dynamic Server quiescent mode. > > 07:20:26 (23) connection rejected - no calls allowed for sqlexec > 07:20:26 listener-thread: err = -27002: oserr = 0: errstr = : No> connections are allowed in Dynamic Server quiescent mode. > > and so on . > and when i put informix into on-line state my logical logs are filling > very fast and there is no session in informix ! > In my opinion session that fill logical logs ( an trying to connect to > IDS in quiescent mode ) is session 53: > > $ o -g ses> > Informix Dynamic Server Version 7.30.FC7 -- Quiescent -- Up 00:18:47 > -- 655103 > 2 Kbytes > > session #RSAM total used > id user tty pid hostname threads memory memory > 53 informix - 0 - 0 8192 6160 > 15 informix - 0 - 0 8192 6160 > 14 informix - 0 - 0 32768 26368 > 13 informix - 0 - 0 32768 26368 > 12 informix - 0 - 0 8192 6160 > 11 informix - 0 - 0 8192 6160 > 10 informix - 0 - 0 8192 6160 > 9 informix - 0 - 0 32768 26368 > 8 informix - 0 - 0 32768 26368 > 7 informix - 0 - 0 8192 6160 > 6 informix - 0 - 0 8192 6160 > 5 informix - 0 - 0 8192 6160 > 4 informix - 0 - 0 8192 6160 > 3 informix - 0 - 0 8192 6160 > 2 informix - 0 - 0 8192 6160 > > $ o -g ses 53> > Informix Dynamic Server Version 7.30.FC7 -- Quiescent -- Up 00:19:37 > -- 655103 > 2 Kbytes > > session #RSAM total used > id user tty pid hostname threads memory memory > 53 informix - 0 - 0 8192 6160 > > Memory pools count 1 > name class addr totalsize freesize #allocfrag > #freefrag > 53 V c000000132720028 8192 2032 8 1 > > name free used name free used > overhead 0 200 scb 0 144 > ostcb 0 64 sqscb 0 5672 > fragman 0 80 > > in few seconds interval that session change its number +1 > what happened and why ? > > There is too low information. Please, send more log and onstat -a. -- With best regards, Yuri Dovgart, SAP R/3, Informix consultant, "Telecominvest" company. E-mail y_dovgart@tci.ukrtel.net Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

Those messages in the log indicate that some user process is trying to attach to the engine while it is in Quiescent mode, a no-no. I take it that the messages stop as soon as you place the engine in ONLINE mode (onmode -m)? Exactly what that user informix session is I cannot guess but since it comes back every minute or so I'd guess some script that is trying to perform some task in a loop checking return codes until it succeeds. Or a task with a CONNECT statement running with INFORMIXCONTIME and INFORMIXCONRETRY set so that it repeatedly retries the CONNECT automatically periodically until it succeeds. Annoying but probably harmless and possibly desireable if that process MUST run when the engine returns to online status. Art S. Kagel edem wrote: > > When i start IDS7.30.FC7 on HP 11: > oninit -s> into quiescent mode, my logfile shows: > > 07:18:39 Quiescent Mode > 07:18:39 Checkpoint Completed: duration was 1 seconds. > 07:19:01 (20) connection rejected - no calls allowed for sqlexec > 07:19:01 listener-thread: err = -27002: oserr = 0: errstr = : No> connections are allowed in Dynamic Server quiescent mode. > > 07:20:26 (23) connection rejected - no calls allowed for sqlexec > 07:20:26 listener-thread: err = -27002: oserr = 0: errstr = : No> connections are allowed in Dynamic Server quiescent mode. > > and so on . > and when i put informix into on-line state my logical logs are filling > very fast and there is no session in informix ! > In my opinion session that fill logical logs ( an trying to connect to > IDS in quiescent mode ) is session 53: > > $ o -g ses> > Informix Dynamic Server Version 7.30.FC7 -- Quiescent -- Up 00:18:47 > -- 655103 > 2 Kbytes > > session #RSAM total used > id user tty pid hostname threads memory memory > 53 informix - 0 - 0 8192 6160 > 15 informix - 0 - 0 8192 6160 > 14 informix - 0 - 0 32768 26368 > 13 informix - 0 - 0 32768 26368 > 12 informix - 0 - 0 8192 6160 > 11 informix - 0 - 0 8192 6160 > 10 informix - 0 - 0 8192 6160 > 9 informix - 0 - 0 32768 26368 > 8 informix - 0 - 0 32768 26368 > 7 informix - 0 - 0 8192 6160 > 6 informix - 0 - 0 8192 6160 > 5 informix - 0 - 0 8192 6160 > 4 informix - 0 - 0 8192 6160 > 3 informix - 0 - 0 8192 6160 > 2 informix - 0 - 0 8192 6160 > > $ o -g ses 53> > Informix Dynamic Server Version 7.30.FC7 -- Quiescent -- Up 00:19:37 > -- 655103 > 2 Kbytes > > session #RSAM total used > id user tty pid hostname threads memory memory > 53 informix - 0 - 0 8192 6160 > > Memory pools count 1 > name class addr totalsize freesize #allocfrag > #freefrag > 53 V c000000132720028 8192 2032 8 1 > > name free used name free used > overhead 0 200 scb 0 144 > ostcb 0 64 sqscb 0 5672 > fragman 0 80 > > in few seconds interval that session change its number +1 > what happened and why ?