Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

IBM Db2 Connect Enterprise Edition has broken Zowe db2 plugin #55

Open
spufidoo opened this issue Jul 30, 2020 · 2 comments
Open

IBM Db2 Connect Enterprise Edition has broken Zowe db2 plugin #55

spufidoo opened this issue Jul 30, 2020 · 2 comments
Labels

Comments

@spufidoo
Copy link

Hi. I'm having trouble with my db2 plugin.

  1. I managed to install it a couple of months ago, but the "zowe plugins validate db2" showed "The specified plugin 'db2' has not been installed into your CLI application." Despite that, I could issue commands and queries to Db2 successfully.
  2. I then managed to get the Db2connect VSCode extension working nicely.
  3. I then tried to get Python talking to Db2/z, but kept on getting license errors - despite the fact that my enterprise license worked for the other plugins.
  4. I was told to install IBM Db2 Connect, which I did. Python STILL doesn't connect to Db2, and now the Zowe Db2 plugin has stopped working, and the Db2connect VSCode extension has stopped working.
    What can I do?
@spufidoo
Copy link
Author

Further info:
VSCode/Help/About:
Version: 1.47.3 (user setup)
Commit: 91899dcef7b8110878ea59626991a18c8a6a1b3e
Date: 2020-07-23T13:12:49.994Z
Electron: 7.3.2
Chrome: 78.0.3904.130
Node.js: 12.8.1
V8: 7.8.279.23-electron.0
OS: Windows_NT x64 10.0.17134

>zowe --version
2.36.4
>node --version
v12.18.2
>npm --version
6.14.5
>python --version
Python 3.8.3
>db2level
DB21085I This instance or install (instance name, where applicable: "DB2") uses "64" bits and DB2 code release "SQL11050" with level identifier "0601010F".
Informational tokens are "DB2 v11.5.0.1077", "s1906101300", "DYN1906101300WIN64", and Fix Pack "0".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".
>zowe plugins validate db2
The specified plugin 'db2' has not been installed into your CLI application.
>zowe db2 execute sql --query "select current timestamp from sysibm.sysdummy1"
Command Error:
Expect Error: Required parameter 'hostname' must be defined
>zowe db2 execute sql --query "select current timestamp from sysibm.sysdummy1" -H xxxx -P xxxx -u xxxx --pw xxxx
Command Error:
DB2 ODBC Driver Error: [node-ibm_db] SQL_ERROR
Error Details:
Error: CLI0600E Invalid connection handle or connection is closed. SQLSTATE=S1000
SQLCODE: -1
SQLSTATE: S1000

@zFernand0
Copy link
Member

Hey @spufidoo,
Does the issue still persist in newer versions of the plug-in?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: Medium Priority
Development

No branches or pull requests

2 participants