IBM DATA PROPAGATOR MVS/ESA VERSION 1
Contents


Announcement Letter Number 290-526 dated September 5, 1990
US - Last Revised on September 5, 1990



Brief Description of Announcement, Charges, and Availability

       The Data Propagator (TM) MVS/ESA (TM) (DProp (TM) MVS/ESA) is
a licensed program designed to help manage the coexistence of the IBM
hierarchical technology of the IMS/ESA (TM) Database Manager (IMS/ESA
DB) with the relational technology of DATABASE 2 (TM) (DB2 (TM)).
For new applications, it helps provide flexibility in choosing the
data base manager (IMS/ESA DB or DB2) that best matches the
application requirements.  Data Propagator MVS/ESA Version 1 provides
the ability to automatically and selectively take changed data from
IMS/ESA DB and update DB2 tables without having to convert existing
applications.  For specific IMS/ESA Transaction Manager, CICS/ESA
(TM), and TSO environments, refer to the Investment Protection
section.
       Planned Availability Date:  March 29, 1991.
 (TM) Trademark of International Business Machines Corporation.


Customer Letter Section

HIGHLIGHTS
o   Business solutions are enhanced by increasing the ability to
    manage the coexistence of the IBM hierarchical technology of
    IMS/ESA DB with the relational technology of DB2.
o   User productivity is enhanced by providing more timely data for
    the DB2 relational applications, yet continuing to provide
    service to end users on the IMS/ESA DB system.
o   Utilities and user exits are provided for systems management and
    customization for the data propagation environment.
o   Growth is enabled with the ability to allow non-DP-oriented users
    to participate in providing solutions to the customer's backlog
    of applications.
o   Investment protection is ensured by allowing customers who wish
    to implement new decision-support applications on the relational
    DB2 technology to do so without significantly changing their
    present operational applications.  Therefore, current investment
    in IMS/ESA DB applications is protected.
DESCRIPTION
BUSINESS SOLUTIONS
Data propagation is the maintenance of two physical copies
(hierarchical and relational) as a single logical copy of data and
reflecting changes from one to the other.  Data Propagator MVS/ESA
Version 1 takes changes made by an application program to an IMS/ESA
DB data base and applies these to a DB2 table based on user-specified
mapping information.  The mapping and applying of changes are
performed, transparent to the application, immediately within the
same unit of work (synchronously).
       In addition, an interface for user-written programs is
provided for invoking the Data Propagator outside of that unit of
work (asynchronously).  Changed data can optionally be obtained from
IMS/ESA DB through the new IMS Data Capture User Exit.  Mapping
information can optionally be obtained from DXT (TM) through the new
DXT Map Capture Exit.  The mapping cases supported in Data Propagator
MVS/ESA Version 1 are:
o   Single IMS/ESA DB data base segment with concatenated keys of
    parents up to root
o   Single IMS/ESA DB data base segment with concatenated keys of
    parents up to root plus data from dependent segment (with a
    maximum occurrence of one).
       The Data Propagator MVS/ESA facilitates the coexistence of
IMS/ESA DB and DB2 by allowing DB2 technology to be used for
applications requiring access to data that originally resides in
IMS/ESA DB, and where it is not sufficient or acceptable to
periodically extract from the IMS/ESA DB data base in order to create
DB2 tables.  This coexistence facility is important for two reasons.
First, it allows existing IMS/ESA DB customers to take advantage of
relational DB2 technology for new decision-support applications even
where the source data originally resides in an existing IMS/ESA DB.
Second, it provides more flexibility in deciding the best data base
manager for a given situation, when developing new applications in an
environment with both DB2 and IMS/ESA DB.  The customers may decide,
for example, that the Fast Path facility of IMS/ESA DB provides the
best solution for applications with stringent data availability and
low cost-per-transaction requirements.  For ad hoc query and other
applications where the relational technology of DB2 might be more
appropriate, the Data Propagator MVS/ESA can be used to propagate the
data changes to DB2.
       By having a separate copy of the IMS/ESA DB data in the form
of DB2 tables, the critical online transaction processing application
can be protected from performance degradation resulting from ad hoc
queries contending for the same data base resources.  Data Propagator
MVS/ESA allows the propagated data to be accessed via SQL statements
issued from a remote IBM distributed relational data base system.
 (TM) Trademark of International Business Machines Corporation.
