Process Orchestrator: Connect DB2 Mainframe with Process Orchestrator Using Only DB2 Client

Available Languages

Updated:February 28, 2012

Document ID:113447

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Introduction

Prerequisites

Requirements

Components Used

Problem

Set up DB2 Connection

Related Information

Introduction

This document describes how to connect a DB2 Mainframe database to Cisco Process Orchestrator using only the DB2 Client.

Prerequisites

Requirements

There are no specific requirements for this document.

Components Used

The information in this document is based on the Cisco Process Orchestrator/Tidal Enterprise Orchestrator (TEO) 2.2 and later.

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Problem

The user wants to connect Cisco Process Orchestrator to their DB2 mainframe and only wants to install the DB2 client, normally due to licensing issues.

Set up DB2 Connection

Complete these steps:

Install DB2 Client from the DB2 Connect-based install component. Use 9.7 in Windows 2008 R2 or 9.1 in Windows 2008 Standard.
After install, start the Cisco Process Orchestrator console and go to Administration > Adapters. Open the DB2 adapter, and click refresh on the prerequisites tab. The shield for the adapter should turn green.
Go to Start > All programs > IBM DB2 > Set-up Tools > Configuration Assistant in order to start the DB2 configuration tool.
Once the tool opens, click Selected > Add Database Using Wizard.
Select Manually Configured, and click Next.
Select TCP/IP, and click Next.
Configure the Hostname and Port of the mainframe, and click Next.
Configure the DB2 database name to connect to, and click Next.
Uncheck the register database box, and click Next.
Select OS/390 or z/OS for the operating system. Enter DB2 for instance name, and click Next.
Accept the defaults on the Operating System page, and click Next.
Select Sever Authentication, and click Finish. Test the connection with a valid user ID and password.
Return to the Cisco Process Orchestrator console, and go to Definitions > Targets.
Right-click Targets > New > DB2 Mainframe.
Input the hostname or IP, the database name, the port number, and create a runtime user and password. Click OK, and the target will be created.