DB2 Server for OS/390 Version 5 Delivers Power to S/390 Data Warehouse Applications

Software Announcement
May 13, 1997
Announcement Letter Number: 297-146


Table of Contents:

(Corrected on May 14, 1997) Price information deleted from the overview.

At a Glance

DB2 Version 5 increases support for data warehouse, operational, client/server, and Internet applications.

Availability for Data Warehouse and Operational Applications

  • Provides Sysplex Query Parallelism for complex queries
  • Introduces online REORG
  • Provides faster utilities
  • Delivers very large tables (1TB)
Client/Server Applications
  • Enhances stored procedures with query result sets and multiple address spaces
  • Reduces communication and processing times for client/server applications
  • Delivers TCP/IP connectivity for DRDA clients, like DDCS
  • Provides DCE authentication for DRDA clients
Increases User Productivity
  • Year 2000 ready
  • Provides full conformance to SQL92 Entry Level Standard
  • Provides temporary tables
  • Delivers Call Level Interface for ODBC and X/Open's CLI
  • Provides workstation-based Installation, Visual Explain, and Performance Tuning
DB2 Database Server Solution
  • Assists application design and capacity planning with DB2 Estimator for Windows (R)
  • Monitors and optimizes DB2's performance with DB2 PM
  • Provides Internet access with Net.Data
-----------------------------------------
For ordering, contact:
  Your IBM representative, an IBM
  Business Partner, or IBM North America
  Sales Call Center at
    800-IBM-CALL  Reference: YE010



Overview

By delivering a flexible client/server solution, DB2 (R) Version 5 increases both transaction and query processing capacity and provides a scalable solution capable of managing terabytes (TB) of data. It also delivers functions to improve application design decisions and ease DB2 system administration.

DB2 for OS/390 (TM) Version 5 has all of the functions previously previewed as DB2 for MVS/ESA (TM) Version 4 Release 2. Refer to Software Announcement 296-107, dated April 2, 1996.

DB2 V5 delivers major improvements in query processing. These improvements may increase the availability of mission-critical applications. The full power of a Sysplex can be used to split a read-only query into a number of smaller tasks and to run these tasks in parallel across multiple DB2 subsystems on multiple complexes in a data sharing group. The enhanced function combines with new support for very large tables, up to 1TB, to provide the performance needed for complex data analysis used by data mining applications.

This new version of DB2 offers improvements to utility performance with RUNSTATS sampling, faster LOAD & REORG, online REORG, and new support for extended sequential data sets in DFSMS/MVS (R). With the use of BSAM, striping data is transferred between DASD and memory faster than individual DASD can handle. With these faster utilities, availability may be improved.

Client/server investments are enhanced with improved stored procedures support to return result sets to the client. Additional connectivity is provided now that DB2 Server for OS/390 supports native TCP/IP connections, from DRDA (R) clients such as DDCS.

DB2 Performance Monitor Feature "Try and Buy" Program

To let you experience the powerful functions of the new DB2 Performance Monitor Feature without time pressures, a "Try and Buy" program is available. Together with the DB2 base product, you will receive a copy of the DB2 Performance Monitor Feature that can be installed and used for up to 120 days without paying license fees.

This program is described in a Memo to DB2 Licensees, which can be ordered as publication number GN26-1329. This program applies to basic licenses.



Intended Customers

DB2 V5 offers significant enhanced functions suitable for current users of DB2 for MVS/ESA. It can also be of value to current users of MVS/ESA and OS/390 systems who are seeking a robust, high performing relational data management solution.



Key Prerequisites

DB2 Server for OS/390 runs on systems capable of supporting OS/390, MVS/ESA Version 5, or MVS (R) SP (TM) Version 4 Release 3.

Planned Availability Date

June 27, 1997

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

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



DESCRIPTION

In response to customer and market demand, DB2 for OS/390 Version 5 delivers richer client/server function, better performance, higher availability, enhancements to increase user productivity, and support for open industry standards. DB2 V5 also demonstrates IBM's leadership in parallel database technology by further exploiting the System/390 (R) Parallel Sysplex (TM) and DB2 data sharing. Sysplex query parallelism expands the power available to a single query, making it possible not only to share data but also to split a query across multiple processors. These new functions make DB2 Server for OS/390 the super-server of choice for twenty-first century enterprise-wide data management on both OS/390 and MVS/ESA systems.

DB2 for OS/390 Version 5 has all of the functions previously previewed as DB2 for MVS/ESA Version 4 Release 2. Refer to Software Announcement 296-107, dated April 2, 1996.



Performance and Availability

DB2 V5 improves performance for complex queries, utility processing, and for data sharing restart and recovery. DB2 V4 introduced the ability to execute parts of a query in parallel and data sharing. Now parallelism is further expanded as DB2 adds Sysplex query parallelism in which a complex query can be executed in parallel on processors throughout the data sharing group.

DB2 Server for OS/390 makes a giant leap toward virtually continuous availability with major improvements in the REORG utility. Prior releases required table spaces to be offline before they could be reorganized. A new option allows read/write access to the data during most phases of the reorganization. A read-only access option allows the utility to process more quickly. Also, LOAD and REORG now support in-line COPY which allows the table space to be available as soon as the utility completes. Another new option for LOAD and REORG can bypass intermediate data sets which can allow the utility to complete with less elapsed time. Improvements to RECOVER INDEX and LOAD reduce processing time, with greater improvement for tables with more rows per page. RUNSTATS can now use a SAMPLE option to reduce processing costs when collecting statistics on nonindexed columns. Preliminary tests showed a considerable improvement.

New with DB2 V5, very large table support adds both capacity and availability. The table limits have been expanded to permit up to 254 partitions of 4 gigabytes (GB) each for a total of 1TB. Large amounts of data placed into more and smaller partitions can reduce the time required to process utilities or queries in parallel. Also, for a large table, the maximum for a non-partitioned index has been increased to 512GB comprised of up to 128 data sets of 4GB each.

Several enhancements improve availability and performance for DB2 data sharing. DB2 V5 takes advantage of the MVS function that permits a rebuild of the group buffer pools. You can use this function to rebuild a group buffer pool onto another coupling facility before applying maintenance, or it may be invoked by DB2 to recover after a link failure has occurred. Other improvements include coexistence support, which permits phased migration of a DB2 data sharing group from V4 to V5 without stopping the entire Sysplex. Also, you can automatically recover data from a damaged group buffer pool without manual operator intervention; retained locks are released sooner following a member failure which makes the data available faster; and improved detection of changes in the read/write interest of shared data can lead to reduced overhead costs. The ability to lock only selected partitions can reduce locking costs for some data sharing applications.

DB2 V5 has added a number of run-time performance improvements. Dynamic SQL, which is called repeatedly, can now be prepared and cached for use by subsequent application processes. A new bind option allows DB2 to reevaluate the access path after the values of host variables or parameter markers have been determined. This can improve query efficiency and response time. Access path selection for correlated columns, such as city and state, can be improved by using RUNSTATS to collect statistics on correlated index columns. Also, you can now use indexes for some common expressions such as DATECOLUMN > CURRENT DATE -- 30 DAYS. Previously, indexes could not be used in these expressions.



Open Systems and Network Computing Enhancements

DB2, an industry leader in distributed technology, enhances DRDA significantly to improve performance and communication costs for applications such as DataJoiner (R). Faster block fetch operations, reduced network traffic because of improved dynamic SQL which permits a single message exchange to both send and receive a query, optimize for "n" rows on SELECT which allows the application to specify the number of rows returned, and improved VTAM (R) performance, all improve transaction throughput. Also, DB2 Server for OS/390 can store data in ASCII format, thereby eliminating the need for special sorting routines when data is returned from an ASCII client.

DB2 V5 extends DB2 Server for OS/390's ability to act as an enterprise server for client/server applications, by providing native TCP/IP support. IBM's new DDCS for Windows product uses this new capability to connect users of Windows 3.x and Windows 95 directly to DB2, without requiring an intermediate gateway machine. This simplifies the network configuration for the end user.

DB2 V4 provided stored procedure support, allowing a DB2 client to call a procedure stored at the DB2 server. DB2 V5 provides stored procedure query result sets. This allows DRDA clients to use popular desktop tools like VisualAge (R), PowerBuilder, and VisualBasic to process one or more query answer sets returned by a DB2 stored procedure. Stored procedures take advantage of MVS Workload Manager to prioritize individual procedure requests and run them in multiple address spaces. Performance can be enhanced by allowing procedures to run as subroutines as well as main routines. Security is enhanced by allowing clients to access the result sets without requiring the end user have access to the underlying SQL tables, and by using the end-user's RACF (TM) ID to control access to non-SQL resources.

There are more options for security with DB2 V5. New with DB2 V5 is support for DCE shared-secret authentication for DCE-enabled clients. DB2 V5 also lets clients send RACF PassTickets instead of passwords. Furthermore, DRDA clients can be enabled to change RACF passwords either on demand or when they have expired.

DB2 V5 provides an access control authorization exit which has the capability to interface with the new RACF/DB2 External Security Module, which was announced in Software Announcement 297-040, dated March 11, 1997.

DB2 Server for OS/390 continues its commitment to open standards with full conformance to the Entry level standard of SQL 92 and to FIPS 127-2, assuring developers of a more complete set of standard SQL that can be used across the DB2 family. DB2 V5 supports open access through ODBC and Call Level Interface (CLI) for applications running on OS/390 or MVS. DB2 V5 provides support for the new Resource Recovery Services (RRS) planned for OS/390 R3. This support will allow two-phase commit processing for transactions using non-SQL resources such as VSAM data sets, IMS (TM) databases, and MQ (TM) Series messages, within a single transaction scope.



User Productivity

DB2 V5 can now be installed from a workstation using the new DB2 Installer. This can increase user productivity by providing a command center from which to install DB2. The graphical interface makes it easier to get the overall picture of the installation process and provides a graphical record of how each subsystem was defined. DB2 Installer arranges the install options into layers, presenting those options which must be specified in the main windows while the others can be accessed through advanced windows. Users can get a basic subsystem up and running quickly or can customize every installation option. DB2 Installer is available for OS/2 (R) and is planned to be available for Windows NT by the end of 1997.