USER PRODUCTIVITY
Propagating data with the Data Propagator MVS/ESA allows end users to
use DB2 for decision support (for example, ad hoc query) in
situations where the source data resides in IMS/ESA DB data bases,
along with concurrent processing of existing IMS/ESA DB operational
applications.
       The increased flexibility in choosing the best solution for a
given application will likewise provide benefits in terms of better
productivity for the end user.
       Whether to use synchronous or asynchronous data propagation
should be determined based upon the customer's application
requirements.  Synchronous propagation in Data Propagator MVS/ESA
requires the IMS/ESA DB to be running batch or under a single IMS/ESA
Transaction Manager with DB2 in the same MVS/ESA image.  The
application will commit both IMS/ESA DB and DB2 changes within the
same application commit scope.  This activity ensures timeliness and
consistency of the data in DB2.  Asynchronous propagation does not
require IMS/ESA DB and DB2 to be under the same MVS image or even on
the same system.  The IMS/ESA DB changed data can be logged by a
user-written program or through the IMS/ESA DB Asynchronous Change
Data Capture facility (available through the service process prior to
December 30, 1991) for future mapping/updating by Data Propagator
MVS/ESA.  This action can help reduce the impact on the end-user
response time for accessing the IMS/ESA DB data, allows possible
enrichment of this data before updating the DB2 tables, and provides
freedom to apply the changes at a customer-selected time.
SYSTEMS MANAGEMENT
The following facilities of the Data Propagator MVS/ESA are provided
to help manage the data propagation environment:
o   CONSISTENCY CHECK UTILITY can provide customers with information
    required to verify and maintain the integrity of the selected DB2
    and IMS/ESA DB data when that data resides on the same MVS image.
    A repair file is created which can be used by customers to fix
    inconsistencies.
o   The AUDIT TRAIL is used to store information about all important
    DProp MVS/ESA events.  This information represents a valuable
    source of historical information.
o   The DPROP MVS/ESA TRACE is used to record detailed trace
    information (for example, a trace of all changed IMS/ESA DB data
    and of all propagating SQL statements).
       Standard installation procedures using ISPF panels help ease
the installation process.
       After a successful installation of Data Propagator, customers
can tailor Data Propagator MVS/ESA to support their special
requirements by implementing the following types of user exits:
PROPAGATION USER EXIT:  This exit will allow customers to handle
specific mapping cases for segments requiring a specialized mapping
if the general mapping cases provided by Data Propagator MVS/ESA are
not sufficient.  Service functions of Data Propagator MVS/ESA such as
tracing, standardized error processing, audit trail and controlled
change of the status of propagation will be available to PROPAGATION
USER EXITS.
SEGMENT USER EXIT:  Data Propagator MVS/ESA propagates data from an
IMS/ESA DB segment (defined in the DBD) to a DB2 table.  Customers
may have a need to define a segment differently from what is in the
source.  For such special requirements (for example, formatting
fields with a variable start position into a fixed column), a SEGMENT
USER EXIT can be written.
FIELD USER EXIT:  Data Propagator MVS/ESA supports only certain
conversion rules for converting IMS/ESA DB fields into DB2 tables.
Customers may have requirements to convert a specific character field
from source data into a numeric field for target data.  This
conversion can be handled by a FIELD USER EXIT for special
non-standard source field conversion or for special non-standard
target field conversion.
GROWTH ENABLEMENT
This product will allow customers whose operational data is on
IMS/ESA DB to implement new decision-support applications on DB2
tables by the use of end-user tools (for example,  QMF (TM)).  By
allowing non-DP-oriented users to participate in providing solutions
to the users' own backlog of applications the business growth of
these customers can be positively affected.  Most end-user decision
support tools today are being developed on relational technology.
 (TM) Trademark of International Business Machines Corporation.
INVESTMENT PROTECTION
Present IMS/ESA DB customers have a very significant investment in
their operational applications.  These applications are the backbone
of their business, performing well and not necessarily having a
business need for redesign.  This product will allow customers who
wish to implement new decision-support applications on the relational
DB2 technology to do so without significantly changing their present
IMS/ESA DB applications.
       The customer environment for Data Propagator MVS/ESA is the
