DAL01013: Cannot connect to server

Question

I'm trying to connect to DB2 db but getting the error:

DAL01013. Cannot create connection to server 'Unknown server' due to the following: [jcc][t4][2034][11148][3.69.24] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected.  Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009

Assume it's something with my system. I cannot connect neither via DataStudio nor via QMF. Other users from other system can. I use same jdbc drivers. My system is Windows 7. Is there anything else I need to adjust on my system?

Answer 1

Personal repository needs to be created first:

https://developer.ibm.com/answers/questions/470013/error-when-trying-to-connect-to-db2-vis-qmf/

Answer 2

Generally you get the reason 0x3 from error -4499 out of the IBM JDBC driver when you are connecting to a SSL port, but you have not specified sslConnection=true on your JDBC connection string. You can also get the error if your database name is incorrect (i.e. does not exist on the server), or your JDBC dirver is too old (DB2 JDBC Driver Versions and Downloads Download Fix Packs by version for IBM Data Server Client Packages)

If connecting to Db2 on Cloud, Db2 Warehouse or Db2 Warehouse on Cloud, all you should need is the sslConnection=true as the CA certificate used in these products is part of the Db2 driver package (for recent drivers anyway)

If connecting to Db2 on premise, you can specify your certificate location via the JDBC properties sslCertLocation or sslTrustStoreLocation and sslTrustStorePassword

Common IBM Data Server Driver for JDBC and SQLJ properties for all supported database products

sslCertLocation Specifies that an application can configure the location of a trusted certificate file. For applications that have the database server certificate, sslCertLocation is the only property that is needed to be configured to instruct IBM Data Server Driver for JDBC and SQLJ to trust the certificate for SSL connections. This property removes the need to import the certificate into a Java truststore database and related driver configurations.

Error codes issued by the IBM Data Server Driver for JDBC and SQLJ

error codes in the ranges -4200 to -4299, and -4450 to -4499 are reserved for the IBM® Data Server Driver for JDBC and SQLJ.