DB2 V5 introduces Visual Explain, an easy to use workstation tool, that presents the DB2 Explain output in an easy to understand graphical format. Relationships between database objects, such as tables and indexes, are instantly clear as are various operations, such as table space scans and sorts. Visual Explain also includes a browser for viewing the current DB2 subsystem parameters. Visual Explain is available for OS/2 and is planned to be available for Windows NT by the end of 1997.

System administration is enhanced with the introduction of the workstation-based Performance Analysis and Tuning function. It provides the ability to access statistical data to assist in analyzing and modifying DB2 Server for OS/390 performance. Context-sensitive help gives the administrator access to tuning recommendations. The workstation function works with the optional DB2 Performance Monitor Feature to provide full analysis and tuning functionality. The DB2 Performance Monitor Feature is a portion of the "Database Server Solution" described below. Workstation Performance Analysis and Tune is available for OS/2 and is planned to be available for Windows NT by the end of 1997.

Now DB2 V5 joins the world of object-oriented development. Application developers can use the object-oriented extensions to IBM COBOL and C++ to write DB2 applications. The DB2 V5 precompiler has been enhanced to support these languages, giving you the opportunity to incorporate DB2 Server for OS/390 into your strategy for object technology.

Additional improvements in query performance that DB2 V5 provides include CASE expressions which can help avoid UNION statements and thereby reduce table scans. Access path selection for correlated columns, such as city and state, can be improved by using RUNSTATS to collect statistics on correlated index columns. Also, you can now use indexes for some common expressions such as DATECOLUMN > CURRENT DATE -- 30 DAYS. Previously, indexes could not be used in these expressions.

New to DB2 V5 is the CHANGELIMIT function of the COPY utility. It is useful in determining whether to perform a full or an incremental image copy. This function provides information about total pages, changed pages, percent of changed pages, and DASD utilization.



Database Server Solution

DB2 V5, together with its new features, is the relational database server for OS/390. OS/390 represents the next generation of operating systems for the S/390 (R). It will retain the classic strengths of the traditional MVS/ESA operating system, but offers a network-ready, integrated operational environment. Base operating system and key database server elements will be installed and tested as one product prior to customer delivery.

DB2 V5 simplifies planning, installation, and maintenance of server software by offering the following additional features at the same time as the DB2 Product is delivered:

The DB2 Performance Monitor (DB2 PM) Feature enables you to monitor, analyze and optimize the performance of DB2 V5 and its applications. It includes an online monitor, for both the host and the workstation environments, which provides an immediate "snap-shot" view of DB2 Server for OS/390 activities and allows for exception processing while the system is operational. In addition, it offers a history facility to view events that happened both recently and in a more distant past, a wide variety of customizable reports for an in-depth performance analysis, and an EXPLAIN function to analyze and optimize Structured Query Language (SQL) statements. The workstation-based Online Monitor can connect directly to the Visual Explain function of the DB2 base product. Workstation Online Monitor is available for OS/2 and is planned to be available for Windows NT by the end of 1997. This separately priced feature may be ordered with DB2 V5.

The Net.Data Feature provides access to DB2 data from the World Wide Web. Businesses are finding many reasons to provide Internet and intranet connectivity from the World Wide Web to their business information. Applications built with Net.Data for OS/390 are making data stored in any DB2 server and other data sources more accessible and useful to customers. Additional information about Net.Data for OS/390 will be available in a forthcoming Software Announcement.

The DB2 Estimator Feature delivers application performance evaluation. DB2 Estimator for Windows Version 5 provides an easy-to-use capacity planning tool helping database administrators, capacity planners and application programmers test the feasibility of system and design changes before investing more time and money. By providing performance estimates for DB2 Version 5 SQL and utilities, the user can perform "what if" scenarios for feasibility studies and determine if utility processing will fit the available batch window. This no charge feature may be ordered with DB2 V5 and it is currently available for download from the Internet.

Refer to the Database Server Solution Features section for more details on all of the above features and for improvements to the new DB2 Performance Monitor Feature which were not in the former licensed program DB2 Performance Monitor for MVS Version 4 Release 1 (5655-102).



Year 2000

This product is year 2000 ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and/or receiving date data within and between the 20th and 21st centuries, provided all other products, (for example, software, hardware, and firmware) used with the product properly exchange date data with it.



PRODUCT POSITIONING

DB2 Server for OS/390 is the super-server of choice for the 21st century providing enterprise-wide data management. It offers large data capacity, high transaction performance, and extensive connectivity. It works with the DB2 family to bring a full relational solution to the market place. DB2 supports transactions arising from CICS (R), IMS transaction management, MVS batch jobs and via distributed connections from remote clients on numerous platforms.

DB2 Server for OS/390 is the relational database server solution for OS/390. It combines the power and reliability of DB2 with additional features such as DB2 Performance Monitor, DB2 Estimator for Windows, and Net.Data.

DB2 Server for OS/390 supports the initiative by IBM to be year 2000 ready. DB2 V5 is a product that, when used in accordance with its associated documentation, is capable of correctly processing, providing and/or receiving date data within and between the 20th and 21st centuries, provided all other products (for example, software, hardware and firmware) used with the product properly exchange date data with it.

For further information, see IBM's year 2000 web page at:

    http://www.software.ibm.com/year2000



STATEMENT OF GENERAL DIRECTION

DB2 for OS/390 supports some functions from earlier versions which may receive less support in the future. In particular, you should be aware that:

  • Type 2 indexes are recommended for every index. Support for type 1 indexes will probably be removed in a future release of DB2. All indexes need to be converted to type 2 before migrating to that release.

  • Data sets should be protected by a security subsystem, such as RACF, an element of the OS/390 Security Server, rather than by passwords. Support for password protection will probably be removed in a future release of DB2.

  • Shared Read-Only Data function has been replaced by more substantial, more usable data sharing. Another alternative is to use distributed data. Shared Read-Only Data will probably be eliminated in a future release of DB2.

  • The private protocol function of the Distributed Data Facility (DDF) was introduced in DB2 for MVS Version 2. Then, DB2 introduced the Distributed Relational Database Architecture (TM) (DRDA) in Version 2 Release 3. DRDA has replaced the private protocol function. No further enhancements are planned for the private protocol function.
DB2 for OS/390 intends to participate as a member of the DB2 Universal Database family. In particular:
  • DB2 for OS/390 intends to support JDBC access to DB2 data for applications that run under OS/390 UNIX Services. Plans for JAVA support on OS/390 are described in Software Announcement 297-040, dated March 11, 1997.

  • DB2 for OS/390 intends to provide support for object data in a future release of DB2. That support would include:
    • Very Large Objects (LOBs)

    • User Defined Functions (UDFs)

    • User Defined Distinct Data Types (UDTs)

    • Triggers

    • DB2 Extenders; which enable you to store and query text, image, video, audio, and a variety of other data objects



EDUCATION SUPPORT

The appropriate curriculum will be updated, as necessary, to include the enhancements in this announcement.

Descriptions of all classroom and self-study courses are contained in the IBM Education and Training catalogs.

DB2 for OS/390 Version 5 Transition is recommended for all customers planning to install or migrate to Version 5. Data Sharing Implementation is recommended for customers planning to implement Data Sharing with Version 4 or 5.

Call IBM Education and Training at 800-IBM-TEACH (426-8322) for education catalogs, schedules, and enrollments.



REFERENCE INFORMATION

DB2 for OS/390 Version 5 has all of the functions previously previewed as DB2 for MVS/ESA Version 4 Release 2. Refer to Software Announcement 296-107, dated April 2, 1996.

Trademarks

      OS/390, MVS/ESA, SP, Parallel Sysplex, RACF, IMS, MQ, and
      Distributed Relational Database Architecture are trademarks of
      International Business Machines Corporation in the United
      States or other countries or both.
      DB2, DFSMS/MVS, DRDA, MVS, System/390, DataJoiner, VTAM,
      VisualAge, OS/2, S/390, and CICS are registered trademarks of
      International Business Machines Corporation in the United
      States or other countries or both.
      Windows is a registered trademark of Microsoft Corporation.
      Other company, product, and service names may be trademarks or
      service marks of others.



SUPPLEMENTAL INFORMATION



Database Server Solution Features

DB2 (R) V5, together with the following new features, is the relational database server for OS/390 (TM):

  • DB2 Performance Monitor Feature
  • Net.Data Feature
  • DB2 Estimator Feature
Following is a detailed description of each of these features.



DB2 Performance Monitor (DB2 PM) Feature

The new DB2 Performance Monitor Feature enables you to monitor, analyze, and optimize the performance of DB2 V5 and its subsystems. It includes an online monitor to provide an immediate "snap-shot" view of DB2 Server for OS/390 activities and to allow for exception processing while the system is operational. In addition, it offers a history facility to view events that happened both recently and in a more distant past, a wide variety of customizable reports for an in-depth performance analysis, and an EXPLAIN function to analyze and optimize Structured Query Language (SQL) statements.

