New Informix setup
A user asked for the best way to consolidate three separate Informix 11.50.FC9 instances (HP-UX Itanium, ~1TB) onto one HP-UX box, keeping them as three instances. Art Kagel advised either backing up each server and restoring onto the new machine (installing the software, setting up chunks, copying ONCONFIG files, building a new sqlhosts), or using onclone to build RSS/HDR secondaries and swap roles. He confirmed only one 'informix' user and one software copy is needed; the instances are kept apart by distinct SERVERNUM values, ONCONFIG files, and ports/service names in sqlhosts and /etc/services, with a redirected restore if chunk paths change.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We have some request to migrate 3 informix instance into one box (HP-UX). Is there any better way to do this Thank you very much --001a1140f3cc1422fa0521bb6a16
Any better way than what ? From which O/S are you migrating ? Between which versions of IDS are you migrating ? What are the sizes of the databases you want to migrate ? Are you wanting to put three all in one instance or retain as three separate instances ? Keith On 10 October 2015 at 08:55, medkba <medkba@gmail.com> wrote: > We have some request to migrate 3 informix instance into one box (HP-UX). > Is there any better way to do this > > Thank you very much > > --001a1140f3cc1422fa0521bb6a16 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e010d826032fe110521c1eb7f
Hi, OS: From HP-UX Itanium to HP-UX Itanium IDS: 11.50 FC9 to 11.50 FC9 Size: 1 TB Separate instance. Any more information required Thank you very much On Sat, Oct 10, 2015 at 11:40 PM, Keith Simmons <smiley73@gmail.com> wrote: > Any better way than what ? > >From which O/S are you migrating ? Between which versions of IDS are you > migrating ? > What are the sizes of the databases you want to migrate ? > Are you wanting to put three all in one instance or retain as three > separate instances ? > > Keith > > On 10 October 2015 at 08:55, medkba <medkba@gmail.com> wrote: > > > We have some request to migrate 3 informix instance into one box (HP-UX). > > Is there any better way to do this > > > > Thank you very much > > > > --001a1140f3cc1422fa0521bb6a16 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e010d826032fe110521c1eb7f > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bdc0cd8fb93220521c2685a
Better than what? Art On Oct 10, 2015 3:55 AM, "medkba" <medkba@gmail.com> wrote: > We have some request to migrate 3 informix instance into one box (HP-UX). > Is there any better way to do this > > Thank you very much > > --001a1140f3cc1422fa0521bb6a16 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01184e1af14fdf0521ca3a15
Art, Actually, we required to move all the informix instance into one box currently, we have three instance three servers. May I know any best practices this kind of requests. Thank you very much Regards Elisha On Sun, Oct 11, 2015 at 9:35 AM, Art Kagel <art.kagel@gmail.com> wrote: > Better than what? > > Art > On Oct 10, 2015 3:55 AM, "medkba" <medkba@gmail.com> wrote: > > > We have some request to migrate 3 informix instance into one box (HP-UX). > > Is there any better way to do this > > > > Thank you very much > > > > --001a1140f3cc1422fa0521bb6a16 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e01184e1af14fdf0521ca3a15 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013a0744312be10521ca64cd
The best way and easiest way would be to archive the three servers and restore on the new box. Obviously you will first have to install the Informix software, configure the chunks, copy the ONCONFIG files, and make a new sqlhosts file. You could also use the onclone utility to create the new servers as RSS secondaries then upgrade them to HDR and swap roles making the new servers the primaries and funally shutting down the old servers and make the new ones stand alone. Art On Oct 10, 2015 9:47 PM, "medkba" <medkba@gmail.com> wrote: > Art, > > Actually, we required to move all the informix instance into one box > currently, we have three instance three servers. May I know any best > practices this kind of requests. > > Thank you very much > > Regards > Elisha > > On Sun, Oct 11, 2015 at 9:35 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > Better than what? > > > > Art > > On Oct 10, 2015 3:55 AM, "medkba" <medkba@gmail.com> wrote: > > > > > We have some request to migrate 3 informix instance into one box > (HP-UX). > > > Is there any better way to do this > > > > > > Thank you very much > > > > > > --001a1140f3cc1422fa0521bb6a16 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --089e01184e1af14fdf0521ca3a15 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e013a0744312be10521ca64cd > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a114158b01eed270521cbfd3f
I have one clarification, Informix software is required to installed three right? each one having separate users like informix1, informix2 and informix3. But the installation informix on the root right. Is there any conflict three instances same boxes. Thank you very much for the advise Elisha On Sun, Oct 11, 2015 at 11:41 AM, Art Kagel <art.kagel@gmail.com> wrote: > The best way and easiest way would be to archive the three servers and > restore on the new box. Obviously you will first have to install the > Informix software, configure the chunks, copy the ONCONFIG files, and make > a new sqlhosts file. > > You could also use the onclone utility to create the new servers as RSS > secondaries then upgrade them to HDR and swap roles making the new servers > the primaries and funally shutting down the old servers and make the new > ones stand alone. > > Art > On Oct 10, 2015 9:47 PM, "medkba" <medkba@gmail.com> wrote: > > > Art, > > > > Actually, we required to move all the informix instance into one box > > currently, we have three instance three servers. May I know any best > > practices this kind of requests. > > > > Thank you very much > > > > Regards > > Elisha > > > > On Sun, Oct 11, 2015 at 9:35 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > > > Better than what? > > > > > > Art > > > On Oct 10, 2015 3:55 AM, "medkba" <medkba@gmail.com> wrote: > > > > > > > We have some request to migrate 3 informix instance into one box > > (HP-UX). > > > > Is there any better way to do this > > > > > > > > Thank you very much > > > > > > > > --001a1140f3cc1422fa0521bb6a16 > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --089e01184e1af14fdf0521ca3a15 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --089e013a0744312be10521ca64cd > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a114158b01eed270521cbfd3f > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013a074407f1160521cc1474
No. You only need one user "informix" for all three instances and one copy of the software. All three instances will be using the same copy of the software on disk. Yes you will be installing the software as "root" not as informix or some other user. The three instances can coexist on a single server because you will use three different SERVERNUM values in the three ONCONFIG files and different PORT numbers or SERVICE names in the sqlhosts file. By convention you will name the ONCONFIG files as onconfig.<servername> but that's just a convention, you can name them anything you want. The ONCONFIG and INFORMIXSERVER environment variables will specify which instance you are talking to for maintenance. You may have to set up new SERVICE names in the /etc/services file for the three instances. Since the three instances are currently on separate machines, note that if they are all using the same chunk paths (or if you just need the chunk paths to be different on the new machine) you will have to do a redirected restore for each instance to remap the old chunk paths to the new ones. Look that up in the Backup and Restore Guide. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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 Sat, Oct 10, 2015 at 11:48 PM, medkba <medkba@gmail.com> wrote: > I have one clarification, Informix software is required to installed three > right? each one having separate users like informix1, informix2 and > informix3. But the installation informix on the root right. Is there any > conflict three instances same boxes. > > Thank you very much for the advise > Elisha > > On Sun, Oct 11, 2015 at 11:41 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > The best way and easiest way would be to archive the three servers and > > restore on the new box. Obviously you will first have to install the > > Informix software, configure the chunks, copy the ONCONFIG files, and > make > > a new sqlhosts file. > > > > You could also use the onclone utility to create the new servers as RSS > > secondaries then upgrade them to HDR and swap roles making the new > servers > > the primaries and funally shutting down the old servers and make the new > > ones stand alone. > > > > Art > > On Oct 10, 2015 9:47 PM, "medkba" <medkba@gmail.com> wrote: > > > > > Art, > > > > > > Actually, we required to move all the informix instance into one box > > > currently, we have three instance three servers. May I know any best > > > practices this kind of requests. > > > > > > Thank you very much > > > > > > Regards > > > Elisha > > > > > > On Sun, Oct 11, 2015 at 9:35 AM, Art Kagel <art.kagel@gmail.com> > wrote: > > > > > > > Better than what? > > > > > > > > Art > > > > On Oct 10, 2015 3:55 AM, "medkba" <medkba@gmail.com> wrote: > > > > > > > > > We have some request to migrate 3 informix instance into one box > > > (HP-UX). > > > > > Is there any better way to do this > > > > > > > > > > Thank you very much > > > > > > > > > > --001a1140f3cc1422fa0521bb6a16 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > --089e01184e1af14fdf0521ca3a15 > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --089e013a0744312be10521ca64cd > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a114158b01eed270521cbfd3f > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e013a074407f1160521cc1474 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a114158b01cb1210521d24ff9
Art, Thank you very much May i know which files to verify for the three instance one box? I.e. Onconfig, sqlhosts and etc/services. Is there anything else required to verify? Thank you Elisha On 11 Oct 2015 19:14, "Art Kagel" <art.kagel@gmail.com> wrote: > No. You only need one user "informix" for all three instances and one copy > of the software. All three instances will be using the same copy of the > software on disk. Yes you will be installing the software as "root" not as > informix or some other user. The three instances can coexist on a single > server because you will use three different SERVERNUM values in the three > ONCONFIG files and different PORT numbers or SERVICE names in the sqlhosts > file. By convention you will name the ONCONFIG files as > onconfig.<servername> but that's just a convention, you can name them > anything you want. The ONCONFIG and INFORMIXSERVER environment variables > will specify which instance you are talking to for maintenance. You may > have to set up new SERVICE names in the /etc/services file for the three > instances. > > Since the three instances are currently on separate machines, note that if > they are all using the same chunk paths (or if you just need the chunk > paths to be different on the new machine) you will have to do a redirected > restore for each instance to remap the old chunk paths to the new ones. > Look that up in the Backup and Restore Guide. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.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 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 Sat, Oct 10, 2015 at 11:48 PM, medkba <medkba@gmail.com> wrote: > > > I have one clarification, Informix software is required to installed > three > > right? each one having separate users like informix1, informix2 and > > informix3. But the installation informix on the root right. Is there any > > conflict three instances same boxes. > > > > Thank you very much for the advise > > Elisha > > > > On Sun, Oct 11, 2015 at 11:41 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > > > The best way and easiest way would be to archive the three servers and > > > restore on the new box. Obviously you will first have to install the > > > Informix software, configure the chunks, copy the ONCONFIG files, and > > make > > > a new sqlhosts file. > > > > > > You could also use the onclone utility to create the new servers as RSS > > > secondaries then upgrade them to HDR and swap roles making the new > > servers > > > the primaries and funally shutting down the old servers and make the > new > > > ones stand alone. > > > > > > Art > > > On Oct 10, 2015 9:47 PM, "medkba" <medkba@gmail.com> wrote: > > > > > > > Art, > > > > > > > > Actually, we required to move all the informix instance into one box > > > > currently, we have three instance three servers. May I know any best > > > > practices this kind of requests. > > > > > > > > Thank you very much > > > > > > > > Regards > > > > Elisha > > > > > > > > On Sun, Oct 11, 2015 at 9:35 AM, Art Kagel <art.kagel@gmail.com> > > wrote: > > > > > > > > > Better than what? > > > > > > > > > > Art > > > > > On Oct 10, 2015 3:55 AM, "medkba" <medkba@gmail.com> wrote: > > > > > > > > > > > We have some request to migrate 3 informix instance into one box > > > > (HP-UX). > > > > > > Is there any better way to do this > > > > > > > > > > > > Thank you very much > > > > > > > > > > > > --001a1140f3cc1422fa0521bb6a16 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > > > Forum Note: Use "Reply" to post a response in the discussion > forum. > > > > > > > > > > > > > > > > > > > > > > --089e01184e1af14fdf0521ca3a15 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > --089e013a0744312be10521ca64cd > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --001a114158b01eed270521cbfd3f > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --089e013a074407f1160521cc1474 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a114158b01cb1210521d24ff9 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113f3ca0f97da10521ea7452
Just those three (well five if you count that each indtance will have its own ONCONFIG file). There is only one sqlhosts file unless the three instances should not know about each other. Art On Oct 12, 2015 12:03 PM, "medkba" <medkba@gmail.com> wrote: > Art, > > Thank you very much > > May i know which files to verify for the three instance one box? I.e. > Onconfig, sqlhosts and etc/services. Is there anything else required to > verify? > > Thank you > Elisha > On 11 Oct 2015 19:14, "Art Kagel" <art.kagel@gmail.com> wrote: > > > No. You only need one user "informix" for all three instances and one > copy > > of the software. All three instances will be using the same copy of the > > software on disk. Yes you will be installing the software as "root" not > as > > informix or some other user. The three instances can coexist on a single > > server because you will use three different SERVERNUM values in the three > > ONCONFIG files and different PORT numbers or SERVICE names in the > sqlhosts > > file. By convention you will name the ONCONFIG files as > > onconfig.<servername> but that's just a convention, you can name them > > anything you want. The ONCONFIG and INFORMIXSERVER environment variables > > will specify which instance you are talking to for maintenance. You may > > have to set up new SERVICE names in the /etc/services file for the three > > instances. > > > > Since the three instances are currently on separate machines, note that > if > > they are all using the same chunk paths (or if you just need the chunk > > paths to be different on the new machine) you will have to do a > redirected > > restore for each instance to remap the old chunk paths to the new ones. > > Look that up in the Backup and Restore Guide. > > > > Art > > > > Art S. Kagel, President and Principal Consultant > > ASK Database Management > > www.askdbmgt.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 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 Sat, Oct 10, 2015 at 11:48 PM, medkba <medkba@gmail.com> wrote: > > > > > I have one clarification, Informix software is required to installed > > three > > > right? each one having separate users like informix1, informix2 and > > > informix3. But the installation informix on the root right. Is there > any > > > conflict three instances same boxes. > > > > > > Thank you very much for the advise > > > Elisha > > > > > > On Sun, Oct 11, 2015 at 11:41 AM, Art Kagel <art.kagel@gmail.com> > wrote: > > > > > > > The best way and easiest way would be to archive the three servers > and > > > > restore on the new box. Obviously you will first have to install the > > > > Informix software, configure the chunks, copy the ONCONFIG files, and > > > make > > > > a new sqlhosts file. > > > > > > > > You could also use the onclone utility to create the new servers as > RSS > > > > secondaries then upgrade them to HDR and swap roles making the new > > > servers > > > > the primaries and funally shutting down the old servers and make the > > new > > > > ones stand alone. > > > > > > > > Art > > > > On Oct 10, 2015 9:47 PM, "medkba" <medkba@gmail.com> wrote: > > > > > > > > > Art, > > > > > > > > > > Actually, we required to move all the informix instance into one > box > > > > > currently, we have three instance three servers. May I know any > best > > > > > practices this kind of requests. > > > > > > > > > > Thank you very much > > > > > > > > > > Regards > > > > > Elisha > > > > > > > > > > On Sun, Oct 11, 2015 at 9:35 AM, Art Kagel <art.kagel@gmail.com> > > > wrote: > > > > > > > > > > > Better than what? > > > > > > > > > > > > Art > > > > > > On Oct 10, 2015 3:55 AM, "medkba" <medkba@gmail.com> wrote: > > > > > > > > > > > > > We have some request to migrate 3 informix instance into one > box > > > > > (HP-UX). > > > > > > > Is there any better way to do this > > > > > > > > > > > > > > Thank you very much > > > > > > > > > > > > > > --001a1140f3cc1422fa0521bb6a16 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > > > > Forum Note: Use "Reply" to post a response in the discussion > > forum. > > > > > > > > > > > > > > > > > > > > > > > > > > --089e01184e1af14fdf0521ca3a15 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > > > Forum Note: Use "Reply" to post a response in the discussion > forum. > > > > > > > > > > > > > > > > > > > > > > --089e013a0744312be10521ca64cd > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > --001a114158b01eed270521cbfd3f > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --089e013a074407f1160521cc1474 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a114158b01cb1210521d24ff9 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a113f3ca0f97da10521ea7452 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013c6e9adba9e70521eaeb41