Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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 Head First Android this week in the Android 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: 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: 16897

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