I have created a Database in DB2 and tables with relationships. I would like to create a ER diagram based on my database design in DB2. MS SQL has a facility to create ER diagrams from DB schema, but DB2 doesn't seem to have one, at least to my knowledge.

Any one know of any open source tools/facility within DB2 itself for this?

Aqua Data Studio has an ER Modeling tool which will work with any RDBMS. You can create, explore, detail, and modify database schemas to create fully editable and scriptable diagrams of database relationships and objects. The link to download is www.aquafold.com

TOAD for DB2 freeware does not have the ER diagramming feature enabled. It is available only in the commercial version. ER Studio is another (expensive) option. Try Visio 2000 Enterprise edition if you can get one. It is available on ebay for about $35. Microsoft has moved the reverse engineering option in subsequent version of Visio to the expensive enterprise architect bundles.

DbVisualizer can visualize (and much more) just about any database, provided that the relevant foreign keys have been defined. DbVisualizer isn't open source, but there is a free edition of it (which isn't limited regarding visualization).

I have used visio for this before, and yes it does a neat job. I was looking for something opensource/facility in DB2; if they had added it as a feature in subsequent releases.
–
ShawJul 20 '09 at 9:41

I used DB2v9.1 and I don't think there was any such feature.
–
Rashmi PanditJul 20 '09 at 9:45

I use 9.1, and didn't find any such feature. I was wondering if I missed it. Interestingly, IBM's RAD seems to have a data model reengineering feature. Not been quite successful in getting it to work so far.
–
ShawJul 21 '09 at 1:30