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

[AIX Solaris HP-UX Linux Windows][IBM i]If your connection is still not successful after completing these steps and reviewing the applicable information, check the SystemOut.log for warning or exception messages. Then use the technical support search function to find known problems.

[z/OS]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.
Note: 這個主題參照一或多個應用程式伺服器日誌檔。 此外,在分散式和 IBM® i 系統上,另外也建議您可以配置伺服器來使用「高效能可延伸記載 (HPEL)」日誌和追蹤基礎架構,而不使用 SystemOut.logSystemErr.log, trace.logactivity.log 檔案。HPEL 與原生 z/OS® 記載機能也可以一起使用。如果您使用 HPEL,則可以從伺服器設定檔 bin 目錄,利用 LogViewer 指令行工具來存取您所有的日誌和追蹤資訊。請參閱有關利用 HPEL 疑難排解應用程式的資訊,以取得更多使用 HPEL 的相關資訊。

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.

指出主題類型的圖示 作業主題



時間戳記圖示 前次更新: July 9, 2016 11:15
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=cord&product=was-nd-mp&topic=tdat_verifycon
檔名:tdat_verifycon.html