in 2011, Dav_G asked in this forum which tools are recommended for modelling a database on IBM i. I have to ask the same, because the answer then--using a mixture of IBM Data Studio Client, IBM i Navigator and a third-party software--doesn't seem ideal to me.
When I was starting my project, I first used MySQL Workbench to design a raw concept and then translated the SQL output in the DB2 dialect but now it's getting more complex, and I'm looking for a better solution.
I was very excited when I discovered IBM Data Studio Client, but disillusion followed soon: To me, it's difficult to find what I want and to see what I am actually doing. Maybe it's because I don't know how to use it correctly, but I don't find a documentation of version 4.1.2 and the included help is not really helpful (it was disappointing to first find interesting looking headlines, but after choosing them the help text is missing). On Youtube there are a few videos by "Analytics Platform Tool", but they are mute and thus very difficult to follow and seem to focus on DB2 for Linux and Windows.
So, which tools do you use and recommend? Or: Do you know a good read on Data Studio Client with IBM i so I can keep using IBM Data Studio?