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

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: 214

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: 17030

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.

An IDE is no substitute for an Intelligent Developer.
jQuery in Action, 3rd edition
subject: Tools for DB2 on AS/400
It's not a secret anymore!