IBM DB2 and IMS Tools assist in management of database environments

IBM United States Software Announcement 204-117
June 1, 2004

 ENUS204-117.PDF (85KB)

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

 
At a glance

New and enhanced DB2 and IMS Tools support DB2 V8 and offer additional capabilities in key functional areas:

  • Database Administration
    • DB2 Administration Tool for z/OS, V5
    • DB2 Object Comparison Tool for z/OS, V3
  • Utilities Management
    • DB2 Automation Tool for z/OS, V2
  • Performance Management
    • DB2 Query Monitor for z/OS, V2
    • IMS Performance Analyzer for z/OS, V3.3
  • Application Management
    • IMS Connect for z/OS, V2.2
    • IMS Connect Extensions for z/OS

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

One new and four enhanced versions of DB2® and IMS™ tools offer innovative features to assist database administrators (DBAs) and system programmers in managing all aspects of DB2 and IMS database environments.

New

  • IMS Connect Extensions for z/OS®

Enhanced

  • DB2 Automation Tool for z/OS, V2
  • DB2 Query Monitor for z/OS, V2
  • IMS Connect for z/OS, V2.2
  • IMS Performance Analyzer for z/OS, V3.3

DB2 Administration Tool for z/OS, V5 (5697-K90) and DB2 Object Comparison Tool for z/OS, V3 (5697-K40) will be available June 25, 2004. Refer to:

  • Software announcement 204-030 , dated March 2, 2004
  • Software announcement 204-080 , dated April 27, 2004

The DB2 and IMS 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 and IMS. Details are listed in the Hardware requirements and Software requirements sections.
 
Back to top
 

Planned availability date

June 25, 2004
 
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 eleventh database tools announcement in less than four 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 60 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, and taking responsibility for decision making and initiating action.

To view the list of DB2 and IMS Tools, visit

IBM Tools for Utilities Management

DB2 Automation Tool for z/OS, V2 (5697-I80) simplifies common DB2 database maintenance tasks for administrators. Database objects, exceptions, and utilities are specified in profiles, then combined into a job profile. When jobs are built, DB2 Automation Tool evaluates database conditions against the thresholds specified by the administrator and generates the appropriate utility jobs. Jobs may execute multiple DB2 utilities against multiple objects (with appropriate parameters for each) in a specified order of steps. In addition to utility automation, DB2 Automation Tool provides robust dataset management and data page browser/editor tools to simplify the precise and timely execution of key database management tasks.

Significant new functions have been added to DB2 Automation Tool for z/OS, V2:

  • Support for DB2 V8
  • Image copy support for ESS and EMC devices
  • Point in time recovery assist
  • New Disaster Recovery feature
  • More choices for JCL generation
  • Utilities enhancements
  • Usability improvements

Descriptions of these new functions are in the Additional information section.

IBM Tools for Performance Management

DB2 Query Monitor for z/OS, V2 (5697-I03) enables you to efficiently tune SQL workload and DB2 objects to ensure the effectiveness of your DB2 subsystems. DB2 Query Monitor's enterprise deployment option lets you leverage the additional functionality provided by the open systems architecture and provides you with the information you need to accurately assess and manage your SQL workload.

The following new features are provided:

  • GUI-based reporting, viewing, and configuration capability
  • Optional keys in reduction process
  • Interval-based VSAM data backstores
  • Proactive event notification, knowledge-based, and autonomic responses
  • Single-console viewing of enterprise DB2 activity
  • Consolidated view of data sharing group activity
  • Collection and reduction of object access information
  • Collection and reduction of buffer pool statistics
  • Support for DB2 V8

The new features are described in the Additional information section.

IMS Performance Analyzer for z/OS, V3.3 (5655-E15) provides comprehensive performance analysis and tuning assistance for IMS TM and DB.

IMS Performance Analyzer for z/OS processes IMS Log, Monitor, and now IMS Connect event data to provide comprehensive reports for use by IMS specialists to tune their IMS systems and managers to verify service levels and predict trends.

