RE: 2nd instance problem - still looking at 1st instance

INFORMIXDIR should be the same for both instances and I am setting both INFORMIXSERVER and ONCONFIG. And I have confirmed that they really are being set (both by echo'ing the vars and with env | grep'ping for them) -----Original Message----- From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] Sent: Thursday, June 16, 2005 5:22 PM To: Danny Wright; ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5173] Something in your environment isn't being reset. How are you resetting $INFORMIXDIR and $INFORMIXSERVER? -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Danny Wright Sent: Thursday, June 16, 2005 3:51 PM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5173] Already done - the first instance is SERVERNUM 0, the 2nd is SERVERNUM 1 -----Original Message----- From: Palmer, George [mailto:George.Palmer@pegs.com] Sent: Thursday, June 16, 2005 4:12 PM To: Danny Wright; ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5171] Change the SERVERNUM ( two instances can not use the same SERVERNUM on the same machine ) George -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Danny Wright Sent: Thursday, June 16, 2005 12:59 PM To: ids@iiug.org Subject: 2nd instance problem - still looking at 1st instance [5171] After I set up one instance and everything seems to be working, I attempted to create a 2nd one. I have entries in /etc/services for both instances. I have entries in /informix/etc/sqlhosts for both. I have unique values for ROOTPATH, MSGPATH, SERVERNUM, DBSERVERNAME and DBSERVERALIASES in my config files (there is no mirroring). And finally, I am changing the INFORMIXSERVER and ONCONFIG environment variables when I attempt to switch instances. I've created separate links to my logical volumes and I've double-checked that they are not pointing to the same ones. But, when I do an onstat -d in the 2nd instance, it shows me information from the first instance. I've just gotten off the phone with our software vendor (who we are supposed to have Informix support through), but they were absolutely NO help - after 45 minutes, all I got was a useless document (their's, not Informix's) telling me to do what I had already done. Environment: AIX 5.3 IDS 9.40 Thanks in advance,

Danny May be unrelated, bt I have a vague recollection that using SERVERNUM 0 is a bad idea.Throw some information back:- relevant SGLHOSTS entries relevant /etc/services entries relevant environment details from each environment (are you correctly exporting the variables?) DBSERVERNAME/ALIASES and NUM from each instance. Keith -> -----Original Message----- -> From: Danny Wright [mailto:dwright@sherwoodfoods.com] -> Sent: Thursday, June 16, 2005 10:49 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5175] -> -> INFORMIXDIR should be the same for both instances and I am -> setting both -> INFORMIXSERVER and ONCONFIG. -> -> And I have confirmed that they really are being set (both -> by echo'ing the -> vars and with env | grep'ping for them) -> -> -----Original Message----- -> From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] -> Sent: Thursday, June 16, 2005 5:22 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5173] -> -> Something in your environment isn't being reset. -> -> How are you resetting $INFORMIXDIR and $INFORMIXSERVER? -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 3:51 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5173] -> -> Already done - the first instance is SERVERNUM 0, the 2nd is -> SERVERNUM 1 -> -> -----Original Message----- -> From: Palmer, George [mailto:George.Palmer@pegs.com] -> Sent: Thursday, June 16, 2005 4:12 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5171] -> -> Change the SERVERNUM ( two instances can not use the same -> SERVERNUM on -> the same machine ) -> -> George -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 12:59 PM -> To: ids@iiug.org -> Subject: 2nd instance problem - still looking at 1st instance [5171] -> -> After I set up one instance and everything seems to be working, I -> attempted to create a 2nd one. -> -> I have entries in /etc/services for both instances. -> -> I have entries in /informix/etc/sqlhosts for both. -> -> I have unique values for ROOTPATH, MSGPATH, SERVERNUM, -> DBSERVERNAME and -> DBSERVERALIASES in my config files (there is no mirroring). -> -> And finally, I am changing the INFORMIXSERVER and ONCONFIG -> environment -> variables when I attempt to switch instances. -> -> I've created separate links to my logical volumes and I've -> double-checked that they are not pointing to the same ones. -> -> But, when I do an onstat -d in the 2nd instance, it shows me -> information -> from the first instance. -> -> -> I've just gotten off the phone with our software vendor (who we are -> supposed to have Informix support through), but they were -> absolutely NO -> help - after -> 45 minutes, all I got was a useless document (their's, not -> Informix's) -> telling me to do what I had already done. -> -> Environment: -> -> AIX 5.3 -> IDS 9.40 -> -> Thanks in advance, -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **

