Unable to connect DB2 Zos with bluemix using cloud integaration -


we used cloud integration connect mainframe db2 in bluemix, downloaded secure connector in linux os , configured db2 jars. status in bluemix got changed "connected" ,but unable proceed further create api db2 ip's endpoints getting error "database connected , please check secure connection".but have checked our secure connection in terminal in start mode. please provide on same.

are able connect z/os server without secure connector; using other client?

you can use db2jcc - ibm data server driver jdbc , sqlj diagnostic utility test database connectivity , validate db2 authentication using java. sample command , it's output shown below:

$ java com.ibm.db2.jcc.db2jcc -url jdbc:db2://myhost.ibm.com:446/mydb -user myuserid -password mydbpasswd  [jcc][10521][13706]command : java com.ibm.db2.jcc.db2jcc -url jdbc:db2://myhost.ibm.com:446/mydb -user myuserid -password ********  [jcc][10516][13709]test connection successful.  db product version = dsn11015 db product name = db2 db url = jdbc:db2://myhost.ibm.com:446/mydb db drivername = ibm data server driver jdbc , sqlj db os name = linux $ 

if have access db2cli executable (sqllib/bin/db2cli), can run below command test connectivity , rule out server side configuration issue:

db2cli validate -database dbname:host_name or ip:port_number -connect -user userid -passwd password

example:

$ db2cli validate -database sample:bimaljha.in.ibm.com:446 -connect -user myuserid -passwd mypasswd ...... =============================================================================== connection attempt database "sample:bimaljha.in.ibm.com:446": ===============================================================================  [success]  =============================================================================== validation completed. ===============================================================================   $ 

if db2jcc or db2cli commands works fine, should connector issue in bluemix.


Comments

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

c# - how to use buttonedit in devexpress gridcontrol -

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -