473,569 Members | 2,705 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ERWin data modeler, iSeries DB2 reverse engineering error

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
Nov 12 '05 #1
17 7144
"Sulu's Beard" <wi*******@nosp am.yahoo.com> wrote in message
news:8s******** *************** *********@4ax.c om...
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.
Nov 12 '05 #2
On Fri, 15 Apr 2005 11:22:58 -0600, "Mark A" <no****@nowhere .com>
wrote:
"Sulu's Beard" <wi*******@nosp am.yahoo.com> wrote in message
news:8s******* *************** **********@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....
Nov 12 '05 #3
"Sulu's Beard" <wi*******@nosp am.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.
Nov 12 '05 #4
RdR
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" <wi*******@nosp am.yahoo.com> wrote in message
news:8s******** *************** *********@4ax.c om...
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

Nov 12 '05 #5
"RdR" <rr******@datam irror.com> wrote in message
news:9e******** *********@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.
Nov 12 '05 #6
RdR
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" <no****@nowhere .com> wrote in message
news:hs******** ************@co mcast.com...
"RdR" <rr******@datam irror.com> wrote in message
news:9e******** *********@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.

Nov 12 '05 #7
On Mon, 18 Apr 2005 16:09:37 -0400, "RdR" <rr******@datam irror.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
Nov 12 '05 #8
> 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.
Nov 12 '05 #9
RdR
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" <no****@nowhere .com> wrote in message
news:yv******** ************@co mcast.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.

Nov 12 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
4496
by: Alex | last post by:
Hello everybody, does ERwin 4.0 support version 8 of DB2 ? what modeling tools recomended for db design and script generation for version 8 ? Thank you Alex
2
6975
by: Lawrence | last post by:
I am trying to use ERWin to reverse-engineer a database running on an AS/400 iSeries database. When the process completes, I end up with an ERD that has 3 or more instances of many of the tables, plus an entity for every file on the box, regardless of the library they reside in. Has anyone else run into this "behavior"? Any ideas on how to...
1
14905
by: Yanik Reid | last post by:
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the new managed IBM.Data.DB2.iSeries data provider from iSeries Access V5R3. When I remove Database=AMFLIB from the connection string, I can connect...
6
1915
by: Matthew Hixson | last post by:
I'm looking for a data modeler that can look at an existing database schema and generate an ERD. A PDF of it would be nice. I'm using OS X, but a Linux or Windows tool would be acceptable too. I don't need any other features than that right now. Just want to generate something that new developers can look at to more easily become familiar...
0
3871
by: NickName | last post by:
What I wanted to do is to have ERwin to reverse engineer an Access db to generate a MS SQL Server 2000 -compatible SQL DDL script. I'll use it to create tables, keys, indexes (and having ERwin to capture Access's TABLE/FIELD DESCRIPTIONS) etc structure on a target SQL Server 2000 db, then using DTS to import data in from the Access DB. ...
0
2395
by: Ed Axelrad | last post by:
I am having some difficulty figuring out how to use ERWIN v. 4 to reverse engineer a DB2 database on an IBM/VSE mainframe. Can anyone help? THANKS.
0
4540
by: mike1402 | last post by:
Hi ! I get the error below sometimes when retrieving a big amount of data using Datadapter.Fill(dataset,"table"). But when I send the command Fill again, there is no error. Is it a fault of IBM.Data.DB2.iSeries; Version: v1.0.3705 (is there an newer one for OS/400 Version ist V5R3 ?) or is it a hardware faoult (memory of as400 or pc) ? br...
6
7369
by: Herby | last post by:
Hi, Im interested in Reverse Engineering C++ source code into a form more comprehensible than the source itself. I want to write a basic one myself, obviously i need to write a parser for the source code. Although this has some overlap with say a compiler it would also seem significantly different too.
0
1523
by: Tom Gugger | last post by:
THOMAS GUGGER INDEPENDENT RECRUITER tgugger@sbcglobal.net 419-537-9447
0
7698
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7924
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8122
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7673
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5513
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5219
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3640
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1213
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
937
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.