SQL network entities: Difference between revisions
No edit summary |
m (restore <span class="superstar">★</span>) |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
== | ==Making the necessary connections== | ||
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 < | 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> | |||
===Defining connections === | ===Defining connections === | ||
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). | |||
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<span class="superstar">★</span>, 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> | |||
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>[[OPEN LINK command|OPEN LINK]] < | |||
<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]] < | <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]] < | <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]] < | <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]] < | <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]] < | <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> | ||
</table> | </table> | ||
[[Category: SQL | ==See also== | ||
{{Template:SQL connectivity topic list}} | |||
[[Category: SQL connectivity]] | |||
Latest revision as of 18:20, 11 August 2017
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
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 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.
| 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 |