Key features:

  • Comprehensive reporting for the IMS Log and Monitor, and IMS Connect
  • Performance information available in formats that meet your varied requirements:
    • Summary reports offer overview information that can be tailored to meet your requirements.
    • Detailed reports and traces track IMS events and transactions for more detailed analysis.
    • Graphical reports give you transaction rate and response time analysis.
    • Extracts allow you to import data into DB2 or spreadsheets for further analysis.
    • The Transaction History File keeps historical transaction performance information in DB2 for capacity planning and trend analysis.
    • Specialized reports designed to meet the demanding requirements of IMS performance experts.
    • User-defined performance thresholds allow you to set goals and report exceptions.
  • Log reporting delivers comprehensive information about transaction transit and response time, as well as IMS resource usage and availability. IMS Performance Analyzer for z/OS can process logs from a single IMS system or from multiple IMS subsystems running in a shared queue sysplex.
  • Monitor reporting provides a comprehensive analysis of regions, programs, transactions, databases, external subsystems, and other resources.
  • Comprehensive reporting is available for the Fast Path Monitor including DEDB, BALG/EMH, Fast Path Buffer, OTHREAD, and VSO.
  • ISPF Dialog helps you manage IMS system and sysplex definitions and tailor and submit your report requests. Batch commands can also be used to request reports.
  • DBRC Log Selection automatically selects the required SLDS log files to simplify report requests.
  • IMS Performance Analyzer complements IMS Problem Investigator for z/OS (5655-K50) in the investigation of IMS performance-related problems.

IMS Performance Analyzer, V3.3 offers new reports and features including:

  • Comprehensive reporting for IMS Connect Extensions for z/OS (5655-K48) event collection.
  • New Dashboard report provides a quick overview of critical system performance indicators and is a springboard to other reports that provide more detailed information.
  • New BMP Checkpoint report measures batch checkpoint frequency that can impact online performance and system restartability.
  • The Transaction History File allows you to collect detailed transaction performance data and export it into DB2 to help with your long-term capacity planning and trend analysis.
  • The Report Analysis (SC27-0913) has been improved by providing additional information to aid in the interpretation of reports.

More information on these new reports and features is provided in the Additional information section.

IBM Tools for Application Management

IMS Connect for z/OS, V2.2 (5655-K52) is IBM's premier access product supporting e-business access to new and existing IMS applications and operations. The product supports communications between one or more TCP/IP (or local/390) clients and one or more IMS systems. It is designed to be the distributed communications front-end to IMS for the future.

The enhancements provided by IMS Connect for z/OS, V2.2 include:

  • Command enhancements for ease of manageability
    • IMS Connect commands can now be issued through the MVS™ modify interface. This is an MVS command. The response to it will be presented by MVS to the issuer of the command, thus enhancing consistency and ease of use.
    • Query Member Command enhancements add IMS Connect IP address and version.
  • Improved performance and availability reporting
  • Cancel timer support to enhance usability
  • IMS Connector for Java™ adds:
    • Commit Mode 0/ Persistent Socket for improved performance
    • Socket timeout for enhanced usability
    • Retry for improved availability

Note: IMS Connector for Java WebSphere® Application Server (WAS) V5 support requires WAS V5.

IMS Connect Extensions for z/OS (5655-K48) enhances the basic IMS Connect product with extended features and functions in the areas of:

  • Availability
  • Security
  • Performance monitoring

A detailed description of this product is in the Additional information section.

Section 508 of the U.S. Rehabilitation Act

The products in this announcement are capable as of their general 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-based pricing will help align the prices of these products to the principle of the PSLC pricing curve, which provides for a lower price per MSU (millions of service units per hour) for larger capacities.

