Table of Contents
Cisco Transaction ConnectionFeature Overview
CTRC and CICS
CTRC and DB2
Benefits
Related Documents
Supported Platforms
Supported Standards, MIBs, and RFCs
Configuration Tasks
Configuring CICS on the Host
Configuring a CICS Client
Configuring DB2 on the Host
Configuring SNA Switching Services
Configuring a CTRC Destination (CICS)
Configuring a CTRC Server (CICS)
Configuring a CTRC Route (CICS)
Configuring a CTRC Server (DB2)
Configuring the CTRC License
Verifying SNA Connectivity
Verifying CTRC Configuration
Monitoring and Maintaining CTRC
Monitoring and Maintaining CTRC Communications with CICS
Monitoring and Maintaining CTRC Communications with DB2
Configuration Examples
CTRC Servers with IP Addresses, RDB Names, and Ports Configuration Example 1 (DB2)
CTRC Servers with IP Addresses, RDB Names, and Ports Configuration Example 2 (DB2)
Server Selection by IP Addresses, RDB Names, and Ports Configuration Example (DB2)
CTRC with CIP and DB2 on VTAM Configuration Example (DB2)
CTRC Servers Using Token Ring to a LEN Configuration Example
(CICS and DB2)
CTRC Servers with IP Addresses, Routes, and Multi-Valued Destinations Configuration Example (CICS)
clear dbconn connection
clear txconn connection
clear txconn statistics
clear txconn transaction
dbconn license
dbconn pem
dbconn ping
dbconn server
dbconn tcpserver
show dbconn connection
show dbconn license
show dbconn ports
show dbconn server
show txconn connection
show txconn destination
show txconn license
show txconn route
show txconn server
show txconn statistics
show txconn transaction
txconn destination
txconn license
txconn ping
txconn route
txconn server
Debug Commands
debug dbconn all
debug dbconn appc
debug dbconn config
debug dbconn drda
debug dbconn event
debug dbconn tcp
debug txconn all
debug txconn appc
debug txconn config
debug txconn data
debug txconn event
debug txconn tcp
debug txconn timer
Error Messages
Glossary
Cisco Transaction Connection
This feature module describes the Cisco Transaction Connection (CTRC) software feature. It includes information on the benefits of using CTRC, supported platforms, configuration instructions, commands, error messages, and additional information about CTRC.
This document contains the following sections:
Feature Overview
The Cisco Transaction Connection (CTRC) software feature provides the following functionality:
- CTRC allows Cisco routers to use the intersystem communication (ISC) protocol to provide a gateway between Customer Information Control System (CICS) clients (also known as common clients) running under Windows or UNIX on Transmission Control Protocol/Internet Protocol (TCP/IP) networks and CICS online transaction monitoring systems on IBM hosts.
- CTRC supports two interfaces to common clients: the Extended Call Interface (ECI), which lets non-CICS client programs call CICS transactions, and the Extended Presentation Interface (EPI), which lets distributed applications call CICS transactions that were originally accessed via 3270 terminals.
- CTRC supports the ability to configure routes for CICS transaction. Each transaction can be routed to a specific CICS region.
- In addition to its CICS-related functionality, CTRC includes the feature previously known as Cisco Database Connection (CDBC), which allows Cisco routers to use IBM's distributed relational database architecture (DRDA) protocol to provide a gateway between client workstations running ODBC-compliant applications on TCP/IP networks and IBM DB2 databases on Systems Network Architecture (SNA) networks. ODBC (Open Database Connectivity) is a call-level interface developed by Microsoft Corporation that allows a single application to access database management systems from different vendors using a single interface. SNA is a large, complex, feature-rich network architecture developed by IBM.
- CTRC adds support for TCP/IP passthrough, allowing the use of a TCP/IP network, rather than a SNA network, between a Cisco router and a DB2 database if the database version supports direct TCP/IP access.
- To match functionality provided in DRDA over TCP/IP, CTRC adds support for Password Expiration Management (PEM) in SNA networks where PEM is supported.
CTRC and CICS
When a router is configured to use CTRC for communications with CICS systems, the router converts ISC packets over TCP/IP to ISC packets over Advanced Program-to-Program Communications (APPC LU6.2) and then routes them to the appropriate CICS region. CTRC converts CICS client messages received via TCP/IP to SNA messages and uses Cisco SNA Switching Services to transmit them to the host.
CTRC runs as a TCP/IP daemon on the router, accepting ISC client connections over TCP/IP. When a client connects to a CICS region on an IBM mainframe host, CTRC allocates an APPC conversation over SNA to an IBM server and acts as a gateway between ISC over TCP/IP and ISC over APPC.
Figure 1 illustrates how CTRC lets CICS client applications on TCP/IP networks interact with CICS transaction monitoring systems on IBM hosts.
Figure 1 Cisco Router Configured with the CTRC Feature for CICS Communications
CTRC and DB2
CTRC enables Cisco routers to implement IBM's DRDA over TCP/IP. The Cisco router with CTRC exists in the TCP/IP network, and clients use a CTRC IP address and port on the router to connect to the IBM host system that exists in either an SNA network or a TCP/IP network.
When CTRC is appropriately configured on a router, client-based ODBC applications can connect to the following IBM D2 relational databases:
For an SNA host connection, the router with CTRC converts DRDA packets over TCP/IP to DRDA packets over (APPC LU 6.2) and then routes them to DB2 databases. CTRC runs as a TCP/IP daemon on the router, accepting DRDA client connections over TCP/IP. When a client connects to the database on an IBM mainframe host, CTRC allocates an APPC conversation over SNA to an IBM server, and acts as a gateway between DRDA over TCP/IP and DRDA over APPC.
Figure 2 illustrates how the Cisco router configured with the CTRC feature enables the exchange of database information between ODBC client applications running DRDA in a TCP/IP network and a DRDA-based IBM system that accesses DB2 relational data.
Figure 2 Cisco Router Configured with the CTRC Feature for DB2 Communications (SNA Host Network)
For a TCP/IP host connection, the router with CTRC routes the DRDA packets over TCP/IP without protocol changes. To use this TCP/IP passthrough feature of CTRC, the host database version must support direct TCP/IP access. Figure 3 illustrates such a configuration.
Figure 3 Cisco Router Configured with the CTRC Feature for DB2 Communications (TCP/IP Host Network)
When configured for DB2 communications on a router, the CTRC feature enables desktop applications to access data in remote databases located on IBM hosts. CTRC receives database access messages from the client over a TCP/IP link. CTRC either converts the messages to SNA and transmits them to the host using APPC services provided by the Cisco SNA Switching Services, or routes the client messages to the TCP/IP-enabled host without protocol changes.
Benefits
Cisco Transaction Connection (CTRC) provides TCP/IP end-users and servers with fast, reliable, and secure access to IBM DB2 databases using the Systems Network Architecture (SNA) protocol. CTRC, a cost-effective software and router solution based on Cisco IOS software, replaces expensive and hard to manage UNIX and NT gateways for database access.
CTRC lets Windows or UNIX client applications call CICS transactions without requiring changes to the client or host software. CTRC provides improved performance, lower cost of ownership, and greater reliability than existing solutions from other vendors.
In addition, CTRC provides Cisco 7200 and 7500 series routers with the functionality previously available in CDBC, which gives ODBC client applications access to data in DB2 databases.
Related Documents
For information related to this feature, refer to the following document:
- Cisco IOS Release 12.0(5)XN SNA Switching Services
- Revealed! CICS Transaction Gateway with More CICS Clients Unmasked
(IBM publication SG24-5277)
See Chapter 15.4 (Configuration for VTAM & CICS TS for OS/390 when connecting with Microsoft SNA Server) - CICS Transaction Server for OS/390 V1R2 CICS Intercommunication Guide
(IBM publication SC33-1695) - DRDA Connectivity Guide
(IBM publication SC26-4783) - Distributed Relational Database Architecture (DRDA)
(Open Group publication C812, ISBN 1-85912-295-7)
Supported Platforms
Supported Standards, MIBs, and RFCs
MIBs
For descriptions of supported MIBs and how to use MIBs, see the Cisco MIB web site on CCO at http://www.cisco.com/public/sw-center/netmgmt/cmtk/mibs.shtml.
RFCs
No new or modified RFCs are supported by this feature.
Standards
No new or modified MIBs are supported by this feature.
Configuration Tasks
CTRC can be configured for use with CICS, with DB2, or both. Both CICS and DB2 configurations require Cisco SNA Switching Services. A few basic instructions for configuring SNA Switching Services are included in the following sections. For more extensive information, consult the SNA Switching Services documentation.
Note CTRC commands related to communications with CICS contain the word txconn. CTRC commands related to communications with DB2 contain the word dbconn. With the exception of commands related to licensing, dbconn and txconn commands act independently of each other and are discussed separately in this document. To configure CTRC for use with both CICS and DB2, complete all the configuration tasks listed below. To configure CTRC for use with CICS only, complete all the configuration tasks except those marked (DB2). To configure CTRC for use with DB2 only, complete all the configuration tasks except those marked (CICS). See the "Configuration Examples" section of this document for additional information.
Perform the following tasks to configure CTRC, in the order that they are listed here:
- Configuring CICS on the Host
- Configuring a CICS Client
- Configuring DB2 on the Host
- Configuring SNA Switching Services
- Configuring a CTRC Destination (CICS)
- Configuring a CTRC Server (CICS)
- Configuring a CTRC Route (CICS)
- Configuring a CTRC Server (DB2)
- Configuring the CTRC License
- Verifying SNA Connectivity
- Verifying CTRC Configuration
Configuring CICS on the Host
If you plan to use CTRC to communicate with CICS, you must configure CICS for APPC connections. Refer to the "Related Documents" section for additional information.
To configure CICS on the host, complete the following tasks:
- In VTAM, define the PU and LU for the Cisco router that will run CTRC.
- Choose a mode name that will be used by both the Cisco router and VTAM, such as #INTER, and make a note of it.
- Make a note of the VTAM APPLID value. You will need this value in later steps.
- In the CICS System Initialization Table (SIT), set ISC to YES, and set APPLID to the VTAM APPLID value.
- In CEDA (a CICS resource definition transaction), create a SNA Connection Definition with a unique four-character name (such as CTRC). Set NETNAME to the router's LU name (control point name). Set the following additional values:
Accessmethod: VTAM
Protocol: APPC
Attachsec: Verify
- Also in CEDA, create sessions related to the Connection Definition. Set the mode name to the value you chose earlier.
- Make sure that your CICS system includes a DFHCNV table for data conversion between ASCII and EBCDIC. If this table is not present, attempts to install and use CTRC may encounter APPC errors on the host that report failure to transform data received from the remote system. A DFHCNV table may contain lines such as are shown below. For more information about DFHCNV tables, see your CICS documentation.
DFHCNV TYPE=INITIAL,SRVERCP=037,CLINTCP=437
The "Configuration Examples" section of this document illustrates many of the host configuration tasks described above.
Configuring a CICS Client
To use IBM's CICS Common Client application with CTRC, complete the following tasks:
Server = Server name
Protocol = TCPIP
NetName = Host name or IP address for the CTRC router
Port = TCP/IP port number for the CTRC router (specify 0 to use the default of 1435)
Driver = TCPIP
Drivername = CCLWNTIP
Configuring DB2 on the Host
For information about preparing a DB2 system to receive communications from CTRC, see the CTRC User's Guide available from StarQuest Software, Inc.:
StarQuest Software, Inc.
1288 Ninth Street
Berkeley, CA 94710-1501
1-800-763-0050 in the US and Canada
1-510-528-2900 Worldwide, ask for extension 170
1-510-528-2986 FAX
Configuring SNA Switching Services
To configure basic SNA Switching Services, complete the following steps:
| Step | Command | Purpose |
|---|---|---|
| 1. | ||
| 2. | ||
| 3. |
Associates a SNA Switching Services link with a SNA Switching Services port.1 |
| 1If the partner node is initiating the connection, a link definition is not necessary. It is built dynamically when the partner node initiates the connection. Links are typically defined for upstream connectivity. |
Note For a LEN level connection between SNA Switching Services and the host, you will also need to configure the snasw location configuration command for the specific resource names to be contacted on the host. Do not define locations if APPN connectivity is being used between SNA Switching Services and the host.
For additional information about configuring SNA Switching Services, consult the SNA Switching Services documentation.
Configuring a CTRC Destination (CICS)
To configure CTRC to communicate with CICS, the first step is to configure a CTRC destination. If you do not need to communicate with CICS, skip to the "Configuring a CTRC Server (DB2)" section. A CTRC destination is ordinarily a single CICS system defined in terms of its remote LU name and APPC mode. Use the following global configuration command to configure a destination:
| Command | Purpose |
|---|---|
For load-sharing purposes, the txconn destination command can be repeated with the same destination name but new remote LU and mode values to assign more than one CICS system or region to a single CTRC destination name. If a CTRC destination is configured in this way, the CTRC server sends traffic to the destination's defined CICS regions on a rotating basis. A Cisco router can be configured to communicate with multiple CTRC destinations, whether each of those destinations is defined as an individual pair of remote LU and mode values or as a set of such values.
Configuring a CTRC Server (CICS)
After you have configured a CICS destination, you can configure a CTRC server process that will handle communications with that CICS system. Additional CTRC servers can be configured on the same router for communications with other CICS destinations. Use the following global configuration command to configure a CTRC server process to communicate with CICS:
| Command | Purpose |
|---|---|
|
Configures a CTRC server process for communicating with CICS. Note that if you do not supply a port number, CTRC uses the default value of 1435. |
When a client attempts to connect to a CTRC server for CICS, the server's port and IP address determine whether that connection is accepted or not. By default, the CTRC server port for CICS client communications is 1435. You can create multiple CTRC txconn and dbconn server processes on one router.
Configuring a CTRC Route (CICS)
After you have configured one or more destinations and server processes for communicating with CICS, you have the option of explicitly configuring CTRC routes that will direct traffic to the appropriate destination based on a transaction ID. If you do not explicitly configure CTRC routes, the CTRC server routes traffic to its own default destination. To configure a CTRC route, use the following global configuration command:
Configuring a CTRC Server (DB2)
To configure a CTRC server process for communications with DB2, use the following command in global configuration mode:
| Command | Purpose |
When a client attempts to connect to a CTRC server for DB2, the server's port, IP address, and remote database name (RDB name) determine if that connection is accepted. By default, the CTRC server port for client requests for DB2 communications is 446. You can create multiple CTRC dbconn and txconn server processes on one router.
Configuring the CTRC License
An unlicensed installation of CTRC allows you to use up to two DB2 connections, two CICS conversations, or one DB2 connection and one CICS conversation for testing purposes. For communications with DB2, CTRC checks the number of connections against the licensed number of users. For communications with CICS, CTRC checks the number of concurrent and queued conversations. To use additional connections or conversations, you must configure the CTRC license. One license key is used for both CICS and DB2 communications.
To obtain your CTRC license key, use the show config | include cpname command to determine the SNA Switching Services cpname for the router you will be licensing. (The CTRC license key is locked to one node and is based on the cpname.) Next, contact your Cisco representative, request a CTRC license key, and provide the cpname value. You should receive information about the number of connections you are licensing along with the license key. If the key is temporary, you should also receive information about the expiration date. After obtaining your license key, use either of the following global configuration commands to configure the CTRC license:
| Command | Purpose |
Verifying SNA Connectivity
To verify that you have SNA connectivity between the router and each host system, complete the following task:
ping sna -m IBMRDB STARW.BUDDY
Verifying CTRC Configuration
To verify the CTRC configuration, complete the following tasks:
Step 1 If you did not configure CTRC for communications with CICS, go to Step 6.
Step 2 If you configured CTRC for communications with CICS, enter the show txconn destination command in EXEC or privileged EXEC mode. Make sure that any CICS destinations you configured are listed with the RLU and mode values you specified.
Step 3 Enter the show txconn server command. Make sure that any CTRC servers you defined for communications with CICS are listed with the configuration values you specified.
If necessary, use the show txconn server server-name form of the command to display more information for an individual server.
Step 4 If you defined any routes for specific transaction IDs to take to CICS destinations, enter the show txconn route command. Make sure that any CTRC routes you defined are listed with the configuration values you specified. An asterisk (*) in the SERVER column indicates a global route that is used by all txconn servers on the router. An asterisk in the TRANID column indicates the default route for the listed txconn server.
Step 5 If you did not configure CTRC communications with DB2, go to Step 7.
Step 6 If you configured CTRC for communications with DB2, enter the show dbconn server command. Make sure that the servers you defined are listed with the configuration values you specified. If necessary, use the show dbconn server server-name form of the command to display more information for an individual server.
Step 7 Enter either the show dbconn license command or the show txconn license command. Make sure that the reported number of licensed connections matches the number you purchased.
Step 8 For each CICS destination you displayed in Step 1, enter the txconn ping command to verify that the router can communicate with that destination.
Step 9 For each dbconn server you displayed in Step 6, enter the dbconn ping command to verify that the router can communicate with the DB2 systems associated with that server.
Monitoring and Maintaining CTRC
This section describes commands used to monitor and maintain CTRC. Commands for CICS communications and DB2 communications are shown separately.
Monitoring and Maintaining CTRC Communications with CICS
Monitoring and Maintaining CTRC Communications with DB2
Configuration Examples
The following sections provide CTRC configuration examples:
- CTRC Servers with IP Addresses Configuration Example (DB2)
- CTRC Servers with IP Addresses, RDB Names, and Ports Configuration Example 1 (DB2)
- CTRC Servers with IP Addresses, RDB Names, and Ports Configuration Example 2 (DB2)
- Server Selection by IP Addresses, RDB Names, and Ports Configuration Example (DB2)
- CTRC with CIP and DB2 on VTAM Configuration Example (DB2)
- CTRC Servers Using Token Ring to a LEN Configuration Example (CICS and DB2)
- CTRC Servers with IP Addresses, Routes, and Multi-Valued Destinations Configuration Example (CICS)
CTRC Servers with IP Addresses Configuration Example (DB2)
Figure 4 shows a CTRC configuration where the CTRC servers are configured to listen on port 446 (by default) for IP addresses specified for these servers in the router's configuration for CTRC. When an ODBC client attempts to make a connection to DB2, a CTRC server accepts the connection if the IP address specified in its configuration matches the IP address to which the client wants to connect.
In this illustration, Servers A and B are configured with IP addresses 172.0.10.2 and 172.0.45.3. Servers A and B accept any connection that targets their IP addresses. Server C accepts any connection that targets any IP address of router on the target port of 446 and an RDB name of IOWA.
Figure 4 CTRC Servers' Configuration with IP Addresses (for DB2 Communications)
The following are the commands that configure servers Server A, Server B, and Server C in the Cisco router:
CTRC Servers with IP Addresses, RDB Names, and Ports Configuration Example 1 (DB2)
When a client request comes in for a server, and multiple servers are configured in the router, the three configured attributes of IP address, RDB name, and port determine which server is chosen for the connection. When a server is selected for a connection, the client remains associated with that server for the duration of that connection. The APPC attributes configured for that server are used to connect to the IBM system. If a server is unconfigured while active connections exist, the active connections with that server will break.
Only one CTRC server can be configured with a unique combination of IP address, port, and RDB name. If a situation arises where multiple servers in a router meet the criteria for accepting a client connection, the CTRC server that meets the most specific criteria accepts the connection. For example, in Figure 5 Servers A and B are listening on port 446 for client connections that match their IP address of 161.55.122.80. Server A is configured to accept RDB name NEVADA and Server B is configured to accept any RDB name. A client connecting to port 446 for RDB name NEVADA matches the criteria for both servers. In this situation, Server A is selected to accept the connection because its configuration includes a specific RDB name NEVADA as compared to Server B whose configuration accepts any RDB name.
Figure 5 CTRC Server Configuration with IP Address and RDB Name Defined
CTRC Servers with IP Addresses, RDB Names, and Ports Configuration Example 2 (DB2)
The IP address and port specified for a server in a router's configuration also determines which server accepts a connection. For example, Server C is configured to listen on any local IP address on port 446 and RDB name IOWA. Server D is configured to listen for IP address 145.56.180.34 on port 446 and RDB name IOWA. When a client attempts to connect to IP address 145.56.180.34 on port 446 for RDB name IOWA, both servers meet the criteria in accepting the connection. In this case, CTRC selects a connection based on the IP address first, then the port, and finally, the RDB name.
Server Selection by IP Addresses, RDB Names, and Ports Configuration Example (DB2)
If multiple servers in a router meet the criteria for accepting a client connection, the CTRC server that meets the most specific criteria accepts the connection. In Figure 6, the Cisco router contains four server configurations. All four servers listen for client connections on port 446 by default. Both Servers A and B are configured with the same IP address, 161.55.122.80. Servers A and C are configured to accept RDB name NEVADA. Servers B and D are configured to accept any RDB name.
If a client connects to IP address 161.55.122.80 on port 446 and sends RDB name NEVADA in the DRDA data stream, all four servers match the criteria for accepting the client connection. However, Server A will be selected to accept the connection because it meets the most specific criteria for IP address, RDB name, and port. If Server A was not configured, Server B would be the second choice because it meets the criteria for the IP address and port. The IP address specified in a server always has precedence when matching a connection to a server.
Figure 6 CTRC Server Configurations with IP Addresses, RDB Names, and Default Port
The following is the configuration for Servers A, B, C, and D in the Cisco router:
CTRC with CIP and DB2 on VTAM Configuration Example (DB2)
Figure 7 illustrates a Cisco router with a Channel Interface Processor (CIP) that is configured with CTRC. The CIP is networked and connected to VTAM on the mainframe. DB2 is configured on VTAM.
Figure 7 Cisco Router with CIP and Connection to DB2 on VTAM
The configuration in Figure 7 uses router commands to configure SNA Switching Services over CIP and CSNA via SRB. The following three pages of this document show the configuration in more detail. Note that the source-bridge ring-group of 100 matches the source bridge of 10 2 100 for interface Channel 13/2 to enable SNA Switching Services to run over SRB. In addition, the destination LAN address used by the snasw link station BUDDY corresponds to the virtual MAC address used by the adapter for Channel 13/2.
In the VTAM host definitions, the variable CONNTYPE=APPN is optional but recommended if you use APPN in your SNA environment. If CP to CP is set to YES and CONNTYPE is set to APPN, this configuration enables the Cisco router to establish CP-to-CP sessions with VTAM. By allowing CP-to-CP sessions, you gain the benefit of APPN's dynamic features such as the availability of directory and topology for locating resources and calculating optimal routes.
In this example, the router smoke is attached to the host BUDDY using a CIP processor.
Note Do not use a snasw location statement if you are using an APPN connection between the host and SNA Switching Services.
VTAM Partner PU and LU Definition
VTAM APPLID for DB2
Cisco IOS Configuration
CTRC Servers Using Token Ring to a LEN Configuration Example
(CICS and DB2)
This section provides a configuration example for a router named smoke, beginning with the VTAM definition for the router, which is the same as for the previous example.
The router is connected to the host via Token Ring. The control point name of the host is BUDDY; its Token Ring MAC address is 4000.0200.0448.
The host is configured as a Subarea Node (APPN LEN); if a host is configured as an APPN Network Node, the snasw location statements are unnecessary.
Figure 8 shows a CTRC configuration for communication with DB2 and CICS.
Figure 8 CTRC Configuration for Communication with DB2 and CICS
VTAM Partner PU and LU Definition
VTAM APPLID for DB2
VTAM APPLID for CICS
Cisco IOS Configuration
CTRC Servers with IP Addresses, Routes, and Multi-Valued Destinations Configuration Example (CICS)
Figure 9 shows a CTRC configuration that includes multiple CTRC servers, routes, default and non-default ports, and one multi-valued CTRC destination.
Figure 9 CTRC Configuration with IP Addresses, Routes, and Multiple CICS Destinations
In Figure 9, a single router is configured to run three CTRC servers for communication with CICS. These txconn servers are shown as CTRC server A, CTRC server C, and CTRC server D. Server A listens on the default port, 1435, for all of the router's IP addresses. Server C listens on port 1436 for IP address 191.9.200.8. Server D listens on port 1436 for IP address 191.9.200.37.
Server A is configured to communicate with two logical destinations. If a client communication has the value of TEST for its transaction ID (TRANID), server A sends it to logical Destination B. This is a multi-valued destination that allows communication with two CICS systems, system B (with RLU B and mode B) and system X (with RLU X and mode X). Transactions are allocated to these two destination systems on a round-robin basis.
If a client communication for server A does not have a value of TEST for TRANID, server A sends it to Destination A, which corresponds to CICS system A (with RLU A and mode A).
Server C is also configured to communicate with two logical destinations. If server C receives a client communication that has the value of TEST2 for its transaction ID, server C sends it to logical Destination D, which corresponds to CICS system D (with RLU D and mode D). Server C sends client communications with other transaction IDs to logical Destination C (CICS system C, with RLU C and mode C).
Server D is configured to send client communications to logical Destination D. This example illustrates the following CTRC configuration principles:
- One router can run multiple CTRC txconn servers.
- One txconn server can communicate with multiple logical destinations.
- One CTRC logical destination can correspond to multiple CICS destination systems.
- More than one txconn server can use a single port number, provided that each server listens on a different IP address.
- More than one txconn server can direct traffic to a single logical destination.
Command Reference
This section documents all non-debug commands used with the CTRC feature. Some of these commands were previously used with the CDBC feature, which CTRC replaces. Other commands are new with the introduction of CTRC.
- clear dbconn connection
- clear txconn connection
- clear txconn statistics
- clear txconn transaction
- dbconn license
- dbconn pem
- dbconn ping
- dbconn server
- dbconn tcpserver
- show dbconn connection
- show dbconn license
- show dbconn ports
- show dbconn server
- show txconn connection
- show txconn destination
- show txconn license
- show txconn route
- show txconn server
- show txconn statistics
- show txconn transaction
- txconn destination
- txconn license
- txconn ping
- txconn route
- txconn server
In Cisco IOS Release 12.0(1)T or later, you can search and filter the output for show and more commands. This functionality is useful when you need to sort through large amounts of output, or if you want to exclude output that you do not need to see.
To use this functionality, enter a show or more command followed by the "pipe" character (|), one of the keywords begin, include, or exclude, and an expression that you want to search or filter on:
command | {begin | include | exclude} regular-expression
Following is an example of the show atm vc command in which you want the command output to begin with the first line where the expression "PeakRate" appears:
For more information on the search and filter functionality, refer to the Cisco IOS Release 12.0(1)T feature module titled CLI String Search.
clear dbconn connection
To break a client connection to DB2, use the clear dbconn connection privileged EXEC command.
- clear dbconn connection connection-id
Syntax Description
Defaults
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following example shows the client connection 786A7C being cleared:
Related Commands
| Command | Description |
clear txconn connection
To clear a CTRC connection to a CICS client and all associated transactions, use the clear txconn connection privileged EXEC command.
- clear txconn connection connection-id
Syntax Description
Defaults
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following example clears the specified CICS client connection number 62146088 and all its transactions:
Related Commands
| Command | Description |
clear txconn statistics
To clear a specified CTRC statistic concerning communications with CICS, or to clear all such statistics, use the clear txconn statistics privileged EXEC command.
- clear txconn statistics {allocatetime | clientreceived | clientsent | clientturnaround | every | hostreceived | hostresponse | hostsent | maxconnections | maxtransactions | totalconnections | totaltransactions}
Syntax Description
Defaults
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following example clears the stored statistics for the number of bytes the current router has received from CICS clients:
Related Commands
| Command | Description |
|
Displays statistics related to CTRC communications with CICS. |
clear txconn transaction
To terminate a specified CICS transaction, use the clear txconn transaction privileged EXEC command. This command terminates the conversation with the host and returns DEALLOC_ABEND_PROG to the client.
- clear txconn transaction transaction-id
Syntax Description
Defaults
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following example clears the CICS transaction number 621FC8E0
Related Commands
| Command | Description |
dbconn license
To configure client licenses for CTRC connections to DB2 or CICS, use the dbconn license global configuration command. To remove the licenses, use the no form of this command.
- dbconn license license-key [connections licensed-connections] [expiration-date yyyymmdd]
no dbconn license
Syntax Description
Defaults
If the number of licensed connections is not specified, the license key must be generated for an unlimited number of licensed connections. If the expiration date is not specified, the license key must be permanent.
Command Modes
Command History
| Release | Modification |
|---|---|
Usage Guidelines
Licenses are required for all CTRC installations. For testing and evaluation purposes, unlicensed CTRC installations allow you to establish two connections to DB2 or CICS. Licenses are shared between CTRC connections to DB2 and CTRC connections to CICS. If you have already configured licenses for CTRC connections to CICS, you do not need to configure licenses for DB2, and vice versa.
Examples
The following example shows a permanent CTRC license for unlimited connections being configured:
Related Commands
dbconn pem
To configure password expiration management (PEM) support for connections to DB2, use the dbconn pem global configuration command. To remove PEM support, use the no form of this command.
- dbconn pem server server-name rlu rlu-name mode mode-name [tpname tp-name]
no dbconn pem server server-name
Syntax Description
Defaults
If tp-name is not specified, the default value is \x06301 (0x06F3F0F1 in EBCDIC).
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following example shows the configuration of PEM support:
Related Commands
| Command | Description |
|
Displays information about CTRC servers for DB2 communications |
dbconn ping
To determine whether or not CTRC servers are successfully connecting to DB2 host databases, use the dbconn ping EXEC command.
- dbconn ping server-name [user user-id] [password password] [rdbname rdbname]
Syntax Description
Defaults
If no user ID is specified, the ping connection is made without APPC security. The DB2 system's security settings determine whether or not the ping can succeed.
If no rdbname is specified, the relational database name configured for the server is used.
Command Modes
Command History
| Release | Modification |
|---|---|
Usage Guidelines
This command can be used for CTRC servers that communicate with DB2 over either SNA or TCP/IP (dbconn servers and dbconn tcpservers).
Examples
The following example shows an attempt to verify the connection to the default database for the CTRC server canopus:
Related Commands
| Command | Description |
|
Displays information about a CTRC server that communicates with DB2. |
|
|
Tests connectivity for SNA Switching Services by initiating an APPC session with a specified destination. |
dbconn server
To configure a CTRC server for communications to DB2, use the dbconn server global configuration command. To disable the server and remove its configuration, use the no form of this command.
- dbconn server server-name [ipaddress ip-address] [port port-number] [rdbname rdbname] [rlu remote-lu] [mode mode] [tpname tp-name] [idle-timeout minutes]
[window-size bytes]
no dbconn server server-name
Syntax Description
Defaults
If you do not specify an IP address, the current server can handle DB2 connectivity requests sent to any IP address on the local router.
If you do not specify a port number, the current server uses the default value of 446.
If you do not specify an rdbname, the server is configured to serve any remote database.
If you do not specify a remote LU, the default is the configured server name which is set to uppercase and truncated to eight characters. An RLU need not be qualified with a NETID. If you omit the NET ID, the NET ID of the router's SNA Switching Services control point is used to fully qualify the LU name.
If you do not specify an APPC mode, the default value is #INTER. If you specify a mode that does not already exist, CTRC will create it.
If you do not specify an APPC transaction program name, the default value is the architected DRDA TP name \x076DB.
If you do not specify an idle timeout, client connections can continue regardless of how long they have been idle.
If you do not specify a TCP receive window size, the default value is 4 K (4096 bytes).
Command Modes
Command History
| Release | Modification |
|---|---|
Usage Guidelines
You can configure more than one CTRC server per router for communications with DB2 or CICS. There is no limit on the number of CTRC servers. For each DB2 database system in your network, you can configure a CTRC server in the router configuration. CTRC dbconn servers that are configured on the same router can share a port. CTRC txconn servers should use a different port.
Examples
The following example shows the configuration of a CTRC server that will communicate with DB2:
Related Commands
| Command | Description |
|
Displays information about a CTRC server for DB2 communications. |
|
|
Displays information about ports used for CTRC server communications to DB2. |
|
dbconn tcpserver
To configure a CTRC server to communicate with IP-enabled DB2 databases, use the dbconn tcpserver global configuration command. To disable such a server and remove its configuration, use the no form of this command.
- dbconn tcpserver server-name [ip ip-address] [port port-num] [rdbname rdbname]
remote-ip remote-ip-address [remote-port remote-port] [idle-timeout time-in-minutes]
[window-size size-in-bytes] - no dbconn tcpserver server-name
Syntax Description
Defaults
If you do not specify an IP address for the tcpserver, it can receive requests on any IP address configured for the router.
If you do not specify a port for the tcpserver, the default port is 446.
If you do not specify a remote database name for the DB2 system, the tcpserver can communicate with any rdbname.
If you do not specify a port for the remote DB2 system, the tcpserver uses the default value of 446.
If you do not specify an idle timeout period, the default value is zero for no timeout.
If you do not specify a TCP/IP receive window size, the default value is 4096 bytes (4 K).
Command Modes
Command History
| Release | Modification |
|---|---|
Usage Guidelines
Configure a separate tcpserver for each DB2 system IP address. A dbconn server and a dbconn tcpserver can share the same port.
Examples
The following example shows the configuration of a tcpserver:
Related Commands
show dbconn connection
To display the status of CTRC connections to DB2, use the show dbconn connection EXEC command.
- show dbconn connection [connection-id | server server-name | user user-id |
rdbname rdb-name]
Syntax Description
|
(Optional) Displays connection information for specified server. |
|
Defaults
If you do not specify any arguments, this command displays information for all CTRC connections to DB2 on the current router.
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following is sample output from the show dbconn connection command:
The following is sample output from the show dbconn connection command for a specified connection:
Table 1 describes significant fields shown in the display.
Related Commands
show dbconn license
To display the status of CTRC licenses for DB2 communications, use the show dbconn license EXEC command.
- show dbconn license
Syntax Description
This command has no arguments or keywords
Defaults
Command Modes
Command History
| Release | Modification |
|---|---|
Usage Guidelines
This command produces the same results as show txconn license because licenses are shared.
Examples
The following is sample output from the show dbconn license command for a router that is using a temporary license key:
Related Commands
show dbconn ports
To display information about ports that CTRC is using for communications to DB2, use the show dbconn ports EXEC command.
- show dbconn ports
Syntax Description
This command has no arguments or keywords.
Defaults
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following is sample output from the show dbconn ports command:
Table 2 describes significant fields shown in the display.
| Field | Description |
|---|---|
Related Commands
show dbconn server
To display information about CTRC servers configured for DB2 communications, use the show dbconn server EXEC command.
- show dbconn server [server-name]
Syntax Description
|
(Optional) Specific server for which information should be displayed. When omitted, this command displays information for all CTRC servers configured for DB2 communications on the current router. |
Defaults
If no server name is specified, this command displays information for all CTRC servers configured for DB2 communications on the current router.
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following is sample output from the show dbconn server command:
The following is sample output from the show dbconn server command where the database server BUDDY is specified:
Table 3 describes significant fields shown in the display.
Related Commands
| Command | Description |
|
Displays information about CTRC ports used for DB2 communications. |
show txconn connection
To display a list of all of the router's CTRC connections to CICS clients, a list of a specified CTRC server's connections to CICS clients, or detailed status information for a specific CTRC connection to a CICS client, use the show txconn connection EXEC command.
- show txconn connection [connection-id | server server-name]
Syntax Description
|
(Optional) Specifies a CTRC connection to a CICS client for which to display detailed status information. |
|
|
(Optional) Specifies a CTRC server for which to list connections to CICS clients. |
Defaults
If neither connection-id nor server-name are specified, a list of all of the current router's CTRC connections to CICS clients is displayed.
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following example displays information about a CICS client connections for the current router:
The following example displays information about a specified CICS client connection:
Table 4 describes significant fields shown in the display.
Related Commands
| Command | Description |
|
Clears a specific CTRC connection to a CICS client, along with all that connection's transactions. |
|
show txconn destination
To display a list of all of the current router's CICS destinations for CTRC, or to display detailed status information for a specified CTRC CICS destination, use the show txconn destination EXEC command.
- show txconn destination [destination-name]
Syntax Description
|
(Optional) CTRC destination for which to display detailed status information. A destination is defined by a unique remote LU and mode pair. |
Defaults
If destination-name is omitted, displays a list of all CTRC destinations for the current router.
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following examples show the CTRC destinations for CICS communications that are available on the current router and information specifically about the destination GEN:
The HITS column displays the number of times the router has routed transactions or pings to each destination since the last time the router was started up.
Related Commands
| Command | Description |
show txconn license
To show the status of licenses used for CTRC, use the show txconn license EXEC command.
- show txconn license
Syntax Description
This command has no arguments or keywords.
Defaults
Command Modes
Command History
| Release | Modification |
|---|---|
Usage Guidelines
This command produces the same result as the show dbconn license command because CTRC licenses are shared between DB2 connections and CICS conversations.
Examples
The following example shows license information for CICS communications being displayed on the current router:
Related Commands
show txconn route
To display a list of all CTRC routes defined for specified CICS transaction IDs, or to display a particular CTRC server's routes to CICS, use the show txconn route EXEC command.
- show txconn route [server server-name]
Syntax Description
|
(Optional) Server for which you wish to display routing information. If not specified, a list of all CICS communications routes for CTRC servers on the current router is displayed. |
Defaults
If server-name is not specified, a list of all CICS communications routes for CTRC servers on the current router is displayed.
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following examples show information about all the CTRC routes to CICS that are available on the current router and information about the route for CTRC server CICSB&C. An asterisk (*) in the SERVER column indicates a global route that is used by all txconn servers on the router. An asterisk in the TRANID column indicates the default route for the listed txconn server.
Related Commands
| Command | Description |
|
Configures CTRC routes to CICS for specified transaction IDs. |
show txconn server
To display information about the current router's CTRC servers for CICS communications, or to display detailed status information for a single CTRC server, use the show txconn server EXEC command.
- show txconn server [server-name]
Syntax Description
|
(Optional) CTRC server for which to display detailed status information. When omitted, a list of CTRC servers is displayed. |
Defaults
When server-name is not specified, a list of the current router's CTRC servers that communicate with CICS is displayed.
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following examples show summary information about the CTRC servers for CICS communications that are available on the current router and more detailed information about the CTRC server CICSB:
Table 5 describes significant fields shown in the display.
Related Commands
| Command | Description |
show txconn statistics
To display information about the current router's CTRC communications with CICS, use the show txconn statistics EXEC command.
- show txconn statistics [kind histogram | kind summary] name {activeconnections | activetransactions | allocatetime | clientreceived | clientsent | clientturnaround | dump | hostreceived | hostresponse | hostsent | latency | maxconnections | maxtransactions | totalconnections | totaltransactions}
Syntax Description
Defaults
If the kind of statistics display is not specified, summary is used.
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following examples show histogram and summary displays of the clientreceived statistic.
Related Commands
show txconn transaction
To display a list of all the current router's CTRC transactions with CICS, a specified CTRC server's transactions, or a specified CICS client connection's transactions, use the show txconn transaction EXEC command.
- show txconn transaction [server server-name | connection connection-id | transaction-id]
Syntax Description
Defaults
If no arguments are specified, all the CICS transactions for the current router are listed.
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following two examples display general information about CICS transactions being handled by the current router and detailed information about a specified CICS transaction, respectively:
Table 6 describes significant fields shown in the display.
Related Commands
| Command | Description |
|
Displays information about CTRC connections to CICS clients. |
|
|
Displays information about CTRC servers that communicate with CICS. |
txconn destination
To configure a CTRC destination, use the txconn destination global configuration command. To remove configuration for a txconn destination, use the no form of this command.
- txconn destination destination-name rlu rlu-name mode mode-name
no txconn destination destination-name [rlu rlu-name mode mode-name]
Syntax Description
Defaults
No defaults exist for the txconn destination command. However, the remote LU name of the host and the APPC mode name are optional for the no form of the command. If you omit them, CTRC removes the configuration for all routing targets defined for the destination. If you use rlu rlu-name mode mode-name to specify a particular routing target within a destination that has multiple targets, the configuration is removed only for the specified target.
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following example shows the CTRC destination newdest being defined on the current router:
A second pair of rlu and mode values could be assigned to this same logical destination, to allow load sharing between the two destination CICS systems:
Related Commands
| Command | Description |
|
Displays information about predefined SNA Switching Services modes. |
|
txconn license
To license a Cisco router for CTRC communications with CICS or DB2, use the txconn license global configuration command. To remove the license, use the no form of this command.
- txconn license license-key [connections licensed-connections] [expiration-date yyyymmdd]
no txconn license
Syntax Description
Defaults
If the number of licensed connections is not specified, the license key must be generated for an unlimited number of licensed connections. If the expiration date is not specified, the license key must be permanent.
Command Modes
Command History
| Release | Modification |
|---|---|
Usage Guidelines
Licenses are required for all CTRC installations. Within CTRC, a common pool of node-linked licenses is used for communications with both DB2 and CICS. Therefore, if you have already configured licenses for CTRC connections to DB2, you do not need to configure licenses for CICS. The txconn license command provides exactly the same functionality as dbconn license.
For testing and evaluation purposes, unlicensed CTRC installations allow you to establish two connections to DB2 or two conversations with CICS.
Examples
The following example shows a CTRC license being configured for communications with CICS:
Related Commands
txconn ping
To test communications between the CTRC router and a CTRC destination (a host defined by a pair of RLU and mode values), use the txconn ping EXEC command.
- txconn ping destination-name
Syntax Description
Defaults
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following example shows communications being tested between the current router and the CTRC destination GEN. Note that GEN is a destination that has two RLU-Mode pairs defined, and that the txconn ping command automatically tests connections to both:
Elapsed time is noted in hours, minutes, seconds, and milliseconds.
Related Commands
| Command | Description |
txconn route
To configure a CTRC route that will transmit specified transactions to a particular CICS destination, use the txconn route global configuration command. To remove the configuration of a CTRC route, use the no form of this command.
- txconn route [server server-name] tranid transaction-id destination destination-name
no txconn route [server server-name] tranid transaction-id
Syntax Description
Defaults
Command Modes
Command History
| Release | Modification |
|---|---|
Examples
The following example shows a CTRC route to destination GEN being defined on the current router for transaction ID PNG1:
Related Commands
| Command | Description |
txconn server
To configure a CTRC server for communications with CICS, use the txconn server global configuration command. To disable a CTRC server, use the no form of this command.
- txconn server server-name destination destination-name [ipaddress ip-address]
[port port-number] [client-timeout minutes] [host-timeout minutes] [window-size bytes]
no txconn server server-name
Syntax Description
Defaults
If the CTRC server's IP address is not configured, the server accepts connections for any IP address that is configured for the router.
If the port number is not configured, the server listens on port 1435.
If you do not specify a client timeout, CICS client connections can continue regardless of how long they have been idle.
If you do not specify a host timeout, host connections can continue regardless of how long they have been idle.
If you do not specify a TCP/IP window size, the default value is 4096 bytes (4 K).
Command Modes
Command History
| Release | Modification |
|---|---|
Usage Guidelines
You can configure more than one CTRC server per router for communications with DB2 or CICS. There is no limit on the number of CTRC servers. However, be sure that CTRC txconn servers and CTRC dbconn servers are configured to use different ports, and that each txconn server is configured to use a unique combination of port number and IP address, or a unique port number with no IP address.
Examples
The following example shows the CTRC server newsvr being defined on the current router:
Related Commands
| Command | Description |
|
Displays information about CTRC servers that communicate with CICS. |
Debug Commands
This section documents debugging commands used with the CTRC feature. Some of these commands were previously used with the Cisco Database Connection feature (CDBC), which CTRC replaces. Other commands are new with the introduction of CTRC.
debug dbconn all
Use the debug dbconn all privileged EXEC command to turn on all debug flags for CTRC communications with DB2. These flags include appc, config, drda, event, and tcp. Use the no form of this command to disable all debugging output.
Syntax Description
This command has no arguments or keywords.
Defaults
By default, debugging is not enabled for the dbconn subsystem.
Command History
| Release | Modification |
|---|---|
Examples
See the examples provided for the debug dbconn appc, debug dbconn config, debug dbconn drda, debug dbconn event, and debug dbconn tcp commands.
Related Commands
debug dbconn appc
Use the debug dbconn privileged EXEC command to display APPC-related trace or error messages for communications with DB2. Use the no form of this command to disable debugging output.
Syntax Description
This command has no arguments or keywords.
Defaults
By default, debugging is not enabled for the dbconn subsystem.
Command History
| Release | Modification |
|---|---|
Examples
The following example shows APPC debugging output using the debug dbconn appc command:
Related Commands
debug dbconn config
Use the debug dbconn config privileged EXEC command to display trace or error messages for CTRC configuration and control blocks for DB2 communications. Use the no form of this command to disable debugging output.
Syntax Description
This command has no arguments or keywords.
Defaults
By default, debugging is not enabled for the dbconn subsystem.
Command History
| Release | Modification |
|---|---|
Examples
The following example shows output from the debug dbconn config command when SNA Switching Services is not available:
Related Commands
debug dbconn drda
Use the debug dbconn drda privileged EXEC command to display error messages and stream traces for DRDA. Use the no form of this command to disable debugging output.
Syntax Description
This command has no arguments or keywords.
Defaults
By default, debugging is not enabled for the dbconn subsystem.
Command History
| Release | Modification |
|---|---|
Examples
The following example displays output from the debug dbconn drda command:
Related Commands
debug dbconn event
Use the debug dbconn event privileged EXEC command to display trace or error messages for CTRC events related to DB2 communications. Use the no form of this command to disable debugging output.
Syntax Description
This command has no arguments or keywords.
Defaults
By default, debugging is not enabled for the dbconn subsystem.
Command History
| Release | Modification |
|---|---|
Examples
The following examples display output from the debug dbconn event command in a variety of situations. A normal trace for the debug dbconn event displays as follows:
If the following messages are displayed, contact Cisco technical support personnel:
Related Commands
debug dbconn tcp
Use the debug dbconn tcp privileged EXEC command to display error messages and traces for TCP. Use the no form of this command to disable debugging output.
Syntax Description
This command has no arguments or keywords.
Defaults
By default, debugging is not enabled for the dbconn subsystem.
Command History
| Release | Modification |
|---|---|
Examples
The following example displays output from the debug dbconn tcp command:
Related Commands
debug txconn all
Use the debug txconn all privileged EXEC command to turn on all debug flags for CTRC communications with CICS. These flags include appc, config, data, event, tcp, and timer. Use the no form of this command to disable all debugging output.
Syntax Description
This command has no arguments or keywords.
Defaults
By default, debugging is not enabled for the txconn subsystem.
Command History
| Release | Modification |
|---|---|
Examples
The following example shows the immediate output of the debug txconn all command. For examples of specific debugging messages, see the examples provided for the debug txconn appc, debug txconn config, debug txconn data, debug txconn event, debug txconn tcp, and debug txconn timer commands.
Related Commands
debug txconn appc
Use the debug txconn privileged EXEC command to display APPC-related trace or error messages for communications with CICS. Use the no form of this command to disable debugging output.
- [no] debug txconn appc
Syntax Description
This command has no arguments or keywords.
Defaults
By default, debugging is not enabled for the txconn subsystem.
Command History
| Release | Modification |
|---|---|
Examples
The following example shows APPC debugging output from the debug txconn appc command:









