Benchmark Factory for Database 7.6.1 - User Guide

Create IBM DB2 CLI Connection

Benchmark Factory allows you to create a native connection to an IBM DB2 database.

To create an IBM DB2 CLI connection

1. Click in the main toolbar. The New Connection dialog opens.
2. Select IBM DB2 CLI from the drop-down list.

3. Enter the connection information. Review the following for additional information:

   Note: BFScripts have been enabled on the User Name and Password fields.

   Native
   Database Alias	Enter the database name.
   User Name	Enter the user name to use for this connection.
   Password	Enter the password associated with the user name.
   Connection Name	Enter a name to use to identify this connection.
   Reconnect Options	Click link to specify timeout and reconnect options. See Connection Timeout and Reconnect Options.

4. Click Create Connection to save the connection information and connect.
5. After creating a new DB2 connection, you can collect database and host server information using the Edit Connection dialog. See Environment Information for more information.

Performance Counters

Benchmark Factory allows you to add additional performance counters to a connection. See Performance Counters Tab for more information.

Note: To review or modify a connection, click Edit Connections in the main toolbar. Select a connection and click .

Edit/Manage Connections

To edit a connection, use the My Connections pane or click the Edit Connections button in the main toolbar. Both the My Connections pane and the Edit Connections dialog provide a list of your currently-defined connections. Use either of these interfaces to view or modify information for each connection.

To edit a connection

1. Use one of the following methods to edit a connection:
   • In the My Connections pane, select a connection and click .
   • Click in the main toolbar. Then select a connection and click in the Edit Connections dialog.
2. The Connection dialog for the selected connection opens. Use the DB Connection tab to update the connection password or other connection information.
3. Select from among the other tabs to add or modify other properties associated with the connection. The following tabs are available (depending on the connection type).
   • Environment Information
   • Performance Counters Tab
   • Oracle Clustering Tab (Connections)
   • Oracle Statistics Tab (Connections)

Connection Toolbars

Edit Connections Dialog Toolbar

The following commands are available from the toolbar in the Edit Connections dialog.

	Open the New Connection dialog to create a new connection.
	Remove the selected connection.
	Open the Connection dialog for the selected connection. Use this dialog to view or edit connection properties.

My Connections Pane Toolbar

The following commands are available from the toolbar in the My Connections pane.

	Create a new connection.
	Edit the selected connection.
	Duplicate the selected connection.
	Delete the selected connection.

Timeout and Reconnect Options

You can specify timeout and reconnect options when you are creating a new connection. You can also specify these options at any time for an existing connection.

To specify timeout and reconnect options

1. In the New Connection dialog, after entering connection information, click Reconnect Options.

2. Specify options. Review the following for additional information:

   Timeout
   Time	The maximum amount of time Benchmark Factory will try to log on to the system-under-test. If this amount of time is reached, Benchmark Factory will return an error.
   Infinite timeout	Prevents the logon to the system-under-test from timing out and returning an error.
   Reconnect
   Enable Reconnect	Enables Benchmark Factory to attempt to reconnect to the system-under-test if the connection is lost.
   Number of reconnect attempts	The number of times to attempt to reconnect before aborting.
   Time to wait between reconnect attempts (seconds)	How long to wait before attempting to reconnect.

3. Click OK.

To specify timeout and reconnect options for an existing connection

1. Click in the main toolbar.
2. Select the connection and click .
3. Then click Reconnect Options in the Connection dialog.

Environment Information

Benchmark Factory can collect and display database and host server information for each connection. The information is displayed in the Environment tab of the Connection dialog for an existing connection and also in the Database Under Test page of the New/Edit Job Wizard.

You can also create custom properties to add your own customized information to the connection.

To display environment information for an existing connection

1. Navigate to the Connection dialog for an existing connection using one of the following methods:
   1. In the My Connections pane, select a connection and click .
   2. Click in the main toolbar. Select a connection and click in the Edit Connections dialog.
2. Select the Environment tab in the Connection dialog.

3. Click Detect Environment Information.

   Note: To successfully view all environment information requested by Benchmark Factory, the login account used in the connection must have sufficient permissions.

To display environment information in the New/Edit Job wizard

1. Open the New Job Wizard or select a job and open the Edit Job wizard.
2. Select the Database Under Test page.
3. (New job) Select a connection.

4. Click Detect Environment Information.

   Note: To successfully view all environment information requested by Benchmark Factory, the login account used in the connection must have sufficient permissions.

To create a custom property

1. In the Connection dialog for a connection, select the Environment tab.
2. Click Add.
3. Enter a property name and value. Click OK.
4. The new property and value display in the Environment tab under Custom Properties.

Permissions Required to Detect Environment Information

In order to display database and host server information for a particular connection, the user account for that connection must have the necessary permissions. Review the following special requirements for detecting environment information.