search

zowe / zowe-cli-db2-plugin

DB2 Plugin for the Zowe CLI
Eclipse Public License 2.0
8 stars 16 forks source link

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

Open spufidoo opened 4 years ago

spufidoo commented 4 years ago

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 commented 4 years ago

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 commented 1 year ago

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