Re: shmget: [EEXIST][17]: key XXXXXXXX: shared memory already exists ERROR

June, Jarrod's right. Change INFORMIXSERVER to prod117_shm and try to run the onclean -ky and then oninit -v again. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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 Tue, Jan 11, 2011 at 3:49 PM, Jarrod Teale <Jarrod.Teale@fonterra.com>wrote: > June - I haven't seen that before. > Are you sure that the $INFORMIXSERVER variable is not set for the network > connection, but for the shared memory? > It looks like the onclean process is trying to connect through the > prod117_net alias name. > Maybe post your sqlhosts file for these two alias entries? > > Jarrod > > ------------------------------ > *From:* June Nebab LKINY [mailto:jnebab@idealcut.com] > *Sent:* Wednesday, 12 January 2011 9:42 a.m. > *To:* informix-list > *Cc:* Jarrod Teale > *Subject:* Re: shmget: [EEXIST][17]: key XXXXXXXX: shared memory already > exists ERROR > > onclean -ky results: > > onclean: Cleaning up processes and resources for 'prod117_net'... > onclean: Cannot open the file /u/informix/11_7/etc/.conf.prod117_net. > Ensure that the value of the INFORMIXSERVER environment variable > matches the value of the DBSERVERNAME configuration parameter > from your onconfig file. > > The ".conf.prod117_net" file does not exist for some reason. > > $INFORMIXSERVER = prod117_shm > DBSERVERNAME = prod117_shm > DBSERVERALIASES = prod117_net> > IDS 11.7 UC1GE > > > ------------------------------------- > June A. Nebab > IBM Informix DBA/Linux System Admin > Lazare Kaplan International Inc. > 19 W 44th Street > New York, NY 10036 > 800-554-3325 > 212-972-9700 > > "The World's Most Beautiful Diamond" > www.lazarediamonds.com > > ----- Original Message ----- > From: "Jarrod Teale" <Jarrod.Teale@fonterra.com> > To: "informix-list" <informix-list@iiug.org> > Sent: Tuesday, January 11, 2011 3:26:41 PM GMT -05:00 US/Canada Eastern > Subject: RE: shmget: [EEXIST][17]: key XXXXXXXX: shared memory already > exists ERROR > > If you are on version 11, try running "onclean -ky". It will rip out all of > the memory segments for you. > > Always post version and platform. > > > ------------------------------ > *From:* informix-list-bounces@iiug.org [mailto: > informix-list-bounces@iiug.org] *On Behalf Of *June Nebab LKINY > *Sent:* Wednesday, 12 January 2011 9:25 a.m. > *To:* informix-list > *Subject:* shmget: [EEXIST][17]: key XXXXXXXX: shared memory already > exists ERROR > > I can not bring up engine due to the following message: > > shmget: [EEXIST][17]: key XXXXXXXX: shared memory already exists > mt_shm_init: can't create resident segment > > I ran "ipcs -m" and found the shared memory segment ID and key and cleaned > it with "ipcrm -m <shmkeyid>" but the error persists and IDS engine is not > starting up. > > Tried changing SERVERNUM but error persists. > > It is strange since I did not reboot the server nor did not change any > onconfig parameter. > > > *DISCLAIMER* > > This transmission and the information contained herein and/or in any > attachments hereto and/or in any attachments thereto is privileged and/or > confidential and is intended ONLY for the use of the individual(s) and/or > entity(s) named above. If you are not the intended recipient, you are > strictly prohibited from disclosing, printing, copying, using or > disseminating this transmission and/or any such attachments and any > information contained in this transmission and/or in any such attachments. > ANY unauthorized interception of this transmission and/or any such > attachments is a violation of federal criminal law. > > If you have received this transmission in error please notify the sender > immediately and delete the transmission and all such attachments. > > > _______________________________________________ Informix-list mailing list > Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list > *DISCLAIMER* > > This transmission and the information contained herein and/or in any > attachments hereto and/or in any attachments thereto is privileged and/or > confidential and is intended ONLY for the use of the individual(s) and/or > entity(s) named above. If you are not the intended recipient, you are > strictly prohibited from disclosing, printing, copying, using or > disseminating this transmission and/or any such attachments and any > information contained in this transmission and/or in any such attachments. > ANY unauthorized interception of this transmission and/or any such > attachments is a violation of federal criminal law. > > If you have received this transmission in error please notify the sender > immediately and delete the transmission and all such attachments. > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >