SQL network entities

From m204wiki
Revision as of 18:20, 11 August 2017 by JAL (talk | contribs) (restore <span class="superstar">★</span>)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Making the necessary connections

The Model 204 TCP/IP (Horizon) connections that you need to establish are described in this section:

  • Link
  • Processgroup
  • Process

Definitions that you provide for these entities set the physical and logical characteristics of network conversations. For detailed information on defining these entities, see the Rocket Model 204 documentation wiki command pages:

DEFINE LINK command: Horizon for TCP/IP

DEFINE PROCESS command: Horizon for TCP/IP and VTAM



A link represents a connection between Model 204 and a network. The link definition specifies the transport mechanism and protocol to use for communications.


A processgroup connects one or more processes to a specific link, and groups processes according to certain attributes to facilitate resource allocation. The processgroup definition also specifies the remote partner with which the processes can communicate.


The process definition associates the CCARSQL process (the Model 204 SQL process) with one or more processgroups; the processgroup(s) associate the process with one or more links.

CCARSQL always receives the SQL client's request for a conversation. This same CCARSQL process is used for all connections to the Model 204 SQL Server: one definition of CCARSQL must apply to all SQL and RCL connections.

Defining connections

If you are running SQL or RCL on a PC or workstation using 32-bit Connect, define a connection for Model 204 TCP/IP (Horizon).

For more information, see Horizon TCP/IP.

Single and multiple definitions

For Connect, specify DEFINE commands for each of the SQL network entities: link, processgroup, and process.

See the excerpt from the sample Model 204 Online job in Runtime examples.

Where to specify DEFINE commands

The DEFINE commands can be:

  • Coded in the CCAIN stream of the job or EXEC you use to bring up your Model 204 Online
  • Stored in a SOUL procedure that is invoked by the Online at runtime
  • Issued Online from Model 204 command level by a user with system manager privileges

Network control commands

Use network control commands to manipulate the Model 204 TCP/IP (Horizon) network entities (link, processgroup, and process) once you have defined them.

You can place these commands in the User 0 stream or in a Model 204 procedure, or issue them at command level. You must have User 0, system administrator, or system manager privileges.

These commands are listed in the following table. For details, follow the links in the table.

Network control commands
Command Function
OPEN LINK name Opens the link; required for connection
CLOSE LINK name Disables an opened link
START type name Starts a stopped link or processgroup
STOP type name Stops a link or processgroup
MONITOR type name Displays current usage of a network entity
MODIFY PROCESSGROUP name Modifies a current processgroup definition

See also