Improvements in the new DB2 Performance Monitor Feature that were not in the former DB2 Performance Monitor for MVS (R) V4 product (5655-102) include:

  • Workstation-based Online Monitor

    DB2 PM V5 provides a new workstation-based Online Monitor. This new monitor substantially improves usability and simplifies online monitoring and problem analysis. When compared with the existing host-based monitor, the new monitor has the following advantages:

    • TSO is no longer needed for monitoring

    • Usage of graphics to better visualize the relationship between performance counters

    • View the access path of the currently executing SQL statement graphically

      This is realized by a connection to DB2's Visual Explain.

    • Monitor multiple subsystems concurrently

      There is no need to exit the monitor and switch the subsystem. Performance data of multiple subsystems can be viewed at the same time in different windows.

    • Enhanced exception handling

      While the host-based monitor reports each detection of a periodic exception, the workstation-based monitor reports a periodic exception just once with start time and stop time, thus reducing the amount of exception messages.

    The initial implementation is on OS/2 (R) and uses APPC as the communication vehicle to the host. Implementation on Windows (R) NT, using TCP/IP connectivity, is planned to be available by the end of 1997.

    This monitor provides the base for the implementation of future enhancements to DB2 online monitoring.

  • Support of Sysplex Query Parallelism

    Sysplex Query Parallelism is supported by combining the data from all parallel tasks, regardless which data sharing member was used for execution. You still get an application view of the thread just like the view for CP Query Parallelism in V4.

    In heterogeneous data sharing environments, that is, in data sharing environments using different types of hardware, the TCB times of tasks running on different members may not be comparable. DB2 PM V5 adjusts the TCB time of the parallel tasks by a conversion factor, so that they are normalized to the machine size of the originating task. This ensures that the TCB time of parallel tasks and the originating task can be analyzed in a meaningful way.

    Sysplex Query Parallelism is supported by the Accounting and SQL Activity report sets.

    Sysplex Query Parallelism is not yet supported by the Online Monitors. Threads exploiting Sysplex Query Parallelism will contain only data from parallel tasks that run on the same CPC as the originating task.

  • Enhanced Data Sharing Support

    To facilitate the monitoring of applications in a data sharing environment, group-scope reports can now be generated for Accounting. This is especially helpful if you use MVS Workload Management to dynamically schedule your applications on different data sharing members. In such environments, applications can be dynamically scheduled to run on different data sharing members.

    Accounting group-scope reports help you get a complete picture of the resources that an application uses, regardless of where the application runs. Performance data of applications that ran on different members is summarized by member and for the whole data sharing group.

    To enable you to compare and summarize processor usage in a data sharing environment with different machine sizes, DB2 PM Accounting reports provide a new block of data containing details of the processor usage expressed in service units. A service unit is a measure of processor usage that is independent of the processor speed. Service units are provided for Class 1 and Class 2 times, for originating task, for the sum of all parallel tasks and for stored procedures.

  • Support of Utility Parallelism

    DB2's LOAD and REORG utilities can now generate parallel SORT subtasks and a parallel COPY subtask. These subtasks are treated by DB2 PM just as parallel tasks of application threads. The accounting data of these tasks are combined with the accounting data of the utility execution itself and presented as one set of data.

  • Increased Exception Processing Capabilities

    To further enhance the exception processing capabilities, you can now define exits for exception situations. Such exit routines can trigger any user-defined action.

    To satisfy requirements from several customers, we will provide a user exit in the Data Collector which is called for each detected exception. This enables the user to implement additional actions, for example, a message to the console, or a message to a specific user ID. In addition, DB2 PM will deliver a user exit which generates a NetView (R) alert for the exception. Using this exit, customers will be able to integrate the DB2 monitoring activities in their NetView environment.

  • Introduce Security Management for Snapshot Display

    Until now, DB2 PM's security mechanisms relied solely on DB2 privileges. The user invoked all DB2 PM functions without restriction, however, the underlying DB2 functions would only give results based on the privileges granted to the user ID in the DB2 catalog.

    Customers asked us to provide a more granular security mechanism. In particular, one that restricts the display of DB2 threads (applications), so that a particular user cannot see all threads in the system and their associated detail data. Such a security mechanism is not available in DB2.

    DB2 PM provides a user exit in the Data Collector that passes each of the following requests from the Online Monitor before it is displayed:

    • Display of a thread for Thread Summary
    • Display of the currently executing SQL statement for Thread Detail
    • Display of subsystem statistics
    • Display of system parameters
    The user exit can decide whether the request is honored or not. This enables an installation to be very flexible with respect to what type of data is shown to a particular user.

  • Redesigned Utility Activity Traces and Reports

    Up to now, only the first object (that is, table space or index) was reported, even if the utility acted upon multiple objects. Now, all objects the utility processed are reported. In addition, each partition is reported separately for partitioned table spaces.

    Furthermore, the layout of the Utility Activity trace and report has been redesigned, so that it is more consistent with other report sets. Phase information (for utilities) and BIND parameters (for BIND commands) is now shown in a separate workload block that can be optionally switched on.

  • Additional Capabilities in I/O Activity Reports

    The I/O Activity Buffer Pool Report can now include the buffer pool ID. The buffer pool ID is a new ORDER criterion. This allows you to show, for example:

    • Which buffer pools were used and how they were used for each primauth-planname combination
    • Which applications used it and how they used it for each buffer pool
  • Simplified Installation

    The installation of DB2 PM has been considerably simplified. All customizable parameters are entered in two work sheets, and no further customization of jobs or CLISTs is necessary. Parameters that had to be entered several times in the past, like high-level qualifiers, need now be specified only once.

  • Comprehensive Support of All DB2 V5 Changes

    The DB2 Performance Monitor Feature supports all instrumentation, catalog and PLAN_TABLE changes, that are introduced in DB2 V5. With DB2 PM, you can rely on a timely and comprehensive support of performance evaluation and analysis.

Investment protection when migrating: The new DB2 Performance Monitor Feature is upwardly compatible with the following former DB2 Performance Monitor products:
  • DB2 PM for MVS Version 4 Release 1 (5655-102)
  • DB2 PM for MVS Version 3 Release 2 (5655-047)
  • DB2 PM for MVS Version 3 Release 1 (5655-047)
The migration process is simplified by conversion utilities that come along with the DB2 Performance Monitor Feature.

The DB2 Performance Monitor Feature is the right solution for you, even if you have an environment of multiple DB2 releases. Ensuring protection of your investment, DB2 PM fully supports instrumentation, catalog, and PLAN_TABLE data from:

  • DB2 for OS/390 Version 5 (5655-DB2)
  • DB2 for MVS/ESA (TM) Version 4 (5695-DB2)
  • DB2 for MVS Version 3 (5685-DB2)



Net.Data Feature

The Net.Data Feature provides access to DB2 data from the World Wide Web. Businesses are finding many reasons to provide Internet and intranet connectivity from the World Wide Web to their business information. Businesses want to build business-critical web applications to reach the global marketplace. With Net.Data, your business can have interactive Web sites with dynamic data from the sources that you have in your business today: relational data, file data, even IMS (TM) applications and data. Whether you are building interactive catalogs of products, allowing customers to track orders, or conducting electronic commerce, your Net.Data-driven application gets your data to (and from) a worldwide audience.

Following on the success of DB2 World Wide Web Connection, IBM Net.Data delivers a powerful framework for Web applications. In addition to connecting to diverse data sources, Net.Data provides for high performance, robust application development function, and exploitation of existing business logic.

Net.Data provides native access to the data you need in your business environment: DB2 on all platforms, other heterogeneous data sources through DataJoiner, IMS applications and data, and flat file data. In addition, Net.Data supports DB2 stored procedures.

Net.Data has extensive application development functionality, including a rich macro language, conditional logic, HTML and VRML support, and HTML variable substitution.

Please see the Net.Data for OS/390 Web pages for documentation, sample programs, and customer applications. You can find the Net.Data home page at:

    http://www.software.ibm.com/data/net.data/



DB2 Estimator Feature

The DB2 Estimator Feature delivers application performance evaluation. DB2 Estimator for Windows provides an easy to use capacity planning tool helping database administrators, capacity planners and application programmers test the feasibility of system and design changes before investing more time and money. By providing performance estimates for DB2 V5 SQL and utilities, the user can perform "what if" scenarios for feasibility studies and determine if utility processing will fit the available batch window.

In support of DB2 V5, DB2 Estimator for Windows improvements include:

  • Support for partitioned tables

  • Type 2 indexes

  • Compression

  • Most common variants of SQL
The usability of DB2 Estimator has been extended to include:
  • Automatic path selection capability including selection of:
    • Join order
    • Join methods
    • Indexes
  • Expanded support is also provided for LOAD, REORG, RUNSTATS, and COPY utilities to quickly determine the amount of time needed for utility processing.
Look for the program off the IBM Software home page at:
    http://www.software.ibm.com
On the Software page look for a link to Products, then link to Data Management, then link to Downloads, then link to DB2 Estimator.

Customers can contact IBM regarding Estimator at this e-mail address:

    estimate@vnet.ibm.com
More product information is available on the DB2 Estimator home page and download page.



OPEN BLUEPRINT (R)

DB2 V5 provides the Relational Database function described in IBM's Open Blueprint. It provides the:

  • Structured Query Language (SQL) industry-standard interface from the International Organization for Standardization (ISO)

  • Structured Query Language Call Level Interface (SQL CLI) industry-standard from the International Organization for Standardization (ISO)

  • Open Database Connectivity (ODBC) for Windows client systems interface from Microsoft (R) Corp.
It supports the Distributed Relational Database Architecture (TM) (DRDA (R)) protocol from IBM to facilitate open, distributed, multivendor interoperability.

Open Enterprise: DB2 V5 is developed at a lab where the quality management system has been certified under International Organization for Standards (ISO) 9001.

DB2 V5 conforms with the following national and international SQL standards:

  • Federal Information Processing Standards (FIPS) publication 127-2, Database Language SQL. FIPS publication 127-2 announces ANSI X3.135-1992 as the standard for SQL, so conformance with FIPS publication 127-2 also means conformance with:
    • ANSI (American National Standards Institute) X3.135-1992, Database Language SQL
    • ISO (International Organization for Standardization) 9075-1992, Database Language SQL
    The above are referenced to collectively as the SQL92 standard. As of this release, DB2 Server for OS/390 conforms to SQL92 Entry Level.
Additionally, the ODBC function that is included in DB2 V5, has been validated per the extensive ODBC Verification System (OVS) developed by INTERSOLV Inc., a recognized leader in ODBC technology. This test suite consists of approximately 4,000 test cases written to the Microsoft ODBC Version 2.5 specifications and represents broad usage of ODBC typical of many client server applications.



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements

Processor: DB2 V5 operates on any processor supported by MVS/SP (TM) Version 4 Release 3 or later. The processor must have enough real storage to satisfy the combined requirements of DB2, MVS/ESA, the appropriate Data Facility Product, appropriate access methods, telecommunications, batch requirements, and other customer required applications. These processors include 3090 (TM), 4381, ES/9000 (R), and S/390 (R) 9672 processors.

The configuration must include sufficient I/O devices to support the requirements for system output, system residence, and system data sets. Sufficient direct access storage (DASD) must be available to satisfy the user's information storage requirements and can consist of any direct access facility supported by the system configuration and the programming system.

