RE: upgrading from 7.3.0 to 9.2

Posted in 2000

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion, Java & JDBC Development

mosserp@WellsFargo.COM — Tue, 9 May 2000 12:07:12 -0700 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFB9E9.CB6F7F86 Content-Type: text/plain; charset="iso-8859-1" Art, Do you have a bug # for the dbexport problem? Or maybe even just a case #? I asked our Enterprise Support engineer about this, and he couldn't find anything on it. He even went out and set up a 7.3x stores database and then converted it to 9.2 -- dbexport worked just fine for him???!! We're getting ready to do a lot of conversions this year, and this one sounds like a real gotcha. Thanks, Paul Mosser -----Original Message----- From: Art S. Kagel [mailto:kagel@bloomberg.net] Sent: Tuesday, May 09, 2000 11:33 AM To: informix-list@iiug.org Subject: Re: upgrading from 7.3.0 to 9.2 hash100@my-deja.com wrote: > > Hi, > > We are running informix 7.3.0.UC3 and we heard it's support is being That would be 7.30UC3 Oracle uses all those dots not Informix. Just being nit picky. ;-) > sometime within a year. We are thinking of migrating to 9.2. > Our application is sort of OLTP with not heavy usage. Here is a > general description of our system: > 1. we use C/esqlc to interact with database > 2. we also use some ACE based reports > 3. we also have a Java server that uses informix jdbc driver to connect > to the database. We are using JDK1.2.2. > 4. Our tables use char type columns only. Database size couple hundred > MBs. > 5. We don't use BLOB. Except for the possibility of moving some of the Java into server eventually 9.2x does not add much value for you though it is a bit faster than 7.30. > Has anybody done this upgrade, are their any issues we should know > about. Or given our setup above, we can upgrade without any worry ? > Pls also cc me in your reply. The only problem I know about is that if you convert an existing 7.3x server to 9.20 dbexport will refuse to export the old format database as its system catalog files are apparently not completely converted. But new tables/databases dbexport fine. (You could use my new dbexport/dbimport replacement utility package, myexport, to export the old format database and recreate it as a 9.2x database. Myexport is availble from the IIUG Software Repository it was loaded up yesterday.) Art S. Kagel ------_=_NextPart_001_01BFB9E9.CB6F7F86 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: upgrading from 7.3.0 to 9.2</TITLE> </HEAD> <BODY> Art, Do you have a bug # for the dbexport problem?  = Or maybe even just a case #?  I asked our Enterprise Support = engineer about this, and he couldn't find anything on it.  He even = went out and set up a 7.3x stores database and then converted it to 9.2 = -- dbexport worked just fine for him???!!  We're getting ready to = do a lot of conversions this year, and this one sounds like a real = gotcha. Thanks, Paul Mosser -----Original Message----- From: Art S. Kagel [<A = HREF=3D"mailto:kagel@bloomberg.net">mailto:kagel@bloomberg.net</A>]</FON= T> Sent: Tuesday, May 09, 2000 11:33 AM To: informix-list@iiug.org Subject: Re: upgrading from 7.3.0 to 9.2 hash100@my-deja.com wrote: > > Hi, > > We are running informix 7.3.0.UC3 and we heard = it's support is being That would be 7.30UC3 Oracle uses all those dots not = Informix. Just being nit picky. ;-) > sometime within a year. We are thinking of = migrating to 9.2. > Our application is sort of OLTP with not heavy = usage. Here is a > general description of our system: > 1. we use C/esqlc to interact with = database > 2. we also use some ACE based reports > 3. we also have a Java server that uses = informix jdbc driver to connect >    to the database. We are using = JDK1.2.2. > 4. Our tables use char type columns only. = Database size couple hundred >     MBs. > 5. We don't use BLOB. Except for the possibility of moving some of the Java = into server eventually 9.2x does not add much value for you though it is a = bit faster than 7.30. > Has anybody done this upgrade, are their any = issues we should know > about. Or given our setup above, we can upgrade = without any worry ? > Pls also cc me in your reply. The only problem I know about is that if you convert = an existing 7.3x server to 9.20 dbexport will refuse to export the old = format database as its system catalog files are apparently not completely = converted.  But new tables/databases dbexport fine.  (You could use = my new dbexport/dbimport replacement utility package, myexport, to export the = old format database and recreate it as a 9.2x database.  Myexport is = availble from the IIUG Software Repository it was loaded up = yesterday.) Art S. Kagel </BODY> </HTML> ------_=_NextPart_001_01BFB9E9.CB6F7F86--

↪ replying to mosserp@WellsFargo.COM

Art S. Kagel — Tue, 09 May 2000 16:30:27 -0400 — source: Informix-list mailing list archive (1991-1998)

