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

Cisco Process Orchestrator is designed to enhance the management and administration of 
mission-critical information in an IBM DB2 database. DB2 is one of the database management system 
software products in IBM that provides performance, scale, and reliability on multiple platforms. Use 
the Cisco Process Orchestrator DB2 Database Adapter to automate common SQL queries in the DB2 
database. 

The following table displays activities that are provided by the IBM DB2 database adapter. For more 
information about using these activities, see 

Bulk Insert into DB2

Provides source table for data inserted into database.

For more information, see 

.

DB2 Database Locks

Queries the locks performed in the DB2 database. 

For more information, see 

.

DB2 Table Space

Queries the table space in a DB2 database. 

Delete from DB2 
Database

Deletes data from the DB2 database using SQL command lines. 

Enter the command text for the selected database. For example, this is a 
simple DELETE statement:

DELETE from mytable where mycolumn = 'zzz'

For more information, see 

Execute DB2 SQL Script

Executes SQL script against a DB2 database. 

For more information, see 

.

Insert Into DB2 Database

Executes SQL command used to insert data into a DB2 database. 

Enter the command text for the selected database. For example, this query 
inserts values into a table:

INSERT into mytable (column1,column2) VALUES ('val1','val2')

List DB2 Running SQL 
Queries

Queries the running SQL queries performed in the DB2 database.

Specify the information that describes the query results, including:

Row Limit—The appropriate number rows to limit for the query and 
returned data (default=50).

Select from DB2 Database Queries data from DB2 database.

For more information, see 

.

Update DB2 Database

Updates column information in the DB2 database using SQL command 
lines. 

Enter the command text for the selected database. For example, this query 
updates columns in a table:

Update mytable set column1 = 'newvalue' where column2 = 'zzz'