Troubleshooting
Problem
CTGDIJ109E Unable to connect to the database, due to invalid hostname.
Symptom
CTGDIJ109E Unable to connect to the database (Required property "serverName" is unknown host).
Verify that all the database connection parameters are correctly specified.
com.ibm.db2.jcc.c.SqlException: Required property "serverName" is unknown host
at com.ibm.db2.jcc.a.a.<init>(a.java:205)
at com.ibm.db2.jcc.a.b.a(b.java:1734)
at com.ibm.db2.jcc.c.bb.a(bb.java:394)
at com.ibm.db2.jcc.c.bb.<init>(bb.java:354)
at com.ibm.db2.jcc.a.b.<init>(b.java:314)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:379)
at java.sql.DriverManager.getConnection(DriverManager.java:415)
at com.ibm.di.connector.JDBCConnector.initialize(JDBCConnector.java:339)
at com.ibm.di.server.CSDeltaTaskComponent.doInitialize(CSDeltaTaskComponent.java:170)
at com.ibm.di.server.AssemblyLineComponent.initialize(AssemblyLineComponent.java:1150)
at com.ibm.di.server.AssemblyLine.initConnectors(AssemblyLine.java:1909)
at com.ibm.di.server.AssemblyLine.msInitConn(AssemblyLine.java:3554)
at com.ibm.di.server.AssemblyLine.executeMainStep(AssemblyLine.java:3364)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2989)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2972)
at com.ibm.di.server.AssemblyLine.executeAL(AssemblyLine.java:2939)
at com.ibm.di.server.AssemblyLine.run(AssemblyLine.java:1317)
Cause
The hostname (serverName) specified in the JDBC URL is incorrect or unreachable.
Diagnosing The Problem
Obtain the IP address of the Database server and attempt the connection using the IP address instead of the registered hostname in the JDBC URL parameter.
If this is successful, then there may be an issue with the DNS resolution should be addressed with the networking team.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21701635