Auxiliary Storage: DB2 is independent of both DASD and tape device type. The customer can use any magnetic, optical or tape device supported by the data facilities component of DFSMS/MVS (R)) for the DB2 data sets. The following DB2 data sets are supported by the device types listed below:

  • Active recovery log data sets: DASD
  • Archive recovery log data sets: DASD, tape
  • Image copy data sets: DASD, tape
  • Bootstrap data sets: DASD
  • User data sets: DASD
  • DB2 catalog data sets: DASD
  • Work data sets (for utilities): DASD, tape
Where DASD is supported for these data sets, optical storage devices are also supported. However, optical storage devices are only recommended for historical user data. These devices are especially useful with compressed data.

If these data sets are on DASD that is shared with other MVS systems, the customer should use global resource serialization in order to prevent concurrent access by more than one MVS system.

The minimum DASD space requirements (based on installing DB2 using the panel default values) is approximately 350MB. Users need additional DASD space for their data.

If dual logging is used and tape is being used for the log archiving device, at least two tape drives are needed.

Data Communications Devices

DB2 operations can be controlled from:

  • The system console
  • Authorized IMS/ESA (R) Transaction Manager terminals
  • Authorized CICS (R) terminals
  • TSO terminals (by authorized users)
For the data communication devices supported by IMS/ESA Transaction Manager, CICS, and TSO, see the manuals for these products.

Function Dependent Hardware Requirements

  • Sysplex query parallelism has the following dependencies:
    • Processors

      This solution is designed to explore the processing power of the Parallel Sysplex (TM). Any configuration that supports DB2 data sharing supports sysplex query parallelism.

    • Virtual Storage

      DB2 requires a small increase in virtual storage (less than 1KB) above the 16Mb line to manage the parallel tasks for Sysplex query parallelism.

    • Coupling Facility Storage for SCA

      DB2 requires a small amount of SCA storage for processing queries across CPCs. This amount is approximately 25KB and will be allocated when data sharing is enabled.

  • DB2 Installer and Visual Explain require:
    • High resolution monitor
    • Workstation with OS/2
  • Workstation-based Analysis and Tuning requires:
    • High resolution monitor
    • Workstation with OS/2
  • DB2 Performance Monitor Feature
    • For the host-based Online Monitor:
      • Display station that is supported by Interactive System Productivity Facility (ISPF)
    • For the host-based graphics facility:
      • IBM color graphics display station, or equivalent, that is supported by Graphical Data Display Manager (GDDM (R))
    • For the workstation-based Online Monitor:
      • High resolution monitor
      • Workstation with OS/2
  • DB2 Estimator Feature
    • A computer that supports any of the following:
      • OS/2 with WIN-OS/2
      • Windows 3.1
      • Windows 95
      • Windows NT
Software Requirements
  • Operating System

    For an OS/390 environment, DB2 requires the function provided by the following licensed programs or their equivalents; later versions or releases of any product are acceptable.

    • OS/390 Release 1 (5645-001)
    • DFSORT (TM) feature
    For an MVS/ESA environment, DB2 requires the function provided by the following licensed programs or their equivalents; later versions or releases of any product are acceptable.
    • MVS/System Product Version 4 Release 3 (5695-047 or 5695-048) or MVS/ESA Version 5 Release 1 (5655-068 or 5655-069) plus the following programs:
      • DFSMS (TM) Version 1 Release 2 (5695-DF1) or MVS Data Facility Product (MVS/DFP (TM)) Version 3 Release 3 (5665-XA3)
      • TSO Extensions (TSO/E) Version 2 Release 5 (5685-025)
      • DFSORT Version 1 Release 13 (5740-SM1)
      • System Modification Program Extended (SMP/E) Version 1 Release 8.1 (5668-949)
      • Interactive System Productivity Facility (ISPF) Version 3 Release 5 (5685-054) and ISPF/Program Development Facility (ISPF/PDF or PDF) Version 3 Release 5 (5665-402), or ISPF for MVS Version 4 Release 2 (5655-042)
      • IBM High Level Assembler/MVS Version 1 Release 2 (5696-234)
  • Optional Programs: Following are the optional program products for use with DB2 for OS/390 Version 5. Unless otherwise specified, the release shown for a product and any follow-on release, currently available, is acceptable.

    Distributed Data Facility

    In order to use the DB2 Distributed Data Facility, the following licensed program or its equivalent is required:

    • Advanced Communication Function/Virtual Telecommunications Access Method (ACF/VTAM (R)) Version 3 Release 4.2 (5685-085) for MVS/ESA, or ACF/VTAM (R) Version 4 Release 2 for MVS/ESA (5695-117)
    In addition to any DRDA compliant database management systems, DB2 for OS/390 Version 5 supports the following IBM relational database products:
    • The DB2 Version 2 family of products (see Software Announcement 295-185 and 296-053):

      DB2 for OS/2, DB2 for AIX (R), DB2 for HP-UX, DB2 for Solaris Operating Environment, DB2 for Windows NT, DB2 for SINIX

    • DB2 Parallel Edition for AIX (see Software Announcement 295-182),
    • IBM Operating System/400 (R) (OS/400 (R)) Version 3 Release 1 with DB2/400 (R) (5763-SS1), or IBM Operating System/400 (OS/400) Version 2 Release 3 (5738-SS1) with IBM Structured Query Language/400 (SQL/400 (R)) Version 2 Release 3 (5738-ST1)
    • IBM Structured Query Language/Data System(SQL/DS (TM)) Version 3 Release 4 (5688-103)
For specific software requirements for the above products, refer to the respective product announcements.

Programming Languages

The following IBM Programming Languages and the previously mentioned Assembler have an interface to DB2:

ADA: IBM ADA/370 Version 1 Release 3 (5706-292) and IBM ADA Runtime Library 370 Version 1 Release 3 (5706-295) with SQL MP feature for DB2

APL2 (R): APL2 Version 2 Release 2 (5688-228); APL2 Application Environment Version 2 Release 2 (5688-229)

BASIC: IBM BASIC/MVS Version 1 Release 2 (5665-948)

C: IBM AD/Cycle (R) C/370 (TM) Compiler Version 1 Release 2 (5688-216); IBM C/370 Library Version 2 Release 2 (5688-188)

C++: C/C++ for MVS/ESA Version 3 Release 1 (5655-121)

COBOL: IBM COBOL for MVS and VM Version 1 Release 2 (5688-197) or VS COBOL II Compiler and Library Version 1 Release 4 (5668-958)

FORTRAN: VS FORTRAN Compiler, Library, and Interactive Debugger Version 2 Release 6 (5668-806)

LE: IBM Language Environment (R) for MVS and VM Version 1 Release 5 (5688-198)

PL/I: IBM PL/I for MVS and VM Version 1 Release 1.1 (5688-235) or OS PL/I Compiler, Library, and Interactive Test Facility Version 2 Release 3 (5668-909)

PROLOG: IBM SAA (R) AD/CYCLE PROLOG/MVS Version 1 (5696-309)

Transaction Management

