DB2 for OS/390 Version 5 Enterprise Data Server Addresses the Demands of Client/Server and Data Warehouse Applications

Software Announcement
December 17, 1996
Announcement Letter Number: 296-500


Table of Contents:



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
Increased User Productivity
  • Provides full year 2000 support
  • Provides full conformance to SQL92 Entry Level Standard
  • Provides temporary tables
  • Enables use of object-oriented programming languages
  • Delivers Call Level Interface for ODBC and X/Open's CLI
  • Provides workstation-based: Installation, Visual Explain, and Performance Tuning
DB2 Data Base Server Solution
  • Assists application design and capacity planning with DB2 Estimator for Windows
  • Monitors and optimizes DB2's performance with DB2 PM
  • Provides Internet access with DB2 WWW Connection



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 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 Version 5 delivers major improvements in query processing. 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 to provide the performance needed for complex data analysis used by data mining applications. It increases the limit for table space size to 1TB, and the number of partitions to 254, which may increase availability for mission-critical applications.

Faster utilities improve availability. Also, online REORG allows both read and write operations during database reorganization.

Client/server investments are enhanced with improved stored procedures support to return result sets to the client. Additional connectivity is provided now that DB2 for OS/390 supports native TCP/IP connections, from DRDA (R) clients such as DDCS. Open application access is also improved through support for Call Level Interface (CLI) extensions, plus support for native ASCII encoded tables.

Customers can now choose between host-based or OS/2 (R) workstation-based installation. Application design and development flexibility are extended by support for C++ and for object-oriented COBOL extensions, and by conformance to SQL92 Entry Level Standard.

DB2: IBM's Relational Database Server for MVS/ESA and OS/390

For increased usability and simplification, DB2 Version 5 provides, as a server solution, new features: DB2 Estimator and DB2 Performance Monitor (DB2 PM). For Internet connectivity, DB2 Version 5 provides DB2 World Wide Web Connection for MVS/ESA. On both the new OS/390 server operating system as well as on the MVS/ESA platform, these tools provide the capability to estimate capacity, model SQL performance, monitor and optimize the DB2 subsystem, and make DB2 data available to Internet Web browser clients. With DB2 Version 5 database server support for OS/390, the server elements will have been integration tested together with OS/390 before general availability.

DB2 V5 is using the Quality Partnership Program (QPP) process. Refer to Marketing Announcement 392-061, dated March 17, 1992, for information on the QPP process. IBM will ship the product to customers already selected as participants in the program.

Shipment of the product to customers in the Quality Partnership Program will begin on January 17, 1997.

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

This announcement is provided for your information only. For additional information, contact your IBM representative, call 800-IBM-4YOU, or visit the IBM home page at: %+%Start_URL%+% http://www.ibm.com



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 for OS/390 the super-server of choice for twenty-first century enterprise-wide data management on both OS/390 and MVS/ESA systems.



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 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 off-line 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 non-indexed 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 (R) 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 (TM). Faster block fetch operations, reduced network traffic due to 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 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 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 (TM), 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 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 an OS/2 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 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.

System administration is enhanced with the introduction of the workstation-based Performance Analysis and Tuning function. An entry-level is included with the DB2 Product. It provides the ability to access statistics data, allowing the user to analyze and modify DB2 for OS/390 performance. Context-sensitive help gives the administrator access to tuning recommendations. Full analysis and tuning functionality is available through the DB2 Performance Monitor Feature, a portion of the "Database Server Solution" described below.

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 customers the opportunity to incorporate DB2 for OS/390 into their 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 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 recently, 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.

The DB2 WWW Connection Feature provides support for Internet Access. Businesses are finding many reasons to provide Internet and intranet connectivity from the World Wide Web to their business information. Applications built with DB2 World Wide Web Connection (DB2 WWW) Version 1 are making data stored in any DB2 server more accessible and useful to customers.

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 also available for download from the Internet.

Refer to the Supplemental Information section for more details on all of the above features and for enhancements of the new DB2 Performance Monitor Feature over the former licensed program DB2 Performance Monitor for MVS Version 4 Release 1 (5655-102).

Open Blueprint (TM):

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 Corp.
It supports the Distributed Relational Database Architecture (TM) (DRDA) 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 for OS/390 conforms to SQL92 Entry Level.
Additionally, the ODBC function which 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 4000 test cases written to the Microsoft ODBC Version 2.5 specifications and represents broad usage of ODBC typical of many client server applications.



