Connect-Star installation requirements: Difference between revisions
No edit summary |
|||
(16 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
{{DISPLAYTITLE: Connect | {{DISPLAYTITLE: Connect-Star installation requirements}} | ||
==Overview== | ==Overview== | ||
<p> | <p> | ||
The Connect | The Connect-Star Suite supports three communications interfaces:</p> | ||
<ul> | <ul> | ||
<li> | <li>.NET Framework</li> | ||
.NET Framework</li> | <li>JDBC</li> | ||
<li> | <li>ODBC</li> | ||
JDBC</li> | |||
<li> | |||
ODBC</li> | |||
</ul> | </ul> | ||
<p> | <p> | ||
Each interface has its own database connectivity program that supports both SQL and RCL connections. The Connect | Each interface has its own database connectivity program that supports both SQL and RCL connections. The Connect-Star Visual Interface is provided to populate the SQL catalog file (CCACAT) and for quick query capability to Model 204.</p> | ||
===SQL conformance level=== | ===SQL conformance level=== | ||
The SQL conformance level is ANSI 89 with most ANSI 92 functionality. | The SQL conformance level is ANSI 89 with most ANSI 92 functionality. | ||
===Communication protocol=== | ===Communication protocol=== | ||
Each interface uses the TCP/IP protocol to connect a PC workstation to Model 204 running on a mainframe. | Each interface uses the TCP/IP protocol to connect a PC workstation to Model 204 running on a mainframe. | ||
===IPv6 address support for Connect | ===IPv6 address support for Connect-Star=== | ||
All Connect-Star clients support Internet Protocol Version 6 (IPv6) 128-bit addresses as well as IPv4 32-bit addresses. | |||
Connect-Star clients have the option of specifying explicit server addresses in either of the following formats: | |||
<ul> | <ul> | ||
<li>IPv4 dotted decimal format; for example: | <li>IPv4 dotted decimal format; for example: | ||
Line 49: | Line 42: | ||
<ul> | <ul> | ||
<li>IBM<sup>®</sup> operating system: IBM z/OS<sup>®</sup>, IBM z/VM<sup>®</sup>, or IBM z/VSE<sup>®</sup></li> | <li>IBM<sup>®</sup> operating system: IBM z/OS<sup>®</sup>, IBM z/VM<sup>®</sup>, or IBM z/VSE<sup>®</sup></li> | ||
<li>TCP/IP for operating systems z/OS, z/VM, or z/VSE</li> | <li>TCP/IP for operating systems z/OS, z/VM, or z/VSE</li> | ||
<li>IBM TCP/IP V3</li> | <li>IBM TCP/IP V3</li> | ||
<li>Model 204 Online, version 7.4 or higher, configured for use with Connect | |||
<li>Model 204 Online, version 7.4 or higher, configured for use with Connect-Star SQL and/or RCL connections. For more information, see the Rocket [[Model 204 installation|Model 204 installation instructions]] for your operating system and the Rocket Model 204 [[:Category:SQL connectivity|SQL connectivity documentation]].</li> | |||
</ul> | </ul> | ||
===Connect | ===Connect-Star workstation or server=== | ||
The following Connect | The following Connect-Star interfaces are available: | ||
<ul> | <ul> | ||
<li>The Connect | <li>The Connect-Star ODBC interface is 32-bit and provides compatibility with any program or Windows operating system capable of running or supporting 32-bit applications.</li> | ||
<li> | <li> | ||
The Connect | The Connect-Star JDBC driver operates with either a 64-bit or 32-bit Java Virtual Machine.</li> | ||
<li> | <li> | ||
The Connect | The Connect-Star .NET interface version 7.5 and higher provides both 32-bit and 64-bit drivers that can be used with any Web or GUI-driven application.</li> | ||
</ul> | </ul> | ||
Line 69: | Line 65: | ||
<li>Microsoft platforms: | <li>Microsoft platforms: | ||
<ul> | <ul> | ||
<li>Windows<sup>®</sup> 7 | <li>Windows<sup>®</sup> 7, Windows 8.1, or Windows 10</li> | ||
<li>Windows Server<sup>®</sup> 2008 or Windows Server 2012</li> | |||
</ul> | </ul> | ||
</li> | </li> | ||
Line 79: | Line 75: | ||
<li>Microsoft TCP/IP</li> | <li>Microsoft TCP/IP</li> | ||
<li> | <li> | ||
Java | Java Runtime 32-bit JRE (minimum version 1.6)</li> | ||
<li> | <li> | ||
Platforms: Any operating system that supports Java Virtual Machine (JVM)</li> | Platforms: Any operating system that supports Java Virtual Machine (JVM)</li> | ||
Line 91: | Line 87: | ||
Microsoft platforms: | Microsoft platforms: | ||
<ul> | <ul> | ||
<li>Windows 7, Windows 8.1</li> | <li>Windows<sup>®</sup> 7, Windows 8.1, or Windows 10</li> | ||
<li> | <li>Windows Server<sup>®</sup> 2008 or Windows Server 2012</li> | ||
</ul> | </ul> | ||
</li> | </li> | ||
Line 99: | Line 95: | ||
==Preparing to install== | ==Preparing to install== | ||
<p> | <p> | ||
Before installing Connect | Before installing Connect-Star, perform the following tasks, consulting the Model 204 documentation or your TCP/IP manager as needed.</p> | ||
<table> | <table> | ||
<p class="caption">Connect | <p class="caption">Connect-Star preinstallation tasks</p> | ||
<tr class="head"> | <tr class="head"> | ||
<th>Task</th> | <th>Task</th> | ||
<th>Consult...</th> | <th>Consult...</th> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Install TCP/IP software on the mainframe and the PC</td> | <td>Install TCP/IP software on the mainframe and the PC</td> | ||
<td>[[ | <td>The [[Model 204 installation]] instructions for your site and the appropriate installation guide for your PC</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Get an IP address for the z/OS system Model 204 runs in. There is only one IP address for each system.</td> | <td>Get an IP address for the z/OS system Model 204 runs in. There is only one IP address for each system.</td> | ||
<td> | <td>The TCP/IP manager at your site</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Get a SERVPORT number, the local port number that remote clients use to connect to the Model 204 link.</td> | <td>Get a SERVPORT number, the local port number that remote clients use to connect to the Model 204 link.</td> | ||
<td> | <td>The TCP/IP manager at your site</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Define input threads, such as IODEVs 19 and/or 49, and setting CCAIN parameters </td> | <td>Define input threads, such as IODEVs 19 and/or 49, and setting CCAIN parameters </td> | ||
<td | <td>[[Defining the user environment (CCAIN)]] | ||
<p>[[List of Model 204 parameters]]</p> | <p>[[List of Model 204 parameters]]</p> | ||
</td> | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Define links and processgroups for your applications</td> | <td>Define links and processgroups for your applications</td> | ||
Line 129: | Line 130: | ||
<var>[[DEFINE LINK command: Horizon for TCP/IP|DEFINE LINK]]</var> and <var>[[DEFINE PROCESSGROUP command: Horizon for TCP/IP|DEFINE PROCESSGROUP]]</var> commands for TCP/IP</td> | <var>[[DEFINE LINK command: Horizon for TCP/IP|DEFINE LINK]]</var> and <var>[[DEFINE PROCESSGROUP command: Horizon for TCP/IP|DEFINE PROCESSGROUP]]</var> commands for TCP/IP</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Make sure you have either a [[Rocket M204 user ID]] or a preexisting user ID to download the installation files.</td> | <td>Make sure you have either a [[Rocket M204 user ID]] or a preexisting user ID to download the installation files.</td> | ||
<td>[[Contacting Rocket Software Technical Support|Rocket Technical Support]]</td> | <td>[[Contacting Rocket Software Technical Support|Rocket Technical Support]]</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Remove your existing copy of Connect | <td>Remove your existing copy of Connect-Star ODBC</td> | ||
<td>[[Connect* for ODBC#uninstall Connect* ODBC|Uninstalling a previous version of Connect | <td>[[Connect* for ODBC#uninstall Connect* ODBC|Uninstalling a previous version of Connect-Star for ODBC]]</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Remove your existing copy of Connect | <td>Remove your existing copy of Connect-Star for JDBC</td> | ||
<td>[[Connect* for JDBC#remove Connect* JDBC|Removing a previous version of Connect | <td>[[Connect* for JDBC#remove Connect* JDBC|Removing a previous version of Connect-Star for JDBC]]</td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>Remove your existing copy of .NET Framework</td> | <td>Remove your existing copy of Connect-Star for .NET Framework</td> | ||
<td>[[Connect* for .NET Framework#uninstall Connect* .NET Framework|Uninstalling a previous version of Connect | <td>[[Connect* for .NET Framework#uninstall Connect* .NET Framework|Uninstalling a previous version of Connect-Star for .NET Framework]]</td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
Most of the tasks in the previous table are handled by the Model 204 system administrator or Model 204 database administrator. The person who installs Connect | Most of the tasks in the previous table are handled by the Model 204 system administrator or Model 204 database administrator. The person who installs Connect-Star might or might not also be the Model 204 system administrator or database administrator. | ||
===TCP/IP software requirements=== | ===TCP/IP software requirements=== | ||
To connect using TCP/IP, define a TCP/IP link in the Model 204 Online using a <var>DEFINE LINK</var> command. For correct coding, see [[DEFINE LINK command: Horizon for TCP/IP|DEFINE LINK command]]. | |||
To connect using TCP/IP, define a TCP/IP link in the Model 204 Online using a DEFINE LINK command. For correct coding, see [[ | |||
==Security interfaces for UNIX System Services (formerly OpenEdition)== | ==Security interfaces for UNIX System Services (formerly OpenEdition)== | ||
If you are running with the sockets interface (IBM stack and z/OS 1.4 or above) then you must make security definitions within Open MVS to define Model 204 as a sockets application. | If you are running with the sockets interface (IBM stack and z/OS 1.4 or above) then you must make security definitions within Open MVS to define Model 204 as a sockets application. | ||
Line 163: | Line 166: | ||
Sample definitions for Security Server (RACF) users: | Sample definitions for Security Server (RACF) users: | ||
<ul> | <ul> | ||
<li> | <li>For the owning USERID for the ONLINE address space, specify the following to define it to the OMVS segment:<p class="code">UID=0000000000 | ||
For the owning USERID for the ONLINE address space, specify the following to define it to the OMVS segment:<p class="code">UID=0000000000 | |||
HOME=/ | HOME=/ | ||
PROGRAM=/bin/sh</p> | PROGRAM=/bin/sh</p> | ||
When defining UNIX System Services users to Security Server (RACF), such as assigning a UID to the user, the USERID must have a UID of 0, as shown in this first example. | When defining UNIX System Services users to Security Server (RACF), such as assigning a UID to the user, the USERID must have a UID of 0, as shown in this first example.</li> | ||
</li> | |||
<li> | <li>For the group that owns the owning USERID, specify a group ID: | ||
For the group that owns the owning USERID, specify a group ID: | |||
<p class="code">GID=0000000002</p> | <p class="code">GID=0000000002</p> | ||
<p> | |||
The value of 0000000002 in this example is the ID of the particular Security Server (RACF) group as defined to UNIX System Services. | The value of 0000000002 in this example is the ID of the particular Security Server (RACF) group as defined to UNIX System Services. </p></li> | ||
</li> | |||
</ul> | </ul> | ||
Line 184: | Line 184: | ||
==See also== | ==See also== | ||
{{Template: Connect* topic list}} | {{Template: Connect* topic list}} | ||
[[Category: Connect*]] | [[Category: Connect*]] |
Latest revision as of 17:49, 27 March 2024
Overview
The Connect-Star Suite supports three communications interfaces:
- .NET Framework
- JDBC
- ODBC
Each interface has its own database connectivity program that supports both SQL and RCL connections. The Connect-Star Visual Interface is provided to populate the SQL catalog file (CCACAT) and for quick query capability to Model 204.
SQL conformance level
The SQL conformance level is ANSI 89 with most ANSI 92 functionality.
Communication protocol
Each interface uses the TCP/IP protocol to connect a PC workstation to Model 204 running on a mainframe.
IPv6 address support for Connect-Star
All Connect-Star clients support Internet Protocol Version 6 (IPv6) 128-bit addresses as well as IPv4 32-bit addresses.
Connect-Star clients have the option of specifying explicit server addresses in either of the following formats:
- IPv4 dotted decimal format; for example:
74.6.238.254
- IPv6 colon-separated hexadecimal format; for example:
2001:0DB8:AC10:FE01:0000:0000:0000:0000
Consecutive zero halfwords can be replaced by a double colon, for example:
2001:0DB8:AC10:FE01::
If an application specifies the host address as a symbolic name, then the client first attempts an IPv6 connection to the server. If that fails, the client attempts an IPv4 connection. An error is not returned to the application unless both attempts fail.
Requirements
In order to take advantage of IPv6 addresses, you might have to install and enable IPv6 support on your client operating system. See your client operating system documentation for instructions.
System requirements
Model 204 mainframe
- IBM® operating system: IBM z/OS®, IBM z/VM®, or IBM z/VSE®
- TCP/IP for operating systems z/OS, z/VM, or z/VSE
- IBM TCP/IP V3
- Model 204 Online, version 7.4 or higher, configured for use with Connect-Star SQL and/or RCL connections. For more information, see the Rocket Model 204 installation instructions for your operating system and the Rocket Model 204 SQL connectivity documentation.
Connect-Star workstation or server
The following Connect-Star interfaces are available:
- The Connect-Star ODBC interface is 32-bit and provides compatibility with any program or Windows operating system capable of running or supporting 32-bit applications.
- The Connect-Star JDBC driver operates with either a 64-bit or 32-bit Java Virtual Machine.
- The Connect-Star .NET interface version 7.5 and higher provides both 32-bit and 64-bit drivers that can be used with any Web or GUI-driven application.
ODBC support
- Microsoft® TCP/IP
- Microsoft platforms:
- Windows® 7, Windows 8.1, or Windows 10
- Windows Server® 2008 or Windows Server 2012
JDBC support
- Microsoft TCP/IP
- Java Runtime 32-bit JRE (minimum version 1.6)
- Platforms: Any operating system that supports Java Virtual Machine (JVM)
.NET Framework support
- Microsoft TCP/IP
- .NET Framework 3.5 or higher
-
Microsoft platforms:
- Windows® 7, Windows 8.1, or Windows 10
- Windows Server® 2008 or Windows Server 2012
Preparing to install
Before installing Connect-Star, perform the following tasks, consulting the Model 204 documentation or your TCP/IP manager as needed.
Task | Consult... |
---|---|
Install TCP/IP software on the mainframe and the PC | The Model 204 installation instructions for your site and the appropriate installation guide for your PC |
Get an IP address for the z/OS system Model 204 runs in. There is only one IP address for each system. | The TCP/IP manager at your site |
Get a SERVPORT number, the local port number that remote clients use to connect to the Model 204 link. | The TCP/IP manager at your site |
Define input threads, such as IODEVs 19 and/or 49, and setting CCAIN parameters | Defining the user environment (CCAIN) |
Define links and processgroups for your applications | DEFINE LINK and DEFINE PROCESSGROUP commands for TCP/IP |
Make sure you have either a Rocket M204 user ID or a preexisting user ID to download the installation files. | Rocket Technical Support |
Remove your existing copy of Connect-Star ODBC | Uninstalling a previous version of Connect-Star for ODBC |
Remove your existing copy of Connect-Star for JDBC | Removing a previous version of Connect-Star for JDBC |
Remove your existing copy of Connect-Star for .NET Framework | Uninstalling a previous version of Connect-Star for .NET Framework |
Most of the tasks in the previous table are handled by the Model 204 system administrator or Model 204 database administrator. The person who installs Connect-Star might or might not also be the Model 204 system administrator or database administrator.
TCP/IP software requirements
To connect using TCP/IP, define a TCP/IP link in the Model 204 Online using a DEFINE LINK command. For correct coding, see DEFINE LINK command.
Security interfaces for UNIX System Services (formerly OpenEdition)
If you are running with the sockets interface (IBM stack and z/OS 1.4 or above) then you must make security definitions within Open MVS to define Model 204 as a sockets application.
A useful reference manual is the IBM document SC28-1890, UNIX System Services Planning manual (formerly OpenEdition Planning). Among other subjects, this manual deals with security issues, including the setup of user IDs (UIDs) and group IDs (GIDs). This planning manual illustrates the security setup from a Security Server (formerly RACF) point of view.
As the planning manual mentions, you can use an equivalent security package instead of Security Server (RACF). However, you must verify that the version of the security package that you are running can handle UNIX System Services security.
Sample definitions for Security Server (RACF) users:
- For the owning USERID for the ONLINE address space, specify the following to define it to the OMVS segment:
UID=0000000000 HOME=/ PROGRAM=/bin/sh
When defining UNIX System Services users to Security Server (RACF), such as assigning a UID to the user, the USERID must have a UID of 0, as shown in this first example. - For the group that owns the owning USERID, specify a group ID:
GID=0000000002
The value of 0000000002 in this example is the ID of the particular Security Server (RACF) group as defined to UNIX System Services.
In Security Server (RACF) terms, you can set up the UID and GID definitions with certain panels under TSO/ISPF that are used to maintain users and groups. There is an equivalent facility for Top Secret or ACF2.
Where to find installation instructions
After performing the preinstallation tasks, see the installation instructions for your driver: JDBC, ODBC, or .NET Framework. Follow the appropriate link in the "See also" section below.