New and enhanced IBM DB2 Tools assist in management of database environments

IBM United States Software Announcement 204-201
September 14, 2004

 

 ENUS204-201.PDF (89KB)

Table of contents   Document options  
At a glance Publications
Overview Technical information
Key prerequisites Ordering information
Planned availability dates Terms and conditions
Description Prices
Offering information Order now
 
Printable version

 
At a glance

New and enhanced DB2 tools deliver:

  • Information integration
    • DB2 DataPropagator for z/OS, V8.2
    • DB2 Information Integrator Classic Federation for z/OS, V8.2
    • DB2 Information Integrator Event Publisher for DB2 Universal Database for z/OS, V8.2
    • DB2 Information Integrator Classic Event Publisher for IMS, V8.2
    • DB2 Information Integrator Classic Event Publisher for VSAM, V8.2
    • DB2 Information Integrator Replication for z/OS, V8.2
  • Utilities management
    • DB2 High Performance Unload for z/OS, V2.2
  • Performance management
    • DB2 SQL Performance Analyzer for z/OS, V2.2
  • Database administration
    • DB2 Administration Tool for z/OS, V5 PTF
    • DB2 Object Comparison Tool for z/OS, V3 PTF

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).
 
Back to top
 

Overview

Four new versions, four new releases, and service stream enhancements for two products offer many innovative features to assist database administrators (DBAs) and system programmers in managing all aspects of DB2® database environments.

New versions

  • DB2 Information Integrator Event Publisher for DB2 Universal Database® for z/OS®, V8.2
  • DB2 Information Integrator Classic Event Publisher for IMS™, V8.2
  • DB2 Information Integrator Classic Event Publisher for VSAM, V8.2
  • DB2 Information Integrator Replication for z/OS, V8.2

New releases

  • DB2 DataPropagator™ for z/OS, V8.2
  • DB2 High Performance Unload for z/OS, V2.2
  • DB2 Information Integrator Classic Federation for z/OS, V8.2
  • DB2 SQL Performance Analyzer for z/OS, V2.2

Service stream enhancements

  • DB2 Administration Tool for z/OS, V5 PTF
  • DB2 Object Comparison Tool for z/OS, V3 PTF

DB2 Information Integrator for Linux™, UNIX®, and Windows™ V8.2 is also being announced. Refer to Software Announcement 204-202 , dated September 14, 2004.

To view a complete list of the DB2 Tools, visit

The DB2 Tools business is a unique model in the industry. IBM continues to increase its investment in tools to deliver comprehensive solutions that meet requirements faster than ever before. Increased focus is on common interfaces, cross-tool integration, and testing with the same criteria used for the databases.
 
Back to top
 

Key prerequisites

Any hardware configuration that supports the required versions of DB2. Details are listed in the Hardware requirements and Software requirements sections.


 
Back to top
 

Planned availability dates

September 24, 2004

  • DB2 DataPropagator for z/OS, V8.2, 5655-I60
  • DB2 Information Integrator Event Publisher for DB2 Universal Database for z/OS, V8.2, 5655-M63
  • DB2 Information Integrator Replication for z/OS, V8.2, 5655-L88
  • DB2 SQL Performance Analyzer for z/OS, V2.2, 5655-I22

October 15, 2004

  • DB2 Information Integrator Classic Federation for z/OS, V8.2, 5697-I82
  • DB2 Information Integrator Classic Event Publisher for IMS, V8.2, 5655-M38
  • DB2 Information Integrator Classic Event Publisher for VSAM, V8.2, 5655-M35

October 29, 2004

  • DB2 High Performance Unload for z/OS, V2.2, 5655-I19


 
Back to top
 

Description

IBM first announced its entry into the database tools business in September 2000, delivering a set of 34 tools for DB2 and IMS, covering key system management functions, and committing to expand this portfolio in response to customer requirements.

This offering marks IBM's thirteenth database tools announcement in less than five years, proof of our ability to offer a broad range of tools that support DB2 and IMS databases, and to provide that support with rapid availability for each new version or release of the databases.

To view the complete list of DB2 and IMS Tools' announcements, visit

IBM now offers more than 70 tools that feature common interfaces and cross-tool integration, tested under the same configurations and workloads as the databases they support. As we enter the era of autonomic computing, DB2 and IMS Tools will become increasingly self-managed in terms of dynamically monitoring and managing data, taking responsibility for decision-making and initiating action.

To view the list of DB2 and IMS Tools, visit

IBM Tools for information integration management

DB2 Information Integrator Classic Federation for z/OS, V8.2 (5697-I82) provides SQL access to mainframe databases and files with transactional speed and enterprise scale without mainframe programming.

Using DB2 Information Integrator Classic Federation, applications can map mainframe assets into relational views, build integrated views across mainframe databases and files co-resident on a single z/OS instance, and issue SQL SELECT, INSERT, UPDATE, and DELETE from open database connectivity (ODBC), Java™ database connectivity (JDBC), or a Call Level Interface (CLI) to access them. Access to DB2 UDB, IMS, and VSAM mainframe data is provided with the base product. Three optional features are available to extend these services for Software AG Adabas as well as Computer Associates CA-Datacom and CA-IDMS data.

This new release provides double-byte character set (DBCS) support for global companies and the Asia-Pacific market, and is translated into Japanese.

More information is provided in the Supplemental information section.

DB2 DataPropagator for z/OS, V8.2 (5655-I60) provides change data capture and replication from and to DB2 UDB for z/OS databases. Plus, it interoperates with the replication capabilities built into DB2 UDB for distribution to and from DB2 UDB or Informix™ databases. And it works with DB2 Information Integrator for Linux, UNIX, or Windows for replication among a variety of relational databases from other vendors. DB2 DataPropagator leverages the SQL replication architecture that maximizes flexibility in managing scheduling, transformation, and distribution topologies efficiently and effectively for populating warehouses or marts. It maintains data consistency between disparate applications, or efficiently manages distribution and consolidation configurations involving central locations and distributed branch or retail sites.

  • The replication server supports distribution (moving data from one database to many) and consolidation (moving data from many databases to one) scenarios.
  • Data can be filtered either horizontally or vertically so that only the data you are interested in is replicated.
  • Transformation can be applied online with the data movement via standard SQL expressions or stored procedure execution.
  • Data movement can be automated on a specific schedule, at designated intervals, continuously, or event-driven.
  • Data movement can be managed table-at-a-time, such as for warehouse loading during batch windows or with transaction consistency for data which is never offline.

Administrators can use a wizard-driven GUI, command-line processor, and/or script-driven processes to configure the variety of topologies, latency, and consistency characteristics for the SQL-based architecture. Integrated monitoring and statistics make it easy for administrators to react to problems and proactively maintain health.

New in DB2 DataPropagator V8.2 are administration enhancements plus the addition of the ASNTDIFF reconciliation utility that aids administrators in evaluating the consistency between multiple copies of a table.