There is also a price benefit when customers grow their capacity. Additional capacity will be based on the number of Value Units (MSUs) the customer has already installed; for example, additional capacity will not be priced starting at the base with a higher price per unit but on the capacity that is already installed.

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

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 and MVS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, z/OS, and WebSphere are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Java is a trademark of Sun Microsystems, Inc.
 
Other company, product, and service names may be trademarks or service marks of others.

 
Back to top
 
Additional information

IBM Tools for Utilities Management

DB2® Automation Tool for z/OS®, V2 (5697-I80) includes the following new support and functions:

  • Support for DB2 V8 allows you to exploit the features available in DB2 V8, including:
    • The long names allowed by the DB2 V8 system catalog for many of the object qualifier columns, such as, table owner, table name, index name, and index creator. DB2 Automation Tool can handle these long names (up to 128 bytes) when processing object names, both internally and on displays.
    • The increase to 4096 in the maximum number of partitions allowed for a partitioned table space in DB2 V8.
    • The Unicode DB2 V8 catalog, which is available in new function mode.
    • Double-byte characters in processing and, where applicable, displays.
    • Syntax changes to utilities that require use of the INDEXSPACE keyword in V8.
  • Image copy support for ESS and EMC devices allows you to make copies of objects on the IBM Enterprise Storage Server™ and EMC Symmetrix devices using the device vendor's utilities. These devices and their accompanying utilities can make very fast image copies of data sets and are useful to back up data without interruption. Normally, these copies are not made known to DB2 and cannot be used in a DB2 RECOVER job unless the copies are made using DB2 Automation Tool. DB2 Automation Tool registers these copies with its own repository and can use these copies for recovery when building the recovery job.
    • For ESS devices jobs are built for the FlashCopy® utility.
    • For EMC devices jobs are built for Snap Dataset utility.
  • Point in time recovery assist provides additional options when building RECOVER utility jobs. The RECOVER online utility recovers data to the current state or to a previous point in time by restoring a copy and applying log records when necessary. In addition, when you select a RECOVER utility and indexes are included in the objects to be recovered, then DB2 Automation Tool will either recover or rebuild the index depending on the index and the type of recovery.
  • The new Disaster Recovery feature provides functions to ease recovery of your DB2 subsystems. In preparing for a potential disaster you may use DB2 Automation Tool to build the jobs necessary to restore the DB2 subsystem at a remote site. After you ship the jobs and the necessary image copies to a recovery site, your subsystem can be recovered quickly and efficiently if a disaster strikes. DB2 Automation Tool makes it easy to prepare for disaster recovery because:
    • You do not have to know the names of the logs, BSDS, or catalog data sets.
    • If you want to process all members of a data sharing group, then only one profile is required to be built for the entire group.
    • At the recovery site you only need to submit one job to initiate a recovery for each member in the data sharing group.
  • More choices for JCL generation are provided. New values have been added to the setup screens, allowing greater control over default values that are used when a job is generated. The following values are specified on the DB2 Shared Profile Support Update Parameters screen:
    • Maximum primary space allocation.
    • Utility region size.
    • The number of parallel MVS™ catalog locate subtasks.
    • Override values can be set for sort work file primary and secondary allocations and number of sort work DDs.
    • Whether STEPLIB DDs are generated.
    • If an abend occurs during an DB2 Automation Tool job, you can specify to terminate utilities with the TERM UTILITY command.
    • A sort work file unit device can be specified separately from the work file unit device.

    These values are assigned by subsystem. However, they can be overridden at the job level.

    In addition, DB2 Automation Tool can now generate syntax with LISTDEF and OPTIONS utility control statements for DB2 V7, and later, subsystems.

  • Utilities enhancements include:
    • Improvements in the way REORG utility jobs are generated:
      • Support has been added for the DRAIN_WAIT, RETRY, and RETRY_DELAY keywords that were introduced in DB2 V7. These keywords apply to both table space and index space REORGs.
      • DB2 Automation Tool will detect whether a table space has been altered and will not allow a REUSE parameter on altered spaces.
      • If a table space does not have a clustering index, the NOSYSREC keyword is not generated.
      • The SORTDATA keyword is not generated for large composite records (greater than 32K).
      • REORG SHRLVL CHANGE is not allowed on spaces with large composite records (greater than 32K).
    • The Modify utility can now clean up rows from the SYSIBM history tables for DB2 V7, and later.
    • Support for GMT time has been added when building image copy data set names.
    • When JCL is generated for data sets that will be allocated using the DB2 Automation Tool reallocation utility the before and after values of the primary quantity (PRIQTY), secondary quantity (SQTY), percent free (PCTFREE), and free page (FREEPAGE) are reported.
  • Usability improvements include:
    • New EXPLODE primary and line commands for object profiles let you see a comprehensive list of all objects included in the profile. Wildcards are "exploded out" resulting in a list of every object meeting the wildcard.
    • Enhancements have been made to ISPF panels that allow you to customize the appearance of screens that contain scrollable data.
    • The main menu options have changed from using numbers to letters for better compatibility with other DB2 tools.
    • An expanded SQL Code message screen aids in debugging.
    • To make the date more easily readable in job comments, it now appears as day-of-week month date, year (for example, Tuesday November 25, 2003).

IBM Tools for Performance Management

DB2 Query Monitor for z/OS, V2 (5697-I03) provides the following new features:

  • GUI-based reporting, viewing, and configuration capability enables you to:
    • Access consolidated data and events for DB2 subsystems, whether within a single z/OS image or across multiple z/OS images independent of the existence of a coupling facility.
    • View and configure monitoring across your enterprise from a single console.
  • Optional keys are controlled via the OPTKEYS parameter in the CQMPARMS data set. They enable the collection of additional information about query activity to help determine the origin of query activity and problems. The TEXT, AUTHIDS, CORRID, WSUSER, WSTRAN, and WSNAME OPTKEYS values enable collected information to be reduced down to the unique piece of SQL text, the individual DB2 authorization ID, individual correlation ID, individual workstation ID, or the individual workstation name, respectively.
  • Interval-based VSAM backstores are VSAM data sets that hold information collected by DB2 Query Monitor's collection points. The data collected includes:
    • SQL metrics
    • DB2 object access
    • SQL text
    • DB2 commands
    • Negative SQLCODES

    With the exception of the Host Variables collection point, one backstore data set is created for each collection point on a per-interval basis. In addition, information about the exceptions and notifications that DB2 Query Monitor recognizes and sends are also written to backstore data sets on a per-interval basis.

  • Proactive event notification:
    • Notifications are sent to users to alert them to exceptional events on a monitored DB2 subsystem as they happen.
  • Knowledge-based analysis:
    • When exceptional events occur they are examined to determine the underlying problems, such as lock delays or poor bufferpool hit ratio. Where possible, these problems are presented to the user.
  • Autonomic responses:
    • When exceptional events occur a wide variety of user configurable responses can be executed, including notifications such as e-mail and wto, and corrective actions such as console commands and batch job submission.
  • Enable the automation of curative actions to deal with exceptional events as they occur.
  • Single-console viewing of enterprise DB2 activity provides access to consolidated data and events for DB2 subsystems, whether within a single z/OS image or across multiple z/OS images independent of the existence of a coupling facility. Query Monitor enables the configuration of monitoring across an enterprise from a single console.
  • Consolidated view of data sharing group activity provides a view of SQL workload information from the perspective of a data sharing group as a whole.
  • Collection and reduction of object access information enables the collection of information about the DB2 objects being accessed by your system's SQL activity. Collected information can be displayed at various levels of granularity down to the level of the individual table and index and related back to the exact request or even to the user who is requiring the access.
  • Collection and reduction of buffer pool statistics enables you to collect buffer pool usage information about your system's SQL-related exceptional events.
  • Additional enhancements include:
    • Seamless operation in SYSPLEX and XPLEX environments
    • Replacement of detailed data collection with increased summarization capabilities and extended exceptional event analysis
    • Improved field problem determination:
      • When an ISPF error occurs DB2 Query Monitor produces PFW and displays the time the event took place.
    • Improved customer problem diagnostics:
      • Advanced recovery has now been built around the DB2 Query Monitor started task, which produces SVC dumps when errors occur.
    • Other improvements:
      • Memory management
      • Exceptional condition recognition
      • Levels of summarization
      • Isolation of data collector from all reporting and analysis processes
      • Support for long SQL text
      • Support for NLS text

