Verifying a data source connection

Many connection problems can be easily fixed by verifying configuration parameters. There are steps that you must complete to enable a successful connection.

About this task

If your connection is still not successful after completing these steps and reviewing the applicable information, check the SYSOUT for the servant for warning or exception messages.
New feature New feature: This topic references one or more of the application server log files. Beginning in WebSphere Application Server Version 8.0 you can configure the server to use the High Performance Extensible Logging (HPEL) log and trace infrastructure instead of using SystemOut.log , SystemErr.log, trace.log, and activity.log files or native z/OS logging facilities. If you are using HPEL, you can access all of your log and trace information using the LogViewer command-line tool from your server profile bin directory. See the information about using HPEL to troubleshoot applications for more information on using HPEL.newfeat

Procedure

  1. Create the authentication data alias. See the topic, Managing Java 2 Connector Architecture authentication data entries.
  2. Create the JDBC provider. See the topic, Configuring JDBC providers using the administrative console.
  3. Create a data source. See the topic, Configuring a data source using the administrative console
  4. Save the data source.
  5. Verify the connectivity if you created an authentication alias. To verify connectivity, restart the server for which you must verify connectivity.

    If you are using scripting or Java Management Extensions (JMX) to create the authentication alias, you can use the updateAuthDataCfg MBean. You can use this MBean method to refresh the authentication data in each server where it is needed. When you create a data source and the data source has not been used, you can use the updateAuthDataCfg MBean method. After a data source is used, its contents are instantiated in the server memory and generally cannot be changed.

    For more information about the updateAuthDataCfg MBean method, see the SecurityAdmin MBean documentation under Reference > Programming interfaces > Mbean interfaces.

  6. Test the connection.

    You can test your connection from the data source collection view or the data source details view. Access either view in the administrative console, and then select a connection from the list. Click Test Connection on the connection.

    See the topic, Test the connection service.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms of Use | Feedback

Last updatedLast updated: Sep 19, 2011 3:08:41 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=matt&product=was-nd-zos&topic=verifycon
File name: tdat_verifycon.html