Migrating data between Informix Platforms without

Good morning, I'm sure this question has probably been asked before. Is it possible to routinely copy data / migrate data from Informix databases between different platforms without HDR/ER replication? I've used dbimport/export, and that isn't feasible to automate as a cron. I have been reviewing the high performance loader utility. It appears to be kind of similar to onunload/onload. The reason for the question is that I use Cognos Reporting software that is bogging down my production box, Informix 10.00.FC5 under HPUX 11.23. It would be nice to do something similar to onunlaod/onload to an inexpensive Linux server running IDS 10.00. ER won't work because my ERP vendor won't allow primary keys on several tables. If high performance loader won't "unload" between IDS platforms, will archecker/onbar be able to restore from IDS on HPUX to IDS on Linux on database or table level? Thank-you in advance for any insight or experiences with these tools. Jonathan B. Smaby Pomona College, ITS-AISO Office jonathan.smaby@pomona.edu Tel. (909) 621-8506 ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.

I've had similar issues with Brio reports. One possible fix is to force the report generation to use PDQ. In this way, the BUFFERS are not flushed and you get to use lightscan buffers. I've been able to up the RA_THRESHOLD/RA_PAGES significantly with no ill effects to OLTP and improve the report generation performance.

Art's utilities on IIUG web site. They do it all. utils2_ak in the repository. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Smaby Sent: Tuesday, November 27, 2007 12:24 PM To: ids@iiug.org Subject: Migrating data between Informix Platforms with.... [10488] Good morning, I'm sure this question has probably been asked before. Is it possible to routinely copy data / migrate data from Informix databases between different platforms without HDR/ER replication? I've used dbimport/export, and that isn't feasible to automate as a cron. I have been reviewing the high performance loader utility. It appears to be kind of similar to onunload/onload. The reason for the question is that I use Cognos Reporting software that is bogging down my production box, Informix 10.00.FC5 under HPUX 11.23. It would be nice to do something similar to onunlaod/onload to an inexpensive Linux server running IDS 10.00. ER won't work because my ERP vendor won't allow primary keys on several tables. If high performance loader won't "unload" between IDS platforms, will archecker/onbar be able to restore from IDS on HPUX to IDS on Linux on database or table level? Thank-you in advance for any insight or experiences with these tools. Jonathan B. Smaby Pomona College, ITS-AISO Office jonathan.smaby@pomona.edu Tel. (909) 621-8506 ------------------------------------------------------------- This message has been scanned by Postini anti-virus software. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Jonathan Smaby wrote: > Good morning, > Bob Roussey's comments aren't far off. Utils2_ak doesn't do EVERYTHING, but it's highly useful and does have features for your needs. In utils2_ak you'll find my dbcopy utility which can copy data from one server to another very quickly and my ul.ec utility which will export a table's contents (actually the result of any SQL SELECT) to a binary file which is platform independent and reload the file onto another server. But what I think Bob is thinking of is my dbexport/dbimport replacement utility myexport which, while it requires my myschema utility from utils2_ak, is actually a separate package. Myexport also requires Jonathan Leffler's sqlcmd package and/or Ravi Krishna's myonpload either of which can optionally be used to actually perform the exports and imports. Myexport is fully compatible with dbexport and dbimport but unlike dbexport myexport does not take a lock on the database, so it can be used successfully in a cron script. Instead it depends on exporting all tables in parallel to minimize relational integrity constraint violations during import. > I'm sure this question has probably been asked before. Is it possible to > routinely copy data / migrate data from Informix databases between different > platforms without HDR/ER replication? I've used dbimport/export, and that > isn't feasible to automate as a cron. I have been reviewing the high > performance loader utility. It appears to be kind of similar to > onunload/onload. The reason for the question is that I use Cognos Reporting > software that is bogging down my production box, Informix 10.00.FC5 under > HPUX 11.23. It would be nice to do something similar to onunlaod/onload to > an inexpensive Linux server running IDS 10.00. ER won't work because my ERP > vendor won't allow primary keys on several tables. > > If high performance loader won't "unload" between IDS platforms, will > Yes, you can use HPLoader to port data from one platform to another. The output format for the export files is configurable and a pipe delimited file such as is used by dbexport/dbimport as well as dbaccess and dbload is a default option. Myexport uses that feature to emulate dbexport. Beyond that you can always write your own input and outpuu translation modules for HPLoader and use whatever format you want. > archecker/onbar be able to restore from IDS on HPUX to IDS on Linux on > database or table level? > Yes, you can also use archecker's restore feature to read the HPUX tape and write data to tables on the Linux server. You'll probably have to run archecker on the HP platform, but as long as that machine's sqlhosts file knows about the Linux server instance it will be able to write the rows to tables there. > Thank-you in advance for any insight or experiences with these tools. > No sweat. Art S. Kagel > Jonathan B. Smaby > Pomona College, ITS-AISO Office > jonathan.smaby@pomona.edu > Tel. (909) 621-8506 > > ------------------------------------------------------------- > This message has been scanned by Postini anti-virus software. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >