Do you use SYSIBM.* tables to create a model of the databases or ERD

[Crox]

Hi!<br><br>I am very interested to create automatically a ERD or some usefull output using the SYSIBM tables as input.<br><br>I work as a contracter on several places. Every time again there is this difficulty in getting to know how the system is build, while the SYSIBM tables contains lots of information.<br><br>Does anyone have some usefull queries perhaps? Can we share some info here? Perhaps even a smart COBOL program or PL/1?<br><br>Thanks in advance!<br><br>

 

[suenram]

You might want to look into buying ERwin.&nbsp;&nbsp;If you want to read about it, go to <A HREF="

http://www.platinum.com/products/appdev"

TARGET="_new">

http://www.platinum.com/products/appdev</A>.<br><br>We

keep our MVS DB2 models organized with ERwin.&nbsp;&nbsp;We also use this tool for Oracle, Sql Server and some Access database models.&nbsp;&nbsp;We were not too thrilled at first but if you have to pass your work on to someone else, this is a nice way to have things organized.&nbsp;&nbsp;<br><br>We also use ModelMart (add more money to your ERwin purchase) to manage the Erwin Models on some bigger projects.&nbsp;&nbsp;This allows you to check-out models without stepping on each other.&nbsp;&nbsp;&nbsp;&nbsp;

 

[suenram]

This works better for an ERwin reference:<br><A HREF="

http://www.cai.com/products/platinum/appdev/erwin_ps.htm"

TARGET="_new">

http://www.cai.com/products/platinum/appdev/erwin_ps.htm</A><br>

 

[Crox]

Thank you for the suggestion, but I can't install my own software on the customers mainframe/pc-network environment. I guess it will cost some money also and as a contractworker I am trying to earn money, not to spend more than I can earn in a few days for this.<br><br>What I need is a program that finds its way in the SYSIBM.* tables in DB2. I can develop this myself but I suppose somebody did this before and perhaps likes to share the info. <br><br>