DB2 Information Integrator Event Publisher for DB2 Universal Database for z/OS, V8.2 (5655-M36), DB2 Information Integrator Classic Event Publisher for IMS, V8.2 (5655-M38), and DB2 Information Integrator Classic Event Publisher for VSAM, V8.2 (5655-M35) make it easy to link data events with business processes. DB2 Information Integrator Event Publisher offerings capture database changes in DB2 UDB for z/OS, IMS, or VSAM by reading the active or recovery log, format the changes into consistent relational XML messages, and publish them to WebSphere® MQ. Any application or service that integrates either with WebSphere MQ directly or supports Java Message Service (JMS) can asynchronously receive the data changes as they occur.

DB2 Information Integrator Event Publisher solutions enable database events to initiate business processes. For example, a change in an inventory value could be used to drive a product restocking workflow or the addition of a new customer could initiate welcome e-mail, credit verification, and accounting update. This creates an application-independent, loosely coupled integration that is more adaptable to changing application environments. For example, while multiple applications may impact the value of the inventory level, a single point of integration — the data items themselves — is driving the workflow. Changes to the applications that impact the inventory level can be made with no impact on the event driven integration. Business can realize faster time to market, based on integration that captures the event in a single location, is more stable, and easier to maintain.

Additionally, DB2 Information Integrator Event Publisher solutions can deliver changes to Extract, Transform, and Load (ETL) tools, or custom-built processes for updating operational data stores, or data warehouses minimizing bandwidth requirements, keeping target databases more closely in synch. Thus, businesses can utilize information that is far more current for tactical and operational decision-making.

DB2 Information Integrator Replication for z/OS, V8.2 (5655-L88) is a new offering that replicates data to and from DB2 UDB for z/OS using either the SQL-based or queue-based architectures and provides event publishing from DB2 UDB databases. (It subsumes and offers additional function over and above DB2 DataPropagator for z/OS and DB2 Information Integrator Event Publisher for DB2 Universal Database for z/OS.) Plus, it interoperates with DB2 UDB built-in replication for distribution to and from DB2 UDB or Informix databases, or with DB2 Information Integrator for Linux, UNIX, or Windows for replication among a variety of relational databases from third-party vendors.

The SQL-based replication architecture (also available with DB2 DataPropagator) maximizes flexibility in managing scheduling, transformation, and distribution topologies efficiently and effectively for populating warehouses or marts, maintaining data consistency between disparate applications, or efficiently managing distribution, and consolidation scenarios among headquarter and branch or retail configurations.

  • The replication server supports distribution (moving data from one database to many) and consolidation (moving data from many databases to one) scenarios.
  • Data can be filtered either horizontally or vertically so that only the data you are interested in is replicated.
  • Transformation can be applied inline with the data movement via standard SQL expressions or stored procedure execution.
  • Data movement can be automated on a specific schedule, at designated intervals, continuously, or event-driven.
  • Data movement can be managed table-at-a-time such as for warehouse loading during batch windows or with transaction consistency for data which is never offline.

For DB2 UDB only applications, DB2 Information Integrator Replication for z/OS introduces new queue-based replication architecture for low-latency, high-throughput replication with managed conflict detection and resolution to support business continuity, workload distribution, and application integration scenarios.

  • Committed changes are published to a WebSphere MQ message queues. A sophisticated apply engine determines transaction dependencies and replay transactions on target systems to maximize parallelism and minimize latency.
  • A rich set of conflict detection and resolution algorithms are available in order to allow backup systems to do productive work or so that application workload can be distributed across multiple servers. Both value-based and version-based algorithms are provided.
  • Data can be filtered so that only the data of interest is replicated.
  • Stored procedures can be invoked by the apply engine on a row basis in order to facilitate transformations for application integration scenarios. Automatic and high-performance load options are integrated allowing data to be loaded at the same time data is being replicated.

DB2 Information Integrator Replication for z/OS makes it easy to link data events with business processes. It captures database in DB2 UDB by reading the recovery log, formats the changes into XML messages, and publishes them to WebSphere MQ. Any application or service that integrates either with WebSphere MQ directly or supports JMS can asynchronously receive the data changes as they occur. For example, using DB2 Information Integrator's event publishing capability, WebSphere Business Integration can receive changes as they occur from a DB2 UDB database and automatically update an SAP application. Alternatively, a JMS-aware application or a service within any Java 2 Platform, Enterprise Edition (J2EE) Server (that is, BEA WebLogic or WebSphere Application Server) could receive those same changes and perform additional processing or integration.

  • Data can be formatted into either transaction messages or row messages depending upon application need.
  • Database changes being published can be filtered such that only the data that the receiving application is interested in are published.
  • Messages can be tailored to include only the changed data that the application requires.

Administrators can use a wizard-driven GUI, command-line processor, and/or script-driven processes to configure the variety of topologies, latency, and consistency characteristics for both SQL-based and queue-based architectures as well as for event publishing. Integrated monitoring and statistics make it easy for administrators to react to problems and proactively maintain health.

Trade-ups to DB2 Information Integrator Replication for z/OS, V8.2 (5655-L88) are available from:

  • DB2 DataPropagator for z/OS, V8.1 and V8.2 (5655-I60)
  • DB2 Information Integrator Event Publisher for DB2 Universal Database for z/OS, V8.2 (5655-M36)

IBM Tools for utilities management

DB2 High Performance Unload for z/OS, V2.2 (5655-I19)

  • Supports DB2 V8
  • Includes the following enhancements:
    • The ability to specify:
      • Target table name
      • Table to be loaded with the CREATOR specification
    • Support for launch of DB2 High Performance Unload with SSID
    • Ability to override user-defined record length on unload
    • Support for an ISPF interface job card
    • Compatibility is provided with Fast Unload for DB2 from Computer Associates for:
      • Use of C'CONSTANT' in the SYSIN for fixed length strings
      • Writing multiple SELECTs to a single output file
      • Option to delimit dates, times, and timestamps with quotes
  • DB2 High Performance Unload for Multiplatforms V2.2 is a cross-platform offering. Refer to Software Announcement 204-204 , dated September 14, 2004.

IBM Tools for performance management

DB2 SQL Performance Analyzer for z/OS, V2.2 (5655-I22) includes the following enhancements:

  • Seamless support for DB2 V7 and V8
  • Full exploitation of DB2 V8 features
  • Redesigned and enhanced reports
  • WLM stored procedures
  • Other improvements

The enhancements are described in the Supplemental information section.

IBM Tools for database administration

