Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2015

    Unanswered: Reporting (/Datawarehousing) using Mainframe DB2 Database

    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 ?

    A programmer

  2. #2
    Join Date
    Apr 2012
    Provided Answers: 27
    All of the above...and more. Depends on the complexity of the enterprise and the number of different legacy origins that comprise it (after merger and acquisitions for example).
    Is this market research or do you have a specific problem to solve?

  3. #3
    Join Date
    Jul 2015
    Thanks for your comments db2mor.

    I have a specific requirement for my application. The reason for asking these questions is a) what is working perfectly in the other environments. b) what is most preferred solution c) any issues observed


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts