|
View previous topic :: View next topic
|
| Author |
Message |
A_programmers
New User
Joined: 24 Mar 2010
Posts: 19
Location: USA
|
|
|
|
Dear All,
I am looking for different approaches which are currently being used to generate reports from IBM DB2 Database on mainframe.
Specific information I am looking at is :
1) Are reports being generated directly from Mainframe live database ? If yes, during business hours or outside business hours ?
2) How data is extracted from Mainframe db2 database ? Is any ETL tool being used for this purpose ?
3) Is the approach of extracting data using Mainframe scheduled jobs and sending it using NDM /FTP flexible or good enough ?
4) Apart from mainframe db2 , any other database which you are using for reporting purposes ?
Thanks
A programmer |
|
| Back to top |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
|
|
| We FTP the files from DB2 to ETL process and then it is processed further for various reports and vice versa we sometimes get the FTP 'ed file from ETL and have SP's to generate the report and surface it to the screens. |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
For Live Warehousing where reports are to be created from current data, there will be replication used to capture the changes and update the target table and report data will be extracted from those tables.
If reports are of weekly and monthly basis, data will be extracted during night(off business hours) or weekends. |
|
| Back to top |
|
|
|
|
