的IBM.Data.DB2 [英] IBM.Data.DB2

问题描述

我使用的IBM.Data.DB2提供商连接到z / OS上IMB DB2取得了.NET C＃中的小桌面应用程序。当我部署的机器上这个程序我所面临的问题为运行于IBM的DB连接，然后我发现我不得不安装DB2运行时客户端精简版，我这样做了。现在，当我运行的应用程序中的错误来了错误[42968] [IBM] SQL8002N连接处理失败;找不到有效的产品许可证SQLSTATE = 42968

I made a small desktop app in .net c# using IBM.Data.DB2 provider connecting to IMB DB2 on z/OS. When i deployed this app on a machine i faced issues for runtime for IBM DB Connect then i found that i had to install the DB2 Run-Time Client Lite and i did so. Now when i run the application an error is coming "ERROR[42968][IBM] SQL8002N Connect processing failed; a valid product license was not found. SQLSTATE=42968"

注：我能够用自己的库连接相同的数据库

Note : I am able to connect same database using HIS libraries.

问候 Verybiztalker

Regards Verybiztalker

推荐答案

我想我回答了这个问题你previous问题相当不错 - 你不是看了吗？我将它意译为你，但首先总结：

I thought I'd answered your previous question on the subject quite well - did you not read it? I'll paraphrase it for you but summarize first:

您将无法访问z / OS的DB2远程入境点与任何精简版的版本。的使用JDBC驱动程序，您需要企业版连接到z / OS，这是几乎可以肯定一样用C＃ - 这是保持所有和 - 杂保护客户端的主机不具备的'企业神的祝福

You will not be able to access z/OS DB2 remote entry points with any lite version. With the JDBC drivers, you need the enterprise version to connect to z/OS and this is almost certainly the same as with C# - this is to keep the mainframe protected from all-and-sundry clients that don't have the blessing of the 'enterprise gods'.

如果您还没有一个有效的许可证，客户甚至不会尝试连接到主机。错误code和国家您收到完全匹配我所描述的情况。并以他的图书馆，我想你的意思IHS时，IBM HTTP服务器，它基本上是Apache的有很多IBM的群众演员（包括可能，企业DB2连接许可证，尽管这只是一个最好的猜测）。

If you don't have a valid license, the client won't even attempt to connect to the mainframe. The error code and state you're receiving match exactly the situation I describe. And by "HIS libraries", I assume you mean IHS, the IBM HTTP server, which is basically Apache with a lot of IBM extras (including, probably, the enterprise DB2 Connect licenses, although that's only a best guess).

重复我在你的previous问题陈述的主题（<一href="http://stackoverflow.com/questions/396589/ibm-data-db2">http://stackoverflow.com/questions/396589/ibm-data-db2):

Repeating what I stated in your previous question on the subject (http://stackoverflow.com/questions/396589/ibm-data-db2):

IBM后卫（或者，更precisely，让他们的客户守卫）的大型机DB2访问非常密切的合作。我怀疑这是与确保唯一的企业应用程序的祝福，甚至尝试连接（没有正确的许可文件甚至没有得到他们出现在主机的TCP端口的请求，他们挡在了JDBC客户端客户端） - 主机通常是关键业务的方式大多数台式机/服务器应用程序只是梦想成为： - ）

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 applications only dream of becoming :-).

使用的JDBC驱动程序，单一类型-4驱动器用于访问所有DB2平台（LUW，i系列，System z的等），但你实际上必须有一个许可证文件安装在CLASSPATH中的特定平台或你会得到一个异常。

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.

这许可证文件的形式为db2jcc_cisuz.jar里的cisuz指定哪些平台允许被访问（立方米是最常见的，但并没有给访问iSeries或System z的）的

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

您通常必须购买的DB2 Connect从IBM获得这些文件，我怀疑这将是.NET Framework的一个类似的情况。您可能会发现DB2 Connect的产品有.NET客户端驱动程序以及JDBC（我没有看）。寻找，因为标准的那些产品的企业版将不可能有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.

这篇关于的IBM.Data.DB2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！