IBM DB2 VSAM Transparency for VSE/ESA Version 5 Allows You to Exploit the Benefits of Relational Database Technology While It Supports Your Existing VSAM Applications

Software Announcement
April 1, 1997
Announcement Letter Number: 297-085


Table of Contents:



At a Glance

DB2 VSAM Transparency for VSE/ESA:

  • Eliminates the need to convert your VSAM applications all at once

  • Allows you to quickly benefit from relational technology

  • Uses static SQL for better performing queries and reduced overhead costs

  • Helps provide storage relief for your VSAM files

  • Gives you the flexibility and time to convert VSAM applications at your own pace
-----------------------------------------
For ordering, contact:
  Your IBM representative, an IBM
  Business Partner, or IBM North America
  Sales Call Center at
    800-IBM-CALL  Reference: LE010



Overview

Now you can get the benefits of a relational database manager without the need to immediately rewrite your VSAM applications. With DB2 (R) VSAM Transparency for VSE/ESA (TM), migration to a relational database no longer means you have to convert all your VSAM applications and replace VSAM calls with SQL right away. DB2 VSAM Transparency for VSE/ESA (DB2 VSAM Transparency) lets you move some or all of your data to DB2 Server for VSE and continue using your existing applications without change. You can use the applications right away against the new database. You can also choose to continue running your operational applications against the VSAM datasets and use the built in propagation functions to replicate the data each night to decision support databases on the DB2 Server.



Intended Customers

All VSAM VSE customers who want:

  • An easy way to benefit from IBM's powerful DB2 family of relational database products

  • To migrate to DB2 Server for VSE

  • To extend their existing VSAM applications to take advantage of relational technology without recoding existing VSAM applications



Key Prerequisites

  • DB2 VSAM Transparency for VSE/ESA is designed to operate with DB2 Server for VSE and/or supported versions of SQL/DS (TM).
Planned Availability Date

May 2, 1997

------------------------------

This announcement is provided for your information only. For additional information, contact your IBM representative or call 800-IBM-4YOU.



DESCRIPTION

DB2 VSAM Transparency for VSE/ESA (DB2 VSAM Transparency) allows users to migrate their data from VSAM files into DB2 tables and also provides transparent access to the migrated data with NO changes required to existing application programs.

With the help of an online tool, the characteristics of each VSAM file are described as well as the corresponding DB2 tables. Batch programs are supplied that automatically migrate the data. For each VSAM file, the following programs are created:

  • A data move program
  • A batch access program
  • An online access program
Once the migration is complete, the user simply specifies which files are to be "Transparent" and productive work can begin with NO changes to user applications. DB2 VSAM Transparency intercepts the VSAM request from an application program and performs the requested action on a DB2 database. The following VSE/VSAM file types are supported:
  • Key Sequenced Data Set (KSDS)
  • VSAM Alternate Indexes
  • Entry Sequenced Data Set (ESDS)
  • Relative Record Data Set (RRDS)
DB2 VSAM Transparency does not support Variable Length Relative Record Data Sets (VRDS).

Installations using DB2 VSAM Transparency will have several migration options available to them. All files do not have to be migrated at the same time. You may choose to proceed with migration on a file by file basis, or you may choose the flexibility of mixing your VSAM access with DB2 access.

DB2 VSAM Transparency has no dependencies on a specific programming language. Commonly used mainframe programming languages are supported. DB2 VSAM Transparency makes it easier to take advantage of DB2 relational technology while maintaining existing VSAM applications. With the use of DB2 databases and other IBM software, customers have the capability to build:

  • Data warehouses
  • Executive information systems
  • Data marts
  • Client/server applications
DB2 VSAM Transparency helps you take advantage of these technologies while leveraging your existing information and application assets.

The version level of IBM DB2 VSAM Transparency for VSE/ESA reflects the version number for the current level of IBM DB2 Server for VSE with which it is designed to run. There are no prior versions of the product. Customers who are using IBM SQL/DS Version 3 Release 5 can also take advantage of the transparency features offered by IBM DB2 VSAM Transparency Version 5 Release 1.



DB2 Product and Service Technical Library

Answers to commonly asked technical questions may be available on the Worldwide Web in the DB2 Product and Service Technical Library. This library can be accessed from the Bookshelf off of the DB2 Server for VSE and VM home Page at:

    http://www.software.ibm.com/data/sql