The following transaction management products work with DB2:

  • Information Management System (IMS)
    • IMS/ESA Version 5 (5695-176)
    • IMS/ESA TM Version 4 (5685-013)
  • Customer Information Control System (CICS)
    • CICS Transaction Server for OS/390 Release 1 (5655-147)
    • CICS/ESA (R) Version 4 (5655-018)
    • CICS/ESA Version 3 Release 3 (5685-083)
    Query Support
    • Query Management Facility (QMF (TM)) Version 3 Release 1.1 (5706-254)
    Application Development
    • IBM VisualAge (R) for OS/2, V3.0
    • IBM VisualGen (TM) Version 1 Release 1 (5648-040) or CSP Version 3 Release 3 or VisualAge Generator Version 2 Release 2
    • IBM Cooperative Development Environment/370 Version 1 Release 2 (5688-194)
    • Application System (AS) Version 3 (5648-018) or Application System (AS) Version 4 (5648-092)
    • IBM Data Interpretation System (DIS) Version 2 Release 1 (5622-877)
    Operational Support
    • BookManager (R) READ/MVS Version 1 Release 2 (5695-046), BookManager READ/VM Version 1 Release 2 (5684-062), or IBM AIX BookManager READ/6000 Version 1 Release 2 (5765-086)
    • Resource Access Control Facility (RACF (TM)) Version 2 Release 1 for MVS (5695-039), or RACF Version 1 Release 9 (5740-XXH)
    • Data Facility Hierarchical Storage Manager (DFHSM) Version 2 Release 6 (5665-329)
    • NetView Version 2 Release 4 (5685-111), or NetView Version 3 for MVS/ESA (5655-007)
    • Performance Reporter for MVS Version 1 Release 2 (5695-101)
    Replication Support
    • DataPropagator (TM) Relational Apply for MVS Version 1 Release 2.1 (5622-267)
    • DataPropagator Relational Capture for MVS Version 1 Release 2.1 (5655-076)
    • DataPropagator NonRelational MVS/ESA Version 2 (5696-705)
    • IBM DataRefresher (TM) Version 1 (5696-703)
    Database Administration and Systems Management Support
    • IBM DataHub (R) for OS/2 Version 2 (33H4460)
    • IBM DataHub Support/MVS Version 1 Release 2 (5695-166)
    • DB2 Automated Utility Generator (DB2AUG) Version 1 Release 2 (5695-077)
    • DATABASE 2 (TM) Administration Tool for MVS/ESA Version 1 (5688-515)
  • Function-Dependent Program Requirements

    DB2 has the following function-specific dependencies:

    • DB2 Data Sharing requires MVS/ESA Version 5 Release 1 or later

    • DB2 DDF has the following enhancements if VTAM Version 4 Release 4 or later is used:
      • The CPU cost of DDF's VTAM send/receive operations can be reduced
      • The SECURITY ERROR CODES install option can be used to control how DB2 reports security errors to DDF clients.
    • DB2 sysplex query parallelism has the following dependencies:
      • MVS/ESA Version 5 Release 2 enclave services
    • Object-Oriented COBOL extension support requires IBM COBOL for MVS and VM Version 1 Release 2 (5688-197) and IBM Language Environment Version 1 Release 5 (5688-198)

    • C++ host language support requires IBM C/C++ for MVS/ESA Version 3 Release 1 (5655-121) and IBM Language Environment Version 1 Release 4 (5688-198)

    • BSAM striping requires DFSMS Version 1 Release 1

    • DB2 Installer requires OS/2 Version 3 (Warp, 5801-AAR).

      Additionally, if you want to run jobs from the workstation to the host, you need TCP/IP for OS/2 or OS/2 Warp Connect (10H9800), and TCP/IP for MVS Version 3 Release 1 (5655-HAL).

    • DB2 Visual Explain requires the following:
      • OS/2 Version 3 (Warp)

      • Distributed Database Connection Services (DDCS), with DB2 for OS/2 Version 2 client workstation (CAE).

        Note: A complimentary single user copy of DDCS will be shipped with every DB2 V5 order.

      • DB2 Visual Explain subsystem parameter browser function requires an activated stored procedures address space.
    • DB2 support for the DCE Security Server requires OS/390 Release 1 (5645-001) plus the optional Security Server

    • Native TCP/IP Network support requires OS/390 Release 3 (5645-001) with APAR UW33483

    • RRS attachment facility (RRSAF) support requires OS/390 Release 3 RRSAF, which uses the MVS system logger. In OS/390 R3, the MVS system logger requires a coupling facility.

    • OS/390 Release 3 is required for the following Stored Procedures enhancements:
      • Priority-based queueing of stored procedure requests
      • Stored procedure dispatching priority inherited from caller's dispatching priority
      • Multiple stored procedure address spaces
      • Dynamic management of the number of stored procedure address spaces
      • Management of storage used for subprogram load modules uses the OS/390 base service, Language Environment for OS/390 and VM
      • Additional RACF environments for selected stored procedures requires the OS/390 optional feature, Security Server, or RACF 2.2 with APAR OW15720
    • DB2 call level interface (CLI) requires the following:
      • For application development, C/C++ for MVS/ESA Version 3 Release 1 or IBM AD/CYCLE C/370 Compiler Version 1 Release 2 can be used
      • For application execution, IBM Language Environment for MVS and VM Version 1 Release 5 or the MVS C/C++ Language Support feature of MVS/ESA Version 5 Release 2 can be used
    • Workstation-based Analysis and Tuning requires:
      • OS/2 Warp Version 3 or above
      • Communications Manager/2 Version 1.11 or above
    • DB2 Performance Monitor Feature requires:
      • For the host-based functions:

        DB2 PM runs, in the same MVS environments as listed above for DB2 Server for OS/390

      • For the host-based graphics facility:
        • Graphical Data Display Manager (GDDM) Version 2 Release 3 (5665-356)
        • GDDM Presentation Graphics Feature (GDDM/PGF) Version 2 Release 1.1 (5668-812)
      • For the workstation-based Online Monitor:
        • OS/2 Warp Version 3 or above
        • Communications Manager/2 Version 1.11 or above
    • DB2 Estimator Feature requires any of the following:
      • OS/2 with WIN-OS/2 Version 2 or above
      • Windows 3.1
      • Windows 95
      • Windows NT
    • Net.Data Feature requires:
      • Either of the following:
        • OS/390 Release 1 (5645-001)
        • MVS Version 5.2.2 (5655-068 or 5655-069)
      • HTTP Web Server

        You must have an HTTP Web server installed on the server with Net.Data. It may be another HTTP compliant Web server or one of the following:

        • IBM Internet Connection Server for MVS/ESA Version 1 Release 1 for OS/390 (5655-156)

        • IBM Internet Connection Secure Server Version 2 Release 1 for OS/390 (5697-B14)

          Note: To use the Secured Socket Layer (SSL) function, you need IBM Internet Connection Secure Server. Version 2 Release 1 or later for OS/390.

        • IBM Internet Connection Secure Server Version 2 Release 2 for OS/390 (5697-B14)
      • Language Environment 370 Version 1 Release 5 (5688-198)

        Note: You must apply LE 1.5 service: UN88194, UN88416, UN88461, and UN87133

Compatibility

DB2

DB2 V5 is upwardly compatible with prior releases of DB2 for MVS/ESA. Successful migration with full fallback protection requires that customers migrate DB2 releases sequentially. Thus, existing customers should ensure that they are successfully running on DB2 V4 before migrating to DB2 V5.

DB2 Performance Monitor Feature

The new DB2 Performance Monitor Feature is upwardly compatible with the following previous DB2 Performance Monitor products:

  • DB2 PM for MVS Version 4 Release 1 (5655-102)
  • DB2 PM for MVS Version 3 Release 2 (5655-047)
  • DB2 PM for MVS Version 3 Release 1 (5655-047)
The migration process is simplified by conversion utilities that come along with the DB2 Performance Monitor Feature.

The DB2 Performance Monitor Feature even supports an environment of multiple DB2 releases, namely instrumentation, catalog, and PLAN_TABLE data from:

  • DB2 for OS/390 Version 5 (5655-DB2)
  • DB2 for MVS/ESA Version 4 (5695-DB2)
  • DB2 for MVS Version 3 (5685-DB2)
Performance Considerations

This release of DB2 Server for OS/390 contains many enhancements that contribute to improved performance and availability. Major highlights include:

Query Performance

Long running complex queries may see improvements in elapsed and cpu time of up to 10 times. Factors contributing to this include:

  • Improved statistics and utilization of them
  • Runtime evaluation of host variables, parameter markers, and special registers to determine access path selection
  • Index key column correlation statistics
  • Usage of non-uniform distribution statistics for LIKE predicate with wildcard values
  • Indexable scalar functions and non-column expressions
  • CASE expressions
  • Increased parallelism exploitation
Parallelism support continues to be improved. DB2 V5 introduces Sysplex Query Parallelism which adds the full power of the Sysplex to query execution. Tests have shown improvements in elapsed time of I/O-intensive queries of up to 29 times with 30 partitions. CP-intensive queries have shown performance improvements of up to 18 times in reduced elapsed time with 2 CPCs having 10 processors each. In both cases, a nearly linear scalability is exhibited, with the elapsed time improvement achieving 90% or higher of the theoretical maximum.

Other parallelism enhancements to DB2 V5 include:

  • Parallel non-partitioned index access
  • Parallel Groupby and Orderby sort in multi-table queries
  • Parallel degree refinements
  • Increase to a maximum of 254 partitions for a maximum of 254(degs) of parallelism
  • Parallelism for subselect of an Insert
  • Parallel noncontiguous partition scan
  • Parallel partition scan for join
Utility Performance

Highlights of Utility enhancements for performance and availability include the addition of online reorg, which allows nearly full data availability during the reorganization. Other utility enhancements include:

  • Sampling may improve Runstats for non-indexed column stats. Lab tests showed up to 50% cpu reduction with 5% sampling. This is dependent on factors such as number and length of columns and their uniqueness.
  • Load and recover index may reduce cpu time up to 35% due to inline module execution. The biggest improvements occur on tables with fewest columns and indexes.
  • Faster LOAD and REORG may see improvements up to 40%. This is due to adding multi-tasking for index key sorting and the use of memory rather than work files. The improvement is bigger on tables with many indexes.
  • The embedded copy option of LOAD/REORG may yield a 20% reduction in elapsed time.
  • Recovery of a logical partition of a non-partitioned index may improve by up to six times.
  • BSAM stripping of utility datasets may improve elapsed time by up to 10%.
  • Online REORG allows nearly full availability of data during the REORG process.
Data Sharing

Locking improvements contribute to improved data sharing performance including reduced page P-lock contentions, reduced IRLM latch contention, improved algorithms to reduce false contention.

DRDA

Lab tests showed an average of 10% reduction of cpu time in DRDA through reduced numbers of messages exchanged, VTAM V4.4 improvements, and Optimize for N Rows. Stored procedures can now execute in multiple address spaces, run at priority set by the SQL CALL, Commit on return, and save overhead by starting as subprogram instead of main program. For installations using DB2 Server for OS/390 as a server for ASCII data, the new ASCII Table support can eliminate the CPU time needed to convert data from an ASCII requestor before storing the data as EBCDIC on the server.

User Group Requirements: This announcement satisfies or partially satisfies requirements from one or more of the worldwide user group communities, which include Australasian SHARE/GUIDE (ASG), COMMON, COMMON Europe, GUIDE International, G.U.I.D.E. Europe, Japan GUIDE/SHARE (JGS), Guide Latin American (LAG), SHARE EUROPE and SHARE Incorporated.

Data Sharing

REQ00059802 Switch to non-gbp dependent state REQ00057971 Usage of SFM-policy in case of link failure to GBPx REQ00061047 P-Locks managing in a Data Sharing environment REQ00057398 Automatic rebuild of GBP structure

Distributed Functions

REQ00045598 Inhibiting the block fetch protocol REQ00049309 Native TCP/IP access to MVS DB2 database REQ00059657 850 code page DB2/2 (R) DDCS connecting to 937 code page DB2

Large Table Support

EBDB2F90019 Partitioned Tablespace REQ00006456 Remove the 64 Gigabyte table size limitation REQ00009928 Having 64 partitions without the 1 gigabyte limit REQ00013667 Increase the maximum number of partitions in a partitioned TS REQ00021991 64 partitions of 1 gigabytes limit EBDB2D94001 Allow DISPLAY DATABASE commands for a single partition EBDB2D94020 Partitioned tablespace with more 64 partitions Utilities

JDDB0292007 Concurrent Execution of REORG and Application Systems EBDB2F93213 UTILITY: Sort phase improvement EBDB2S90028 Imagecopy during LOAD and REORG GBDB2X89071 Allow "O" condition code when loading with "LOG NO" GBDB2X90037 Additional COPYPEND status flag needed GGDB3094015 Image Copy Full, YES/NO switching, threshold LBDBII94004 Utility to gather the number of pages updated EBDB2U88003 RUNSTATS to record count of changed pages in catalog REQ00013126 Warning on bad space map page at time image copy taken SDRDBX87121 Date Last Changed Facility for DB2 CMDABA90007 Change indicator for tablespaces 2 EBDB2D89017 User Parm Changed Pages in Image Copy EBDB2F93220 Empty Incremental Image Copy REQ00056653 Enhancement to DSN1COMP Utility REQ00053833 DB2 DSN1COPY utility default blksize REQ00052454 Allow comments within SYSIN input stream for DB2 utilities EBDB2D94006 Allow incremental image copy after LOAD resume EBDB2D89016 Automatic Switch from Incremental IC to Full IC EBDB2F90010 RUNSTATS collecting data on all columns of an index REQ00022615 Possibility of Incremental IC after a Load resume REQ00013892 DB2 Report Utility -- enhancement request REQ00011375 Incremental Copy REQ00002732 Allow comment lines in DB2 Utility Jobs REQ00002737 Image Copy not Required for All Tables REQ00058509 Online Utilities. GBDB2X89103 IMAGCOPY statistics should be saved in SYSCOPY JDDB0290012 Data base which is reorganizable during the online mode EBDB2S91010 Incremental image copy after DB2-LOAD with LOG YES

