I've used DbSchema for many years with MySQL & PostgreSQL.
Recently I tried to reverse engineer a DB2 database - unsuccessfully.
The database base is on an AS/400 or iSeries. I have downloaded the open source JT400.jar and successfully connected to the database using SquirrelSQL.
When configuring DbSchema to connect to the same DB, I used the same driver and selected the DB2z/OS option.
I get errors reading DB2 system tables, so I altered the DbSchema reverse engineer SQL statements to refer to QSYS2 instead of SYSIBM. This got me thru most of the queries until the very end, when it displays an error 'cannot read REMARKS column'.
I can't get past this error.
So, I downloaded and installed DB2 LUW on my employer owned PC. I am not an administrator of this PC, but I do have application install rights. Because of this, I installed DB2 LUW without a userid or password. SquirrelSQL can successfully connect to this database.
Time to configure DbSchema. I selected the default DB2 driver and let DbSchema download the driver. Then completed the configuration information and left user id & password empty.
DbSchema complains that user id & password cannot be empty. If I put something in there, DbSchema advises that authentication failed.
This is very frustrating!
SquirrelSQL can connect to both databases using the same JAR drivers as DbSchema uses. DbSchema cannot.
Has anyone been able to successfully connect to DB2?
ps. I'm using DbSchema 4016.