Connect-Star installation requirements: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{DISPLAYTITLE: Connect<span class="superstar">&#9733;</span> installation requirements}}
{{DISPLAYTITLE: Connect-Star installation requirements}}
==Overview==
==Overview==
<p>
<p>
The Connect<span class="superstar">&#9733;</span> Suite supports three communications interfaces:</p>
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<span class="superstar">&#9733;</span>
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&nbsp;204.</p>
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<sup>&#9733;</sup>===
===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.


All Connect<span class="superstar">&#9733;</span> 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:
 
Connect<span class="superstar">&#9733;</span> 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>&reg;</sup> operating system: IBM z/OS<sup>&reg;</sup>, IBM z/VM<sup>&reg;</sup>, or IBM z/VSE<sup>&reg;</sup></li>
<li>IBM<sup>&reg;</sup> operating system: IBM z/OS<sup>&reg;</sup>, IBM z/VM<sup>&reg;</sup>, or IBM z/VSE<sup>&reg;</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<span class="superstar">&#9733;</span> SQL and/or RCL connections. For more information, see the Rocket Model 204 [[:Category: Installation|installation instructions]] for your operating system and the Rocket Model 204 [[:Category:SQL connectivity|SQL connectivity documentation]].</li>
 
<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&nbsp;204 [[:Category:SQL connectivity|SQL connectivity documentation]].</li>
</ul>
</ul>


===Connect<sup>&#9733;</sup> workstation or server===
===Connect-Star workstation or server===
The following Connect<span class="superstar">&#9733;</span> interfaces are available:
The following Connect-Star interfaces are available:
<ul>
<ul>
<li>The Connect<span class="superstar">&#9733;</span> ODBC interface is 32-bit and provides compatibility with any program or operating system capable of running or supporting 32-bit applications. This includes Windows 7 (32-bit or 64-bit), Java Virtual Machine (32-bit or 64-bit), or other similar environments.</li>
<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<span class="superstar">&#9733;</span> JDBC driver operates with either a 64-bit or 32-bit Java Virtual Machine.</li>
The Connect-Star JDBC driver operates with either a 64-bit or 32-bit Java Virtual Machine.</li>
<li>
<li>
The Connect<span class="superstar">&#9733;</span> .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>
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>&reg;</sup> 7 or Windows 8.1 and Windows Server<sup>&reg;</sup> 2008 or Windows Server 2012</li>
<li>Windows<sup>&reg;</sup> 7, Windows 8.1, or Windows 10</li>
<li>Windows 10 and Windows Server 2012</li>
<li>Windows Server<sup>&reg;</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<sup>TM</sup> SE Development Kit (JDK) 7.0 or higher</li>
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<sup>&reg;</sup> 7 or Windows 8.1 and Windows Server<sup>&reg;</sup> 2008 or Windows Server 2012</li>
<li>Windows<sup>&reg;</sup> 7, Windows 8.1, or Windows 10</li>
<li>Windows 10 and Windows Server 2012</li>
<li>Windows Server<sup>&reg;</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<span class="superstar">&#9733;</span>, perform the following tasks, consulting your documentation or TCP/IP manager as needed.</p>
Before installing Connect-Star, perform the following tasks, consulting the Model&nbsp;204 documentation or your TCP/IP manager as needed.</p>
<table>
<table>
<p class="caption">Connect<span class="superstar">&#9733;</span> preinstallation tasks</p>
<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>[[:Category:Installation|the Model 204 installation instructions]] for your site and the appropriate installation guide for your PC</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&nbsp;204 runs in. There is only one IP address for each system.</td>
<td>the TCP/IP manager at your site</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&nbsp;204 link.</td>
<td>the TCP/IP manager at your site</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><p>[[Defining the user environment (CCAIN)]]</p>
<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<span class="superstar">&#9733;</span> ODBC</td>
<td>Remove your existing copy of Connect-Star ODBC</td>
<td>[[Connect* for ODBC#uninstall Connect* ODBC|Uninstalling a previous version of Connect<span class="superstar">&#9733;</span> for ODBC]]</td>
<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<span class="superstar">&#9733;</span> for JDBC</td>
<td>Remove your existing copy of Connect-Star for JDBC</td>
<td>[[Connect* for JDBC#remove Connect* JDBC|Removing a previous version of Connect<span class="superstar">&#9733;</span> for JDBC]]</td>
<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 Connect<span class="superstar">&#9733;</span> for .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<span class="superstar">&#9733;</span> for .NET Framework]]</td>
<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<span class="superstar">&#9733;</span> might or might not also be the Model 204 system administrator or database administrator.
Most of the tasks in the previous table are handled by the Model&nbsp;204 system administrator or Model&nbsp;204 database administrator. The person who installs Connect-Star might or might not also be the Model&nbsp;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&nbsp;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 [[DEFINE_LINK_command:_Horizon_for_TCP/IP|DEFINE LINK command]].


==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.

Connect-Star preinstallation tasks

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)

List of Model 204 parameters

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.

See also