DB2 Administration Tool for z/OS, V5 (5697-K90) PTF

  • Refer to APAR number PQ89787
  • Available since August 31, 2004
  • Usability is improved:
    • On the databases panel, a new line command allows you to list the first level views that are defined on tables in the database.
    • A new primary command has been added to the User Authorization (UA) option to allow you to revoke all explicitly granted and directly held authorizations and privileges from all listed grantees. If the generated SQL statement is greater than 32,765 characters, you can choose to create a batch job with the statements or add the statements to a work statement list. This enhancement also aids migration.
    • Unique utility IDs (UIDs) are created during JCL generation for utility access. The ability to customize UIDs by utility type is also supported. With this feature, more DB2 utility jobs can be run in parallel.
    • The Alter Columns (ALC) process has the following enhancements:
      • When the primary key is changed or a row identifier (ROWID) added, you can create or recreate the table index.
      • Parallel UNLOAD and LOAD of a partitioned table can be performed (DB2 V7, or later).
      • Additional utilities options are now available that can be performed after an ALTER.
  • Integrity is improved during CHECK DATA processing in a work statement list (WSL). Whenever a CHECK DATA utility statement occurs, CHECK DATA will be performed for:
    • The changed table
    • All dependent tables that are in CHECK-pending status
  • Installation and customization are improved:
    • The restriction of allowing only two data sets in the DB2 Load Library parameter is removed.
    • Multiple data set names can be specified during customization for both DB2 Administration Tool and DB2 Object Comparison Tool.

DB2 Object Comparison Tool for z/OS, V3 (5697-K40) PTF

  • Refer to APAR number PQ89788.
  • Available since August 31, 2004.
  • Must be installed with DB2 Administration Tool for z/OS, V5 (5697-K90) with APAR number PQ89787.
  • Usability is improved. A new option is provided on a COMPARE Work Statement list to combine all Creates, Drops, Unloads, Reloads, and Utilities into a single Apply job. This option allows you to specify whether multiple jobs will be generated. Before the availability of the new option, multiple jobs were always generated.
  • Integrity is improved during CHECK DATA processing in a WSL. Whenever a CHECK DATA utility statement occurs, CHECK DATA will be performed for:
    • The changed table
    • All dependent tables that are in CHECK-pending status
  • Installation and customization are improved:
    • The restriction of allowing only two data sets in the DB2 Load Library parameter is removed.
    • Multiple data set names can be specified during customization for both DB2 Administration Tool and DB2 Object Comparison Tool.

Section 508 of the U.S. Rehabilitation act

The products in this announcement are capable as of their planned availability, when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it.

Value Unit-based pricing

Value Unit pricing for eligible zSeries® International Program License Agreement (IPLA) programs enables a lower cost of incremental growth and enterprise aggregation. Each zSeries IPLA product with Value Unit pricing has a single price per Value Unit and a conversion matrix, called Value Unit Exhibit, for converting from some designated measurement to Value Units. Most commonly, Millions of Service Units (MSUs) is the measurement designated by IBM to be converted to Value Units. Some other measurements are engines or messages. Since MSUs are the most common measurement, that measurement will be used for the remainder of this description.

Value Unit pricing offers price benefits for customers. For each zSeries IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the "required license capacity." Each of the various Value Unit Exhibits stipulates that the larger your required license capacity, the fewer Value Units per MSU you will need. Value Unit Exhibits are uniquely identified by a three digit code and referred to using the nomenclature VUExxx, where xxx is the three digit code.

Subsequent acquisitions of Value Unit priced programs offers additional price benefits for customers. The quantity of each zSeries IPLA program that you have acquired is referred to as "entitled license capacity." If you wish to grow your entitled license capacity for a zSeries IPLA program, the calculation to determine additional needed Value Units is based upon the number of Value Units already acquired.

For each zSeries IPLA program with Value Unit pricing, you should:

  • Determine the required license capacity in MSUs
  • Aggregate the MSUs across the enterprise
  • Convert the total MSUs to Value Units using the applicable Value Unit Exhibit, and
  • Multiply the price per Value Unit by the total number of Value Units to determine the total cost.

To simplify conversion from the designated measurement to VUs or vice-versa, use the Value Unit Converter Tool. For additional information or to obtain a copy of the Value Unit Converter Tool, visit the Value Unit Converter Tool Web site

Note that Value Units of a given product cannot be exchanged, interchanged, or aggregated with Value Units of another product.

To determine the applicable Value Unit Exhibit for the zSeries IPLA program you selected, refer to the Ordering information section.

IPLA and Subscription and Support considerations

IPLA licenses can be transferred from one machine to another within, but not limited to an enterprise. The customer may aggregate the capacity for all the processors the product is operated on to achieve a more economic price. This will result in a single Proof of Entitlement. It is the customer's responsibility to manage the distribution of Value Units within the limits of the entitlement of the product license.

Subscription and Support must cover the same capacity as the product license entitlement. Subscription and Support will be available in the country in which the agreement is made.

Trademarks

 
IMS, DataPropagator, and Informix are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DB2 Universal Database, z/OS, WebSphere, and zSeries are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows is a trademark of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both
 
Other company, product, and service names may be trademarks or service marks of others.

IBM Tools for information integration management

DB2® Information Integrator Classic Federation for z/OS®, V8.2 (5697-I82)

The three optional features that provide support for Software AG Adabas and Computer Associates CA-Datacom and CA-IDMS data are:

  • DB2 Information Integrator Connector for Software AG Adabas
  • DB2 Information integrator Connector for CA-Datacom
  • DB2 Information Integrator Connector for CA-IDMS

SQL-literate tools, and application developers are productive immediately. They can integrate mainframe data into everything from a simple read-oriented customer self-service Web site to a complex multi-database read/write e-commerce site.

DB2 Information Integrator Classic Federation maps a logical relational table structure over existing physical databases. UNIX®, Windows™, and Linux™ tools, and applications issue standard SQL commands to these logical tables. Behind the scenes, DB2 Information Integrator Classic Federation dynamically generates native data access commands that are optimized for each database and file type. Results are automatically translated and reformatted into relational rows and columns providing seamless integration of all mainframe data assets without proprietary programming.

With 60% of structured business data residing on the mainframe, mainframe data access is important to the success of many of today's business-critical IT initiatives including:

  • Delivering mainframe operational data to customer self-service Web sites
  • Connecting e-commerce sites with mainframe inventory data
  • Integrating business intelligence systems in real time with mainframe accounting data
  • Connecting an enterprise portal to mainframe HR data

DB2 Information Integrator Classic Federation can also extend IBM DB2 Information Integrator V8.2 (5724-C74) to include access to non-relational mainframe data sources. DB2 Information Integrator lets applications access diverse and distributed data, including multi-vendor mainframe and distributed, structured and unstructured, public and private, as if it were a single database.

The benefits of DB2 Information Integrator Classic Federation V8.2 include:

  • Extending the value of existing mainframe investments. Rather than ripping out and replacing mainframe assets, clients can extend these investments to deliver new business applications or integrate business operations.
  • Reducing time-to-value for integration projects that require mainframe data by eliminating proprietary coding and multiplatform development, and automating complex multi-source integration.
  • Minimizing dependence on scarce legacy data skills by empowering non-mainframe staff to automatically leverage legacy data sources without investing in the proprietary skills associated with these data sources.
  • Empowering IT to rapidly deliver information rich-business solutions that present up-to-the second information, rather than stale copied data.

