Horizon TCP/IP: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Created page with "==Overview== Model 204 TCP/IP (Horizon) provides a <i>connection</i> between Model 204 and PCs and workstations over a TCP/IP network. This connection transports requests and...")
 
 
(15 intermediate revisions by one other user not shown)
Line 4: Line 4:


===Preparing the environment===
===Preparing the environment===
To implement the Model 204 TCP/IP connection, prepare the Model 204 Online environment by defining TCP/IP SQL and RCL threads and adjusting buffer sizes. For information about preparation of the Model 204 Online, see [[Specifying the runtime environment]].
To implement the Model 204 TCP/IP connection, prepare the Model 204 Online environment by defining TCP/IP SQL and RCL threads and adjusting buffer sizes. For information about preparation of the Model 204 Online, see [[Runtime environment for SQL processing]].
<p>In addition, you must specify the Model 204 TCP/IP link, processgroup, and process entities with Model 204 DEFINE commands. The procedures for creating these definitions are provided in this chapter.</p>
<p>In addition, you must specify the Model 204 TCP/IP link, processgroup, and process entities with Model 204 DEFINE commands. The procedures for creating these definitions are provided in this chapter.</p>


===Transparent operation===
===Transparent operation===
Once the network is properly defined, the operation of Model 204 TCP/IP is transparent to Connect* users. For example, the execution of socket verbs is handled internally.
Once the network is properly defined, the operation of Model 204 TCP/IP is transparent to Connect<span class="superstar">&#9733;</span> users. For example, the execution of socket verbs is handled internally.


==Connecting to Model 204 TCP/IP (Horizon)==
==Connecting to Model 204 TCP/IP (Horizon)==
The following figure shows a Model 204 TCP/IP link with three connections to Connect* clients. Note the interrelated --process, processgroup, and link--that support TCP/IP connections.</p>
The following figure shows a Model 204 TCP/IP link with three connections to Connect<span class="superstar">&#9733;</span> clients. Note the interrelated process, processgroup, and link that support TCP/IP connections.


<p class="caption">Horizon for TCP/IP connection support</p>
<p class="caption">Horizon for TCP/IP connection support</p>
Line 17: Line 17:


<p>In Model 204 TCP/IP, a conversation occurs over a connection in which the IP protocol for exchanging messages is observed. </p>
<p>In Model 204 TCP/IP, a conversation occurs over a connection in which the IP protocol for exchanging messages is observed. </p>
<p>See the DEFINE LINK command in the Rocket Model 204 documentation wiki for information about the IP protocol:</p>
<p>See the [[DEFINE_LINK_command:_Horizon_for_TCP/IP|DEFINE LINK]] command topic for information about the IP protocol.</p>
<p>
http://m204wiki.rocketsoftware.com/index.php/DEFINE_LINK_command:_Horizon_for_TCP/IP</p>
<p>
<p>
In this chapter, descriptions of Model 204 TCP/IP use <i>conversation</i>
In this chapter, descriptions of Model 204 TCP/IP use <i>conversation</i>
  and <i>connection</i> interchangeably, because a connection is dropped when a conversation ends. Model 204 TCP/IP conversation exchanges are always initiated by the Connect* for an application program. CCARSQL is always the server.</p>
  and <i>connection</i> interchangeably, because a connection is dropped when a conversation ends. Model 204 TCP/IP conversation exchanges are always initiated by the Connect<span class="superstar">&#9733;</span> for an application program. CCARSQL is always the server.</p>