customer who has installed, or plans to install, both IMS/ESA DB and
DB2, and who needs information from IMS/ESA DB data bases kept and
maintained in a timely manner in both IMS/ESA DB data bases and DB2
tables.
       The customer environments for synchronous data propagation are
customers with IMS/ESA DB running either batch or under a single
IMS/ESA Transaction Manager with DB2 in the same MVS/ESA image.
DProp MVS/ESA can be running under IMS/ESA DB/TM or IMS/ESA DB batch.
       The customer environments for asynchronous data propagation
are customers with IMS/ESA DB and DB2 in the same MVS/ESA image or on
different MVS/ESA images.  This could be within the same CPU or on
different CPUs.  The IMS/ESA DB is running either batch or under
control of the IMS/ESA TM and/or CICS/ESA.  Support for IMS/ESA DB
Version 3 Release 1 running under control of CICS (TM) with the
IMS/ESA DB Asynchronous Change Data Capture facility will be
available through the service process prior to December 30, 1991.
DProp MVS/ESA can be running under IMS/ESA DB/TM, IMS/ESA DB batch,
DB2 CAF, or TSO.
       The requirement for taking changes made by an application
program to DB2 tables and applying these to IMS/ESA data bases is
well understood and is accepted.
 (TM) Trademark of International Business Machines Corporation.
SCHEDULE
       Planned Availability Date:  March 29, 1991.
TECHNICAL INFORMATION
SPECIFIED OPERATING ENVIRONMENT
MACHINE REQUIREMENTS:  Data Propagator MVS/ESA executes on all IBM
processors capable of running MVS/SP (TM) Version 3 or MVS/ESA SP
Version 4.
       Most Data Propagator MVS/ESA modules are loaded above the 16MB
line and can be stored, if desired, in the link pack area.
       The Data Propagator MVS/ESA virtual storage requirement for
control blocks and work areas allocated above the 16MB line can be
estimated at 30KB.
 (TM) Trademark of International Business Machines Corporation.
PROGRAMMING REQUIREMENTS:  Data Propagator MVS/ESA requires the
functions of the following programs with the appropriate
prerequisites for each program.
       The minimum release level for each product is listed; later
releases are also supported, unless stated otherwise.
o   MVS/SP JES2 Version 3 Release 1.1 (5685-001), or MVS/SP JES3
    Version 3 Release 1.1 (5685-002)
o   MVS/DFP (TM) Version 3 Release 1.1 (5665-XA3)
o   DB2 Version 2 Release 2 (5665-DB2)
o   TSO/E Version 2 Release 1 (5685-025) (MVS/ESA Version)
o   SMP/E Version 1 Release 5 (5668-949)
o   ISPF Version 2 Release 3 (5665-319) or ISPF Version 3 Release 2
    (5685-054)
o   ISPF/PDF Version 2 Release 3 (5665-317) or ISPF/PDF Version 3
    Release 2 (5665-402)
o   Assembler H Version 2 Release 1 (5668-962)
o   DFSort Version 1 Release 10 (5740-SM1), or equivalent product
o   IMS/ESA Version 3 Release 1 Database Manager (5665-408), with the
    IMS data capture user exit.  For synchronous propagation the
    IMS/ESA subsystem must be in the same MVS image as the Data
    Propagator.  For asynchronous propagation the IMS/ESA subsystem
    can be in a different MVS image than the Data Propagator.
       Optional or related programs:
o   IMS/ESA Version 3 Release 1 Database Manager (5665-408), with IMS
    asynchronous change data capture (available December 30, 1991)
o   IMS/ESA Version 3 Release 1 Transaction Manager (5665-409)
o   CICS/ESA Version 3 Release 1.1 (5685-083)
o   DXT Version 2 Release 4 (5668-788)
o   QMF/MVS Version 2 Release 4 (5668-721)
o   RACF Version 1 Release 9 (5740-XXH), or equivalent product.
 (TM) Trademark of International Business Machines Corporation.
