Re: I can't kill a session - pl. help

Accordingly to the output of your onstat command, the Application logged a Begin Work, then after you issue the onmode -z, actually Informix will need to rollback the work for that session, now my question is, Have you checked that log space is available for that rollback?. That might be the reason, probably your process has logged many sql statements and it needs space to roll them back. Regards, Mario Estrada >> -----Original Message----- >> From: Abhay Mannur [SMTP:abhay@cheerful.com] >> Sent: Friday, August 28, 1998 3:08 AM >> To: Informix Mailing List >> Subject: I can't kill a session - pl. help >> >> Hi All, >> I can't kill the following session using onmode -z . >> why ? >> Is shutting down the Informix server the only option ? >> Thanks in advance. >> Abhay Mannur. >> >> INFORMIX-OnLine Version 7.23.UC4 -- On-Line -- Up 8 days 22:28:05 -- >> 822760 Kbytes >> >> session #RSAM total used >> id user tty pid hostname threads memory memory >> 63206 aes 152 ystmiche 1 1900544 1337272 >> >> tid name rstcb flags curstk status >> 89818 sqlexec 9f2f4398 --BP--- 28848 9f2f4398 running >> >> Memory pools count 1 >> name class addr totalsize freesize #allocfrag #freefrag >> Changing data structure forced command termination. >> >