Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 
Support > Technical Documents > Document Types > Release Bulletin > Release Bulletin for MainframeConnect for DB2/MVS-...

Release Bulletin for MainframeConnect for DB2/MVS-CICS Release 11.6

Documents known problems and changes to installation, functionality, and documentation for MainframeConnect for DB2/MVS-CICS version 11.6.
 
RSS Feed
 
 
 

72216-01-1160-03
8/20/98

Copyright Notice

Table of Contents 
1. Accessing Current Release Bulletin Information  
2. Product Summary  
2.1. Product Features  
2.2. Version Contents  
2.3. Migration Issues  
3. Special Upgrade Instructions  
4. Special Installation Instructions  
4.1. Before Installing MainframeConnect for DB2/MVS-CICS  
4.2. Installing MainframeConnect for DB2/MVS-CICS  
5. Known Issues  
5.1. General issues  
6. Product Compatibilities  
7. Software Bugs and Fixes  
8. Documentation Updates and Clarifications  
8.1. In the MainframeConnect for DB2/MVS-CICS Installation and Administration Guide  
9. Technical Support  
10. Other Sources of Information  

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:

  1. Go to support.sybase.com.

  2. Click the Electronic Support Services tab.

  3. Under the Technical Library heading, choose Product Manuals.

  4. Choose the appropriate version link.

  5. In the right-hand window, choose the "platform" collection of the product you are interested in.

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

Table 1: MainframeConnect for MainframeConnect for DB2/MVS-CICS Release 11.06 product set

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:

Table 2: Descrition of bugs and fixes

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:

Error 33243

DB2 Access Module warning (Max result size, %s, exceeded)

Explanation

The DirectConnect configured MaxResultSize or MaxRowsReturned has been exceeded. The remaining results have not been returned.

Action

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:

Sybase Certifications on the Web

Technical documentation at the Sybase Web site is updated frequently.

For the latest information on product certifications and/or the EBF Rollups:
  1. Point your Web browser to Technical Documents at the following Web site:

    www.sybase.com/support

  2. In the Browse section, click on the Hot entry.

  3. Explore your area of interest: Hot Docs covering various topics, or Hot Links to Technical News, Certification Reports, Partner Certifications, and so on.

If you are a registered SupportPlus user:
  1. Point your Web browser to Technical Documents at the following Web site:

    www.sybase.com/support

  2. In the Browse section, click on the Hot entry.

  3. Click on the EBF Rollups entry.

    You can research EBFs using Technical Documents, and you can download EBFs using Electronic Software Distribution (ESD).

  4. Follow the instructions associated with the SupportPlusSM Online Services entries.

If you are not a registered SupportPlus user and you want to become one:

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

Whether or not you are a registered SupportPlus user:

You can use Sybase's Technical Documents. Certification Reports are among the features documented at this site.

  1. Point your Web browser to Technical Documents at the following Web site:

    www.sybase.com/support

  2. In the Browse section, click on the Hot entry.

  3. Click on the topic that interests you.


 

DOCUMENT ATTRIBUTES
Last Revised: Jul 28, 1998
Part Number: 72216-01-1160-03
Product: Mainframe Connect
Hardware Platform: IBM MVS
  
Technical Topics: Install/Upgrade
Business or Technical: Technical
Content Id: 206037
Infotype: Release Bulletin
 
 
 

© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics