To use the db2test utility
If your operating system does not provide the db2test utility, use the cxntest utility to test connections to the target database.
1.
From a command prompt on the Campaign server, run the db2test utility.
The db2test utility returns a list of databases (registered data sources) that you can connect to.
2.
The db2test utility is prompt-driven. You must enter the following information exactly at the prompts:
*
The name of the database you want to connect to (taken from the list of Registered Data Sources)
*
A database user ID
*
The password associated with the database user ID
The utility does not prompt for confirmation of your selections.
3.
When you have successfully connected to the database, the db2test utility prints out messages like the following and presents you with a command prompt:
 

Server ImpactDemo conforms to LEVEL 1.
Server's cursor commit behavior: CLOSE
Transactions supported: ALL
Maximum number of concurrent statements: 0
For a list of tables, use PRINT.
4.
You can enter the following commands at the prompt:
*
describepattern
Describes the table or tables specified by pattern. Returns the corresponding type, data type, storage length, precision, and scale.
*
exit
Terminates the database connection and exits.
*
help
Displays a list of supported commands.
*
print[pattern]
Returns a list of tables. Can optionally specify a search pattern.
*
quit
Terminates the database connection and exits.
*
SQL_command
Executes any valid SQL command or series of SQL commands.
*
typeinfo
Returns a list of supported data types for the database.
Copyright IBM Corporation 2015. All Rights Reserved.