Troubleshooting
Problem
After IBM InfoSphere Information Server Fix pack 2 or Fix Pack 3 is applied, Db2 related warnings are reported in an installation that uses Oracle© or Microsoft SQL Server as the repository.
Symptom
No functional issues are observed.
However, even though Oracle© or SQL Server is used as the repository in an installation, Db2 related warning messages are logged in SystemOut.log.
For example,
[1/7/22 9:23:51:360 CET] 000000ec DSConfigHelpe W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: The property 'useJDBC4DataType' does not exist on the DataSource class com.ibm.isf.jdbcx.oracle.OracleDataSource. [1/7/22 9:23:51:360 CET] 000000ec DSConfigHelpe W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: The property 'useJDBC4ColumnNameAndLabelSemantics' does not exist on the DataSource class com.ibm.isf.jdbcx.oracle.OracleDataSource.
Similarly, execution of "Test connection" in the WebSphere Application Server Administration console, displays a warning message:
The test connection operation for data source ASB JDBC DataSource on server XXXXX at node XXXXXXXXX was successful with 2 warning(s). View JVM logs for further details.
However, even though Oracle© or SQL Server is used as the repository in an installation, Db2 related warning messages are logged in SystemOut.log.
For example,
[1/7/22 9:23:51:360 CET] 000000ec DSConfigHelpe W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: The property 'useJDBC4DataType' does not exist on the DataSource class com.ibm.isf.jdbcx.oracle.OracleDataSource. [1/7/22 9:23:51:360 CET] 000000ec DSConfigHelpe W DSRA8200W: DataSource Configuration: DSRA8020E: Warning: The property 'useJDBC4ColumnNameAndLabelSemantics' does not exist on the DataSource class com.ibm.isf.jdbcx.oracle.OracleDataSource.
Similarly, execution of "Test connection" in the WebSphere Application Server Administration console, displays a warning message:
The test connection operation for data source ASB JDBC DataSource on server XXXXX at node XXXXXXXXX was successful with 2 warning(s). View JVM logs for further details.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m500000008XGPAA2","label":"WebSphere Application Server-\u003EWebSphere Configuration"},{"code":"a8m500000008XJEAA2","label":"Xmeta Repository Database-\u003EOracle"},{"code":"a8m500000008XIuAAM","label":"Xmeta Repository Database-\u003ESQL Server"}],"ARM Case Number":"TS008142135","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.1"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
ibm16552524