Hi, I am using 0 as SERVERNUM without any problem. Are you using the same informix user for both instances? Diane Lavoie -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Simmons, Keith Sent: Friday, June 17, 2005 3:59 AM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5178] Danny May be unrelated, bt I have a vague recollection that using SERVERNUM 0 is a bad idea. Throw some information back:- relevant SGLHOSTS entries relevant /etc/services entries relevant environment details from each environment (are you correctly exporting the variables?) DBSERVERNAME/ALIASES and NUM from each instance. Keith -> -----Original Message----- -> From: Danny Wright [mailto:dwright@sherwoodfoods.com] -> Sent: Thursday, June 16, 2005 10:49 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st instance -> [5175] -> -> INFORMIXDIR should be the same for both instances and I am setting -> both INFORMIXSERVER and ONCONFIG. -> -> And I have confirmed that they really are being set (both by -> echo'ing the vars and with env | grep'ping for them) -> -> -----Original Message----- -> From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] -> Sent: Thursday, June 16, 2005 5:22 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st instance -> [5173] -> -> Something in your environment isn't being reset. -> -> How are you resetting $INFORMIXDIR and $INFORMIXSERVER? -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 3:51 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st instance -> [5173] -> -> Already done - the first instance is SERVERNUM 0, the 2nd is -> SERVERNUM 1 -> -> -----Original Message----- -> From: Palmer, George [mailto:George.Palmer@pegs.com] -> Sent: Thursday, June 16, 2005 4:12 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st instance -> [5171] -> -> Change the SERVERNUM ( two instances can not use the same SERVERNUM -> on the same machine ) -> -> George -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 12:59 PM -> To: ids@iiug.org -> Subject: 2nd instance problem - still looking at 1st instance [5171] -> -> After I set up one instance and everything seems to be working, I -> attempted to create a 2nd one. -> -> I have entries in /etc/services for both instances. -> -> I have entries in /informix/etc/sqlhosts for both. -> -> I have unique values for ROOTPATH, MSGPATH, SERVERNUM, DBSERVERNAME -> and DBSERVERALIASES in my config files (there is no mirroring). -> -> And finally, I am changing the INFORMIXSERVER and ONCONFIG -> environment variables when I attempt to switch instances. -> -> I've created separate links to my logical volumes and I've -> double-checked that they are not pointing to the same ones. -> -> But, when I do an onstat -d in the 2nd instance, it shows me -> information from the first instance. -> -> -> I've just gotten off the phone with our software vendor (who we are -> supposed to have Informix support through), but they were absolutely -> NO help - after -> 45 minutes, all I got was a useless document (their's, not -> Informix's) -> telling me to do what I had already done. -> -> Environment: -> -> AIX 5.3 -> IDS 9.40 -> -> Thanks in advance, -> ************************************************************************ ********** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ************************************************************************ **********