SQL 92 Conformance

EBDB2S93004 DB2, Support for SQL-92 GBDB2X91007 Support temporary table for the life of a thread GBDB2X89084 Eliminate logging or installation specified tablespaces EBDB2D89009 Temporary tables EBDB2I94014 Support for temporary table REQ00008596 Allow DB2 option of nonrecoverable tablespace REQ00020292 Add option to DB2 tablespace definition for nonrecoverable EBDB2F90004 Request for a "scratch pad" facility EBDB2S90012 Too much logging EBDB2F93219 Database without LOGGING EBDB2D89013 Nonrecoverable Table (spaces)

Precompiler Support

REQ00042963 DB2 Precompiler causes msgicyps2023i during COBOL compile step REQ00046202 Message IGYPS2015-I for COBOL-II, COBOL370 in DB2 Precompiler Security

REQ00052265 DB2/RACF Interface GGSE1094017 Provide Security for DB2 Objects with RACF REQ00042454 Increased Usability of Secondary IDs SDRDBX87400 Standardized External Security Interface GBDB2X86037 User Exit is needed to validate authorization EBRDBS87033 DB2 SYSOPR database authority EBDB2D89004 EXITs for GRANT- and CREATE-Statement EBDB2S89028 DB2 V2 -- SYSOPR privileges EBDB2D90011 Increase maximum number of secondary authids GBDB2X90001 Provide SIGNON capability using CALL ATTACH GBDB2X87022 Preserve Authorization on Dropped DB2 Object EBDB2S90038 BIND validation by secondary authorization ID's GBDB2X90092 DB2 IVP jobstream should support an install sysadm which GBDB2X91059 Definition of Access Privileges before Object Exists SARDBX92019 No Duplicated DB2 Security Authorizations GBDB2X92001 Installation SYSOPR should have STOPDB & STARTDB authorization GBDB2X92048 Global Security Administration GBDB2X92065 Ability to GRANT authorization for specific time period REQ00013663 Requirement is for all DB2 security be under RACF control REQ00012922 Secondary auth ID group limit increase -- DB2 REQ00011779 DB2 choice of security authorization REQ00008183 Additional DB2 exit to allow RACF more control in authorization REQ00006994 Consistency with primary/secondary ID's when ASXBUSER field ch REQ00006555 Change in CREATE authorization rules REQ00006462 Additional DB2 exit to allow RACF more control in authorization

Other Enhancements

REQ00056880 Extended MCS Support REQ00056423 Modify gets abend80a when processing 8500+ sysins REQ00056321 Undocumented Parameters for DSNJU003 in DB2 Ver4 DataSharing J REQ00054588 DSNTIJD Needs Additional Checking to Avoid Data Loss REQ00053996 Install SYSADM Required for start of all catalog objects EBDB2F95302 Use of Column Distribution in Static SQL REQ00052467 DSNTIJTC and space allocation REQ00050261 DB2 collect data distr. stats. for col. not first index key REQ00047102 Design change to DB2 Optimizer EBDB2D94001 Allow DISPLAY DATABASE commands for a single partition REQ00043804 Performance problem with the version 230 SDRDBX87121 Date last changed facility for DB2 GBDB2X90030 Allow optimizer to use additional distribution statistics GBDB2X88063 Ability to lock a partition of a tablespace JDDB0292009 Limitation of Lock Escalation REQ00020292 Add option to DB2 tablespace definition for nonrecoverable REQ00008188 Performance trace record IFCID 22 REQ00008190 DB2 -- not using "INDEX ONLY" access path REQ00062945 Change COBOL installation defaults to a current COBOL REQ00051727 Preformatting Active Logs REQ00044043 CREATE LIKE not allowed even though SELECT authority is grante GDDB2X88034 Provide a scalar function to TRIM unwanted column data GBDB2X87055 Support for Extended Dynamics in DB2 GBDB2X87001 Synchronize Timestamps For the DB2 EXPLAIN command results EBRDBS88028 Redefine tables EBRDBS88022 DATE and TIME-format in the system catalog GBDB2X86024 Fully qualified Table/View Name as a variable EBDB2I89012 New column functions GBDB2X89080 Support monitoring and control of commit frequency by the REQ00020609 Need for PUBLIC bit in package SKPT header REQ00020407 DB2 needs facility to allow renameing of DB2 Objects REQ00009933 Need ability to rename DB2 objects easily



Planning Information

Customer Responsibilities: Customers should review the sections in this announcement that describe the hardware and software dependencies for DB2 V5.

Installability

Customers should refer to the planning sections of the following publications:

  • Release Guide (SC26-8965)
  • Installation Guide (GC26-8970)
  • Data Sharing: Planning and Administration (SC26-8961)
available from an IBM representative, as well as the Program Directory shipped with the product.

Packaging

DB2 Product, DB2 Performance Monitor Feature, and Net.Data Feature: The DB2 Product, DB2 Performance Monitor Feature, and Net.Data Feature will be shipped on 9-track magnetic tapes (written at 6250 BPI), 3480 cartridges, or 4-mm DAT cartridges.

The Workstation-based Installer and Visual Explain functions will be shipped on CD-ROM.

Also included will be a memo to users, a Program Directory, and under separate cover, one copy of the DB2 Product and DB2 Performance Monitor Feature publications.

DB2 Estimator Feature: The DB2 Estimator Feature will be shipped on 3.5-inch diskettes.



Security, Auditability, and Control

DB2 V5 uses the security and auditability features of the host MVS/ESA systems. It also provides facilities for the protection and control of its resources. These facilities include controls for:

  • System access
  • Data access and control
  • Concurrent access
  • Data recovery
  • Accounting
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.



ORDERING INFORMATION

The following advance publications are available now. To order, contact your IBM representative.

                                                  Order
Title                                             Number

DB2 for OS/390 Version 5 What's New GC26-8971 DB2 for OS/390 Version 5 Release Guide SC26-8965 DB2 PM Version 5 General Information GC26-8982



New Licensees

Orders for new licenses will be accepted now.

Shipment will begin on the planned availability date.

New users of DB2 V5 should specify:

         Type           Model

5655 DB2

DB2 PM "Try & Buy" Program: If you are participating in the "Try & Buy" program for the DB2 Performance Monitor Feature, you do not need to order the DB2 Performance Monitor Feature initially. At the conclusion of the "Try & Buy" program, if you choose to continue using the DB2 Performance Monitor Feature, then you need to order it via MES.

DB2 Estimator Feature: DB2 Estimator Feature is a no charge feature of DB2 Server for OS/390.

Net.Data Feature: Net.Data Feature is a no charge feature of DB2 Server for OS/390.

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

Also, specify the feature number of the desired distribution medium.

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

18 0018 0003 20 0019 0004 25 0020 0005 28 0021 0006 29 0022 0007 30 0023 0008 31 0024 0009 32 0025 0010 35 0026 0011 38 0027 0012 40 0028 0013 50 0029 0014 60 0030 0015 70 0031 0016 80 0032 0017

Multiple Operating System -- PR/SM (TM) (MOSP): For a graduated one-time charge or graduated monthly license charge, specify the following feature numbers, corresponding to the group that contains the designated machine.

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

18 0048 0033 20 0049 0034 25 0050 0035 28 0051 0036 29 0052 0037 30 0053 0038 31 0054 0039 32 0055 0040 35 0056 0041 38 0057 0042 40 0058 0043 50 0059 0044 60 0060 0045 70 0061 0046 80 0062 0047

DB2 Performance Monitor Feature: For a graduated one-time charge or graduated monthly license charge specify one of the following feature numbers as applicable and corresponding to the group that contains the designated machine.

Also, specify the feature number of the desired distribution medium.

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

18 0078 0063 20 0079 0064 25 0080 0065 28 0081 0066 29 0082 0067 30 0083 0068 31 0084 0069 32 0085 0070 35 0086 0071 38 0087 0072 40 0088 0073 50 0089 0074 60 0090 0075 70 0091 0076 80 0092 0077

Multiple Operating System -- PR/SM (MOSP): For a graduated one-time charge or graduated monthly license charge, specify the following feature numbers, corresponding to the group that contains the designated machine.

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

18 0108 0093 20 0109 0094 25 0110 0095 28 0111 0096 29 0112 0097 30 0113 0098 31 0114 0099 32 0115 0100 35 0116 0101 38 0117 0102 40 0118 0103 50 0119 0104 60 0120 0105 70 0121 0106 80 0122 0107

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

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

                                           ESL
                                     One-Time Charge
Program Number/Description            Feature Number

5655-DB2/DB2 for OS/390 0001

                                           ESL
                                     One-Time Charge
Program Number/Description            Feature Number

5655-DB2/DB2 for OS/390 0002 DB2 Performance Monitor Feature

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

