Hi Uday,
We did considered using the HPL but only because that was the only thing
available and it takes a lot of configuration work, we are kinnda short
on time and the product we are working on will be deployed to various
other clients so we were looking for a generic solution. By the way is
there a way of running HPL without creating its underlying database and
stuff. I mean just run it like a command line utility more like bulk
loader available for SQL server?

Thanks and Regards,
Aash

-----Original Message-----
From: Uday Kale [mailto:udayk@us.ibm.com]
Sent: Friday, December 09, 2005 9:25 PM
To: Aashish Ramsinghani - ASDC, Chennai
Cc: informix-list@iiug.org; owner-informix-list@iiug.org
Subject: Re: Moving Informix TableSpaces between databases



I think your best bet would be to use HPL to unload data from the logged
db and load it into the non-logged db as long as they both have the same
schema(=table definition).

Regards,
Uday.

Inactive hide details for "Aashish Ramsinghani - ASDC, Chennai" '
src="cid:437041605@12122005-1cb3" width=16 border=0>"Aashish Ramsinghani
- ASDC, Chennai" <Aashishsr@hcl.in>






"Aashish Ramsinghani - ASDC, Chennai" <Aashishsr@hcl.in>
Sent by: owner-informix-list@iiug.org

12/09/2005 07:01 AM




To

informix-list@iiug.org



cc





Subject

Moving Informix TableSpaces between databases


Hi I am using Informix for one of my DW projects.
We are loading data from the source system into the staging area both
are separate Databases. Source has logging enables and staging has it
disabled. The problem comes when I try to access data across both these
databases. I cannot link tables between these databases because of their
logging properties. So I am dumping the data into a CSV file and loading
it again but for my initial load which consists of 40+ million records
it is a problem. In oracle I know we can make a separate table space and
dump the data there then load the table space to another database. I
don't know if such a thing is possible in Informix.

Any help will be appreciated.

Thanks and Regards,
Aash
sending to informix-list

[demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif]
sending to informix-list