英文:
How to use DB2Connect license file for IBM Db2 .net provider nuget package?
问题
我的工作站机器和我们的应用服务器（生产环境和QA环境）都有文件夹 C:\Program Files\IBM\SQLLIB\。其中包含用于较旧的 .net 框架的 DB2 .net 提供程序（C:\Program Files\IBM\SQLLIB\BIN\netf40_32）。我们的一些旧应用程序使用 IBM DB2 ODBC 驱动程序。但对于应用程序，我们无法使用它，因为我们找不到使用 SSL 证书作为身份验证而不是密码的工作连接字符串。
现在我们在我们的 .net core 应用程序中添加了 NuGet Gallery | IBM.Data.DB2.Core 3.1.0.600。在开发和QA部署期间，我们的应用程序可以通过与 Db2 连接正常工作。现在我们将要部署到生产服务器。我担心我们是否会因许可问题而遇到问题。
我从这个FAQ中了解到“现有的 DB2Connect 许可证应该有效”。如何查找我们是否有 DB2Connect 许可证呢？这篇博客文章说我们需要将许可证文件放在指定的路径中。
目前，我可以在 C:\Users\ {MyUserName} .nuget\packages\ibm.data.db2.core\3.1.0.600\buildTransitive\clidriver\license 文件夹中找到 2 个名为 "odbc_notices.rtf" 和 "odbc_REDIST.txt" 的文件，还有另一个名为 "Windows" 的文件夹，其中包含 odbc_LI_en.rtf 文件。而且我只能在此文件夹 C:\Program Files\IBM\SQLLIB\license 中找到 rtf 文件。
我想确保我们的生产部署将能够使用 IBM Db2 .NET Core 提供程序与 Db2 连接而不会出现任何问题。
我的问题是：
- 如何验证我的应用服务器是否有 "Db2Connect"？
- 如果有，我们可以从哪里（许可证文件路径位置）复制许可证文件？
- 如何识别许可证文件？文件扩展名是什么？
- 对于本地开发，我们需要将许可证文件粘贴到哪个位置，是 "C:\Users<MyUserName>.nuget\packages\ibm.data.db2.core\3.1.0.600\buildTransitive\clidriver\license" 还是 "C:\Users<MyUserName>\sourceCode\ApplicationProject\bin\Debug\netcoreapp3.1\clidriver"？
- 对于 QA、生产环境服务器部署，我们需要将许可证文件放在哪个位置，是 "E:\apps\MyApplication\clidriver\license" 还是 "C:\Users<MyUserName>.nuget\packages\ibm.data.db2.core\3.1.0.600\buildTransitive\clidriver\license"？
- 我们需要许可证来使用 C:\Program Files\IBM\SQLLIB\BIN\netf40_32 中的 dll 吗？
英文:
My workstation machine and our app servers(both prod & QA environments) are all got folders C:\Program Files\IBM\SQLLIB\ . It contains DB2 .net providers for older .net framework(C:\Program Files\IBM\SQLLIB\BIN\netf40_32). Our few old applications are using IBM DB2 ODBC Driver. But for application we can't use that since we can't find a working connection string which uses SSL Certificates as Authentication instead of password.
Now we have added NuGet Gallery | IBM.Data.DB2.Core 3.1.0.600 in our .net core application. During development and QA deployment, our app is working fine by connecting with Db2. Now we are going to deploy to production server. I am worrying about whether we will face any issue due to license.
I learned that "existing DB2Connect license should work" from this faq. How to find whether we have DB2Connect license or not? This blog post says we need to place the license file in the specified path.
Currently I can find 2 files named "odbc_notices.rtf" , "odbc_REDIST.txt" in C:\Users\ {MyUserName} .nuget\packages\ibm.data.db2.core\3.1.0.600\buildTransitive\clidriver\license folder along with another folder named "Windows" which contains odbc_LI_en.rtf file. And also I can only find rtf files in this folder C:\Program Files\IBM\SQLLIB\license .
I want to ensure that our production deployment will connect with Db2 using IBM Db2 .NET Core Provider without any issue.
My questions are:
- How to verify whether my app servers have "Db2Connect" or not?
- If yes, From where(license file path location) we can copy the license file?
- How to identify a license file ? what is the file extension?
- For local dev, To which location we need to paste the license file whether "C:\Users<MyUserName>.nuget\packages\ibm.data.db2.core\3.1.0.600\buildTransitive\clidriver\license" or C:\Users<MyUserName>\sourceCode\ApplicationProject\bin\Debug\netcoreapp3.1\clidriver
- For QA , Prod environment server deployment To which location we need to place the license file whether E:\apps\MyApplication\clidriver\license or "C:\Users<MyUserName>.nuget\packages\ibm.data.db2.core\3.1.0.600\buildTransitive\clidriver\license"
- Do we need license to use dll in C:\Program Files\IBM\SQLLIB\BIN\netf40_32 ?
答案1
得分: 0
对于DB2connect许可证，我们不需要在客户端即应用程序端执行任何操作。许可证将存在于主机系统中。因此，就开发和部署而言，我们无需担心许可证问题。
请与您的主机管理团队/Db2管理团队确认是否在主机上拥有Db2Connect许可证。
如果许可证不在Db2主机系统上，那么需要在客户端安装它。您可以通过nuget向IBM团队发送消息以获取试用许可证。
请参考此论坛的问答以获取更多信息：https://community.ibm.com/community/user/datamanagement/discussion/how-to-use-db2connect-license-file-for-ibm-db2-net-provider-nuget-package#bmbe68bacf-0e65-4e7e-89e2-01871495d413。
英文:
For DB2connect License , We don't need to do anything in client side i.e. Application side. The License will be in mainframe system. So for development and deployment we don't need to worry about the license.
Ensure with your mainframe admin team / Db2 Admin Team whether you have Db2Connect license in mainframe or not.
If the license is not on the Db2 mainframe system it needs to be installed on the client. You can get trial license by sending a message to IBM team through nuget .
Please refer this Forum Q&A for further info https://community.ibm.com/community/user/datamanagement/discussion/how-to-use-db2connect-license-file-for-ibm-db2-net-provider-nuget-package#bmbe68bacf-0e65-4e7e-89e2-01871495d413
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论