File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 17417

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.
I agree. Here's the link:
subject: Tools for DB2 on AS/400
It's not a secret anymore!