Just to clarify, do you have separate files for onconfig and sqlhosts. When you are switching to the second instance, are you setting the environment variables ONCONFIG, INFORMIXSQLHOSTS and INFORMIXSERVER to the second instance. Thank you, Kannan Thirugnanam -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Simmons, Keith Sent: Friday, June 17, 2005 3:59 AM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5178] Danny May be unrelated, bt I have a vague recollection that using SERVERNUM 0 is a bad idea.Throw some information back:- relevant SGLHOSTS entries relevant /etc/services entries relevant environment details from each environment (are you correctly exporting the variables?) DBSERVERNAME/ALIASES and NUM from each instance. Keith -> -----Original Message----- -> From: Danny Wright [mailto:dwright@sherwoodfoods.com] -> Sent: Thursday, June 16, 2005 10:49 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5175] -> -> INFORMIXDIR should be the same for both instances and I am -> setting both -> INFORMIXSERVER and ONCONFIG. -> -> And I have confirmed that they really are being set (both -> by echo'ing the -> vars and with env | grep'ping for them) -> -> -----Original Message----- -> From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] -> Sent: Thursday, June 16, 2005 5:22 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5173] -> -> Something in your environment isn't being reset. -> -> How are you resetting $INFORMIXDIR and $INFORMIXSERVER? -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 3:51 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5173] -> -> Already done - the first instance is SERVERNUM 0, the 2nd is -> SERVERNUM 1 -> -> -----Original Message----- -> From: Palmer, George [mailto:George.Palmer@pegs.com] -> Sent: Thursday, June 16, 2005 4:12 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5171] -> -> Change the SERVERNUM ( two instances can not use the same -> SERVERNUM on -> the same machine ) -> -> George -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 12:59 PM -> To: ids@iiug.org -> Subject: 2nd instance problem - still looking at 1st instance [5171] -> -> After I set up one instance and everything seems to be working, I -> attempted to create a 2nd one. -> -> I have entries in /etc/services for both instances. -> -> I have entries in /informix/etc/sqlhosts for both. -> -> I have unique values for ROOTPATH, MSGPATH, SERVERNUM, -> DBSERVERNAME and -> DBSERVERALIASES in my config files (there is no mirroring). -> -> And finally, I am changing the INFORMIXSERVER and ONCONFIG -> environment -> variables when I attempt to switch instances. -> -> I've created separate links to my logical volumes and I've -> double-checked that they are not pointing to the same ones. -> -> But, when I do an onstat -d in the 2nd instance, it shows me -> information -> from the first instance. -> -> -> I've just gotten off the phone with our software vendor (who we are -> supposed to have Informix support through), but they were -> absolutely NO -> help - after -> 45 minutes, all I got was a useless document (their's, not -> Informix's) -> telling me to do what I had already done. -> -> Environment: -> -> AIX 5.3 -> IDS 9.40 -> -> Thanks in advance, -> ************************************************************************ ********** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ************************************************************************ ********** ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.

I suppose I should just change my onconfig file and do an oninit -i? -----Original Message----- From: Danny Wright [mailto:dwright@sherwoodfoods.com] Sent: Friday, June 17, 2005 9:24 AM To: David Williams; ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5175] Foreword: After I composed the below email, I noticed that an updated version of the installation doc (the one they sent me yesterday) for our app said to put an offset of 12 for dbspaces. The documentation I originally had said to use an offset of 0 (zero). I'm not sure if this is cause of the problem or not, but I've dropped all dbspaces except root dbspace, which I'm discovering cannot be dropped. So if it cannot be dropped, how do I recreate it properly?

Kannan onconfig files should be different, but the sqlhosts file can be the same, and is probably best if they are. Keith -----Original Message----- From: Thirugnanam, Kannan [mailto:Kannan.Thirugnanam@JTax.com] Sent: Friday, June 17, 2005 14:58 To: Simmons, Keith; ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5178] Just to clarify, do you have separate files for onconfig and sqlhosts. When you are switching to the second instance, are you setting the environment variables ONCONFIG, INFORMIXSQLHOSTS and INFORMIXSERVER to the second instance. Thank you, Kannan Thirugnanam -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Simmons, Keith Sent: Friday, June 17, 2005 3:59 AM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5178] Danny May be unrelated, bt I have a vague recollection that using SERVERNUM 0 is a bad idea.Throw some information back:- relevant SGLHOSTS entries relevant /etc/services entries relevant environment details from each environment (are you correctly exporting the variables?) DBSERVERNAME/ALIASES and NUM from each instance. Keith -> -----Original Message----- -> From: Danny Wright [mailto:dwright@sherwoodfoods.com] -> Sent: Thursday, June 16, 2005 10:49 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5175] -> -> INFORMIXDIR should be the same for both instances and I am -> setting both -> INFORMIXSERVER and ONCONFIG. -> -> And I have confirmed that they really are being set (both -> by echo'ing the -> vars and with env | grep'ping for them) -> -> -----Original Message----- -> From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] -> Sent: Thursday, June 16, 2005 5:22 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5173] -> -> Something in your environment isn't being reset. -> -> How are you resetting $INFORMIXDIR and $INFORMIXSERVER? -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 3:51 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5173] -> -> Already done - the first instance is SERVERNUM 0, the 2nd is -> SERVERNUM 1 -> -> -----Original Message----- -> From: Palmer, George [mailto:George.Palmer@pegs.com] -> Sent: Thursday, June 16, 2005 4:12 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5171] -> -> Change the SERVERNUM ( two instances can not use the same -> SERVERNUM on -> the same machine ) -> -> George -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 12:59 PM -> To: ids@iiug.org -> Subject: 2nd instance problem - still looking at 1st instance [5171] -> -> After I set up one instance and everything seems to be working, I -> attempted to create a 2nd one. -> -> I have entries in /etc/services for both instances. -> -> I have entries in /informix/etc/sqlhosts for both. -> -> I have unique values for ROOTPATH, MSGPATH, SERVERNUM, -> DBSERVERNAME and -> DBSERVERALIASES in my config files (there is no mirroring). -> -> And finally, I am changing the INFORMIXSERVER and ONCONFIG -> environment -> variables when I attempt to switch instances. -> -> I've created separate links to my logical volumes and I've -> double-checked that they are not pointing to the same ones. -> -> But, when I do an onstat -d in the 2nd instance, it shows me -> information -> from the first instance. -> -> -> I've just gotten off the phone with our software vendor (who we are -> supposed to have Informix support through), but they were -> absolutely NO -> help - after -> 45 minutes, all I got was a useless document (their's, not -> Informix's) -> telling me to do what I had already done. -> -> Environment: -> -> AIX 5.3 -> IDS 9.40 -> -> Thanks in advance, -> ************************************************************************ ********** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ************************************************************************ ********** ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.

