Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Reporting (/Datawarehousing) using Mainframe DB2 Database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
A_programmers

New User


Joined: 24 Mar 2010
Posts: 6
Location: USA

PostPosted: Tue Jul 21, 2015 12:48 pm    Post subject: Reporting (/Datawarehousing) using Mainframe DB2 Database
Reply with quote

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
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1788
Location: NY,USA

PostPosted: Tue Jul 21, 2015 8:43 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Aug 06, 2015 2:55 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Looking for Mainframe job Chandan1993 Mainframe Jobs 0 Sun Sep 24, 2017 1:06 am
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
No new posts Mainframe dataset split purushottam DFSORT/ICETOOL 13 Tue Aug 29, 2017 12:28 pm
No new posts FTP data transfer from PC to Mainfram... AJAYREDDY All Other Mainframe Topics 8 Wed Aug 23, 2017 9:59 pm
No new posts Allianz Technology - Mainframe 3+ Yea... sooraj184 Mainframe Jobs 0 Mon Jul 31, 2017 2:17 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us