Meaningless Drivel is fun!*
The moose likes IDEs, Version Control and other tools and the fly likes Tools for DB2 on AS/400 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Tools for DB2 on AS/400" Watch "Tools for DB2 on AS/400" New topic

Tools for DB2 on AS/400

Benson Fung
Ranch Hand

Joined: Apr 10, 2003
Posts: 207

I am working on a project whose DB2 is on AS/400. Is there reverse engineering tools particularly open source like eclipse plugin which can provide ER diagram generation for such database?

Please advice

Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 15950

There's an open-source tool called SchemaSpy that I have found to be very useful. It can create an entire interactive website for the schema.

It's a Java application using JDBC, so you can do things like run the app on a Windows machine and analyze an AS/400 or even z/OS database as long as you have JDBC drivers.

I think you can find SchemaSpy on If not, Google.

Customer surveys are for companies who didn't pay proper attention to begin with.
I agree. Here's the link:
subject: Tools for DB2 on AS/400
Similar Threads
Using JDBC java code - how can I connect to IBM AS400 iSERIES to read data
About using JBoss
AS400 and JDBC (and SQL)
DB2 v9 slower than DB2 v8 while inserting DDL and DML Scripts using Ant script
what is connection pooling?