Informix restore to another OS

Hi, We are running Informix 11.70.FC7 on Solaris. We need to move the entire Informix instance to another OS, possibly windows (just for some application development testing). What are the options for moving all the data and objects (tables, data, indexes, triggers, Foreign Keys, SP's etc...). Is there a way to use ontape to do a backup/restore from Solaris to Windows? What are the options? Thank You, --Dave --047d7bacb8eaeb30030515be8e99

dbexport/dbimport or distributed queries (INSERT INTO database@windows_server:table SELECT * FROM database@solaris_server:table) Regards On Sun, May 10, 2015 at 7:37 PM, Informix DBA <in4mixdba@gmail.com> wrote: > Hi, > > We are running Informix 11.70.FC7 on Solaris. We need to move the entire > Informix instance to another OS, possibly windows (just for some > application development testing). What are the options for moving all the > data and objects (tables, data, indexes, triggers, Foreign Keys, SP's > etc...). Is there a way to use ontape to do a backup/restore from Solaris > to Windows? What are the options? > > Thank You, > > --Dave > > --047d7bacb8eaeb30030515be8e99 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11c1f784d63fa80515bebaac

Or lots of parallel hpl jobs Paul Watson Oninit www.oninit.com +1 913 387 7529 Oninit® is a Registered Trademark of Oninit LLC > On May 10, 2015, at 13:50, Fernando Nunes <domusonline@gmail.com> wrote: > > dbexport/dbimport or distributed queries (INSERT INTO > database@windows_server:table SELECT * FROM database@solaris_server:table) > Regards > >> On Sun, May 10, 2015 at 7:37 PM, Informix DBA <in4mixdba@gmail.com> wrote: >> >> Hi, >> >> We are running Informix 11.70.FC7 on Solaris. We need to move the entire >> Informix instance to another OS, possibly windows (just for some >> application development testing). What are the options for moving all the >> data and objects (tables, data, indexes, triggers, Foreign Keys, SP's >> etc...). Is there a way to use ontape to do a backup/restore from Solaris >> to Windows? What are the options? >> >> Thank You, >> >> --Dave >> >> --047d7bacb8eaeb30030515be8e99 > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --001a11c1f784d63fa80515bebaac > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.

Thank you Paul and Fernando. Will any of the ontape or onbar utilities work across different platforms? --Dave On Sun, May 10, 2015 at 3:18 PM, Paul Watson <paul@oninit.com> wrote: > Or lots of parallel hpl jobs > > Paul Watson > Oninit www.oninit.com > +1 913 387 7529 > > Oninit® is a Registered Trademark of Oninit LLC > > > On May 10, 2015, at 13:50, Fernando Nunes <domusonline@gmail.com> wrote: > > > > dbexport/dbimport or distributed queries (INSERT INTO > > database@windows_server:table SELECT * FROM database@solaris_server > :table) > > Regards > > > >> On Sun, May 10, 2015 at 7:37 PM, Informix DBA <in4mixdba@gmail.com> > wrote: > >> > >> Hi, > >> > >> We are running Informix 11.70.FC7 on Solaris. We need to move the entire > >> Informix instance to another OS, possibly windows (just for some > >> application development testing). What are the options for moving all > the > >> data and objects (tables, data, indexes, triggers, Foreign Keys, SP's > >> etc...). Is there a way to use ontape to do a backup/restore from > Solaris > >> to Windows? What are the options? > >> > >> Thank You, > >> > >> --Dave > >> > >> --047d7bacb8eaeb30030515be8e99 > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --001a11c1f784d63fa80515bebaac > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d044287500f35aa0515bf9bc8

No Paul Watson Oninit www.oninit.com +1 913 387 7529 Oninit® is a Registered Trademark of Oninit LLC > On May 10, 2015, at 14:52, Informix DBA <in4mixdba@gmail.com> wrote: > > Thank you Paul and Fernando. Will any of the ontape or onbar utilities > work across different platforms? > > --Dave > >> On Sun, May 10, 2015 at 3:18 PM, Paul Watson <paul@oninit.com> wrote: >> >> Or lots of parallel hpl jobs >> >> Paul Watson >> Oninit www.oninit.com >> +1 913 387 7529 >> >> Oninit® is a Registered Trademark of Oninit LLC >> >>> On May 10, 2015, at 13:50, Fernando Nunes <domusonline@gmail.com> wrote: >>> >>> dbexport/dbimport or distributed queries (INSERT INTO >>> database@windows_server:table SELECT * FROM database@solaris_server >> :table) >>> Regards >>> >>>> On Sun, May 10, 2015 at 7:37 PM, Informix DBA <in4mixdba@gmail.com> >> wrote: >>>> >>>> Hi, >>>> >>>> We are running Informix 11.70.FC7 on Solaris. We need to move the entire >>>> Informix instance to another OS, possibly windows (just for some >>>> application development testing). What are the options for moving all >> the >>>> data and objects (tables, data, indexes, triggers, Foreign Keys, SP's >>>> etc...). Is there a way to use ontape to do a backup/restore from >> Solaris >>>> to Windows? What are the options? >>>> >>>> Thank You, >>>> >>>> --Dave >>>> >>>> --047d7bacb8eaeb30030515be8e99 > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> -- >>> Fernando Nunes >>> Portugal >>> >>> http://informix-technology.blogspot.com >>> My email works... but I don't check it frequently... >>> >>> --001a11c1f784d63fa80515bebaac > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d044287500f35aa0515bf9bc8 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.

If you know ER then I would use that - just easy Cheers Paul Paul Watson Oninit www.oninit.com +1 913 387 7529 Oninit® is a Registered Trademark of Oninit LLC > On May 10, 2015, at 14:52, Informix DBA <in4mixdba@gmail.com> wrote: > > Thank you Paul and Fernando. Will any of the ontape or onbar utilities > work across different platforms? > > --Dave > >> On Sun, May 10, 2015 at 3:18 PM, Paul Watson <paul@oninit.com> wrote: >> >> Or lots of parallel hpl jobs >> >> Paul Watson >> Oninit www.oninit.com >> +1 913 387 7529 >> >> Oninit® is a Registered Trademark of Oninit LLC >> >>> On May 10, 2015, at 13:50, Fernando Nunes <domusonline@gmail.com> wrote: >>> >>> dbexport/dbimport or distributed queries (INSERT INTO >>> database@windows_server:table SELECT * FROM database@solaris_server >> :table) >>> Regards >>> >>>> On Sun, May 10, 2015 at 7:37 PM, Informix DBA <in4mixdba@gmail.com> >> wrote: >>>> >>>> Hi, >>>> >>>> We are running Informix 11.70.FC7 on Solaris. We need to move the entire >>>> Informix instance to another OS, possibly windows (just for some >>>> application development testing). What are the options for moving all >> the >>>> data and objects (tables, data, indexes, triggers, Foreign Keys, SP's >>>> etc...). Is there a way to use ontape to do a backup/restore from >> Solaris >>>> to Windows? What are the options? >>>> >>>> Thank You, >>>> >>>> --Dave >>>> >>>> --047d7bacb8eaeb30030515be8e99 > ******************************************************************************* >>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>> >>> -- >>> Fernando Nunes >>> Portugal >>> >>> http://informix-technology.blogspot.com >>> My email works... but I don't check it frequently... >>> >>> --001a11c1f784d63fa80515bebaac > ******************************************************************************* >>> Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d044287500f35aa0515bf9bc8 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.

No. Informix stores everything in "as native as possible" format. This is good for the daily database activity, but it's a nasty thing when you consider moving platforms. Officially it's not even mentioned, meaning it is not the only issue, but different Endianess of the CPUs/OS is a big issue when you consider moving across platforms. And in the situation you mention (and I say again, this is not officially the problem, meaning you still have the issue even on similar endianess platforms), your two platforms have different endianess... Everything that is not a string and has more than one byte has a different physical layout on Windows and Solaris. Numbers, pointers, structures etc. Regards. On Sun, May 10, 2015 at 8:52 PM, Informix DBA <in4mixdba@gmail.com> wrote: > Thank you Paul and Fernando. Will any of the ontape or onbar utilities > work across different platforms? > > --Dave > > On Sun, May 10, 2015 at 3:18 PM, Paul Watson <paul@oninit.com> wrote: > > > Or lots of parallel hpl jobs > > > > Paul Watson > > Oninit www.oninit.com > > +1 913 387 7529 > > > > Oninit® is a Registered Trademark of Oninit LLC > > > > > On May 10, 2015, at 13:50, Fernando Nunes <domusonline@gmail.com> > wrote: > > > > > > dbexport/dbimport or distributed queries (INSERT INTO > > > database@windows_server:table SELECT * FROM database@solaris_server > > :table) > > > Regards > > > > > >> On Sun, May 10, 2015 at 7:37 PM, Informix DBA <in4mixdba@gmail.com> > > wrote: > > >> > > >> Hi, > > >> > > >> We are running Informix 11.70.FC7 on Solaris. We need to move the > entire > > >> Informix instance to another OS, possibly windows (just for some > > >> application development testing). What are the options for moving all > > the > > >> data and objects (tables, data, indexes, triggers, Foreign Keys, SP's > > >> etc...). Is there a way to use ontape to do a backup/restore from > > Solaris > > >> to Windows? What are the options? > > >> > > >> Thank You, > > >> > > >> --Dave > > >> > > >> --047d7bacb8eaeb30030515be8e99 > > > > > > > > > ******************************************************************************* > > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > > > Fernando Nunes > > > Portugal > > > > > > http://informix-technology.blogspot.com > > > My email works... but I don't check it frequently... > > > > > > --001a11c1f784d63fa80515bebaac > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --f46d044287500f35aa0515bf9bc8 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11c1f78428a65f0515c082ff

The main problem is that you have to make a lot of changes/configurations on the original (production?) system... On Sun, May 10, 2015 at 9:30 PM, Paul Watson <paul@oninit.com> wrote: > If you know ER then I would use that - just easy > > Cheers > Paul > > Paul Watson > Oninit www.oninit.com > +1 913 387 7529 > > Oninit® is a Registered Trademark of Oninit LLC > > > On May 10, 2015, at 14:52, Informix DBA <in4mixdba@gmail.com> wrote: > > > > Thank you Paul and Fernando. Will any of the ontape or onbar utilities > > work across different platforms? > > > > --Dave > > > >> On Sun, May 10, 2015 at 3:18 PM, Paul Watson <paul@oninit.com> wrote: > >> > >> Or lots of parallel hpl jobs > >> > >> Paul Watson > >> Oninit www.oninit.com > >> +1 913 387 7529 > >> > >> Oninit® is a Registered Trademark of Oninit LLC > >> > >>> On May 10, 2015, at 13:50, Fernando Nunes <domusonline@gmail.com> > wrote: > >>> > >>> dbexport/dbimport or distributed queries (INSERT INTO > >>> database@windows_server:table SELECT * FROM database@solaris_server > >> :table) > >>> Regards > >>> > >>>> On Sun, May 10, 2015 at 7:37 PM, Informix DBA <in4mixdba@gmail.com> > >> wrote: > >>>> > >>>> Hi, > >>>> > >>>> We are running Informix 11.70.FC7 on Solaris. We need to move the > entire > >>>> Informix instance to another OS, possibly windows (just for some > >>>> application development testing). What are the options for moving all > >> the > >>>> data and objects (tables, data, indexes, triggers, Foreign Keys, SP's > >>>> etc...). Is there a way to use ontape to do a backup/restore from > >> Solaris > >>>> to Windows? What are the options? > >>>> > >>>> Thank You, > >>>> > >>>> --Dave > >>>> > >>>> --047d7bacb8eaeb30030515be8e99 > > > > ******************************************************************************* > >>>> Forum Note: Use "Reply" to post a response in the discussion forum. > >>> > >>> -- > >>> Fernando Nunes > >>> Portugal > >>> > >>> http://informix-technology.blogspot.com > >>> My email works... but I don't check it frequently... > >>> > >>> --001a11c1f784d63fa80515bebaac > > > > ******************************************************************************* > >>> Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > > > > --f46d044287500f35aa0515bf9bc8 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11c1e5d03952c90515c085c7

Well on 11.70 there isn't as much management because of database templates. Not saying they should use it for certain, but it is a viable option Sent from my iPhone > On May 10, 2015, at 3:59 PM, Fernando Nunes <domusonline@gmail.com> wrote:= >=20 > The main problem is that you have to make a lot of changes/configurations=20= > on the original (production?) system...=20 >=20 > On Sun, May 10, 2015 at 9:30 PM, Paul Watson <paul@oninit.com> wrote:=20 >=20 >> If you know ER then I would use that - just easy=20 >>=20 >> Cheers=20 >> Paul=20 >>=20 >> Paul Watson=20 >> Oninit www.oninit.com=20 >> +1 913 387 7529=20 >>=20 >> Oninit=C2=AE is a Registered Trademark of Oninit LLC=20 >>=20 >>> On May 10, 2015, at 14:52, Informix DBA <in4mixdba@gmail.com> wrote:=20 >>>=20 >>> Thank you Paul and Fernando. Will any of the ontape or onbar utilities=20= >>> work across different platforms?=20 >>>=20 >>> --Dave=20 >>>=20 >>>> On Sun, May 10, 2015 at 3:18 PM, Paul Watson <paul@oninit.com> wrote:=20= >>>>=20 >>>> Or lots of parallel hpl jobs=20 >>>>=20 >>>> Paul Watson=20 >>>> Oninit www.oninit.com=20 >>>> +1 913 387 7529=20 >>>>=20 >>>> Oninit=C2=AE is a Registered Trademark of Oninit LLC=20 >>>>=20 >>>>> On May 10, 2015, at 13:50, Fernando Nunes <domusonline@gmail.com> >> wrote:=20 >>>>>=20 >>>>> dbexport/dbimport or distributed queries (INSERT INTO=20 >>>>> database@windows_server:table SELECT * FROM database@solaris_server >>>> :table)=20 >>>>> Regards=20 >>>>>=20 >>>>>> On Sun, May 10, 2015 at 7:37 PM, Informix DBA <in4mixdba@gmail.com> >>>> wrote:=20 >>>>>>=20 >>>>>> Hi,=20 >>>>>>=20 >>>>>> We are running Informix 11.70.FC7 on Solaris. We need to move the >> entire=20 >>>>>> Informix instance to another OS, possibly windows (just for some=20 >>>>>> application development testing). What are the options for moving all= >>>> the=20 >>>>>> data and objects (tables, data, indexes, triggers, Foreign Keys, SP's= =20 >>>>>> etc...). Is there a way to use ontape to do a backup/restore from >>>> Solaris=20 >>>>>> to Windows? What are the options?=20 >>>>>>=20 >>>>>> Thank You,=20 >>>>>>=20 >>>>>> --Dave=20 >>>>>>=20 >>>>>> --047d7bacb8eaeb30030515be8e99 > **************************************************************************= *****=20 >>>>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>>>>=20 >>>>> --=20 >>>>> Fernando Nunes=20 >>>>> Portugal=20 >>>>>=20 >>>>> http://informix-technology.blogspot.com=20 >>>>> My email works... but I don't check it frequently...=20 >>>>>=20 >>>>> --001a11c1f784d63fa80515bebaac > **************************************************************************= *****=20 >>>>> Forum Note: Use "Reply" to post a response in the discussion forum. > **************************************************************************= *****=20 >>>> Forum Note: Use "Reply" to post a response in the discussion forum. >>>=20 >>> --f46d044287500f35aa0515bf9bc8 > **************************************************************************= *****=20 >>> Forum Note: Use "Reply" to post a response in the discussion forum. > **************************************************************************= *****=20 >> Forum Note: Use "Reply" to post a response in the discussion forum. >=20 > --=20 > Fernando Nunes=20 > Portugal=20 >=20 > http://informix-technology.blogspot.com=20 > My email works... but I don't check it frequently...=20 >=20 > --001a11c1e5d03952c90515c085c7=20 >=20 >=20 > **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20

What are you dealing with? You allowed any downtime or are you 24x7? We are 24x7 and I migrated all of our data to new hardware with no downtime and no data loss using a combination of HPL, ER and custom scripts. It went a little something like this 1. Install and configure new engine 2. Create tables on new engine 3. Use HPL to migrate data to new system (express mode and things will be a little out of sync) 4. Create indexes, foreign keys, update stats, etc 5. Setup update anywhere ER between old and new engines for every table 6. Use ER to sync changes on old to new. Or use custom scripts to sync bigger tables if you can (i.e. we had a transaction table that logged changes to our main/biggest table so I could use that drive the sync which was faster than ER utilities) 7. Cut everything over to the new engine whenever you want 8. Leave ER on for a few weeks, or at least until you know you won't have to revert to the old system. Update anywhere replication keeps old in sync with new in case you have to revert. You just have to be sure all apps are either connected to old or new and not both at the same time to avoid collisions 9. Turn off/remove ER when you know you won't revert. This came in real handy because I could do everything except step #7 during the day and not during a 2 am maintenance window, there was no time crunch to get everything done because a system wasn't down for maintenance during the data migration, I had a safe place to quickly revert to if something went wrong with the new system. I did a presentation about it in 2008 I think, the slides should be on the IIUG website. I had previous experience with ER and HPL so the learning curve wasn't too bad and I was pretty sure our system could handle running ER. Maybe your situation is different, so YMMV. Andrew -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Informix DBA Sent: Sunday, May 10, 2015 1:38 PM To: ids@iiug.org Subject: Informix restore to another OS [35059] Hi, We are running Informix 11.70.FC7 on Solaris. We need to move the entire Informix instance to another OS, possibly windows (just for some application development testing). What are the options for moving all the data and objects (tables, data, indexes, triggers, Foreign Keys, SP's etc...). Is there a way to use ontape to do a backup/restore from Solaris to Windows? What are the options? Thank You, --Dave --047d7bacb8eaeb30030515be8e99 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

The OP may be able to use my dbexport/dbimport replacement utilities in the myexport package along with the myschema utility in my utils2_ak package. That will give him functionality equivalent to dbexport/dbimport but with the speed of HPL using external tables. 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 Sun, May 10, 2015 at 10:09 PM, Andrew Ford <andrew@informix-dba.com> wrote: > What are you dealing with? You allowed any downtime or are you 24x7? > > We are 24x7 and I migrated all of our data to new hardware with no downtime > and no data loss using a combination of HPL, ER and custom scripts. > > It went a little something like this > > 1. Install and configure new engine > 2. Create tables on new engine > 3. Use HPL to migrate data to new system (express mode and things will be a > little out of sync) > 4. Create indexes, foreign keys, update stats, etc > 5. Setup update anywhere ER between old and new engines for every table > 6. Use ER to sync changes on old to new. Or use custom scripts to sync > bigger tables if you can (i.e. we had a transaction table that logged > changes to our main/biggest table so I could use that drive the sync which > was faster than ER utilities) > 7. Cut everything over to the new engine whenever you want > 8. Leave ER on for a few weeks, or at least until you know you won't have > to > revert to the old system. Update anywhere replication keeps old in sync > with > new in case you have to revert. You just have to be sure all apps are > either > connected to old or new and not both at the same time to avoid collisions > 9. Turn off/remove ER when you know you won't revert. > > This came in real handy because I could do everything except step #7 during > the day and not during a 2 am maintenance window, there was no time crunch > to get everything done because a system wasn't down for maintenance during > the data migration, I had a safe place to quickly revert to if something > went wrong with the new system. I did a presentation about it in 2008 I > think, the slides should be on the IIUG website. > > I had previous experience with ER and HPL so the learning curve wasn't too > bad and I was pretty sure our system could handle running ER. Maybe your > situation is different, so YMMV. > > Andrew > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Informix DBA > Sent: Sunday, May 10, 2015 1:38 PM > To: ids@iiug.org > Subject: Informix restore to another OS [35059] > > Hi, > > We are running Informix 11.70.FC7 on Solaris. We need to move the entire > Informix instance to another OS, possibly windows (just for some > application > development testing). What are the options for moving all the data and > objects (tables, data, indexes, triggers, Foreign Keys, SP's etc...). Is > there a way to use ontape to do a backup/restore from Solaris to Windows? > What are the options? > > Thank You, > > --Dave > > --047d7bacb8eaeb30030515be8e99 > > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113efd628fe73f0515c5086d

Andrew, Thank you for the detailed steps. We are not using it to actually switch environments, rather do a proof of concept and application development, so just a copy in time would suffice. What did you use to get your schema? Tables, triggers, indexes, Stored Procedures etc... --Dave On Sun, May 10, 2015 at 10:09 PM, Andrew Ford <andrew@informix-dba.com> wrote: > What are you dealing with? You allowed any downtime or are you 24x7? > > We are 24x7 and I migrated all of our data to new hardware with no downtime > and no data loss using a combination of HPL, ER and custom scripts. > > It went a little something like this > > 1. Install and configure new engine > 2. Create tables on new engine > 3. Use HPL to migrate data to new system (express mode and things will be a > little out of sync) > 4. Create indexes, foreign keys, update stats, etc > 5. Setup update anywhere ER between old and new engines for every table > 6. Use ER to sync changes on old to new. Or use custom scripts to sync > bigger tables if you can (i.e. we had a transaction table that logged > changes to our main/biggest table so I could use that drive the sync which > was faster than ER utilities) > 7. Cut everything over to the new engine whenever you want > 8. Leave ER on for a few weeks, or at least until you know you won't have > to > revert to the old system. Update anywhere replication keeps old in sync > with > new in case you have to revert. You just have to be sure all apps are > either > connected to old or new and not both at the same time to avoid collisions > 9. Turn off/remove ER when you know you won't revert. > > This came in real handy because I could do everything except step #7 during > the day and not during a 2 am maintenance window, there was no time crunch > to get everything done because a system wasn't down for maintenance during > the data migration, I had a safe place to quickly revert to if something > went wrong with the new system. I did a presentation about it in 2008 I > think, the slides should be on the IIUG website. > > I had previous experience with ER and HPL so the learning curve wasn't too > bad and I was pretty sure our system could handle running ER. Maybe your > situation is different, so YMMV. > > Andrew > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Informix DBA > Sent: Sunday, May 10, 2015 1:38 PM > To: ids@iiug.org > Subject: Informix restore to another OS [35059] > > Hi, > > We are running Informix 11.70.FC7 on Solaris. We need to move the entire > Informix instance to another OS, possibly windows (just for some > application > development testing). What are the options for moving all the data and > objects (tables, data, indexes, triggers, Foreign Keys, SP's etc...). Is > there a way to use ontape to do a backup/restore from Solaris to Windows? > What are the options? > > Thank You, > > --Dave > > --047d7bacb8eaeb30030515be8e99 > > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013d0f3842881e0515ce27f2

You can use dbschema -ss or my dbschema replacement utility myschema. 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 Mon, May 11, 2015 at 9:14 AM, Informix DBA <in4mixdba@gmail.com> wrote: > Andrew, > > Thank you for the detailed steps. We are not using it to actually switch > environments, rather do a proof of concept and application development, so > just a copy in time would suffice. > > What did you use to get your schema? Tables, triggers, indexes, Stored > Procedures etc... > > --Dave > > On Sun, May 10, 2015 at 10:09 PM, Andrew Ford <andrew@informix-dba.com> > wrote: > > > What are you dealing with? You allowed any downtime or are you 24x7? > > > > We are 24x7 and I migrated all of our data to new hardware with no > downtime > > and no data loss using a combination of HPL, ER and custom scripts. > > > > It went a little something like this > > > > 1. Install and configure new engine > > 2. Create tables on new engine > > 3. Use HPL to migrate data to new system (express mode and things will > be a > > little out of sync) > > 4. Create indexes, foreign keys, update stats, etc > > 5. Setup update anywhere ER between old and new engines for every table > > 6. Use ER to sync changes on old to new. Or use custom scripts to sync > > bigger tables if you can (i.e. we had a transaction table that logged > > changes to our main/biggest table so I could use that drive the sync > which > > was faster than ER utilities) > > 7. Cut everything over to the new engine whenever you want > > 8. Leave ER on for a few weeks, or at least until you know you won't have > > to > > revert to the old system. Update anywhere replication keeps old in sync > > with > > new in case you have to revert. You just have to be sure all apps are > > either > > connected to old or new and not both at the same time to avoid collisions > > 9. Turn off/remove ER when you know you won't revert. > > > > This came in real handy because I could do everything except step #7 > during > > the day and not during a 2 am maintenance window, there was no time > crunch > > to get everything done because a system wasn't down for maintenance > during > > the data migration, I had a safe place to quickly revert to if something > > went wrong with the new system. I did a presentation about it in 2008 I > > think, the slides should be on the IIUG website. > > > > I had previous experience with ER and HPL so the learning curve wasn't > too > > bad and I was pretty sure our system could handle running ER. Maybe your > > situation is different, so YMMV. > > > > Andrew > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Informix DBA > > Sent: Sunday, May 10, 2015 1:38 PM > > To: ids@iiug.org > > Subject: Informix restore to another OS [35059] > > > > Hi, > > > > We are running Informix 11.70.FC7 on Solaris. We need to move the entire > > Informix instance to another OS, possibly windows (just for some > > application > > development testing). What are the options for moving all the data and > > objects (tables, data, indexes, triggers, Foreign Keys, SP's etc...). Is > > there a way to use ontape to do a backup/restore from Solaris to Windows? > > What are the options? > > > > Thank You, > > > > --Dave > > > > --047d7bacb8eaeb30030515be8e99 > > > > > > > **************************************************************************** > > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e013d0f3842881e0515ce27f2 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf3026662a44318c0515ce5a67

Thank you Art, I will check out your dbexport/dbimport and myschema replacement utilities. Thank You, --Dave On Mon, May 11, 2015 at 9:28 AM, Art Kagel <art.kagel@gmail.com> wrote: > You can use dbschema -ss or my dbschema replacement utility myschema. > > 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 Mon, May 11, 2015 at 9:14 AM, Informix DBA <in4mixdba@gmail.com> wrote: > > > Andrew, > > > > Thank you for the detailed steps. We are not using it to actually switch > > environments, rather do a proof of concept and application development, > so > > just a copy in time would suffice. > > > > What did you use to get your schema? Tables, triggers, indexes, Stored > > Procedures etc... > > > > --Dave > > > > On Sun, May 10, 2015 at 10:09 PM, Andrew Ford <andrew@informix-dba.com> > > wrote: > > > > > What are you dealing with? You allowed any downtime or are you 24x7? > > > > > > We are 24x7 and I migrated all of our data to new hardware with no > > downtime > > > and no data loss using a combination of HPL, ER and custom scripts. > > > > > > It went a little something like this > > > > > > 1. Install and configure new engine > > > 2. Create tables on new engine > > > 3. Use HPL to migrate data to new system (express mode and things will > > be a > > > little out of sync) > > > 4. Create indexes, foreign keys, update stats, etc > > > 5. Setup update anywhere ER between old and new engines for every table > > > 6. Use ER to sync changes on old to new. Or use custom scripts to sync > > > bigger tables if you can (i.e. we had a transaction table that logged > > > changes to our main/biggest table so I could use that drive the sync > > which > > > was faster than ER utilities) > > > 7. Cut everything over to the new engine whenever you want > > > 8. Leave ER on for a few weeks, or at least until you know you won't > have > > > to > > > revert to the old system. Update anywhere replication keeps old in sync > > > with > > > new in case you have to revert. You just have to be sure all apps are > > > either > > > connected to old or new and not both at the same time to avoid > collisions > > > 9. Turn off/remove ER when you know you won't revert. > > > > > > This came in real handy because I could do everything except step #7 > > during > > > the day and not during a 2 am maintenance window, there was no time > > crunch > > > to get everything done because a system wasn't down for maintenance > > during > > > the data migration, I had a safe place to quickly revert to if > something > > > went wrong with the new system. I did a presentation about it in 2008 I > > > think, the slides should be on the IIUG website. > > > > > > I had previous experience with ER and HPL so the learning curve wasn't > > too > > > bad and I was pretty sure our system could handle running ER. Maybe > your > > > situation is different, so YMMV. > > > > > > Andrew > > > > > > -----Original Message----- > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > > Informix DBA > > > Sent: Sunday, May 10, 2015 1:38 PM > > > To: ids@iiug.org > > > Subject: Informix restore to another OS [35059] > > > > > > Hi, > > > > > > We are running Informix 11.70.FC7 on Solaris. We need to move the > entire > > > Informix instance to another OS, possibly windows (just for some > > > application > > > development testing). What are the options for moving all the data and > > > objects (tables, data, indexes, triggers, Foreign Keys, SP's etc...). > Is > > > there a way to use ontape to do a backup/restore from Solaris to > Windows? > > > What are the options? > > > > > > Thank You, > > > > > > --Dave > > > > > > --047d7bacb8eaeb30030515be8e99 > > > > > > > > > > > > **************************************************************************** > > > *** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --089e013d0f3842881e0515ce27f2 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --20cf3026662a44318c0515ce5a67 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9cc9f9654b9270515ce6996

Dave: Get the latest copy of my utils2_ak package (that contains myschema) from my web site: www.askdbmgt.com/myutilities.html That version contains a couple of recent bug fixes that I have not uploaded to the IIUG site yet (not finished reversion testing). 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 Mon, May 11, 2015 at 9:33 AM, Informix DBA <in4mixdba@gmail.com> wrote: > Thank you Art, > > I will check out your dbexport/dbimport and myschema replacement utilities. > > Thank You, > > --Dave > > On Mon, May 11, 2015 at 9:28 AM, Art Kagel <art.kagel@gmail.com> wrote: > > > You can use dbschema -ss or my dbschema replacement utility myschema. > > > > 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 Mon, May 11, 2015 at 9:14 AM, Informix DBA <in4mixdba@gmail.com> > wrote: > > > > > Andrew, > > > > > > Thank you for the detailed steps. We are not using it to actually > switch > > > environments, rather do a proof of concept and application development, > > so > > > just a copy in time would suffice. > > > > > > What did you use to get your schema? Tables, triggers, indexes, Stored > > > Procedures etc... > > > > > > --Dave > > > > > > On Sun, May 10, 2015 at 10:09 PM, Andrew Ford <andrew@informix-dba.com > > > > > wrote: > > > > > > > What are you dealing with? You allowed any downtime or are you 24x7? > > > > > > > > We are 24x7 and I migrated all of our data to new hardware with no > > > downtime > > > > and no data loss using a combination of HPL, ER and custom scripts. > > > > > > > > It went a little something like this > > > > > > > > 1. Install and configure new engine > > > > 2. Create tables on new engine > > > > 3. Use HPL to migrate data to new system (express mode and things > will > > > be a > > > > little out of sync) > > > > 4. Create indexes, foreign keys, update stats, etc > > > > 5. Setup update anywhere ER between old and new engines for every > table > > > > 6. Use ER to sync changes on old to new. Or use custom scripts to > sync > > > > bigger tables if you can (i.e. we had a transaction table that logged > > > > changes to our main/biggest table so I could use that drive the sync > > > which > > > > was faster than ER utilities) > > > > 7. Cut everything over to the new engine whenever you want > > > > 8. Leave ER on for a few weeks, or at least until you know you won't > > have > > > > to > > > > revert to the old system. Update anywhere replication keeps old in > sync > > > > with > > > > new in case you have to revert. You just have to be sure all apps are > > > > either > > > > connected to old or new and not both at the same time to avoid > > collisions > > > > 9. Turn off/remove ER when you know you won't revert. > > > > > > > > This came in real handy because I could do everything except step #7 > > > during > > > > the day and not during a 2 am maintenance window, there was no time > > > crunch > > > > to get everything done because a system wasn't down for maintenance > > > during > > > > the data migration, I had a safe place to quickly revert to if > > something > > > > went wrong with the new system. I did a presentation about it in > 2008 I > > > > think, the slides should be on the IIUG website. > > > > > > > > I had previous experience with ER and HPL so the learning curve > wasn't > > > too > > > > bad and I was pretty sure our system could handle running ER. Maybe > > your > > > > situation is different, so YMMV. > > > > > > > > Andrew > > > > > > > > -----Original Message----- > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf > Of > > > > Informix DBA > > > > Sent: Sunday, May 10, 2015 1:38 PM > > > > To: ids@iiug.org > > > > Subject: Informix restore to another OS [35059] > > > > > > > > Hi, > > > > > > > > We are running Informix 11.70.FC7 on Solaris. We need to move the > > entire > > > > Informix instance to another OS, possibly windows (just for some > > > > application > > > > development testing). What are the options for moving all the data > and > > > > objects (tables, data, indexes, triggers, Foreign Keys, SP's etc...). > > Is > > > > there a way to use ontape to do a backup/restore from Solaris to > > Windows? > > > > What are the options? > > > > > > > > Thank You, > > > > > > > > --Dave > > > > > > > > --047d7bacb8eaeb30030515be8e99 > > > > > > > > > > > > > > > > > > **************************************************************************** > > > > *** > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --089e013d0f3842881e0515ce27f2 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --20cf3026662a44318c0515ce5a67 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --14dae9cc9f9654b9270515ce6996 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec51969417623310515ceb07e

I used Art's myschema, of course. Twas never a better utility written. Well maybe, dostats. :) -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Informix DBA Sent: Monday, May 11, 2015 8:14 AM To: ids@iiug.org Subject: Re: Informix restore to another OS [35070] Andrew, Thank you for the detailed steps. We are not using it to actually switch environments, rather do a proof of concept and application development, so just a copy in time would suffice. What did you use to get your schema? Tables, triggers, indexes, Stored Procedures etc... --Dave On Sun, May 10, 2015 at 10:09 PM, Andrew Ford <andrew@informix-dba.com> wrote: > What are you dealing with? You allowed any downtime or are you 24x7? > > We are 24x7 and I migrated all of our data to new hardware with no > downtime and no data loss using a combination of HPL, ER and custom scripts. > > It went a little something like this > > 1. Install and configure new engine > 2. Create tables on new engine > 3. Use HPL to migrate data to new system (express mode and things will > be a little out of sync) 4. Create indexes, foreign keys, update > stats, etc 5. Setup update anywhere ER between old and new engines for > every table 6. Use ER to sync changes on old to new. Or use custom > scripts to sync bigger tables if you can (i.e. we had a transaction > table that logged changes to our main/biggest table so I could use > that drive the sync which was faster than ER utilities) 7. Cut > everything over to the new engine whenever you want 8. Leave ER on for > a few weeks, or at least until you know you won't have to revert to > the old system. Update anywhere replication keeps old in sync with new > in case you have to revert. You just have to be sure all apps are > either connected to old or new and not both at the same time to avoid > collisions 9. Turn off/remove ER when you know you won't revert. > > This came in real handy because I could do everything except step #7 > during the day and not during a 2 am maintenance window, there was no > time crunch to get everything done because a system wasn't down for > maintenance during the data migration, I had a safe place to quickly > revert to if something went wrong with the new system. I did a > presentation about it in 2008 I think, the slides should be on the IIUG website. > > I had previous experience with ER and HPL so the learning curve wasn't > too bad and I was pretty sure our system could handle running ER. > Maybe your situation is different, so YMMV. > > Andrew > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Informix DBA > Sent: Sunday, May 10, 2015 1:38 PM > To: ids@iiug.org > Subject: Informix restore to another OS [35059] > > Hi, > > We are running Informix 11.70.FC7 on Solaris. We need to move the > entire Informix instance to another OS, possibly windows (just for > some application development testing). What are the options for moving > all the data and objects (tables, data, indexes, triggers, Foreign > Keys, SP's etc...). Is there a way to use ontape to do a > backup/restore from Solaris to Windows? > What are the options? > > Thank You, > > --Dave > > --047d7bacb8eaeb30030515be8e99 > > > ********************************************************************** > ****** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013d0f3842881e0515ce27f2 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.