To use the db2test utility
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 db2testutility 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 2012. All Rights Reserved.