Trademarks
      VSE/ESA and SQL/DS are trademarks of International Business
      Machines Corporation in the United States or other countries or
      both.
      DB2 is a registered trademark of International Business
      Machines Corporation in the United States or other countries or
      both.
      Other company, product, and service names may be trademarks or
      service marks of others.



SUPPLEMENTAL INFORMATION



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: DB2 (R) VSAM Transparency for VSE/ESA (TM) is designed to operate on any hardware supporting DB2 Server for VSE or SQL/DS (TM).

Software Requirements: DB2 VSAM Transparency for VSE/ESA is designed to operate with the following minimum versions and releases of programs.

  • SQL/DS Version 3 Release 4 (5688-103) and/or
  • DB2 Server for VSE & VM Version 5 Release 1 (5648-158)
  • VSE/VSAM Version 2 Release 1 (5686-037)
Follow-on versions or releases of these products can be used with DB2 VSAM Transparency unless otherwise stated.



Planning Information



Security, Auditability, and Control

The announced program uses the security and auditability features of the Host software.

User management is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.



ORDERING INFORMATION

The following publications will be available May 2, 1997. To order, contact your IBM representative.

                                 Order
Title                            Number

DB2 VSAM Transparency for SC26-8956 VSE/ESA User's Guide How to Get to DB2/VSE from SG24-4931 VSAM Using DB2 VSAM Transparency for VSE/ESA



New Licensees

Orders for new licenses will be accepted now.

Shipment will begin on the planned availability date.

New users of DB2 VSAM Transparency for VSE/ESA should specify:

         Type           Model

5697 B88

Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. For a graduated one-time charge (OTC), or graduated monthly license charge (MLC), specify one of the following feature numbers as applicable and corresponding to the group that contains the designated machine. Also, specify the feature number of the desired distribution medium.

                                               Basic
                 Basic                       Graduated
               Graduated                      Monthly
            One-Time Charge                License Charge
Group        Feature Number                Feature Number

10 1664 1600 15 1665 1601 18 1666 1602 20 1667 1603 25 1668 1604 28 1669 1605 29 1670 1606 30 1671 1607 31 1672 1608 32 1673 1609 35 1674 1610 38 1675 1611 40 1676 1612 50 1677 1613 60 1678 1614 70 1679 1615 80 1680 1616

Multiple Operating System -- PR/SM (TM) (MOSP): For a graduated OTC or graduated MLC, specify the following feature number, corresponding to the group that contains the designated machine.

                                               Basic
                 Basic                       Graduated
               Graduated                      Monthly
            One-Time Charge                License Charge
Group        Feature Number                Feature Number

18 1681 1617 20 1682 1618 25 1683 1619 28 1684 1620 29 1685 1621 30 1686 1622 31 1687 1623 32 1688 1624 35 1689 1625 38 1690 1626 40 1691 1627 50 1692 1628 60 1693 1629 70 1694 1630 80 1695 1631

Note: The group can be determined by referring to either the Exhibit for IBM System/370 (TM) and System/390 (R) Machines (Z125-3901) or the Exhibit for Non-IBM Machines (Z125-3902) associated with the IBM Customer Agreement (Z125-4575).

Entry Support License (ESL): To order an ESL license, specify the program number, feature number 9001 for asset registration, and the applicable ESL OTC feature number. Also specify the feature number of the desired distribution medium.

                                                  ESL
                                                  One-Time
                                                  Charge
                                Program           Feature
Description                     Number            Number

DB2 VSAM Transparency 5697-B88 1728 for VSE/ESA

Note: ESL machines can be determined by referring to the IBM Entry End User/390 Attachment (Z125-4379).

Version-to-Version Upgrade Credit: To upgrade from a prior program acquired for a one-time charge to a replacement program using a version-to-version upgrade credit, the customer must notify and identify to IBM the applicable prior program and replacement program participating in the upgrade credit.

Basic Machine-Readable Material: To order, select the feature number of the desired distribution medium.

                                 Feature        Distribution
Environment                      Number         Medium