DB2 Information Integrator Classic Federation can be used as a stand-alone solution or in conjunction with DB2 Information Integrator V8.2.

IBM Tools for performance management

DB2 SQL Performance Analyzer, V2.2 (5655-I22) enhancements include:

  • Seamless support for DB2 V7 and V8. DB2 SQL Performance Analyzer operates in DB2 V7 and V8 environments. You do not have to wait until DB2 V8 migration time to install and use this version of DB2 SQL Performance Analyzer. The product automatically detects the current DB2 version and behaves accordingly. The majority of enhancements, including the redesigned reports and streamlined processing, are benefits intended for all users.
  • Full exploitation of DB2 V8 features. This release of DB2 SQL Performance Analyzer contains full support for DB2 V8. It handles the new V8 catalog, including longer column names, new values, and new columns, in either Unicode or EBCDIC. The product recognizes and reports table and index "versioning", "volatile" tables, MQTs, DPSIs, and other DB2 V8-specific enhancements. DBRM modules in Unicode or EBCDIC are handled and processed in both DB2 V8 Compatibility and New Function Modes. Parser support for DB2 V8 includes SQL enhancements, such as:
    • Insert within select
    • Multi-row fetch and insert
    • Parallel sorts
    • Long predicates
    • Stage 1 indexable predicates for mixed data types
    • Inserts and updates with qualified column names
    • Grouping expressions for sort
    • Multiple distinct sort
    • Full scalar selects in expressions
    • Common table expressions
    • Recursive SQL
    • Dynamic scrollable cursors
  • Redesigned and enhanced reports. DB2 SQL Performance Analyzer reports have been redesigned to make the data and content more readable and to handle the larger column values supported in DB2 V8.
    • SQL Advisor messages are now neatly boxed and easy to locate.
    • An optional predicate analysis section has been added to the reports, detailing the optimizer's evaluation of each predicate.
    • The QLIMIT report has added columns for DBRM Member and Rejection Reason (DB2 Path Checker).
    • All reports have headers with time and date, plus additional information.
    • Other improvements are provided in the data content. For example, more information on index column cardinality for both selected and alternate indexes is included in the body of the reports.
  • Workload Manager stored procedures. The SQL Performance Analyzer stored procedure, which formerly ran under control of the DB2 stored procedure address space (DB2SPAS) and CAF, has been redesigned to run under the z/OS Workload Manager (WLM) and RRSAF. DB2 V8 discourages support for DB2-managed stored procedures in favor of WLM control. Both CAF and RRSAF operation under DB2 V7 are provided.
  • Other improvements. Improvements in operation, parameterization, ease of use, flexibility, and self-diagnosis are provided in this release.

 
Back to top
 
Offering information

Product information is available via the Offering Information Web site


 
Back to top
 
Publications

The IBM Publications Center portal is at

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card or customer number. A large number of publications are available online in various file formats. They can all be downloaded free of charge.

The IBM Publications Notification System (PNS) portal is at

The PNS enables subscribers to set up profiles of interest by order number/product number. PNS subscribers automatically receive notifications by e-mail of all new publications defined in their profiles. These may then be ordered/downloaded via the Publications Center.

One copy of the following publications is supplied automatically with the basic machine-readable material.

                                                       Order
Title                                                  number
 
DB2 DataPropagator(TM) for z/OS, V8.2
 (5655-I60)
  License Information                                  GC18-9331
  Program Directory                                    GI10-8653
 
DB2 High Performance Unload for z/OS,
 V2.2 (5655-I19)
  License Information                                  GC27-1597
  Program Directory                                    I10-8452
 
DB2 Information Integrator Classic
 Federation for z/OS, V8.2 (5697-I82)
  DB2 Information Integrator Installation              GC18-9301
   Guide for Classic Federation and
   Classic Event Publishing
  License Information                                  GC18-9322
  Program Directory                                    GI10-8602
 
DB2 Information Integrator Event
 Publisher for DB2 Universal Database
 for z/OS, V8.2 (5655-M36)
  License Information                                  GC18-9324
  Program Directory                                    GI10-8604
 
DB2 Information Integrator Classic
 Even Publisher for IMS(TM), V8.2 (5655-M38)
  DB2 Information Integrator Installation              GC18-9301
   Guide for Classic Federation and
   Classic Event Publishing
  License Information                                  GC18-9325
  Program Directory                                    GI10-8605
 
DB2 Information Integrator Classic Event
 Publisher for VSAM, V8.2 (5655-M35)
  DB2 Information Integrator Installation              GC18-9301
   Guide for Classic Federation and
   Classic Event Publishing
  License Information                                  GC18-9323
  Program Directory                                    GI10-8603
 
DB2 Information Integrator Replication
 for z/OS, V8.2 (5655-L88)
  License Information                                  GC18-9330
  Program Directory                                    GI10-8652
 
DB2 SQL Performance Analyzer
 for z/OS, V2.2 (5655-I22)
  License Information                                  GC27-1600
  Program Directory                                    GI10-8455

The following publications cannot be ordered in hardcopy . The publications are made available on the Web at

Publications on CD-ROM for the products in this announcement will be available on the next release of z/OS Software Products Collection (SK3T-4270), BookManager®, and PDF formats.

                                                       Order
Title                                                  number
 
DB2 DataPropagator for z/OS, V8.2
 (5655-I60)
 
DB2 Information Integrator Administering               SC18-9410
 DB2 Replication using the ASNCLP Program
 
                                                       Order
Title                                                  number
 
DB2 Information Integrator Tuning for SQL              SC18-9411
 Replication Performance
DB2 Information Integrator Migrating to                SC18-9413
 SQL Replication Version 8
DB2 Information Integrator Introduction                GC18-7567
 to Replication and Event Publishing
DB2 Information Integrator Replication                 SC18-9127
 Installation and Customization Guide
 for z/OS
DB2 Information Integrator SQL                         SC27-1121
 Replication Guide and Reference
DB2 Universal Database(R) Message                      GC09-4840
 Reference, Volume 1
 
DB2 High Performance Unload for z/OS,
 V2.2 (5655-I19)
 
User's Guide                                           SC27-1602
 
DB2 Information Integrator Classic
 Federation for z/OS, V8.2 (5697-I82)
 
DB2 Information Integrator Client Guide                SC18-9160
 for Classic Federation and Classic
 Event Publishing
DB2 Information Integrator Data Mapper                 SC18-9163
 Guide for Classic Federation and
 Classic Event Publishing
DB2 Information Integrator Installation                GC18-9301
 Guide for Classic Federation and
 Classic Event Publishing
DB2 Information Integrator Reference for               SC18-9156
 Classic Federation and Classic Event
 Publishing
DB2 Information Integrator System                      SC18-9162
 Messages for Classic Federation and
 Classic Event Publishing
