Our current application is a legacy application which uses RPG, DB2 AS400. We are working on a modernized application which has to store data in modernized tables and also legacy tables as well. If legacy application is accessed then data has to insert in legacy tables and modernized tables. At a point of time, legacy tables will sunset Note: we are using DB2 AS400 for both modern and legacy applications, its just tables are different.

We thought of multiple approaches:

through messaging from both modernized and legacy side which can be done. through CDC approach, without involving code changes this can be done, which is a good solution. We have analyzed debezium tool but debezium does not work for DB2 AS400.

We are analyzing on change data capture (CDC) but have some questions. whether DB2 AS400 supports change data capture, how to enable and connector for db2 AS400. Could someone provide insight into how to approach the problem.

Does DB2 AS400 uses journals tables for change data caputre? Our current database is IBM i 7.3 that runs on AS400 OS

Please let me know if there is anything missing, before closing. I can update my post.

New contributor
Vipul is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • 1
    Please don't cross-post
    – mustaccio
    Jun 22 at 15:27
  • 1
    @mustaccio the question seems more appropriate here. The SO posts are likely to be closed.
    – Charles
    Jun 22 at 16:12
  • @Charles the way it's currently phrased it's off-topic anywhere (except maybe reddit).
    – mustaccio
    Jun 22 at 16:36
  • In response to your flag requesting more information, are you familiar with dba.stackexchange.com/help/dont-ask and dba.stackexchange.com/help/on-topic ? The reason this question is closed as off-topic is that it doesn't really meet the test. You are asking for opinions on your proposed architecutres, which is not really objective and the intent of StackExchange sites is for objective answers, which doesn't always help. That being said, there is still a value in learning about best practices, so we can work to "clean this up", if you like.
    – jcolebrand
    Jun 22 at 17:30
  • 1
    Hopefully this helps you understand the why of your question being closed, and helps you understand what the commnity is looking for in a scenario such as this. I'm not sure we have a lot of AS400 experts here, but these sort of questions are excellent for the long-tail nature of StackExchange, and may yield results in the future even if not today.
    – jcolebrand
    Jun 22 at 17:41


Browse other questions tagged or ask your own question.