IBM InfoSphere Federation Server, Version 10.5

Testing the connection to the Informix server

Test the connection to the Informix® data source server to determine if the federated server is properly configured to access Informix data sources.

About this task

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

Procedure

Open a pass-through session and issue a SELECT statement on the Informix system tables. If the SELECT statement returns a count, your server definition and your user mapping are set up properly.

For example:

SET PASSTHRU server_definition_name
SELECT count(*) FROM informix.systables
SET PASSTHRU RESET

If the SELECT statement returns an error, you should troubleshoot the connection errors.

Feedback