Cisco Cisco Process Orchestrator 3.1 ユーザーガイド

Use the following process to monitor and manage IBM DB2 database instances. 

Create an IBM DB2 database target (see 

).

Define an IBM DB2 database activity. 

In the Process Editor Toolbox, choose Database > IBM DB2 > [DB2 Database Activity], then drag 
and drop the activity onto the Workflow pane.

Click the General tab and enter the required information.

Click the [Activity-Specific] tabs to define the properties specific to the activity. 

Enter the information in the remaining tabs as necessary, then click Save to complete the activity 
definition.

For details about a specific activity, see 

.

View the activity results (see 

The DB2 Database Adapter provides the activities to access DB2 database objects and execute SQL 
queries in Process Orchestrator. Use the SQL tab to configure DB2 database query settings.

Choose Administration > Adapters, right-click IBM DB2 Database Adapter and choose Properties.

Click the SQL tab to configure database adapter properties:

Maximum number of rows—Maximum number of rows to return in a Select SQL query (default 
10000)

Termination character—Termination character string with default values

Termination characters can be configured in DB2. Common termination characters are forward slash 
[ / ] and the semi-colon [ ; ].

Click OK to close the dialog box.

Using the DB2 Database adapter, you can create these types of targets:

Use the DB2 Mainframe Database target to specify the connection information for a IBM mainframe 
using DB2 architecture.

Use the DB2 Universal Database target to specify the connection information used to connect to a 
DB2 universal database.

Choose Definitions > Targets, right-click, choose New, then choose one of the following options:

DB2 Mainframe Database