Had this happen to me once before. My memory isn't 100% on this, but as I recall, I had pointed the rootdbs to the same device for both instances. DOH! >From: "Lavoie, Diane" <diane.lavoie@domtar.com> >To: ids@iiug.org >Subject: RE: 2nd instance problem - still looking at 1st instance >[5181] Date: Fri, 17 Jun 2005 09:32:15 -0400 (EDT) > >Hi, >I am using 0 as SERVERNUM without any problem. >Are you using the same informix user for both instances? >Diane Lavoie > >-----Original Message----- >From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On >Behalf Of Simmons, Keith >Sent: Friday, June 17, 2005 3:59 AM >To: ids@iiug.org >Subject: RE: 2nd instance problem - still looking at 1st instance [5178] > > >Danny > >May be unrelated, bt I have a vague recollection that using SERVERNUM 0 >is a bad idea. >Throw some information back:- >relevant SGLHOSTS entries >relevant /etc/services entries >relevant environment details from each environment (are you > correctly exporting the variables?) >DBSERVERNAME/ALIASES and NUM from each instance. > >Keith > >-> -----Original Message----- >-> From: Danny Wright [mailto:dwright@sherwoodfoods.com] >-> Sent: Thursday, June 16, 2005 10:49 PM >-> To: ids@iiug.org >-> Subject: RE: 2nd instance problem - still looking at 1st instance >-> [5175] >-> >-> INFORMIXDIR should be the same for both instances and I am setting >-> both INFORMIXSERVER and ONCONFIG. >-> >-> And I have confirmed that they really are being set (both by >-> echo'ing the vars and with env | grep'ping for them) >-> >-> -----Original Message----- >-> From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] >-> Sent: Thursday, June 16, 2005 5:22 PM >-> To: Danny Wright; ids@iiug.org >-> Subject: RE: 2nd instance problem - still looking at 1st instance >-> [5173] >-> >-> Something in your environment isn't being reset. >-> >-> How are you resetting $INFORMIXDIR and $INFORMIXSERVER? >-> >-> -----Original Message----- >-> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On > >-> Behalf Of Danny Wright >-> Sent: Thursday, June 16, 2005 3:51 PM >-> To: ids@iiug.org >-> Subject: RE: 2nd instance problem - still looking at 1st instance >-> [5173] >-> >-> Already done - the first instance is SERVERNUM 0, the 2nd is >-> SERVERNUM 1 >-> >-> -----Original Message----- >-> From: Palmer, George [mailto:George.Palmer@pegs.com] >-> Sent: Thursday, June 16, 2005 4:12 PM >-> To: Danny Wright; ids@iiug.org >-> Subject: RE: 2nd instance problem - still looking at 1st instance >-> [5171] >-> >-> Change the SERVERNUM ( two instances can not use the same SERVERNUM >-> on the same machine ) >-> >-> George >-> >-> -----Original Message----- >-> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On > >-> Behalf Of Danny Wright >-> Sent: Thursday, June 16, 2005 12:59 PM >-> To: ids@iiug.org >-> Subject: 2nd instance problem - still looking at 1st instance [5171] >-> >-> After I set up one instance and everything seems to be working, I >-> attempted to create a 2nd one. >-> >-> I have entries in /etc/services for both instances. >-> >-> I have entries in /informix/etc/sqlhosts for both. >-> >-> I have unique values for ROOTPATH, MSGPATH, SERVERNUM, DBSERVERNAME >-> and DBSERVERALIASES in my config files (there is no mirroring). >-> >-> And finally, I am changing the INFORMIXSERVER and ONCONFIG >-> environment variables when I attempt to switch instances. >-> >-> I've created separate links to my logical volumes and I've >-> double-checked that they are not pointing to the same ones. >-> >-> But, when I do an onstat -d in the 2nd instance, it shows me >-> information from the first instance. >-> >-> >-> I've just gotten off the phone with our software vendor (who we are >-> supposed to have Informix support through), but they were absolutely >-> NO help - after >-> 45 minutes, all I got was a useless document (their's, not >-> Informix's) >-> telling me to do what I had already done. >-> >-> Environment: >-> >-> AIX 5.3 >-> IDS 9.40 >-> >-> Thanks in advance, >-> > >************************************************************************ >********** >This message is sent in strict confidence for the addressee only. It >may contain legally privileged information. The contents are not to be >disclosed to anyone other than the addressee. Unauthorised recipients >are requested to preserve this confidentiality and to advise the sender >immediately of any error in transmission. >This footnote also confirms that this email message has been swept for >the presence of computer viruses, however we cannot guarantee that this >message is free from such problems. >************************************************************************ >********** > > > > >

