PDM diagram from DB2 catalog

Art McEwen

PDM diagram from DB2 catalog
Hi,

Any recommendations out there for tools that will draw physical data model
diagrams directly from the contents of the DB2 Catalog?

We're trying to close a gap between our architects logical view of our data
and the physical reality.

Thanks,


Art McEwen



Sr. Database Administrator
Service Delivery & Management Br.
Health Services Cluster
5th flr, 49 Place d'Armes
Kingston ON K7L 5J3

[login to unmask email]



Office 613-548-6622
FAX 613-548-6894
Cell 613-539-3903



_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Philip Sevetson

Re: PDM diagram from DB2 catalog
(in response to Art McEwen)
ERWin. Not cheap, but good.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Art McEwen
Sent: Friday, December 11, 2009 3:45 PM
To: [login to unmask email]
Subject: [DB2-L] PDM diagram from DB2 catalog

Hi,

Any recommendations out there for tools that will draw physical data model
diagrams directly from the contents of the DB2 Catalog?

We're trying to close a gap between our architects logical view of our data
and the physical reality.

Thanks,


Art McEwen



Sr. Database Administrator
Service Delivery & Management Br.
Health Services Cluster
5th flr, 49 Place d'Armes
Kingston ON K7L 5J3

[login to unmask email]



Office 613-548-6622
FAX 613-548-6894
Cell 613-539-3903



_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Philip Gunning

Re: PDM diagram from DB2 catalog
(in response to Philip Sevetson)
Any modeling tool should be able to reverse engineer what you have. I like ER/Studio from Embarcadero. PG

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Art McEwen
Sent: Friday, December 11, 2009 3:45 PM
To: [login to unmask email]
Subject: [DB2-L] PDM diagram from DB2 catalog

Hi,

Any recommendations out there for tools that will draw physical data model
diagrams directly from the contents of the DB2 Catalog?

We're trying to close a gap between our architects logical view of our data
and the physical reality.

Thanks,


Art McEwen



Sr. Database Administrator
Service Delivery & Management Br.
Health Services Cluster
5th flr, 49 Place d'Armes
Kingston ON K7L 5J3

[login to unmask email]



Office 613-548-6622
FAX 613-548-6894
Cell 613-539-3903



_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L