Hi Team,
We have an audit requirement to enable ssl in our sqoop jobs. Our source which DB2 has enabled ssl, and when trying to connect to the DB fails with below error:
"Error executing statement: com.ibm.db2.jcc.am.DisconnectNonTransientException: [jcc][t4][2034][11148][3.68.61] 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"
Have performed the following actions:
added the certification to keystore file and generated a .jks file
sqoop config file has the following entries:
jdbc:db2://xxxxx.xxx:60542/abcd:sslconnection=true;ssltrustStoreLocation=/tmp/truststore.jks;ssltruststorePassword=xxxx;
I have also tried adding the jks file to hdfs location but fails with "file not found exception"
Are there any config changes that needs to be made sqoop properties file?
Is there is a documentation on how ssl is implemented for sqoop 1.4.6
Thanks for the the input!!!!