What about the ports being used in sqlhosts? Even if you have each one uniquely names, verify with /etc/services that they both point to unique TCP numbers. Thanks, Kate 770-433-8211 X 10922 Pager 1-800-946-4645 X 3377249 -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Danny Wright Sent: Thursday, June 16, 2005 5:49 PM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5175] INFORMIXDIR should be the same for both instances and I am setting both INFORMIXSERVER and ONCONFIG. And I have confirmed that they really are being set (both by echo'ing the vars and with env | grep'ping for them) -----Original Message----- From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] Sent: Thursday, June 16, 2005 5:22 PM To: Danny Wright; ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5173] Something in your environment isn't being reset. How are you resetting $INFORMIXDIR and $INFORMIXSERVER? -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Danny Wright Sent: Thursday, June 16, 2005 3:51 PM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5173] Already done - the first instance is SERVERNUM 0, the 2nd is SERVERNUM 1 -----Original Message----- From: Palmer, George [mailto:George.Palmer@pegs.com] Sent: Thursday, June 16, 2005 4:12 PM To: Danny Wright; ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5171] Change the SERVERNUM ( two instances can not use the same SERVERNUM on the same machine ) George -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Danny Wright Sent: Thursday, June 16, 2005 12:59 PM To: ids@iiug.org Subject: 2nd instance problem - still looking at 1st instance [5171] After I set up one instance and everything seems to be working, I attempted to create a 2nd one. I have entries in /etc/services for both instances. I have entries in /informix/etc/sqlhosts for both. I have unique values for ROOTPATH, MSGPATH, SERVERNUM, DBSERVERNAME and DBSERVERALIASES in my config files (there is no mirroring). And finally, I am changing the INFORMIXSERVER and ONCONFIG environment variables when I attempt to switch instances. I've created separate links to my logical volumes and I've double-checked that they are not pointing to the same ones. But, when I do an onstat -d in the 2nd instance, it shows me information from the first instance. I've just gotten off the phone with our software vendor (who we are supposed to have Informix support through), but they were absolutely NO help - after 45 minutes, all I got was a useless document (their's, not Informix's) telling me to do what I had already done. Environment: AIX 5.3 IDS 9.40 Thanks in advance,

