Hi All,
I need to transform large amount of record from DBase IV free tables into DB2 v7.2. The total DBase files size is 1.94GB and is around 12 million records. The process has to be run as much "Unattended" as possible, and have to finish within 2 days.
Currently I am using ADO in VB6 to connect to both DBase IV and DB2, then pull data out of DBase, transform the record and insert into DB2, the process is running fine, except it takes more than 10 days to complete the whole process...:-(
Then instead of doing the transformation in VB, I simply pull data out of DBase and insert into DB2, and do the transformation within DB2, but the whole process still take more than a week...:-(
The bottleneck is due to 2 different databases are involved and I have to deal with one record at a time.
Any suggestion that can improve the process time will be much appreciated.
Thank in advance.
I need to transform large amount of record from DBase IV free tables into DB2 v7.2. The total DBase files size is 1.94GB and is around 12 million records. The process has to be run as much "Unattended" as possible, and have to finish within 2 days.
Currently I am using ADO in VB6 to connect to both DBase IV and DB2, then pull data out of DBase, transform the record and insert into DB2, the process is running fine, except it takes more than 10 days to complete the whole process...:-(
Then instead of doing the transformation in VB, I simply pull data out of DBase and insert into DB2, and do the transformation within DB2, but the whole process still take more than a week...:-(
The bottleneck is due to 2 different databases are involved and I have to deal with one record at a time.
Any suggestion that can improve the process time will be much appreciated.
Thank in advance.