Data Model tools for DB2

Question

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?

Solution 1

You could try TOAD for DB2 (freeware and commercial versions).
Download here

Also IBM Data Studio looks promising.

Solution 2

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).

Solution 3

You can use Visio and do a database reverse engineering. I have done it and found it to be quite neat.

Reverse engineer an existing database into a database model

Comments

[SO User]

I used DB2v9.1 and I don't think there was any such feature.

[Shaw]

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.

[SO User]

You will find the option in Visio

[Zoran Pavlovic]

Please note, to use the create ERD feature of TOAD for DB2, you have to have a licensed version. Pricing here: shop.software.dell.com/682/purl-toad-for-ibm-db2