|
|
This chapter explains the function and syntax of the Cisco Transaction Connection commands. For more information about defaults and usage guidelines, see the corresponding chapter of the Cisco IOS Bridging and IBM Networking Command Reference, Volume 2, Release 12.1.
To break a client connection to DB2, use the clear dbconn connection privileged EXEC command.
clear dbconn connection connection-id
Syntax Description
connection-id Identification number for client connection to DB2.
To clear all CTRC statistics concerning communications with DB2, use the clear dbconn statistics privileged EXEC command.
clear dbconn statistics {chains | clientturnaround | connectionsdown | connectionsup | dump | hostreceived | hostresponse | hostsent | latency | maxconnections}
Syntax Description
chains Clears the number of command chains created between CTRC and DB2. clientturnaround Clears statistics for average time from receiving a DB2 client communication to sending that client a response. connectionsdown Clears statistics for number of connections down between CTRC and DB2. connectionsup Clears statistics for number of connections up between CTRC and DB2. dump Clears the complete statistics dump between CTRC and DB2. hostreceived Clears statistics for number of bytes received from DB2 hosts. hostresponse Clears statistics for average DB2 host response time. hostsent Clears statistics for number of bytes sent to DB2 hosts. latency Clears the statistic for average server latency. maxconnections Clears statistics for maximum number of concurrent connections to CICS clients.
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
connection-id CICS connection identification number.
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
allocatetime Clears statistics for average time spent waiting for APPC allocate operation to complete. clientreceived Clears statistics for number of bytes received from CICS clients. clientsent Clears statistics for number of bytes sent to CICS clients. clientturnaround Clears statistics for average time from receiving a CICS client communication to sending that client a response. every Clears every statistic concerning the current router's CTRC communications with CICS. hostreceived Clears statistics for number of bytes received from CICS hosts. hostresponse Clears statistics for average CICS host response time. hostsent Clears statistics for number of bytes sent to CICS hosts. maxconnections Clears statistics for maximum number of concurrent connections to CICS clients. maxtransactions Clears statistics for maximum number of concurrent transactions with CICS hosts. totalconnections Clears statistics for total number of connections to CICS clients. totaltransactions Clears statistics for total number of CICS transactions processed.
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
transaction-id ID of the CICS transaction to be cleared.
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]
Syntax Description
license-key License key obtained from your Cisco representative. The license determines the maximum number of CICS conversations or connections to DB2 via a Cisco router configured with CTRC. The license key is a 32-character hexadecimal string. It is not case sensitive, but it is linked to a specific router. When you request your license key, you must supply your Cisco representative with the SNA Switching Services cpname for the router. Use the show config | include cpname command to view the cpname. connections licensed-connections (Optional) Number of licensed connections. If number of connections is omitted, the number of licensed connections must be unlimited. expiration-date yyyymmdd (Optional) Date when a temporary license key expires, in yyyymmdd format, where yyyy is the year expressed in four digits, mm is the month expressed in two digits, and dd is the date expressed in two digits. If the date is omitted, the license key must be permanent.
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]
Syntax Description
server server-name Name of the CTRC server whose password management you are configuring. rlu rlu-name Host remote LU name the server connects to when performing password management. This RLU ordinarily differs from the RLU values used in dbconn server or txconn destination commands. It may or may not be fully qualified. mode mode-name APPC stack mode the server uses when performing password management. tpname tp-name (Optional) Name of the PEM transaction program on the host (the APPC Signon transaction program, an architected APPC TP). The default value is \x06301 (0x06F3F0F1 in EBCDIC).
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
server-name Name of the CTRC server for DB2 communications. user user-id (Optional) User ID used to connect to the DB2 system. password password (Optional) Password used to connect to the DB2 system. rdbname rdbname (Optional) Name of the relational database to be contacted.
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] [wlm {off | on}]
Syntax Description
server-name Name of the CTRC server. Server names are user-defined strings up to 16 characters. ipaddress ip-address (Optional) IP address used by the CTRC server to receive a connection requesting DB2 communications. When a connection arrives, this IP address is used for matching and selecting the server from multiple configured servers. 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. port port-number (Optional) Port used to listen for connections requesting DB2 communications. If no port is specified, the default is 446. rdbname rdbname (Optional) DB2 remote database name on the host. When a connection arrives, this name is used to identify and select the appropriate server from multiple configured servers. The string is used to match the RDB name sent by the client in the DRDA data stream at connect time. The default RDB name is an asterisk (*), which indicates that this CTRC server serves any remote database. rlu remote-lu (Optional) APPC remote LU used to allocate the connection to the DB2 system. An example is NETA.S103B345. If no remote LU is specified, 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. mode mode (Optional) APPC mode used to allocate the conversation to the DB2 system. If no mode is specified, the default is #INTER. Performance might improve if you choose a mode such as IBMRDB. If you specify a mode that does not already exist, CTRC will create it. tpname tp-name (Optional) APPC remote transaction program name used to allocate the conversation to the DB2 system. If no TP name is specified the default is the architected DRDA TP name \x076DB. idle-timeout idle-timeout (Optional) Time, in minutes, to wait for an idle client. If there is no activity from the client for this amount of time, the connection is forcibly broken. The time spent in waiting for a response from the DB2 system is not counted, only idle time in between client requests is counted. The maximum is 1440 minutes (24 hours). If no idle timeout is specified, the default is 0 (zero) for no timeout. window-size bytes (Optional) TCP/IP receive window size. If no window size is specified, the default is 4 K (4096 bytes). wlm {off | on} (Optional) Enables or disables Workload Manager load balancing. The default is "inactive-enabled".
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]
Syntax Description
server-name Name of the CTRC server being configured for TCP passthrough communications with DB2. ip ip-address (Optional) IP address for the CTRC tcpserver process being configured. If not specified, the tcpserver receives client requests on all IP addresses configured for the router. port port-num (Optional) Port the tcpserver listens on for client requests. The default value is 446. A dbconn server and a dbconn tcpserver can share the same port. rdbname rdbname (Optional) DB2 remote database name on the host. When a connection arrives, this name is used to identify and select the appropriate tcpserver from multiple configured tcpservers. The string is used to match the RDB name sent by the client in the DRDA data stream at connect time. The default RDB name is an asterisk (*) which indicates that this CTRC tcpserver serves any remote database. remote-ip remote-ip-address IP address for the host where DB2 resides. remote-port remote-port (Optional) Host port that listens for tcpserver communications from the router. The default value is 446. idle-timeout time-in-minutes (Optional) Time in minutes to wait for an idle client. If there is no activity from the client for this amount of time, the connection is forcibly broken. The time spent in waiting for a response from the DB2 system is not counted, only idle time in between client requests is counted. The maximum time is 1440 minutes (24 hours). If no idle timeout is specified, the default is 0 (zero) for no timeout. window-size size-in-bytes (Optional) This value is used for the TCP/IP receive window size. If no window size is specified, the default is 4096 bytes (4 K).
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
connection-id (Optional) Displays the status of a specified connection. server server-name (Optional) Displays connection information for specified server. user user-id (Optional) Displays connections for specified user ID. rdbname rdb-name (Optional) Displays connections for specified RDB name.
To display the status of CTRC licenses for DB2 communications, use the show dbconn license EXEC command.
show dbconn licenseSyntax Description
This command has no arguments or keywords
To display information about ports that CTRC is using for communications to DB2, use the show dbconn ports EXEC command.
show dbconn portsSyntax Description
This command has no arguments or keywords.
To display information about CTRC servers configured for DB2 communications, use the show dbconn server EXEC command.
show dbconn server [server-name]
Syntax Description
server-name (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.
To show all CTRC statistics concerning communications with DB2, use the show dbconn statistics privileged EXEC command.
show dbconn statistics {chains | clientturnaround | connectionsdown | connectionsup | dump | hostreceived | hostresponse | hostsent | latency | maxconnections}
Syntax Description
chains Shows statistics for number of chains created. clientturnaround Shows statistics for average time from receiving a DB2 client communication to sending that client a response. connectionsdown Shows statistics for number of connections finished between CTRC and DB2. connectionsup Shows statistics for number of connections created between CTRC and DB2. dump Shows a complete statistics dump. hostreceived Shows statistics for number of bytes received from DB2 hosts. hostresponse Shows statistics for average DB2 host response time. hostsent Shows statistics for number of bytes sent to DB2 hosts. latency Shows average server latency time. maxconnections Shows statistics for maximum number of concurrent connections to CICS clients.
To display information about CTRC servers configured for DB2 communications using Workload Manager, use the show dbconn wlm EXEC command.
show dbconn wlm [server-name]
Syntax Description
server-name (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.
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
connection-id (Optional) Specifies a CTRC connection to a CICS client for which to display detailed status information. server server-name (Optional) Specifies a CTRC server for which to list connections to CICS clients.
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
destination-name (Optional) CTRC destination for which to display detailed status information. A destination is defined by a unique remote LU and mode pair.
To show the status of licenses used for CTRC, use the show txconn license EXEC command.
show txconn licenseSyntax Description
This command has no arguments or keywords.
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
server server-name (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.
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
server-name (Optional) CTRC server for which to display detailed status information. When omitted, a list of CTRC servers is displayed.
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
kind histogram | kind summary (Optional) Desired format for the statistics to be displayed. Legal values are as follows: If the kind of statistics display to show is not specified, summary is used. Statistics are shown for the clock hour in progress and the preceding 24 full hours. name {activeconnections | activetransactions | allocatetime | clientreceived | clientsent | clientturnaround | dump | hostreceived | hostresponse | hostsent | latency | maxconnections | maxtransactions | totalconnections | totaltransactions} Specific statistic to display. Legal values are as follows:
If the kind of statistics display is not specified, summary is used.
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
server server-name (Optional) Specifies a CTRC server for which to display a list of transactions. connection connection-id (Optional) Specifies a CICS client connection to CTRC for which to display a list of transactions. transaction-id (Optional) Specifies an individual transaction for which to display detailed status information.
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
Syntax Description
destination-name Name of the destination being defined or added to. This name is used in the route configuration command to identify the destination for the route. If the destination does not exist, it is created; if it exists, the rlu and mode parameters are added as an additional routing target for this destination. When a destination contains multiple routing targets, it is like configuring a cluster where the various targets are chosen on a round-robin basis for load balancing. rlu rlu-name Remote LU name on the host. This parameter defines to which remote LU the server will connect when using this destination. A remote LU corresponds directly to a CICS region. The value you enter here should match your VTAM APPLID. mode mode-name Name of the APPC mode. This parameter defines which mode the server will use for its APPC connections when using this destination. If the mode you specify does not already exist, CTRC will create it.
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]
Syntax Description
license-key License key obtained from your Cisco representative. The license determines the maximum number of DB2 connections or conversations with CICS possible via a Cisco router configured with CTRC. It is not case sensitive, but it is linked to a specific router. When you request your license key, you must supply your Cisco representative with the SNA Switching Services cpname for the router. Use the show config | include cpname command to view the cpname. connections licensed-connections (Optional) Number of licensed connections. If the number of connections is omitted, the number of licensed connections must be unlimited. expiration-date yyyymmdd (Optional) Date when a temporary license key expires, in yyyymmdd format, where yyyy is the year expressed in four digits, mm is the month expressed in two digits, and dd is the date expressed in two digits. If the date is omitted, the license key must be permanent.
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
destination-name Specifies the CICS system for which to test communications.
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
Syntax Description
server server-name (Optional) Name of the CTRC server to which this route applies. If omitted, this route is applied to all CTRC servers on the current router that are configured for communication with CICS. tranid transaction-id CICS transaction ID (a TP name). When the server processes a transaction that uses this transaction ID, the server routes the transaction using this route entry. destination destination-name Name of the destination to which the transaction is routed.
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 access [cics] [ccsid number] [comti] [ipaddress ip-address] [port port-number] [client-timeout minutes] [host-timeout minutes] [window-size bytes] [fold {on|off}]
Syntax Description
server-name Name of the server being defined. This name is used in other commands to identify the server being administered. access Name of server for IBM CICS or Microsoft CommTi client. If none is specified, default is CICS. cics (Optional) Server for IBM CICS client. This is the default when none is entered. ccsid number (Optional) The Coded Character Set Identifier. This is used for Tx Series Clients. comti (Optional) Server for Microsoft CommTI client destination destination-name Name of the server's default destination. Any transactions whose tranid is not associated with a particular route will be routed to this destination. The destination must already be defined when configuring the server. ipaddress ip-address (Optional) TCP/IP network address for which the server accepts connections. If this parameter is omitted, the server accepts connections for any IP address, like a wildcard address. If multiple servers are configured to listen on the same port, they must each specify a different IP address. If a server is configured with the IP address omitted, no other servers may listen on the same port. So, on a given port, you may configure either 1 wildcard IP address server, or n address-specific servers, where n is 1 or more. port port-number (Optional) TCP/IP port number on which the server listens. If no IP address is specified, only one server can listen on a port. Multiple servers can use the same port number if the combination of IP address and port number is unique to each server. If the port number is omitted, the server listens on port 1435. client-timeout minutes (Optional) Number of minutes of client connection inactivity after which the server decides the client has gone away. When this happens the server closes the client connection. If no client timeout is specified, the default is 0 (zero) for no timeout. host-timeout minutes (Optional) Number of minutes of host connection inactivity after which the server decides the host has gone away. When this happens the server closes the host connection. If no host timeout is specified, the default is 0 (zero) for no timeout. window-size bytes (Optional) Size, in bytes, of the TCP/IP window for incoming CICS client connections. If no window size is specified, the default is 4096 bytes (4 K). fold {on | off} (Optional) Enables/disables the fold program. Default is on. CTRC folds the CICS program name to uppercase.
![]()
![]()
![]()
![]()
![]()
![]()
![]()
Posted: Wed Jul 26 12:35:59 PDT 2000
Copyright 1989-2000©Cisco Systems Inc.