IBM United States
Software Announcement 201-054
March 6, 2001
IBM DB2 UDB Server for OS/390 and z/OS, Version 7 Availability with Enhancements DB2 Net Search Extender
(Corrected on April 19, 2001)
Correct Net Search Extender Japan-Kanji media feature numbers for DB2 UDB for OS/390 (5645-DB2).
(Corrected on April 3, 2001)
Changed DB2 Management Tools to DB2 Management Clients. Corrected Net
Searach Extender Media feature numbers.
At a Glance
With Version 7, DB2 UDB Server for OS/390:
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).
The DB2 Universal Database® (UDB) Server for OS/390® and z/OS, Version 7 program delivers improved performance, availability, and scalability for your e-business and data warehouse applications. A new feature, Net Search Extender, delivers the latest in high-speed full-text search technology. Use its powerful in-memory search to provide rapid query responses for your e-business applications.
In DB2® UDB for OS/390 and z/OS, Version 7, the DB2 Family is expanding the capability of the DB2 server by integrating warehouse management. The new DB2 Warehouse Manager feature gives a full set of tools for building and using a data warehouse based on DB2 for OS/390. This feature includes:
Several DB2 UDB for OS/390 and z/OS, Version 7 enhancements to DB2 can help improve your existing applications. Take advantage of:
Extend the power and flexibility of your applications with DB2 UDB for OS/390 and z/OS, Version 7 enhancements. You can utilize the following:
Now packaged separately, the utility functions deliver more for your DB2 UDB for OS/390 and z/OS, Version 7. New capability includes CopyToCopy, in support of recovery, also significant enhancements to improve your data availability.
With DB2 UDB for OS/390 and z/OS, Version 7, your e-business and business intelligence applications can be synergized with the powerful, highly available environment provided by S/390® and zSeries servers running OS/390 and z/OS. You can leverage your existing applications while developing and expanding your electronic commerce for the future. Refer to Software Announcement 200-087 , dated April 18, 2000.
The DATABASE 2 UDB Server for OS/390 is IBM's super-server of choice
for enterprise-wide data management in the twenty-first century. It is
the premier relational database server solution for OS/390. The database
server builds upon the momentum of previous releases furthering the
themes of user productivity, e-business, business intelligence, high
performance, and continuous availability.
Net Search Extender
Net Search Extender is a new member of the DB2 UDB Extender family and complements DB2 Text Extender. Net Search Extender adds a high-speed, scalable Internet text search capability to DB2. This addresses the needs of e-commerce and Web self-service applications. It works seamlessly with text data contained in DB2 and handles the heavy text search demands of large text-intensive Web sites. It rapidly searches data without locking database tables and delivers excellent query performance and scalability using in-memory database technology.
DB2 Warehouse Manager, new to DB2 UDB Server for OS/390 in Version 7, delivers a complete warehouse solution along with your DB2 for OS/390. This new offering brings together the tools to build, manage, govern, and access DB2 data warehouses. It is based on proven technologies enhanced to provide additional function and to provide tighter integration among the components. Provided in the optional DB2 Warehouse Manager Feature are:
Improved Performance, Availability, and Scalability
Version 7 includes significant new function to DB2 for OS/390. Whether your requirements are to do any of the following, DB2 UDB for OS/390 and z/OS, Version 7 has the power and function you are seeking:
One of the causes of a planned outage for DB2 arises when there is the need to alter one or more of the system parameters (known as ZPARMS). Now, Version 7 introduces the opportunity to change the value of many of these system parameters without stopping DB2.
Data sharing customers can benefit from a new restart option. Restart
Light will allow you to restart DB2 with a smaller storage footprint to
quickly recover retained locks, following an abnormal termination. The
reduced storage requirement can make a restart for recovery possible on a
system that might not have enough resources to start and stop DB2 in
Version 7 continues to enhance the flexibility of DB2 to support your enterprise applications and to ease the integration to the calling application.
DB2 UDB introduced support for the new object data types. Along with these objects, DB2 Extenders® provided appropriate functions for defining, accessing, storing, and searching data stored as a specific type. New in Version 7 is DB2 XML Extender with support for data using the XML data type. This extender allows you to store an XML object either:
Scrollable cursors give your application logic ease of movement through the result table using simple SQL and program logic. This frees your application from the need to cache the resultant data or to re-invoke the query in order to reposition within the resultant data.
In the increasingly global world of business and e-commerce, there is a growing need for data arising from geographically disparate users to be stored in a central server. Previous releases of DB2 have offered support for numerous code sets of data in either ASCII or EBCDIC format. However, there was a limitation of only one code set per system. New in Version 7 is support for UNICODE encoded data. This new code set is an encoding scheme that is able to represent the characters (code points) of many different geographies and languages.
Stored procedures introduced in Version 5 have increased program flexibility and portability among relational databases. Now, with Version 7, DB2 for OS/390 will accept COMMIT and ROLLBACK statements issued from within a stored procedure. This enhancement will prove especially useful for applications in which the stored procedure has been invoked from a remote client.
Stored Procedure Access to IMS Data: JDBC access to IMS Version 7 (V7) Database Manager (DB) data, initially provided with IMS V7 (available October 27, 2000) for Java applications running under control of the IMS Transaction Manager, is being extended through the IMS V7 service process to provide JDBC access to IMS V7 DB data from Stored Procedures running in DB2 UDB for OS/390.
Now, you can take advantage of Precompiler Services to perform the tasks currently executed by the DB2 precompiler. This API can be called by the COBOL compiler. By using this option, you can eliminate the DB2 precompile step in program preparation. You can take advantage of language capabilities that had been restricted by the precompiler, such as nested COBOL programs. Use of the host language compiler enhances DB2 Family compatibility, making it easier to import applications from other database management systems and from other operating environments.
Greater flexibility and family compatibility comes from several SQL
enhancements. Now, you can use a subselect to determine the values used
in the SET clause of an UPDATE statement. Also, you can have a
self-referencing subselect. The search condition in the WHERE clause can
include a subquery in which the object for the subquery and the UPDATE or
DELETE is the same. Support is now extended so you can define a view
with the operators UNION or UNION ALL. You can also use a row expression
to compare with a subselect expression.
DB2 Tools and Utilities Packaging
IBM announced Database Administration Tools and Database Recovery and
Replication Tools on September 12, 2000. Refer to Software
, dated September 12, 2000. With Version 7, the DB2
Utilities are now offered as products in this new family of Data
Management Tools for DB2. These new DB2 Utility products deliver
improved and powerful tools for your database operation and also for
diagnosis and recovery. A complete description of the utility commands
available in these new products is provided in a separate announcement.
Refer to Software Announcement
, dated March 6, 2001.
Utility Support for your DB2 Catalog Data
DB2 UDB for OS/390 and z/OS, Version 7 delivers the DB2 Utilities
Suite in support of your catalog data. DB2 catalog data is critical for
all database reference and application design. In order to sustain the
high-availability of DB2 for OS/390, this product is delivered with each
shipment of DB2 UDB for OS/390 and z/OS, Version 7. Use these
powerful management utilities for all of your DB2 catalog data management
Try and Buy Program
When DB2 UDB for OS/390 and z/OS, Version 7 was first announced, it
included reference to a Try and Buy program for selected DB2 tools
features. This program is not offered with DB2 UDB for OS/390 and z/OS,
Version 7. Instead, refer to the Data Management Tools for DB2
announcements to learn what powerful tools are separately available for
use with DB2 UDB for OS/390 and z/OS, Version 7. Refer to Software
, dated September 12, 2000, and Software Announcement
, dated March 6, 2001.
These programs are not impacted by euro currency.
DB2 UDB for OS/390 is the super-server of choice for the twenty-first century, providing enterprise-wide data management for e-business, business intelligence, CRM, and ERP applications such as Siebel, Vantive, Baan, PeopleSoft, and SAP R/3, and operational transaction processing. It offers large data capacity, high transaction performance, and extensive connectivity. It works with the DB2 UDB family to bring a full relational solution to the market place. DB2 supports transactions arising from Web servers, CICS®, IMS transaction management, MVS batch jobs, and via distributed connections from remote clients on numerous platforms.
DB2 UDB 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 UDB for OS/390 extends the object-relational functions of DB2 UDB to the S/390 environment. Now the full power and capacity of OS/390 and Parallel Sysplex® are available to store object data, which can be delivered to applications originating on the S/390 or connected via DRDA® from a remote requestor or from Internet and intranet applications.
Hardware and Software Support Services
IBM Installation Services are provided for DB2 UDB for OS/390 by IBM
Global Services or your IBM Business Partner at an additional cost. For
additional information, contact your IBM representative and ask for
Installation Services for DB2 UDB for OS/390.
DB2 for OS/390 Services Team
The DB2 for OS/390 services team at Silicon Valley Lab delivers fee-based services designed to help you accomplish your business goals. As a part of the DB2 development organization, this team of experienced professionals has the advantage of having direct access to DB2 for OS/390 developers. This services team is also in the unique position of understanding DB2 and being able to influence its future direction.
IBM Silicon Valley Lab DB2 for OS/390 Services team can offer system health checks, performance evaluation, and other custom services to address your special requirements for managing and tuning DB2 for OS/390 and z/OS.
For more information, contact your IBM Global Services representative and ask about DB2 for OS/390 Services or contact Larry Lange at Silicon Valley Lab at email@example.com.
Features of DB2 UDB Server for OS/390®
DB2® Universal Database® Server for OS/390 extends DB2 for OS/390 by offering features that combine with DB2 to enhance data warehousing, query access, system management, and replication of your data. The optional features of DB2 UDB Server for OS/390 and z/OS, Version 7 include:
Several optional features are available at no additional charge, including:
DB2 Warehouse Manager Feature
Use DB2 Warehouse Manager to simplify and speed your warehouse prototyping, development, and deployment to production. Benefits include better control of query resources through query governance, cost management, and usage tracking. Integration with the Information Catalog enables you to satisfy user requirements for finding, understanding, and accessing the right data. QMF gives you the ability to satisfy common reporting requirements, whatever the size of your enterprise.
DB2 UDB Version 7.1 Enterprise Edition: The data warehouse management infrastructure and OLAP Starter Kit is delivered as elements of DB2 UDB Version 7.1 Enterprise Edition. This copy of DB2 is included, with a restricted-use license, to permit delivery and utilization of the Windows-based components of the DB2 Warehouse Manager for OS/390.
Data Warehouse Center: The Data Warehouse Center gives you a graphical control facility, fully integrated with DB2 Control Center. Now you can more easily accomplish the diverse tasks of warehouse creation and management:
OS/390 Agents and Transformers: The warehouse agent for OS/390 executes OS/390-based processes on behalf of the Data Warehouse Center. It permits data to be processed in your OS/390 environment without the need to export it to an intermediate platform environment, allowing you to take full advantage of the power, security, reliability, and availability of DB2 and OS/390.
Warehouse transformers are stored procedures or user-defined functions that provide commonly used transformations for building data warehouses. These transformers provide complex transformations commonly used in warehouse development including:
These transformers augment the rich transformations available with SQL built-in functions including:
DB2 OLAP Starter Kit: The DB2 OLAP Starter Kit is a limited user license of DB2 OLAP Server and the OLAP Integration Server. Use them to quickly build and deploy OLAP applications in a Windows-based environment. The DB2 OLAP server for OS/390 is separately available. You can order and use it for OLAP applications to be run natively on OS/390.
DB2 Query Management Facility (QMF) Family: QMF, the tightly integrated, powerful, reliable, query and reporting tool set for the DB2 relational database management system family, provides new capabilities for the workstation environment and enhancements for the mainframe that help you access and present mission-critical data better than ever before. QMF Version 7 enables you to work with data all over the enterprise from DB2 for OS/390, DB2 for VSE and VM, DB2 for AS/400® to workstation servers running OS/2®, Windows NT, AIX®, and other UNIX® operating systems to massively parallel processors. QMF coupled with the DB2 DataJoiner® product allows access to non-relational and other vendor data sources as well.
The DB2 Warehouse Manager feature delivers the following QMF Family of integrated tools:
They offer a comprehensive data access and governing solution including:
They also provide for report publishing to the Web for viewing with your favorite Web browser.
The QMF HPO Version 7 includes QMF HPO/Manager and QMF HPO/Compiler.
The QMF HPO/Compiler lets you convert automatically queries and reports into efficient programs in OS/VS COBOL or COBOL II. This reduces CPU consumption, DB2 catalog contention, DB2 Optimizer overhead, and security concerns as converted programs use static Structured Query Language (SQL) in place of dynamic SQL.
The QMF HPO/Manager consists of a group of functions that improves governing and object management capabilities, including a preemptive governor to analyze QMF queries. The governing capabilities allow you to establish controls that protect valuable resources. Among the many conditions available for governing are:
For customers with DB2 databases of many sizes, QMF for Windows provides a Windows-based, point-and-click query tool that gives you many benefits, including an intuitive GUI "quick start" user interface and a Java-based query capability. Using QMF for Windows, you can automate tasks and develop powerful native Windows applications. The tool includes a powerful Windows-based API to automate database querying, updating, and report distribution tasks, so you can centralize control over resource consumption. QMF for Windows also gives you support for TCP/IP, static SQL, create and edit QMF forms and procedures, and a full-screen table editor for updating enterprise data.
QMF for Windows can connect to the DB2 family of products including:
QMF for Windows connectivity options include SNA, TCP/IP, and CLI.
For more information on the QMF Family of integrated tools, including a QMF Family demo and a QMF for Windows Try and Buy download, access the QMF Web site at:
Net Search Extender
Net Search Extender is a new member of the DB2 UDB Extender family and complements DB2 Text Extender. Net Search Extender adds high-speed, scalable Internet text search capability to DB2 by combining in-memory database technology with text search technology. This addresses the needs of e-commerce and Web self-service applications. It works seamlessly with text data contained in DB2 and handles the heavy text search demands of large text-intensive Web sites. It rapidly searches data without locking database tables and delivers excellent query performance and scalability.
In-memory Technology: At index creation time, Net Search Extender allows you to specify parts of the table that can be stored in main memory, such as the sorting of a text index using table columns. For example, you could presort a text index on a book abstract column by the value in the price column.
At run time, DB2 involvement can be as slight as just a call to invoke the stored procedure. A query such as "get the author and price for all books about relational databases and order by price" can be satisfied by:
The Text Extender uses functions to provide SQL language with text search functionality. These can be used inside SQL statements like the built-in SQL functions, such as "length" or "concat." The stored procedure offered by Net Search Extender can be exploited in any Net.Data, Java, or DB2 CLI client application. This allows you to use DB2 interfaces between your application and the DB2 server. If you require rich linguistic functionality, proximity search (word "aa" in the same sentence or paragraph as word "bb"), XML document support, thesaurus support, or integrated multimedia searches (images) then Text Extender is the recommended search solution.
DB2 Management Clients Package
The DB2 Management Clients Package is a no-charge feature of DB2 for OS/390, Version 7. The Management Clients Package is a collection of workstation-based tools you can use to work with and manage your DB2 for OS/390 environment. The elements of the DB2 Management Clients Package Feature are:
DB2 Control Center: Users of DB2 for OS/390 can now manage data in a new way. The Control Center capability of DB2 UDB Version 6 for Windows, UNIX, and OS/2 first extended support to DB2 for OS/390, with Version 6. As a Java-based tool, the Control Center can run on many types of workstations and on many different operating systems. Users can now use the same tool, with its easy-to-use GUI, to manage DB2 databases on OS/390, and on workstation servers. The GUI supports DB2 for OS/390 SQL statements (such as CREATE and ALTER), DB2 commands (such as DISPLAY, START, and STOP), and utilities (such as REORG and LOAD).
With the Control Center, users can manage the family of DB2 databases on many different operating systems. DB2 for OS/390 objects are displayed on the Control Center main window along with objects of other members of the DB2 UDB family. To initiate an action or utility to manage these objects, users select the object. For example, a user can list the table spaces of a particular database and perform the following actions, and others, on one of the selected table spaces:
The Control Center can run either as a Java application or as an application on your Web server that your Web browser can access. DB2 Control Center is part of the DB2 Application Development Client on Windows, delivered with all editions of DB2 UDB and DB2 Connect products on Linux, OS/2, UNIX, and Windows. Because the Control Center requires DB2 Connect, the DB2 Management Clients Package provides a restricted-use copy of DB2 Connect Version 7 to satisfy this functional dependency.
The Control Center approach to managing DB2 is now extended to the S/390® platform. Sites that have multiple DB2 subsystems, on the same or different operating systems, can use the Control Center as a central point of administration. Users who are more experienced in the workstation environment can manage DB2 for OS/390 more easily as a result of the GUI.
DB2 Stored Procedure Builder: The DB2 Stored Procedure Builder (SPB), an element of the DB2 Management Clients Package, provides an easy-to-use development environment for creating, installing, and testing stored procedures. With the DB2 SPB, you can focus on creating your stored procedure logic rather than on the details of registering, building, and installing stored procedures on a DB2 server. The SPB provides a single development environment that supports the entire DB2 family ranging from the workstation to S/390. With DB2 SPB, you can develop stored procedures on one operating system and deploy them on other server operating systems.
The DB2 SPB has a GUI that guides you through the tasks with the help of basic design patterns, SQL assistants, and costing information. Use the SPB to perform a variety of tasks associated with stored procedures, such as:
DB2 SPB is part of the DB2 Application Development Client on Windows, delivered with all editions of DB2 UDB and DB2 Connect products on Linux, OS/2, UNIX, and Windows. Because SPB requires DB2 Connect, the DB2 Management Clients Package provides a restricted-use copy of DB2 Connect Version 7 to satisfy this functional dependency.
DB2 Installer: DB2 Installer is a workstation client delivered as an element of the DB2 Management Clients Package. DB2 Installer enhances your productivity whether you are installing DB2 for OS/390 for the first time or you are an experienced installer. From your workstation, you can:
Enhancements in Version 7 include:
Visual Explain: DB2 Visual Explain, a workstation client that is an element of the DB2 Management Tools Package, is an easy-to-use workstation tool that presents the output from DB2 EXPLAIN and dynamic EXPLAIN in a 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. DB2 Visual Explain also includes a browser for viewing DB2 subsystem parameters. With Visual Explain you can:
As a result of enhancements to Visual Explain Version 7, you can:
If you are using Control Center, you can launch Visual Explain directly from the Control Center. Because DB2 Visual Explain requires DB2 Connect, the DB2 Management Clients Package provides a restricted-use copy of DB2 Connect Version 7 to satisfy this functional dependency.
DB2 Estimator: DB2 Estimator is an easy-to-use, stand-alone tool for estimating the performance of applications for DB2 for OS/390. DB2 Estimator is one of the elements of the DB2 Management Clients Package. Run it on your desktop personal computer, or take it with you on your portable notebook computer.
With DB2 Estimator, you can model a partial DB2 application or a complete real or planned DB2 application without requiring an actual DB2 system. From simple table sizings to a detailed performance analysis of an entire DB2 application, DB2 Estimator saves time, lowers costs, and reduces risk. You can use DB2 Estimator to investigate the impact to your production system of new or modified applications before you implement them. You can do what-if analysis to assess the impact of changes you're considering. You can also answer many questions, such as:
Use DB2 Estimator during all life-cycle phases of a DB2 application. During the initial design phase, you can easily:
When creating database objects, use the models you specified in DB2 Estimator as a guide for naming columns and for specifying attribute values. You can model your system using actual DB2 information by importing information from the DB2 catalog and, if available, from EXPLAIN or DB2 Performance Monitor. Thereby eliminating problems early in the design phase.
When your application is in production, use DB2 Estimator with tools such as DB2 PM to solve application performance problems. You can evaluate alternative SQL designs, without any risk to your production environment, before changing any production database objects. DB2 Estimator also helps you determine the impact of hardware or workload changes.
You can use DB2 Estimator for Versions 5, 6, and 7 of DB2 for OS/390. It runs in any environment that supports Windows (Windows 95, Windows 98, Windows 2000, and Windows NT). Use DB2 Estimator on any data imported from DB2 for OS/390, or you can model an application for which none of the tables, SQL, transactions, or configuration exist.
In Version 7, DB2 Estimator expands support for utilities and SQL statements to help you approximate your working environment more closely. Enhancements in Version 7 include:
The Net.Data Version 7 feature provides high-performance access to DB2 data from the World Wide Web. Net.Data for OS/390, Version 7 exploits the S/390's capabilities as a premier platform for electronic commerce and Internet technology.
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 you have in your business today: relational data on OS/390 and a variety of other platforms. 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.
IBM Net.Data delivers a powerful framework for Web applications. In addition to connecting to diverse data sources, Net.Data provides for:
Net.Data provides native access to the data you need in your business environment:
In addition, Net.Data can call DB2 stored procedures for additional performance from static SQL.
Net.Data has extensive application development functionality, including:
Net.Data for OS/390, Version 7 adds enhancements for performance and usability. With Net.Data for OS/390, Version 7, your high-performance, business-critical Web applications can more efficiently utilize the data in your enterprise.
Refer to the Net.Data Web pages for documentation, sample programs, and customer applications. You can find the Net.Data home page at:
REXX Language Support Feature
REXX Language Support lets your REXX programs access DB2 data. You can use this facility to enable your REXX execs or REXX stored procedures to issue calls directly to DB2 for OS/390.
Processors: DB2 for OS/390 operates on any processor supported by OS/390 Version 2 Release 7 and supports the architectural level set. In this version, DB2 for OS/390 intends to use ESA/390 architectural enhancements that were implemented on selected S/390 servers.
DB2 UDB for OS/390 and z/OS, Version 7 can run only on servers that implement the architectural enhancements, and cannot run on any servers that have not implemented them. The following IBM servers implement the architectural enhancements:
DB2 UDB for OS/390 and z/OS, Version 7 cannot run on the following IBM servers, because they do not implement the architectural enhancements:
Architectural enhancements provide a variety of performance and reliability improvements. For more information about the specific enhancements in ESA/390, refer to Software Announcement 299-234 , dated August 24, 1999, or the product manuals for ESA/390.
The processor must have enough real storage to satisfy the combined requirements of:
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 DASD and tape device type. The customer can use any magnetic or tape device supported by the data facilities component of OS/390 or z/OS for the DB2 data sets. The following DB2 data sets are supported by the following device types:
If these data sets are on a disk shared with other OS/390 or z/OS systems, you should use global resource serialization to prevent concurrent access by more than one OS/390 or z/OS system.
The minimum DASD space requirement, based on installing DB2 using the Installation Panels default values, is approximately 600 MB. You will need additional DASD space for your data.
If you use dual logging and tape for the log archiving device, you need at least two tape drives.
For the data communication devices supported by IMS/ESA Transaction Manager, CICS, and TSO, refer to the documentation for these products.
This section lists licensed programs required in the DB2 UDB for OS/390 and z/OS, Version 7 environment. You can use subsequent versions or releases of the programs, unless stated otherwise. This section also identifies the requirements associated with specific DB2 capabilities, as well as optional programs that you can use with DB2 UDB for OS/390 and z/OS, Version 7.
Operating System and Support Programs: 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.
Virtual Storage Requirements: The amount of space needed for the common service area (CSA) below the 16 MB line is less than 40 KB for each DB2 subsystem and 24 KB for each IRLM. High concurrent activity, parallelism, or high contention can require more CSA.
Most of the DB2 common data resides in the extended common service area (ECSA). Most modules, control blocks, and buffers reside in the extended private area. A DB2 subsystem with 200 concurrent users and 2,000 open data sets should need less than 2 MB of virtual storage below the 16 MB line.
Function-Dependent Requirements for Features of DB2 UDB Server for OS/390: DB2 UDB for OS/390 and z/OS, Version 7 includes the following features, some of which have requirements of their own, above and beyond what the base DB2 product requires. This section identifies the requirements for using these features, but does not repeat the requirements for DB2 UDB for OS/390 and z/OS, Version 7.
DB2: DB2 UDB for OS/390 and z/OS, Version 7 is upwardly compatible with prior releases of DB2 for OS/390 and DB2 for MVS/ESA. Migration with full fallback protection is available for customers running on either DB2 for OS/390, Version 5 or DB2 UDB for OS/390, Version 6. Thus, existing customers should ensure they are successfully running on DB2 for OS/390, Version 5, or later, before migrating to DB2 UDB for OS/390 and z/OS, Version 7.
User Group Requirements: This announcement satisfies or partially satisfies 63 requirements from one or more of the worldwide user group communities. Groups 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. Requirements satisfied include:
REQ00033987 DB2 Unload Utility REQ00048887 Unload utility REQ00073656 DB2 UTILITY REORG UNLOAD EXTERNAL INCONVENIENT TO USE REQ00075995 REORG UNLOAD Enhancements REQ00039320 COPY with filtering of Table Space Names REQ00039857 Image Copy by Database REQ00039323 Thread Termination Without Rollback REQ00041522 Terminate Thread without Backout REQ00072841 Command to Cancel Backout and Recover Objects REQ00075829 CANCEL THREAD NO ROLLBACK REQ00069335 Online REORG Switch Phase Takes Too Long to Complete REQ00039774 Support scrollable cursor REQ00023873 Fetch previous row REQ00039114 DB2 Unpredictable Results when using Index instead of Temporary REQ00039450 ENSURE PREDICTABLE RESULTS WHEN FETCHING A ROW FROM A CURSOR REQ00025551 Provide an option to make a CURSOR insensitive to updates REQ00039634 Select max on the first column in a unique index in DB2 REQ00039540 Enhance DB2 to walk backwards through an INDEX REQ00026448 DB2-Precompiler support for SQL statements in nested program REQ00028200 Embedded SQL within VS COBOL II Nested Programs REQ00039163 Extra DB2 precompiler option to suppress generated code REQ00039758 Support Subscripted Host-Variable REQ00039798 Reduce Initialization overhead for SQL in programs containing SQL REQ00029770 Dynamic Alteration of DB2 System Parameters REQ00037642 DB2 -- Provide dynamic ZPARM update capability REQ00039026 DB2 system parameters: dynamic reconfiguration REQ00039704 DSNZPARM REQ00039772 Capability of Dynamically changing to DSNZPARM parameters REQ00062092 Dynamic Assignment of DSNZPARM REQ00062114 Dynamic Updating of DSNZPARM REQ00068708 DB2 DSNZPARM, ZPARM, changing while DB2 is running REQ00068708-1 DB2 DSNZPARM, ZPARM, changing while DB2 is running REQ00072132 ZPARM Alteration Function While Running DB2 System REQ00072836 Dynamic change for DSNZPARM parameters REQ00072848 Dynamic Modification of Unittype for Archive Logs REQ00074416 Improvement of DB2 subquery performance REQ00029459 Allow DB2 Delete From Table with Subselect From Same Table REQ0007521 Reduce recovery time in datasharing environments REQ00065739 Online Utilities REQ00073348 LOAD RESUME with OLTP concurrency/generic insert bmp capability REQ00039004 COMMENT ON for all DB2 objects REQ00039628 Only a few tables have remark columns. All of the tables ought to. REQ00039640 Get DSNTINST values from running DSNZPARM REQ00075134 DB2 Optimizer REQ00075699 Catalog column for immedwrite bind parameter REQ00039011 Prize-list REQ00039296 Adding new statement "SELECT FIRST (n)" REQ00040253 ALLOW A LIMIT TO BE PLACED ON THE NUMBER OF ROWS RETRIEVED REQ00074553 LIMIT THE NUMBER OF ROWS RETURNED ON A SELECT STATEMENT REQ00068551-1 Increase of acceptable values for QUERYNO in Plan_table REQ00068551 Increase of acceptable values for QUERYNO in Plan_table REQ00069866 Top Secret DB2 Interface REQ00070041 Authorization exit needs to pass DATABASE name for ALTER and DROP REQ00034332 Allow DBADM to create view with different qualifier REQ00039156 DB2 -- Enhance DBADM authority REQ00041745 DBADM authority to create views REQ00045374 SPECIFY A OWNER IN CREATE VIEW REQ00058505 DBADM-Authority for CREATE VIEW REQ00065735 DBADM-Authority for CREATE VIEW REQ00074704 Full RACF DB2 Security Management REQ00072517 Accounting traces running a full day
DB2 UDB for OS/390 and z/OS, Version 7 has support for migration from Version 5 or 6. Customers not yet on Version 5, should plan to migrate to DB2 for OS/390, Version 5, or later, as preparation for a migration to Version 7.
Migration Considerations: IBM added many universal database capabilities in DB2 UDB for OS/390, Version 6 and removed support for some functions. As you prepare to migrate your subsystems, you should be aware of the following changes:
For more detailed information on migrating to Version 7, refer to the DB2 UDB for OS/390 and z/OS, Version 7 Installation Guide (GC26-9636).
Also included will be a Program Directory, and under separate cover, one copy of the entitled publications.
The workstation client functions of DB2 Management Clients Package and DB2 Extenders will be shipped on CD-ROM.
The QMF for Windows product CD-ROM also contains all supported national languages and all U.S. English and translated publications, in softcopy format. Two publications are shipped:
Security, Auditability, and Control
DB2 UDB for OS/390 and z/OS, Version 7 uses the security and auditability features of the host OS/390 systems. It also provides facilities for the protection and control of its resources. These facilities include controls for:
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed on the Web at:
Orders for new licenses can be placed now.
Shipment will not occur before March 30, 2001.
Unless a later date is specified, orders entered before March 30, 2001, will be assigned a schedule date of one week following this date.
Shipment will begin on March 30, 2001.
New users of DB2 UDB Server for OS/390 and z/OS, Version 7 should specify 5675-DB2.
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.
OTC Program Feature Description Number Number DB2 UDB for OS/390 and z/OS 5675-DB2 0029 ESL Optional Features DB2 Warehouse Manager ESL 0083 QMF for OS/390 ESL 0128 QMF for Windows ESL 0236 (Requires QMF) QMF for Windows ESL 0274 (No Requirement) DB2 Net Search Extender ESL 0515 DB2 UDB for OS/390, Version 6 5645-DB2 Optional Feature DB2 Net Search Extender ESL 0350
Application StarterPak License (ASPL): This program product is eligible for ASPL charges. The appropriate ASPL charge is determined by the 3000 model on which the programs are preloaded. The ASPL license charge feature numbers are as follows:
3000-A10 3000-A20 ASPL ASPL MLC(1) MLC Program Feature Feature Name Number Number 5675-DB2 DB2 UDB for OS/390 0016 0017 Optional Features DB2 Warehouse Manager 0087 0088 QMF for OS/390 0132 0133 QMF for Windows 0231 0232 (Requires QMF) QMF for Windows 0269 0270 (Without QMF Requirement) DB2 Net Search Extender 0516 0517 DB2 UDB for OS/390, Version 6 Optional Feature DB2 Net Search Extender 0351 0352
Customers must sign the Attachment for IBM S/390 Application StarterPak License (Z125-5597) to the IBM Customer Agreement (ICA) or to its equivalent depending on the geography. ASPL charges apply to the programs listed above when these programs are licensed for use on an IBM 3000 Model A10 or A20 processor. If ASPL is not available for a particular program, the applicable license charges apply. For the IBM 3000 Model A10, Group 38 or 6 MSUs apply. For the IBM 3000 Model A20, Group 40 or 11 MSUs apply.
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, and PSLC Level C, PSLC Level D 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.
Basic PSLC License MSU Feature MLC Feature Capacity Number Description 1 0001 Base, 1 MSU 2 0002 Base, 2 MSUs 3 0003 Base, 3 MSUs 4 - 45 0004 Level A, 1 MSU 0005 Level A, 42 MSUs 46 - 175 0006 Level B, 1 MSU 0007 Level B, 10 MSUs 0008 Level B, 50 MSUs 176 - 315 0009 Level C, 1 MSU 0010 Level C, 10 MSUs 0011 Level C, 50 MSUs 316 or more 0012 Level D, 1 MSU 0013 Level D, 50 MSUs Not Applicable 0014 NC Identifier
0003 quantity 1
0004 quantity 8
Basic PSLC License MSU Feature MLC Feature Capacity Number Description 1 0062 Base, 1 MSU 2 0063 Base, 2 MSUs 3 0064 Base, 3 MSUs 4 - 45 0065 Level A, 1 MSU 0066 Level A, 42 MSUs 46 - 175 0067 Level B, 1 MSU 0068 Level B, 10 MSUs 0069 Level B, 50 MSUs 176 - 315 0070 Level C, 1 MSU 0071 Level C, 10 MSUs 0072 Level C, 50 MSUs 316 or more 0073 Level D, 1 MSU 0074 Level D, 50 MSUs Not Applicable 0075 NC Identifier
0064 quantity 1
0065 quantity 8
PSLC Basic PSLC License MSU Feature MLC Feature Capacity Number Description 1 0107 Base, 1 MSU 2 0108 Base, 2 MSUs 3 0109 Base, 3 MSUs PSLC Basic PSLC License MSU Feature MLC Feature Capacity Number Description 4 - 45 0110 Level A, 1 MSU 0111 Level A, 42 MSUs 46 - 175 0112 Level B, 1 MSU 0113 Level B, 10 MSUs 0114 Level B, 50 MSUs 176 - 315 0115 Level C, 1 MSU 0116 Level C, 10 MSUs 0117 Level C, 50 MSUs 316 or more 0118 Level D, 1 MSU 0119 Level D, 50 MSUs Not Applicable 0120 NC Identifier
0109 quantity 1
0110 quantity 8
PSLC Basic PSLC License MSU Feature MLC Feature Capacity Number Description 1 0217 Base, 1 MSU 2 0218 Base, 2 MSUs 3 0219 Base, 3 MSUs 4 - 45 0220 Level A, 1 MSU 0221 Level A, 42 MSUs 46 - 175 0222 Level B, 1 MSU 0223 Level B, 10 MSUs 0224 Level B, 50 MSUs 176 - 315 0225 Level C, 1 MSU 0226 Level C, 10 MSUs 0227 Level C, 50 MSUs 316 or more 0228 Level D, 1 MSU 0229 Level D, 50 MSUs Not Applicable 0230 NC Identifier
0219 quantity 1
0220 quantity 8
PSLC Basic PSLC License MSU Feature MLC Feature Capacity Number Description 1 0255 PSLC Base, 1 MSU 2 0256 PSLC Base, 2 MSUs 3 0257 PSLC Base, 3 MSUs 4 - 45 0258 PSLC Level A, 1 MSU 0259 PSLC Level A, 42 MSUs 46 - 175 0260 PSLC Level B, 1 MSU 0261 PSLC Level B, 10 MSUs 0262 PSLC Level B, 50 MSUs 176 - 315 0263 PSLC Level C, 1 MSU 0264 PSLC Level C, 10 MSUs 0265 PSLC Level C, 50 MSUs 316 or more 0266 PSLC Level D, 1 MSU 0267 PSLC Level D, 50 MSUs Not Applicable 0268 PSLC NC Identifier
0257 quantity 1
0258 quantity 8
PSLC Basic PSLC License MSU Feature MLC Feature Capacity Number Description 1 0501 Base, 1 MSU 2 0502 Base, 2 MSUs 3 0503 Base, 3 MSUs 4 - 45 0504 Level A, 1 MSU 0505 Level A, 42 MSUs 46 - 175 0506 Level B, 1 MSU 0507 Level B, 10 MSUs 0508 Level B, 50 MSUs PSLC Basic PSLC License MSU Feature MLC Feature Capacity Number Description 176 - 315 0509 Level C, 1 MSU 0510 Level C, 10 MSUs 0511 Level C, 50 MSUs 316 or more 0512 Level D, 1 MSU 0513 Level D, 50 MSUs Not Applicable 0514 NC Identifier
0503 quantity 1
0504 quantity 8
PSLC Basic PSLC License MSU Feature MLC Feature Capacity Number Description 1 0336 Base, 1 MSU 2 0337 Base, 2 MSUs 3 0338 Base, 3 MSUs 4 - 45 0339 Level A, 1 MSU 0340 Level A, 42 MSUs 46 - 175 0341 Level B, 1 MSU 0342 Level B, 10 MSUs 0343 Level B, 50 MSUs 176 - 315 0344 Level C, 1 MSU 0345 Level C, 10 MSUs 0346 Level C, 50 MSUs 316 or more 0347 Level D, 1 MSU 0348 Level D, 50 MSUs Not Applicable 0349 NC Identifier
0338 quantity 1
0339 quantity 8
Variable Workload License Charge (WLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the WLC base feature. If applicable, specify the WLC Level 1, WLC Level 2, WLC Level 3, and WLC Level 4 features with the appropriate quantity.
Also, specify the feature number of the desired distribution medium.
The Variable WLC requires the use of the IBM License Use Management (LUM) tool. A PTF will be made available to implement the LUM tool on DB2 UDB for OS/390 and z/OS, Version 7.
Variable WLC Aggregation: When z/OS is installed on two or more S/390 or zSeries 900 (z900) machines comprising a sysplex, Variable WLC aggregation applies to z/OS and the S/390 software programs that have Variable WLC.
Whether there is only one license or more than one license of the program in the sysplex, the charge for all licenses is associated to the "aggregation license" by specifying the applicable WLC feature numbers and quantity represented by the sum of the MSUs (millions of service units) in the sysplex. The "aggregation license" is an additional program license that is ordered and serialized, although there is no shipment associated with it.
For the actual licenses, the charge is reflected as $0 by specifying the applicable "registration" Variable WLC feature numbers and the quantity equal to the MSUs of that license running on the designated machine.
For DB2 UDB Server for OS/390 and z/OS, Version 7 (5675-DB2), the Variable WLC feature numbers are as follows:
WLC Basic PSLC License Machine Feature MLC Feature MSU Capacity Number Description 0 - 45 0431 Base, 45 MSUs 46 - 175 0432 Level 1, 1 MSU 176 - 315 0435 Level 2, 1 MSU 316 - 575 0437 Level 3, 1 MSU 0439 Level 3, 50 MSUs 576 or more 0441 Level 4, 1 MSU 0443 Level 4, 50 MSUs WLC Basic License No-Charge WLC Registration MSU Feature Feature Capacity Number Description 0 - 1 0433 Base, 1 MSU Reg 2 - 175 0434 Level 1, 1 MSU Reg 176 - 315 0436 Level 2, 1 MSU Reg 316 - 575 0438 Level 3, 1 MSU Reg 0440 Level 3, 50 MSUs Reg 576 or more 0442 Level 4, 1 MSU Reg 0444 Level 4, 50 MSUs Reg
0431 quantity 1
0432 quantity 130
0435 quantity 45
Example 2: If there are two machines in a sysplex, and a program is running on machine #1 at 190 MSUs and on machine #2 at 140 MSUs, the Variable WLC feature numbers and quantities to be ordered would be:
WLC Basic License WLC MLC MSU Feature Feature Capacity Number Description 0 - 45 0445 Base, 45 MSUs 46 - 175 0446 L1, 1 MSU 176 - 315 0449 L2, 1 MSU 316 - 575 0451 L3, 1 MSU 0453 L3, 50 MSUs 576 or more 0455 L4, 1 MSU 0457 L4, 50 MSUs WLC Basic License No-Charge WLC Registration MSU Feature Feature Capacity Number Description 0 - 1 0447 Base, 1 MSU Reg 2 - 175 0448 Level 1, 1 MSU Reg 176 - 315 0450 Level 2, 1 MSU Reg 316 - 575 0452 Level 3, 1 MSU Reg 0454 Level 3, 50 MSUs Reg 576 or more 0456 Level 4, 1 MSU Reg 0458 Level 4, 50 MSUs Reg
0445 quantity 1
0446 quantity 130
0449 quantity 45
Example 2: If there are two machines in a sysplex, and a program is running on machine #1 at 190 MSUs and on machine #2 at 140 MSUs, the Variable WLC feature numbers and quantities to be ordered would be:
WLC Basic PSLC License MSU Feature MLC Feature Capacity Number Description 0 - 45 0459 Base, 45 MSUs 46 - 175 0460 Level 1, 1 MSU 176 - 315 0463 Level 2, 1 MSU 316 - 575 0465 Level 3, 1 MSU 0467 Level 3, 50 MSUs 576 or more 0469 Level 4, 1 MSU 0471 Level 4, 50 MSUs WLC Basic License WLC MLC MSU Feature Feature Capacity Number Description 0 - 1 0461 Base, 1 MSU Reg 2 - 175 0462 Level 1, 1 MSU Reg 176 - 315 0464 Level 2, 1 MSU Reg 316 - 575 0466 Level 3, 1 MSU Reg 0468 Level 3, 50 MSUs Reg 576 or more 0470 Level 4, 1 MSU Reg 0472 Level 4, 50 MSUs Reg
0459 quantity 1
0460 quantity 130
0463 quantity 45
Example 2: If there are two machines in a sysplex, and a program is running on machine #1 at 190 MSUs and on machine #2 at 140 MSUs, the Variable WLC feature numbers and quantities to be ordered would be:
WLC Basic PSLC License Machine Feature MLC Feature MSU Capacity Number Description 0 - 45 0487 Base, 45 MSUs 46 - 175 0488 Level 1, 1 MSU 176 - 315 0491 Level 2, 1 MSU 316 - 575 0493 Level 3, 1 MSU 0495 Level 3, 50 MSUs 576 or more 0497 Level 4, 1 MSU 0499 Level 4, 50 MSUs WLC Basic License No-Charge WLC Registration MSU Feature Feature Capacity Number Description 0 - 1 0489 Base, 1 MSU Reg 2 - 175 0490 Level 1, 1 MSU Reg 176 - 315 0492 Level 2, 1 MSU Reg 316 - 575 0494 Level 3, 1 MSU Reg 0496 Level 3, 50 MSUs Reg 576 or more 0498 Level 4, 1 MSU Reg 0500 Level 4, 50 MSUs Reg
0487 quantity 1
0488 quantity 130
0491 quantity 45
WLC Basic WLC License Machine Feature MLC Feature MSU Capacity Number Description 0 - 45 0473 Base, 45 MSUs 46 - 175 0474 Level 1, 1 MSU 176 - 315 0477 Level 2, 1 MSU 316 - 575 0479 Level 3, 1 MSU 0481 Level 3, 50 MSUs 576 or more 0483 Level 4, 1 MSU 0485 Level 4, 50 MSUs WLC Basic License No-Charge WLC Registration MSU Feature Feature Capacity Number Description 0 - 1 0475 Base, 1 MSU Reg 2 - 175 0476 Level 1, 1 MSU Reg 176 - 315 0478 Level 2, 1 MSU Reg 316 - 575 0480 Level 3, 1 MSU Reg 0482 Level 3, 50 MSUs Reg 576 or more 0484 Level 4, 1 MSU Reg 0486 Level 4, 50 MSUs Reg
0473 quantity 1
0474 quantity 130
0477 quantity 45
WLC Basic WLC License Machine Feature MLC Feature MSU Capacity Number Description 0 - 45 0521 Base, 45 MSUs 46 - 175 0522 Level 1, 1 MSU 176 - 315 0525 Level 2, 1 MSU WLC Basic WLC License Machine Feature MLC Feature MSU Capacity Number Description 316 - 575 0527 Level 3, 1 MSU 0529 Level 3, 50 MSUs 576 or more 0531 Level 4, 1 MSU 0533 Level 4, 50 MSUs WLC Basic License No-Charge WLC Registration MSU Feature Feature Capacity Number Description 0 - 1 0523 Base, 1 MSU Reg 2 - 175 0524 Level 1, 1 MSU Reg 176 - 315 0526 Level 2, 1 MSU Reg 316 - 575 0528 Level 3, 1 MSU Reg 0530 Level 3, 50 MSUs Reg 576 or more 0532 Level 4, 1 MSU Reg 0534 Level 4, 50 MSUs Reg
0521 quantity 1
0522 quantity 130
0525 quantity 45
WLC Basic License WLC MLC MSU Feature Feature Capacity Number Description 0 - 45 0356 Base, 45 MSUs 46 - 175 0357 Level 1, 1 MSU 176 - 315 0360 Level 2, 1 MSU 316 - 575 0362 Level 3, 1 MSU 0364 Level 3, 50 MSUs 576 or more 0366 Level 4, 1 MSU 0368 Level 4, 50 MSUs WLC Basic License No-Charge WLC Registration MSU Feature Feature Capacity Number Description 0 - 1 0358 Base, 1 MSU Reg 2 - 175 0359 Level 1, 1 MSU Reg 176 - 315 0361 Level 2, 1 MSU Reg 316 - 575 0363 Level 3, 1 MSU Reg 0365 Level 3, 50 MSUs Reg 576 or more 0367 Level 4, 1 MSU Reg 0369 Level 4, 50 MSUs Reg
0356 quantity 1
0357 quantity 130
0360 quantity 45
S/390 Usage Pricing (Usage License Charge) Basic License: To order a basic license, specify the appropriate program and feature number, if required, for asset registration. Specify the applicable S/390 Usage Pricing feature. Also, specify the feature number of the desired distribution medium.
Charges will be based upon the Peak MSUs. Usage reported between thresholds of features 1, 2, or 3, will be rounded up to the next MSU level. Above 1.0 MSU, usage will be rounded up to the nearest whole MSU. For example, 2.4 MSUs would round to 2.0 MSUs for pricing, and 2.5 MSUs would round to 3.0 MSUs for pricing.
The customer pricing will be determined by selecting either:
Feature Description Number ULC 0 to 0.25 MSU Base 0018 ULC 0.26 to 0.5 MSU Base 0019 ULC 0.51 to 1.0 MSU Base 0021 ULC Level A (2 to 11 MSUs) 0022 ULC Level B (12 to 44 MSUs) 0023 ULC Level C (45 to 78 MSUs) 0024 ULC Level D (above 78 MSUs) 0025 ULC Level D (above 78 MSUs) 0026 NC Identification Feature 0020
Growth Opportunity License Charge (GOLC): To order GOLC software, specify the program number, feature number 9001 for asset registration, and the GOLC monthly charge feature number from the table below. Also, specify the feature number for the desired distribution medium.
GOLC GOLC Feature Category Number DB2 UDB For OS/390 GOLC H30 0030 GOLC H50 0031 GOLC H70 0032 DB2 Warehouse Manager Feature GOLC H30 0084 GOLC H50 0085 GOLC H70 0086 QMF Feature GOLC H30 0129 GOLC H50 0130 GOLC H70 0131 QMF for Windows Feature (Requires QMF) GOLC H30 0233 GOLC H50 0234 GOLC H70 0235 QMF for Windows Feature Without Requirement of QMF GOLC H30 0271 GOLC H50 0272 GOLC H70 0273 DB2 Net Search Extender Feature GOLC H30 0518 GOLC H50 0519 GOLC H70 0520 DB2 Net Search Extender Feature Optional Feature of 5645-DB2, DB2 UDB for OS/390, Version 6 GOLC H30 0353 GOLC H50 0354 GOLC H70 0355
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.
3480 9/6250 Car- 4-mm Description Tape tridge DAT CD-ROM DB2 UDB Server Feature DB2 UDB for OS/390 5851 5852 6005 and z/OS DB2 Management Clients 5881 5882 6008 Package (No-charge) Feature DB2 Warehouse Manager 5811 5812 6001 (Priced) Feature (Includes all QMF Features) 3480 9/6250 Car- 4-mm Description Tape tridge DAT CD-ROM Net.Data Version 7 5891 5892 6009 (No-charge) Feature Net Search Extender 6182 6180 6181 (Priced) Feature QMF for OS/390 5949 5950 6010 (Priced) Feature QMF for Windows 5829 (Priced) Feature (Requires QMF) QMF for Windows 5809 (Priced) Feature (Without QMF Requirement) REXX Language Support 5962 5963 6011 (No-charge) Feature DB2 UDB for OS/390, Version 6 (5645-DB2): Optional Feature Net Search Extender 5715 5714 5712 (Priced) Feature
DB2 UDB Server for OS/390 provides support in the languages listed below; however, not all elements are translated into each language.
The NLS features for DB2 UDB Server for OS/390 and z/OS, Version 7 are:
3480 9/6250 Car- 4-mm Description Tape tridge DAT CD-ROM DB2 UDB Server Feature OS/390 and z/OS 6155 6153 6154 Japan -- Kanji (DBCS) Management Clients Spanish 6167 6165 6166 French 6164 6162 6163 Japan -- Kanji (DBCS) 6170 6168 6169 Korean 6173 6171 6172 DB2 Warehouse Manager -- Includes all QMF Features Arabic 6148 6146 6147 Simplified Chinese 6055 6053 6054 Traditional Chinese 6067 6065 6066 Danish 6052 6050 6051 Swiss German 6019 6017 6018 German 6046 6044 6045 English Upper Case SBCS 6022 6020 6021 Spanish 6025 6023 6024 French 6034 6032 6033 Belgian French 6016 6014 6015 Canadian French 6058 6056 6057 Swiss French 6028 6026 6027 Italian 6049 6047 6048 Swiss Italian 6064 6062 6063 Japan -- Kanji (DBCS) 6031 6029 6030 Korean 6040 6038 6039 Brazilian Portuguese 6043 6041 6042 Portuguese 6061 6059 6060 Swedish 6037 6035 6036 Net.Data Version 7 Japan -- Kanji (DBCS) 6158 6156 6157 Korean 6161 6159 6160 3480 9/6250 Car- 4-mm Description Tape tridge DAT CD-ROM Net Search Extender Japan -- Kanji (DBCS) 6188 6186 6187 Brazilian Portuguese 6185 6183 6184 QMF for OS/390 Simplified Chinese 6100 6098 6099 Danish 6130 6128 6129 Swiss German 6070 6068 6069 German 6094 6092 6093 English Upper Case SBCS 6103 6101 6102 Spanish 6073 6071 6072 French 6082 6080 6081 Canadian French 6145 6143 6144 Swiss French 6076 6074 6075 Italian 6097 6095 6096 Japan -- Kanji (DBCS) 6079 6077 6078 Korean 6088 6086 6087 Brazilian Portuguese 6091 6089 6090 Swedish 6085 6083 6084 QMF for Windows -- Requires QMF Arabic 6152 Simplified Chinese 6122 Traditional Chinese 6124 Danish 6121 Swiss German 6111 German 6119 Spanish 6112 French 6115 Belgian French 6110 Canadian French 6123 Swiss French 6113 Italian 6120 Swiss Italian 6150 Japan -- Kanji 6114 Korean 6117 Brazilian Portuguese 6118 Portuguese 6151 Swedish 6116 QMF for Windows -- Without QMF Requirement Arabic 6149 Simplified Chinese 6109 Traditional Chinese 5879 Danish 6108 Swiss German 5889 German 6106 Spanish 5899 French 5983 Belgian French 5849 Canadian French 5859 Swiss French 5957 Italian 6107 Swiss Italian 5869 Japan -- Kanji (DBCS) 5970 Korean 6104 Brazilian Portuguese 6105 Portuguese 5839 Swedish 5996 DB2 UDB for OS/390, Version 6 (5645-DB2): Optional Feature Net Search Extender Japan -- Kanji (DBCS) 5720 5718 5719
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) Satellite Electronic Delivery 3450 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 Delivery and Fulfillment (SDF) receives the order. SDF will then ship the order via overnight air transportation.
Additional Copies Order Feature Title Number Number DB2 UDB for OS/390 and z/OS, Version 7 Command Reference SC26-9934 8069 Installation Guide GC26-9936 8064 Licensed Program GC26-9938 8066 Specifications Messages and Codes GC26-9940 8067 Utility Guide and Reference SC26-9945 8072 Online Books: Licensed Library LK3T-6999 8002 Collection (includes licensed and unlicensed material) Additional Copies Order Feature Title Number Number Supplied when DB2 Warehouse Manager or QMF for OS/390 optional feature is ordered: QMF for OS/390, Version 7 Installing and Managing QMF GC27-0719 8098 on OS/390 QMF Messages and Codes GC27-0717 8092 QMF High Performance Option SC27-0724 8091 User's Guide for OS/390 Getting Started with QMF for SC27-0723 8079 Windows Installing and Managing QMF GC27-0722 8074 for Windows Supplied when DB2 Net Search Extender optional feature is ordered: Net Search Extender for OS/390 SC27-1171 8071 and z/OS Administration and Programming
The following optional publications are available by March 30, 2001:
Additional Copies Order Feature Title Number Number DB2 UDB for OS/390 and z/OS, Version 7 Administration Guide SC26-9931 8009 Application Programming Guide SC26-9932 8020 and Reference for Java Application Programming & SQL SC26-9933 8015 Guide Data Sharing: Planning and SC26-9935 8013 Administration Data Sharing Quick Reference SX26-3846 8029 Image, Audio, and Video SC26-9947 8028 Extenders Administration and Programming An Introduction to DB2 for SC26-9937 8011 OS/390 Master Index SC26-9939 8026 ODBC Guide and Reference SC26-9941 8024 Reference for Remote DRDA SC26-9942 8022 Requesters and Servers and Servers Reference Summary SX26-3847 8030 Release Planning Guide SC26-9943 8040 SQL Reference SC26-9944 8017 Text Extender Administration SC26-9948 8031 and Programming What's New? GC26-9946 8003 XML Extender Administration SC26-9949 8032 and Programming QMF for OS/390, Version 7: Introducing QMF GC27-0714 8034 QMF Reference SC27-0715 8055 Using QMF SC27-0716 8056 Developing QMF Applications SC27-0718 8095
Additional copies of unlicensed publications are available by March 30, 2001. These copies may be ordered via direct order or you may contact your IBM representative.
The following DB2 UDB for OS/390 publications can be ordered using bill-of-forms number SBOF-7730.
Order Title Number DB2 UDB for OS/390 and z/OS, Version 7 Command Reference SC26-9934 Installation Guide GC26-9936 Messages and Codes GC26-9940 Utility Guide and Reference SC26-9945 Administration Guide SC26-9931 Application Programming Guide SC26-9932 and Reference for Java Application Programming & SQL SC26-9933 Guide Data Sharing: Planning and SC26-9935 Administration Data Sharing Quick Reference SX26-3846 Image, Audio, and Video SC26-9947 Extenders Administration and Programming Master Index SC26-9939 ODBC Guide and Reference SC26-9941 Reference for Remote DRDA SC26-9942 Requesters and Servers Reference Summary SX26-3847 Release Planning Guide SC26-9943 SQL Reference SC26-9944 Text Extender Administration SC26-9948 and Programming What's New? GC26-9946 XML Extender Administration SC26-9949 and Programming
Displayable Softcopy Publications: DB2 UDB Server for OS/390 publications are offered in displayable softcopy form. All unlicensed manuals are included. 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.
The first copy is supplied automatically with the basic machine-readable material. Use the feature number 8XXX to order additional copies for a fee.
Additional Copies Order Feature Title Number Number DB2 UDB for OS/390 and z/OS Version 7 Diagnosis Guide and Reference LY37-3740 8000 Diagnostic Quick Reference LY37-3741 8001 Online Books: Licensed Library LK3T-6999 8002 Collection (includes licensed and unlicensed material)
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.
The following publications will be available after availability:
Order Title Number DB2 UDB for OS/390, Version 7 German What's New? GC12-2947 Introducing QMF GC12-2858 QMF Reference SC12-2849 Using QMF SC12-2850 Installing and Managing GC12-2859 QMF for Windows Getting Started with SC12-2847 QMF for Windows Japan (DBCS) Administration Guide SC88-8761 Application Programming Guide SC88-8762 and Reference for Java Application Programming and SQL SC88-8763 Guide Command Reference SC88-8764 Data Sharing: Planning and SC88-8765 Administration Image, Audio and Video Extenders SC88-8775 Administration and Programming Introduction to DB2 for OS/390 SC88-8767 Installation Guide GC88-8766 Messages and Codes GC88-8768 ODBC Guide and Reference SC88-8769 Reference for Remote DRDA SC88-8770 Requestors and Servers Release Planning Guide SC88-8771 SQL Reference SC88-8772 Text Extender Administration SC88-8776 and Programming Utility Guide and Reference SC88-8773 What's New? GC88-8774 XML Extender Administration SC88-8777 and Programming Introducing QMF GC88-8618 QMF Reference SC88-8619 Using QMF SC88-8620 QMF Messages and Codes GC88-8621 Developing QMF Applications SC88-8622 Installing and Managing GC88-8623 QMF for OS/390 Installing and Managing GC88-8669 QMF for Windows Getting Started with SC88-8670 QMF for Windows Traditional Chinese Installing and Managing GC40-0530 QMF for Windows Getting Started with SC40-0531 QMF for Windows Simplified Chinese Installing and Managing SB84-0252 QMF for Windows Getting Started with SB84-0253 QMF for Windows Order Title Number Spanish Introduction to DB2 for OS/390 SC10-3600 Master Index SC10-3601 Text Extender Administration SC10-3602 and Programming What's New? GC10-3599 XML Extender Administration SC10-3593 and Programming Introducing QMF GC10-3530 QMF Reference SC10-3531 Using QMF SC10-3532 Getting Started with SC10-3533 QMF for Windows Brazilian Portuguese Introducing QMF S517-6997 QMF Reference S517-6998 Using QMF S517-6999 Getting Started with S517-7008 QMF for Windows Egyptian Getting Started with SB20-2151 QMF for Windows Korean Introducing QMF GA30-1047 QMF Reference SA30-1048 Using QMF SA30-1049 QMF Messages and Codes GA30-1050 Developing QMF Applications SA30-1051 Getting Started with SA30-1046 QMF for Windows French Introducing QMF GC11-1685 Using QMF SC11-1687 Getting Started with SC11-1694 QMF for Windows Italian Introducing QMF GC13-2904 QMF Reference SC13-2905 Using QMF SC13-2906 Getting Started with SC13-2907 QMF for Windows Portuguese Getting Started with SC17-5378 QMF for Windows
Terms and Conditions
Single- Version Charging Replaced Program Replacement Program Applies DB2 Version 1 DB2 UDB Version 7 Yes 5740-XYR 5675-DB2 DB2 Version 2 DB2 UDB Version 7 Yes 5665-DB2 5675-DB2 DB2 Version 3 DB2 UDB Version 7 Yes 5685-DB2 5675-DB2 DB2 Version 4 DB2 UDB Version 7 Yes 5695-DB2 5675-DB2 DB2 Version 5 DB2 UDB Version 7 Yes 5655-DB2 5675-DB2 DB2 Version 6 DB2 UDB Version 7 Yes 5645-DB2 5675-DB2 DB2 Version 7 To a follow-on program, N/A 5675-DB2 if any. QMF Feature QMF Version 1 DB2 UDB Version 7 Yes(2) 5668-972 5675-DB2 QMF Version 2 DB2 UDB Version 7 Yes(2) 5668-721 5675-DB2 QMF Version 3 DB2 UDB Version 7 Yes(2) 5706-254 5675-DB2 QMF for Windows Feature QMF for Windows, DB2 UDB Version 7 Yes(2) Version 3.3 5675-DB2 5697-D27
Authorization to use this copy of DB2 Connect is to enable access to DB2 for OS/390 data by the following workstation tools only:
For all other remote connections to DB2 for OS/390 provided through DB2 Connect, or for any use of DB2 Connect not specifically described above, you must obtain a separate license for DB2 Connect from IBM.
Authorization to use this copy of DB2 UDB Enterprise Edition is to enable database management of DB2 for OS/390 data warehouse control databases by the following workstation tools only:
For use of DB2 UDB Enterprise Edition other than the uses specifically described above, you must obtain a separate license for DB2 UDB Enterprise Edition from IBM.
Terms and Conditions (S/390 Application Starterpak Software): The software preloaded as a result of ordering feature number 1408, 1409, or 1410 on the IBM 3000 Model A10 or A20 is licensed under the terms of the Attachment for IBM Application StarterPak License (Z125-5597) to the IBM Customer Agreement or to its equivalent depending on the geography.
Two months (basic license only)
Use Priority/Reference Code: LE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org Mail: IBM Atlanta Sales Center Dept. LE001 P.O. Box 2690 Atlanta, GA 30301-2690
You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.
Note: Shipments will begin after the planned availability date.