Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Tool for Finding Data Model of DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
prav_06
Warnings : 1

Active User


Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands

PostPosted: Wed Jun 20, 2007 4:27 pm    Post subject: Tool for Finding Data Model of DB2
Reply with quote

Hi All,

There is requirement to find the data model of all the tables in my system, is there any tool that gives the data model of the tables. Thanks in advance.


Thamilzan.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jun 20, 2007 6:27 pm    Post subject:
Reply with quote

Hello,

Are you looking for entity relationship diagrams (ERD) or something else?
Back to top
View user's profile Send private message
prav_06
Warnings : 1

Active User


Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands

PostPosted: Thu Jun 21, 2007 11:39 am    Post subject: Re: Tool for Finding Data Model of DB2
Reply with quote

Hi Dick,

Yes am looking for the ERD diagram, parent child relationship between tables. I had gone thro fileaid for DB2 there is an option called as Relationship in the same will that be useful, if so can you please throw some light on how to use that option or is there any other tool to get the ERD diagram. Thanks for your reply.

Thamilzan.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 22, 2007 1:39 am    Post subject:
Reply with quote

Hello,

There are several vendors of data modeling software. Some products are:

AllFusion ERwin Data Modeler - ERD tool, ablity to generate HTML reports.

ConceptDraw - cross platform software for creating ER Diagrams

DBDesigner - OpenSource ER Data Modeler.

DB Visual ARCHITECT - Support UML Class Diagram and ERD

Dia - a free software/open source program to draw ER diagrams

Ferret (software) - a free software ER drawing tool

ER/Studio - robust, easy-to use ER modeling tool from Embarcadero.

ModelRight - inovative and complete physical modeling tool

Kivio - a free software flowcharting program that supports ER Diagrams

Microsoft Visio - The Enterprise Architect version supports generating and
reverse engineering databases

OmniGraffle - diagramming software for Mac OS

Oracle Designer - Oracle's CASE tool for designing an information system and generating it

PowerDesigner - modeling suite from Sybase which includes Data Architect for constructing or reverse engineering conceptual, logical and physical models with many of the leading RDBMS brands.

Rational Rose - Old software designed for producing UML diagrams. Notably easy to use which has aided its longevity

SILVERRUN ModelSphere - supporting conceptual, logical and physical data modeling including interfaces for multiple target systems.

SmartDraw - point and click drawing method combined with many templates creates professional diagrams.


If you search on the web, you may find some shareware/freeware that will do what you want.
Back to top
View user's profile Send private message
prav_06
Warnings : 1

Active User


Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands

PostPosted: Fri Jun 22, 2007 5:03 pm    Post subject:
Reply with quote

Dick,
Thanka a lot for the reply!!!!!!!

Thamilzan.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jun 22, 2007 6:20 pm    Post subject:
Reply with quote

You're welcome icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts Need info on EIBCPOSN value in IBM FA... subratarec CICS 11 Wed Jul 12, 2017 3:45 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us