IMS™ Performance Analyzer for z/OS, V3.3 (5655-E15) offers new reports and features.

The performance and accounting data collected by IMS Connect Extensions event collector is reported and includes:

  • Summary and detailed analysis of IMS Connect transaction internal and external transit times and latencies. Detailed analysis includes critical event analysis for message processing.
  • Summary and detailed analysis of message sizes, types, and other significant detail including Transaction, Message, Resume Tpipe statistics, and Socket utilization
  • Summary and detailed information about significant processing events such as security, user message exits, and other events with the potential to impact performance, including resource availability and session errors
  • Accounting and charge back

The new Dashboard report provides a quick overview of critical system performance indicators, including transaction throughput and IMS system resources. It can highlight potential performance problem areas quickly and provide a springboard to other reports that contain more detailed information.

The new BMP Checkpoint report provides an analysis of BMP Checkpoint frequency that can affect online performance and system restartability.

  • The detailed List report provides a breakdown of individual BMP checkpoint activity.
  • The Summary report provides an overview of each BMP program.
The reports can be used to measure BMP checkpoint frequency, highlighting the impact they have on IMS system restartability.

The Transaction History File is used to collect historical transaction performance data that is useful for long-term trend analysis and capacity planning.

  • Information is summarized for each transaction code over a short time interval including:
    • Transaction transit
    • Response and CPU times
    • DLI call statistics
  • The data is provided in a format suitable for loading directly into DB2 from where you can run queries or produce reports.

Additional new features and enhancements:

  • The Transaction Substitution Exit allows you to change the Transaction Code name in the Message Queue Transit reports via an exit.
  • Message Queue Transit report peak percentiles are now more accurate for low transaction volumes.
  • The IMS Subsystem ID can optionally be included in Monitor report headings.
  • The new Fast Path Buffer Usage report provides an in-depth analysis of Fast Path Buffer usage. It includes support for new IMS V9 log record fields that identify the NBA and OBA values at region start-up.

IBM Tools for Application Management

IMS Connect Extensions for z/OS (5655-K48) extended features and functions include:

Performance monitoring extensions provide performance measurements and basic reporting with more extensive reporting provided by IMS Performance Analyzer for z/OS. Accounting information for IMS Connect activities is created and collected. The data collected enables reporting by IMS Performance Analyzer that includes the following areas:

  • Summary and detailed analysis of:
    • IMS transaction internal and external transit times and latencies. Detail analysis includes critical event analysis for message processing, including performance details for READ Exit, OTMA, XMIT Exit, Input, and Output.
    • Message sizes, types, and other significant detail
      • Transaction statistics by period, minimum, maximum, and average counts
      • Message statistics by period, minimum, maximum, and average message lengths
      • Resume Tpipe statistics
      • Socket utilization
  • Detail and summary information about significant processing events such as security processing, user message exits, and other events with the potential to impact performance
    • Resource availability
    • Session errors
  • Gather information needed for user accounting and charge back systems

