473,882 Members | 1,688 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
17 7185
On Mon, 18 Apr 2005 19:09:20 -0600, "Mark A" <no****@nowhere .com>
wrote:
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.


Mark - please... CA offers a fully functionly, time-limited demo -
see for yourself

http://www3.ca.com/Solutions/Collate...D=33655&ID=260

I see you're a frequent contributor to this group, and that's
commendable. But for this particular topic you've only had two things
to offer:
(1) ERWin may not support iSeries DB2 (it does)
(2) I own an illegal copy and should fess up (I don't).

All I was hoping for was another user of this software (from what I've
been able to gather, ERWin is the most widely used data modelling
tool) that may have encountered the same issue when
reverse-engineering against the same type of system we utilize. To
reply with half-guesses and accusations is not only unhelpful, but
somewhat insulting as well.

I will, however, take your suggestion to place a quick call to the CA
folks (although finding a phone number to call will be a challenge in
and of itself).

Regards,

- bill
Nov 12 '05 #11
"Sulu's Beard" <wi*******@nosp am.yahoo.com> wrote in message


Mark - please... CA offers a fully functionly, time-limited demo -
see for yourself

http://www3.ca.com/Solutions/Collate...D=33655&ID=260

I see you're a frequent contributor to this group, and that's
commendable. But for this particular topic you've only had two things
to offer:
(1) ERWin may not support iSeries DB2 (it does)
(2) I own an illegal copy and should fess up (I don't).

All I was hoping for was another user of this software (from what I've
been able to gather, ERWin is the most widely used data modelling
tool) that may have encountered the same issue when
reverse-engineering against the same type of system we utilize. To
reply with half-guesses and accusations is not only unhelpful, but
somewhat insulting as well.

I will, however, take your suggestion to place a quick call to the CA
folks (although finding a phone number to call will be a challenge in
and of itself).

Regards,

- bill


I didn't say you had a illegal copy, I was just asking, primarily because I
did not understand why you would not call CA about this problem. I also
didn't say Erwin didn't support DB2 iSeries, but I did ask if you knew for
sure that it does (it is not unreasonable that it would not be supported by
Erwin). I don't know why you distort what I said.

All software companies hire marketing and pre-sales support people to answer
these questions. I am not kidding you. A significant portion of the cost of
software goes toward marketing and pre-sales costs. If you can't get any
pre-sales support before you purchase, you will not get any support after
you purchase.

There is nothing wrong with asking on this forum, but it has already been
established that very few people here use DB2 iSeries, and even fewer use
Erwin with DB2 iSeries.
Nov 12 '05 #12
On Mon, 18 Apr 2005 20:27:55 -0600, "Mark A" <no****@nowhere .com>
wrote:
"Sulu's Beard" <wi*******@nosp am.yahoo.com> wrote in message

Mark - please... CA offers a fully functionly, time-limited demo -
see for yourself

http://www3.ca.com/Solutions/Collate...D=33655&ID=260

I see you're a frequent contributor to this group, and that's
commendable. But for this particular topic you've only had two things
to offer:
(1) ERWin may not support iSeries DB2 (it does)
(2) I own an illegal copy and should fess up (I don't).

All I was hoping for was another user of this software (from what I've
been able to gather, ERWin is the most widely used data modelling
tool) that may have encountered the same issue when
reverse-engineering against the same type of system we utilize. To
reply with half-guesses and accusations is not only unhelpful, but
somewhat insulting as well.

I will, however, take your suggestion to place a quick call to the CA
folks (although finding a phone number to call will be a challenge in
and of itself).

Regards,

- bill


I didn't say you had a illegal copy, I was just asking, primarily because I
did not understand why you would not call CA about this problem.


At the risk of being troll-like - what's the purpose then of asking
ANY questions in this group? Based on your logic, no questions should
be asked here - all should go to the vendor. I could easily reply
with "Why don't you contact IBM?" "Why don't you contact SPSS" etc..
to all other questions here!

These groups evolved so people can help each other - as getting
through to "marketing" departments can be a trial.
I also
didn't say Erwin didn't support DB2 iSeries, but I did ask if you knew for
sure that it does (it is not unreasonable that it would not be supported by
Erwin). I don't know why you distort what I said.
What distortion? After I clearly communicated that ERWin does indeed
support iSeries DB2, you still respond with "If you have to do those
things, then Erwin does not support DB2 iSeries."

All software companies hire marketing and pre-sales support people to answer
these questions. I am not kidding you. A significant portion of the cost of
software goes toward marketing and pre-sales costs. If you can't get any
pre-sales support before you purchase, you will not get any support after
you purchase.

There is nothing wrong with asking on this forum, but it has already been
established that very few people here use DB2 iSeries, and even fewer use
Erwin with DB2 iSeries.


Where are the stat's on this? I've archived every message to this
group since June 2003 and there's never been any indication of the
sort! Or is this another made-up fact that you offer as help?

I certainly had no intention of dragging this out - but when the best
advice you offered was "If you a illegal copy of the software, then
please say so" , you came off more insulting than helpful.

Nov 12 '05 #13
"Sulu's Beard" <wi*******@nosp am.yahoo.com> wrote in message
I didn't say you had a illegal copy, I was just asking, primarily because
I
did not understand why you would not call CA about this problem.


At the risk of being troll-like - what's the purpose then of asking
ANY questions in this group? Based on your logic, no questions should
be asked here - all should go to the vendor. I could easily reply
with "Why don't you contact IBM?" "Why don't you contact SPSS" etc..
to all other questions here!

These groups evolved so people can help each other - as getting
through to "marketing" departments can be a trial.

By the time I mentioned that, it was fairly clear the answer was probably
not forthcoming from anyone else in this newsgroup. The other people who
were trying to help were just guessing and had no real experience with the
combination of DB2 iSeries and Erwin.

I never meant to imply that there is any problem in asking a question here,
but after the answer is not posted here in a reasonable timeframe, it is not
unreasonable to contact to the vendor. Many vendors have free newsgroup
support. For example, there are several IBM'ers answer questions here.
PowerBuilder (probably Erwin's biggest competitor) has a newsgroup where
someone from their support group (and anyone else who wants to) answers
questions, and they don't care who asks the questions.
I also
didn't say Erwin didn't support DB2 iSeries, but I did ask if you knew for
sure that it does (it is not unreasonable that it would not be supported
by
Erwin). I don't know why you distort what I said.


What distortion? After I clearly communicated that ERWin does indeed
support iSeries DB2, you still respond with "If you have to do those
things, then Erwin does not support DB2 iSeries."

The distortion is that you said:

1. I said that it DB2 iSeries was not supported
2. I accused you of not having a valid license.

In truth, I was just asking those things.

All software companies hire marketing and pre-sales support people to
answer
these questions. I am not kidding you. A significant portion of the cost
of
software goes toward marketing and pre-sales costs. If you can't get any
pre-sales support before you purchase, you will not get any support after
you purchase.

There is nothing wrong with asking on this forum, but it has already been
established that very few people here use DB2 iSeries, and even fewer use
Erwin with DB2 iSeries.


Where are the stat's on this? I've archived every message to this
group since June 2003 and there's never been any indication of the
sort! Or is this another made-up fact that you offer as help?

I certainly had no intention of dragging this out - but when the best
advice you offered was "If you a illegal copy of the software, then
please say so" , you came off more insulting than helpful.

I have been on this and other DB2 forums for awhile. I don't know how many
questions I have answered on this forum, but I have answered over 1600
questions on a DB2 web-based forum where the number of my posts are kept
track of. I a fairly confident in my assessment that no one who has posted
so far explicitly knows the answer to your question, and that very few
knowledgeable people about DB2 iSeries post here. There are some, but not
many. Many of the DB2 iSeries questions here and elsewhere go unanswered or
people just guess on the answer based on knowledge of other DB2's. I
actually have used DB2/400, although it was awhile ago.

A very large percentage of questions on this newsgroup come from people who
do not have valid DB2 licenses. Many are just using evaluation copies for
their own education. There is nothing wrong with that, except that they
don't have access to IBM support UNLESS they are seriously considering
purchasing DB2 and in that case I am sure that an IBM pre-sales person would
be glad to help them make sure that the function they were most interested
in does indeed work. I would expect the same for CA. I would not expect any
kind of support if one was not already licensed and is not seriously
considering a purchase, which is why I asked. I am sorry if you were
offended.

The best answer I gave you was to try the DB2 ODBC driver included with the
DB2 client. I had similar problems as you did trying to use PowerDesigner
and Visio interfaces to DB2 until I specifically used the IBM DB2 ODBC
driver instead of the MS version.

The next best advice I gave you was to try to contact CA support. Of course
this would probably only work if you had a license or were seriously
contemplating a purchase from them. But who knows, there may be a newsgroup
where you can get Erwin support without directly contacting CA (like
PowerDesigner).
Nov 12 '05 #14
RdR
I think ONE reason why there are newsgroups like these is to avoid the
hassle of contacting the vendors. I often find it helpful to go to
newsgroups first then the vendor as a last recourse. We all know that you
need to go through all the hoops to get to the right person to answer your
question. In newsgroups like these, it is more often than not you get to the
right person right away. A complete opposite when you call a vendor. You
need to explain your issue to the first level support, then gets escalated
to a more senior support person, then goes to a more senior person, then
goes to the lab then goes to development. I think the reason Bill wants to
go to the newsgroup first is to see if someone experienced or had seen the
issue he had. And luckily I had some experience with his situation, not
exactly the same but something he get ideas from before going to the last
recourse which is going to the vendor. I would say that newsgroups like
these helps saves time and help you maintain your train of thought. I once
posted a question here on DDL information on the DB2 logs. Had I gone
through IBM for that, it would have taken weeks before I get the answer I
got here in a span of days (not that IBM is slow, it is just a reality). I
was able to get expert advise from Serge Rielau. If I call the IBM helpline
with a question about DDL info on the logs, I will have to explain to the
first, second, third level support person before I can get to experts who
answered my question here.

Do not get me wrong, i am not saying vendors are slow in answering
questions, one may just have to go through the hoops to get to the right
person, and that is just normal. This newsgroup is one way to maybe avoid
going through that.

Thanks,

RdR
"Sulu's Beard" <wi*******@nosp am.yahoo.com> wrote in message
news:0d******** *************** *********@4ax.c om...
On Mon, 18 Apr 2005 20:27:55 -0600, "Mark A" <no****@nowhere .com>
wrote:
"Sulu's Beard" <wi*******@nosp am.yahoo.com> wrote in message


Mark - please... CA offers a fully functionly, time-limited demo -
see for yourself

http://www3.ca.com/Solutions/Collate...D=33655&ID=260

I see you're a frequent contributor to this group, and that's
commendable. But for this particular topic you've only had two things
to offer:
(1) ERWin may not support iSeries DB2 (it does)
(2) I own an illegal copy and should fess up (I don't).

All I was hoping for was another user of this software (from what I've
been able to gather, ERWin is the most widely used data modelling
tool) that may have encountered the same issue when
reverse-engineering against the same type of system we utilize. To
reply with half-guesses and accusations is not only unhelpful, but
somewhat insulting as well.

I will, however, take your suggestion to place a quick call to the CA
folks (although finding a phone number to call will be a challenge in
and of itself).

Regards,

- bill


I didn't say you had a illegal copy, I was just asking, primarily because Idid not understand why you would not call CA about this problem.


At the risk of being troll-like - what's the purpose then of asking
ANY questions in this group? Based on your logic, no questions should
be asked here - all should go to the vendor. I could easily reply
with "Why don't you contact IBM?" "Why don't you contact SPSS" etc..
to all other questions here!

These groups evolved so people can help each other - as getting
through to "marketing" departments can be a trial.
I also
didn't say Erwin didn't support DB2 iSeries, but I did ask if you knew forsure that it does (it is not unreasonable that it would not be supported byErwin). I don't know why you distort what I said.


What distortion? After I clearly communicated that ERWin does indeed
support iSeries DB2, you still respond with "If you have to do those
things, then Erwin does not support DB2 iSeries."

All software companies hire marketing and pre-sales support people to answerthese questions. I am not kidding you. A significant portion of the cost ofsoftware goes toward marketing and pre-sales costs. If you can't get any
pre-sales support before you purchase, you will not get any support after
you purchase.

There is nothing wrong with asking on this forum, but it has already been
established that very few people here use DB2 iSeries, and even fewer use
Erwin with DB2 iSeries.


Where are the stat's on this? I've archived every message to this
group since June 2003 and there's never been any indication of the
sort! Or is this another made-up fact that you offer as help?

I certainly had no intention of dragging this out - but when the best
advice you offered was "If you a illegal copy of the software, then
please say so" , you came off more insulting than helpful.

Nov 12 '05 #15
"RdR" <ro*@delrosario .ca> wrote in message
news:YP******** ************@ro gers.com...
I think ONE reason why there are newsgroups like these is to avoid the
hassle of contacting the vendors. I often find it helpful to go to
newsgroups first then the vendor as a last recourse. We all know that you
need to go through all the hoops to get to the right person to answer your
question. In newsgroups like these, it is more often than not you get to
the
right person right away. A complete opposite when you call a vendor. You
need to explain your issue to the first level support, then gets escalated
to a more senior support person, then goes to a more senior person, then
goes to the lab then goes to development. I think the reason Bill wants to
go to the newsgroup first is to see if someone experienced or had seen the
issue he had. And luckily I had some experience with his situation, not
exactly the same but something he get ideas from before going to the last
recourse which is going to the vendor. I would say that newsgroups like
these helps saves time and help you maintain your train of thought. I once
posted a question here on DDL information on the DB2 logs. Had I gone
through IBM for that, it would have taken weeks before I get the answer I
got here in a span of days (not that IBM is slow, it is just a reality). I
was able to get expert advise from Serge Rielau. If I call the IBM
helpline
with a question about DDL info on the logs, I will have to explain to the
first, second, third level support person before I can get to experts who
answered my question here.

Do not get me wrong, i am not saying vendors are slow in answering
questions, one may just have to go through the hoops to get to the right
person, and that is just normal. This newsgroup is one way to maybe avoid
going through that.

Thanks,

I don't have any problem with someone asking questions here first. But it
was obvious after a short time that no one knew the answer.
Nov 12 '05 #16
On Tue, 19 Apr 2005 19:48:55 -0600, "Mark A" <no****@nowhere .com>
wrote:

I don't have any problem with someone asking questions here first. But it
was obvious after a short time that no one knew the answer.


Mark - you obviously do have problem. I posted the question on
Friday. By Monday, you're wondering why I just wouldn't call CA for
support on an evaluation copy of their software - and wondered allowed
if I had an illegal copy. I don't know what buttons of yours were
posted by this question - but apparently you think that I should have
been on the phone over the weekend trying to get answers from a
marketing department.
Nov 12 '05 #17
"Sulu's Beard" <wi*******@nosp am.yahoo.com> wrote in message
news:p1******** *************** *********@4ax.c om...
On Tue, 19 Apr 2005 19:48:55 -0600, "Mark A" <no****@nowhere .com>
wrote:

I don't have any problem with someone asking questions here first. But it
was obvious after a short time that no one knew the answer.


Mark - you obviously do have problem. I posted the question on
Friday. By Monday, you're wondering why I just wouldn't call CA for
support on an evaluation copy of their software - and wondered allowed
if I had an illegal copy. I don't know what buttons of yours were
posted by this question - but apparently you think that I should have
been on the phone over the weekend trying to get answers from a
marketing department.


It is now Wednesday, and no one in this newsgroup has answered the question
to your satisfaction.
Nov 12 '05 #18

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

Similar topics

4
4524
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
7003
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 make ERWin look only at the library that the database tables reside in?
1
14957
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 but as soon as I try to specify a known database (like my good old AMFLIB) I get the following error:
6
1931
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 with the schema. Thanks, -M@
0
3902
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. (Haven't used ERwin for a while, would not expect it to be able to convert Access queries and VB-driven...
0
2410
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
4564
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 mike Es wurde versucht, im geschützten Speicher zu lesen oder zu schreiben. Dies ist häufig ein...
6
7387
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
1535
by: Tom Gugger | last post by:
THOMAS GUGGER INDEPENDENT RECRUITER tgugger@sbcglobal.net 419-537-9447
0
9777
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11109
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10833
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 most users, this new feature is actually very convenient. If you want to control the update process,...
0
10405
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9558
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7957
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7114
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5782
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
3226
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.