Instance in Initialization mode

Hi, Below is the server details: informix 9.40.FC8 HP UX B.11.11 U 9000/800 The instance was in CKPT REQD mode with BLOCKED checkpoint archive. We tried to restart the instance. While bringing it down the following message was captured. 14:54:47 WARNING: Checkpoint appears stalled and may not complete before the database server shuts down. 14:54:48 IBM Informix Dynamic Server Stopped. Now when we tried to start the instance again,it goes in initialization mode. IBM Informix Dynamic Server Version 9.40.FC8 -- Initialization -- Up 00:05:44 -- 75580 Kbytes We tried to get the instance down using onmode -ucky it gives the following warning: onmode: Shutdown of the database server shall be done by killing the database server processes, as the database server is in Initialization mode and cannot accept onmode commands. We tried kill the oninit processes through root login but that too failed. Now we are not able to either start or stop the instance. Any quick response on this is highly appreciated. Thanks in advance. Regards, Sushant

1. ipcs to display the shared memory segments for your instance. 2. ipcrm -m <shm_id> (execute as root and make sure you got the right id) 3. prepare for the worse (I don't know how the instance was violated, but you just have to prepare for the worse, you may have to restore the instance) ________________________________ From: SUSHANT KODE <ksushants@gmail.com> To: ids@iiug.org Sent: Friday, April 26, 2013 11:04 AM Subject: Instance in Initialization mode [30139] Hi, Below is the server details: informix 9.40.FC8 HP UX B.11.11 U 9000/800 The instance was in CKPT REQD mode with BLOCKED checkpoint archive. We tried to restart the instance. While bringing it down the following message was captured. 14:54:47 WARNING: Checkpoint appears stalled and may not complete before the database server shuts down. 14:54:48 IBM Informix Dynamic Server Stopped. Now when we tried to start the instance again,it goes in initialization mode. IBM Informix Dynamic Server Version 9.40.FC8 -- Initialization -- Up 00:05:44 -- 75580 Kbytes We tried to get the instance down using onmode -ucky it gives the following warning: onmode: Shutdown of the database server shall be done by killing the database server processes, as the database server is in Initialization mode and cannot accept onmode commands. We tried kill the oninit processes through root login but that too failed. Now we are not able to either start or stop the instance. Any quick response on this is highly appreciated. Thanks in advance. Regards, Sushant ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

ipcs is not an issue. When I shutdown the instance, all the memory segments are closed in ipcs but the oninit processes at the OS level remain intact. We are not able to kill these oninit processes even thru root login.

Kill -9 will always work, but as has been said, be prepared to maybe have to restore a recent archive and roll forward your logical logs. So, I sincerely hope that you have good archives that have been verified, that you backup your logical logs religiously and keep them for at least two archives back (in case the most recent archive has been trashed somehow), and finally that all of your databases are logged - preferably using unbuffered logging. If some of these points are not true, I hope that you have extended support from IBM for you out-of-support version! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Apr 26, 2013 at 12:50 PM, SUSHANT KODE <ksushants@gmail.com> wrote: > ipcs is not an issue. When I shutdown the instance, all the memory segments > are closed in ipcs but the oninit processes at the OS level remain intact. > We > are not able to kill these oninit processes even thru root login. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01228d680e357c04db46c781