Availability extensions provide enhanced services for user exits, transaction pacing, dynamic routing, workload balancing, and extended control and reporting.

  • Enhanced services for user exits
    • Dynamic exit reload without interruption of IMS Connect execution
    • Adding or removing exits without interruption of IMS Connect execution
  • Flexible Resource definitions with grouping of resource types:
    • Data Store
    • Transactions
  • Expanded control of client input messages
    • Dynamic routing of messages to multiple Data Stores utilizing features including:
      • Rerouting of message to alternative Data Store when the primary is not available
      • Workload balancing utilizing routing and work load schemes
      • Transaction affinity to a single or group of Data Stores
    • Dynamic resource controls
      • Ability to limit client input message rates
      • Controlling user access to IMS Connect instances
  • External Control of IMS Connect Extension via ISPF console:
    • Establish resources and groups
    • Tailor IMS Connect exits
    • Display and/or change resource controls while IMS Connect is active
    • Add, delete, or re-load exits while IMS Connect is active
    • Display statistical data for active IMS Connect instances

Security extensions provide protection against access by unauthorized clients.

  • Special RACF® class for client access control
  • Verify client access to IMS Connect Resources
    • The Connect Instance
  • USERID SAF profile caching
  • Refreshing of SAF profiles via command, for example, online change for profiles

 
Back to top
 
Offering information

Product information is available via the Offering Information Web site at


 
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 Automation Tool for z/OS, V2 (5697-I80)
 License Information                              GC18-9271
 Program Directory                                GI10-8596
 
DB2 Query Monitor for z/OS, V2 (5697-I03)
 License Information                              GC18-9201
 Program Directory                                GI10-8587
 
                                                  Order
Title                                             number
 
IMS Connect for z/OS, V2.2 (5655-K52)
 License Information                              GC18-7259
 Program Directory                                GI10-8506
 
IMS Connect Extensions for z/OS (5655-K48)
 License Information                              GC18-7254
 Program Directory                                GI10-8504
 
IMS Performance Analyzer for z/OS, V3.3
(5655-E15)
  License Information                             GC27-0914
  Program Directory                               GI10-8259

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 Automation Tool for z/OS, V2 (5697-I80)
 User's Guide                                     SC18-9280
 
DB2 Query Monitor for z/OS, V2 (5697-I03)
 User's Guide                                     GC18-9202
 
IMS Connect for z/OS, V2.2 (5655-K52)
 Guide and Reference                              SC18-7260
 
IMS Connect Extensions for z/OS (5655-K48)
 User's Guide                                     SC18-7255
 
IMS Performance Analyzer for z/OS, V3.3
 (5655-E15)
  User's Guide                                    SC27-0912
  Report Analysis                                 SC27-0913

The following material is available on the Web at

  • Overview brochure: IBM DB2 and IMS Tools (GC27-1070)
  • Fact Sheets
    • DB2 Automation Tool for z/OS (GC27-1048)
    • DB2 Query Monitor for z/OS (GC27-1042)
    • IMS Connect for z/OS (GC27-1071)
    • IMS Connect Extensions for z/OS (G507-1455)
    • IMS Performance Analyzer for z/OS, V3.3 (GC27-1059)

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

Hardware requirements

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

Software requirements

The DB2 products in this announcement require DB2 V6, or later.

  • DB2 V6 (5645-DB2)
  • DB2 V7 (5675-DB2)
  • DB2 V8 (5625-DB2)

The IMS products in this announcement require IMS V7, or later.

  • IMS V7 (5655-B01)
  • IMS V8 (5655-C56)
  • IMS V9 (5655-J38)

IMS Connect for z/OS, V2.2

  • Much of the base function of IMS Connect can be used with terminals, applications, and data running under IMS V7 (5655-B01). The IMS Connect V2.2 function provided to support IMS Connect Extensions for z/OS (5655-K48) is supported with IMS V7.
  • IMS V8 (5655-C56) is required for IMS Connect support for:
    • Distributed IMS operations
    • All IMS Connect V2 enhancements
  • WebSphere® Application Server (WAS) for z/OS V5 (5655-I35) is required for IMS Connector for Java™ WAS for z/OS V5 support.

