SQL network entities - Revision history

JAL: restore ★

2017-08-11T18:20:00Z

restore ★

← Older revision		Revision as of 18:20, 11 August 2017
Line 22:		Line 22:

	===Defining connections ===		===Defining connections ===
	If you are running SQL or RCL on a PC or workstation using 32-bit Connect<~~sup~~>★</~~sup~~>, define a connection for Model 204 TCP/IP (Horizon).		If you are running SQL or RCL on a PC or workstation using 32-bit Connect<span class="superstar">★</span>, define a connection for Model 204 TCP/IP (Horizon).

	For more information, see [[Horizon TCP/IP]].		For more information, see [[Horizon TCP/IP]].

	===Single and multiple definitions===		===Single and multiple definitions===
	For Connect<~~sup~~>★</~~sup~~>, specify <var>DEFINE</var> commands for each of the SQL network entities: link, processgroup, and process.		For Connect<span class="superstar">★</span>, specify <var>DEFINE</var> commands for each of the SQL network entities: link, processgroup, and process.
	<p>		<p>
	See the excerpt from the sample Model 204 Online job in [[Runtime environment for SQL processing#Runtime examples\|Runtime examples]].</p>		See the excerpt from the sample Model 204 Online job in [[Runtime environment for SQL processing#Runtime examples\|Runtime examples]].</p>

JAL: repair super

2017-08-02T19:50:11Z

repair super

← Older revision		Revision as of 19:50, 2 August 2017
Line 18:		Line 18:
	===Process===		===Process===
	The <var class="term">process definition</var> 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.		The <var class="term">process definition</var> 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.
	<p>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.</p>		<p>
			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.</p>

	===Defining connections ===		===Defining connections ===
			If you are running SQL or RCL on a PC or workstation using 32-bit Connect<sup>★</sup>, define a connection for Model 204 TCP/IP (Horizon).
	If you are running SQL or RCL on a PC or workstation using 32-bit Connect<~~span class="superstar"~~>★</~~span~~>, define a connection for Model 204 TCP/IP (Horizon).

	For more information, see [[Horizon TCP/IP]].		For more information, see [[Horizon TCP/IP]].

	===Single and multiple definitions===		===Single and multiple definitions===
	For Connect<~~span class="superstar"~~>★</~~span~~>, specify DEFINE commands for each of the SQL network entities: link, processgroup, and process.		For Connect<sup>★</sup>, specify <var>DEFINE</var> commands for each of the SQL network entities: link, processgroup, and process.
	<p>See the excerpt from the sample Model 204 Online job in [[Runtime environment for SQL processing#Runtime examples\|Runtime examples]].</p>		<p>
			See the excerpt from the sample Model 204 Online job in [[Runtime environment for SQL processing#Runtime examples\|Runtime examples]].</p>

	===Where to specify DEFINE commands===		===Where to specify DEFINE commands===
	The DEFINE commands can be:		The <var>DEFINE</var> commands can be:
	<ul>		<ul>
	<li>Coded in the CCAIN stream of the job or EXEC you use to bring up your Model 204 Online</li>		<li>Coded in the CCAIN stream of the job or EXEC you use to bring up your Model 204 Online</li>

	<li>Stored in a SOUL procedure that is invoked by the Online at runtime</li>		<li>Stored in a SOUL procedure that is invoked by the Online at runtime</li>
	<li>Issued Online from Model 204 command level by a user with system manager privileges</li>
			<li>Issued Online from Model 204 command level by a user with system manager privileges</li>
	</ul>		</ul>

	==Network control commands==		==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.		Use network control commands to manipulate the Model 204 TCP/IP (Horizon) network entities (link, processgroup, and process) once you have defined them.
	<p>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.</p>		<p>
	<p>These commands are listed in the following table. For details, follow the links in the table.</p>		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.</p>
	~~<p class="caption">Network control commands</p>~~		<p>
			These commands are listed in the following table. For details, follow the links in the table.</p>

	<table>		<table>
	<th>Command</th>		<caption>Network control commands</caption>
			<tr class="head"><th>Command</th>
	<th>Function</th>		<th>Function</th>
	<tr>		<tr>

	<td><var>[[OPEN LINK command\|OPEN LINK]]</var> <var class="term">name</var></td>		<td><var>[[OPEN LINK command\|OPEN LINK]]</var> <var class="term">name</var></td>
	<td>Opens the link; required for connection</td>		<td>Opens the link; required for connection</td>
	</tr>		</tr>

	<tr>		<tr>
	<td><var>[[CLOSE LINK command: Model 204 non-CNOS intersystem link\|CLOSE LINK]]</var> <var class="term">name</var></td>		<td><var>[[CLOSE LINK command: Model 204 non-CNOS intersystem link\|CLOSE LINK]]</var> <var class="term">name</var></td>
	<td>Disables an opened link</td>		<td>Disables an opened link</td>
	</tr>		</tr>

	<tr>		<tr>
	<td><var>[[START command: Starting a Model 204 intersystem network entity\|START]]</var> <var class="term">type name</var></td>		<td><var>[[START command: Starting a Model 204 intersystem network entity\|START]]</var> <var class="term">type name</var></td>
	<td>Starts a stopped link or processgroup</td>		<td>Starts a stopped link or processgroup</td>
	</tr>		</tr>

	<tr>		<tr>
	<td><var>[[STOP command: Stopping a Horizon or Model 204 SQL link or processgroup\|STOP]]</var> <var class="term">type name</var></td>		<td><var>[[STOP command: Stopping a Horizon or Model 204 SQL link or processgroup\|STOP]]</var> <var class="term">type name</var></td>
	<td>Stops a link or processgroup</td>		<td>Stops a link or processgroup</td>
	</tr>		</tr>

	<tr>		<tr>
	<td><var>[[MONITOR command: Intersystem network entities\|MONITOR]]</var> <var class="term">type name</var></td>		<td><var>[[MONITOR command: Intersystem network entities\|MONITOR]]</var> <var class="term">type name</var></td>
	<td>Displays current usage of a network entity</td>		<td>Displays current usage of a network entity</td>
	</tr>		</tr>

	<tr>		<tr>
	<td><var>[[MODIFY PROCESSGROUP command\|MODIFY PROCESSGROUP]]</var> <var class="term">name</var></td>		<td><var>[[MODIFY PROCESSGROUP command\|MODIFY PROCESSGROUP]]</var> <var class="term">name</var></td>

JAL: /* Process */ typo

2017-08-02T19:42:34Z

Process: typo

← Older revision		Revision as of 19:42, 2 August 2017
Line 18:		Line 18:
	===Process===		===Process===
	The <var class="term">process definition</var> 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.		The <var class="term">process definition</var> 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.
	<p>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.</p>		<p>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.</p>

	===Defining connections ===		===Defining connections ===

ELowell at 23:59, 11 October 2016

2016-10-11T23:59:23Z

← Older revision		Revision as of 23:59, 11 October 2016
Line 71:		Line 71:
	</tr>		</tr>
	</table>		</table>

			==See also==
			{{Template:SQL connectivity topic list}}

	[[Category: SQL connectivity]]		[[Category: SQL connectivity]]

ELowell: /* Network control commands */

2015-07-20T20:00:17Z

Network control commands

← Older revision		Revision as of 20:00, 20 July 2015
Line 47:		Line 47:
	<th>Function</th>		<th>Function</th>
	<tr>		<tr>
	<td>[[OPEN LINK command\|OPEN LINK]] <i>name</i></td>		<td><var>[[OPEN LINK command\|OPEN LINK]]</var> <var class="term">name</var></td>
	<td>Opens the link; required for connection</td>		<td>Opens the link; required for connection</td>
	</tr>		</tr>
	<tr>		<tr>
	<td>[[CLOSE LINK command: Model 204 non-CNOS intersystem link\|CLOSE LINK]] <i>name</i></td>		<td><var>[[CLOSE LINK command: Model 204 non-CNOS intersystem link\|CLOSE LINK]]</var> <var class="term">name</var></td>
	<td>Disables an opened link</td>		<td>Disables an opened link</td>
	</tr>		</tr>
	<tr>		<tr>
	<td>[[START command: Starting a Model 204 intersystem network entity\|START]] <i>type name</i></td>		<td><var>[[START command: Starting a Model 204 intersystem network entity\|START]]</var> <var class="term">type name</var></td>
	<td>Starts a stopped link or processgroup</td>		<td>Starts a stopped link or processgroup</td>
	</tr>		</tr>
	<tr>		<tr>
	<td>[[STOP command: Stopping a Horizon or Model 204 SQL link or processgroup\|STOP]] <i>type name</i></td>		<td><var>[[STOP command: Stopping a Horizon or Model 204 SQL link or processgroup\|STOP]]</var> <var class="term">type name</var></td>
	<td>Stops a link or processgroup</td>		<td>Stops a link or processgroup</td>
	</tr>		</tr>
	<tr>		<tr>
	<td>[[MONITOR command: Intersystem network entities\|MONITOR]] <i>type name</i></td>		<td><var>[[MONITOR command: Intersystem network entities\|MONITOR]]</var> <var class="term">type name</var></td>
	<td>Displays current usage of a network entity</td>		<td>Displays current usage of a network entity</td>
	</tr>		</tr>
	<tr>		<tr>
	<td>[[MODIFY PROCESSGROUP command\|MODIFY PROCESSGROUP]] <i>name</i></td>		<td><var>[[MODIFY PROCESSGROUP command\|MODIFY PROCESSGROUP]]</var> <var class="term">name</var></td>
	<td>Modifies a current processgroup definition</td>		<td>Modifies a current processgroup definition</td>
	</tr>		</tr>

ELowell: /* Overview */

2015-07-20T16:48:25Z

Overview

← Older revision		Revision as of 16:48, 20 July 2015
Line 1:		Line 1:
	==~~Overview~~==		==Making the necessary connections==
	~~This overview topic introduces the network entities that you define to establish~~ Model 204 TCP/IP (Horizon) ~~networks~~:		The Model 204 TCP/IP (Horizon) connections that you need to establish are described in this section:
	<ul>		<ul>
	<li>Link</li>		<li>Link</li>
Line 13:		Line 13:

	===Link===		===Link===
	A <i>link</i> represents a connection between Model 204 and a network. The link definition specifies the transport mechanism and protocol to use for communications.		A <var class="term">link</var> represents a connection between Model 204 and a network. The link definition specifies the transport mechanism and protocol to use for communications.
	===Processgroup===		===Processgroup===
	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.		A <var class="term">processgroup</var> 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.
	===Process===		===Process===
	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.		The <var class="term">process definition</var> 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.
	<p>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.</p>		<p>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.</p>

Line 37:		Line 37:
	<li>Issued Online from Model 204 command level by a user with system manager privileges</li>		<li>Issued Online from Model 204 command level by a user with system manager privileges</li>
	</ul>		</ul>

	==Network control commands==		==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.		Use network control commands to manipulate the Model 204 TCP/IP (Horizon) network entities (link, processgroup, and process) once you have defined them.

ELowell at 17:27, 23 February 2015

2015-02-23T17:27:32Z

← Older revision		Revision as of 17:27, 23 February 2015
Line 71:		Line 71:
	</table>		</table>

	[[Category: SQL ~~Connectivity~~]]		[[Category: SQL connectivity]]

ELowell at 23:28, 20 February 2015

2015-02-20T23:28:47Z

← Older revision		Revision as of 23:28, 20 February 2015
Line 71:		Line 71:
	</table>		</table>

	[[Category: ~~Networking]]~~		[[Category: SQL Connectivity]]
	~~[[Category: Model 204~~ SQL ~~processing~~]]

ELowell: Created page with "==Overview== This overview topic introduces the network entities that you define to establish Model 204 TCP/IP (Horizon) networks:

Link

Processgroup

2015-02-19T21:45:32Z

Created page with "==Overview== This overview topic introduces the network entities that you define to establish Model 204 TCP/IP (Horizon) networks: <ul> <li>Link</li> <li>Processgroup</li> <li..."

New page
==Overview==
This overview topic introduces the network entities that you define to establish Model 204 TCP/IP (Horizon) networks:
<ul>
<li>Link</li>
<li>Processgroup</li>
<li>Process</li>
</ul>

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]]
[[DEFINE PROCESSGROUP command: Horizon for TCP/IP]]

===Link===
A link represents a connection between Model 204 and a network. The link definition specifies the transport mechanism and protocol to use for communications.
===Processgroup===
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.
===Process===
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 environment for SQL processing#Runtime examples|Runtime examples]].

===Where to specify DEFINE commands===
The DEFINE commands can be:
<ul>
<li>Coded in the CCAIN stream of the job or EXEC you use to bring up your Model 204 Online</li>
<li>Stored in a SOUL procedure that is invoked by the Online at runtime</li>
<li>Issued Online from Model 204 command level by a user with system manager privileges</li>
</ul>
==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
<table>
<th>Command</th>
<th>Function</th>
<tr>
<td>[[OPEN LINK command|OPEN LINK]] name</td>
<td>Opens the link; required for connection</td>
</tr>
<tr>
<td>[[CLOSE LINK command: Model 204 non-CNOS intersystem link|CLOSE LINK]] name</td>
<td>Disables an opened link</td>
</tr>
<tr>
<td>[[START command: Starting a Model 204 intersystem network entity|START]] type name</td>
<td>Starts a stopped link or processgroup</td>
</tr>
<tr>
<td>[[STOP command: Stopping a Horizon or Model 204 SQL link or processgroup|STOP]] type name</td>
<td>Stops a link or processgroup</td>
</tr>
<tr>
<td>[[MONITOR command: Intersystem network entities|MONITOR]] type name</td>
<td>Displays current usage of a network entity</td>
</tr>
<tr>
<td>[[MODIFY PROCESSGROUP command|MODIFY PROCESSGROUP]] name</td>
<td>Modifies a current processgroup definition</td>
</tr>
</table>

[[Category: Networking]]
[[Category: Model 204 SQL processing]]