|
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 GlanceWith 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). OverviewThe 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 Key Prerequisites
Description
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 ExtenderNet 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.
Note:
Net Search Extender is ordered as a feature of DB2 UDB for OS/390,
Version 6 (5645-DB2) as well as with DB2 UDB for OS/390 and z/OS, Version
7.
Warehouse IntegrationDB2 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 ScalabilityVersion 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
normal mode.
Enterprise ApplicationVersion 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
Announcement
200-307
, 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
201-050
, 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
tasks.
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
Announcement
200-307
, dated September 12, 2000, and Software Announcement
201-056
, dated March 6, 2001.
Euro CurrencyThese programs are not impacted by euro currency. Product PositioningDB2 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 ServicesSmoothStart™/Installation 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 TeamThe 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 lclange@us.ibm.com.
Trademarks
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:
Following is a detailed description of each of these features.
DB2 Warehouse Manager FeatureUse 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:
The Information Catalog: The Information Catalog helps end users to find, understand, and access information they need for making decisions. It:
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.
QMF High Performance Option (HPO) Enhancements
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 ExtenderNet 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. Key Features: Net Search Extender key features include:
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:
Net Search Extender and Text Extender: In contrast to Text Extender, which offers text search functionality fully integrated into SQL, Net Search Extender provides a single stored procedure. 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.
However, for text-only queries, with an expectation of high levels of
concurrent queries, Net Search Extender is the recommended solution.
DB2 Management Clients PackageThe 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:
Net.Data FeatureThe 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 FeatureREXX 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. Technical InformationHardware RequirementsProcessors: 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. Data Communications Devices: DB2 operations can be controlled from:
For the data communication devices supported by IMS/ESA Transaction Manager, CICS, and TSO, refer to the documentation for these products. Function-Dependent Hardware Requirements
Software RequirementsThis 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 Program Requirements: The following functions of DB2 require specific licensed programs, or features of licensed programs, before they can be used:
Optional Program Requirements: The following functions are enabled with the specified optional licensed programs when used together with DB2:
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. Recommendation: Before using these features, refer to the installation information for these features to ensure you have all required and recommended products.
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
Planning InformationCustomer Responsibilities: Customers should review the sections in this announcement that describe the hardware and software dependencies for DB2 UDB for OS/390 and z/OS, Version 7. 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). Installability: Customers should refer to the planning sections of the following publications available from an IBM representative, as well as the Program Directory shipped with the product:
Packaging: The DB2 UDB Server for OS/390, except as noted below, will be shipped on 9-track magnetic tapes (written at 6,250 bpi), 3480 cartridges, or 4-mm DAT cartridges. 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 ControlDB2 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. Customer FinancingIBM 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: Ordering InformationNew LicenseesOrders 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. Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. 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
Example 1: For a single machine with 11 MSUs, the PSLC features would be: 0003 — quantity 1 0004 — quantity 8 Example 2: For two machines in a Parallel Sysplex, which have an aggregation of 60 MSUs, the PSLC features would be:
DB2 Warehouse Manager Feature (PSLC)
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
Example 1: For a single machine with 11 MSUs, the PSLC features would be: 0064 — quantity 1 0065 — quantity 8 Example 2: For two machines in a Parallel Sysplex, which have an aggregation of 60 MSUs, the PSLC features would be:
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
Example 1: For a single machine with 11 MSUs, the PSLC features would be: 0109 — quantity 1 0110 — quantity 8 Example 2: For two machines in a Parallel Sysplex, which have an aggregation of 60 MSUs, the PSLC features would be:
QMF for Windows Feature of QMF (PSLC): Requires QMF for OS/390
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
Example 1: For a single machine with 11 MSUs, the PSLC features would be: 0219 — quantity 1 0220 — quantity 8 Example 2: For two machines in a Parallel Sysplex, which have an aggregation of 60 MSUs, the PSLC features would be:
QMF for Windows Feature (PSLC): Without QMF for OS/390 requirement
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
Example 1: For a single machine with 11 MSUs, the PSLC features would be: 0257 — quantity 1 0258 — quantity 8 Example 2: For two machines in a Parallel Sysplex, which have an aggregation of 60 MSUs, the PSLC features would be:
DB2 Net Search Extender Feature (PSLC)
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
Example 1: For a single machine with 11 MSUs, the PSLC features would be: 0503 — quantity 1 0504 — quantity 8 Example 2: For two machines in a Parallel Sysplex, which have an aggregation of 60 MSUs, the PSLC features would be:
DB2 Net Search Extender Feature (PSLC): Optional feature of 5645-DB2, DB2 UDB for OS/390, Version 6
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
Example 1: For a single machine with 11 MSUs, the PSLC features would be: 0338 — quantity 1 0339 — quantity 8 Example 2: For two machines in a Parallel Sysplex, which have an aggregation of 60 MSUs, the PSLC features would be:
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 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
Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be: 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:
DB2 Warehouse Manager Feature (WLC)
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
Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be: 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
Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be: 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:
QMF for Windows Feature of QMF (WLC)
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
Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be: 0487 — quantity 1 0488 — quantity 130 0491 — 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:
QMF for Windows Feature (WLC): Without QMF for OS/390 requirement
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
Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be: 0473 — quantity 1 0474 — quantity 130 0477 — 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:
DB2 Net Search Extender Feature (WLC)
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
Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be: 0521 — quantity 1 0522 — quantity 130 0525 — 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:
DB2 Net Search Extender Feature (WLC): Optional feature of 5645-DB2, DB2 UDB for OS/390, Version 6
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
Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be: 0356 — quantity 1 0357 — quantity 130 0360 — 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:
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. Basic Machine-Readable Material
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
NLS Features: DB2 UDB Server for OS/390 NLV support features will become available on the same date the release code becomes available. 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
Customization Options: Select the appropriate feature numbers to customize your order to specify the delivery options desired. These features can be specified on the initial or MES orders. Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.
Feature
Description Number
Initial Shipments
Serial number only (suppresses shipment 3444
of media and documentation)
Ship media only (suppresses initial 3470
shipment of documentation)
Ship documentation only (suppresses 3471
initial shipment of media)
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. Unlicensed Documentation: A memo, program directory, and one copy of the following publications are supplied automatically with the basic machine-readable material:
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. Licensed Documentation: The following licensed material will be available from IBM by March 30, 2001. To order, contact your IBM representative. 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 ConditionsIndexed Monthly License Charge (IMLC) Applies: No Installation License or Location License Applies: No Educational Allowance: Yes, a 15% education allowance applies to qualified education institution customers. Volume Discount: Not applicable
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
Limited-use License for DB2 Connect: The DB2 Management Clients Package provides a restricted-use copy of Connect Version 7. 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. Limited-use License for DB2 UDB Enterprise Edition: The DB2 Warehouse Manager provides a restricted-use copy of DB2 UDB Enterprise Edition Version 7. 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. Licensed Program Materials Availability
Two months (basic license only)
Order Now
Use Priority/Reference Code: LE001
Phone: 800-IBM-CALL
Fax: 800-2IBM-FAX
Internet: ibm_direct@us.ibm.com
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.
Trademarks
|
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