PERFORMANCE CONSIDERATIONS:
o   The impact of the Data Propagator MVS/ESA on the IMS/ESA DB
    performance is primarily dependent on how many updates a
    transaction or batch program performs per execution and on the
    percentage of the updates to be propagated.  The main performance
    impact on updating IMS/ESA DB applications in a synchronous
    environment is the impact of the SQL calls issued by Data
    Propagator MVS/ESA for the propagation of the changed IMS/ESA DB.
    Asynchronous propagation reduces the impact on IMS/ESA DB
    applications.  The Data Propagator MVS/ESA attempts to limit the
    performance impact of the propagating SQL statements by:
    -   Using static SQL statements to propagate IMS/ESA DB changes
        to the target relational tables
    -   Using a WHERE clause of the SQL statements for columns in
        available DB2 index(es) for medium-sized and large tables,
        resulting in the scanning of the index.
    -   By utilizing the high-performance services provided by the
        Virtual Lookaside Facility (VLF) of MVS/ESA for the retrieval
        of its control blocks from a data space.  Utilization of VLF
        is designed to greatly reduce the number of SQL calls
        required to access control information located in the tables
        of the Data Propagator MVS/ESA directory.
o   The impact of Data Propagator MVS/ESA on overall system
    performance largely depends on how the system is used and on what
    role Data Propagator MVS/ESA plays on this system.
PLANNING INFORMATION
INSTALLABILITY:
       When considering the general Data Propagator MVS/ESA
environment, the following installation procedures apply:
o   The data base administrator needs to perform a DB2 table design
    for the data that will be propagated from IMS/ESA DB, and will
    need to specify how the data from IMS/ESA DB will be mapped to
    DB2.
o   Existing IMS/ESA DB application programs that issue update
    (replace, delete or insert) calls will continue to run without
    change.  The capture of the updates through the IMS data capture
    function and the subsequent propagation of the data to DB2
    through the Data Propagator MVS/ESA (DProp MVS/ESA) is
    transparent to the application program.  Users should be able to
    take advantage of the Data Propagator MVS/ESA facilities without
    having to rewrite their existing applications.  However, since
    data propagation does not support all delete rules for logical
    relationships, use of this function may require modification of
    delete rules and as a result, modification of programs using the
    modified data bases.
o   Depending on the amount and type of propagated IMS/ESA DB calls,
    additional hardware (for example, DASD, processors, real/expanded
    storage) may be required to accommodate both data bases when
    propagating changes to DB2.
o   In the case of synchronous mode of propagation, customer
    operational procedures will need to be updated to ensure that DB2
    tables corresponding to the IMS/ESA DB segments are available
    when IMS/ESA DB updates are performed to segments propagated to
    DB2.
o   All propagated DB2 tables must have a primary key.
SECURITY, AUDITABILITY AND CONTROL
       The announced program works with the security and auditability
features provided by the IMS/ESA DB and DB2 data base systems.  RACF
can be used to protect the data propagator data sets.
       Special consideration should be given to IMS/ESA DB data with
field-level sensitivity and dependent segments that are propagated as
a result of cascade delete.
       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
NEW LICENSEES
Orders for new licenses will be accepted now.  Unless a later date is
specified, orders entered prior to March 29, 1991, will be scheduled
for shipment April 5, 1991.  Orders entered after March 29, 1991,
will be scheduled for the week following order entry.
       New users of Data Propagator MVS/ESA should specify:
          TYPE           MODEL
          5685           124
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.
                             FEATURE NUMBERS
                    GRADUATED                GRADUATED
                       OTC                      MLC
      18               8765                     8761
      20               8766                     8762
      25               8767                     8763
      28               8768                     8764
      29               0101                     0105
      30               8507                     8527
      31               0102                     0106
      32               8508                     8528
      35               8509                     8529
      38               8510                     8530
      40               8511                     8531
      50               8512                     8532
      60               8513                     8533
NOTE:  The group can be determined by referring to the Exhibit for
IBM System/370 and System/390 Machines (Z125-3901) or the Exhibit for
Non-IBM Machines (Z125-3902) associated with the Agreement for IBM
Licensed Programs.
BASIC MACHINE-READABLE MATERIAL:  To order, select the feature number
of the desired distribution medium:
                              FEATURE
ENVIRONMENT                   NUMBER         DISTRIBUTION MEDIUM
Data Propagator               5861           6250 Magnetic Tape
Data Propagator               5862           3480 Tape Cartridge
       To suppress initial shipment of machine-readable materials and