DB2 VSAM Transparency 5801 9/6250 bpi tape for VSE/ESA DB2 VSAM Transparency 5802 3480 cartridge for VSE/ESA DB2 VSAM Transparency 5040 1/4-inch for VSE/ESA cartridge DB2 VSAM Transparency 5041 4-mm cartridge for VSE/ESA

Customization Options: Select the appropriate feature numbers to customize your order to specify the delivery options desired. These features can be specified on the initial or MES orders.

Example: If publications are not desired for the initial order, and for future updates, specify feature numbers 3470 to ship media only, and 3480 to ship media updates only. In the future if publication updates were required, order an MES to remove feature number 3480, and the publications will ship with the next release for the program.

                                                    Feature
Description                                         Number

Initial Shipments

Serial Number Only (suppresses shipment 3444 of media and documentation)

Ship Media Only (suppresses initial 3470 shipment of documentation)

Ship Documentation Only (suppresses 3471 initial shipment of media) Feature Description Number

Update Shipments

Ship Media Updates Only (suppresses 3480 update shipment of documentation)

Ship Documentation Only (suppresses 3481 update shipment of media)

Suppress Updates (suppresses update 3482 shipment of media and documentation)

Expedite Shipments

Local IBM Office Expedite 3445 (for IBM use only)

Customer Expedite Process Charge 3446 ($30 charge for each product)

Expedite shipments will be processed to receive 72 hour delivery from the time IBM Software Manufacturing Solutions (ISMS) receives the order. ISMS will then ship the order via overnight air transportation.

DSLO License: To order a DSLO license, specify the program number, feature number 9901 for asset registration, and the feature number for a graduated OTC or graduated MLC that corresponds to the group containing the designated machine.

                DSLO                        DSLO
             Graduated                   Graduated
          One-Time Charge          Monthly License Charge
Group      Feature Number              Feature Number

10 1696 1632 15 1697 1633 18 1698 1634 20 1699 1635 25 1700 1636 28 1701 1637 29 1702 1638 30 1703 1639 31 1704 1640 32 1705 1641 35 1706 1642 38 1707 1643 40 1708 1644 50 1709 1645 60 1710 1646 70 1711 1647 80 1712 1648

Multiple Operating System -- PR/SM (MOSP): For a graduated OTC or graduated MLC, specify the following feature number corresponding to the group that contains the designated machine.

             MOSP DSLO                   MOSP DSLO
             Graduated                   Graduated
          One-Time Charge          Monthly License Charge
Group      Feature Number              Feature Number

18 1713 1649 20 1714 1650 25 1715 1651 28 1716 1652 29 1717 1653 30 1718 1654 31 1719 1655 MOSP DSLO MOSP DSLO Graduated Graduated One-Time Charge Monthly License Charge Group Feature Number Feature Number

32 1720 1656 35 1721 1657 38 1722 1658 40 1723 1659 50 1724 1660 60 1725 1661 70 1726 1662 80 1727 1663

Ordering a DSLO feature will result in IBM maintaining a record of this customer location as a DSLO user only. All material for the DSLO license must be ordered by the basic licensee. If a user selects DSLO, no other feature numbers are valid for this order and no program materials or updates will be shipped.

Unlicensed Documentation: A program directory and one copy of the following publications are supplied automatically with the basic machine-readable material:

                                                  Order
Title                                             Number

DB2 VSAM Transparency for SC26-8956 VSE/ESA Users Guide How to Get to DB2/VSE SG24-4931 from VSAM Using DB2 VSAM Transparency for VSE/ESA

Additional copies of unlicensed publications are available for a fee after product availability. These copies may be ordered from your IBM representative, through the system library subscription service (SLSS) or by direct order.

Subsequent updates (technical newsletters or revisions between releases) to the publications shipped with the product will be distributed to the user of record for as long as a license for this software remains in effect. A separate publication order or subscription is not needed.



TERMS AND CONDITIONS

Licensing: IBM Customer Agreement

Variable Charges Apply: Yes

Parallel Sysplex (TM) License Charge (PSLC) Applies: No

Indexed Monthly License Charge (IMLC) Applies: No

Installation License or Location License Applies: No

Usage Restriction Applies: No

Educational Allowance: Yes, to qualified education customers.

Volume Discount: Not applicable.

Version-to-Version Upgrade Credits Apply: Yes

                                                      Single
