Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: Mainframe LOGS to DB2 UDB

    Team,

    Does mainframe logs are compatible with DB2 UDB V8.2
    If so what would be the best scrubber? Q replicator, MQ series etc.

    We planned to build DB2 UDB database and feed daily data from Mainframe using mainframe logs. What would be the best approach?

    Thanks,
    RJ

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The raw logs themselves are not compatiable, but there are IBM products that will replicate data using the logs from DB2 for z/OS to DB2 for LUW.

    I believe that it is called WebSphere Information Integrator Replication for z/OS.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2005
    Posts
    109
    DB2 Host to DB2 UDB LUW basic replication software is included in DB2 Connect. Also I find the replication center already available.
    It might be some other GUI tools are only packaged with Websphere II, but not needed. You do not need extra licences besides DB2 Connect for DB2 Host to DB2 LUW replication.
    These tools will asynchronously read the logfiles and replicate to UDB.
    Juliane

  4. #4
    Join Date
    Oct 2005
    Posts
    109
    Just to add: you can use SQL replication as well as MQ queues for transfer the data between servers. Q replication is expected to be very fast, faster than SQL replication, setup not very difficult, especially once you understood basic MQ concepts.
    Juliane

Posting Permissions

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