PRODUCT POSITIONING

DB2 for OS/390 is the super-server of choice for the 21st century 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 (TM), IMS transaction management, MVS batch jobs and via distributed connections from remote clients on numerous platforms.

DB2 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 DB2 World Wide Web Connection.

DB2 for OS/390 supports the initiative by IBM for full year 2000 support. 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, customers 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 migration 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 DDF has been replaced by DRDA. No further enhancements are planned for the private protocol.



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 Catalog of 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. HONE users can use the keyword EDUCATION for descriptions and schedules of these and other courses.

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

Trademarks

 (TM) Trademark of International Business Machines Corporation in the
      United States or other countries or both.
 (R)  Registered trademark of International Business Machines
      Corporation in the United States or other countries or both.
      Microsoft and Windows are registered trademarks of Microsoft
      Corporation.
      Other trademarks and registered trademarks are the properties
      of their respective owners.



SUPPLEMENTAL INFORMATION



Database Server Solution

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

  • DB2 Performance Monitor Feature
  • DB2 WWW Connection 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 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 recently, 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 improvements in the new DB2 Performance Monitor Feature over 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 not needed any longer 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 communication vehicle to the host.

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

    Selected customers are currently evaluating a beta version of the new monitor for validation of its design and ease of use.

  • Support of Sysplex Query Parallelism

    Sysplex Query Parallelism is supported by combining the data from all parallel tasks, regardless on which data sharing member they were executed. You still get an application view of the thread as you did 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 guarantees that the TCB time of parallel tasks and 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 to get a complete picture of the resources that an application has used, no matter on which members the application ran. Performance data of applications that ran on different members is summarized by member and for the whole data sharing group.

    To be able 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 a parallel SORT subtask 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 userID. DB2 PM will, in addition, deliver such 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 would rely solely on DB2 privileges. The user could invoke 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, it should be possible to restrict 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 which is passed 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, for example,

    • to show for each primauth-planname combination which buffer pools were used and how they were used.
    • to show for each buffer pool which applications used it and how they used it.
  • Year 2000 Support

    DB2 PM will comply with the general IBM strategy of providing Year 2000 support within 1996. All DB2 PM functions will be enabled to support the year 2000.

  • 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 timely and comprehensive support of performance evaluation and analysis.

Investment Protection when Migrating: The new DB2 Performance Monitor Feature is upwardly compatible with the former DB2 Performance Monitor products:
  • DB2 PM for MVS Version 4 Release 1 (5655-102)
  • DB2 PM for MVS Version 3 Release 2 (5665-047)
  • DB2 PM for MVS Version 3 Release 1 (5665-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. 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)
thus ensuring protection of your investment.

DB2 WWW Connection Feature: The DB2 WWW Connection Feature provides support for Internet access. Businesses are finding many reasons to provide Internet and intranet connectivity from the World Wide Web to their business information. Applications built with DB2 World Wide Web Connection (DB2 WWW) Version 1 are making data stored in any DB2 server more accessible and useful to customers.

DB2 WWW Connection Version 1 currently provides a CGI-BIN gateway engine and a development environment on OS/2, AIX (R), HP-UX, Solaris, Windows NT, and SCO. Now, IBM is expanding its Internet and intranet connectivity to data to include DB2 for OS/390 and DB2 for MVS/ESA. This porting strategy should meet the needs of customers implementing Internet client/server capabilities on the MVS/ESA platform or on the new OS/390 server operating system. An application built with and managed by DB2 WWW Connection on OS/390 or on MVS/ESA uses the industry-standard HTML and SQL languages, and has the ability to access DB2 data on local or remote servers.

For example, a browser accessing DB2 with DB2 WWW Connection may use a Web page, actually a form managed by DB2 WWW Connection, to submit a customer registration into a DB2 database. Once the registration is complete, the customer can use DB2 WWW Connection to view catalog entries stored in another DB2 database. A Web browser that supports secure hypertext transfer protocol (SHTTP) may allow the customer to place an order by completing and submitting a form (also managed by DB2 WWW Connection) to a data base behind a firewall and a secure server.