Replaced Programs           Replacement Programs     Version
Program     Program         Program   Program        Charging
Number      Name            Number    Name           Applies

5697-B88 DB2 VSAM To follow on, if any No Transparency for VSE/ESA

Warranted: No

Licensed Program Materials Availability:

Restricted Materials of IBM:        None
Non-Restricted Source Materials:    None
Object Code Only (OCO):             All

Testing Period: None

Program Services:

Support Center applies:             Yes

Available until discontinued: 6 months written notice

APAR Mailing Address: DB2 Server for VSE & VM Service Dept. 240 Stn. 2S 1150 Eglinton Avenue East North York, ON Canada, M3C 1H9

Services for DSLO Licenses: Provided through Basic License location



CHARGES

Program Number
5697-B88
           Basic          DSLO            Basic          DSLO
           Graduated      Graduated       Monthly        Monthly
           One-Time       One-Time        License        License
Group      Charge         Charge          Charge         Charge

10 $ 2,500 $ 1,875 $ 52 $ 39 15 3,250 2,440 68 51 18 3,410 2,560 71 53 20 4,945 3,710 103 77 25 6,430 4,825 134 101 28 8,810 6,610 183 137 29 11,450 8,590 238 179 30 14,880 11,160 310 233 31 18,300 13,730 381 286 32 23,420 17,570 488 366 35 26,930 20,200 561 421 38 30,970 23,230 645 484 40 35,620 26,720 742 557 50 44,530 33,400 928 696 60 55,660 41,750 1,160 870 70 69,580 52,190 1,450 1,090 80 86,980 65,240 1,815 1,360

                                          MOSP Basic     MOSP DSLO
           MOSP Basic     MOSP DSLO       Graduated      Graduated
           Graduated      Graduated       Monthly        Monthly
           One-Time       One-Time        License        License
Group      Charge         Charge          Charge         Charge

18 $ 3,250 $ 2,440 $ 68 $ 51 20 3,330 2,500 70 53 25 4,180 3,135 87 65 28 5,690 4,270 119 89 29 7,620 5,715 159 119 30 10,130 7,600 211 158 31 13,170 9,880 274 206 32 16,590 12,440 346 260 35 20,860 15,650 435 326 38 25,180 18,890 525 394 40 28,950 21,710 603 452 50 33,300 24,980 694 521 60 40,080 30,060 835 626 70 50,100 37,580 1,045 784 80 62,620 46,970 1,305 979

                           One-Time
                           Charge

Entry End User/390 Entry Support License: $1,135

One-Time Charge: -- Customers who pay a one-time charge for a licensed program receive enhancements and future releases, if any, at no additional charge. Significant new function may be offered as an optional feature and charged for separately. If a replacement program is announced and the customer elects to license the replacement program and replace the prior program, a time-based upgrade credit may apply.

Variable Charges: -- The applicable graduated one-time charge or graduated monthly license charge will be based on the group of the designated machine on which the licensed program is licensed for use. If the program is designated to a processor in a group for which no charge is listed above, the charge of the next higher group listed applies.

For upgrades of one-time charge licenses to a machine in a higher group, the upgrade charge will be the difference in the then current charges between the two groups. For downgrades of one-time charge licenses to a machine in a lower group, there will be no adjustment or refund of one-time charges paid.

For upgrades or downgrades of monthly license charge licenses, the monthly license charge applicable to the higher or lower group will apply.

Entry Support License One-Time Charge: -- One-Time charge authorizes use only on IBM Entry End User/390 Machines.



CALL NOW TO ORDER

To order, contact IBM North America Sales Call Center, your local IBM representative, or your IBM Business Partner (TM).

IBM North America Sales Call Center, our national direct marketing organization, can also arrange to put your name on the mailing list for catalogs of IBM products.

 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM North America Call Sales Center
            Dept. LE010
            P.O. Box 16848
            Atlanta, GA  30321-0848
 Reference: LE010

To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date. Trademarks

      VSE/ESA, SQL/DS, PR/SM, System/370, SP, Parallel Sysplex, and
      Business Partner are trademarks of International Business
      Machines Corporation in the United States or other countries or
      both.
      DB2 and System/390 are registered trademarks of International
      Business Machines Corporation in the United States or other
      countries or both.
      Other company, product, and service names may be trademarks or
      service marks of others.