Re: Shared Memory Initialisation Problem

Patrick You probably have Infomrix shared memory segments hanging around even after IDS is brought down. To check this, do a ipcs -m at the command prompt. You will need do run the ipcrm to delete the shared memory segments (and you will have to be root) which are owned by informix. I am assuming that you have a single instance on the box. If you have multiple instances you need to match the address using the segment key in your online log. HTH Sujit Patrick Herrera <patrickh@posit.com.au> on 06/02/99 11:49:32 PM Please respond to Patrick Herrera <patrickh@posit.com.au> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Shared Memory Initialisation Problem Hello all, Could anyone shed light on why I get the following messages in the online.log file every time I try to bring Informix on-line or to quiescent mode from off-line. 15:32:36 shmget: [EEXIST][17]: key 52644801: shared memory alreadyexists 15:32:36 mt_shm_init: can't create resident segment No matter how I shutdown the DB, for example from on-line to quiescent or directly to off-line (all using onmode), I am unable to restart it. The only solution I have found is to restart the entire system. My pressing problem is that after initiating a cold, full system restore, the DB was unable to come back up as part of the process: 15:16:55 Physical Restore of dbspc1, dbspc2, dbspc3 started. 15:17:07 Physical Restore of dbspc1, dbspc2, dbspc3 Completed. 15:17:08 Checkpoint Completed: duration was 0 seconds. 15:33:44 Shutdown Mode 15:33:45 Quiescent Mode 15:34:07 INFORMIX-OnLine Stopped. 15:37:23 shmget: [EEXIST][17]: key 52644801: shared memory alreadyexists 15:37:23 mt_shm_init: can't create resident segment We restarted the system and when Informix tried to come up we received the following errors: 15:55:17 INFORMIX-OnLine Initialized -- Shared Memory Initialized. 15:55:17 Physical Recovery Started. 15:55:23 Physical Recovery Complete: 368 Pages Restored. 15:55:23 Logical Recovery Started. 15:55:23 Checkpoint Record not Found in Logical Log. 15:55:24 Cannot Rollforward from Checkpoint. 15:55:24 INFORMIX-OnLine Stopped. 15:55:24 mt_shm_remove: WARNING: may not have removed all/correctsegments Can anyone help me fix this problem? Logical log backups have not been made because the data is all relatively easy to recreate. Our Informix version is INFORMIX-OnLine Dynamic Server 7.12.UC1 running on Solaris 2.5 on a SPARC system. Most of the settings, inc. shared memory are the defaults. Thanks in advance, Patrick ______________________________________________ THE DIGITAL MAGE Technical & development wizardry for New Media solutions Suite 24, Level 2 Ph: (03) 62 24 3535 "City Mill Building" Fax: (03) 62 24 3545 11 Morrison Street Hobart, TAS 7000 Email: patrickh@posit.com.au