June 15, 1999
DB2 UDB Server for OS/390, Version 6 Delivers the Power for Your e-business and Business Intelligence Needs
(Corrected on July 8, 1999)
Prices corrected on features 2004 and 2015.
(Corrected on June 25, 1999)
At a Glance
With Version 6, DB2 UDB Server for OS/390 provides databases that are:
For ordering, contact:
The DB2 Universal Database® Server for OS/390®, Version 6 program extends the DB2 Universal Database to the System/390® platform. Now IBM combines the power of PC and UNIX® application development and query tools with the industrial-strength, reliability, and performance of DB2 Universal Database Server for OS/390 (DB2® UDB Server for OS/390).
With Version 6, it is now possible to have an enterprise-wide DB2 strategy that can take full advantage of these UDB object-relational capabilities across major IBM and non-IBM operating systems. With it, you can develop e-business applications for tomorrow while continuing to meet today's business needs.
DB2 UDB for OS/390, Version 6 delivers enhancements and improvements that can be utilized by existing applications. You can take advantage of:
Version 6 also delivers more power for e-business and network computing with better performing Java applications, which can now use static SQL, enhanced Open Database Connectivity (ODBC) support, further improvements to stored procedures, and connection pooling that permits Distributed Data Facility (DDF) to better support large client networks. Version 6 now has the capability to:
With Version 6, DB2 for OS/390, a leader for OLTP business solutions, works with S/390® to provide the power, capacity, and reliability needed for today's demanding business intelligence (BI) and Enterprise Resource Planning (ERP) solutions. DB2 UDB for OS/390 can hold the largest data warehouses, manage effective throughput for mixed workloads of decision support and operational transactions, and provide mission-critical data services for ERP solutions.
DB2 UDB Server for OS/390 is expanded to offer even more of the features you need to manage, access, and tune your DB2 environment. Version 5 offered DB2 Performance Monitor and Net.Data. Now Version 6 also provides QMF and QMF for Windows, DB2 DataPropagator, DB2 Administration Tool, and DB2 Buffer Pool Tool as features of the server.
An additional feature, DB2 Management Tools Package, combines several workstation-based tools to enable you to tune, administer, and manage your DB2 through easy-to-use graphical interfaces. Take advantage of these optional features and discover how they can help you to obtain even more from your DB2.
Planned Availability Date
DATABASE 2 Universal Database 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, high-performance, and continuous availability.
In response to customer and marketplace demands, Version 6 of DB2 UDB for OS/390 delivers universal database capabilities for:
Relational databases are extensively used for mission-critical applications. Building on the strength of the relational technology, this release delivers, through object-relational extensions, support for non-traditional, object-oriented applications like multimedia. The very Large Objects (LOBs), User-Defined Functions, and User-Defined Distinct Data Types together support the handling of new, large, and complex data types needed in object-oriented applications like image, voice or multimedia. With the object-relational support delivered in Version 6, DB2 UDB for OS/390 becomes a database of choice for object-oriented application programming. In addition, this release of DB2 delivers triggers making it possible to convert the database from a passive to an active database.
DB2 UDB for OS/390 has the capacity required to handle and store these new complex data types. A LOB column can be up to 2 GB in length and a collection of all LOB values can be up to 4,000 TB. The DB2 Extenders build on the object-relational infrastructure of DB2. Each extender is a package of predefined UDTs, UDFs, triggers, constraints, and stored procedures that satisfies a specific application domain. With the extenders, you can store text documents, images, videos, and audio clips in DB2 tables by adding columns of the new data types provided by the extenders. The actual data can be stored inside the table or outside in external files. These new data types also have attributes that describe aspects of their internal structures, such as "language" and "format" for text data. Each extender provides the appropriate functions for creating, updating, deleting, and searching through data stored in its data types. You can now include these new data types and functions in SQL statements for integrated content searching across all types of data. Four DB2 Extenders are provided as part of the DB2 UDB Server for OS/390.
The DB2 Text Extender adds the power of full-text retrieval to SQL queries by making use of features available in DB2 that let you store unstructured text documents of up to 2 GB in databases. Text Extender offers DB2 users and application programmers a fast, versatile, and intelligent method of searching through such text documents. Text Extender's strength lies in its ability to search through many thousands of large text documents at high speed, helping you to find not only what you directly ask for, but also word variations and synonyms. You are not restricted to searching only in text documents stored in DB2 databases, you can also search in text documents stored in files.
The DB2 Image Extender defines a new data type and functions for images using DB2 UDB's built-in support for user-defined types and user-defined functions. It also exploits DB2 UDB's support for LOBs of up to 2 GB and uses DB2 UDB triggers to store and maintain, automatically, attribute information for images. The DB2 Image Extender supports a wide variety of image formats, such as GIF (including animated GIFs), JPEG, BMP, and TIFF.
The DB2 Audio Extender defines a new data type and functions for audio using DB2 UDB's built-in support for user-defined types and user-defined functions. It also exploits DB2 UDB's support for LOBs of up to 2 GB and uses DB2 UDB triggers to store and maintain, automatically, attribute information for audio objects. The DB2 Audio Extender supports a variety of audio file formats, such as WAVE, MIDI, MPEG1, and AU, and can work with different file-based audio servers.
The DB2 Video Extender defines a new data type and functions for video using DB2 UDB's built-in support for user-defined types and user-defined functions. It also exploits DB2 UDB's support for LOBs of up to 2 GB and uses DB2 UDB triggers to store and maintain, automatically, attribute information for video objects. The DB2 Video Extender supports a variety of video file formats, such as MPEG1, MPEG2, AVI, and QuickTime, and can work with different file-based video servers.
Traditional business applications can also profit from the new UDTs and UDFs provided in DB2 UDB for OS/390, Version 6. Distinct types allow your business model to expand beyond DB2's built-in data types. For instance, a numeric field for currency value could be defined as a distinct type of currency, such as the Euro or U.S. dollars. Now, your application logic can be guarded against erroneously summing Euro currency with U.S. dollars. User-defined functions allow you to write your own extensions to the capability provided by SQL. UDFs are similar to stored procedures, written in high-level languages like COBOL, Java, C, and C++. They run in the stored procedures address space managed by the MVS Workload manager.
Triggers help you to bring application logic into the database. A trigger defines a set of actions to be executed when a specific SQL data change operation occurs. Uses for triggers include:
Version 6 delivers universal access for e-business, Web, and other distributed network computing applications. In Version 5, DB2 added support for Java access via JDBC connectivity. Now combine the portability of Java application development with the performance advantage of using static Structured Query Language (SQL). What you get is SQLJ, which is SQL embedded in the Java programming language. SQLJ gives you more control over authorization checking, because now table privileges can be granted to the package owner. With dynamic SQL that JDBC uses, table privileges must be granted to each end user.
Distributed Relational Database Architecture (DRDA) includes support for three-part names. Applications using the private protocol to access distributed DB2 data on other MVS systems can now enjoy all the benefits of DRDA without having to make any program revisions.
Stored procedures are also enhanced for DB2 UDB for OS/390, Version 6. Easier management is afforded now through the use of CREATE, ALTER, GRANT, and REVOKE to manage your stored procedures. Use the Stored Procedures Builder tool to easily develop and deploy stored procedures from a graphical development environment. Additionally, a new register, CURRENT PATH, and the PATH bind option allow implicitly qualified stored procedure names in CALL statements. Stored procedures now permit nested calls by stored procedures and user-defined functions, and you can also use stored procedures for DB2 utility invocation. The Call Level Interface (CLI) introduced in Version 5 is enhanced to support the new object-relational functions:
CLI calls can now be issued from within a stored procedure. This can enhance portability of existing ODBC applications to the OS/390 platform.
DDF Connection Pooling can support thousands of TCP/IP or SNA connections to a small number of database access threads with much less storage than was required in previous releases.
The power of the SQL language is enhanced by the increase in SQL functions provided in Version 6. Now, scores of new built-in functions are available to permit you to obtain results such as absolute value, modulus, square root, standard deviation, or calendar conversions as part of your SQL operation. This extended list of functions contributes to increased compatibility among the DB2 UDB family, making your applications even more portable.
Universal Scalability, Reliability, Availability
In every release, DB2 provides more function to help you deliver mission-critical applications. With DB2 UDB for OS/390, Version 6, you can:
Unbalanced table spaces can be adjusted by altering the partitioning key for affected partitions, the rest of the table space can remain available to your application while the altered partitions are reorganized. Utility improvements include parallelism for COPY and RECOVER utilities so that a list of image copies can be processed in parallel and thus reduce the elapsed time of these jobs. REBUILD INDEX is the new name for RECOVER INDEX. Now the RECOVER utility can rebuild indexes and table spaces from one utility statement. For table spaces with more than one index, DB2 can sort, build, and rebuild indexes in parallel, thus saving elapsed time for LOAD, REORG, and REBUILD INDEX. Further elapsed time savings can occur by including RUNSTATS within the execution of:
The in-line statistics eliminates the need for a separate RUNSTATS pass over the same data. A new option of REORG permits the discarding of data. The discarded data can be optionally saved to a file. You can avoid unnecessary execution of REORG by specifying threshold limits for relevant statistics from the DB2 catalog, which determine when the REORG will execute.
Restart and recovery is improved by permitting some of the backout work to be postponed until after system restart. When many backouts are required at restart, this will contribute to a significantly faster restart than was available with prior releases. Also, a faster log apply process can improve restart and recovery times with fewer I/O operations and with reduced CPU time.
Your largest applications and data warehouse projects can benefit from the expansion in table size. Now individual tables can be defined to be up to 16 TB in size, adding an order of magnitude to your database capacity.
Query parallelism is extended to include more types of queries. Now with Version 6, outer joins, queries on nonpartitioned tables, and queries using IN list index access are eligible for parallel processing. Sysplex Query Parallelism is enhanced to better balance workloads for Sysplexes comprised of unlike processor models. Also, reevaluation at run-time can redistribute work when the number of members has changed or there are shortages of buffer pool resource.
Several query improvements will be especially valuable for data warehouse and business intelligence applications. Join processing for columns of different length but same data types is improved. This will be especially important for joins of tables with a million or more rows. Outer-join and star-join processing are improved and enhanced.
DB2 UDB for OS/390, Version 6 gives you more choices for sizing your data pages. In addition to the previously supported 4 KB and 32 KB page sizes, you can now choose from 8 KB and 16 KB page sizes. You can store your data more efficiently and balance the I/O costs for random access processing.
New with DB2 UDB for OS/390, Version 6 is support for buffer pools in data spaces. Now, you can move buffer pools out of the DB2 address space into data spaces. This provides relief for applications facing virtual storage constraints. DB2 is positioned to take advantage of any future changes that would permit S/390 processors to expand beyond 2 GB of real memory.
Expanding upon the server features delivered in Version 5, QMF, QMF HPO, QMF for Windows, DB2 DataPropagator, DB2 Administration Tool, and DB2 Buffer Pool Tool are now features of DB2 UDB Server for OS/390. These optional, priced features add query, administration, and data management services that extend the power and utility of DB2. All of the optional, priced features are shipped as a time-limited "Try and Buy" with DB2 UDB for OS/390. Install and try these features and discover the value they bring to your DB2. A full-use license may be obtained by ordering the "Buy" feature that delivers the key that removes the time restriction. The features of DB2 UDB Server for OS/390 were developed to work with Version 6 and have been tested to help assure they install and execute in an integrated environment. This can save you valuable install test time. For detailed descriptions of these optional features, plus Net.Data, DB2 PM, and the new DB2 Management Tools Package, refer to the Additional Features of DB2 UDB Server for OS/390 section.
This product is Year 2000 ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and/or receiving date data within and between the twentieth and twenty-first centuries, provided that all products (hardware, software, and firmware) used with the product properly exchange accurate date data with it.
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, Enterprise Resource Planning applications such as 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 marketplace. DB2 supports transactions arising from 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.
Statement of General Direction
With DB2 for OS/390, Version 5, IBM delivered additional new function after availability. This function was delivered via service and was consolidated by periodic refreshes of DB2 for OS/390. IBM intends to deliver additional new function via this refresh process for DB2 UDB for OS/390, Version 6. Each refresh will undergo integration testing to assure you of a stable service level of DB2 for OS/390. You can subscribe to IBM's information service "iSource", to obtain e-mail notice of news about DB2 for OS/390, by pointing your browser to:
IBM intends to deliver the Stored Procedure Builder Tool for the DB2 UDB Family. It will be initially available in a beta test format for use with DB2 UDB for OS/390. You can obtain it from the Web by linking to "Download" from:
Stored Procedure Builder is planned to be incorporated into the DB2 Management Tools Package when Version 6 is refreshed.
IBM will probably remove support for the private-protocol access of the Distributed Data Facility in a future release of DB2 for OS/390. IBM has no plans for additional enhancements. DRDA replaces the private-protocol access. Private protocol does not support stored procedures and TCP/IP, both of which are available with DB2 for OS/390, Version 5. Private protocol also does not support the network computing enhancements in Version 6.
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.
Reference: Software Announcement 298-159 , dated May 12, 1998.
Additional Features of DB2 UDB Server for OS/390®
DB2® UDB Server for OS/390 expands the offering of features that combine with DB2 to enhance query access, management, and replication of your data. Features new in Version 6 include:
These features are in addition to the features added in Version 5:
DB2 QMF Feature
IBM Query Management Facility (QMF), the tightly integrated, powerful, reliable, query and reporting tool for IBM's 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 6 enables you to work with data all over the enterprise from DB2 for OS/390 to DB2 for VSE and VM 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 QMF Family consists of the following integrated tools:
They offer a total solution that includes:
They also provide for report publishing to the Web for viewing with your favorite Web browser.
The components in QMF HPO Version 6 (QMF HPO/Manager and QMF HPO/Compiler) were available as QMF features that could be ordered separately in QMF Version 3.3. They are no longer available as separately ordered features in Version 6. QMF HPO/Complete is now simply called QMF HPO and includes the QMF HPO/Manager, QMF HPO/Compiler, and QMF for Windows as one comprehensive feature.
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 production applications, while delivering "on demand" information. 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 provides many benefits, including an intuitive GUI "quick start" user interface. Using QMF for Windows, you can automate tasks and develop powerful native Windows applications. The tool includes a robust Windows-based API to automate database querying, updating, and report distribution tasks, so you can centralize control over resource consumption. QMF for Windows also provides 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. Not all connection methods are available with all releases of DB2. Refer to Installing and Managing QMF for Windows (GC26-9583) for details.
QMF for Windows is available in three distinct ordering configurations:
QMF Version 6 includes enhancements and support for:
QMF For Windows, Version 6 enhancements include support for:
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:
DB2 DataPropagator Feature
DB2 DataPropagator Version 6 provides read-only, update-anywhere, and on-demand replication between relational sources and targets and defines the architecture for the comprehensive IBM Data Replication solution.
The IBM DB2 DataPropagator consists of the following autonomous components/programs:
The Administration component for the DB2 DataPropagator Version 6 is called the Control Center. The Control Center is the integrated administration tool for DB2 Universal Database Version 5 and includes replication administration. The Control Center runs on OS/2, Windows NT, and Windows 95 platforms and does not require a local DB2 database. The Control Center is used to:
Whenever you submit a replication request from the Control Center, such as defining a replication source, the processing information is generated as SQL statements. You can choose to run the statements immediately, or you can save the SQL statements to a plain ASCII file, which you can edit and run at a later time from a replication folder object in the Control Center.
Deferred SQL files allow you to customize the replication tasks for your shop or application and give you the flexibility as to when and how you run the SQL files.
The Capture component captures changes made to data in tables defined as replication sources by reading the database log or journal without causing any changes and running asynchronously to business applications. The captured changes are placed in staging tables. The IBM DB2 DataPropagator Capture for OS/390, Version 6 supports DB2 for MVS, Version 3.1, or later. However, the following functions are available with DB2 for MVS, Version 4.1, or later:
The Apply component reads the changed data, previously captured and stored in a staging table, and applies it to the target tables. Apply components can also read data directly from source tables, for example, for a full refresh. Supporting update and refresh copying provides greater flexibility and automation in a replication environment. The Apply component also enhances the data to your specifications as it copies data to the targets. You can exploit the full power of SQL to:
You can define run-time processing statements using SQL statements and stored procedures before and after the Apply program processes the replication subscription. The run-time processing statements can be run at the source server before the answer set is fetched, and at the target server before and after the answer set is applied. The stored procedures use the SQL CALL statement, newly supported by IBM Replication, without parameters. The run-time procedures are executed together in a single unit-of-work. Acceptable SQLSTATEs can be defined for each processing statement as well.
The Apply component allows you to create:
You can subset data for distribution through column and row specifications, replicating only the data you need. Unique to DB2 DataPropagator is the ability to subselect for joins and unions, allowing you to subset according to a value not in the table being replicated. This can be a key requirement when replicating to mobile laptops from normalized databases where most values are not redundantly stored.
Finally, an Apply instance can process many subscriptions at a single site. Multiple Apply instances can run concurrently at different sites/platforms, each processing different numbers and types of subscriptions from the same source. Each subscription can have different definitions, refresh criteria, and timing.
The On-Demand replication capability offers a solution to the challenge of infrequent and unpredictable connections present in the mobile computing community. Data transfers are initiated from the mobile unit where control should be based. This implementation allows downloading from a central server (pulling), or uploading for consolidated processing (pushing).
DB2 DataPropagator Version 6 offers a highly efficient architecture for automatic capture and asynchronous propagation of data changes to the DB2 family of databases. It contains a high-performance, log-based change-capture component that captures all DB2 updates without response-time impact or requiring any user application changes. You can make powerful data enhancements using standard SQL including multitable joins and the use of stored procedures. There is support for full refresh and update change replication, including update of denormalized copies. DataPropagator supports seamless interoperation with DataPropagator NonRelational (IMS), DataRefresher, DataJoiner, and Lotus NotesPump products to deliver robust, versatile replication among:
There is easier, intuitive administration from the DB2 Universal Database Control Center running on OS/2, Windows NT, and Windows 95 platforms. Support exists for subscription sets allowing for transaction consistency. DB2 view-based replication, including join views, is supported as well as event-driven and continuous replication. Also supported is update-anywhere replication with robust conflict detection and compensation, along with on-demand replication for occasionally connected and mobile systems. DB2 Catalog replication is now supported for speeding up of ODBC-based queries.
New with Version 6 for DB2 DataPropagator is the ability to replicate large objects (BLOB, CLOB and DBCLOB) as well as replication for ROWID, a new data type introduced in DB2 UDB for OS/390. Installation of DataPropagator is easier and integrated using the DB2 installer. Support for a mixed data sharing environment consisting of different versions of DB2 is now included as well as better resource utilization for continuous replication scenarios. Additional capturing choices are added allowing you to capture changes when any column changes or only when one of the registered columns changes. There is improved scalability, performance, and concurrency along with support for many popular versions of DB2 including:
DB2 Administration Tool Feature
Use DB2 Administration Tool (DB2 Admin) to:
As the number and complexity of DB2 applications and systems increase, having the right DB2 tools has never been more important.
DB2 Administration Tool is the right tool to help you get the most from your DB2 system. Its comprehensive set of database management functions helps DB2 systems personnel efficiently and effectively manage your DB2 environment by:
DB2 Admin supports the functionality of DB2 Version 6 by providing panels and options allowing you to quickly see new pertinent catalog information. DB2 Admin works on a data sharing, group member level.
DB2 Admin provides usability enhancements, lower overhead costs, better error recovery, and more extensive online help. Highlights include:
DB2 Admin offers a robust set of database management functions for DB2 MVS systems personnel. As your enterprise expands its DB2 usage and systems environment, you may need to manage multiple complex DB2 systems, perhaps in several locations. DB2 Admin simplifies database administration and allows you to manage these systems more efficiently and effectively.
DB2 Admin is an easy-to-use, ISPF panel driven tool, which overviews DB2 system tables and provides relevant DB2 catalog information in a logical format. Designed to be an interactive and intuitive tool to learn and use, DB2 Admin integrates with DB2 utilities and simplifies creation of DB2 utility jobs. Among DB2 Admin's strengths is the extensive support to simplify understanding and analysis of the DB2 catalog and allow you to intelligently act on the information presented. The abundant DB2 catalog query capabilities in DB2 Admin include:
DB2 Admin offers new panels and options for DB2 Version 6 including:
DB2 Admin's power-packed functionality still includes:
DB2 Buffer Pool Tool Feature
While DB2 online performance monitors can tell you when something is wrong, it may be a difficult and time-consuming effort to determine what is the right corrective action to take. Take the guesswork out of tuning and avoid making costly mistakes with DB2 Buffer Pool Tool.
DB2 Buffer Pool Tool helps performance analysts evaluate tuning alternatives and achieve optimal performance with minimal effort. Accurate tuning of buffer pools is one of the single, most-critical factors to improving DB2 performance and getting the most out of your system resources. By now, we all know the best I/O is no I/O; however, eliminating I/O can be a challenging task.
DB2 Buffer Pool Tool gives you comprehensive statistical data and easy-to-read reports and graphs for all pools and objects. The type of information provided by DB2 Buffer Pool Tool is not available from any other monitor or tool in the industry.
DB2 Buffer Pool Tool provides the ability to simulate the effects of changing pool sizes and thresholds. It can also help you predict the effects of moving DB2 objects into different pools or into new pools that do not currently exist. This "what if" analysis allows you to make expert decisions on maximizing resource utilization and reducing elapsed time of your DB2 transactions through effective buffer pool usage. DB2 Buffer Pool Tool is the ultimate tuning aid. If you need a better way of realizing performance improvements, then consider the advantages DB2 Buffer Pool Tool can provide. DB2 Buffer Pool Tool makes it easier to maximize system resources and optimize DB2 performance. Eliminate I/O and realize better utilization of your existing expanded and real storage with DB2 Buffer Pool Tool. DB2 Buffer Pool Tool allows you to:
The DB2 Buffer Pool Tool provides the following advantages:
DB2 Buffer Pool Tool gives you expert tuning knowledge and reduces the time and effort necessary to effectively tune your environment. Make informed decisions with confidence regarding performance improvements.
DB2 Management Tools Package Feature
The DB2 Management Tools Package is a new, no-charge feature of DB2 for OS/390, Version 6. The Management Tools 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 Tools Package Feature are:
DB2 UDB Control Center: Users of DB2 for OS/390 can now manage data in a new way. The Control Center capability of DB2 Universal Database Version 6 for Windows, UNIX, and OS/2 now extends support to DB2 for OS/390, 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, as well as 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 Software Developers Kit (SDK) on Windows, delivered with all editions of DB2 Universal Database and DB2 Connect products on Linux, OS/2, UNIX, and Windows. Because the Control Center requires DB2 Connect, the DB2 Management Tools Package provides a restricted-use copy of DB2 Connect Version 6 to satisfy this functional dependency.
The Control Center approach to managing DB2 is now extended to the System/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 Tools Package, provides an easy-to-use development environment for creating, installing, and testing stored procedures. With the DB2 Stored Procedure Builder, 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 Stored Procedure Builder provides a single development environment that supports the entire DB2 family ranging from the workstation to System/390. With DB2 Stored Procedure Builder, you can develop stored procedures on one operating system and deploy them on other server operating systems.
The DB2 Stored Procedure Builder has a GUI that guides you through the tasks with the help of basic design patterns, SQL assistants, and costing information. Use the Stored Procedure Builder to perform a variety of tasks associated with stored procedures, such as:
DB2 Stored Procedure Builder support for DB2 for OS/390 is initially available in beta test mode. It can be obtained from the Web at:
DB2 Stored Procedure Builder is part of the DB2 SDK on Windows, delivered with all editions of DB2 Universal Database and DB2 Connect products on Linux, OS/2, UNIX, and Windows. Because the SPB requires DB2 Connect, the DB2 Management Tools Package provides a restricted-use copy of DB2 Connect Version 6 to satisfy this functional dependency.
DB2 Installer: DB2 Installer is a workstation client delivered as an element of the DB2 Management Tools 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:
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. As a result of enhancements to Visual Explain Version 6, 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 Tools Package provides a restricted-use copy of DB2 Connect Version 6 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 Tools 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. 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. Eliminate 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 Version 5 and Version 6 of DB2 for OS/390. It runs in any environment that supports Windows (Windows 3.1, Windows 95, Windows 98, 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.
DB2 PM Feature
The DB2 PM Feature enables you to monitor, analyze, and optimize the performance of DB2 UDB for OS/390, Version 6 and its subsystems. It includes an online monitor to provide an immediate "snap-shot" view of DB2 for OS/390 activities and to allow for exception processing while the system is operational. In addition, it offers:
Enhancements to DB2 PM Feature for Version 6 include:
The DB2 PM Feature is the right solution for you, even if you have an environment of multiple DB2 releases. Ensuring protection of your investment, DB2 PM fully supports instrumentation, catalog, and PLAN_TABLE data from:
The new Net.Data Version 2 feature provides high-performance access to DB2 data from the World Wide Web. Net.Data for OS/390, Version 2 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.
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 2.2 adds enhancements for performance, scalability, usability, and serviceability. With Net.Data for OS/390, Version 2.2, 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:
DB2 UDB for OS/390, Version 6 provides the relational database function described in the Open Blueprint. It provides the:
DB2 UDB for OS/390, Version 6 is developed at a lab where the quality management system is certified under ISO 9001.
DB2 UDB for OS/390, Version 6 conforms with the following national and international SQL standards:
DB2 UDB for OS/390, Version 6 is certified as Tivoli Ready . Tivoli Ready products are certified for integration with Tivoli management software. These products provide instant integration with Tivoli software, and they provide the power to immediately manage new additions to an IT environment. Tivoli Ready products help manage every element of an IT environment. For more information on Tivoli and Tivoli Ready products view the Tivoli Web site at:
DB2 UDB for OS/390, Version 6 is registered by IBM as Advanced ClusterProven. The IBM ClusterProven program introduces new high-availability requirements that may be applied to any combination of operating system, middleware, or end-user application. DB2 for OS/390 is a solution that satisfies the S/390® platform's technical criteria and has been registered to receive ClusterProven status. Specifically, DB2 has obtained the status of Advanced ClusterProven by providing significant benefits above those inherent at the ClusterProven level. More information on ClusterProven is available on the Web at:
Specified Operating Environment
Hardware Requirements: DB2 for OS/390, Version 6 operates on any processor that is supported by OS/390 Version 1 Release 3, or subsequent releases. The processor must have enough real storage to satisfy the combined requirements of:
OS/390 runs on the following hardware:
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.
In addition to listing auxiliary storage and data communications devices, this section identifies function-dependent hardware requirements and virtual storage requirements.
Auxiliary Storage: DB2 is independent of DASD and tape device type. You can use any magnetic, optical, or tape device that is supported by the data facilities component of DFSMS/MVS® for the DB2 data sets. If these data sets are on DASD shared with other OS/390 systems, you should use global resource serialization to prevent concurrent access by more than one OS/390 system.
The minimum DASD space requirement, based on installing DB2 using the panel default values, is approximately 600 MB. Users need additional DASD space for their data.
If you use dual logging and tape for the log archiving device, you need at least two tape drives.
For information about the data communication devices supported by IMS/ESA Transaction Manager, CICS, and TSO, refer to the documentation for these products.
Operating System and Support Programs: For an OS/390 environment, DB2 requires the function provided by the following licensed programs or their equivalents; subsequent versions or releases of any product are acceptable.
Function-Dependent Program Requirements: DB2 for OS/390 has the following function-specific program requirements. For specific software requirements for the required products, refer to the respective product announcements.
Optional Programs: You can use the following optional licensed programs with DB2 for OS/390, Version 6. Unless otherwise specified, the release shown for a product and any subsequent release are acceptable. In some cases, earlier versions or releases of IBM licensed programs may also work with DB2 for OS/390, but IBM may not have tested them at the time this document was published. If you have questions, check with your IBM representative.
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 when APAR PQ12390 and prior service is applied. 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.
Prerequisites of Features of DB2 UDB Server for OS/390: DB2 for OS/390, Version 6 includes many features, some of which have requirements of their own, above and beyond what DB2 for OS/390, Version 6 requires. This section identifies the requirements for using these features with DB2 for OS/390, Version 6, but it does not repeat those DB2 for OS/390 requirements that apply to the features. Also, some of these features can be used with prior releases of DB2; these requirements are not included in this section, but rather in the detailed installation information for the specific feature.
You can use subsequent versions or releases of the products mentioned in this section, unless otherwise noted.
Both environments require TCP/IP in any of the following circumstances:
If you don't have TCP/IP, you can use DB2 Installer to customize your installation jobs, but you need to use a method outside of DB2 Installer to move jobs from the workstation to OS/390 for execution.
In addition, DB2 Visual Explain requires one of the following communication protocols:
Visual Explain includes a browser that lets users view current values of subsystem parameters. To use this browser, your DB2 subsystem must have:
DB2 Estimator has no hardware requirements.
Net.Data Requirements: Net.Data for OS/390, Version 2 Release 2 requires an HTTP Web server that is installed on the same server as Net.Data and DB2 for OS/390. The Web server can be another HTTP-compliant Web server or one of the following servers:
In addition, Net.Data servlets have the following requirements:
Net.Data for OS/390 has no hardware requirements.
The DB2 PM Workstation-Based Online Monitor has the following dependencies:
Program Requirements: For the host-based Online Monitor and host-based graphics facility, DB2 PM has no functional dependencies if you are monitoring DB2 for OS/390, Version 6. The DB2 PM feature supports an environment of multiple DB2 releases, namely instrumentation, catalog, and PLAN_TABLE data from:
Refer to the software requirements for the specific version of DB2.
DB2: DB2 UDB for OS/390, Version 6 is upwardly compatible with prior releases of DB2 for OS/390 and DB2 for MVS/ESA. Successful migration with full fallback protection requires customers to migrate DB2 releases sequentially. Thus, existing customers should ensure they are successfully running on DB2 for OS/390, Version 5 before migrating to DB2 UDB for OS/390, Version 6.
User Group Requirements: This announcement satisfies or partially satisfies 142 requirements from one or more of the worldwide user group communities, which include Australasian SHARE/GUIDE (ASG), COMMON, COMMON Europe, GUIDE International, G.U.I.D.E. Europe, Japan GUIDE/SHARE (JGS), Guide Latin American (LAG), SHARE EUROPE, and SHARE Incorporated.
DB2 UDB for OS/390, Version 6 has support for migration from Version 5. Customers not yet on Version 5, should plan to migrate to DB2 for OS/390, Version 5 as preparation for a migration to Version 6.
Migration Considerations: IBM adds many universal database capabilities in DB2 UDB for OS/390, Version 6 and removes 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 6, refer to the DB2 UDB for OS/390, Version 6 Installation Guide (GC26-9018).
The QMF V3.3 Approach® 97 client available in Lotus® Approach 97 and SmartSuite® 97 is no longer supported. Approach can be accessed using the API of the QMF for Windows feature.
Direct Customer Support: Direct customer support is provided by S/390 Support Line. This service can enhance your productivity by providing voice and electronic access into the IBM support organization. S/390 Support Line will help answer questions pertaining to usage, how to, and suspected software defects for eligible products.
Installation and technical support is provided by IBM Global Services. For more information on services, call 800-IBM-4YOU (426-4968).
Also included will be a Program Directory, and under separate cover, one copy of the entitled publications.
The workstation client functions of DB2 Management Tools Package, DB2 Extenders, and Buffer Pool Tool will be shipped on CD-ROM.
The Workstation-Based Analysis and Tuning function will be shipped on the same media with the DB2 PM "Try" software.
Note: The components in QMF HPO Version 6 (QMF HPO/Manager and QMF HPO/Compiler) were available as QMF features that could be ordered separately in QMF Version 3.3. They are no longer available as separately ordered features in Version 6. QMF HPO/Complete is now simply called QMF HPO and includes the QMF HPO/Manager, QMF HPO/Compiler, and QMF for Windows as one comprehensive feature.
Security, Auditability, and Control
DB2 UDB for OS/390, Version 6 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 around the world. 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:
The following advance publications are available now. To order, contact your IBM representative.
Order Title Number DB2 UDB Server for OS/390, Version 6 GC26-9017 What's New DB2 UDB Server for OS/390, Version 6 SC26-9013 Release Planning Guide
A DB2 Performance Monitor presentation is available through:
Orders for new licenses can be placed now.
Shipment will begin on June 25, 1999.
New users of DB2 UDB Server for OS/390 should specify:
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.
Program ESL OTC(1) Description Number Feature DB2 UDB for OS/390 5645-DB2 3021 Optional Features: DB2 Administration Tool 3043 DB2 Buffer Pool Tool 3065 DB2 DataPropagator Apply 3087 DB2 DataPropagator Capture 3109 DB2 Performance Monitor 3131 QMF for OS/390 2028 QMF for Windows Feature of QMF 2954 (Requires QMF for OS/390) QMF HPO 2968 (Requires QMF for OS/390) QMF for Windows 2041 (without QMF for OS/390 Requirement)
ESL machines can be determined by referring to the IBM Entry End User/390 Attachment (Z125-4379).
Program NALC Description Number Feature DB2 UDB for OS/390 5645-DB2 2004 Optional Features: DB2 Performance Monitor 2015
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 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.
DB2 UDB for OS/390 (PSLC)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 3000 PSLC Base, 1 MSU 2 3001 PSLC Base, 2 MSUs 3 3002 PSLC Base, 3 MSUs 4 -- 45 3003 PSLC Level A, 1 MSU 3004 PSLC Level A, 42 MSUs 46 -- 175 3005 PSLC Level B, 1 MSU 3006 PSLC Level B, 10 MSUs 3007 PSLC Level B, 50 MSUs 176 -- 315 3008 PSLC Level C, 1 MSU 3009 PSLC Level C, 10 MSUs 3010 PSLC Level C, 50 MSUs 316 or more 3011 PSLC Level D, 1 MSU 3012 PSLC Level D, 50 MSUs NA 3013 PSLC NC Identifier
3002 quantity 1
3003 quantity 8
DB2 Administration Tool Feature (PSLC)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 3022 PSLC Base, 1 MSU 2 3023 PSLC Base, 2 MSUs 3 3024 PSLC Base, 3 MSUs 4 -- 45 3025 PSLC Level A, 1 MSU 3026 PSLC Level A, 42 MSUs 46 -- 175 3027 PSLC Level B, 1 MSU 3028 PSLC Level B, 10 MSUs 3029 PSLC Level B, 50 MSUs 176 -- 315 3030 PSLC Level C, 1 MSU 3031 PSLC Level C, 10 MSUs 3032 PSLC Level C, 50 MSUs 316 or more 3033 PSLC Level D, 1 MSU 3034 PSLC Level D, 50 MSUs NA 3035 PSLC NC Identifier
3024 quantity 1
3025 quantity 8
DB2 Buffer Pool Tool Feature (PSLC)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 3044 PSLC Base, 1 MSU 2 3045 PSLC Base, 2 MSUs 3 3046 PSLC Base, 3 MSUs 4 -- 45 3047 PSLC Level A, 1 MSU 3048 PSLC Level A, 42 MSUs 46 -- 175 3049 PSLC Level B, 1 MSU 3050 PSLC Level B, 10 MSUs 3051 PSLC Level B, 50 MSUs 176 -- 315 3052 PSLC Level C, 1 MSU 3053 PSLC Level C, 10 MSUs 3054 PSLC Level C, 50 MSUs 316 or more 1000 PSLC Level D, 1 MSU 1002 PSLC Level D, 50 MSUs NA 3057 PSLC NC Identifier
3046 quantity 1
3047 quantity 8
DB2 DataPropagator Apply Feature (PSLC)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 3066 PSLC Base, 1 MSU 2 3067 PSLC Base, 2 MSUs 3 3068 PSLC Base, 3 MSUs 4 -- 45 3069 PSLC Level A, 1 MSU 3070 PSLC Level A, 42 MSUs 46 -- 175 3071 PSLC Level B, 1 MSU 3072 PSLC Level B, 10 MSUs 3073 PSLC Level B, 50 MSUs 176 -- 315 3074 PSLC Level C, 1 MSU 3075 PSLC Level C, 10 MSUs 3076 PSLC Level C, 50 MSUs 316 or more 3077 PSLC Level D, 1 MSU 3078 PSLC Level D, 50 MSUs NA 3079 PSLC NC Identifier
3068 quantity 1
3069 quantity 8
DB2 DataPropagator Capture Feature (PSLC)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 3088 PSLC Base, 1 MSU 2 3089 PSLC Base, 2 MSUs 3 3090 PSLC Base, 3 MSUs 4 -- 45 3091 PSLC Level A, 1 MSU 3092 PSLC Level A, 42 MSUs 46 -- 175 3093 PSLC Level B, 1 MSU 3094 PSLC Level B, 10 MSUs 3095 PSLC Level B, 50 MSUs 176 -- 315 3096 PSLC Level C, 1 MSU 3097 PSLC Level C, 10 MSUs 3098 PSLC Level C, 50 MSUs 316 or more 3099 PSLC Level D, 1 MSU 3100 PSLC Level D, 50 MSUs NA 3101 PSLC NC Identifier
3090 quantity 1
3091 quantity 8
DB2 Performance Monitor Feature (PSLC)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 3110 PSLC Base, 1 MSU 2 3111 PSLC Base, 2 MSUs 3 3112 PSLC Base, 3 MSUs 4 -- 45 3113 PSLC Level A, 1 MSU 3114 PSLC Level A, 42 MSUs 46 -- 175 3115 PSLC Level B, 1 MSU 3116 PSLC Level B, 10 MSUs 3117 PSLC Level B, 50 MSUs 176 -- 315 3118 PSLC Level C, 1 MSU 3119 PSLC Level C, 10 MSUs 3120 PSLC Level C, 50 MSUs 316 or more 3121 PSLC Level D, 1 MSU 3122 PSLC Level D, 50 MSUs NA 3123 PSLC NC Identifier
3112 quantity 1
3113 quantity 8
QMF for OS/390 Feature (PSLC)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 2016 PSLC Base, 1 MSU 2 2017 PSLC Base, 2 MSUs 3 2018 PSLC Base, 3 MSUs 4 -- 45 2019 PSLC Level A, 1 MSU 2020 PSLC Level A, 42 MSUs 46 -- 175 2021 PSLC Level B, 1 MSU 2022 PSLC Level B, 10 MSUs 2023 PSLC Level B, 50 MSUs 176 -- 315 2024 PSLC Level C, 1 MSU 2025 PSLC Level C, 10 MSUs 2026 PSLC Level C, 50 MSUs 316 or more 1001 PSLC Level D, 1 MSU 1003 PSLC Level D, 50 MSUs NA 2027 PSLC NC Identifier
2018 quantity 1
2019 quantity 8
QMF for Windows Feature of QMF (PSLC)
(Requires QMF for OS/390)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 2942 PSLC Base, 1 MSU 2 2943 PSLC Base, 2 MSUs 3 2944 PSLC Base, 3 MSUs 4 -- 45 2945 PSLC Level A, 1 MSU 2946 PSLC Level A, 42 MSUs 46 -- 175 2947 PSLC Level B, 1 MSU 2948 PSLC Level B, 10 MSUs 2949 PSLC Level B, 50 MSUs 176 -- 315 2950 PSLC Level C, 1 MSU 2951 PSLC Level C, 10 MSUs 2952 PSLC Level C, 50 MSUs 316 or more 1006 PSLC Level D, 1 MSU 1007 PSLC Level D, 50 MSUs NA 2953 PSLC NC Identifier
2944 quantity 1
2945 quantity 8
QMF HPO Feature (PSLC): (Requires QMF for OS/390)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 2956 PSLC Base, 1 MSU 2 2957 PSLC Base, 2 MSUs 3 2958 PSLC Base, 3 MSUs 4 -- 45 2959 PSLC Level A, 1 MSU 2960 PSLC Level A, 42 MSUs 46 -- 175 2961 PSLC Level B, 1 MSU 2962 PSLC Level B, 10 MSUs 2963 PSLC Level B, 50 MSUs 176 -- 315 2964 PSLC Level C, 1 MSU 2965 PSLC Level C, 10 MSUs 2966 PSLC Level C, 50 MSUs 316 or more 1008 PSLC Level D, 1 MSU 1009 PSLC Level D, 50 MSUs NA 2967 PSLC NC Identifier
2958 quantity 1
2959 quantity 8
QMF for Windows Feature (PSLC): (Without QMF for OS/390 requirement)
PSLC PSLC Basic License Machine Feature MLC Feature MSU Capacity Number Description 1 2029 PSLC Base, 1 MSU 2 2030 PSLC Base, 2 MSUs 3 2031 PSLC Base, 3 MSUs 4 -- 45 2032 PSLC Level A, 1 MSU 2033 PSLC Level A, 42 MSUs 46 -- 175 2034 PSLC Level B, 1 MSU 2035 PSLC Level B, 10 MSUs 2036 PSLC Level B, 50 MSUs 176 -- 315 2037 PSLC Level C, 1 MSU 2038 PSLC Level C, 10 MSUs 2039 PSLC Level C, 50 MSUs 316 or more 1004 PSLC Level D, 1 MSU 1005 PSLC Level D, 50 MSUs NA 2040 PSLC NC Identifier
2029 quantity 1
2030 quantity 8
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 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 1 (if usage is below 0.25 MSU) Feature 2 (if usage is between 0.26 and 0.50) Feature 3 (if usage is between 0.51 and 1.0) Feature 3 + (number of MSUs from 2-11 times the charge associated with feature number 4) + (number of MSUs from 12-44 times the charge associated with feature number 5) + (number of MSUs above 44 times the charge associated with feature number 6 -- if applicable)
DB2 UDB for OS/390
Feature Description Number 0 to 0.25 MSU Base 3014 0.26 to 0.5 MSU Base 3015 0.51 to 1.0 MSU Base 3016 Level A Charge/MSU (2 to 11 MSUs) 3017 Level B Charge/MSU (12 to 44 MSUs) 3018 Level C Charge/MSU (45 to 78 MSUs) 3019 Level D Charge/MSU (above 78 MSUs) 2002 Level D Charge/50 MSUs (above 78 MSUs) 2003 NC Identifier Feature 3020
DB2 Administration Tool Feature
Feature Description Number 0 to 0.25 MSU Base 3036 0.26 to 0.5 MSU Base 3037 0.51 to 1.0 MSU Base 3038 Level A Charge/MSU (2 to 11 MSUs) 3039 Level B Charge/MSU (12 to 44 MSUs) 3040 Level C Charge/MSU (45 to 78 MSUs) 3041 Level D Charge/MSU (above 78 MSUs) 2005 Level D Charge/50 MSUs (above 78 MSUs) 2006 NC Identifier Feature 3042
DB2 DataPropagator Apply Feature
Feature Description Number 0 to 0.25 MSU Base 3080 0.26 to 0.5 MSU Base 3081 0.51 to 1.0 MSU Base 3082 Level A Charge/MSU (2 to 11 MSUs) 3083 Level B Charge/MSU (12 to 44 MSUs) 3084 Level C Charge/MSU (45 to 78 MSUs) 3085 Level D Charge/MSU (above 78 MSUs) 2007 Level D Charge/50 MSUs (above 78 MSUs) 2008 NC Identifier Feature 3086
DB2 DataPropagator Capture Feature
Feature Description Number 0 to 0.25 MSU Base 3102 0.26 to 0.5 MSU Base 3103 0.51 to 1.0 MSU Base 3104 Level A Charge/MSU (2 to 11 MSUs) 3105 Level B Charge/MSU (12 to 44 MSUs) 3106 Level C Charge/MSU (45 to 78 MSUs) 3107 Level D Charge/MSU (above 78 MSUs) 2009 Level D Charge/50 MSUs (above 78 MSUs) 2010 NC Identifier Feature 3108
DB2 Performance Monitor Feature
Feature Description Number 0 to 0.25 MSU Base 3124 0.26 to 0.5 MSU Base 3125 0.51 to 1.0 MSU Base 3126 Level A Charge/MSU (2 to 11 MSUs) 3127 Level B Charge/MSU (12 to 44 MSUs) 3128 Level C Charge/MSU (45 to 78 MSUs) 3129 Level D Charge/MSU (above 78 MSUs) 2013 Level D Charge/50 MSUs (above 78 MSUs) 2014 NC Identifier Feature 3130
Single Version Charging: To elect single version charging, the customer must notify and identify to IBM the prior program and replacement program and the designated machine the programs are operating on.
Version-to-Version Upgrade Credit: To upgrade from a prior program acquired for a one-time charge (OTC) to a replacement program using a version-to-version upgrade credit, the customer must notify and identify to IBM the applicable prior program and replacement program participating in the upgrade credit.
Feature Distribution Environment Number Medium DB2 UDB for OS/390, 5822 3480 Cartridge Version 6 (Includes "Try" 6270 4-mm DAT Cartridge for all "Try and Buy" 5821 9/6250 Magnetic Tape Features) DB2 Administration Tool 5892 3480 Cartridge "Buy" Feature 5514 4-mm DAT Cartridge 5851 9/6250 Magnetic Tape Feature Distribution Environment Number Medium DB2 Buffer Pool Tool 5963 3480 Cartridge "Buy" Feature 5047 4-mm DAT Cartridge 5740 9/6250 Magnetic Tape DB2 DataPropagator Apply 5802 3480 Cartridge "Buy" Feature 5701 4-mm DAT Cartridge 5801 9/6250 Magnetic Tape DB2 DataPropagator 5101 3480 Cartridge Capture "Buy" 5520 4-mm DAT Cartridge Feature 5891 9/6250 Magnetic Tape DB2 Performance Monitor 5832 3480 Cartridge "Buy" Feature 6280 4-mm DAT Cartridge 5831 9/6250 Magnetic Tape QMF for OS/390 5862 3480 Cartridge "Buy" Feature 5856 4-mm DAT Cartridge 5861 9/6250 Magnetic Tape QMF for Windows 5829 CD-ROM (Feature of QMF) "Buy" Feature QMF HPO 5852 3480 Cartridge (Feature of QMF) 5855 4-mm DAT Cartridge "Buy" Feature 5871 9/6250 Magnetic Tape QMF for Windows 5809 CD-ROM "Buy" Feature DB2 Management Tools 5950 3480 Cartridge Package (No-charge) 5530 4-mm DAT Cartridge Feature 5949 9/6250 Magnetic Tape Net.Data Version 2.2 5842 3480 Cartridge (No-charge) Feature 5505 4-mm DAT Cartridge 5841 9/6250 Magnetic Tape
Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.
Feature Description Number Initial Shipments Serial Number Only (suppresses shipment 3444 of media and documentation) Ship Media Only (suppresses initial 3470 shipment of documentation) Ship Documentation Only (suppresses 3471 initial shipment of media) Update Shipments Ship Media Updates Only (suppresses 3480 update shipment of documentation) Ship Documentation Only (suppresses 3481 update shipment of media) Suppress Updates (suppresses update 3482 shipment of media and documentation) Expedite Shipments Local IBM Office Expedite 3445 (for IBM use only) Customer Expedite Process Charge 3446 ($30 charge for each product)
Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Delivery and Fulfillment (SDF) receives the order. SDF will then ship the order via overnight air transportation.
Order Title Number DB2 UDB for OS/390, Version 6 GC26-9018 Installation Guide DB2 UDB for OS/390, Version 6 GC26-9003 Administration Guide DB2 UDB for OS/390, Version 6 GC26-9006 Command Reference DB2 UDB for OS/390, Version 6 GC26-9007 Data Sharing Planning and Administration DB2 UDB for OS/390, Version 6 GC26-9009 Licensed Program Specifications DB2 UDB for OS/390, Version 6 GC26-9011 Messages and Codes DB2 UDB for OS/390, Version 6 GC26-9014 SQL Reference DB2 UDB for OS/390, Version 6 GC26-9015 Utility Guide and Reference DB2 Administration Tool for OS/390, SC26-8947 Version 6, User's Guide DB2 Buffer Pool Tool for OS/390, SC26-9306 Version 6, User's Guide and Reference DB2 Performance Monitor Version 6 SC26-9167 Batch User's Guide DB2 Performance Monitor Version 6 SC26-9171 Installation and Customization DB2 Performance Monitor Version 6 SC26-9169 Messages DB2 Performance Monitor Version 6 SC26-9168 Online Monitor User's Guide DB2 Performance Monitor Version 6 SC26-9164 Report Reference, Volume 1 DB2 Performance Monitor Version 6 SC26-9165 Report Reference, Volume 2 DB2 Performance Monitor Version 6 SC26-9170 Using the Online Workstation Monitor QMF for OS/390, Version 6 GC26-9575 Installing and Managing QMF on OS/390 QMF for OS/390, Version 6 GC26-9576 Introducing QMF QMF for OS/390, Version 6 GC26-9580 Messages and Codes QMF for OS/390, Version 6 SC26-9577 QMF Reference Order Title Number QMF for OS/390, Version 6 SC26-9578 Using QMF QMF for OS/390, Version 6 SC26-9581 QMF HPO User's Guide QMF for Windows, Version 6 SC26-9582 Getting Started with QMF for Windows QMF for Windows, Version 6 GC26-9583 Installing and Managing QMF for Windows The following optional publications are available June 25, 1999: Order Title Number DB2 UDB for OS/390, Version 6 GC26-9018 Application Programming Guide and Reference for JAVA DB2 UDB for OS/390, Version 6 GC26-9004 Application Programming and SQL Guide DB2 UDB for OS/390, Version 6 SX26-3843 Data Sharing Quick Reference DB2 UDB for OS/390, Version 6 GC26-9010 Master Index DB2 UDB for OS/390, Version 6 GC26-9005 ODBC Guide and Reference DB2 UDB for OS/390, Version 6 GC26-9012 Reference for Remote DRDA Requestors and Servers DB2 UDB for OS/390, Version 6 SX26-3844 Reference Summary DB2 UDB for OS/390, Version 6 SC26-9650 Image, Audio, and Video Extenders Administration and Programming DB2 UDB for OS/390, Version 6 SC26-9650 Text Extender Administration and Programming DB2 UDB for OS/390, Version 6 GC26-9013 Release Guide DB2 UDB for OS/390, Version 6 GC26-9017 What's New? DB2 Performance Monitor Version 6 SC26-9166 Command Reference DB2 Performance Monitor Version 6 SC26-9172 General Information DB2 DataPropagator Version 6 SC26-9642 DB2 Replication Guide and Reference QMF for OS/390, Version 6 SC26-9579 Developing QMF Applications
Additional copies of unlicensed publications are available for a fee immediately. These copies may be ordered from your IBM representative, through the Publication Notification System (PNS), or by direct order.
All of the above DB2 UDB for OS/390 publications can be ordered using bill-of-forms number SBOF-7413.
All of the above DB2 Performance Monitor publications can be ordered using bill-of-forms number SBOF-7414.
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, Version 6 LY36-3736 8204 Diagnosis Guide and Reference DB2 UDB for OS/390, Version 6 LY36-3737 8203 Diagnostic Quick Reference Card
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.
IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries around the world. 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:
Terms and Conditions
Replaced Replacement Single Version Program Program Charging Applies DB2 Version 1 DB2 UDB Version 6 Yes (5740-XYR) (5645-DB2) DB2 Version 2 DB2 UDB Version 6 Yes (5665-DB2) (5645-DB2) DB2 Version 3 DB2 UDB Version 6 Yes (5685-DB2) (5645-DB2) DB2 Version 4 DB2 UDB Version 6 Yes (5695-DB2) (5645-DB2) DB2 Version 5 DB2 UDB Version 6 Yes (5655-DB2) (5645-DB2) DB2 Version 6 To a follow-on N/A (5645-DB2) program, if any.
DB2 Performance Monitor Feature
Replaced Replacement Single Version Program Program Charging Applies(2) DB2 PM Version 1 DB2 UDB Version 6 Yes (5665-354) (5645-DB2) DB2 PM Version 2 DB2 UDB Version 6 Yes (5685-140) (5645-DB2) DB2 PM Version 3 DB2 UDB Version 6 Yes (5655-047) (5645-DB2) DB2 PM Version 4 DB2 UDB Version 6 Yes (5655-102) (5645-DB2)
Replaced Replacement Single Version Program Program Charging Applies(2) QMF Version 1 DB2 UDB Version 6 Yes (5668-972) (5645-DB2) QMF Version 2 DB2 UDB Version 6 Yes (5668-721) (5645-DB2) QMF Version 3 DB2 UDB Version 6 Yes (5706-254) (5645-DB2)
QMF for Windows Feature
Replaced Replacement Single Version Program Program Charging Applies(2) QMF for Windows DB2 UDB Version 6 Yes (5697-D27) (5645-DB2)
DB2 DataPropagator Feature
Replaced Replacement Single Version Program Program Charging Applies(2) DataPropagator DB2 UDB Version 6 Yes Relational Apply (5645-DB2) for MVS, Version 1.2.1 (5622-267) DataPropagator DB2 UDB Version 6 Yes Relational Capture (5645-DB2) for MVS, Version 1.2.1 (5655-076) DataPropagator DB2 UDB Version 6 Yes Relational Apply (5645-DB2) for MVS, Version 5.1 (5655-A22) DataPropagator DB2 UDB Version 6 Yes Relational Capture (5645-DB2) for MVS, Version 5.1 (5655-A23)
DB2 Administration Tool Feature
Replaced Replacement Single Version Program Program Charging Applies(2) DB2 Administration DB2 UDB Version 6 Yes Tool Version 1 (5645-DB2) (5688-515)
DB2 Buffer Pool Tool Feature
Replaced Replacement Single Version Program Program Charging Applies(2) DB2 Buffer Pool DB2 UDB Version 6 Yes Tool Version 1 (5645-DB2) (5697-D16)
Try and Buy Program: The optional priced features of DB2 Universal Database Server for OS/390, Version 6 are shipped with each new order of DB2 UDB Server for OS/390 and are available for customer evaluation under a limited term trial license. The following priced features are included in the Try and Buy program:
These features may be installed and used on a trial basis for 90 days from the date of installation of the feature, except for the QMF for Windows Feature, which may be installed and used on a trial basis for 60 days from the date of installation. A full-use license for each of the above priced features may be obtained by ordering the appropriate billing feature number and media feature number, labeled as "Buy", for the optional priced feature. The trial version of these priced features contain time disabling devices that will prevent their use upon expiration of the trial period.
Call Now to Order
To order, contact the IBM Americas Call Centers, your local IBM representative, or your IBM Business Partner.
IBM Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.
Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org Mail: IBM Americas Call Centers Dept. LE001 P.O. Box 2690 Atlanta, GA 30301-2690 Reference: LE001
To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU.
Note: Shipments will begin after the planned availability date.