| General Information | Information that applies in general to this CONNX SQL Engine version. |
| Supported Platforms | Provides information on the platforms supported by this version. |
| Availability of CONNX Product Features | Provides information on the CONNX features supported for each platform. |
| Software AG Products | Provides information about the Software AG products supported by this version. |
| JDBC, JDK, and Other Product Requirements | Provides information about the JDBC, JDK, and other requirements of this release of CONNX SQL Engine. |
| New Features | An overview of the new features provided with this version. |
| Changes and Enhancements | Information on changes and enhancements provided in this version. |
| Known Issues | Information regarding known issues applicable for this version. |
| Abnormal Terminations | Describes the most common abend codes and their possible causes. |
| Adabas Response Codes | Describes the Adabas response codes caused by installation and configuration issues. |
| Migration | Information on migration of an existing CONNX SQL Engine installation to this version. |
| Installation Considerations | Information which should be considered prior to beginning with product installation. |
| Documentation and Other Online Information | Information about the product documentation and support. |
CONNX SQL Engine is a product component which enables you to access your business data via SQL.
CONNX SQL Engine is delivered in conjunction with another Software AG product, for example:
Adabas SQL Gateway
Natural SQL Gateway
Event Replicator for Adabas on LUW
This section covers the following topics:
The necessary CONNX licenses are delivered together with the associated Software AG product which you have purchased.
A list of CONNX licenses that are available is provided in the section Installation Considerations.
Important:
Before you can begin using the CONNX SQL Engine, you must
install the CONNX License Server and activate the CONNX licenses. For further
information, please refer to the CONNX Installation Guide and the
CONNX Planning Guide.
Prior to installing CONNX, it is strongly recommended that product administrators refer to the CONNX Enterprise Planning Guide for assistance in developing a comprehensive and appropriate CONNX installation and maintenance strategy.
The CONNX Planning Guide is intended to be relatively comprehensive and provides guidance that is not included in the CONNX Installation Guide or the CONNX User Guide.
The section Migration describes the steps which are to be performed, when –
Migrating from CONNX Version 11.5 SP1
Migrating from CONNX Version 12.0
A revised and updated documentation set is available at http://documentation.softwareag.com/ (Empower login required).
Information on last-minute changes made just before the product release can be found in the file readme.txt that is provided on the installation media.
The following table shows the operating system platforms supported by this release:
| Operating System | Version | Mode |
|---|---|---|
| Windows | Windows 7, Windows 8, Windows 10, Windows 2012 and Windows 2008 Server | 64-bit |
| AIX | 7.1 and 7.2 | 64-bit |
| HP-UX (Itanium) | 11i v3 | 64-bit |
| Sun Solaris | Solaris 11 | 64-bit |
| Linux (x86) |
Red Hat Enterprise 6 & 7 |
64-bit |
| z/Linux |
Red Hat Enterprise 6 & 7 |
64-bit |
| z/OS | 2.1 & 2.2 | 31-bit |
| z/VSE | 5.2 & 6.1 | 31-bit |
The following table shows which features are available for each supported platform.
| Platform >>>> | Windows | AIX | HP-UX (Itanium) | Sun Solaris | Linux (x86) | z/Linux | z/OS | z/VSE |
|---|---|---|---|---|---|---|---|---|
|
Server Features
|
||||||||
| License Server | X | X | X | X | X | X | ||
| JDBC Server | X | X | X | X | X | X | ||
| Location of the Data Dictionary (CDD) | X | X | X | X | X | X | ||
| Data Server | X | X | X | X | X | X | X | X |
|
Client Features
|
||||||||
| .NET | X | X | X | X | X | X | ||
| OLE DB | X | |||||||
| ODBC | X | X | X | X | X | X | ||
| JDBC | X | X | X | X | X | X | ||
| Embedded SQL | X | X | X | X | X | X | X | |
|
Utility Features
|
||||||||
| License Administrator | X | |||||||
| Data Dictionary Manager | X | |||||||
| Data Dictionary Viewer | X | |||||||
| Configuration Manager | X | |||||||
| DSNRegistry (JDBC) | X | |||||||
| SQLRegistry | X | X | X | X | X | X | ||
| Precompiler for C | X | X | X | X | X | X | X | |
| Precompiler for Cobol | X | X | X | X | X | X | X | |
| InfoNaut - Query Tool | X | |||||||
| ACEINT - Query Tool | X | X | X | X | X | X | X | |
|
Event Replicator
|
||||||||
| Replication Administrator | X | |||||||
| Event Producer | (32-bit) | X | X | X | X | X | ||
| Replication Server | X | X | X | X | X | X |
This section describes the Software AG products and features which may be used with CONNX.
The following table shows the Adabas versions with which CONNX may be used.
| Product | Platform: Open Systems | Platform: Mainframe |
|---|---|---|
| Adabas SQL Gateway | Adabas Version 6.1 or later | Adabas Version 8.1 or later |
| Event Replication Adabas to Adabas (LUW) | Adabas 6.3 SP1 or later | Not applicable |
Entire Net-Work is required to access Adabas databases which are located on platforms where the CONNX data server is not available (for example, BS2000 and VMS).
The Adabas client module to be used with the SQL Gateway is both platform and operating system dependent:
| Platform | Operating System | Environment | Module |
|---|---|---|---|
| Open Systems | Windows, UNIX, Linux | n/a | ADALNKX |
| Mainframe | z/OS | Batch / Started Task | ADALNKR |
| Mainframe | z/OS | CICS | LNCSTUB |
| Mainframe | z/VSE | CICS | LNCSTUB |
When installing under CICS, the SQL Gateway requires the usage of –
“CICS Command Level Interface” and
LNCSTUB – the “High Performance Stub”
Important:
The data server under CICS must be defined with “EXECKEY
CICS”; not doing so will result in an error.
This section describes the JDBC, JDK and other product requirements for this release of CONNX SQL Engine.
The JDBC client requirements are described in CONNX 13.5 Release Notes.
The JDK is only required for a CONNX client machine using JDBC.
Your platform vendor is usually the best source for platform specific JDKs. Please follow your vendor’s instructions for installation.
For a complete list of URLs where you can download JDKs for specific platforms, read CONNX 13.5 Release Notes.
Any driver manager can be used with the CONNX SQL Engine; for example, the open source product unixODBC. For more information, read CONNX 13.5 Release Notes.
For a complete list of new features available with this release please see the CONNX 13.5 Release Notes.
Information on the issues resolved in this product release can be found in the CONNX 13.5 Release Notes.
The following is a list of 32-bit and 64-bit components and the default ports they listen on:
| Component Name | Port |
|---|---|
| 32-bit Enterprise Server Service | 6500 |
| 64-bit Enterprise Server Service | 6502 |
| 32-bit JDBC Server | 7500 |
| 64-bit JDBC Server | 7502 |
| License Server | 7501 |
For a complete list of known issues with this release please see the CONNX 13.5 Release Notes.
Below is a list of the most common abend codes and their possible causes.
The most common causes of abnormal terminations on z/OS are installation and configuration issues:
ADALNKR has not been link-edited with the attributes
(RENT, REUSE).
The ‘default’ SVC in ADALNKR is invalid.
SAF Interface where the users are not allowed JESSPOOL access, usually to SYSTERM, SYSPRINT, etc.
The following table contains the most frequent abend codes for z/OS:
| Abend Code | Description |
|---|---|
| ABEND S013 | SAF Interface - JESSPOOL access. |
| ABEND S0C1 | ADALNKR is not link-edited with
(RENT, REUS).
|
| ABEND S0C4 |
ADALNKR is not link-edited with ( Adabas Fastpath requires a correction, when used with the SAF Interface. SAF Interface - JESSPOOL access. |
| ABEND S378 | ADALNKR must be link-edited with
(RENT, REUS).
|
| ABEND S4C6 | Apply IBM PTF OA08358. |
| ABEND S683 | CNXNOPREAUTHORIZE = 0
and Listener libraries *NOT* APF authorized.
|
| ABEND S806 | Migration from Version 9 to Version 10 issue (CNXADAx0). |
| ABEND S913 | SAF Interface - JESSPOOL access. |
| ABEND SFxx | Error occurred executing an installation-defined SVC. The 'default' SVC for the ADALNKR is xF9 (249). |
The most common causes of abnormal terminations on z/VSE are installation and configuration issues:
Usage of Adabas DCI (LNCSTUB) / ADATRUE is mandatory under CICS
Incorrect definitions or usage of Adabas Link Routine (ADATRUE/ADAENAB)
Ensure the AMODE setting of the Adabas
Link Routine is set to 31
CONNX Server components are not defined with EXECKEY ‘CICS’
The following table contains the most frequent abend codes for z/VSE:
| Abend Code | Description |
|---|---|
| ABEND AEZD | Definition and usage of Adabas Link Routine. |
| ABEND ASRA | EXECKEY 'CICS'. |
The following Adabas response codes are caused by installation and configuration issues:
| Adabas Response | Access to the Database | Action to be Taken |
|---|---|---|
| ADARSP-022 | Accessing a read-only nucleus | Use Registry Setting
OPREADONLY=0 |
| ADARSP-041 | Retrieving SUPERDE as COLUMN | Install Adabas Version 5.1.2 or later |
| ADARSP-145 | During UPDATE/DELETE | Use Registry Setting
ADAWAITONHOLD
|
The migration steps to be performed depend upon the product version that is currently in use and/or the version which was used to create the CONNX CDD.
The sections below describe the steps, which are to be performed, when –
The following licensing changes have been made in version 12.0:
Older versions of CONNX were licensed on a processor / core basis. With CONNX 12.0 this licensing is now enforced.
Licenses now contain the CONNX product version which is checked at initialization.
Both these new features make it essential that the license server is updated to CONNX 12.0 and new licenses are installed prior to upgrading the base CONNX products. Please refer to the CONNX Release Notes for more details.
Licenses for CONNX Version 12 are not valid for Version 13. You will need to install new licenses for this version.
The CONNX product installation files can be found in the Software Download Center (SDC) in Empower at https://empower.softwareag.com/ (Empower login required).
Prior to installing CONNX, it is strongly recommended that product administrators refer to the CONNX Enterprise Planning Guide for assistance in developing a comprehensive and appropriate CONNX installation and maintenance strategy.
The CONNX Planning Guide is intended to be relatively comprehensive and provides guidance that is not included in the CONNX Installation Guide or the CONNX User Guide.
CONNX licenses are available for multiple data sources. Please contact your Software AG representative for further details.
When installing SQL Gateway under z/VSE with Adabas V8.1 or later, the Adabas CICS High-Performance Stub Routine LNCSTUB.A must be modified.
Edit the member LNCSTUB.A (located in the appropriate Adabas sublibrary) Change &STBNAME SETC 'ADADCI' To &STBNAME SETC 'ADABAS'
After modification, LNCSTUB.A should be re-assembled, then re-linked to the SQL Gateway Server using the supplied member CNXINST0.JCL.
If the above change is not made, the SQL Gateway Server will abend with S0c1 when calling Adabas.
Code translation is automatically performed on columns which contain data that is stored in a Single-Byte code page.
The code page of the data can be set via the parameter
SBCCSID. This setting applies to all files in the
database and is stored in the table definitions in the CDD when the tables are
defined.
Note:
Adabas fields, which are defined with the Adabas field type
'A', may only contain "Single-Byte" data. Multi-Byte data that has been stored
in fields with field type 'A' cannot be interpreted correctly.
The following online resources are available for you to obtain up-to-date information about your Software AG products:
You can find documentation for all Software AG products on the Software AG Documentation website at http://documentation.softwareag.com. This site requires Empower credentials. If you do not have an Empower user ID and password yet, you will find instructions for registering on this site (free for customers with maintenance contracts) or you can also use the TECHcommunity website to access the latest documentation.
You can find documentation and other technical information on the Software AG TECHcommunity website at http://techcommunity.softwareag.com. You can:
Access product documentation, if you have TECHcommunity credentials. If you do not, you will need to register and specify "Documentation" as an area of interest. If you already have TECHcommunity credentials, you can adjust your areas of interest on the TECHcommunity website by editing your TECHcommunity profile. To access documentation in the TECHcommunity once you are logged in, select from the menu.
Access articles, demos, and tutorials.
Use the online discussion forums, moderated by Software AG professionals, to ask questions, discuss best practices, and learn how other customers are using Software AG technology.
Link to external websites that discuss open standards and web technology.
You can find product information on the Software AG Empower Product Support website at https://empower.softwareag.com. This site requires Empower credentials. If you do not have an Empower user ID and password yet, you will find instructions for registering on this site (free for customers with maintenance contracts).
To submit feature/enhancement requests, get information about product availability, and download products and certified samples, select from the menu once you are logged in.
To get information about fixes and to read early warnings, technical papers, and knowledge base articles, select from the menu once you are logged in.