Parallel Sysplex License Charge (PSLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the PSLC Base feature. If applicable, specify the PSLC Level A and PSLC Level B features and quantity.

If there is more than one program copy in a Parallel Sysplex, the charge for all copies is associated to one license by specifying the applicable PSLC feature numbers and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the PSLC No-Charge (NC) Identifier feature on the licenses.

Also, specify the feature number of the desired distribution medium.

                    PSLC           PSLC Basic License
Machine             Feature        MLC Feature
MSU Capacity        Number         Description

1 0151 PSLC Base, 1 MSU 2 0152 PSLC Base, 2 MSUs

3 0153 PSLC Base, 3 MSUs

4 -- 45 0154 PSLC Level A, 1 MSU 0155 PSLC Level A, 42 MSUs

46 or more 0156 PSLC Level B, 1 MSU 0157 PSLC Level B, 10 MSUs 0158 PSLC Level B, 50 MSUs

NA 0159 PSLC N/C ID

Example 1: For a single machine with 11 MSUs, the PSLC features would be 0153 -- quantity 1 and 0154 -- quantity 8.

Example 2: For two machines in a Parallel Sysplex which have an aggregation of 60 MSUs, the PSLC features would be:

  • PSLC chargeable license #1: 0153 -- quantity 1, 0155 -- quantity 1, 0156 -- quantity 5, and 0157 -- quantity 1
  • PSLC no-charge license #2: 0159 -- quantity 1
DB2 Performance Monitor Feature
                    PSLC           PSLC Basic License
Machine             Feature        MLC Feature
MSU Capacity        Number         Description

1 0160 PSLC Base, 1 MSU 2 0161 PSLC Base, 2 MSUs

3 0162 PSLC Base, 3 MSUs

4 -- 45 0163 PSLC Level A, 1 MSU 0164 PSLC Level A, 42 MSUs

46 or more 0165 PSLC Level B, 1 MSU 0166 PSLC Level B, 10 MSUs 0167 PSLC Level B, 50 MSUs

NA 0168 PSLC N/C ID

Example 1: For a single machine with 11 MSUs, the PSLC features would be 0162 -- quantity 1 and 0163 -- quantity 8.

Example 2: For two machines in a Parallel Sysplex which have an aggregation of 60 MSUs, the PSLC features would be:

  • PSLC chargeable license #1: 0162 -- quantity 1, 0164 -- quantity 1, 0165 -- quantity 5, and 0166 -- quantity 1
  • PSLC no-charge license #2: 0168 -- quantity 1
Indexed Monthly License Charge (IMLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the IMLC Base 80 MSU feature and the applicable additional IMLC MSU feature(s) and quantity corresponding to the MSU rating of the designated machine.

Also, specify the feature number of the desired distribution medium.

IMLC           IMLC Basic License
Feature        MLC Feature
Number         Description

0169 IMLC Base 80 MSUs 0170 IMLC 1 MSU 0171 IMLC 10 MSUs 0172 IMLC 50 MSUs

DB2 Performance Monitor Feature

IMLC           IMLC Basic License
Feature        MLC Feature
Number         Description

0173 IMLC Base 80 MSUs 0174 IMLC 1 MSU 0175 IMLC 10 MSUs 0176 IMLC 50 MSUs

Measured Usage License Charge (MULC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the applicable MSUs Usage Band feature. If usage exceeds 14 MSUs, specify Usage Band 10 feature and the appropriate additional MSUs features and quantity. When multiple versions of a program are operating on the same machine, select the highest version MULC feature number. For lower versions, specify the MULC No-Charge Identifier feature.

In a Parallel Sysplex, if there is more than one program copy or version, the charge for all copies and versions should be associated to the highest version copy by specifying the applicable MULC features represented by the sum of the MSUs used by the programs in the Parallel Sysplex. For all other program copies and versions, specify the MULC No-Charge Identifier feature.

Also, specify the feature number of the desired distribution medium.

                                      MULC
Usage                                 Feature
Band      Usage Range (MSUs)          Number

1 0 -- .250 0123 2 .251 -- .500 0124 3 .501 -- 1.000 0125 4 1.001 -- 1.500 0126 5 1.501 -- 2.500 0127 6 2.501 -- 3.500 0128 7 3.501 -- 5.500 0129 8 5.501 -- 7.500 0130 9 7.501 -- 10.500 0131 10 10.501 -- 14.000 0132 MULC N/C ID 0136

Above 14.000 MSU: Each additional 1 MSU 0133 Each additional 10 MSUs 0134 Each additional 50 MSUs 0135

DB2 Performance Monitor Feature

                                      MULC
Usage                                 Feature
Band      Usage Range (MSUs)          Number

1 0 -- .250 0137 2 .251 -- .500 0138 3 .501 -- 1.000 0139 4 1.001 -- 1.500 0140 5 1.501 -- 2.500 0141 6 2.501 -- 3.500 0142 7 3.501 -- 5.500 0143 8 5.501 -- 7.500 0144 9 7.501 -- 10.500 0145 10 10.501 -- 14.000 0146 MULC N/C ID 0150

Above 14.000 MSU: Each additional 1 MSU 0147 Each additional 10 MSUs 0148 Each additional 50 MSUs 0149

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

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

Basic Machine-Readable Material

To order, select the feature number of the desired distribution medium:

                           Feature
Environment                Number      Distribution Medium

DB2 for OS/390 5821 9/6250 Magnetic Tape (Includes DB2 PM 5822 3480 Cartridge "Try") 6270 4-mm DAT Cartridge

DB2 PM Feature 5831 9/6250 Magnetic Tape (DB2 PM "Buy") 5832 3480 Cartridge 6280 4-mm DAT Cartridge

DB2 Estimator Feature 5815 3.5-inch Diskette (a no charge feature)

Net.Data Feature 5841 9/6250 Magnetic Tape (a no charge feature) 5842 3480 Cartridge 6290 4-mm DAT Cartridge

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

Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.

                                                    Feature
Description                                         Number

Initial Shipments

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

Ship Media Only (suppresses initial 3470 shipment of documentation)

Ship Documentation Only (suppresses 3471 initial shipment of media)

Update Shipments

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

Ship Documentation Only (suppresses 3481 update shipment of media)

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

Expedite Shipments

Local IBM Office Expedite 3445 (for IBM use only)

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

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

Optional Machine-Readable Material

To order, select the feature number for the desired distribution medium.

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

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

18 0192 0177 20 0193 0178 25 0194 0179 28 0195 0180 29 0196 0181 30 0197 0182 31 0198 0183 32 0199 0184 35 0200 0185 38 0201 0186 40 0202 0187 50 0203 0188 60 0204 0189 70 0205 0190 80 0206 0191

Multiple Operating System -- PR/SM (MOSP): For a graduated one-time charge or graduated monthly license charge specify the following feature numbers corresponding to the group that contains the designated machine.

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

18 0222 0207 20 0223 0208 25 0224 0209 28 0225 0210 29 0226 0211 30 0227 0212 31 0228 0213 32 0229 0214 35 0230 0215 38 0231 0216 40 0232 0217 50 0233 0218 60 0234 0219 70 0235 0220 80 0236 0221

DB2 Performance Monitor Feature

To order the DSLO license for this feature, specify the program number, feature number 9901 for asset registration, and the feature number for a graduated one-time charge or graduated monthly license charge that corresponds to the group containing the designated machine.

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

18 0252 0237 20 0253 0238 25 0254 0239 28 0255 0240 29 0256 0241 30 0257 0242 31 0258 0243 32 0259 0244 35 0260 0245 38 0261 0246 40 0262 0247 50 0263 0248 60 0264 0249 70 0265 0250 80 0266 0251

Multiple Operating System -- PR/SM (MOSP): For a graduated one-time charge or graduated monthly license charge specify the following feature numbers corresponding to the group that contains the designated machine.

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

18 0282 0267 20 0283 0268 25 0284 0269 28 0285 0270 29 0286 0271 30 0287 0272 31 0288 0273 32 0289 0274 35 0290 0275 38 0291 0276 40 0292 0277 50 0293 0278 60 0294 0279 70 0295 0280 80 0296 0281

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

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

                                                       Order
Title                                                  Number

DB2 for OS/390 Version 5 Administration SC26-8957 Guide DB2 for OS/390 Version 5 Application SC26-8958 Programming & SQL Guide DB2 for OS/390 Version 5 Call Level SC26-8959 Interface Guide and Reference DB2 for OS/390 Version 5 Command SC26-8960 Reference DB2 for OS/390 Version 5 Data Sharing: SC26-8961 Planning and Administration DB2 for OS/390 Version 5 Data Sharing: SX26-3841 Quick Reference Card DB2 for OS/390 Version 5 Installation Guide GC26-8970 DB2 for OS/390 Version 5 Licensed Program GC26-8969 Specification DB2 for OS/390 Version 5 Messages and GC26-8979 Codes DB2 for OS/390 Version 5 References for SC26-8964 Remote DRDA Requesters and Servers DB2 for OS/390 Version 5 Reference SX26-3842 Summary DB2 for OS/390 Version 5 Release Guide SC26-8965 DB2 for OS/390 Version 5 SQL Reference SC26-8966 DB2 for OS/390 Version 5 Utility Guide and SC26-8967 Reference DB2 for OS/390 Version 5 Portfolio GK2T-9081

All of the above publications can be ordered using bill of forms number SBOF-7407.

DB2 Performance Monitor Feature

As part of the "Try and Buy" program for the DB2 Performance Monitor Feature, the following publications will be delivered along with the DB2 publications previously listed.

                                                  Order
Title                                             Number

DB2 Performance Monitor for OS/390 SC26-8991 Version 5 Batch User's Guide DB2 Performance Monitor for OS/390 SC26-8990 Version 5 Online Monitor User's Guide DB2 Performance Monitor for OS/390 SC26-8985 Version 5 Report Reference Volume I DB2 Performance Monitor for OS/390 SC26-8986 Version 5 Report Reference Volume II DB2 Performance Monitor for OS/390 SC26-8987 Version 5 Command Reference DB2 Performance Monitor for OS/390 SC26-8988 Version 5 Messages DB2 Performance Monitor for OS/390 SC26-8984 Version 5 Master Index DB2 Performance Monitor for OS/390 GC26-8982 Version 5 General Information DB2 Performance Monitor for OS/390 SC26-8989 Version 5 Getting Started on the Workstation

All of the above publications can be ordered using bill of forms number SBOF-7410.

Additional copies of unlicensed publications are available immediately for a fee. These copies may be ordered from your IBM representative, through the System Library Subscription Service (SLSS), or by direct order.

Net.Data Feature

No hardcopy publications are shipped with the Net.Data Feature.

Net.Data manuals are offered in displayable softcopy form. The following documentation is provided:

  • Net.Data Programming Guide
  • Net.Data Reference Guide
  • Net.Data Language Environment Guide
  • Net.Data Messages and Codes
The manuals are HTML documents and can be browsed with any Web browser. These documents will be available at no charge on the Internet at the following location:
    http://www.software.ibm.com/data/net.data/docs/
Displayable Softcopy Publications

The DB2 Server for OS/390 publications, including the DB2 Performance Monitor Feature publications, are offered in displayable softcopy form. All unlicensed manuals are included except for:

DB2 for OS/390 Version 5 Licensed                 GC26-8969
 Program Specification
DB2 Performance Monitor for OS/390                SC26-8984
 Version 5 Master Index
DB2 Performance Monitor for OS/390                GC26-8982
 Version 5 General Information

The displayable manuals are part of the basic machine-readable material. The files are shipped on CD-ROM.

These displayable manuals can be used with the BookManager READ licensed programs in any of the supported environments. Terms and conditions for use of the machine-readable files are shipped with the files.

When you order DB2 V5, you are entitled to one copy of the following CD-ROMs containing the DB2 Server for OS/390 online books at no additional charge:

  • DB2 Server for OS/390 Version 5 Licensed Online Book, LK2T-9075
You can order multiple copies for an additional charge by specifying feature code 8207.
  • DB2 Server for OS/390 Version 5 Online Library, SK2T-9092
Periodic updates for both the DB2 and DB2 PM publications will be provided on the collection kit called IBM Online Library Transaction Processing and Data Collection, SK2T-0730, available with DB2 V5.

When you order DB2 V5, you will receive one copy of the collection kit with DB2 V5 at no additional charge. You will automatically receive one copy of the collection kit each time it is updated at no additional charge.

SK2T-9092 will be superseded by SK2T-0730 when updates to the online library are made available.

DB2 books are also available, for an additional charge on the following collection kits, which contain online books for many IBM products:

  • IBM Online Library MVS Collection, SK2T-0710, in English
  • IBM Online Library MVS Collection Kit SK88-8002, in Japanese, for viewing on DOS and Windows platforms
In addition, you can use the Online Message Facility (OMF), an OS/2 program that provides online access to information from BookManager softcopy books, to get information about DB2 messages. The facility, which is included on SK2T-9092 and SK2T-0730, helps network operators and system programmers diagnose problems without interrupting their tasks. For DB2 V5, Messages and Codes is enabled for OMF.

Licensed Documentation: The following licensed material and microfiche will be available from IBM at general availability. To order, contact your IBM representative.

The first copy is supplied automatically with the basic machine-readable material. Use the feature number 82XX to order additional copies for a fee.

                                                  Additional
                                                  Copies
                                   Order          Feature
Title                              Number         Number

DB2 for OS/390 Version 5 LY27-9659 8205 Diagnosis Guide and Reference

DB2 for OS/390 Version 5 LY27-9660 8206 Diagnostic Quick Reference

DB2 for OS/390 Version 5 LK2T-9075 8207 Licensed Online Library

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



TERMS AND CONDITIONS

Licensing: IBM Customer Agreement

Variable Charges Apply: Yes

Measured Usage License Charge (MULC) Applies: Yes

Installation License or Location License Applies: No

Usage Restriction Applies: No

Educational Allowance: Yes, to qualified education customers.

Volume Discount: Not applicable.

Version-To-Version Upgrade Credits Apply: Yes

                                                    Single
Replaced Program(s)    Replacement Program(s)      Version
Program   Program      Program     Program         Charging
Number    Name         Number      Name            Applies

5740-XYR DB2 V1 5695-DB2 DB2 V4 Yes 5655-DB2 DB2 V5 Yes

5665-DB2 DB2 V2 5695-DB2 DB2 V4 Yes 5655-DB2 DB2 V5 Yes

5685-DB2 DB2 V3 5695-DB2 DB2 V4 Yes 5655-DB2 DB2 V5 Yes

5695-DB2 DB2 V4 5655-DB2 DB2 V5 Yes

5655-DB2 DB2 V5 To a follow-on program, N/A if any

DB2 Performance Monitor Feature

                                                    Single
Replaced Program(s)    Replacement Program(s)      Version
Program   Program      Program     Program         Charging
Number    Name         Number      Name            Applies

5665-354 DB2 PM V1 5655-DB2 DB2 V5 Yes*

5685-140 DB2 PM V2 5655-DB2 DB2 V5 Yes*

5655-047 DB2 PM V3 5655-DB2 DB2 V5 Yes*

5655-102 DB2 PM V4 5655-DB2 DB2 V5 Yes*

*     Note 3 of DAWN-0040 applies

Warranted: Yes

Licensed Program Materials Availability

  • Restricted Materials of IBM: None
  • Non-Restricted Source Materials: None
  • Object Code Only (OCO): All
Testing Period: Two months (basic license only)

Program Services

Support Center Applies:           Yes

Access is available through the IBM Support Center

Available Until Discontinued: 12 months written notice

APAR Mailing Address: IBM Corporation APAR Processing P.O. Box 49023 San Jose, CA 95161-9023

Services for DSLO Licenses: Provided through Basic License location



CHARGES

The charges provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

Program Number  5655-DB2

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

18 $ 25,170 $ 18,880 $ 525 $ 394 20 36,500 27,380 761 571 25 47,450 35,590 989 742 28 65,000 48,750 1,355 1,015 29 84,500 63,380 1,760 1,320 30 109,850 82,390 2,290 1,720 31 135,100 101,350 2,815 2,110 32 172,950 129,700 3,605 2,705 35 198,900 149,200 4,145 3,110 38 228,750 171,550 4,765 3,575 40 263,050 197,300 5,480 4,110 50 328,800 246,600 6,850 5,140 60 411,000 308,250 8,565 6,425 70 513,750 385,300 10,710 8,035 80 642,200 481,650 13,390 10,040

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

18 $ 25,170 $ 18,880 $ 525 $ 394 20 30,840 23,130 643 482 25 41,980 31,490 875 656 28 56,230 42,170 1,170 878 29 74,750 56,060 1,560 1,170 30 97,180 72,890 2,025 1,520 31 122,500 91,880 2,555 1,915 32 154,050 115,550 3,210 2,410 35 185,950 139,450 3,875 2,905 38 213,850 160,400 4,455 3,340 40 245,900 184,450 5,125 3,845 50 295,950 221,950 6,165 4,625 60 369,900 277,450 7,710 5,785 70 462,400 346,800 9,640 7,230 80 578,000 433,500 12,050 9,040

                                     One-Time Charge

Entry End User/390 Entry Support License: $8,390

DB2 Performance Monitor Feature

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

18 $ 6,200 $ 4,650 $ 129 $ 97 20 8,990 6,745 187 140 25 11,690 8,770 243 182 28 16,020 12,020 334 251 29 20,820 15,620 434 326 30 27,070 20,300 565 424 31 33,290 24,970 695 521 32 42,610 31,960 888 666 35 49,000 36,750 1,020 765 38 56,350 42,260 1,175 881 40 64,800 48,600 1,350 1,015 50 81,000 60,750 1,690 1,270 60 101,250 75,940 2,110 1,585 70 126,550 94,910 2,640 1,980 80 158,200 118,650 3,295 2,470

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

18 $ 6,200 $ 4,650 $ 129 $ 97 20 7,595 5,695 158 119 25 10,340 7,755 215 161 28 13,860 10,400 288 216 29 18,420 13,820 383 287 30 23,950 17,960 498 374 31 30,180 22,640 628 471 32 37,950 28,460 790 593 35 45,810 34,360 954 716 38 52,680 39,510 1,100 825 40 60,580 45,440 1,265 949 50 72,900 54,680 1,520 1,140 60 91,130 68,350 1,905 1,430 70 113,900 85,430 2,380 1,785 80 142,400 106,800 2,975 2,230

                                     One-Time Charge

Entry End User/390 Entry Support License: $2,065

                                           DB2         PM
MSU                                        Product     Feature
Capacity       Description                 Charge      Charge

1 PSLC Base, 1 MSU $1,175 $ 334 2 PSLC Base, 2 MSUs 1,990 565

3 PSLC Base, 3 MSUs 3,130 888

4 -- 45 PSLC Level A, 1 MSU 164 40 PSLC Level A, 42 MSUs 6,888 1,680

46 or more PSLC Level B, 1 MSU 70 16 PSLC Level B, 10 MSUs 700 160 PSLC Level B, 50 MSUs 3,500 800

                            DB2       PM
                            Product   Feature
IMLC                        IMLC      IMLC
Description                 Charge    Charge

IMLC Base 80 MSUs $12,468 $3,128 IMLC 1 MSU 70 16 IMLC 10 MSUs 700 160 IMLC 50 MSUs 3,500 800

                                   DB2       PM
                                   Product   Feature
Usage     Usage                    MULC      MULC
Band      Range (MSUs)             Charge    Charge

1 0 -- .250 $ 3,130 $ 888 2 .251 -- .500 3,603 1,021 3 .501 -- 1.000 4,145 1,174 4 1.001 -- 1.500 4,643 1,315 5 1.501 -- 2.500 5,200 1,473 6 2.501 -- 3.500 5,829 1,650 7 3.501 -- 5.500 6,585 1,865 8 5.501 -- 7.500 7,772 2,201 9 7.501 -- 10.500 9,637 2,729 10 10.501 -- 14.000 12,468 3,128

Above 14.000 MSU: Each additional 1 MSU 324 81 Each additional 10 MSUs 3,240 810 Each additional 50 MSUs 16,200 4,050

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

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

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

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

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



CALL NOW TO ORDER

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

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

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

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

Note: Shipments will begin after the planned availability date.

Trademarks

      OS/390, MVS/ESA, IMS, Distributed Relational Database
      Architecture, MVS/SP, 3090, Parallel Sysplex, DFSORT, DFSMS,
      MVS/DFP, SQL/DS, C/370, QMF, VisualGen, RACF, DataPropagator,
      DataRefresher, DATABASE 2, PR/SM, System/370, and Business
      Partner are trademarks of International Business Machines
      Corporation in the United States or other countries or both.
      DB2, MVS, OS/2, NetView, Open Blueprint, DRDA, ES/9000, S/390,
      DFSMS/MVS, IMS/ESA, CICS, GDDM, ACF/VTAM, VTAM, AIX, Operating
      System/400, OS/400, DB2/400, SQL/400, APL2, AD/Cycle, Language
      Environment, SAA, CICS/ESA, VisualAge, BookManager, DataHub,
      DB2/2, and System/390 are registered trademarks of
      International Business Machines Corporation in the United
      States or other countries or both.
      Windows and Microsoft are registered trademarks of Microsoft
      Corporation.
      Other company, product, and service names may be trademarks or
      service marks of others.