mosserp@WellsFargo.COM wrote: OK, I looked back through the Archive and found the original posting. It was not about dbexport but rather about onunload. The post was on 4/7 from Richard Lewis" <richard.lewis@nospam-gerling.com.au> the gist is: *** BEGIN EXTRACT *** However, as an extra backup, I have a script running at night that takes a copy of selected databases using "onunload". Would you believe that a database converted from an earlier version of IDS is not considered suitable by onunload !!!??? Here is the message: ERROR: Onunload is not capable of unloading a database converted from a previous version. Please use another Informix unload/load mechanism to export this database. Dump failed What does this tell you about the database in use by your application ? Is it any good ? In addition, if you create a new database and migrate the data across, then change your mind and want to go back to 7.30, you cannot do so. The reason given in the Migration Guide is that you cannot migrate a database created by 9.20 to an earlier version. *** END EXTRACT *** > Art, > > Do you have a bug # for the dbexport problem? Or maybe even just a case #? > I asked our Enterprise Support engineer about this, and he couldn't find > anything on it. He even went out and set up a 7.3x stores database and then > converted it to 9.2 -- dbexport worked just fine for him???!! We're getting > ready to do a lot of conversions this year, and this one sounds like a real > gotcha. > > Thanks, > Paul Mosser > > -----Original Message----- > From: Art S. Kagel [mailto:kagel@bloomberg.net] > Sent: Tuesday, May 09, 2000 11:33 AM > To: informix-list@iiug.org > Subject: Re: upgrading from 7.3.0 to 9.2 > > hash100@my-deja.com wrote: > > > > Hi, > > > > We are running informix 7.3.0.UC3 and we heard it's support is being > > That would be 7.30UC3 Oracle uses all those dots not Informix. Just being > nit picky. ;-) > > > sometime within a year. We are thinking of migrating to 9.2. > > Our application is sort of OLTP with not heavy usage. Here is a > > general description of our system: > > 1. we use C/esqlc to interact with database > > 2. we also use some ACE based reports > > 3. we also have a Java server that uses informix jdbc driver to connect > > to the database. We are using JDK1.2.2. > > 4. Our tables use char type columns only. Database size couple hundred > > MBs. > > 5. We don't use BLOB. > > Except for the possibility of moving some of the Java into server eventually > > 9.2x does not add much value for you though it is a bit faster than 7.30. > > > Has anybody done this upgrade, are their any issues we should know > > about. Or given our setup above, we can upgrade without any worry ? > > Pls also cc me in your reply. > > The only problem I know about is that if you convert an existing 7.3x server > > to 9.20 dbexport will refuse to export the old format database as its > system catalog files are apparently not completely converted. But new > tables/databases dbexport fine. (You could use my new dbexport/dbimport > replacement utility package, myexport, to export the old format database and > > recreate it as a 9.2x database. Myexport is availble from the IIUG > Software Repository it was loaded up yesterday.) > > Art S. Kagel > > ------_=_NextPart_001_01BFB9E9.CB6F7F86 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Diso-8859-1"> > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > 5.5.2448.0"> > <TITLE>RE: upgrading from 7.3.0 to 9.2</TITLE> > </HEAD> > <BODY> > > Art, > > > Do you have a bug # for the dbexport problem?  = > Or maybe even just a case #?  I asked our Enterprise Support = > engineer about this, and he couldn't find anything on it.  He even = > went out and set up a 7.3x stores database and then converted it to 9.2 = > -- dbexport worked just fine for him???!!  We're getting ready to = > do a lot of conversions this year, and this one sounds like a real = > gotcha. > > Thanks, > Paul Mosser > > > -----Original Message----- > From: Art S. Kagel [<A = > HREF=3D"mailto:kagel@bloomberg.net">mailto:kagel@bloomberg.net</A>]</FON= > T> > Sent: Tuesday, May 09, 2000 11:33 AM > To: informix-list@iiug.org > Subject: Re: upgrading from 7.3.0 to 9.2 > > > > hash100@my-deja.com wrote: > > > > Hi, > > > > We are running informix 7.3.0.UC3 and we heard = > it's support is being > > > That would be 7.30UC3 Oracle uses all those dots not = > Informix. Just being > nit picky. ;-) > > > > sometime within a year. We are thinking of = > migrating to 9.2. > > Our application is sort of OLTP with not heavy = > usage. Here is a > > general description of our system: > > 1. we use C/esqlc to interact with = > database > > 2. we also use some ACE based reports > > 3. we also have a Java server that uses = > informix jdbc driver to connect > >    to the database. We are using = > JDK1.2.2. > > 4. Our tables use char type columns only. = > Database size couple hundred > >     MBs. > > 5. We don't use BLOB. > > > Except for the possibility of moving some of the Java = > into server eventually > 9.2x does not add much value for you though it is a = > bit faster than 7.30. > > > > Has anybody done this upgrade, are their any = > issues we should know > > about. Or given our setup above, we can upgrade = > without any worry ? > > Pls also cc me in your reply. > > > The only problem I know about is that if you convert = > an existing 7.3x server > to 9.20 dbexport will refuse to export the old = > format database as its > system catalog files are apparently not completely = > converted.  But new > tables/databases dbexport fine.  (You could use = > my new dbexport/dbimport

↪ replying to mosserp@WellsFargo.COM

Doug McAllister — Thu, 18 May 2000 13:26:41 -0400 — source: Informix-list mailing list archive (1991-1998)