If you have the servernumber set to 0, a bunch of "default" activity takes place. That is why we have a rule at my company NEVER to use 0. Thanks, Kate 770-433-8211 X 10922 Pager 1-800-946-4645 X 3377249 -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Lavoie, Diane Sent: Friday, June 17, 2005 9:32 AM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5181] Hi, I am using 0 as SERVERNUM without any problem. Are you using the same informix user for both instances? Diane Lavoie -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Simmons, Keith Sent: Friday, June 17, 2005 3:59 AM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5178] Danny May be unrelated, bt I have a vague recollection that using SERVERNUM 0 is a bad idea. Throw some information back:- relevant SGLHOSTS entries relevant /etc/services entries relevant environment details from each environment (are you correctly exporting the variables?) DBSERVERNAME/ALIASES and NUM from each instance. Keith -> -----Original Message----- -> From: Danny Wright [mailto:dwright@sherwoodfoods.com] -> Sent: Thursday, June 16, 2005 10:49 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st instance -> [5175] -> -> INFORMIXDIR should be the same for both instances and I am setting -> both INFORMIXSERVER and ONCONFIG. -> -> And I have confirmed that they really are being set (both by -> echo'ing the vars and with env | grep'ping for them) -> -> -----Original Message----- -> From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] -> Sent: Thursday, June 16, 2005 5:22 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st instance -> [5173] -> -> Something in your environment isn't being reset. -> -> How are you resetting $INFORMIXDIR and $INFORMIXSERVER? -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 3:51 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st instance -> [5173] -> -> Already done - the first instance is SERVERNUM 0, the 2nd is -> SERVERNUM 1 -> -> -----Original Message----- -> From: Palmer, George [mailto:George.Palmer@pegs.com] -> Sent: Thursday, June 16, 2005 4:12 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st instance -> [5171] -> -> Change the SERVERNUM ( two instances can not use the same SERVERNUM -> on the same machine ) -> -> George -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 12:59 PM -> To: ids@iiug.org -> Subject: 2nd instance problem - still looking at 1st instance [5171] -> -> After I set up one instance and everything seems to be working, I -> attempted to create a 2nd one. -> -> I have entries in /etc/services for both instances. -> -> I have entries in /informix/etc/sqlhosts for both. -> -> I have unique values for ROOTPATH, MSGPATH, SERVERNUM, DBSERVERNAME -> and DBSERVERALIASES in my config files (there is no mirroring). -> -> And finally, I am changing the INFORMIXSERVER and ONCONFIG -> environment variables when I attempt to switch instances. -> -> I've created separate links to my logical volumes and I've -> double-checked that they are not pointing to the same ones. -> -> But, when I do an onstat -d in the 2nd instance, it shows me -> information from the first instance. -> -> -> I've just gotten off the phone with our software vendor (who we are -> supposed to have Informix support through), but they were absolutely -> NO help - after -> 45 minutes, all I got was a useless document (their's, not -> Informix's) -> telling me to do what I had already done. -> -> Environment: -> -> AIX 5.3 -> IDS 9.40 -> -> Thanks in advance, -> ************************************************************************ ********** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ************************************************************************ **********

Sqlhosts doesn't need to be a second file. Thanks, Kate 770-433-8211 X 10922 Pager 1-800-946-4645 X 3377249 -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Thirugnanam.... Sent: Friday, June 17, 2005 10:04 AM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5182] Just to clarify, do you have separate files for onconfig and sqlhosts. When you are switching to the second instance, are you setting the environment variables ONCONFIG, INFORMIXSQLHOSTS and INFORMIXSERVER to the second instance. Thank you, Kannan Thirugnanam -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Simmons, Keith Sent: Friday, June 17, 2005 3:59 AM To: ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5178] Danny May be unrelated, bt I have a vague recollection that using SERVERNUM 0 is a bad idea.Throw some information back:- relevant SGLHOSTS entries relevant /etc/services entries relevant environment details from each environment (are you correctly exporting the variables?) DBSERVERNAME/ALIASES and NUM from each instance. Keith -> -----Original Message----- -> From: Danny Wright [mailto:dwright@sherwoodfoods.com] -> Sent: Thursday, June 16, 2005 10:49 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5175] -> -> INFORMIXDIR should be the same for both instances and I am -> setting both -> INFORMIXSERVER and ONCONFIG. -> -> And I have confirmed that they really are being set (both -> by echo'ing the -> vars and with env | grep'ping for them) -> -> -----Original Message----- -> From: Hamilton, Jerry [mailto:hamiltoj@fleishman.com] -> Sent: Thursday, June 16, 2005 5:22 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5173] -> -> Something in your environment isn't being reset. -> -> How are you resetting $INFORMIXDIR and $INFORMIXSERVER? -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 3:51 PM -> To: ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5173] -> -> Already done - the first instance is SERVERNUM 0, the 2nd is -> SERVERNUM 1 -> -> -----Original Message----- -> From: Palmer, George [mailto:George.Palmer@pegs.com] -> Sent: Thursday, June 16, 2005 4:12 PM -> To: Danny Wright; ids@iiug.org -> Subject: RE: 2nd instance problem - still looking at 1st -> instance [5171] -> -> Change the SERVERNUM ( two instances can not use the same -> SERVERNUM on -> the same machine ) -> -> George -> -> -----Original Message----- -> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On -> Behalf Of Danny Wright -> Sent: Thursday, June 16, 2005 12:59 PM -> To: ids@iiug.org -> Subject: 2nd instance problem - still looking at 1st instance [5171] -> -> After I set up one instance and everything seems to be working, I -> attempted to create a 2nd one. -> -> I have entries in /etc/services for both instances. -> -> I have entries in /informix/etc/sqlhosts for both. -> -> I have unique values for ROOTPATH, MSGPATH, SERVERNUM, -> DBSERVERNAME and -> DBSERVERALIASES in my config files (there is no mirroring). -> -> And finally, I am changing the INFORMIXSERVER and ONCONFIG -> environment -> variables when I attempt to switch instances. -> -> I've created separate links to my logical volumes and I've -> double-checked that they are not pointing to the same ones. -> -> But, when I do an onstat -d in the 2nd instance, it shows me -> information -> from the first instance. -> -> -> I've just gotten off the phone with our software vendor (who we are -> supposed to have Informix support through), but they were -> absolutely NO -> help - after -> 45 minutes, all I got was a useless document (their's, not -> Informix's) -> telling me to do what I had already done. -> -> Environment: -> -> AIX 5.3 -> IDS 9.40 -> -> Thanks in advance, -> ************************************************************************ ********** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ************************************************************************ ********** ***** Jackson Hewitt Email Disclaimer ***** The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email.

