SEO

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

"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.

On Fri, 15 Apr 2005 11:22:58 -0600, "Mark A" <nobody@nowhere.com>
wrote:

>"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.
>

Yes - there is clear support for iSeries DB2 (it's listed even in the
drop-down box for data sources - and even lists various versions of
DB2). I feel this is a specific library related issue - I've
contemplated creating a library called SYSCAT and copying all of the
objects from SYSIBM over to SYSCAT - however, I'm not a DB2 DBA and
these tables look extremely important to me....

"Sulu's Beard" <wilbolite@nospam.yahoo.com> wrote in message
> Yes - there is clear support for iSeries DB2 (it's listed even in the
> drop-down box for data sources - and even lists various versions of
> DB2). I feel this is a specific library related issue - I've
> contemplated creating a library called SYSCAT and copying all of the
> objects from SYSIBM over to SYSCAT - however, I'm not a DB2 DBA and
> these tables look extremely important to me....

Make sure that you are using the IBM supplied ODBC driver for DB2. This can
be accomplished by installing the DB2 client on your PC. However, you may
need a license for DB2 Connect to get to the iSeries DB2.

Hi,

You can try this, create a library called syscat, the command is as follows:

CRTLIB LIB(SYSCAT)

This will automatically create it in the QSYS library. Then copy the SYSIBM
objects to this library. If you have an existing SYSCAT library, it should
complain that you have it or the SYSCAT you are creating will not go to the
QSYS library. (You can do a WRKLIB SYSCAT command before creating it to
verify if it is existing. Be careful overwriting any existing objects that
are already existing. I suggest if something is existing, consult your
aS/400 admin.

This may just answer the question on SYSCAT being hard coded in ER Win. You
may encounter other errors.

Thanks,

RdR

"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

"RdR" <rrosario@datamirror.com> wrote in message
news:9eS8e.2405$5u4.8716@nnrp1.uunet.ca...
> Hi,
>
> You can try this, create a library called syscat, the command is as
> follows:
>
> CRTLIB LIB(SYSCAT)
>
> This will automatically create it in the QSYS library. Then copy the
> SYSIBM objects to this library. If you have an existing SYSCAT library, it
> should complain that you have it or the SYSCAT you are creating will not
> go to the QSYS library. (You can do a WRKLIB SYSCAT command before
> creating it to verify if it is existing. Be careful overwriting any
> existing objects that are already existing. I suggest if something is
> existing, consult your aS/400 admin.
>
> This may just answer the question on SYSCAT being hard coded in ER Win.
> You may encounter other errors.
>
> Thanks,
>
> RdR
If you have to do those things, then Erwin does not support DB2 iSeries. I
think he should call CA support.

I know before ERwin became under the AllFusion brand, it runs on the iSeries
(then AS/400) and is supported in that platform and it was looking for the
SYSIBM library. At least, this proves that something hard-coded is not set
right.

Thanks

RdR

"Mark A" <nobody@nowhere.com> wrote in message
news:hsGdnUTVD_wobf7fRVn-pQ@comcast.com...
> "RdR" <rrosario@datamirror.com> wrote in message
> news:9eS8e.2405$5u4.8716@nnrp1.uunet.ca...
>> Hi,
>>
>> You can try this, create a library called syscat, the command is as
>> follows:
>>
>> CRTLIB LIB(SYSCAT)
>>
>> This will automatically create it in the QSYS library. Then copy the
>> SYSIBM objects to this library. If you have an existing SYSCAT library,
>> it should complain that you have it or the SYSCAT you are creating will
>> not go to the QSYS library. (You can do a WRKLIB SYSCAT command before
>> creating it to verify if it is existing. Be careful overwriting any
>> existing objects that are already existing. I suggest if something is
>> existing, consult your aS/400 admin.
>>
>> This may just answer the question on SYSCAT being hard coded in ER Win.
>> You may encounter other errors.
>>
>> Thanks,
>>
>> RdR
> If you have to do those things, then Erwin does not support DB2 iSeries. I
> think he should call CA support.
>

On Mon, 18 Apr 2005 16:09:37 -0400, "RdR" <rrosario@datamirror.com>
wrote:

>I know before ERwin became under the AllFusion brand, it runs on the iSeries
>(then AS/400) and is supported in that platform and it was looking for the
>SYSIBM library. At least, this proves that something hard-coded is not set
>right.
>
>Thanks
>
>RdR
>

Thanks for the input - I considered copying the SYSIBM library over to
SYSCAT (I know for a fact that SYSCAT does not exist). Perhaps I will
do so on our development machine.

As for CA support - well, as I said before, I'm currently evaluating
their demo program - and while it works like a charm on SQL Server
2000 or ODBC connections (even Client Access ODBC connections back to
the same iSeries box), this little annoying glitch is preventing me
from seeing what true native support for iSeries DB2 is like!

Thanks,

- Bill

> As for CA support - well, as I said before, I'm currently evaluating
> their demo program - and while it works like a charm on SQL Server
> 2000 or ODBC connections (even Client Access ODBC connections back to
> the same iSeries box), this little annoying glitch is preventing me
> from seeing what true native support for iSeries DB2 is like!
>
> Thanks,
>
> - Bill

If you are evaluating the product with a demo product, and are considering
purchasing it, then you should contact CA support or a marketing person. Why
do you think they have a marketing department?

If you a illegal copy of the software, then please say so.

It is common nowadays that tests and proof of concept are paid for, they
only deduct the cost of support for the test and the actual proof of concept
when you buy the product from the purchase price. But if they are willing to
support it for free if you are still a prospect, then by all means report
it.

RdR

"Mark A" <nobody@nowhere.com> wrote in message
news:yv-dnZG-eazfx_nfRVn-ug@comcast.com...
> > As for CA support - well, as I said before, I'm currently evaluating
> > their demo program - and while it works like a charm on SQL Server
> > 2000 or ODBC connections (even Client Access ODBC connections back to
> > the same iSeries box), this little annoying glitch is preventing me
> > from seeing what true native support for iSeries DB2 is like!
> >
> > Thanks,
> >
> > - Bill
>
> If you are evaluating the product with a demo product, and are considering
> purchasing it, then you should contact CA support or a marketing person.
Why
> do you think they have a marketing department?
>
> If you a illegal copy of the software, then please say so.
>
>