====Guidelines====
====Guidelines====
Line 34: Line 32:
==DEFINE commands==
==DEFINE commands==
In Model 204 terminology, the Model 204 SQL Server is the server process, or program, that communicates through a conversation with a client partner (SQL application). The Model 204 DEFINE commands specify the physical and logical characteristics of the conversation and name the clients that can access the SQL Server.
In Model 204 terminology, the Model 204 SQL Server is the server process, or program, that communicates through a conversation with a client partner (SQL application). The Model 204 DEFINE commands specify the physical and logical characteristics of the conversation and name the clients that can access the SQL Server.
<p>The commands--DEFINE LINK, DEFINE PROCESSGROUP, and DEFINE PROCESS--are all necessary to define a Horizon for TCP/IP connection. These commands are documented in the Rocket Model 204 documentation wiki command pages:</p>
<p>The DEFINE commands &mdash; [[DEFINE LINK command: Horizon for TCP/IP|DEFINE LINK]], [[DEFINE PROCESS command: Horizon for TCP/IP and VTAM|DEFINE PROCESS]], and [[DEFINE PROCESSGROUP command: Horizon for TCP/IP|DEFINE PROCESSGROUP]] &mdash; are all necessary to define a Horizon for TCP/IP connection.</p>
<p>
http://m204wiki.rocketsoftware.com/index.php/Category:Commands</p>