IMS Connect Extensions for z/OS requires:

  • IMS Connect for z/OS, V2.2 and its prerequisite software

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)

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

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

Value Unit-based pricing will help to align the prices of these products to the principle of the PSLC pricing curve, which delivers a lower price per MSU (millions of service units per hour) for larger capacities.

There is also a price benefit when customers grow their capacity. Additional capacity will be based on the number of Value Units (MSUs) the customer has already installed, for example, additional capacity will not be priced starting at the base with a higher price per unit but on the capacity that is already installed.

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

Value Unit exhibit VUE007

            MSUs     MSUs
           minimum  maximum  Value Units/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 non MSU-based S/390® processors:

Hardware            Value Units/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 the customer has installed 1,500 MSUs, the applicable Value Units would be:

         Translation from MSUs to Value Units
 
            MSUs    *  Value Units/MSU  = Value 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.

Value Units for IBM 9672 processors will be based upon the full capacity of these systems. This is applicable to all S/390-based systems that are measured on MSU capacity. Information on MSU capacities can be found in the IBM System/370™, System/390® and zSeries® Machine Exhibit, Z125-3901.

Value Units for zSeries will be based upon full MSU capacity as defined in the Machine Exhibits.

A tool will be available that provides support for transforming the MSU-based capacities of S/390 systems to new Value Units by calculating the applicable number of Value Units for a given number of MSUs.

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.

When ordering DB2 and IMS Tools for use in a Parallel Sysplex® environment specify the number of Value Units to cover the MSU capacity of the machines in the Parallel Sysplex to which DB2, IMS, or both are licensed. The following examples illustrate how this rule applies to different situations.

  • DB2, IMS, or both licensed on a single server

    In a single zSeries server with a capacity of 140 MSUs with DB2, IMS or both are licensed to it, DB2 and IMS Tools licenses are based on the 140 MSU capacity of the machine.

  • DB2, IMS, or both licensed under PSLC in a sysplex

    In a four-way sysplex with DB2, IMS, or both on all four machines in the sysplex, DB2 and IMS Tools licenses are based on the total capacity in MSUs of all four machines or the total number of MSUs in the sysplex.

  • DB2, IMS, or both licensed under PSLC in a sysplex under CEC level pricing

    In a four-way sysplex with DB2, IMS, or both licensed to two machines in the sysplex, DB2 and IMS Tools licenses are based on the total capacity in MSUs of the two machines where DB2, IMS, or both are licensed.

The ordering information for the following products has not changed.

Product name                                           PID
 
Subscription and Support for DB2                       5655-E38
 Automation Tool
Subscription and Support for DB2                       5655-E87
 Query Monitor
IMS Connect for z/OS, V2.2                             5655-K52
Subscription and Support for                           5655-E34
 IMS Connect
IMS Performance Analyzer for z/OS, V3.3                5655-E15
Subscription and Support for IMS                       5655-E18
 Performance Analyzer

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

Translation from MSUs to Value Units

 
              MSUs       Value Units/MSU
 
   Base        1-3            1.00
   Tier A      4-45            .45
   Tier B     46-175           .36
   Tier C    176-315           .27
   Tier D    316+              .20
 
Program   Entitlement                      License Option/
PID       Identifier  Description          Pricing Metric
 
5697-I80  S011240     DB2 Automation Tool  Use-Based OTC,
                      for z/OS, V2          Per Value Unit
                                            OOCoD, TUC
 
5697-I03  S0103FS     DB2 Query Monitor    Use-Based OTC,
                      for z/OS, V2          Per Value Unit
                                            OOCoD, TUC
 
5655-K48  S00XT2N     IMS Connect          Use-Based OTC,
                      Extensions for z/OS   Per Value Unit
                                            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

Program    Entitlement                 License Option/
PID        Identifier   Description    Pricing Metric
 
5655-K49   S00XT3K      IMS Connect    SW Subscription and
                                        Support
                        Extensions     ASC Decline 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 and the machine the programs are operating on.

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

