Unable to hit database using sender JDBC channel

[former_member207622]

Hi Folks

I am unable to hit database using sender JDBC channel I am getting unknown HOST error

This is DB2 database and driver and connection details are provided  , driver is properly installed

I am trying to ping the database using URL whihc is a tool by SAP http://host:port//myftp

Please help in this regard

ninad

[rajasekhar_reddy14]

Better to use IP adress instead of host name and check SID correct or not.

This is purely network issue, your DB team also has to accept PI calls for that Network team has to open Ports.

check with network team.

Regards,

Raj

[Former Member]

Dear Ninad

The test tool url is

http://hpst:port/ftpjdbc which comes after deployment of FTP_JDBC_ConnectionValidation_711.ear

check note Note# 1085539

Regards

Monika

[xavisanse]

Hi,

Have you checked SAP Note 1385571 ?

[Shabarish_Nair]

this could be a connectivity issue.

try to ping the host name or the IP address and confirm the connectivity between PI server and the DB.

Also instead of host name try to give the IP address in your connection parameters and try

[former_member207622]

I tried pinging from command prompt its working but not  through the channel

[Shabarish_Nair]

Did you log onto the PI server OS level and ping it or did you ping it from your desktop? Try to logon to the OS level of the server and then ping the DB. Also use the IP address in your connection parameters

[baskar_gopalakrishnan2]

This could be firewall port not enabled between source database server and PI server. Please check the network connectivity. I also recommend you to take help from BASIS. GO to PI server file system and see whether you can ping the database from there. Plus we use specific port for this database service.

[GabrielSagaya]

Hi,

Have you deployed the 2 jar files (db2java.zip,ojdbc14.jar) in the com.sap.aii.adapter.lib.sda file

Have you configured the parameter correctly or not.

Driver= COM.ibm.db2.jdbc.net.DB2Driver

JdbcUrl=jdbc: db2://<hostaddress or ipaddress>:<portno>/databasename

Make sure that hostname should be FQDN.

[GabrielSagaya]

Also check this thread

http://scn.sap.com/thread/1905235 for JDBC connection test tool