Real time data needs to push from Apache kafka to DB2 9.1.6. There might be couple of business logics will apply after fetching the data from kafka. What is the best solution to do this usecase? How efficiently DB2 can handle the real time data?
Confluent has some amazing solutions jdbc,REST,Sinks and source connectors that I think is mature.Syncsort has a DB2 certified connector but you can combine a bunch of technics with Kafka connect to achieve.
I would suggest you NiFi. It is available as HDF by Hortonworks. It is very easy to be used since it is a graphical tool, it allows real time solutions and data transformation. It has a built in connector for Kafka and a built in JDBC connector you can use to write to DB2.