DB2 Information Integrator Getting                     GC18-9155
 Started with Classic Federation
DB2 Information Integrator Transaction                 SC18-9161
 Services Guide for Classic Federation
 
DB2 Information Integrator Event
 Publisher for DB2 Universal Database for
 z/OS, V8.2 (5655-M36)
 
DB2 Information Integrator Administering               SC18-9410
 DB2 Replication using the ASNCLP Program
DB2 Information Integrator Tuning for                  SC18-9289
 Replication and Event Publishing
 Performance
DB2 Information Integrator Introduction                GC18-7567
 to Replication and Event Publishing
DB2 Information Integrator Replication                 SC18-7568
 and Event Publishing Guide and Reference

DB2 Information Integrator Classic Event Publisher for IMS, V8.2 (5655-M38)

DB2 Information Integrator Classic Event Publisher for VSAM, V8.2 (5655-M35)

These products are supported by the following publications.

                                                       Order
Title                                                  number
 
DB2 Information Integrator Client Guide                SC18-9160
 for Classic Federation and Classic
 Event Publishing
 
                                                       Order
Title                                                  number
 
DB2 Information Integrator Data Mapper                 SC18-9163
 Guide for Classic Federation and
 Classic Event Publishing
DB2 Information Integrator Installation                GC18-9301
 Guide for Classic Federation and
 Classic Event Publishing
DB2 Information Integrator Reference for               SC18-9156
 Classic Federation and Classic Event
 Publishing
DB2 Information Integrator System                      SC18-9162
 Messages for Classic Federation and
 Classic Event Publishing
DB2 Information Integrator Getting                     GC18-9186
 Started with Classic Event Publishing
DB2 Information Integrator Operations                  SC18-9157
 Guide for Classic Event Publishing
DB2 Information Integrator Planning                    SC18-9158
 Guide for Classic Event Publishing
 
DB2 Information Integrator Replication
 for z/OS, V8.2 (5655-L88)
 
DB2 Information Integrator SQL                         SC27-1121
 Replication Guide and Reference
DB2 Information Integrator Replication                 SC18-7568
 and Event Publishing Guide and Reference
DB2 Information Integrator Introduction                GC18-7567
 to Replication and Event Publishing
DB2 Information Integrator Replication                 SC18-9127
 Installation and Customization Guide
 for z/OS
DB2 Information Integrator Administering               SC18-9410
 DB2 Replication using the ASNCLP Program
DB2 Information Integrator Tuning for                  SC18-9411
 SQL Replication Performance
DB2 Information Integrator Tuning for                  SC18-9289
 Replication and Event Publishing
 Performance
DB2 Information Integrator Migrating to                SC18-9413
 SQL Replication Version 8
DB2 Universal Database Message                         GC09-4840
 Reference, Volume 1
 
DB2 SQL Performance Analyzer for z/OS,
 V2.2 (5655-I22)
 
User's Guide                                           SC27-1605
Install Guide                                          SC27-1625

The following material is available on the Web at

  • Overview brochure: IBM DB2 and IMS Tools (GC27-1070)
  • Fact sheets
    • DB2 DataPropagator for z/OS, V8.2 (GC18-7190)
    • DB2 High Performance Unload for z/OS, V2.2 (GC27-1047)
    • DB2 Information Integrator Classic Federation for z/OS, V8.2 (GC18-9189)
    • DB2 Information Integrator Replication and Event Publisher for z/OS, V8.2 (SC18-9403)
    • DB2 Information Integrator Classic Federation and Classic Event Publisher, V8.2 (SC18-9404)
    • DB2 SQL Performance Analyzer for z/OS, V2.2 (GC27-1038)

Specification Sheets, User's Guides, and White Papers are also available on CD-ROM (GK3T-7099). This CD-ROM can be ordered from the IBM Publications Center Portal.

The IBM Publications Center portal is at


 
Back to top
 
Technical information

Specified operating environment

Hardware requirements

The products in this announcement will operate on any hardware configuration that supports the required versions of DB2.

Software requirements

DB2 Information Integrator Classic Federation for z/OS, V8.2 (5697-I82) software requirements are determined by the type of data that it will be accessing:

  • DB2 access requires DB2 V6 (5645-DB2) or DB2 V7 (5675-DB2).
  • IMS/DB access requires IMS V7 (5655-B01).
  • Software AG Adabas access requires the DB2 Information Integrator Connector for Software AG Adabas (feature 5832) and ADABAS V7.
  • CA-Datacom/DB access requires the DB2 Information Integrator Connector for CA-Datacom (feature 5832) and Datacom V10.
  • CA-IDMS access requires the DB2 Information Integrator Connector for CA-IDMS (feature 5822) and CA-IDMS V14 or V15.

DB2 Information Integrator Classic Event Publisher for IMS, V8.2 requires IMS V7 (5655-B01).

DB2 Information Integrator Classic Event Publisher for VSAM, V8.2 requires CICS® Transaction Server for z/OS, V2.2, or V2.3 (5697-E93).

The other products in this announcement require DB2 V7 (5675-DB2) or DB2 V8 (5625-DB2).

Customer requirements are used extensively to determine how the database tools evolve.

DB2 Administration Tool for z/OS, V5 (5697-K90) PTF (APAR number PQ89787) satisfies the following requirements:

          MR0317031359                     MR0804033029
          MR0919036829                     MR1112035452
          MR0605036842                     MR0919035836
          MR1110036637                     MR1127026816

DB2 High Performance Unload for z/OS, V2.2 (5655-I19) satisfies the following requirements:

          MR0831033643                     MR1202026546
          MR0228033107                     MR0228034836
          MR0218035830                     MR0923035735
          MR0606033313                     MR0804037045
          MR0923031932                     MR092303150

DB2 Object Comparison Tool for z/OS, V3 (5697-K40) PTF (APAR number PQ89788) satisfies the following requirements:

          MR0218032046                     MR0703036837
          MR111203303                      MR1227024930
          MR0304031851                     MR0929031914
          MR1115023615

DB2 SQL Performance Monitor for z/OS, V2.2 (5655-I22) satisfies the following requirements:

          MR0716034523                     MR0702044136
          MR1122025256                     MR071503647
          MR0118026223                     MR0811034829
          MR0716033651                     MR0715036234
          MR100102359                      MR0603023832

Planning information

Packaging

The programs in this announcement are distributed with the following content:

  • Basic machine-readable material on tape
  • Program Directory
  • Proof of Entitlement (PoE)
  • IBM International Program License Agreement (IPLA)

DB2 Connect® Personal Edition on CD-ROM (LCD4-7357) is shipped with:

  • DB2 Information Integrator Replication for z/OS, V8.2 (5655-L88)
  • DB2 Information Integrator Event Publisher for DB2 UDB for z/OS, V8.2 (5655-M36)
  • DB2 DataPropagator for z/OS, V8.2 (5655-I60)

Security, auditability, and control

The announced programs use the security and auditability features of the host operating system software. The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
 