publications, and for serial number assignment only, use Initial
Order Suppress feature number 3444.
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.
                             FEATURE NUMBERS
                    GRADUATED                GRADUATED
                       OTC                      MLC
      18               8773                     8769
      20               8774                     8770
      25               8775                     8771
      28               8776                     8772
      29               0103                     0107
      30               8520                     8540
      31               0104                     0108
      32               8521                     8541
      35               8522                     8542
      38               8523                     8543
      40               8524                     8544
      50               8525                     8545
      60               8526                     8546
       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 memo, program directory, and one copy of
the following publications are supplied automatically with the basic
machine-readable material:
                                                       ORDER
TITLE                                                  NUMBER
General Information                                    GC26-4735
Licensed Program Specifications                        SC26-4736
Installation Guide                                     SC26-4737
Administration Guide                                   SC26-4738
Messages and Codes                                     SC26-4739
Reference                                              SC26-4740
       Additional copies of unlicensed publications will be available
for a fee after product availability.  These copies may be ordered
from your IBM marketing representative through the System Library
Subscription Service (SLSS) or by direct order.
       All of the above publications may be ordered by using one bill
of forms number, SBOF-3568.
LICENSED DOCUMENTATION:  The following licensed material will be
available from IBM at availability.  To order, contact your IBM
marketing representative.
       The first copy is supplied automatically with the basic
machine-readable material.  Use the 8XXX feature number to order
additional copies for a fee.  Prices for licensed documentation may
be obtained from your IBM representative at availability.
                                                  ADDITIONAL
                                                    COPIES
                              ORDER                FEATURE
TITLE                         NUMBER                NUMBER
Diagnosis Guide and
  Reference                   LY27-9592              8559
       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:  The program in this announcement is licensed under the
terms and conditions of the Agreement for IBM Licensed Programs.
VARIABLE CHARGES APPLY:  Yes, for licenses obtained for a graduated
one-time charge or graduated monthly license charge.
INSTALLATION LICENSE OR LOCATION LICENSE APPLIES:  No.  A separate
license is required for each designated machine on which the licensed
program materials will be used.
USAGE LICENSE APPLIES:  No.
EDUCATIONAL ALLOWANCE:  A 15% educational allowance toward eligible
license charges is available to qualifying institutions in accordance
with the Educational Allowance Amendment.  The educational allowance
may not be added to any other discount or allowance.
VOLUME DISCOUNT:  Not applicable.
VERSION UPGRADES:  Version-To-Version Upgrade Credits apply:  Yes.
                                                       Single
 Replaced Program           Replacement Program        Version
Program      Program        Program        Program     Charging
Number       Name           Number         Name        Applies
5685-124     Data
             Propagator     To a follow-on if any      N/A
WARRANTED:  Basic license -- Yes.  DSLO -- Not applicable.
LICENSED PROGRAM MATERIALS AVAILABILITY:  Restricted Materials:  No.
This licensed program will be available without source licensed
program materials.  It will be available in object code.
TESTING PERIOD:  Basic license -- Two months.  DSLO -- Not
applicable.
PROGRAM SERVICES:  Central Service, including the IBM Support Center,
will be available until discontinued by IBM upon six months' written
notice.
       Central Service, including the IBM Support Center, for DSLO
licenses will be provided only through the customer location
designated for the basic license.
CHARGES
DATA PROPAGATOR MVS/ESA (5685-124)
             GRADUATED ONE-TIME          GRADUATED MONTHLY
                   CHARGE                  LICENSE CHARGE
    GROUP     BASIC        DSLO          BASIC        DSLO
      18   $  7,970      $ 5,977        $  166       $  124

      20     10,370        7,777           216          162
      25     13,440       10,080           280          210
      28     17,470       13,102           364          273
      29     22,750       17,062           474          355
      30     29,570       22,177           616          462
      31     38,400       28,800           800          600
      32     44,210       33,157           921          690
      35     50,880       38,160         1,060          795
      38     58,320       43,740         1,215          911
      40     67,200       50,400         1,400        1,050
      50     84,000       63,000         1,750        1,312
      60    105,100       78,825         2,190        1,642
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, an 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.
       For upgrades of one-time charge licenses to a machine in a
higher group, the upgrade charge will be the difference in the
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.