Looks like bug #123380 from techinfo mosserp@WellsFargo.COM wrote: > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------_=_NextPart_001_01BFB9E9.CB6F7F86 > Content-Type: text/plain; > charset="iso-8859-1" > > Art, > > Do you have a bug # for the dbexport problem? Or maybe even just a case #? > I asked our Enterprise Support engineer about this, and he couldn't find > anything on it. He even went out and set up a 7.3x stores database and then > converted it to 9.2 -- dbexport worked just fine for him???!! We're getting > ready to do a lot of conversions this year, and this one sounds like a real > gotcha. > > Thanks, > Paul Mosser > > -----Original Message----- > From: Art S. Kagel [mailto:kagel@bloomberg.net] > Sent: Tuesday, May 09, 2000 11:33 AM > To: informix-list@iiug.org > Subject: Re: upgrading from 7.3.0 to 9.2 > > hash100@my-deja.com wrote: > > > > Hi, > > > > We are running informix 7.3.0.UC3 and we heard it's support is being > > That would be 7.30UC3 Oracle uses all those dots not Informix. Just being > nit picky. ;-) > > > sometime within a year. We are thinking of migrating to 9.2. > > Our application is sort of OLTP with not heavy usage. Here is a > > general description of our system: > > 1. we use C/esqlc to interact with database > > 2. we also use some ACE based reports > > 3. we also have a Java server that uses informix jdbc driver to connect > > to the database. We are using JDK1.2.2. > > 4. Our tables use char type columns only. Database size couple hundred > > MBs. > > 5. We don't use BLOB. > > Except for the possibility of moving some of the Java into server eventually > > 9.2x does not add much value for you though it is a bit faster than 7.30. > > > Has anybody done this upgrade, are their any issues we should know > > about. Or given our setup above, we can upgrade without any worry ? > > Pls also cc me in your reply. > > The only problem I know about is that if you convert an existing 7.3x server > > to 9.20 dbexport will refuse to export the old format database as its > system catalog files are apparently not completely converted. But new > tables/databases dbexport fine. (You could use my new dbexport/dbimport > replacement utility package, myexport, to export the old format database and > > recreate it as a 9.2x database. Myexport is availble from the IIUG > Software Repository it was loaded up yesterday.) > > Art S. Kagel > > ------_=_NextPart_001_01BFB9E9.CB6F7F86 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Diso-8859-1"> > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > 5.5.2448.0"> > <TITLE>RE: upgrading from 7.3.0 to 9.2</TITLE> > </HEAD> > <BODY> > > Art, > > > Do you have a bug # for the dbexport problem?  = > Or maybe even just a case #?  I asked our Enterprise Support = > engineer about this, and he couldn't find anything on it.  He even = > went out and set up a 7.3x stores database and then converted it to 9.2 = > -- dbexport worked just fine for him???!!  We're getting ready to = > do a lot of conversions this year, and this one sounds like a real = > gotcha. > > Thanks, > Paul Mosser > > > -----Original Message----- > From: Art S. Kagel [<A = > HREF=3D"mailto:kagel@bloomberg.net">mailto:kagel@bloomberg.net</A>]</FON= > T> > Sent: Tuesday, May 09, 2000 11:33 AM > To: informix-list@iiug.org > Subject: Re: upgrading from 7.3.0 to 9.2 > > > > hash100@my-deja.com wrote: > > > > Hi, > > > > We are running informix 7.3.0.UC3 and we heard = > it's support is being > > > That would be 7.30UC3 Oracle uses all those dots not = > Informix. Just being > nit picky. ;-) > > > > sometime within a year. We are thinking of = > migrating to 9.2. > > Our application is sort of OLTP with not heavy = > usage. Here is a > > general description of our system: > > 1. we use C/esqlc to interact with = > database > > 2. we also use some ACE based reports > > 3. we also have a Java server that uses = > informix jdbc driver to connect > >    to the database. We are using = > JDK1.2.2. > > 4. Our tables use char type columns only. = > Database size couple hundred > >     MBs. > > 5. We don't use BLOB. > > > Except for the possibility of moving some of the Java = > into server eventually > 9.2x does not add much value for you though it is a = > bit faster than 7.30. > > > > Has anybody done this upgrade, are their any = > issues we should know > > about. Or given our setup above, we can upgrade = > without any worry ? > > Pls also cc me in your reply. > > > The only problem I know about is that if you convert = > an existing 7.3x server > to 9.20 dbexport will refuse to export the old = > format database as its > system catalog files are apparently not completely = > converted.  But new > tables/databases dbexport fine.  (You could use = > my new dbexport/dbimport > replacement utility package, myexport, to export the = > old format database and > recreate it as a 9.2x database.  Myexport is = > availble from the IIUG > Software Repository it was loaded up = > yesterday.) > > > Art S. Kagel > > > </BODY> > </HTML> > ------_=_NextPart_001_01BFB9E9.CB6F7F86--

RE: upgrading from 7.3.0 to 9.2

Related threads

Glossary

Your privacy choices