Back to top
 

Ordering information

For each zSeries® IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the "required license capacity". Your required license capacity is based upon the following factors:

  • The zSeries IPLA program you select
  • The applicable Value Unit Exhibit
  • The applicable terms
  • Whether your current mainframes are full capacity or sub-capacity

To determine the required license capacity for the zSeries IPLA program you selected, refer to the Terms and conditions section.

The products in this announcement have one charge unit: Value Unit.

Note that Value Units of a given product cannot be exchanged, interchanged, or aggregated with Value Units of another product.

                                                         Value
Program                                                  Unit
number         Program name                              Exhibit
 
5655-I19       DB2 High Performance Unload               VUE007
                for z/OS, V2.2
 
5655-I60       DB2 DataPropagator for                    VUE007
                z/OS, V8.2
 
5697-I82       DB2 Information Integrator                VUE007
                Classic Federation for
                z/OS, V8.2
 
5655-M38       DB2 Information Integrator                VUE007
                Classic Event Publisher
                for IMS, V8.2
 
5655-M35       DB2 Information Integrator                VUE007
                Classic Event Publisher
                for VSAM, V8.2
 
5655-M36       DB2 Information Integrator                VUE007
                Event Publisher for DB2
                Universal Database for z/OS, V8.2
 
5655-L88       DB2 Information Integrator                VUE007
                Replication for z/OS, V8.2
 
5655-I22       DB2 SQL Performance                       VUE007
                Analyzer for z/OS, V2.2

Value Unit Exhibit VUE007

                                                          Value
                  MSUs                MSUs                Units/
                  minimum             maximum             MSU
 
Base                1                   3                 1
Tier A              4                  45                 0.45
Tier B             46                 175                 0.36
Tier C            176                 315                 0.27
Tier D            316                   +                 0.2

Value Units for mainframes without MSU ratings:

                                                Value
                                                Units/
          Hardware                              Machine
 
          MP3000 H30                             6
          MP3000 H50                             8
          MP3000 H70                            12
          ESL Models                             2

Ordering example: The total number of Value Units is calculated according to the following example. If your required license capacity is 1,500 MSUs for your selected zSeries IPLA product the applicable Value Units would be:

Translation from MSUs to Value Units

                                     Value
                                     Units/               Value
              MSUs          *        MSU          =       Units
 
Base              3         *        1.00         =         3.00
Tier A           42         *         .45         =        18.90
Tier B          130         *         .36         =        46.80
Tier C          140         *         .27         =        37.80
Tier D        1,185         *         .20         =       237.00
 
Total         1,500                                       343.50

When calculating the total number of Value Units, the sum is to be rounded up to the next integer.

Example: In the above ordering example, for the product running on a machine with 1,500 MSUs requiring 344 Value Units, order feature number 0001, quantity 94, and feature number 0002, quantity 1.

Ordering z/OS through the Internet

ShopzSeries (formerly SHOPS390) provides an easy way to plan and order your z/OS ServerPac or CBPDO. It will analyze your current installation, determine the correct product migration, and present your new configuration based on z/OS. Additional products can also be added to your order (including determination of whether all product requisites are satisfied). ShopzSeries is available in the U.S. and several countries in Europe. In countries where ShopzSeries is not available yet, contact your IBM representative (or Business Partner) to handle your order via the traditional IBM ordering process. For more details and availability, visit the ShopzSeries Web site at

The products in this announcement have one charge unit — Value Units.

Basic license: To order, specify the program number, feature number 9001 for asset registration, and the one-time charge (OTC) feature number. Also specify the feature number of the desired distribution medium. To suppress shipment of media, select the license-only option in CFSW.

Three medium feature numbers have changed for DB2 Information Integrator Classic Federation for z/OS, V8.2 (5697-I82) to facilitate shipment from SDF rather than from the development lab. The remaining ordering information for these products has not changed.

                                   Medium feature
                                       number
Description                        Old       New          Medium
 
DB2 Information Integrator         6722      5832         Tape
 Connector for Software AG
 Adabas
 
DB2 Information integrator         6723      5822         Tape
 Connector for CA-Datacom
 
DB2 Information Integrator         6724      5812         Tape
 Connector for CA-IDMS

The ordering information for the following products has not changed.

Product name                                            PID
 
DB2 DataPropagator for z/OS, V8.2                       5655-I60
Subscription and Support for DB2                        5655-E80
 DataPropagator
 
DB2 High Performance Unload for z/OS,                   5655-I19
 V2.2
Subscription and Support for DB2 High                   5655-E89
 Performance Unload
 
Subscription and Support for DB2                        5697-I83
 Information Integrator Federation
 
DB2 SQL Performance Analyzer for z/OS,                  5655-I22
 V2.2
Subscription and Support for DB2 SQL                    5655-E97
 Performance Analyzer

The ordering information for the other products in this announcement follows:

Program    Entitlement                           License option/
PID        identifier    Description             Pricing metric
 
5655-M36   S01190M       DB2 Information         Use-Based OTC,
                          Integrator Event        Per Value Unit
                          Publisher for DB2       On/Off Capacity
                          Universal Database      on Demand
                          for z/OS, V8.2          (OOCoD), TUC
 
5655-M38   S01190C       DB2 Information         Use-Based OTC,
                          Integrator Classic      Per Value Unit
                          Event Publisher         OOCoD, TUC
                          for IMS, V8.2
 
5655-M35   S011909       DB2 Information         Use-Based OTC,
                          Integrator Classic      Per Value Unit
                          Event Publisher         OOCoD, TUC
                          for VSAM, V8.2
 
5655-L88   S0118Z5       DB2 Information         Use-Based OTC,
                          Integrator Replication  Per Value Unit
                          for z/OS, V8.2          OOCoD, TUC

Subscription and Support

To receive voice technical support via telephone during normal business hours, and future releases and versions at no additional charge, Subscription and Support must be ordered. The capacity of Subscription and Support (Value Units) must be the same as the capacity ordered for the product licenses.

To order, specify the support program number and feature number 9001 for asset registration. IBM is also providing Subscription and Support for these products via a separately purchased offering under the terms of the IBM International Agreement for Acquisition of Support (IAAS). This offering:

  • Includes and extends the support services provided in the base support to include technical support via telephone during normal business hours.
  • Entitles customers to future releases and versions at no additional charge. Note that the customer is not entitled to new products.

When Subscription and Support is ordered, the charges will renew automatically annually unless cancelled by the customer.

Subscription and Support (S&S)

Program    Entitlement                           License option/
PID        identifier    Description             Pricing metric
 
5655-M50   S01190N       DB2 Information         SW Subscription and
                          Integrator Event       Support ASC Decline
                          Publisher for DB2      SW S&S No Charge
                          Universal Database     SW S&S Registration
                          for z/OS S&S           No Charge
 
