72216-01-1160-03
8/20/98
Copyright Notice
1. Accessing Current Release Bulletin Information
A more recent version of this Release Bulletin may be available on the World Wide Web. To check for critical product or document information added after the release of the product CD, use the Sybase Technical Library Product Manual Web site.
To access release bulletins at the Technical Library Product Manual Web site:
Go to support.sybase.com.
Click the Electronic Support Services tab.
Under the Technical Library heading, choose Product Manuals.
Choose the appropriate version link.
In the right-hand window, choose the "platform" collection of the product you are interested in.
In the right-hand window, choose the release bulletin for your platform.
2. Product Summary
Enclosed is Sybase MainframeConnect for DB2/MVS-CICS Release 11.06, which is compatible with the following platform and operating system configurations:
CICS version 3.3 and later
MVS/ESA, OS/390
DB2 3.1 and later
Note: For complete software requirements, see MainframeConnect for DB2/MVS-CICS Installation and Administration Guide.
MainframeConnect for DB2/MVS-CICS is a unified version of two previous products:
MDI Access Server for MVS-CICS Versions 2.3 and 2.5
OmniSQL Access Module Release 10.1.2
Product Features
Starting with this release the format of the version string has changed. In previous releases the format for the version number was 11.1.1 . It will now appear as 11.01.01. nnnn , where the nnnn is the build number as in the following example, 11.01.01.0083 . For this release the version string is 11.06.00 .
The following describes the features of this release for Mainframe Connect for DB2/MVS-CICS:
Contains enhancements for providing compatibility with PowerBuilder native driver and a new 32 bit ODBC driver.
Incorporates numerous MainframeConnect enhancements from EBF 1111 P1-P3.
Is built on Open ServerConnect for CICS version 4.0 which will support MainframeConnect version 11.06.
Note: 1] To run MainframeConnect version 11.06 in an Open ServerConnect version 3.1 environment, using TCP/IP, you must re-link the MainframeConnect modules with special JCL that is being supplied. See additional instructions in the Installation Instructions section of this Release Bulletin. 2] If you are using the Client Services Applications (CSAs) or Remote Stored Procedures (RPCs) features, you must install an EBF that will correct the incompatibilities that exist between the CSA and RSP interface and Open ServerConnect and Open ClientConnect APIs. See the Known Issues section of this release bulletin for more information.
Version Contents
MainframeConnect for MainframeConnect for DB2/MVS-CICS is shipped on two 3480 cartridges. The contents of the cartridges are listed in the installation chapters of the MainframeConnect for DB2/MVS-CICS Installation and Administration Guide and the Open ServerConnect Installation and Administration Guide for IBM CICS/MVS.
MainframeConnect for MainframeConnect for DB2/MVS-CICS Release 11.06 includes the following:
3480 cartridges
Product documentation
This release bulletin
The following table shows the contents and product ID numbers of MainframeConnect for MainframeConnect for DB2/MVS-CICS.
| Product | Product Type | Product ID |
|---|---|---|
| Open ServerConnect for IBM CICS/MVS Base Tape Release 4.0Includes the Japanese Conversion Module libraries. | 3480 cartridge | 68120-33-0400-41 |
| MainframeConnect for MainframeConnect for DB2/MVS-CICS Version 11.1.1 Volume Serial Number MFC111Includes the Transaction Router Service Catalog Stored Procedures libraries. | 3480 cartridge | 26875-33-1160-41 |
| MainframeConnect for DB2/MVS-CICS Installation and Administration Guide | Document | 36525-01-1111-01 |
| Open ServerConnect Installation and Administration Guide for IBM CICS/MVS | Document | 36510-01-0400-01 |
| Release Bulletin (for) MainframeConnect for MainframeConnect for DB2/MVS-CICS Release 11.06 | Document | 72216-01-1160-01 |
Migration Issues
MainframeConnect for MainframeConnect for DB2/MVS-CICS is backwardly-compatible with:
MDI Access Server for MVS-CICS Version 2.5
OmniSQL Access Module Release 10.1.2
3. Special Upgrade Instructions
If you are migrating from the MDI Access Server for MVS-CICS or OmniSQL Access Module, read Chapter 3, "Migrating from Previous Installations," in the MainframeConnect for DB2/MVS-CICS Installation and Administration Guide before you install MainframeConnect for DB2/MVS-CICS.
4. Special Installation Instructions
Before Installing MainframeConnect for DB2/MVS-CICS
Before you install MainframeConnect for DB2/MVS-CICS, you must install the Open ServerConnect for CICS/MVS base tape.
For instructions on installing the Open ServerConnect for CICS version 4.0 base tape, see the Open ServerConnect Installation and Administration Guide for IBM CICS/MVS.
To run MainframeConnect version 11.06 in an Open ServerConnect 3.1 environment, using TCP/IP, you must re-link the MainframeConnect modules with special JCL (Library name = SYBASE.AMD2116.JCL, Member name = LNK31AM2) that is being supplied with this installation.
Contact Sybase Technical support for help if needed. See additional instructions in the Installation Instructions section
Installing MainframeConnect for DB2/MVS-CICS
For instructions on installing the MainframeConnect tape, see Chapter 5, "Installing the MainframeConnect Tape" in the MainframeConnect for DB2/MVS-CICS Installation and Administration Guide.
For instructions on installing the optional Transaction Router Service Catalog Stored Procedures, see Chapter 6, "Installing Catalog Stored Procedures for Transaction Router Service" in the MainframeConnect for DB2/MVS-CICS Installation and Administration Guide.
For instructions on installing the optional Japanese Conversion Module, see the Open ServerConnect Installation and Administration Guide for IBM CICS/MVS.
5. Known Issues
This section contains known issues with MainframeConnect for DB2/MVS-CICS version 11.06.
General issues
TRS CSPs
The table_owner column for sp_tables is returned and padded to eight characters.
TSQUEUE
When tsqueue is set to aux or main and the first column is a non-nullable longvar, the beginning of the record buffer for tsqueues will not be set correctly.
RSPs
When an RSP has an input pipe and a DB2 output pipe that is opened simultaneously, the RSP will abend with an ASRA (abend code).
An incorrect length variable is being moved to the length of the standard output pipe variable record.
The spvarlen field is not being set if all the parms are keywords.
Quoted strings are not parsed correctly if two quotes are together within the string, for example "O'Riley".
CSAs and RSPs
If you are using CSAs or RSPs and MainframeConnect version 11.06 you need to install EBF NO. I0135 for Open ClientConnect version 4.0P1A or Open ServerConnect version 4.0P1A that will be issued following this release. There are incompatibilities with the CSA/RSP interface that is shipped with Open ServerConnect and Open ClientConnect APIs that this EBF will correct.
Note: EBF NO I0135 is ONLY to be installed if you are using CSAs or RSPs with MainframeConnect version 11.06.
6. Product Compatibilities
MainframeConnect for DB2/MVS-CICS is compatible with the following products:
Open ServerConnect for IBM CICS/MVS version 4.0
Japanese Conversion Module Release 3.1 and later
DirectConnect for MVS Release 11.1.1 and later
7. Software Bugs and Fixes
For information describing the fixes in this release, refer to the following table:
| Description | Resolution | QTS # |
|---|---|---|
| MainframeConnect changes all single-quotes and double-quotes to single quotes. | Quote transformation removed except for TRS and RSPs. | 135855 |
| TRS did not get dates in ISO format if DB2 date option was not ISO. | Add Date configuration option of ISO to the MainframeConnect configuration screen. | 137228 |
| In migrating, from MDI to DC DB2 and MainframeConnect, columns returned >255 bytes included 2 bytes undisplayable text in front of the result. | Removed the additional undisplayable 2 bytes. | 137486 |
| RSPs after being re-linked for MainframeConnect will not work with the old MDI Access Server. | RSP stubs can now be used for both MainframeConnect and the MDI Access Server. | 137921 |
| An RSP being called as an RPC by SQL Server produces an 063 message. | Corrected call. | 138839 |
| Columns defined as decimal (3,2) or (numeric 3,2) cannot be selected using version 11.1 of DirectConnect for DB2 or Mainframe Connect for DB2. | This problem has been corrected. | 139115 |
| SPCODE is not being returned properly from an RSP call through MainframeConnect. | This problem has been corrected. | 140752 |
| When a decimal column is defined with an odd number precision one greater than the scale, results less than one return bad values. | This problem has been corrected. | 140754 |
| Stop on condition, error, was not working correctly when a warning was issued for a language event. | This problem has been corrected. | 141118 |
| When running ASPT all result sets are being returned as upper case. MDI SPTEST returns data as is. | Corrected ASPT. | 142130 |
| CSA ASQL will not work with TCP/IP default in Open Client 3.2 EBF 6781. | This problem has been corrected. | 142423 |
| The "NO UDT" option does not work for all transactions in a CICS region. | "Send UDT" option added to the mainframe configuration. | 142490 |
| If SendWarningMessages property is set to "Yes" and MaxRows is reached DirectConnect does not issue a warning message. | Created new warning message 33243 for these conditions. | 142613 |
| ASPT does not return status information from the RSP. | This problem has been corrected. | 142624 |
| USE procedure does not invoke the RSP when called as a dynamic event. | RSPs can now be invoked via a dynamic event. (Backward compatibility issue with MDI Database Gateway.) | 142708 |
| DirectConnect TRS's sp_columns returns 26,0 for Timestamp's precision scale, rather than 26,6. | This problem has been corrected. | 163333 |
| MAXROWRETURNED message is currently defined as an error and should only be a warning. | Message level changed to warning. | 165248 |
| MainframeConnect not calling parse/request exits for cursor events. | Parse and request exit is now supported for cursor events. | 165253 |
| Language statements concatenated into a buffer greater than 32K fail. | This problem has been corrected. | 166144 |
| RSP returning multiple result sets show the wrong row count. | This problem has been corrected. | 166288 |
| If AMD2 is executed as an RPC (from Netgateway or TRS) and if the language request in the parameter contains semi-colon delimeters and CR/LFs, then an error occurs. Either a 104 error message, indicating an invalid character or an abend. | This problem has been corrected. | 166449 |
| Execution of AMD2 as an RPC gives a return code of "1" not zero. | This problem has been corrected. | 166464 |
| RSPs return warning messages even when SendWarningMessages is set to 'no". | This problem has been corrected. | 166539 |
| ASQL the CSA Open Client test program is showing date in the internal representation (2-4 byte integer fields) instead of Char format in either ISO or USA format. | If the UDT indicates this is a date or time then the datetime gets converted to date and time. Otherwise it is converted to a timestamp. | 166734 |
| Datetime parameter failed to get inserted into DB2 date, time, or timestamp fields. | This problem has been corrected. | 166818 |
| RSP input pipes does not return all the data in the pipe when the first record is smaller than the following records in the pipe. | This problem has been corrected. | 166872 |
8. Documentation Updates and Clarifications
In the MainframeConnect for DB2/MVS-CICS Installation and Administration Guide
The following updates to existing documentation should be noted.
In Chapter 5, Installing the MainframeConnect Tape
At the bottom of page 5-2, in step 4 change the reference to the CICS utility from "DFHCSDUB to read "DFHCSDUP".
In Chapter 7, Configuring MainframeConnect
On page 7-6 at the bottom of the page delete the following two bullets:
The block size divided by the record size equals the number of records per block.
The number of records divided by the number of records per block equals the number of blocks written to temporary storage.
At the top of page 7-7, change "blocks" to "records". The bulleted sentence should read:
The number of records it writes to temporary storage multiplied by the 8-byte storage ID equals the number of bytes of main storage.
Delete the entire example following the bulleted sentence.
In Appendix A, Error Messages
Add the following new error message:
DB2 Access Module warning (Max result size, %s, exceeded)
The DirectConnect configured MaxResultSize or MaxRowsReturned has been exceeded. The remaining results have not been returned.
Select a smaller result set or increase the configured value for MaxResultSize or MaxRowsReturned.
9. Technical Support
Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you have any questions about this installation or if you need assistance during the installation process, ask the designated person to contact Sybase Technical Support or the Sybase subsidiary in your area.
10. Other Sources of Information
Use the Sybase Technical Library CD and the Technical Library Web site to learn more about your product:
Technical Library CD contains product manuals and technical documents and is included with your software. The DynaText browser (included on the Technical Library CD) allows you to access technical information about your product in an easy-to-use format.
Refer to the Technical Library Installation Guide in your documentation package for instructions on installing and starting Technical Library.
Technical Library Web site includes the Product Manuals site, which is an HTML version of the Technical Library CD that you can access using a standard Web browser. In addition, you'll find links to the Technical Documents Web site (formerly known as Tech Info Library), the Solved Cases page, and Sybase/Powersoft newsgroups.
To access the Technical Library Web site, go to support.sybase.com, click the Electronic Support Services tab, and select a link under the Technical Library heading.
Sybase Certifications on the Web
Technical documentation at the Sybase Web site is updated frequently.
Point your Web browser to Technical Documents at the following Web site:
In the Browse section, click on the Hot entry.
Explore your area of interest: Hot Docs covering various topics, or Hot Links to Technical News, Certification Reports, Partner Certifications, and so on.
Point your Web browser to Technical Documents at the following Web site:
In the Browse section, click on the Hot entry.
Click on the EBF Rollups entry.
You can research EBFs using Technical Documents, and you can download EBFs using Electronic Software Distribution (ESD).
Follow the instructions associated with the SupportPlusSM Online Services entries.
You can register by following the instructions on the Web.
To use SupportPlus, you need:
A Web browser that supports the Secure Sockets Layer (SSL), such as Netscape Navigator 1.2 or later
An active support license
A named technical support contact
Your user ID and password
You can use Sybase's Technical Documents. Certification Reports are among the features documented at this site.
Point your Web browser to Technical Documents at the following Web site:
In the Browse section, click on the Hot entry.
Click on the topic that interests you.
Back to Top
