upgrading from 7.3.0 to 9.2

Hi, We are running informix 7.3.0.UC3 and we heard it's support is being 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. 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. Thanks -AH Sent via Deja.com http://www.deja.com/ Before you buy.

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