5655-M49   S01190B       DB2 Information         SW Subscription and
                          Integrator Classic     Support ASC Decline
                          Event Publisher        SW S&S No Charge
                          for IMS S&S            SW S&S Registration
                                                 No Charge
 
5655-M51   S011908       DB2 Information         SW Subscription and
                          Integrator Classic     Support ASC Decline
                          Event Publisher        SW S&S No Charge
                          for VSAM S&S           SW S&S Registration
                                                 No Charge
 
5655-M82   S0118Z6       DB2 Information         SW Subscription and
                          Integrator             Support ASC Decline
                          Replication            SW S&S No Charge
                          for z/OS S&S           SW S&S Registration
                                                 No Charge

Single version charging: To elect single version charging, the customer must notify and identify to IBM the prior program and replacement program as well as the machine on which the programs are operating.

Customized Offerings

Product media is shipped only via Customized Offerings (for example, CBPDO, ServerPac, SystemPac®). Non-customized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product.
 
Back to top
 

Terms and conditions

For each zSeries IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the "required license capacity". Your required license capacity is based upon the following factors:

  • The zSeries IPLA program you select
  • The applicable Value Unit Exhibit
  • The applicable terms
  • Whether your current mainframes are full-capacity or sub-capacity

For more information on the Value Unit Exhibit for the zSeries IPLA program you selected, refer to the Ordering information section.

Licensing: IBM IPLA. Proofs of Entitlement (PoE) are required for all authorized use.

These products are licensed under the IPLA, the associated Agreement for Acquisition of Support, and the Addendum for Support (Z125-6336), which offer support with ongoing access to releases and versions of the program. These programs have a one-time license charge for use of the program and an ongoing recurring charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours) and access to updates, releases, and versions of the program as long as support is in effect. IBM Operational Support Services — Support Line for S/390® and zSeries is an option for customers who want added services.

Limited warranty applies: Yes

Warranty: This program has warranty for a minimum of one year from acquisition from IBM or authorized IBM Business Partner. The warranty provided to the customer, for at least one year from acquisition, is access to databases (read Web sites) for program information and FAQs, including any known fixes to defects, which the customer can download or obtain otherwise and install at leisure.

Program support: Enhanced support, called Subscription and Support, includes telephone assistance (voice support for defects during normal business hours) as well as access to updates, releases, and versions of the program as long as support is in effect. The customer will be notified of discontinuance of support with 12 months' notice.

Money-back guarantee: If for any reason you are dissatisfied with the program, return it within 30 days from the invoice date, to the party (either IBM or its reseller) from whom you acquired it, for a refund. This applies only to your first acquisition of the program.

Copy and use on home/portable computer: No

Volume orders (IVO): No

Passport Advantage® applies: No

Software Maintenance applies: No

For Operating System software, the revised IBM Operational Support Services — SoftwareXcel offering will provide support for those operating systems and associated products that are not available with the newly announced Software Maintenance offering. This will ensure total support coverage for your enterprise needs, including IBM and selected non-IBM products. For complete lists of products supported under both the current and revised SoftwareXcel offering, visit

For additional information on the revised IBM Operational Support Services, refer to Services Announcement 601-023 , dated July 10, 2001.

IBM operational support services — SoftwareXcel: Yes

AIX®/UNIX Upgrade Protection applies: No

Entitled Upgrade for current AIX/UNIX Upgrade Protection licensees: No

iSeries™ Software Subscription applies: No

Variable charges apply: No

Educational allowance available: Yes, 15% education allowance applies to qualified education institution customers.

    Replaced programs                        Replacement program
Program                                  Program
number    Program name                   number    Program name
 
5622-267  DataPropagator Relational      5655-I60  DB2 DataPropagator
          Apply for MVS(TM)                        for z/OS, V8.2
 
5645-DB2  DB2 UDB Server for OS/390(R),  5655-I60  DB2 DataPropagator
          V6 (DB2 DataPropagator                   for z/OS, V8.2
          Apply feature)
 
5645-DB2  DB2 UDB Server for OS/390,     5655-I60  DB2 DataPropagator
          V6 (DB2 DataPropagator                   for z/OS, V8.2
          Capture feature)
 
5655-A22  DataPropagator Relational      5655-I60  DB2 DataPropagator
          Apply for MVS, V5                        for z/OS, V8.2
 
5655-A23  DataPropagator Relational      5655-I60  DB2 DataPropagator
          Capture for MVS, V5                      for z/OS, V8.2
 
5622-276  DataPropagator Relational      5655-I60  DB2 DataPropagator
          Apply for MVS                            for z/OS, V8.2
 
5655-076  DataPropagator Relational      5655-I60  DB2 DataPropagator
          Capture for MVS                          for z/OS, V8.2
 
5697-F44  DB2 High Performance           5655-I19  DB2 High
          Unload for z/OS                          Performance Unload
                                                   for z/OS, V2.2

                       Program                      Parents
Program name           number    Terms              if applicable
 
DB2 High Performance   5655-I19  Referenced-based   DB2 V7 (5675-DB2)
Unload for z/OS, V2.2                               or
                                                    DB2 V8 (5625-DB2)
 
DB2 DataPropagator     5655-I60  Referenced-based   DB2 V7 (5675-DB2)
for z/OS,V8.2                                       or
                                                    DB2 V8 (5625-DB2)
 
DB2 Information        5697-I82  Full-machine-based NA
Integrator Classic
Federation for
z/OS, V8.2
 
DB2 Information        5655-M38  Referenced-based   IMS V7 (5655-B01)
Integrator Classic
Event Publisher
for IMS, V8.2
 
DB2 Information        5655-M35  Full-machine-based NA
Integrator Classic
Event Publisher
for VSAM, V8.2
 
DB2 Information        5655-M36  Referenced-based   DB2 V7 (5675-DB2)
Integrator Event                                    or
Publisher for DB2                                   DB2 V8 (5625-DB2)
Universal Database
for z/OS, V8.2
 
DB2 Information        5655-L88  Referenced-based   DB2 V7 (5675-DB2)
Integrator Replication                              or
for z/OS, V8.2                                      DB2 V8 (5625-DB2)
 
DB2 SQL Performance    5655-I22  Referenced-based   DB2 V7 (5675-DB2)
Analyzer for z/OS,                                  or
V2.2                                                DB2 V8 (5625-DB2)

Full-capacity mainframes

In cases where full-capacity is applicable, the following terms apply:

  • Execution-based, z/OS-based, full-machine-based: The required capacity of a zSeries IPLA program with these terms equals the MSU-rated capacity of the machines where the zSeries IPLA program executes.

    For more information on mainframe MSU-rated capacities, refer to "The System/370™, System/390®, and zSeries Machine Exhibit" (Z125-3901) or visit the Mainframes section of the zSeries Exhibits Web site

  • Reference-based: The required license capacity of a zSeries IPLA program with these terms equals the license capacity of the applicable monthly license charge (MLC) program. This MLC program is called the "parent" program.

Sub-capacity mainframes

