Question 9
An administrator configures an IBM DB2data source at cell scope. The environment variable DB2UNIVERSAL_JDBC_DRIVER_PATH is configured at cluster scope. The data source test connection on one node succeeds, but fails on the other node with java.lang.ClassNotFoundException:com.ibm.db2.jcc.DB2ConnectionPoolDataSource.
Which of the below is the likely cause for the exception?
The data source is configured at cell scope.
Multiple driver JARs are installed on the second node.
DB2UNIVERSAL_JDBC_DRIVER_PATH is configured at cluster scope.
A different version of the JDBC driver JAR does not exist on the second node.
Correct answer: C
Explanation:
Check that the variable is correctly defined at the scope where the JDBCProvider/DataSource is defined.Note: At runtime, WebSphere Application Server invokes a physical data source by resolving the appropriate variable at a level where one of thefollowing criteria exists: The scope of the variable can contain the data source configuration; that is, the variable has the larger scope.The variable and the data source have identical scopes.Application Server meets these conditions by attempting to resolve the variable at each level of the scope spectrum. That is, the product tries to resolve the variable in the server scope, then the cluster scope, then the node scope, and lastly the cell scope.References: https://www.ibm.com/support/knowledgecenter/SSAW57_8.0.0/com.ibm.websphere.nd.doc/info/ae/ae/cdat_testcon.html
Check that the variable is correctly defined at the scope where the JDBCProvider/DataSource is defined.
Note: At runtime, WebSphere Application Server invokes a physical data source by resolving the appropriate variable at a level where one of thefollowing criteria exists: The scope of the variable can contain the data source configuration; that is, the variable has the larger scope.
The variable and the data source have identical scopes.
Application Server meets these conditions by attempting to resolve the variable at each level of the scope spectrum. That is, the product tries to resolve the variable in the server scope, then the cluster scope, then the node scope, and lastly the cell scope.
References: https://www.ibm.com/support/knowledgecenter/SSAW57_8.0.0/com.ibm.websphere.nd.doc/info/ae/ae/cdat_testcon.html