DB2 World Wide Web Connection for MVS/ESA Version 1 delivers Internet connectivity to the DB2 V5 server:

  • A new platform for Internet access from any Web browser that supports HTML-forms to data on DB2 for OS/390 or DB2 for MVS/ESA, as well as access to data on other DB2 remote servers.

  • Internet gateway and application development capabilities for DB2 V5 servers.

  • Internet application development with industry standard HTML and SQL.

  • End-user interaction by means of familiar Web page forms.

  • Support for applications developed with industry-standard HTML and SQL languages.

  • Authenticated access to DB2 plus support for various secure schemes with firewall and secure server technology.
DB2 World Wide Connection V1 delivers a leading-edge Internet solution to IBM data management customers. This gateway and application development tool increases the customers' ability to enable business data to the Web, making company information and data more useful in the growing Internet marketplace.

The CGI-BIN gateway approach used by DB2 WWW Connection on all its platforms puts no special requirement on any client, other than the ability to support a Web browser, the most commonly used piece of Internet software.

Look for the program download off the IBM Software homepage 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, and then to DB2 WWW Connection.

More product information is available on the DB2 WWW Connection homepage and download page.

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 homepage 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 homepage and download page.



TECHNICAL INFORMATION



Specified Operating Environment

This product uses only existing attachment interfaces.

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, of MVS/ESA, of 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 for the DB2 data sets. The following DB2 data sets are supported by the following device types:

    • Active recovery log data sets: DASD
    • Archive recovery log dat 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 (TM) 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 1 KB) 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 25 KB 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 WINOS2
      • Windows 3.1
      • Windows 95
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)
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 1 (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 Version 4 Release 2 for MVS/ESA (5695-117)
In addition to any DRDA (R) 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 Announcements 295-185 and 296-053):

    DB2 for OS/2, DB2 for AIX, 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 (TM) (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/370

    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 (TM))
      • 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 (TM) for Smalltalk 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)
    • 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), IBM SAA BookManager READ/2 Version 1 Release 2 Modification 1 (5601-454), IBM BookManager READ/DOS Version 1 Release 2 (5601-453), 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 Non-Relational 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 EXTENDED SECURITY 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 a DB2 for OS/2 Version 2 client workstation and corresponding Distributed Database Connection Services (DDCS), and OS/2 Version 3 (Warp).

    DB2 Visual Explain subsystem parameter browser 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)

  • Data Sharing Enhancements require MVS/ESA Version 5 Release 2

  • RRS attachment facility (RRSAF) requires OS/390 Release 3

  • 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 addition to the above listed MVS environments, in the following environments.
      • For an MVS/ESA System Product Version 4 environment:

        MVS/ESA SP-JES2 Version 4 Release 1 (5695-047) or MVS/ESA SP-JES3 Version 4 Release 1 (5695-048)

      • For an MVS/System Product Version 3 (MVS/ESA) environment:

        MVS/ESA SP-JES2 Version 3 Release 1.3 (5685-001) or MVS/ESA SP-JES3 Version 3 Release 1.3 (5685-002)

      • For an MVS/System Product Version 2 (MVS/XA (TM)) environment:

        MVS/ESA SP-JES2 Version 2 Release 2 (5740-XC6) or MVS/ESA SP-JES3 Version 2 Release 2.1 (5665-291) and Version 2 Release 2.0 SPE

      Important Note:

      Selected functions of DB2 PM utilize the data collector and require MVS/ESA Version 4 Release 3 as a minimum environment. These functions include:

      • Collection of history data
      • Operation of exception processing when a TSO user is not logged on
      • Monitoring of event exceptions
      • Online monitoring of threads exploiting query CP parallelism
      • Data agent for workstation-based monitor
    • 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
  • For the DB2 Estimator Feature any of:
    • OS/2 with WINOS2 Version 2 or above
    • Windows 3.1
    • Windows 95
  • For the DB2 WWW Connection Feature:
    • Either of:
      • OS/390 Release 1 (5645-001)
      • MVS Version 5.2.2 (5655-068 or 5655-069)
    • Language Environment 370 Version 1 Release 5 (5688-198) NOTE: You must apply LE 1.5 service: UN88194, UN88416, UN88461, and UN87133
    • IBM C/C++ for MVS/ESA Version 3 Release 1 (5655-121) NOTE: Only the C++ Class Library, CBC.V3R1M0.SCLB3DLL is required
    • Internet Connection Server for MVS (5655-156)
