RCP on ODBC stage - MySQL
Posted: Thu Oct 01, 2015 2:38 am
Hi,
My requirement is to extract data from different tables using ODBC stage using MySQL. We have multiple tables with around 50 fields and 40 million records each.
My job design is simple: ODBC -> Copy -> Dataset.
RCP is enabled and no metadata is defined in any of the stages.
But, when I'm executing the job, sometimes the job fails and sometimes it's starts processing records after a long time, almost after 45 minutes.
That raised some questions in my mind as to how RCP works.
Does Datastage scan through all the records and determine the metadata in realtime or what.
One more observation is that when I expected the same queries on a sample table, which contains 1000 records, the job runs in 1 min or less.
Please shed some light on this issue.
Best Regards,
Sam
My requirement is to extract data from different tables using ODBC stage using MySQL. We have multiple tables with around 50 fields and 40 million records each.
My job design is simple: ODBC -> Copy -> Dataset.
RCP is enabled and no metadata is defined in any of the stages.
But, when I'm executing the job, sometimes the job fails and sometimes it's starts processing records after a long time, almost after 45 minutes.
That raised some questions in my mind as to how RCP works.
Does Datastage scan through all the records and determine the metadata in realtime or what.
One more observation is that when I expected the same queries on a sample table, which contains 1000 records, the job runs in 1 min or less.
Please shed some light on this issue.
Best Regards,
Sam