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

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
What's the difference between identifying and non-identifying relationships?

I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?

Read More