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

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.

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.

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.