Hi Danny, You are correct. You can not drop a root dbspace as the root dbspace needs to exist for an Informix exist for an Informix instance to exist. So, you do the oninit -i to recreate the Informix instance. I like to use oninit -iv to getthe screen messages as the Informix is being initialized. I have created and worked with multiple instances of Informix on the same servers on IBM-AIX, Sun, and SGI. Somtimes I have as many as 9 or 10 Informix instances up on a server at the same time. The process is the same regardless of the hardware platform. If you are using the same Informix directory and the same version of Informix binaries for the Informix instances then you can share one sqlhosts file that has the necessary settings [server name, connection type. host machine, service name] for the instances. The $INFORMIXDIR will be the same for both instances when using the same binaries. There will be a separate onconfig file for each instance. As other people indicated, you need unique server names for the instances. Also check the onconfig files for their SERVERNUM, DBSERVERNAME, and DBSERVERALIAS, ROOTPATH, and MSGPATH. Do a setenv and pipe it to more to verify that you settings are what you think they should be. I like to create a separate source file for each Informix instance. I then just source the source file to have the exact settings that I need for the particular Informix instance that I want to access. If you are having problems accessing the second Informix instance, are you sure that you actually created a second Informix instance? What do you see when you execute ipcs from the command line as user Informix? Do you see multiple shared memory segments owned by Informix and two different sets of Hex numbers in the third column? Go to your $INFORMIXDIR for both instances and look at the Informix log files, or to another location if you are storing the log files. What do the log files show? If there is only one log file, then ether you are using the same log file name and location [i.e. MSGPATH] for both instances [a no no], or you only have one Informix instance. Bruce -----Original Message----- From: Danny Wright <dwright@sherwoodfoods.com> To: ids@iiug.org Sent: Fri, 17 Jun 2005 10:18:55 -0400 (EDT) Subject: RE: 2nd instance problem - still looking at 1st instance [5183] I suppose I should just change my onconfig file and do an oninit -i? -----Original Message----- From: Danny Wright [mailto:dwright@sherwoodfoods.com] Sent: Friday, June 17, 2005 9:24 AM To: David Williams; ids@iiug.org Subject: RE: 2nd instance problem - still looking at 1st instance [5175] Foreword: After I composed the below email, I noticed that an updated version of the installation doc (the one they sent me yesterday) for our app said to put an offset of 12 for dbspaces. The documentation I originally had said to use an offset of 0 (zero). I'm not sure if this is cause of the problem or not, but I've dropped all dbspaces except root dbspace, which I'm discovering cannot be dropped. So if it cannot be dropped, how do I recreate it properly?