IBM.数据.DB2
我可以使用 .NET Framework 和 IBM.Data.DB2 提供程序开发 Windows 应用程序来访问 OS/390 上运行的 DB2 数据库吗？
提前致谢。
Can I develop a windows application using .NET framework and IBM.Data.DB2 provider to access a DB2 database running on OS/390?
Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
IBM 非常严密地保护（或者更准确地说，允许他们的客户保护）他们的大型机 DB2 访问。 我怀疑这与确保只有企业级应用程序尝试连接有关（没有正确许可证文件的 JDBC 客户端甚至无法在大型机 TCP 端口上收到其请求，它们在客户端） - 大型机通常是业务关键型的，大多数桌面/服务器应用程序都梦想成为:-)。
对于 JDBC 驱动程序，单个类型 4 驱动程序用于访问所有 DB2 平台（LUW、iSeries、System z 等），但实际上您必须在 CLASSPATH 中安装特定平台的许可证文件，否则您将得到一个例外。
该许可证文件的格式为“
db2jcc_cisuz.jar”，其中 cisuz 指定允许访问哪些平台（cu 是最常见的，但不能访问 iSeries 或 System z）。您通常必须从 IBM 购买 DB2 Connect 才能获取这些文件，我怀疑 .NET 框架也会出现类似的情况。 您可能会发现 DB2 Connect 产品具有 .NET 客户端驱动程序以及 JDBC（我没有看过）。 寻找该产品的“企业”版本，因为标准版本不太可能拥有 System z 许可证。
只是一个小问题，它不再是 OS/390（除非您是少数专门付费以获得恐龙支持的日本客户之一）。 这是 z/OS。
IBM guard (or, more precisely, allows their customers to guard) their mainframe DB2 access very closely. I suspect this has something to do with ensuring only enterprise-blessed applications even try to connect (JDBC clients that don't have the right license file don't even get their requests appearing at the mainframe TCP ports, they're blocked on the client side) - the mainframe is usually business-critical in a way most desktop/server apps only dream of becoming :-).
With the JDBC drivers, a single type-4 driver is used to access all DB2 platforms (LUW, iSeries, System z, etc) but you actually have to have a license file installed in your CLASSPATH for the specific platforms or you'll get an exception.
This license file is of the form "
db2jcc_cisuz.jar" where the cisuz specifies which platforms are allowed to be accessed (cu is the most common but that doesn't give access to iSeries or System z).You generally have to buy DB2 Connect from IBM to get these files and I suspect it would be a similar situation for the .NET framework. You may find that DB2 Connect products have .NET client drivers as well as JDBC (I haven't looked). Look for the "Enterprise" edition of that product since the standard ones would be unlikely to have the System z license.
And just a minor niggle, it's not OS/390 any more (unless you're one of the rare Japanese customers paying specially to have that dinosaur supported). It's z/OS.
我不确定 OS/390，但在工作中我共同开发了连接到 Solaris DB2 实例的 .Net 应用程序。 我们使用标准 IBM.Data.DB2，所以我相信 OS/390 也应该可以工作。
I'm not sure about OS/390 but at work I co-develop .Net application that connects to Solaris DB2 instance. We use standard IBM.Data.DB2 so I believe OS/390 should work as well.
我之前使用 MS Host Integration Server 将用 C# 编写的 .Net 应用程序与 DB2 连接，可能不是您正在寻找的，但我知道它有效。 以下是链接，了解有关 MS HIS 的详细信息
I used MS Host Integration Server to connect a .Net application written in C# with DB2 before, may not be what you are looking for but I know it works. Here is a link for more information about MS HIS