"Sulu's Beard" <wilbolite@nospam.yahoo.com> wrote in message
news:8ssv51tj60q9of77l8sij5dp45b3ateu14@4ax.com...
> Hey gang,
>
> I'm evaluating the CA ERWin product for an upcoming data warehousing
> project. I'm most excited about the reverse engineering aspect of
> this system.
>
> I've sucessfully tested it on a SQL Server 2000 system, however, when
> I run it against our iSeries DB2 system (on which our ERP exists), I
> encounter errors that essentially say that files are missing from our
> SYSCAT library. I'm not an iSeries expert, but I can say that the
> SYSCAT library does not exist on our box, and that the tables ERwin is
> looking for is actually stored in a SYSIBM library.
>
> I've checked all sorts of help files & on-line searches, but I've
> found no way to tell ERwin to look in SYSIBM instead of SYSCAT. It
> seems almost as if SYSCAT is hard-coded into this application.
>
> Any ideas?
>
> - Bill

Does Erwin support DB2 for iSeries? If so (or if not sure) contact CA
support.