Testing connections to JDBC data source servers

You can test the connection to the JDBC data source server by using the server definition and the user mappings that you defined.

Procedure

Open a pass-through session and issue a SELECT statement on the JDBC data source system tables.
If the SELECT statement returns a count, your server definition and your user mapping are set up properly. 
SET PASSTHRU server_definition_name
SELECT count(*) FROM schema_name.table_name
SET PASSTHRU RESET
If the SELECT statement returns an error, troubleshoot the connection errors.

What to do next

After you complete this task, you must register nicknames for the JDBC data source tables and views.