Skip to content

Unable to connect to IBM cloud db2 database #945

@ahmednrana

Description

@ahmednrana

Unable to connect to IBM cloud db2 database

Although I can connect to db2 databases but the one from IBM cloud are not accessible. Although I can connect to them using Dbeaver

  1. Add such a connection
  2. It will give an error
  3. The connection string in db2 is
    jdbc:db2://reportdb.client.suite.maximo.com:32461/BLUDB:sslConnection=true;encrypt=true;trustServerCertificate=true;sslCertLocation=C:\tools\cert-ssl.txt;sslClientHostnameValidation=false;
    and it works in Dbeaver after a few warnings.

Expected Behavior

The connection should be OK

Actual Behavior

I got an error in connection

Environment

  • DBCode version: 1.26

  • VS Code (or fork) version: Version: 1.108.00347-insider (system setup)
    Commit: 56bd352fc181ec0def1ac6b32e48444af7596887
    Date: 2026-01-14T12:27:37.046Z
    Electron: 39.2.7
    ElectronBuildId: undefined
    Chromium: 142.0.7444.235
    Node.js: 22.21.1
    V8: 14.2.231.21-electron.0
    OS: Windows_NT x64 10.0.26200

  • OS: Windows 11

  • Database: DB2

  • Connection: (direct/SSH/SSL) SSL

Error Meesages (if applicable)

Error connecting to Test ibm cloud, error: [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication protocol being used: "SSL".  Communication API being used: "SOCKETS".  Location where the error was detected: "".  Communication function detecting the error: "sqlccSSLSocketSetup".  Protocol specific error code(s): "414", "*", "*".  SQLSTATE=08001

Screenshots

If applicable, add screenshots to help explain your problem.

Logs

If available, paste relevant logs from the Output panel (View > Output > DBCode).

2026-02-03 12:04:05.916 [debug] SchemaFactory: Attempting to load databases from storage for connection 'Test ibm cloud'
2026-02-03 12:04:05.918 [debug] FileStore: failed to find file 'schemas/OZcT9tPeg5LUGte3oIAoK/OZcT9tPeg5LUGte3oIAoK.data'
2026-02-03 12:04:05.918 [debug] SchemaFactory: No databases found for connection 'Test ibm cloud'
2026-02-03 12:04:05.929 [info] Found existing 'IBM DB2 Node Binary' version file: 'c:\Users\ranaa\.vscodium-insiders\extensions\dbcode.dbcode-1.26.16-universal\out\vendor\ibm_db\build\Release\IBM DB2 Node Binary.json'
2026-02-03 12:04:05.934 [info] Found existing 'IBM DB2 ODBC CLI' version file: 'c:\Users\ranaa\.vscodium-insiders\extensions\dbcode.dbcode-1.26.16-universal\out\vendor\ibm_db\installer\IBM DB2 ODBC CLI.json'
2026-02-03 12:04:05.935 [debug] DB2: checking connection on 'Test ibm cloud'
2026-02-03 12:04:42.802 [error] Connection: 'Test ibm cloud' failed:  Error: [IBM][CLI Driver] SQL30081N  A communication error has been detected. Communication protocol being used: "SSL".  Communication API being used: "SOCKETS".  Location where the error was detected: "".  Communication function detecting the error: "sqlccSSLSocketSetup".  Protocol specific error code(s): "414", "*", "*".  SQLSTATE=08001

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions