Testing a connection using wsadmin

The AdminControl object of the wsadmin scripting tool has a testConnection operation that tests the configuration properties of a data source object.

Before you begin

About this task

The testConnection operation takes a data source configuration ID as an argument.
Note: This invocation cannot accept user IDs and passwords that must be defined in the database itself. This invocation can only be used for databases that do not require a user ID and password to make a connection (such as DB2® on a Windows® machine), or for data sources that have a component-managed or container-managed authentication alias set on the data source object.

Procedure

  1. Invoke the getid() method for your data source.
  2. Set the value of the configuration id to a variable.
    set myds [$AdminConfig getid /JDBCProvider:mydriver/DataSource:mydatasrc/] 
    where /JDBCProvider:mydriver/DataSource:mydatasrc/ is the data source you want to test. After you have the configuration ID of the data source, you can test the connection to the database.
  3. Test the connection to the database.
    $AdminControl testConnection $myds



In this information ...


Related concepts

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    

Terms of Use | Feedback

Last updated: Oct 20, 2010 11:50:58 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-base-iseries&topic=testcon1
File name: tdat_testcon1.html