Urgent help requested

Just on case somebody is reading the list mail in this moment.... Solaris 9 Sparc... IDS 9.40 FC2 ... One session issue a query that requested huge memory ammounts. Now anybody can't work with the database.. I tried to kill process onmode -z pid, shutdown instance onmode -u, onmode -k, and some other tries but none of that commands can work. Any idea of how to kill the session or sutdown the instance. Thanks a lot

If nothing else works kill -9 the main oninit process (the one with a parent pid of '1' ). Once all of the oninits are gone, run onmode -ky to remove shared memory and you should be able to restart normally. Art On Fri, Jul 11, 2008 at 8:08 PM, nestor gomez munoz <nestorgm@prodigy.net.mx> wrote: > Just on case somebody is reading the list mail in this moment.... > > Solaris 9 Sparc... IDS 9.40 FC2 ... > One session issue a query that requested huge memory ammounts. Now > anybody can't work with the database.. I tried to kill process onmode > -z pid, shutdown instance onmode -u, onmode -k, and some other tries but > none of that commands can work. > > Any idea of how to kill the session or sutdown the instance. > > Thanks a lot > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

If multiple instances try and kill -9 on pid for cpu: $onstat -g glo IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 08:22:30 -- 165984 Kbytes MT global info: sessions threads vps lngspins 0 24 12 5 sched calls thread switches yield 0 yield n yield forever total: 15449605 10266555 5250931 237947 6512858 per sec: 0 0 0 0 0 Virtual processor summary: class vps usercpu syscpu total cpu 1 1184.69 196.17 1380.86 aio 4 0.87 2.20 3.07 shm 1 0.26 0.56 0.82 lio 1 0.20 0.56 0.76 pio 1 0.20 0.55 0.75 adm 1 0.88 1.42 2.30 soc 2 8.09 18.62 26.71 msc 1 0.29 0.10 0.39 total 12 1195.48 220.18 1415.66 Individual virtual processors: vp pid class usercpu syscpu total 1 22288 cpu 1184.69 196.17 1380.86 2 21808 adm 0.88 1.42 2.30 3 27362 lio 0.20 0.56 0.76 4 17008 pio 0.20 0.55 0.75 5 14286 aio 0.32 0.70 1.02 6 29694 msc 0.29 0.10 0.39 7 27742 aio 0.20 0.55 0.75 8 23274 aio 0.17 0.47 0.64 9 33712 aio 0.18 0.48 0.66 10 31540 soc 5.00 12.21 17.21 11 28160 soc 3.09 6.41 9.50 12 29954 shm 0.26 0.56 0.82 tot 1195.48 220.18 1415.66 *************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: eknox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com " It's always a great day to watch Football ! " *************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, July 11, 2008 7:14 PM To: ids@iiug.org Subject: Re: Urgent help requested [12676] If nothing else works kill -9 the main oninit process (the one with a parent pid of '1' ). Once all of the oninits are gone, run onmode -ky to remove shared memory and you should be able to restart normally. Art On Fri, Jul 11, 2008 at 8:08 PM, nestor gomez munoz <nestorgm@prodigy.net.mx> wrote: > Just on case somebody is reading the list mail in this moment.... > > Solaris 9 Sparc... IDS 9.40 FC2 ... > One session issue a query that requested huge memory ammounts. Now > anybody can't work with the database.. I tried to kill process onmode > -z pid, shutdown instance onmode -u, onmode -k, and some other tries but > none of that commands can work. > > Any idea of how to kill the session or sutdown the instance. > > Thanks a lot > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks Art and Ernest. I didnt want to reach the extreme resource of kill -9. However, thats what I did, but killed all of the oninit's PID in the same command. ¿is that even more dangerous? --Nestor El vie, 11-07-2008 a las 20:13 -0400, Art Kagel escribió: > If nothing else works kill -9 the main oninit process (the one with a parent > pid of '1' ). Once all of the oninits are gone, run onmode -ky to remove > shared memory and you should be able to restart normally. > > Art > > On Fri, Jul 11, 2008 at 8:08 PM, nestor gomez munoz <nestorgm@prodigy.net.mx> > wrote: > > > Just on case somebody is reading the list mail in this moment.... > > > > Solaris 9 Sparc... IDS 9.40 FC2 ... > > One session issue a query that requested huge memory ammounts. Now > > anybody can't work with the database.. I tried to kill process onmode > > -z pid, shutdown instance onmode -u, onmode -k, and some other tries but > > none of that commands can work. > > > > Any idea of how to kill the session or sutdown the instance. > > > > Thanks a lot > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > >

No, just usually unnecessary that's all. Once you kill the primary oninit the others will exit. Art On Fri, Jul 11, 2008 at 9:58 PM, nestor gomez munoz <nestorgm@prodigy.net.mx> wrote: > Thanks Art and Ernest. > I didnt want to reach the extreme resource of kill -9. However, thats > what I did, but killed all of the oninit's PID in the same command. ¿is > that even more dangerous? > > --Nestor > > El vie, 11-07-2008 a las 20:13 -0400, Art Kagel escribió: > > If nothing else works kill -9 the main oninit process (the one with a > parent > > pid of '1' ). Once all of the oninits are gone, run onmode -ky to remove > > shared memory and you should be able to restart normally. > > > > Art > > > > On Fri, Jul 11, 2008 at 8:08 PM, nestor gomez munoz > <nestorgm@prodigy.net.mx> > > wrote: > > > > > Just on case somebody is reading the list mail in this moment.... > > > > > > Solaris 9 Sparc... IDS 9.40 FC2 ... > > > One session issue a query that requested huge memory ammounts. Now > > > anybody can't work with the database.. I tried to kill process onmode > > > -z pid, shutdown instance onmode -u, onmode -k, and some other tries > but > > > none of that commands can work. > > > > > > Any idea of how to kill the session or sutdown the instance. > > > > > > Thanks a lot > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.