Compatibility: DB2 Product

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 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 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)
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

Distributed Functions

REQ00045598 Inhibiting the block fetch protocol REQ00049309 Native TCP/IP access to MVS DB2 database

Large Table Support

EBDB2F90019 Partitioned Tablespace REQ00006456 Remove the 64 Gigabytes 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 gigabyte limit EBDB2S89051 New partition without recreate GGDB3094011 Support DROP & CREATE of a single partition GGDB3094011 Allow more flexibility in Alter statement for Partitioning Index GBDB2X93027 Permit Partition Restructure Without Recreating Tablespace JDDB0292007 Concurrent Execution of REORG and Application Systems EBDB2D94001 Allow DISPLAY DATABASE commands for a single partition REQ00052323 Partitioned Tablespace with more than 64 partitions

Sysplex Query

SDRDBX87423 Exploit N-Way Processors for certain SQL Statements

Utilities

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 REQ00046768 Allow incremental image copy after LOAD resume REQ00039287 Automatic Switch from Incremental IC to Full IC REQ00038630 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

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

Other Enhancements

REQ00056880 Extended MCS Support REQ00056423 Modify gets abend80a when processing 8500+ sysins REQ00056321 Undocumented Parameters for DSNJU003 in DB2 Ver4 DataSharing JCL REQ00054588 DSNTIJD Needs Additional Checking to Avoid Data Loss REQ00053996 Install SYSADM Required for start of all catalog objects REQ00053572 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 REQ00046770 Automatic reconnect of the CICS/DB2 attachment facility REQ00046763 Allow DISPLAY DATABASE commands for a single partition REQ00043804 Performance problem with the version 230 REQ00039866 Date last changed facility for DB2 REQ00038432 Allow optimizer to use additional distribution statistics REQ00029244 Ability to lock a partition of a Tablespace REQ00028257 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



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 Release Guide (SC26-8965) available from an IBM representative, as well as the Program Directory shipped with the product.

Packaging: DB2 Product and DB2 Performance Monitor Feature

The DB2 Product and DB2 Performance Monitor 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.

DB2 WWW Connection Feature

The DB2 WWW Connection Feature is available from the IBM Software homepage at:

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



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



ORDERING INFORMATION

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

                                                  Order
Title                                             Number

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

Ordering instructions and order processing availability will be communicated when IBM announces general availability of this product.



TERMS AND CONDITIONS

Licensing: IBM Customer Agreement

Variable Charges Apply: Yes

Measured Usage License Charge (MULC): The Measured Usage License Charge applies.

Parallel Sysplex License Charge (PSLC): The Parallel Sysplex License Charge applies.

Location License Applies: No

Usage Restriction Applies: No

Educational Allowance: Yes, to qualified education customers.

Volume Orders: Not applicable.

Version-To-Version Upgrade Credits Apply: Yes

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

5740-XYDB2 V1 5665-DB2 DB2 V2 Yes__

5665-DBDB2 V2 5685-DB2 DB2 V3 Yes__

5685-DBDB2 V3 5695-DB2 DB2 V4 Yes__

5695-DBDB2 V4 5655-DB2 DB2 V5 Yes__

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

DB2 Performance Monitor Feature

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

5665-35DB2 PM V1 5655-DB2 DB2 V5 Yes__ *

5685-14DB2 PM V2 5655-DB2 DB2 V5 Yes__ *

5665-04DB2 PM V3 5655-DB2 DB2 V5 Yes__ *

5655-10DB2 PM V4 5655-DB2 DB2 V5 Yes__ *

* Note 3 of DAWN-0040 applies

Warranty Applies: 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)

Satisfaction Guarantee: Two months for Basic Licenses

Starts:              10 days after IBM ships, or
                      on the day an Additional License
                      is authorized

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

Contact your IBM representative for charges information for this announcement.

Trademarks

 (TM) Trademark of International Business Machines Corporation in the
      United States or other countries or both.
 (R)  Registered trademark of International Business Machines
      Corporation in the United States or other countries or both.
      Microsoft and Windows are registered trademarks of Microsoft
      Corporation.
      Other trademarks and registered trademarks are the properties
      of their respective owners.