===Issuing DEFINE commands===
===Issuing DEFINE commands===
The DEFINE commands are typically stored in a SOUL procedure that is invoked by the Model 204 Online job or EXEC at runtime or coded in the Online job or EXEC CCAIN stream. For example,
The DEFINE commands are typically stored in a SOUL procedure that is invoked by the Model 204 Online job or EXEC at runtime or coded in the Online job or EXEC CCAIN stream. For example,
<p class="code">
<p class="code">DEFINE PROCESS CCARSQL WITH SCOPE = SYSTEM  -
DEFINE PROCESS CCARSQL WITH SCOPE = SYSTEM  -
DATALEN = 32763 FROM = (ANY192, ANY204)</p>
DATALEN = 32763 FROM = (ANY192, ANY204)</p>
<p>The CCAIN settings defined for the SQL thread(s) are used as default settings for the RCL thread(s). They can also be issued Online from Model 204 command level by a user with system manager privileges.</p>
<p>The CCAIN settings defined for the SQL thread(s) are used as default settings for the RCL thread(s). They can also be issued Online from Model 204 command level by a user with system manager privileges.</p>
Line 47: Line 42:
===Exchanging Horizon for TCP/IP connection parameters===
===Exchanging Horizon for TCP/IP connection parameters===
The Model 204 system manager and TCP/IP system administrator must exchange or jointly determine certain parameter values required to define their connection. ion characteristics are provided by default.
The Model 204 system manager and TCP/IP system administrator must exchange or jointly determine certain parameter values required to define their connection. ion characteristics are provided by default.
<p>As summarized in [[#Model 204 TCP/IP connection parameters|Model 204 TCP/IP connection parameters]], Model 204 DEFINE command parameters must specify server and client network addresses, the server port number, and connection buffer sizes. For 32-bit * interfaces, ODBC SQL and SQLDriver function calls also specify the server's network address and port number, and might specify a Model 204 user ID and password.  </p>
<p>As summarized in the following table, Model 204 DEFINE command parameters must specify server and client network addresses, the server port number, and connection buffer sizes. For 32-bit * interfaces, ODBC SQL and SQLDriver function calls also specify the server's network address and port number, and might specify a Model 204 user ID and password.  </p>
<table>
<table>
<p class="caption">Model 204 TCP/IP connection parameters</p>
<p class="caption">Model 204 TCP/IP connection parameters</p>
<tr class="head">
<th>Value provided</th>
<th>Value provided</th>
<th>Model 204 DEFINE command parameter</th>
<th>Model 204 DEFINE command parameter</th>
<th>TCP/IP client specification</th>
<th>TCP/IP client specification</th>
</tr>
<tr>
<tr>
<td>Server node (Model 204 SQL) address</td>
<td>Server node (Model 204 SQL) address</td>
Line 59: Line 57:
<td>Host (Server) Name or IP Address parameter in ODBC, JDBC or .NET connection string</td>
<td>Host (Server) Name or IP Address parameter in ODBC, JDBC or .NET connection string</td>
</tr>
</tr>
<tr>
<tr>
<td>Server port number</td>
<td>Server port number</td>
Line 65: Line 64:
<td>Port number parameter in ODBC, JDBC or .NET connection string</td>
<td>Port number parameter in ODBC, JDBC or .NET connection string</td>
</tr>
</tr>
<tr>
<tr>
<td>Client node (TCP/IP Workstation) address</td>
<td>Client node (TCP/IP Workstation) address</td>
<td>DEFINE PROCESSGROUP REMOTEID<BR>
<td>DEFINE PROCESSGROUP REMOTEID<BR>
MASK</td>
MASK</td>
<td>
<td>N/A
</td>
</td>
</tr>
</tr>
<tr>
<tr>
<td>Model 204 user ID and password for client user (might not be required)</td>
<td>Model 204 user ID and password for client user (might not be required)</td>
Line 80: Line 81:
</tr>
</tr>
</table>
</table>
<p>For details about TCP/IP client specification, see the <p class="book">Connect* Suite Installation and Programming Guide</p>.</p>
<p>For details about TCP/IP client specification, see [[Connect* installation requirements|Connect<span class="superstar">&#9733;</span> installation requirements]].</p>


===DEFINE command interconnections===
===DEFINE command interconnections===
Specify a DEFINE command for each Horizon network entity. Each command has multiple parameters, some of which are optional. The Horizon network entities are:
Specify a DEFINE command for each Horizon network entity. Each command has multiple parameters, some of which are optional.  
 
The Horizon network entities are described in the following table.
<table>
<table>
<tr class="head">
<th>Entity</th> <th>Description</th>
</tr>
<tr>
<tr>
<td>Link</td>
<td>Link</td>
Line 93: Line 99:
<td>Points to the link (with LINK) and points to the client node (with REMOTEID and, optionally, MASK)</td>
<td>Points to the link (with LINK) and points to the client node (with REMOTEID and, optionally, MASK)</td>
</tr>
</tr>
<tr>
<tr>
<td>Process</td>
<td>Process</td>
Line 98: Line 105:
</tr>
</tr>
</table>
</table>
<p>The following figure shows the parameters with which the commands point to each other and to the client partner. Descriptions of the individual entity definitions with all their parameters are provided in previous sections of this chapter.</p>
<p>
The following figure shows the parameters with which the commands point to each other and to the client partner. Descriptions of the individual entity definitions with all their parameters are provided in previous sections of this topic.</p>


<p class="caption">Interconnecting parameters of network entity definitions </p>
<p class="caption">Interconnecting parameters of network entity definitions </p>
Line 104: Line 112:


===OPEN LINK command===
===OPEN LINK command===
After you have issued the required entity definition commands, you must issue the OPEN LINK command to enable processing.
After you have issued the required entity definition commands, you must issue the [[OPEN LINK command]] to enable processing.
<p>The OPEN LINK command prepares a port to accept connection requests. Connection requests are accepted and processed only if the address they come from matches the (masked) address in a processgroup definition that points to an open link.</p>
<p>The OPEN LINK command prepares a port to accept connection requests. Connection requests are accepted and processed only if the address they come from matches the (masked) address in a processgroup definition that points to an open link.</p>


[[Category: Networking]]
==See also==
[[Category: Model 204 SQL processing]]
{{Template:SQL connectivity topic list}}
 
[[Category: SQL connectivity]]
[[Category: Horizon]]

Latest revision as of 20:34, 24 March 2017

Overview

Model 204 TCP/IP (Horizon) provides a connection between Model 204 and PCs and workstations over a TCP/IP network. This connection transports requests and responses between the workstation clients and the Model 204 SQL Server on the mainframe.

You can use Model 204 TCP/IP (Horizon) and Windows Sockets (winsockets) to establish a client connection from a PC or workstation to the TCP/IP software on the mainframe. To use Model 204 TCP/IP (Horizon), you need installed and running on your PC or workstation an interface product that supports Windows Sockets.

Preparing the environment

To implement the Model 204 TCP/IP connection, prepare the Model 204 Online environment by defining TCP/IP SQL and RCL threads and adjusting buffer sizes. For information about preparation of the Model 204 Online, see Runtime environment for SQL processing.

In addition, you must specify the Model 204 TCP/IP link, processgroup, and process entities with Model 204 DEFINE commands. The procedures for creating these definitions are provided in this chapter.

Transparent operation

Once the network is properly defined, the operation of Model 204 TCP/IP is transparent to Connect users. For example, the execution of socket verbs is handled internally.

Connecting to Model 204 TCP/IP (Horizon)

The following figure shows a Model 204 TCP/IP link with three connections to Connect clients. Note the interrelated process, processgroup, and link that support TCP/IP connections.

Horizon for TCP/IP connection support

SQL_Connect_Guide_fig_4-1.gif

In Model 204 TCP/IP, a conversation occurs over a connection in which the IP protocol for exchanging messages is observed.

See the DEFINE LINK command topic for information about the IP protocol.

In this chapter, descriptions of Model 204 TCP/IP use conversation and connection interchangeably, because a connection is dropped when a conversation ends. Model 204 TCP/IP conversation exchanges are always initiated by the Connect for an application program. CCARSQL is always the server.

Guidelines

  • Model 204 SQL process accepts connection requests only from pre-specified TCP/IP clients.
  • Model 204 TCP/IP processgroup definition specifies the network address or addresses of those clients with whom connections are possible.
  • Model 204 link definition specifies the network address and port by which the Model 204 SQL server is known to the TCP/IP network.
  • A single Model 204 TCP/IP link can support as many as 1999 connections at a time.

DEFINE commands

In Model 204 terminology, the Model 204 SQL Server is the server process, or program, that communicates through a conversation with a client partner (SQL application). The Model 204 DEFINE commands specify the physical and logical characteristics of the conversation and name the clients that can access the SQL Server.

The DEFINE commands — DEFINE LINK, DEFINE PROCESS, and DEFINE PROCESSGROUP — are all necessary to define a Horizon for TCP/IP connection.

Issuing DEFINE commands

The DEFINE commands are typically stored in a SOUL procedure that is invoked by the Model 204 Online job or EXEC at runtime or coded in the Online job or EXEC CCAIN stream. For example,

DEFINE PROCESS CCARSQL WITH SCOPE = SYSTEM - DATALEN = 32763 FROM = (ANY192, ANY204)

The CCAIN settings defined for the SQL thread(s) are used as default settings for the RCL thread(s). They can also be issued Online from Model 204 command level by a user with system manager privileges.

Exchanging Horizon for TCP/IP connection parameters

The Model 204 system manager and TCP/IP system administrator must exchange or jointly determine certain parameter values required to define their connection. ion characteristics are provided by default.

As summarized in the following table, Model 204 DEFINE command parameters must specify server and client network addresses, the server port number, and connection buffer sizes. For 32-bit * interfaces, ODBC SQL and SQLDriver function calls also specify the server's network address and port number, and might specify a Model 204 user ID and password.

Model 204 TCP/IP connection parameters

Value provided Model 204 DEFINE command parameter TCP/IP client specification
Server node (Model 204 SQL) address DEFINE LINK
LOCALID
Host (Server) Name or IP Address parameter in ODBC, JDBC or .NET connection string
Server port number DEFINE LINK
SERVPORT
Port number parameter in ODBC, JDBC or .NET connection string
Client node (TCP/IP Workstation) address DEFINE PROCESSGROUP REMOTEID
MASK
N/A
Model 204 user ID and password for client user (might not be required) Login depends on setting of:

DEFINE PROCESSGROUP LOGIN

GUESTUSER
User ID and password in ODBC, JDBC or .NET connection string

For details about TCP/IP client specification, see Connect installation requirements.

DEFINE command interconnections

Specify a DEFINE command for each Horizon network entity. Each command has multiple parameters, some of which are optional.

The Horizon network entities are described in the following table.

Entity Description
Link Identifies the local node (with LOCALID parameter and SERVPORT parameter)
Processgroup Points to the link (with LINK) and points to the client node (with REMOTEID and, optionally, MASK)
Process Model 204 SQL process (CCARSQL) points to the processgroups (with FROM)

The following figure shows the parameters with which the commands point to each other and to the client partner. Descriptions of the individual entity definitions with all their parameters are provided in previous sections of this topic.

Interconnecting parameters of network entity definitions

OPEN LINK command

After you have issued the required entity definition commands, you must issue the OPEN LINK command to enable processing.

The OPEN LINK command prepares a port to accept connection requests. Connection requests are accepted and processed only if the address they come from matches the (masked) address in a processgroup definition that points to an open link.

See also