ERWin数据建模器，iSeries DB2逆向工程错误 [英] ERWin data modeler, iSeries DB2 reverse engineering error
问题描述
嘿帮派，
我正在为即将到来的数据仓库评估CA ERWin产品
项目。我对这个系统的逆向工程方面感到非常兴奋。
我已经在SQL Server 2000系统上成功测试了它，但是
我在我们的iSeries DB2系统（我们的ERP存在）上运行它，我的b $ b遇到错误，基本上说我们的文件丢失了
SYSCAT库。我不是iSeries的专家，但我可以说
SYSCAT库在我们的盒子上不存在，并且表ERwin是
寻找的其实是存储在SYSIBM库中。
我检查了各种帮助文件&在线搜索，但我发现
无法告诉ERwin查看SYSIBM而不是SYSCAT。它几乎就像SYSCAT硬编码到这个应用程序中一样。
任何想法？
- 比尔
" Sulu''s Beard" <无线******* @ nospam.yahoo.com>在消息中写道
新闻：8s ******************************** @ 4ax.com ...嘿帮派，
我正在为即将到来的数据仓库项目评估CA ERWin产品。我对这个系统的逆向工程方面感到非常兴奋。
我已经在SQL Server 2000系统上成功测试了它，但是，当我运行时它针对我们的iSeries DB2系统（我们的ERP存在），我会遇到错误，基本上说我们的
SYSCAT库中缺少文件。我不是iSeries专家，但我可以说我们的盒子上没有SYSCAT库，并且ERwin正在寻找的表实际上存储在SYSIBM库中。 />
我检查了各种帮助文件&在线搜索，但我发现没有办法告诉ERwin查看SYSIBM而不是SYSCAT。它几乎就像SYSCAT被硬编码到这个应用程序中一样。
任何想法？
- Bill
Erwin是否支持DB2 for iSeries？如果是（或如果不确定）请联系CA
支持。
2005年4月15日星期五，下午11:22:58 -0600， ;马克A < no **** @ nowhere.com>
写道：
" Sulu''s Beard" <无线******* @ nospam.yahoo.com>在消息中写道
新闻：8s ******************************** @ 4ax.com .. < blockquote class =post_quotes>嘿帮派，
我正在为即将到来的数据仓库项目评估CA ERWin产品。我对这个系统的逆向工程方面感到非常兴奋。
我已经在SQL Server 2000系统上成功测试了它，但是，当我运行时它针对我们的iSeries DB2系统（我们的ERP存在），我会遇到错误，基本上说我们的
SYSCAT库中缺少文件。我不是iSeries专家，但我可以说我们的盒子上没有SYSCAT库，并且ERwin正在寻找的表实际上存储在SYSIBM库中。 />
我检查了各种帮助文件&在线搜索，但我发现没有办法告诉ERwin查看SYSIBM而不是SYSCAT。它几乎就像SYSCAT被硬编码到这个应用程序中一样。
任何想法？
- Bill
Erwin是否支持DB2 for iSeries？如果是（或者如果不确定）请联系CA
支持。
是的 - 对iSeries DB2有明确的支持（即使在
数据源的下拉框 - 甚至列出各种版本的
DB2）。我觉得这是一个特定的库相关问题 - 我已经打算创建一个名为SYSCAT的库并将所有
对象从SYSIBM复制到SYSCAT - 但是，我不是DB2 DBA和
这些表对我来说非常重要....
" Sulu''s Beard" ; <无线******* @ nospam.yahoo.com>在消息中写道是的 - 对iSeries DB2有明确的支持（它甚至列在数据源的
下拉框中 - 甚至列出了各种版本的
DB2）。我觉得这是一个特定的库相关问题 - 我已经考虑创建一个名为SYSCAT的库并将所有
对象从SYSIBM复制到SYSCAT - 但是，我不是DB2 DBA这些表对我来说非常重要....
确保使用IBM提供的DB2 ODBC驱动程序。这可以通过在PC上安装DB2客户端来实现。但是，您可能需要获得DB2 Connect的许可才能访问iSeries DB2。
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" <wi*******@nospam.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.
On Fri, 15 Apr 2005 11:22:58 -0600, "Mark A" <no****@nowhere.com>
wrote:
"Sulu''s Beard" <wi*******@nospam.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....
"Sulu''s Beard" <wi*******@nospam.yahoo.com> wrote in messageYes - 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.
这篇关于ERWin数据建模器，iSeries DB2逆向工程错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
