You can test connections for data sources with the wsadmin tool
and scripting.
About this task
Perform the following steps to test a data source to ensure a
connection to the database.
Procedure
- Identify the DataSourceCfgHelper MBean and assign it to the dshelper
variable.
Using Jacl:
set ds [$AdminConfig getid /DataSource:DS1/]
$AdminControl testConnection $ds
Using Jython:
ds = AdminConfig.getid('/DataSource:DS1/')
AdminControl.testConnection(ds)
Example output:
WASX7217I: Connection to provided datasource was successful.
- Test the connection. The following example invokes the testConnectionToDataSource
operation on the MBean, passing in the classname, userid, password, database
name, JDBC driver class path, language, and country.
Using Jacl:
$AdminControl invoke $dshelper testConnectionToDataSource
"COM.ibm.db2.jdbc.DB2XADataSource db2admin db2admin
{{databaseName sample}} c:/sqllib/java/db2java.zip en US"
Using Jython:
print AdminControl.invoke(dshelper, 'testConnectionToDataSource',
'COM.ibm.db2.jdbc.DB2XADataSource dbuser1 dbpwd1
"{{databaseName jtest1}}" c:/sqllib/java12/db \"\" \"\"')
Example output:
WASX7217I: Connection to provided data source was successful.