Data Model tools for DB2

database database-design db2 data-modeling erd
Shaw picture Shaw · Jul 18, 2009 · Viewed 15.5k times · Source

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?

Answer

Kb. picture Kb. · Jul 18, 2009

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

Also IBM Data Studio looks promising.

Related questions

DB2 Communication Error

We recently developed an application which will run a query in DB2 and send a mail to the corresponding recipient. It works well in our local system and QA region. But in production, few queries failed (even if it's rare, …

Read More
Can I have multiple primary keys in a single table?

Can I have multiple primary keys in a single table?

Read More
Database, Table and Column Naming Conventions?

Whenever I design a database, I always wonder if there is a best way of naming an item in my database. Quite often I ask myself the following questions: Should table names be plural? Should column names be singular? Should …

Read More