In cases where sub-capacity is applicable, the following terms apply:

  • Full-machine-based: The required license capacity of a zSeries IPLA program with full-machine-based terms equals the MSU rated capacity of the machines where the zSeries IPLA program executes.

    For more information on mainframe MSU-rated capacities, refer to "The System/370, System/390, and zSeries Machine Exhibit" (Z125-3901) or visit the Mainframes section of the zSeries Exhibits Web site

  • Reference-based: The required license capacity of a zSeries IPLA program with these terms equals the license capacity of the applicable MLC program. This MLC program is called the "parent" program.

For more information on sub-capacity zSeries IPLA terms and conditions, refer to Software Announcement 204-184 , dated August 10, 2004.

Additional information for products with reference-based terms

zSeries IPLA sub-capacity programs with reference-based terms add value to the parent program across the environment, regardless of where in environment the zSeries IPLA program executes.

An environment is defined as either a single/stand-alone machine or a qualified Parallel Sysplex®. Customers may have one or more different environments across their enterprise. To determine the required license capacity for each zSeries IPLA program with referenced-based terms, each environment should be assessed separately.

When a zSeries IPLA sub-capacity program with reference-based terms is used in a qualified Parallel Sysplex environment, the required license capacity of the zSeries IPLA program must equal with the license capacity of the parent program across the Parallel Sysplex. Qualified Parallel Sysplex refers to one:

  1. That meets the criteria defined in Hardware Announcement 198-001 , dated January 13, 1998
  2. Where MLC pricing is aggregated across the Sysplex

Sub-capacity eligibility

To be eligible for sub-capacity charging on select zSeries IPLA programs, you must first implement and comply with all terms of either sub-capacity workload license charges (WLC) or sub-capacity entry workload license charges (EWLC). To implement sub-capacity WLC or EWLC, a machine must be zSeries (or equivalent). On that machine:

  • All instances of the OS/390 operating system must be migrated to the z/OS (or z/OS.e) operating systems.
  • Any licenses for the OS/390 operating system must be discontinued.
  • All instances of the z/OS operating (or z/OS.e) systems must be running in z/Architecture™ (64-bit) mode.

For that machine, you must create and submit a sub-capacity report to IBM each month. Sub-capacity reports must be generated using the Sub-Capacity Reporting Tool (SCRT). For additional information or to obtain a copy of SCRT, visit the zSeries Software Pricing Web site

You must comply with all of the terms of the WLC or EWLC offering, whichever is applicable:

  • The complete terms and conditions of sub-capacity WLC are defined in the IBM Customer Agreement
    • Attachment for zSeries Workload License Charges (Z125-6516)
  • The complete terms and conditions for sub-capacity EWLC are defined in the IBM Customer Agreement
    • Attachment for z800 and z890 Software License Charges (Z125-6587)

Additionally, you must sign and comply with the terms and conditions specified in the amendment to the IPLA contract

  • Amendment for zSeries Platform Programs Sub-Capacity Pricing (Z125-6929, or higher)
Once the amendment is signed, the terms in the amendment replace any and all previous zSeries IPLA sub-capacity terms and conditions.

On/Off Capacity on Demand

To be eligible for On/Off Capacity on Demand pricing, customers must be enabled for temporary capacity on the corresponding hardware, and the required contract must be signed prior to use.

  • Attachment for Customer Initiated Upgrade and IBM eServer On/Off Capacity on Demand — Software (Z125-6611)

 
Back to top
 
Prices

The prices of the following DB2 and IMS Tools products did not change with the new releases:

  • DB2 DataPropagator for z/OS, V8.2 (5655-I60)
  • DB2 High Performance Unload for z/OS, V2.2 (5655-I19)
  • DB2 Information Integrator Classic Federation for z/OS, V8.2 (5697-I82)
  • DB2 SQL Performance Analyzer for z/OS, V2.2 (5655-I22)

Contact your IBM representative for all price information.

Four new Subscription and Support program numbers are introduced with this announcement.

For existing Subscription and Support program numbers, contact your IBM representative.

Program    Entitlement                           License option/
PID        identifier    Description             Pricing metric
 
5655-M36   S01190M       DB2 Information         Use-Based OTC,
                         Integrator Event        Per Value Unit
                         Publisher for DB2       OOCoD, TUC
                         Universal Database
                         for z/OS, V8.2
 
5655-M38   S01190C       DB2 Information         Use-Based OTC,
                         Integrator Classic      Per Value Unit
                         Event Publisher         OOCoD, TUC
                         for IMS, V8.2
 
5655-M35   S011909       DB2 Information         Use-Based OTC,
                         Integrator Classic      Per Value Unit
                         Event Publisher         OOCoD, TUC
                         for VSAM, V8.2
 
5655-L88   S0118Z5       DB2 Information         Use-Based OTC,
                         Integrator Replication  Per Value Unit
                         for z/OS, V8.2          OOCoD, TUC

Subscription and Support

Program   Entitlement                   License option/
PID       identifier   Description      Pricing metric
 
5655-M50  S01190N      DB2 II Event     SW Subscription and
                       Publisher for    Support ASC Decline
                       DB2 UDB for      SW S&S No Charge SW
                       z/OS S&S         S&S Registration No
                                        Charge
 
5655-M49  S01190B      DB2 II Classic   SW Subscription and
                       Event Publisher  Support ASC Decline
                       for IMS S&S      SW S&S No Charge SW
                                        S&S Registration No
                                        Charge
 
5655-M51  S011908      DB2 II Classic   SW Subscription and
                       Event Publisher  Support ASC Decline
                       for VSAM S&S     SW S&S No Charge SW
                                        S&S Registration No
                                        Charge
 
5655-M82  S0118Z6      DB2 II           SW Subscription and
                       Replication      Support ASC Decline
                       for z/OS S&S     SW S&S No Charge SW
                                        S&S Registration No
                                        Charge

IBM Global Financing

IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, both from IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit

IBM Global Financing offerings are provided through IBM Credit LLC in the United States and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice. For more financing information, visit


 
Back to top
 
Order now

To order, contact the Americas Call Centers, your local IBM representative, or your IBM Business Partner.

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

 Phone:     800-IBM-CALL (426-2255)
 Fax:       800-2IBM-FAX (242-6329)
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Americas Call Centers
            Dept:  IBM CALL, 11th Floor
            105 Moatfield Drive
            North York, Ontario
            Canada M3B 3R1
 
 Reference: LE001

The Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

Note: Shipments will begin after the planned availability date.

Trademarks

 
DataPropagator, IMS, iSeries, MVS, System/370, and z/Architecture are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
z/OS, DB2, BookManager, DB2 Universal Database, CICS, DB2 Connect, zSeries, SystemPac, S/390, Passport Advantage, AIX, OS/390, System/390, and Parallel Sysplex are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows is a trademark of Microsoft Corporation.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both
 
Other company, product, and service names may be trademarks or service marks of others.

Back to top
 

 
Printable version