Licensing: IPLA. 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
 
DB2 Automated Utility              DB2 Automation Tool
 Generator (5695-077)               for z/OS, V2 (5697-I80)
 
Query Monitor (5799-GJC)           DB2 Query Monitor
                                    for z/OS, V2 (5697-I03)
 
IMS Monitor Summary                IMS Performance
 and Systems Analysis               Analyzer, V3
 Program (IMSASAP)                  (5655-E15)
 (5798-CHJ)
 
IMS Performance
 Analysis and Reporting
 System (IMSPARS)
 (5798-CQP)
IMS Performance
 Analyzer (5697-B89)
 
IMS Performance
 Analyzer, V2.1
 (5697-F020)

Sub-capacity charges terms and conditions

IBM zSeries software charges at less than full machine capacity for eligible tools apply when z/OS is running in z/Architecture™ (64-bit) mode on a zSeries 900, no other MVS-based operating system is licensed to that server, and the required information is provided by the customer in accordance with the applicable terms.

Sub-capacity charges for an eligible tool are based on the z/OS product defined capacity. To obtain charges at less than full machine capacity for eligible tools, the customer is required to:

  • Determine the MSUs needed for each machine on which the tools will run. Only machines on which the customer has implemented sub-capacity Workstation License Charges (WLC) according to the above terms and conditions, are eligible for charges at less than full machine capacity for the tools.
  • Use the product defined capacity for z/OS (as specified on the Sub-Capacity Reports submitted to IBM for sub-capacity WLC) as the sub-capacity (MSUs) for each tool.
  • Submit any additional MSUs and/or Value Units required for each product along with the current entitlement in Value Units for each product.

Sub-capacity charges for tools

To be eligible for sub-capacity charges for tools, the machine on which the tools are running must be eligible for WLC sub-capacity charges terms and conditions. The customer must have signed the Attachment for zSeries Workload License Charges-Pre-ILM, Z125-6516, and submitted at least one Sub-Capacity Report to IBM as defined in the attachment.

With sub-capacity charges, the charge for an eligible tool is based on the z/OS product defined capacity. To obtain charges at less than full machine capacity for each eligible tool for each machine, the customer should:

  • Determine the MSUs needed for the machine on which the tools will run. In a data sharing environment, determine the aggregate MSUs needed on the machine where the tools run. Use the product defined capacity (MSUs) for z/OS (as specified on the Sub-Capacity Reports submitted to IBM for sub-capacity WLC) as the sub-capacity (MSUs) for each tool.
  • Submit any additional MSUs and/or Value Units required for each product along with the current entitlement in Value Units for each product.
  • If the use of sub-capacity pricing terms for tools results in a reduced requirement for Value Units, thus freeing up entitlements, customers can reallocate the entitlement difference by distributing the Value Units across a larger or different set of systems, or reserve them for future growth. There will be no refunds for these freed up Value Units. Subscription and Support volumes and entitlements for existing contracts will continue to be at the same levels as the acquired licenses.

Management of the Value Unit entitlements continues to be a customer responsibility. If one of the following occur on a machine to which tools are licensed, the customer must determine if additional Value Units and Subscription and Support need to be ordered for those tools to cover the increase:

  • The z/OS defined capacity is increased.
  • The requirements for WLC sub-capacity charges are no longer met.

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 — Z125-6611, Attachment for Customer Initiated Upgrade and IBM eServer® On/Off Capacity on Demand — Software — must be signed prior to use.
 
Back to top
 

Prices

Contact your IBM representative for charges information for this announcement.

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

 
Enterprise Storage Server, MVS, IMS, System/370, iSeries, and z/Architecture are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
z/OS, DB2, FlashCopy, RACF, BookManager, WebSphere, S/390, System/390, zSeries, Parallel Sysplex, Systempac, Passport Advantage, AIX, and eServer are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to top
 

 
Printable version