Need information on Data Extract approach
Posted: Thu May 08, 2008 9:35 am
Hi All,
We need to extract the data from OLTP system which is on Mainframe DB2 host
We have two approaches to extract the data from DB2 tables:
1. Using DB2 API Stage which directly fetches the data from DB2 tables.
2. Using JCL scripts to fetch the data from Mainframe and ftp the files to UNIX box. and process those files using a sequential stage.
can anyone suggest which approach is the best one taking into consideration the performance aspect. our jobs will be run daily insert/updating around million records.
Any help will be highly appreciated.![Smile :)](./images/smilies/icon_smile.gif)
Thank you
Narendar
We need to extract the data from OLTP system which is on Mainframe DB2 host
We have two approaches to extract the data from DB2 tables:
1. Using DB2 API Stage which directly fetches the data from DB2 tables.
2. Using JCL scripts to fetch the data from Mainframe and ftp the files to UNIX box. and process those files using a sequential stage.
can anyone suggest which approach is the best one taking into consideration the performance aspect. our jobs will be run daily insert/updating around million records.
Any help will be highly appreciated.
![Smile :)](./images/smilies/icon_smile.gif)
Thank you
Narendar