IBM DB2 UDB for z/OS, V8 delivers 64-bit virtual addressing
IBM United States Software Announcement 204-029March 2, 2004
 ENUS204-029.PDF (135KB)
|
At a glance(Corrected on June 17, 2004)
- Added text to Key Prerequisites section.
- Hardware requirements section -- revised text in first and second paragraphs under Processors heading.
- Software requirements section -- changed heading from Group Bufferpool (GBP) Caching z/OS to Group Bufferpool (GBP) Batching.
 |
| At a glance |
 |
DB2 UDB for z/OS, V8 delivers power, flexibility, and DB2 Family compatibility for e-business application leadership through synergy with zSeries and z/OS.
- Enhanced capacity through 64-bit virtual addressing for DB2 and Internal Resource Lock Manager (IRLM)
- Schema evolution for enhanced data availability
- DB2 Family compatible SQL for transaction processing
- Reengineered catalog including Unicode data format and long name support
- Major indexing and partitioning enhancements
- Major utility enhancements
DB2 QMF V8 delivers:
- OLAP with DB2 Cube Views
- Drag and drop queries and analytics
- Executive dashboards
- DB2 V8 long name and other support
- Enabled for WebSphere Application Server
- Simplified packaging for easier ordering
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at
800-IBM-CALL
(Reference: LE001).
Back to top
|
|
| Overview |
|
DB2 Universal Database® (UDB) for z/OS® continues to deliver rich function for scalable and
highly available data for your enterprise-scale e-business applications. Combine the power and
capacity of IBM 
zSeries®,
the high performance and high availability of the z/OS operating system, and this enriched version
of DB2® to expand and extend your applications in the increasingly competitive e-business
environment.
- 64-bit virtual addressing that exploits the capacity and processing power of zSeries servers and z/OS operating system
- Extensive enhancements to SQL
-
Usability and portability enhancements through major catalog changes:
- Improvements in long object names
- Unicode for worldwide support and improved SQL compatibility.
- DB2 family compatibility for portability of transaction applications from UNIX® and Microsoft™ Windows™ environments
- Enhanced data availability through online schema evolution
-
Database management flexibility with:
- Indexing enhancements
- Variable-length indexes
- Up to 4096 partitions and data partitioning for indexes
-
Utility enhancements:
- System-level point-in-time backup and recovery
- Automatic restart of utilities
- Greater DB2 family compatibility through support for load and unload with delimited data
-
DB2 Query Management Facility (QMF™) on demand feature, which includes:
- Support for DB2 UDB V8, including DB2 Cube Views, long names, Unicode, and enhancements to SQL
- Drag-and-drop building of OLAP analytics, SQL queries, pivot tables, and other business analysis and reports
- Visual data "appliances," such as executive dashboards, that offer unique, visually rich, interactive functionality and interfaces specific to virtually any type of information task
- Database explorer for easily browsing and identifying database assets and other objects they may reference
- QMF for WebSphere®, allowing ordinary Web browsers to become "zero maintenance" thin clients for visual on demand access to enterprise DB2 business data
With this release, DB2 QMF is offered in several simplified editions, enabling you to more easily apply its DB2 QMF on demand information strategy to single or multiple database and end-user platforms.
For more information and the most current news regarding DB2 UDB for z/OS, visit:
Back to top
|
|
| Key prerequisites |
|
- z/OS V1R3 Base Services (5694-A01), or later, executing in 64-bit addressing mode
- Any processor that supports z/Architecture™ with some limitations. Refer to the Technical information section for details on required microcode levels and zSeries emulation software.
Back to top
|
|
| Planned availability date |
|
March 26, 2004
Back to top
|
|
| Description |
|
DB2 UDB for z/OS, V8 is the most comprehensive and feature-rich version to date. With a major emphasis on 64-bit addressing, one of the keys to reengineering is breaking through the limits of the current architecture.
The use of 64-bit virtual addressing exploits the capacity and processing power of zSeries servers and the z/OS operating system. Increasing the amount of virtual storage that DB2 can address directly can help with scaling and simplifying the management of virtual storage.
Other major functions from backup and recovery to improved security and SQL enhancements are critical to your on-demand database environment.
Enhancements to system-level point-in-time recovery for DB2 provide improved usability, more flexibility, and faster recovery. You can now recover your data to any point in time, regardless of whether you have uncommitted units of work. As a result, data recovery time is reduced significantly for large DB2 systems that contain thousands of objects.
The new multilevel security feature in DB2 V8 delivers a secure single repository of data that can be accessed by people with different need-to-know authority. This secure access is managed down at the row level to provide the granularity that is required.
DB2 UDB for z/OS, V8 also includes dozens of changes in SQL, improving family consistency while pushing DB2 SQL beyond current boundaries for enhanced application portability.
DB2 incorporates a broad set of key open standards that gives your application access to standard computing industry solutions and methods. You can concentrate on your company's core competencies, while managing global market and competition changes with consistent availability, security, and privacy around the world and around the clock.
To raise productivity, lower business costs, and stay competitive, every organization needs on demand access to corporate data:
- Tailored to roles and responsibilities across the enterprise
-
Visualized in formats easiest to understand:
- On precisely the scale required
- To any user anywhere
All of these capabilities are delivered — rapidly, reliably, affordably, and flexibly — through IBM's on demand business information platform.
DB2 QMF
DB2 QMF Enterprise Edition: DB2 QMF Enterprise Edition provides the entire DB2 QMF family of technologies, enabling enterprise-wide business information across end-user and database platforms. DB2 QMF Enterprise Edition consists of these components:
- DB2 QMF for TSO/CICS®
- DB2 QMF High Performance Option (HPO)
- DB2 QMF for Windows
- DB2 QMF for WebSphere
- DB2 QMF Visionary Studio
Other editions of DB2 QMF offer subsets of QMF Enterprise Edition, as follows.
DB2 QMF Distributed Edition: DB2 QMF Distributed Edition provides components to support end users functioning entirely from Web or Windows clients to access enterprise databases. This edition consists of:
- DB2 QMF for Windows
- DB2 QMF for WebSphere
- DB2 QMF Visionary Studio
DB2 QMF Classic Edition: DB2 QMF Classic Edition supports end users functioning entirely from traditional mainframe terminals and emulators (including IBM Host On Demand) to access DB2 UDB databases. This edition consists of DB2 QMF for TSO/CICS.
DB2 Management Clients Package: With this release, the z/OS Enablement element of the DB2 Management Clients Package includes support for DB2 UDB for z/OS, V8, including long name support, 4096 partitions support, and 64-bit virtual support. It also supports MVS™ job administration and UNIX commands execution.
With this release, DB2 Administration Server (DAS) is offered as an element of the DB2 Management Clients Package. DAS is required by, and supports administrative tasks by the DB2 UDB Control Center and Replication Center.
z/OS Application Connectivity to DB2 for z/OS is a no-charge, optional feature of DB2 UDB Server for z/OS, V8. This feature consists of a component known as the DB2 UDB Driver for z/OS, Java™ Edition, a pure Java, type 4 JDBC driver designed to deliver high performance and scalable remote connectivity for Java-based enterprise applications on z/OS to a remote DB2 for z/OS database server. The driver:
- Supports JDBC 2.0 and 3.0 specification and JDK V1.4 to deliver the maximum flexibility and performance required for enterprise applications
- Delivers robust connectivity to the latest DB2 for z/OS and WebSphere Application Server for z/OS
- Provides support for distributed transaction support
- Allows custom Java applications that don't require an application server to run in a remote partition and connect to DB2 z/OS
Ideal for z/OS customers who require the ultimate scalable and reliable DB2 connectivity solution anchored on a WebSphere Application Server framework. DB2 Universal Driver, Java Edition is an integral part of an e-business solution stack that can help achieve the highest level of Web application availability by leveraging the most durable OLTP platform.
Accessibility by people with disabilities
The following features support use by people with disabilities:
- Operation by keyboard alone
- Optional font enlargement and high-contrast display settings
- Screen readers and screen magnifiers tested for use by people with visual impairment
- Speech recognition products tested for use by people with mobility impairment
- Optional display of alerts for people with hearing impairment
Back to top
|
|
| Hardware and software support services |
|
SmoothStart™/installation services
SmoothStart Services, an on-site implementation and training startup service, is designed to accelerate your productive use of your IBM solution. The service is provided by IBM Global Services or your IBM Business Partner at an additional cost. For additional information, refer to Services Announcement 697-004 , dated March 25, 1997, or contact your IBM representative and ask for SmoothStart Services for DB2 UDB for z/OS, V8.
IBM Installation Services are provided for DB2 UDB for z/OS, V8 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 z/OS, V8.
Trademarks
Back to top
|
|
| Education support |
|
Call IBM Education and Training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and
enrollments.
Back to top
|
|
| Technical information |
|
Hardware requirements
Processors
DB2® UDB for z/OS®, V8 operates on any processor that supports z/Architecture™, including z800, z890, z900, z990, or comparable processor, with some limitations. For z900 systems, microcode level 3G or later is required. For emulation packages or other comparable processors, the Long Displacement Facility of the z/Architecture must be available. For further information about determining or updating your microcode level, search for the word microcode from the Technotes (FAQs) link on the DB2 UDB for z/OS Support Web page at
The processor must have enough real storage to satisfy the combined requirements of DB2, z/OS, and other user-required applications.In addition, 64-bit virtual addressing support will probably require increased real storage for a workload compared to DB2 for z/OS and OS/390®, V7.
The requirement for 64-bit addressing means that z/OS Bimodal Migration Accommodation software cannot be used with DB2 UDB for z/OS, V8.
The configuration must include sufficient I/O devices to support the requirements for system output, system residence, and system data sets. Sufficient disk storage must be available to satisfy the users' 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 UDB for z/OS is independent of both disk and tape device type. You can use any magnetic, optical, or tape device that is supported by the data facilities component of z/OS for the DB2 data sets.
The following DB2 data set types are supported by the following device types:
- Active recovery log data sets: disk
- Archive recovery log data sets: disk, tape
- Image copy data sets: disk, tape
- Bootstrap data sets: disk
- User data sets: disk
- DB2 catalog data sets: disk
- Work data sets (for utilities): disk, tape
If these data sets are on disk that is shared with other z/OS systems, use global resource serialization to prevent concurrent access by more than one z/OS system.
The minimum disk space requirement, based on installing DB2 using the panel default values, is approximately 1 GB. Users need additional disk space for their 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:
- System console
- Authorized IMS™ Transaction Manager terminals
- Authorized CICS® terminals
- TSO terminals (by authorized users)
For information about the data communication devices supported by IMS Transaction Manager, CICS, and TSO, refer to the documentation for these products.
Function-dependent hardware requirements
DRDA® data stream encryption has the following hardware requirements:
- Built-in functions for encryption and decryption require cryptographic hardware in a Cryptographic Coprocessor, Cryptographic Accelerator, or Cryptographic instructions.
- DRDA data stream encryption can optionally use cryptographic hardware in a Cryptographic Coprocessor, Cryptographic Accelerator, or Cryptographic instructions.
Software requirements
This section lists licensed programs, or specific elements and features of licensed programs, that are required in the DB2 UDB for z/OS, V8 environment. You can use subsequent versions or releases of the programs, unless stated otherwise. This section also identifies the requirements that are associated with specific DB2 capabilities as well as optional programs that you can use with DB2 UDB for z/OS, V8. Refer to the following Web sites for the most current information:
-
http://www.ibm.com/software/data/db2/os390/availsum.html
http://www.ibm.com/support/docview.wss?rs=71&org=SW&doc=1039854
http://www.ibm.com/servers/eserver/zseries/zos/support/zos_eos_dates.htm
Operating system and support programs
DB2 UDB for z/OS, V8 requires the function provided by the following licensed programs or their equivalents; subsequent versions or releases are acceptable.
-
z/OS V1.3 Base Services (5694-A01) or z/OS.e (5655-G52) plus APARs
OW56073, OW56074, OA03519, and OA03095 with the following base and
optional elements:
- DFSMS V1.3
- Language Environment®
- z/OS V1.3 Security Server (RACF®)
-
IRLM V2.2
If DB2 is installed with IRLM into the same SMP zone as any Version of IMS with IRLM V2.1, IRLM V2.1 will be deleted during the SMP/E installation of IRLM V2.2.
Notes
- z/OS Unicode Services and appropriate conversion definitions are required.
- Some of the basic operation of a DBMS is provided by utility functions, such as backup, recovery, reorganization, loading and unloading data, gathering statistics and checking data, indexes, and large objects. Customers should ensure that these functions are provided either by ordering DB2 Utilities Suite for z/OS, V8 (5655-K61), or by obtaining equivalent function elsewhere.
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.
Function-dependent program requirements
The following functions of DB2 require specific licensed programs, or features of licensed programs, before they can be used:
-
Application execution:
Applications written in high-level programming languages, such as applications or stored procedures written in the C language and using the ODBC or CLI interfaces to DB2, require the Language Environment element of z/OS at run time. Applications or stored procedures written in Java™, such as those using the JDBC or SQLJ interfaces to DB2, require IBM Developer Kit for OS/390, Java 2 Technology Edition (5655-D35) at run time.
-
Extenders:
- Audio, Image, and Video Extenders: Use of these extenders requires Language Environment. Audio, Image, and Video Extenders have been stabilized at the V7 level and are provided in DB2 for z/OS, V8, to ensure continuity for current customers. Audio, Image, and Video Extenders do not support the DB2 for z/OS data sharing function in a Parallel Sysplex® environment. For the most current information, visit
- XML Extender: Use of the XML Extender requires Language Environment and the IBM XML Parser for z/OS, C++ Edition, to be available at run time. The required parser is provided with the XML Toolkit for z/OS and OS/390 (5655-D44). At general availability of DB2 UDB for z/OS, V8, the required level is Release 4, but subsequent service may require a later level. Use of either the XML File type or the "Getting Started" material requires the z/OS UNIX® System Services element of z/OS.
- DB2 Text Extender: DB2 Text Extender has been stabilized at the V7 level and is provided in DB2 for z/OS, V8, to ensure continuity for current customers. DB2 Text Extender does not support the DB2 for z/OS data sharing function in a Parallel Sysplex environment. For the most current information, visit
- Net Search Extender: Net Search Extender V7 is compatible and delivered with DB2 for z/OS, V8. Net Search Extender does not support the DB2 for z/OS data sharing function in a Parallel Sysplex environment. For the most current information, visit
Operational support: The following programs provide operational support for DB2 specifically:
-
DFSMS features, part of the Systems Management optional feature of z/OS:
- DFSMShsm™ for archiving
- DFSMSdss™ for concurrent copy in Utilities
- IBM Softcopy Reader or Library Readers, included on the CD-ROMs for BookManager® books
-
IBM Tools for Replication Management and Database Recovery
-
The IBM Tools for Replication Management, including the following tools:
- DB2 DataPropagator™ for z/OS V8 (5655-I60)
- IBM IMS DataPropagator for z/OS V3 (5655-E52)
-
The IBM Tools for Database Recovery, including the following tools
- IBM Application Recovery Tool for IMS and DB2 Databases V1.2 (5697-F56)
- DB2 Archive Log Accelerator for z/OS, V2.1 (5697-I73)
- DB2 Change Accumulation Tool for z/OS, V1.3 (5655-F55)
- DB2 Object Restore for z/OS, V2.1 (5697-I20)
- DB2 Log Analysis Tool for z/OS, V2.1 (5655-E56)
- DB2 Recovery Expert for Multiplatforms V1 (5724-B91)
-
The IBM Tools for Replication Management, including the following tools:
-
Database Application Management: The following tools support database
application development for DB2:
- DB2 Information Integrator Classic Federation for z/OS V8 (5697-I82)
- DB2 Data Archive Expert for z/OS V1 (5655-I95)
- DB2 Bind Manager for z/OS V2.2 (5655-E43)
- DB2 Web Query Tool for z/OS V1.3 (5655-E71)
- DB2 Web Query Tool for Multiplatforms V1.3 (5724-B34)
- DB2 Test Database Generator for z/OS V2 (5697-I02)
- DB2 Path Checker for z/OS V2.1 (5697-I23)
- DB2 Table Editor for z/OS V4.3 (5697-G65)
- DB2 Table Editor for Multiplatforms V4.3 (5724-B33)
- DB2 Table Editor for Workgroups 4.3 (5724-E55)
-
Database Administration and Systems Management Support: The IBM Tools
for Database Administration and Systems Management include the following
tools:
-
The IBM Tools for Database Administration
- DB2 Administration Tool for z/OS V5.1 (5697-K90)
- DB2 Object Comparison Tool for z/OS V3.1 (5697-K40)
-
The IBM Tools for Utilities Management
- DB2 Automation Tool for z/OS V1.3 (5697-G63)
- DB2 Utilities Suite for z/OS V8 (5655-K61)
- DB2 High Performance Unload for z/OS V2 (5655-I19)
- DB2 High Performance Unload for Multiplatforms V2 (5724-B90)
- DB2 High Performance Unload for Workgroups V2 (5724-E56)
-
The IBM Tools for Database Performance Management, including the
following tools:
- DB2 Performance Expert for z/OS V2 (5655-J49)
- DB2 Performance Monitor for z/OS V8 (5655-J50)
- DB2 Buffer Pool Analyzer for z/OS V2.1 (5697-H82)
- DB2 SQL Performance Analyzer for z/OS V2 (5655-I22)
- DB2 Query Monitor for z/OS V1.1 (5655-E67)
-
The IBM Tools for Database Administration
For further information about all of the DB2 and IMS Tools products, visit
For the most recent news about DB2 Tools compatibility with DB2 UDB for z/OS, V8, visit the DB2 and IMS Tools Web site at
Information you will find on this page includes a compatibility matrix with notes regarding any required service.
The DB2 Management Clients Package, a feature of DB2 UDB for z/OS, V8 that includes:
- DB2 Administration Server (DAS) (z/OS installable component)
- z/OS Enablement (z/OS installable component)
- DB2 for z/OS Visual Explain (workstation CD or Web download) at
-
DB2 Connect® Personal Edition Kit (workstation CD), which includes:
- Control Center
- Development Center
- Replication Center
- Command Center
A restricted-use copy of DB2 Connect Personal Edition V8.1 (5724-B56) for Windows™ is provided in the DB2 Management Clients Package feature of DB2 UDB for z/OS, V8.
Optional program requirements
The following functions are enabled in conjunction with the specified optional licensed programs when used together with DB2.
DRDA connectivity: DB2 UDB for z/OS, V8 supports the following editions of IBM relational database products:
-
DB2 UDB for Linux, UNIX, Windows V8
- DB2 Enterprise Server Edition (ESE) V8.1 (5765-F41)
- DB2 Workgroup Server Edition V8.1 (5765-F35)
- DB2 Workgroup Server Unlimited Edition V8.1 (5765-F43)
- DB2 UDB Universal Developer's Edition V8.1 (5765-F34)
-
DB2 UDB for Linux, UNIX, Windows V7
- DB2 Universal Developer's Edition (5648-D37)
- DB2 Enterprise Edition (5648-D48)
- DB2 Enterprise Extended Edition (5648-D50)
- DB2 UDB Workgroup Edition (5648-D46)
- DB2 Workgroup Unlimited Edition (5648-D46)
-
DB2 UDB for iSeries™ OS/400® V5.1 or V5.2 (5722-SS1) (Info APAR
II13348)
- DB2 DataPropagator for iSeries V8.1 (5722-DP4)
- DB2 Query Manager and SQL Development Kit for iSeries (5722-ST1)
- DB2 Server for VSE & VM V7 (5697-F42)
- Any other DRDA-compliant client or relational DBMS server
Web connectivity: The following products provide connectivity to DB2 for z/OS, V8 from the Web:
- WebSphere® Application Server V5 (5655-I35)
- WebSphere Application Server V4 (5655-F31)
-
DB2 Connect V8 or V7.2
-
DB2 Connect Personal Edition (CPE) V8.1 (5724-B56)
DB2 Connect Personal Edition (CPE) V8.1.4 (also known as Fixpack 4) is the recommended level to use with DB2 for z/OS, V8. For DB2 Connect support services, visit
- DB2 Connect Enterprise Edition (CEE) V8 (5765-F30)
- DB2 Connect Unlimited Edition (CUE) V8 (5724-B62)
- DB2 Connect Application Server Edition (CASE) V8 (5724-D54)
- DB2 Connect Personal Edition, V7.2 (5648-D40)
- DB2 Connect Enterprise Edition, V7.2 (5648-D42)
-
DB2 Connect Personal Edition (CPE) V8.1 (5724-B56)
- Net.Data® for z/OS V7, a feature of DB2 UDB for z/OS, V8
Capacity planning: DB2 Estimator for Windows works with DB2 data to estimate application feasibility, to model application cost and performance, and to estimate required CPU and I/O capacity. DB2 Estimator is available to download from the DB2 for z/OS Web page.
For more information on DB2 Estimator for Windows, visit
Transaction management: The following transaction management products work with DB2:
-
Information Management System (IMS)
- IMS V9 (5655-J38)
- IMS V8 (5655-C56)
- IMS V7 (5655-B01)
-
Customer Information Control System (CICS)
- CICS Transaction Server for z/OS V2.2 or V2.3 (5697-E93),
- CICS Transaction Server for OS/390 V1.3 (5655-147)
- WebSphere MQSeries® for OS/390: WebSphere MQSeries for OS/390 V5.2 (5655-F10)
-
Application environments that use DB2 Connect to access DB2 remotely can
use the following transaction manager products:
- WebSphere Application Server
- TXSeries™ (CICS Transaction Server and Encina®)
- WebSphere MQ
- Microsoft™ Transaction Server (MTS)
- Java applications that support Java Transaction API (JTA) and Java 2 Enterprise Edition (J2EE)
- BEA (Tuxedo and WebLogic)
Query support: The following query programs work with DB2:
-
The DB2 QMF™ family, which are features of DB2 UDB for z/OS, V8
includes:
- DB2 QMF Enterprise Edition
- DB2 QMF Distributed Edition
- DB2 QMF Classic Edition
The components include:
- DB2 QMF for TSO/CICS
- DB2 QMF HPO
- DB2 QMF for WebSphere
- DB2 QMF for Windows
- DB2 QMF Visionary Studio
DB2 QMF Enterprise Edition includes all the components. Other editions of DB2 QMF offer subsets of QMF Enterprise Edition, as follows.
-
DB2 QMF Distributed Edition:
DB2 QMF Distributed Edition provides components to support end users functioning entirely from Web or Windows clients to access enterprise databases. This edition consists of:
- DB2 QMF for Windows
- DB2 QMF for WebSphere
- DB2 QMF Visionary Studio
-
DB2 QMF Classic Edition:
DB2 QMF Classic Edition supports end users functioning entirely from traditional mainframe terminals and emulators (including IBM Host On Demand) to access DB2 UDB databases. This edition consists of DB2 QMF for TSO/CICS.
DB2 Extenders®: DB2 Extenders for Net Search Extender, Text, Audio, Video, Image, and XML, extend the native DB2 for z/OS SQL capabilities.
Data warehouse support: DB2 Warehouse Manager for z/OS V8 (5655-I61) provides warehouse management for DB2.
Application development tools and programming languages: The DB2 Development Center, which is part of the Software Developer's Kit (SDK) on Windows, AIX®, and Solaris, is delivered with all editions of DB2 UDB and DB2 Connect products.
DB2 Development Center provides a graphical application that supports rapid development and deployment of DB2 Stored Procedures.
The following application development tools and programming languages work with DB2:
- Assembler: High Level Assembler, part of the System Services element of z/OS
-
C/C++:
-
Any of the following:
- C/C++ (with or without Debug Tool), optional feature of z/OS
- SAA® AD/Cycle® C/370™ Compiler V1.2 (5688-216)
DB2 UDB for z/OS V8 does not yet support the coprocessor or Precompiler Services with C or C++. Use of DB2 Precompiler Services with C requires the DB2 Coprocessor provided with z/OS V1.5 and the DB2 UDB for z/OS and OS/390 V7 libraries. For use of DB2 UDB for z/OS V8 function, use the precompiler as an alternative.
-
Any of the following:
-
COBOL: To exploit the DB2 V8 new functions, applications written in
COBOL must be compiled with one of the following combinations:
-
Using the separate DB2 precompiler, any supported COBOL compiler,
including:
- Enterprise COBOL for z/OS and OS/390 V3.2 (5655-G53)
- COBOL for OS/390 & VM V2.2 (5648-A25)
- Using the integrated SQL coprocessor, Enterprise COBOL for z/OS and OS/390 V3.2 or V3.3 (5655-G53) with APAR PQ83744
-
Using the separate DB2 precompiler, any supported COBOL compiler,
including:
- Fortran: VS Fortran V2.6 (5668-806, 5688-087, or 5668-805)
- Java: Applications or stored procedures written in Java, such as those using the JDBC or SQLJ interfaces to DB2, require IBM Developer Kit for OS/390, Java 2 Technology Edition (5655-D35) at run time
-
WebSphere: WebSphere Studio Enterprise Developer V5 (5724-B67)
Program requirements
- IBM SDK for z/OS, Java 2 Technology Edition, V1.4 (5655-I56) with APAR PQ74985 (the same as V1.4.1, which is the recommended level)
- IBM SDK for z/OS, Java 2 Technology Edition, V1.3.1. For more information on Java 2 for z/OS including a link to software prerequisites, visit
-
PL/I
-
Any of the following:
- IBM Enterprise PL/I for z/OS and OS/390 V3.2 (5655-H31)
- IBM PL/I for MVS™ & VM V1.1 (5688-235)
Use of the DB2 Precompiler Services requires the DB2 Coprocessor provided with IBM Enterprise PL/I for z/OS and OS/390 V3.2 and APAR PQ84513 or later releases.
-
Any of the following:
- REXX: IBM TSO/E REXX, which is part of z/OS
-
SQL Procedure Language: A C language compiler is required on z/OS to
develop stored procedures using the SQL procedures language. Specific C
compilers include:
- C/C++ (with or without Debug Tool), optional feature of z/OS
-
IBM SAA AD/Cycle C/370 Compiler, V1.2 (5688-216)
Restriction: This compiler is not supported for SQL procedures that are used with the SQL Debugger.
Requirements for dependent functions of DB2: DB2 UDB for z/OS, V8 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 z/OS, V8.
Recommendation: Before using these features, refer to the installation information for these features to ensure you have all required and recommended products.
System-level point-in-time backup and recovery
- z/OS V1.5
- DFSMShsm
- DFSMSdss
- FlashCopy® V1 (FlashCopy V2 is recommended)
- RESTORE SYSTEM LOGONLY option has no dependency on z/OS V1.5
Multilevel security with row granularity
- z/OS V1.5
- z/OS V1.5 Security Server (RACF)
- RACF Access Control Module required for multilevel security on objects other than rows
Encryption and decryption functions
Built-in functions for encryption and decryption require z/OS Cryptographic Services Integrated Cryptographic Service Facility (ICSF).
Group Bufferpool (GBP) Batching z/OS
- z/OS V1.4
- Coupling Facility (CF) level 12
More secure port of entry mechanism
- z/OS V1.5
TCP/IP performance
TCP/IP performance is improved when running on z/OS V1.5
DRDA Data Stream Encryption
DRDA Data Stream Encryption can optionally use z/OS Cryptographic Services Integrated Cryptographic Services Facility (ICSF).
Managed System Infrastructure for Setup DB2 Customization Center is enabled for the IBM Managed System Infrastructure (msys). The DB2 Customization Center provides installation customization for DB2 UDB for z/OS, V8. DB2 Customization Center is available as a plug-in for msys for Setup and, therefore, requires msys for Setup, which is included with z/OS, V1.4. Msys for Setup is a base element of z/OS. The prerequisite for DB2 Customization Center is PTF OA04581. This is not a prerequisite for installing msys. This PTF is required when running the DB2 Customization Center.
In addition, msys for Setup has three components:
- Msys workplace code, which runs on the workstation and provides the user with a Windows Explorer-style GUI to manage z/OS products. The workplace code has to be downloaded from the z/OS host.
- Msys host program which runs on a driving system that manages all installation/customization tasks.
- Msys management directory, which uses an LDAP server to store the configuration data for all msys-enabled products.
Visual Explain is an element of the DB2 Management Clients Package, which is a feature of DB2 UDB for z/OS, V8.
Hardware requirements
Visual Explain requires:
- Workstation capable of running Windows
- Monitor capable of displaying 1024 x 768 resolution
- Approximately 100 MB of disk space
- 256 MB memory, or greater
Software requirements: Visual Explain can run in either of the following environments:
- Microsoft Windows 2000, Windows XP, or Windows NT™ V4.0 (Service Pack 6, or later)
- DB2 Connect V7.2, or later
Visual Explain includes a browser that lets you view current values of subsystem parameters. To use this browser, your DB2 for z/OS subsystem must have the DSNWZP stored procedure enabled.
Net.Data: Net.Data V7, a feature of DB2 UDB for z/OS, V8, has the following software requirements:
Net.Data requires an HTTP server to be installed on the same server as Net.Data. To configure Net.Data to execute as a servlet, the following additional product is required:
WebSphere Application Server for z/OS and OS/390 V4 (5655-F31)
DB2 QMF
DB2 QMF for TSO/CICS, DB2 QMF HPO, DB2 QMF for WebSphere, DB2 QMF for Windows, DB2 QMF for Visionary Studio , all of which are components of the DB2 QMF family.
DB2 QMF components of DB2 UDB for z/OS, V8
-
DB2 QMF for TSO/CICS
Hardware requirements: A display station supported by Graphical Data Display Manager (GDDM®)
Software requirements: Requirements to run DB2 UDB for z/OS, V8
-
DB2 QMF High Performance Option (HPO)
Hardware requirements: A display station that is supported by ISPF
-
DB2 QMF for WebSphere
Hardware requirements: 230 MB hard disk space (multilingual installation)
Software requirements:
- WebSphere Application Server (WAS) 4.0, or later, on any platform supported by WAS.
-
One of the following Web browsers (with JavaScript support enabled) on each user machine:
- Microsoft Internet Explorer, V5.5, or later
- Netscape Navigator, V6.2, or later
- Client support from one of the following DB2 products on the WebSphere Application Server machine, depending on the platform:
Platform and DB2 client Version DB2 UDB for z/OS 8 DB2 UDB for z/OS and OS/390 7 DB2 UDB for iSeries 5.2, 5.1 DB2 UDB for Linux, UNIX, and 8.1, 7.2 Windows
DB2 QMF for WebSphere supports the following DB2 servers:
Product Version DB2 UDB for z/OS 8 DB2 UDB for z/OS and OS/390 7 DB2 UDB Server for OS/390 6 DB2 Server for VSE & VM 7.3, 7.2, 7.1 DB2 UDB for iSeries 5.2, 5.1 DB2 UDB for Linux, UNIX, and 8.1, 7.2 Windows
The following DB2 QMF for WebSphere functions have software dependencies:
- DB2 IM Scoring functions that are performed through the DB2 QMF for WebSphere Expression Builder require the DB2 IM Scoring (V7.1) feature of DB2 UDB EE or EEE, V7.2 (5724-A60) or DB2 UDB Enterprise Server Edition, V8.1 (5724-B93).
- DB2 QMF for WebSphere OLAP support requires DB2 Cube Views, V8.1 or later, on the DB2 server that is accessed.
-
DB2 QMF for Windows
Hardware requirements:
-
DB2 QMF for Windows requires a workstation that supports:
- A windows 32-bit operating system
- Network connectivity
- Approximately 70 MB of disk space (single language installation)
- Minimum of 128 MB of RAM
Software requirements: Database client access requires at least one of the following communication products or drivers on each user machine:
- A TCP/IP product that provides a WinSock, V1.1 interface
- An SNA product that provides a CPI-C interface
- The DB2 UDB for Windows Runtime Client, V8.1 or V7.2
- One or more ODBC 2.x or 3.x drivers
-
DB2 QMF for Windows, V8, runs on any of the following operating systems:
- Microsoft Windows 98
- Microsoft Windows ME
- Microsoft Windows NT 4.0 SP6a
- Microsoft Windows 2000
- Microsoft Windows XP
- Microsoft Windows Server 2003
DB2 QMF for Windows supports the following DB2 servers:
Product Version DB2 UDB Server for z/OS 8 DB2 UDB Server for z/OS and OS/390 7 DB2 UDB Server for OS/390 6 DB2 Server for VSE & VM 7.3, 7.2, 7.1 DB2 UDB for iSeries 5.1, 5.2 DB2 UDB for Linux, UNIX, and 7.2, 8.1 Windows
The following DB2 QMF for Windows functions have software dependencies:
-
IBM Object REXX Interpreter Edition V2.1 (5639-M69), or later, is required for the following DB2 QMF
for Windows functions:
- Procedures with logic
- @IF REXX function
- The DB2 QMF for Windows Spatial Viewer requires DB2 Spatial Extender EE or EEE V7.2 with Fixpack 5 or DB2 Spatial Extender V8.1
- Performing DB2 IM Scoring functions via the DB2 QMF for Windows Expression Builder requires DB2 IM Scoring V7.1 feature of DB2 EE or EEE V7.2 (5724-A60) or DB2 Enterprise Server Edition V8.1 (5724-B93)
- Use of DB2 QMF for Windows with natural language queries requires English Wizard 3.1 or EasyAsk 6.0 from IBM Business Partner Linguistic Technologies
- DB2 QMF for Windows OLAP support requires DB2 Cube Views, V8.1, or later, on the DB2 server that is accessed
-
Use of spreadsheet application add-ins with DB2 QMF for Windows requires one or both of:
- Microsoft Excel 7.0, or later
- Lotus® 1-2-3® Millennium Edition, or later
-
Use of charting in spreadsheet applications with DB2 QMF for Windows requires one or both of:
- Microsoft Excel 97, or later
- Lotus 1-2-3 Millennium Edition, or later
-
DB2 QMF for Windows requires a workstation that supports:
-
DB2 QMF Visionary Studio:
DB2 QMF Visionary Studio has the following client software dependencies:
-
The DB2 QMF Visionary Developer package has the following minimum system requirements:
- 64 MB of RAM
- 30 MB of disk space (English installation only); 100 MB of disk space are required for developing Visionary worlds that include image and audio content.
- A Pentium™ processor
-
The DB2 QMF Visionary Developer package requires one of the following operating systems:
- Windows 98
- Windows ME
- Windows NT Workstation 4.0 (SP4 or later)
- Windows NT Server 4.0 (SP4 or later)
- Windows 2000, Professional or Server
- Windows XP, Professional or Home Edition
- Windows 2003 Server, all editions
-
V8 of DB2 QMF Visionary Studio supports any of the following DB2 servers:
- DB2 UDB Server for z/OS, V8
- DB2 UDB Server for z/OS and OS/390, V7
- DB2 UDB Server for OS/390, V6
- DB2 Server for VSE & VM, V 7.3, 7.2, and 7.1
- DB2 UDB for iSeries, V5.2 and V5.1
- DB2 UDB for Linux, UNIX and Windows, V8.1 and V7.2
-
In addition, the DB2 QMF Visionary Developer package requires the following software:
- ODBC, V3.510.4202.0, or later
- ODBC Data Source Administrator
- DB2 UDB for Windows Runtime Client, Versions 8.1 or 7.2, for all DB2 database servers that are accessed by Visionary worlds
- Suitable ODBC drivers for all other (non-DB2) database servers that are accessed by Visionary worlds
In addition to the supported DB2 servers, DB2 QMF Visionary Studio supports data access to the following database systems:
- Red Brick™ Decision Server, V5.1.7, and later
- Informix™ Dynamic Server 2000
- Informix Dynamic Server with Universal Data Option, V9.x, and later
- Informix Extended Parallel Server, V8.3, and later
- Informix-OnLine Dynamic Server, V7.3, and later
- Microsoft Access 2000, and later
- Microsoft SQL Server 7.0, and later
- Oracle 7, 8i, 9i, and later
-
The DB2 QMF Visionary Developer package has the following minimum system requirements:
Limited-use license for z/OS Application Connectivity to V8 of DB2 UDB for z/OS: The no-charge z/OS Application Connectivity to DB2 feature, a Type 4 JDBC driver, is licensed for installation and use solely on z/OS. You are authorized to use z/OS Application Connectivity to DB2 only to run an application on z/OS. The application can connect to a DB2 UDB for OS/390 and z/OS, V7 subsystem or DB2 UDB for z/OS, V8 subsystem. The subsystem must reside on a different z/OS logical partition on the same z/OS server or on a different z/OS server. You can also connect applications to a subsequent supported version of DB2 UDB for z/OS or, with limitations, V6 of DB2 UDB Server for OS/390. Authorized use does not extend to applications that run on Linux for zSeries or any other platform or operating system.
The z/OS Application Connectivity to DB2 feature can only be ordered for V7 of DB2 UDB for z/OS and OS/390 or V8 of DB2 UDB for z/OS. If you also have V6 of DB2 UDB for OS/390 in your enterprise, you can use the V7 or V8 feature to access data in V6 of DB2 UDB for OS/390, but certain technical limitations apply. For example, XA two-phase commit functionality is not supported. In addition, you cannot install this feature on your V6 system. For any other connectivity to DB2 UDB for z/OS, you must obtain a separate license from IBM for the edition of DB2 Connect that is appropriate for your environment.
z/OS Application Connectivity Software Requirements: z/OS Application Connectivity feature has a dependency on IBM JDK 1.3.1, or later, available as Java for OS/390 (5655-A46).
Limited-use license for DB2 Connect: A restricted-use copy of V8.1 of DB2 Connect Personal Edition for Windows (5724-B56) is provided in the DB2 Management Clients Package feature of V8 of DB2 UDB for z/OS. You are authorized to use this copy of DB2 Connect to enable access to DB2 UDB for z/OS data by the following workstation tools only:
- DB2 UDB Control Center
- DB2 Replication Center
- DB2 Development Center
- DB2 Command Center
- DB2 UDB for z/OS Visual Explain
For all other remote connections to DB2 UDB for z/OS that are provided through DB2 Connect, you must obtain a separate license for DB2 Connect from IBM.
Compatibility
DB2 UDB for z/OS, V8 is upwardly compatible with previous releases of DB2 for z/OS and OS/390. Migration with full fallback protection is available for customers running on DB2 UDB for z/OS, V7. Thus, existing customers should ensure they are successfully running on DB2 UDB for z/OS, V7 before migrating to DB2 UDB for z/OS, V8.
User group requirements: This announcement satisfies or partially satisfies 111 requirements from one or more of the worldwide user group communities. Groups include Australasian SHARE/GUIDE, COMMON, COMMON Europe, GUIDE International, G.U.I.D.E. Europe, Japan GUIDE/SHARE, Guide Latin American, SHARE EUROPE, and SHARE Incorporated. Requirements satisfied include:
- FR007: Add a partition
- FR035: Unbundle clustering from partitioned index
- FR045: Prior point-in-time recovery automation
- FR097: Change clustering index
- FR107: Alter table column data type
- FR116: Add a column to an existing index
- MR00023580: Alter table column data type
- MR00023584: Permit partition restructure without recreating tablespace
- MR00031810: Change clustering index
- MR00037642: Provide dynamic ZPARM update capability
- MR00037895: Use index bidirectional
- MR00037955: Ability to add a partition
- MR00039026: DB2 system parameters: dynamic reconfiguration
- MR00039330: New partition without recreate
- MR00039540: Improve performance while using indexes
- MR00039736: Increase number of partitions
- MR00039774: Support scrollable cursor
- MR00039856: Exposures in DB2 with partitioned tablespaces
- MR00039864: SQL Multi-Column Alter
- MR00045382: Explain plan information to include filter factors, flags
- MR00047350: Support add of a single partition
- MR00047377: Alter column length
- MR00047531: Rebalance, add partition
- MR00052325: ADD a partition of a partitioned tablespace
- MR00053578: GROUP BY clause numbers
- MR00054263_1: Detail package level accounting information needed
- MR00058501: SQL access to the secondary authid list
- MR00062092: Dynamic assignment of DSNZPARM
- MR00062114: Dynamic updating of DSNZPARM
- MR00063642: Key independent partitioned tables
- MR00065134_1: Make DB2 plan name available to DB2 application
- MR00065134_2: Make DB2 plan name available to DB2 application
- MR00065559: DB2 pre-processor storage allocation above 16M line
- MR00065731: SQL access to the secondary authid list
- MR00066810: DBM1 out of storage
- MR00071443: Online DB2 Catalog Migration utility (Online CATMAINT)
- MR00071443_1: Online DB2 Catalog Migration utility (Online CATMAINT)
- MR00071499: GROUP BY clause changes
- MR00071499_1: GROUP BY clause changes
- MR00071836: Allow C double predicate to be indexable with a SQL DECIMAL(p,s)
- MR00072199: Support for longer table names in UDB for OS/390
- MR00072735: Dynamic extension of the numbers of partitions
- MR00072836: Dynamic change for DSNZPARM parameters
- MR00072995: Online reorg of DB2 catalog
- MR00073178: Data availability during LPL Recovery
- MR00073493: Avoid SQL against index created with DEFER = YES
- MR00073508: Support for table and view column length 30 bytes
- MR00074015: Avoid all possible SQLCODE = -101
- MR00074022: Ability to store more archive log names in BSDS
- MR00074022_1: Ability to store more archive log names in BSDS
- MR00075063: Make more predicates indexable
- MR00075194: DBM1 out of storage due to large number of compression dictionaries
- MR00075886: Full availability during DB2 online reorg BUILD2 phase
- MR00076053: REORG DISCARD SHRLEVEL CHANGE support
- MR00076324: Trigger Difference between DB2 OS/390 and DB2 UNIX and Windows
- MR00076325: Return ROWID to application
- MR00076394: Add columns or alter data types of columns without drop
- MR011501492: DB2 preprocessor support for alternative locales and codepages
- MR0116021248: DB2 explain output restricted to table
- MR0118011917: Terminate EXISTS processing on first qualifying row
- MR0201014921: Capture high water usage for IDBACK
- MR0201015056: Hung Webserver threads, RRSAF compatibility for CAF
- MR021201177: Allow DSNTEP2 to modify MAXERRORS value during runtime
- MR0212013027: Load data into DB2 similar to import function DB2 UNIX & Windows
- MR0222024838: Negative sqlcode instead of abend after alter index
- MR0223011553: Save storage in the EDM pool and statement cache
- MR0313021730: Declared temporary table usage with stored procedures
- MR0405013817: New command option for the SQLJ profile customizer, db2profc
- MR0407005986: Increase the maximum length (32767 characters) of DB2 SQL statements
- MR041001615: DB2 UDB connectivity problem for large environments
- MR0419006957: Change SYSPRINT blocking in DSNTEP2
- MR0420013649: Allowing ORDER BY clause in SELECT INTO statement
- MR0420015442: Time out mechanism for a thread stuck in allocation
- MR0421001328: Ability to do point-in-time recovery to a specified time
- MR0425002725: Trigger performance using transition tables
- MR042700326: LOAD of character delimited input data into DB2
- MR0430022143: Capability to populate catalog statistics
- MR0508015544: Allow DB2 to use striping for VSAM clusters
- MR0510011210: SQLCODE -440 instead of authority error (-551)
- MR0523016551: Control of IP address connecting to DB2
- MR052702429: LOAD delimited data from other platforms
- MR0530024159: IFCID 0063 should not be truncated at 5000 bytes
- MR0606027143: Precompiler support for left and right braces
- MR0607005936: Increase length of table and view names from 18
- MR0607006807: ALTER tablespace add partition
- MR0608024139: Longer column and table names
- MR0608024432: ALIAS names for DB2 locations
- MR060802453: More accounting counters at package level
- MR0618016536: No value returned with SQLCODE +445 in SPUFI and CHAR function used
- MR0623006928: DB2 data set placement
- MR0625013520: Authentication between DB2 for OS/390 and DB2 UDB
- MR0625016457: Signal exception to client program from SQL stored proc
- MR0627022543: Implementation of a db2rfpen type utility on z/OS platform
- MR0703022312: Stored procedures should be WLM-managed
- MR070302645: Increase 32K limit for SQL procedures
- MR0717015639: EDM Pool Error Message, no diagnostic information supplied
- MR0828002527: Occasional message indicating status of cancelled thread rollback
- MR0828003236: Tablespace scan when mismatch between host variable and DB2 column
- MR0829003556: Need SQL Limit of 455 Lines or 32670 Bytes Raised
- MR0917012917: Support GROUP BY clause with a function or expression
- MR091800551: Precompiler support of codepages other than 1047
- MR0918005817: Release write claims on cursors with hold
- MR1005003945: Addition of scalar fullselect to DB2 UDB for OS/390
- MR1017016637: Delete orphan records from SYSLGRNX
- MR1019005352: Increase maximum length of character constant
- MR1024005542: Increase DSNTEP2 buffer (MAXARRY)
- MR1029016954: DDF member routing to specific member
- MR1117002951: LOB IVPs — COBOL or PL/I
- MR112700584: QUERYNO clause for INSERT with VALUES clause is missing
- MR120302549: CREATE INDEX DEFER YES improvements
- OR1220026117: IFCID record should not be truncated at 5000 bytes
Planning information
Customer responsibilities: Review the sections in this announcement that describe the hardware and software dependencies for DB2 UDB for z/OS, V8.
DB2 UDB for z/OS, V8 supports migration from V7. Customers not yet on V7 should plan to migrate to DB2 UDB for z/OS, V7 as preparation for a migration to V8.
Migration considerations: IBM added many universal database capabilities in DB2 UDB for z/OS, V8 and reduced support for some functions. As you prepare to migrate your subsystems, you should be aware of the following changes:
- Net.Data has been stabilized in V7. WebSphere is the strategic IBM solution for delivering DB2 data to Web applications. Net.Data V7 may be ordered as a feature of DB2 UDB for z/OS, V8 to provide stability and compatibility during application transition from Net.Data to a WebSphere Application Server environment.
- Workload Manager (WLM) managed stored procedure address spaces is the strategic solution for stored procedure support in DB2 UDB for z/OS. DB2 managed stored procedure spaces do not support all of the SQL enhancements and capabilities of DB2 UDB for z/OS, V8. Migration to WLM managed stored procedure spaces is recommended to obtain the full stored procedure capability of DB2 UDB for z/OS, V8.
- DRDA is the strategic solution for network computing support in DB2 UDB for z/OS. IBM has no plans for additional private protocol enhancements. DRDA replaces the private protocol access. Private protocol does not support stored procedures or TCP/IP, both of which are available with DB2 for OS/390, V5 and above. Private protocol also does not support network computing enhancements in Versions 6, 7, and 8. Conversion of private protocol applications to DRDA is recommended to obtain the full network computing capability of DB2 UDB for z/OS, V8.
For more detailed information on migrating to V8, refer to the DB2 UDB for z/OS, V8 Installation Guide (GC18-7418).
Installability: Refer to the planning sections of the following publications available from an IBM representative, as well as to the Program Directory shipped with the product:
- Release Planning Guide (SC18-7425)
- Installation Guide (GC18-7418)
- Data Sharing: Planning and Administration (SC18-7417)
Direct customer support: Direct customer support is provided by IBM Operational Support Services — Support Line. This fee service can enhance your productivity by providing voice and electronic access into the IBM support organization. IBM Operational Support Services — 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).
Packaging: The DB2 UDB for z/OS features are available on 4-mm data cartridges and 3480 cartridges.
Also included with each base or optional feature is a Program Directory, and under separate cover, one copy of the entitled publications, and other media, such as CD-ROM, as applicable.
DB2 UDB for z/OS
Order
Title number
DB2 for z/OS V8 GI10-8566
Program Directory
DB2 Installation Guide GC18-7418
DB2 Licensed Library CD-ROM LK3T-7128
DB2 Messages and Codes GC18-7422
DB2 Licensed Programming GC18-7420
Specifications
QMF Classic Edition
QMF Classic Edition GI10-8517
Program Directory
Order
Title number
QMF Distributed Edition
QMF Distributed Edition GI10-8518
Program Directory
QMF for WebSphere CD-ROM
QMF for Windows CD-ROM
QMF Visionary Studio CD-ROM
QMF Enterprise Edition
QMF Enterprise Edition GI10-8519
Program Directory
QMF for WebSphere CD-ROM
QMF for Windows CD-ROM
QMF Visionary Studio CD-ROM
DB2 Management Clients
The workstation client functions of DB2 Management
Clients Package are shipped on CD-ROM.
DB2 Management Clients Pkg GI10-8567
Program Directory
DB2 Management Clients LCD4-6606
CD-ROM ws CD-ROM
DB2 Connect Personal Edition
Pre-packaged kit
Net.Data
Net.Data V7 GI10-8565
Program Directory
Net Search Extender V7
Net Search Extender V7 GI10-8582
Program Directory
z/OS Application Connectivity to DB2 for z/OS
z/OS Application GI10-8581
Connectivity to
DB2 for z/OS
Program Directory
Security, auditability, and control
DB2 UDB for z/OS, V8 uses the security and auditability features of the host z/OS systems. It also provides facilities for the protection and control of its resources. These facilities include controls for:
- System access
- Data access and control
- Concurrent access
- Data recovery
- Accounting
The customer is responsible for evaluation, selection, and implementation of security features,
administrative procedures, and appropriate controls in application systems and communication
facilities.
Back to top
|
|
| Ordering information |
|
New licensees
Orders for new licenses can be placed now.
Registered customers can access IBMLink™ for ordering information and charges.
Unless a later date is specified, orders entered before the planned availability date of March 26, 2004, will be assigned a schedule date of one week following availability.
Shipment will begin on the planned availability date of March 26, 2004.
-
Orders entered after the planned availability date will be assigned a schedule date for the week
following order entry.
or - Orders entered with a scheduled date before the planned availability date will be shipped DB2 UDB for z/OS and OS/390, V7.
- Orders entered with a scheduled shipment date after planned availability will be shipped DB2 UDB for z/OS, V8. Unless a later date is specified, an order is scheduled for the week following order entry.
New users of DB2 UDB for z/OS, V8 should specify type 5625 and model DB2.
Basic license: To order a basic license, specify the program number and feature number 9001 for asset registration.
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, and 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.
DB2 UDB for z/OS, V8
PSLC PSLC basic license
Machines feature MLC feature
MSU capacity number description
1 0001 PSLC Base, 1 MSU
2 0002 PSLC Base, 2 MSUs
3 0003 PSLC Base, 3 MSUs
4 to 45 0004 PSLC Level A, 1 MSU
0005 PSLC Level A, 42 MSUs
46 to 175 0006 PSLC Level B, 1 MSU
0007 PSLC Level B, 10 MSUs
0008 PSLC Level B, 50 MSUs
PSLC PSLC basic license
Machines feature MLC feature
MSU capacity number description
176 to 315 0009 PSLC Level C, 1 MSU
0010 PSLC Level C, 10 MSUs
0011 PSLC Level C, 50 MSUs
316 or more 0012 PSLC Level D, 1 MSU
0013 PSLC Level D, 50 MSUs
Not applicable 0014 PSLC N/C ID
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:
-
PSLC chargeable license #1:
- 0003 — quantity 1
- 0005 — quantity 1
- 0006 — quantity 5
- 0007 — quantity 1
- PSLC no-charge license #2: 0014 — quantity 1
QMF Classic Edition
PSLC PSLC basic license
Machines feature MLC feature
MSU capacity number description
1 0142 PSLC Base, 1 MSU
2 0143 PSLC Base, 2 MSUs
3 0144 PSLC Base, 3 MSUs
4 to 45 0145 PSLC Level A, 1 MSU
0146 PSLC Level A, 42 MSUs
46 to 175 0147 PSLC Level B, 1 MSU
0148 PSLC Level B, 10 MSUs
0149 PSLC Level B, 50 MSUs
176 to 315 0150 PSLC Level C, 1 MSU
0151 PSLC Level C, 10 MSUs
0152 PSLC Level C, 50 MSUs
316 or more 0153 PSLC Level D, 1 MSU
0154 PSLC Level D, 50 MSUs
Not applicable 0155 PSLC N/C ID
QMF Distributed Edition
1 0098 PSLC Base, 1 MSU
2 0099 PSLC Base, 2 MSUs
3 0100 PSLC Base, 3 MSUs
4 to 45 0101 PSLC Level A, 1 MSU
0102 PSLC Level A, 42 MSUs
46 to 175 0103 PSLC Level B, 1 MSU
0104 PSLC Level B, 10 MSUs
0105 PSLC Level B, 50 MSUs
176 to 315 0106 PSLC Level C, 1 MSU
0107 PSLC Level C, 10 MSUs
0108 PSLC Level C, 50 MSUs
PSLC PSLC basic license
Machines feature MLC feature
MSU capacity number description
316 or more 0109 PSLC Level D, 1 MSU
0110 PSLC Level D, 50 MSUs
Not applicable 0111 PSLC N/C ID
QMF Enterprise Edition
1 0054 PSLC Base, 1 MSU
2 0055 PSLC Base, 2 MSUs
3 0056 PSLC Base, 3 MSUs
4 to 45 0057 PSLC Level A, 1 MSU
0058 PSLC Level A, 42 MSUs
46 to 175 0059 PSLC Level B, 1 MSU
0060 PSLC Level B, 10 MSUs
0061 PSLC Level B, 50 MSUs
176 to 315 0062 PSLC Level C, 1 MSU
0063 PSLC Level C, 10 MSUs
0064 PSLC Level C, 50 MSUs
316 or more 0065 PSLC Level D, 1 MSU
0066 PSLC Level D, 50 MSUs
Not applicable 0067 PSLC N/C ID
DB2 Net Search Extender V7
1 0482 PSLC Base, 1 MSU
2 0483 PSLC Base, 2 MSUs
3 0484 PSLC Base, 3 MSUs
4 to 45 0485 PSLC Level A, 1 MSU
0486 PSLC Level A, 42 MSUs
46 to 175 0487 PSLC Level B, 1 MSU
0488 PSLC Level B, 10 MSUs
0489 PSLC Level B, 50 MSUs
176 to 315 0490 PSLC Level C, 1 MSU
0491 PSLC Level C, 10 MSUs
0492 PSLC Level C, 50 MSUs
316 or more 0493 PSLC Level D, 1 MSU
0494 PSLC Level D, 50 MSUs
Not applicable 0495 PSLC N/C ID
Workload License Charge (WLC) basic license: To order a basic license, specify the program number and feature number 9001 for asset registration. Also, specify the feature number of the desired distribution medium.
Variable Workload License Charge (VWLC) features
DB2 UDB for z/OS, V8
VWLC
feature
Description number
Level 0 incl 3 MSU, Workload Per User Base 4100
Level 0 Up to 45 MSU, Per Usage Addl Qty 4101
Workload
Level 1 46-175 MSU, Per Usage Addl Qty 0029
Workload
Level 2 176-315 MSU, Per Usage Addl Qty 0030
Workload
Level 3 316-575 MSU, Per Usage Addl Qty 0031
Workload
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0032
Workload
Level 4 576-875 MSU, Per Usage Addl Qty 0033
Workload
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0034
Workload
Level 5 876-1315 MSU, Per Usage Addl Qty 0035
Workload
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0036
Workload
Level 6 1316-1975 MSU, Per Usage Addl Qty 0254
Workload
Level 6 1316-1975 MSU, Per 50 MSU Addl Qty 0255
Workload
Level 7 1976 MSU and up, Per Usage Addl 0256
Qty Workload
Level 7 1976 MSU and up, Per 50 MSU Addl 0257
Qty Workload
License option -- Workload registration no charge
Level 0 incl 1 MSU, Workload Registration Per 4102
User Base
Level 0 Up to 45 MSU, Per Usage Addl Qty 4103
Workload Regist
Level 1 46-175 MSU, Per Usage Addl Qty 0038
Workload Regist
Level 2 176-315 MSU, Per Usage Addl Qty 0039
Workload Regist
Level 3 316-575 MSU, Per Usage Addl Qty 0040
Workload Regist
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0041
Workload Regist
Level 4 576-875 MSU, Per Usage Addl Qty 0042
Workload Regist
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0043
Workload Regist
Level 5 876-1315 MSU, Per Usage Addl Qty 0044
Workload Regist
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0045
Workload Regist
Level 6 1316-1975 MSU, Per Usage Addl Qty 0258
Workload Regist
Level 6 1316-1975 MSU, Per 50 MSU Addl Qty 0259
Workload Regist
Level 7 1976 MSU and up, Per Usage Addl 0260
Qty Workload Regist
Level 7 1976 MSU and up, Per 50 MSU Addl 0261
Qty Workload Regist
VWLC
feature
Description number
QMF Classic Edition
Level 0 incl 3 MSU, Workload Per User Base 4104
Level 0 Up to 45 MSU, Per Usage Addl Qty 4105
Workload
Level 1 46-175 MSU, Per Usage Addl Qty 0161
Workload
Level 2 176-315 MSU, Per Usage Addl Qty 0162
Workload
Level 3 316-575 MSU, Per Usage Addl Qty 0163
Workload
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0164
Workload
Level 4 576-875 MSU, Per Usage Addl Qty 0165
Workload
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0166
Workload
Level 5 876-1315 MSU, Per Usage Addl Qty 0167
Workload
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0168
Workload
Level 6 1316-1975 MSU, Per Usage Addl Qty 0246
Workload
Level 6 1316-1975 MSU, Per 50 MSU Addl Qty 0247
Workload
Level 7 1976 MSU and up, Per Usage Addl 0248
Qty Workload
Level 7 1976 MSU and up, Per 50 MSU Addl 0249
Qty Workload
License option -- Workload registration no charge
Level 0 incl 1 MSU, Workload Registration Per 4106
User Base
Level 0 Up to 45 MSU, Per Usage Addl Qty 4107
Workload Regist
Level 1 46-175 MSU, Per Usage Addl Qty 0170
Workload Regist
Level 2 176-315 MSU, Per Usage Addl Qty 0171
Workload Regist
Level 3 316-575 MSU, Per Usage Addl Qty 0172
Workload Regist
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0173
Workload Regist
Level 4 576-875 MSU, Per Usage Addl Qty 0174
Workload Regist
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0175
Workload Regist
Level 5 876-1315 MSU, Per Usage Addl Qty 0176
Workload Regist
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0177
Workload Regist
Level 6 1316-1975 MSU, Per Usage Addl Qty 0250
Workload Regist
Level 6 1316-1975 MSU, Per 50 MSU Addl Qty 0251
Workload Regist
Level 7 1976 MSU and up, Per Usage Addl 0252
Qty Workload Regist
Level 7 1976 MSU and up, Per 50 MSU Addl 253
Qty Workload Regist
VWLC
feature
Description number
QMF Distributed Edition
Level 0 incl 3 MSU, Workload Per User Base 4112
Level 0 Up to 45 MSU, Per Usage Addl Qty 4113
Workload
Level 1 46-175 MSU, Per Usage Addl Qty 0117
Workload
Level 2 176-315 MSU, Per Usage Addl Qty 0118
Workload
Level 3 316-575 MSU, Per Usage Addl Qty 0119
Workload
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0120
Workload
Level 4 576-875 MSU, Per Usage Addl Qty 0121
Workload
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0122
Workload
Level 5 876-1315 MSU, Per Usage Addl Qty 0123
Workload
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0124
Workload
Level 6 1316-1975 MSU, Per Usage Addl Qty 0238
Workload
Level 6 1316-1975 MSU, Per 50 MSU Addl Qty 0239
Workload
Level 7 1976 MSU and up, Per Usage Addl 0240
Qty Workload
Level 7 1976 MSU and up, Per 50 MSU Addl 0241
Qty Workload
License option -- Workload registration no charge
Level 0 incl 1 MSU, Workload Registration Per 4114
User Base
Level 0 Up to 45 MSU, Per Usage Addl Qty 4115
Workload Regist
Level 1 46-175 MSU, Per Usage Addl Qty 0126
Workload Regist
Level 2 176-315 MSU, Per Usage Addl Qty 0127
Workload Regist
Level 3 316-575 MSU, Per Usage Addl Qty 0128
Workload Regist
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0129
Workload Regist
Level 4 576-875 MSU, Per Usage Addl Qty 0130
Workload Regist
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0131
Workload Regist
Level 5 876-1315 MSU, Per Usage Addl Qty 0132
Workload Regist
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0133
Workload Regist
Level 6 1316-1975 MSU, Per Usage Addl Qty 0242
Workload Regist
Level 6 1316-1975 MSU, Per 50 MSU Addl Qty 0243
Workload Regist
Level 7 1976 MSU and up, Per Usage Addl 0244
Qty Workload Regist
Level 7 1976 MSU and up, Per 50 MSU Addl 0245
Qty Workload Regist
VWLC
feature
Description number
QMF Enterprise Edition
Level 0 incl 3 MSU, Workload Per User Base 4108
Level 0 Up to 45 MSU, Per Usage Addl Qty 4109
Workload
Level 1 46-175 MSU, Per Usage Addl Qty 0073
Workload
Level 2 176-315 MSU, Per Usage Addl Qty 0074
Workload
Level 3 316-575 MSU, Per Usage Addl Qty 0075
Workload
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0076
Workload
Level 4 576-875 MSU, Per Usage Addl Qty 0077
Workload
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0078
Workload
Level 5 876-1315 MSU, Per Usage Addl Qty 0079
Workload
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0080
Workload
Level 6 1316-1975 MSU, Per Usage Addl Qty 0230
Workload
Level 7 1316-1975 MSU, Per 50 MSU Addl Qty 0231
Workload
Level 7 1976 MSU and up, Per Usage Addl 0232
Qty Workload
Level 7 1976 MSU and up, Per 50 MSU Addl 0233
Qty Workload
License option -- Workload registration no charge
Level 0 incl 1 MSU, Workload Registration Per 4110
User Base
Level 0 Up to 45 MSU, Per Usage Addl Qty 4111
Workload Regist
Level 1 46-175 MSU, Per Usage Addl Qty 0082
Workload Regist
Level 2 176-315 MSU, Per Usage Addl Qty 0083
Workload Regist
Level 3 316-575 MSU, Per Usage Addl Qty 0084
Workload Regist
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0085
Workload Regist
Level 4 576-875 MSU, Per Usage Addl Qty 0086
Workload Regist
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0087
Workload Regist
Level 5 876-1315 MSU, Per Usage Addl Qty 0088
Workload Regist
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0089
Workload Regist
Level 6 1316-1975 MSU, Per Usage Addl Qty 0234
Workload Regist
Level 6 1316-1975 MSU, Per 50 MSU Addl Qty 0235
Workload Regist
Level 7 1976 MSU and up, Per Usage Addl 0236
Qty Workload Regist
Level 7 1976 MSU and up, Per 50 MSU Addl 0237
Qty Workload Regist
VWLC
feature
Description number
DB2 Net Search Extender V7
Level 0 incl 3 MSU, Workload Per User Base 0496
Level 0 Up to 45 MSU, Per Usage Addl Qty 0497
Workload
Level 1 46-175 MSU, Per Usage Addl Qty 0498
Workload
Level 2 176-315 MSU, Per Usage Addl Qty 0499
Workload
Level 3 316-575 MSU, Per Usage Addl Qty 0500
Workload
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0501
Workload
Level 4 576-875 MSU, Per Usage Addl Qty 0502
Workload
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0503
Workload
Level 5 876-1315 MSU, Per Usage Addl Qty 0504
Workload
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0505
Workload
Level 6 1316-1975 MSU, Per Usage Addl Qty 0506
Workload
Level 6 1316-1975 MSU, Per 50 MSU Addl Qty 0507
Workload
Level 7 1976 MSU and up, Per Usage Addl 0508
Qty Workload
Level 7 1976 MSU and up, Per 50 MSU Addl 0509
Qty Workload
License option -- Workload registration no charge
Level 0 incl 1 MSU, Workload Registration Per 0510
User Base
Level 0 Up to 45 MSU, Per Usage Addl Qty 0511
Workload Regist
Level 1 46-175 MSU, Per Usage Addl Qty 0512
Workload Regist
Level 2 176-315 MSU, Per Usage Addl Qty 0513
Workload Regist
Level 3 316-575 MSU, Per Usage Addl Qty 0514
Workload Regist
Level 3 316-575 MSU, Per 50 MSU Addl Qty 0515
Workload Regist
Level 4 576-875 MSU, Per Usage Addl Qty 0516
Workload Regist
Level 4 576-875 MSU, Per 50 MSU Addl Qty 0517
Workload Regist
Level 5 876-1315 MSU, Per Usage Addl Qty 0518
Workload Regist
Level 5 876-1315 MSU, Per 50 MSU Addl Qty 0519
Workload Regist
Level 6 1316-1975 MSU, Per Usage Addl Qty 0520
Workload Regist
Level 6 1316-1975 MSU, Per 50 MSU Addl Qty 0521
Workload Regist
Level 7 1976 MSU and up, Per Usage Addl 0522
Qty Workload Regist
Level 7 1976 MSU and up, Per 50 MSU Addl 0523
Qty Workload Regist
Entry Workload License Charge (EWLC): To order EWLC software, specify the program number, feature number 9001 for asset registration, and the EWLC monthly charge feature number from the table below. Also, specify the feature number for the desired distribution medium.
DB2 UDB for z/OS, V8
EWLC
feature
Description number
Level 1 incl 3 MSU, Basic Per User Base 4116
EWLC
Level 1 4-17 MSU, Per Usage Additional Qty 4117
EWLC
Level 2 18-30 MSU, Per Usage Additional Qty 4118
EWLC
Level 3 31-45 MSU, Per Usage Additional Qty 4119
EWLC
Level 4 46-87 MSU, Per Usage Additional Qty 4120
EWLC
Level 5 88-175 MSU, Per Usage Additional Qty 4121
EWLC
Level 6 176-260 MSU, Per Usage Additional 4122
Qty EWLC
Level 7 261 and up MSU, Per Usage 4123
Additional Qty EWLC
Level 7 261 and up MSU, Per 50 MSU Usage 4148
Additional Qty EWLC
QMF Classic Edition
Level 1 incl 3 MSU, Basic Per User Base 4124
EWLC
Level 1 4-17 MSU, Per Usage Additional Qty 4125
EWLC
Level 2 18-30 MSU, Per Usage Additional Qty 4126
EWLC
Level 3 31-45 MSU, Per Usage Additional Qty 4127
EWLC
Level 4 46-87 MSU, Per Usage Additional Qty 4128
EWLC
Level 5 88-175 MSU, Per Usage Additional Qty 4129
EWLC
Level 6 176-260 MSU, Per Usage Additional 4130
Qty EWLC
Level 7 261 and up MSU, Per Usage 4131
Additional Qty EWLC
Level 7 261 and up MSU, Per 50 MSU Usage 4149
Additional Qty EWLC
QMF Distributed Edition
Level 1 incl 3 MSU, Basic Per User Base 4140
EWLC
Level 1 4-17 MSU, Per Usage Additional Qty 4141
EWLC
Level 2 18-30 MSU, Per Usage Additional Qty 4142
EWLC
Level 3 31-45 MSU, Per Usage Additional Qty 4143
EWLC
Level 4 46-87 MSU, Per Usage Additional Qty 4144
EWLC
Level 5 88-175 MSU, Per Usage Additional Qty 4145
EWLC
Level 6 176-260 MSU, Per Usage Additional 4146
Qty EWLC
Level 7 261 and up MSU, Per Usage 4147
Additional Qty EWLC
Level 7 261 and up MSU, Per 50 MSU Usage 4151
Additional Qty EWLC
EWLC
feature
Description number
QMF Enterprise Edition
Level 1 incl 3 MSU, Basic Per User Base 4132
EWLC
Level 1 4-17 MSU, Per Usage Additional Qty 4133
EWLC
Level 2 18-30 MSU, Per Usage Additional Qty 4134
EWLC
Level 3 31-45 MSU, Per Usage Additional Qty 4135
EWLC
Level 4 46-87 MSU, Per Usage Additional Qty 4136
EWLC
Level 5 88-175 MSU, Per Usage Additional 4137
Qty EWLC
Level 6 176-260 MSU, Per Usage Additional 4138
Qty EWLC
Level 7 261 and up MSU, Per Usage 4139
Additional Qty EWLC
Level 7 261 and up MSU, Per 50 MSU Usage 4150
Additional Qty EWLC
DB2 Net Search Extender V7
Level 1 incl 3 MSU, Basic Per User Base 0534
EWLC
Level 1 4-17 MSU, Per Usage Additional Qty 0535
EWLC
Level 2 18-30 MSU, Per Usage Additional Qty 0536
EWLC
Level 3 31-45 MSU, Per Usage Additional Qty 0537
EWLC
Level 4 46-87 MSU, Per Usage Additional Qty 0538
EWLC
Level 5 88-175 MSU, Per Usage Additional 0539
Qty EWLC
Level 6 176-260 MSU, Per Usage Additional 0540
Qty EWLC
Level 7 261 and up MSU, Per Usage 0541
Additional Qty EWLC
Level 7 261 and up MSU, Per 50 MSU Usage 0542
Additional Qty EWLC
For DB2 UDB for z/OS, V8
S/390® and zSeries 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 S390 and zSeries 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+: (# MSUs from 2-11 times the charge associated with feature number 4) + (# MSUs from 12-44 times the charge associated with feature number 5) + (# MSUs from 45-78 times the charge associated with feature number 6) + (# MSUs above 78 times the charge associated with feature number 7 — if applicable)
Usage
pricing
feature
Description number
License option -- Basic monthly license charge
Up to 0.25 MSU Basic 0015
Up to 0.5 MSU Basic 0016
Value metric category -- ULC above 0.5
License option -- Basic monthly license charge
Level A incl 1 MSU, Basic Per User Base 0017
Level A Up to 11 MSU, Per Usage 0018
Additional Quantity
Level B 12-44 MSU, Per Usage 0019
Additional Quantity
Level C 45-78 MSU, Per Usage 0020
Additional Quantity
Level D 79 MSU and up, Per Usage 0021
Additional Quantity
Level D 79 MSU and up, Per 50 MSU 0022
Additional Quantity
Value metric category -- ULC above 0.5
License option -- Basic monthly license charge
License option -- System registration no charge
System Usage Registration 0023
Examples for ordering: A customer with a measured usage (from the IBM Measured Usage report) of 0.3 MSU would order quantity 1 of the 0.26 to 0.5 MSU base feature.
A customer with 6.6 MSUs (from the IBM Usage report) would:
- Be rounded up to 7.0 MSUs
- Order quantity 1 of the "0.51 to 1.0 MSU" base feature Order quantity 6 of the Level A 1 MSU feature
A customer with 15 MSUs (from the IBM Usage report) would:
- Order quantity 1 of the "0.51 to 1.0 MSU" base feature
- Order quantity 10 of the Level A 1 MSU feature
- Order quantity 4 of the Level B 1 MSU feature
A customer with 50 MSUs (from the IBM Usage report) would:
- Order quantity 1 of the "0.51 to 1.0 MSU" base feature
- Order quantity 10 of the Level A 1 MSU feature
- Order quantity 33 of the Level B 1 MSU feature
- Order quantity 6 of the Level C 1 MSU feature
A customer with 85 MSUs (from the IBM Usage report) would:
- Order quantity 1 of the "0.51 to 1.0 MSU" base feature
- Order quantity 10 of the Level A 1 MSU feature
- Order quantity 33 of the Level B 1 MSU feature
- Order quantity 34 of the Level C 1 MSU feature
- Order quantity 7 of the Level D 1 MSU feature
zSeries entry license charge (zELC): To order zELC software, specify the program number, feature number 9001 for asset registration, and the zELC monthly charge feature number from the table below. Also, specify the feature number for the desired distribution medium.
DB2 UDB for z/OS, V8
zELC
feature
z800 models number
0E1 -- 1 engine 0262
0A1 -- 1 engine 0046
0B1 -- 1 engine 0047
0C1 -- 1 engine 0048
0X2 -- 1 engine 0263
001 -- 1 engine 0049
0A2 -- 2 engines 0050
002 -- 2 engines 0051
003 -- 3 engines 0052
004 -- 4 engines 0053
QMF Classic Edition
0E1 -- 1 engine 0410
0A1 -- 1 engine 0178
0B1 -- 1 engine 0179
0C1 -- 1 engine 0180
0X2 -- 1 engine 0265
001 -- 1 engine 0181
0A2 -- 2 engines 0182
002 -- 2 engines 0183
003 -- 3 engines 0184
004 -- 4 engines 0185
0E1 -- 1 engine 0360
0A1 -- 1 engine 0134
0B1 -- 1 engine 0135
0C1 -- 1 engine 0136
0X2 -- 1 engine 0267
001 -- 1 engine 0137
0A2 -- 2 engines 0138
002 -- 2 engines 0139
003 -- 3 engines 0140
004 -- 4 engines 0141
QMF Enterprise Edition
0E1 -- 1 engine 0310
0A1 -- 1 engine 0090
0B1 -- 1 engine 0091
0C1 -- 1 engine 0092
0X2 -- 1 engine 0269
001 -- 1 engine 0093
0A2 -- 2 engines 0094
002 -- 2 engines 0095
003 -- 3 engines 0096
004 -- 4 engines 0097
DB2 Net Search Extender V7
0E1 -- 1 engine 0524
0A1 -- 1 engine 0525
0B1 -- 1 engine 0526
0C1 -- 1 engine 0527
0X2 -- 1 engine 0528
001 -- 1 engine 0529
0A2 -- 2 engines 0530
002 -- 2 engines 0531
003 -- 3 engines 0532
004 -- 4 engines 0533
z/OS Application Connectivity to DB2 for z/OS
To order this feature for the basic license, specify the program number, feature number 9001 for asset registration, and the no charge feature number from the table below. Also specify the feature number for the desired media type.
No charge feature No charge description feature number z/OS Application Connectivity 0543 to DB2 for z/OS
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
DB2 UDB for z/OS, V8
Feature Distribution
Environment number medium
English -- U.S. 6020 3480 1/2-inch data
U/L SBCS (ENU) cartridge 34K bpi
uncompressed
English -- U.S. 6022 4-mm data cartridge;
U/L SBCS (ENU) modified; 2 GB
uncompressed
(variable block)
Japanese -- Kanji 6021 3480 1/2-inch data
(DBCS) (JPN) cartridge 34 K
bpi uncompressed
Japanese -- Kanji 6019 4-mm data cartridge;
(DBCS) (JPN) modified; 2 GB
uncompressed
(variable block)
QMF Classic Edition
English -- US 5950 3480 1/2-in data
U/L SBCS (ENU) cartridge 34K
bpi uncompressed
English -- U.S. 6013 4-mm data cartridge;
U/L SBCS (ENU) modified; 2 GB
uncompressed
(variable block)
English -- U.S. 5892 3480 1/2-in data
U/L SBCS (MUL) cartridge 34K
and DBCS bpi uncompressed
English -- US 6012 4-mm data cartridge;
U/L SBCS (MUL) modified; 2 GB
and DBCS uncompressed
(variable block)
QMF Distributed Edition
English -- U.S. 6018 3480 1/2-in data
U/L SBCS (ENU) cartridge 34K
bpi uncompressed
English -- U.S. 6017 4-mm data cartridge;
U/L SBCS (ENU) modified; 2 GB
uncompressed
Feature Distribution
Environment number medium
English -- U.S. 5989 3480 1/2-in data
U/L SBCS (MUL) cartridge 34K
and DBCS bpi uncompressed
English -- U.S. 6016 4-mm data cartridge;
U/L SBCS (MUL) modified; 2 GB
and DBCS uncompressed
QMF Enterprise Edition
English -- U.S. 5976 3480 1/2-in data
U/L SBCS (ENU) cartridge 34K
bpi uncompressed
English -- U.S. 6015 4-mm data cartridge;
U/L SBCS (ENU) modified; 2 GB
uncompressed
English -- U.S. 5963 3480 1/2-in data
U/L SBCS (MUL) cartridge 34K
and DBCS bpi uncompressed
English -- U.S. 6014 4-mm data cartridge;
U/L SBCS (MUL) modified; 2 GB
and DBCS uncompressed
DB2 Management Clients Package
English -- U.S. 6024 3480 1/2-in data
U/L SBCS (ENU) cartridge 34K
bpi uncompressed
English -- U.S. 6023 4-mm data cartridge;
U/L SBCS (ENU) modified; 2 GB
uncompressed
English -- U.S. 6031 3480 1/2-in data
U/L SBCS (MUL) cartridge 34K
and DBCS bpi uncompressed
English -- U.S. 6032 4-mm data cartridge;
U/L SBCS (MUL) modified; 2 GB
and DBCS uncompressed
DB2 Net Search Extender V7
English -- U.S. 6033 3480 1/2-in data
U/L SBCS (ENU) cartridge 34K
bpi uncompressed
English -- U.S. 6034 4-mm data cartridge;
U/L SBCS (ENU) modified; 2 GB
uncompressed
English -- U.S. 6035 3480 1/2-in data
U/L SBCS (MUL) cartridge 34K
and DBCS bpi uncompressed
English -- U.S. 6036 4-mm data cartridge;
U/L SBCS (MUL) modified; 2 GB
and DBCS uncompressed
Feature Distribution
Environment number medium
Net Data V7
English -- U.S. 6025 3480 1/2-in data
U/L SBCS (ENU) cartridge 34K
bpi uncompressed
English -- U.S. 6026 4-mm data cartridge;
U/L SBCS (ENU) modified; 2 GB
uncompressed
English -- U.S. 6029 3480 1/2-in data
U/L SBCS (MUL) cartridge 34K
and DBCS bpi uncompressed
English -- U.S. 6030 4-mm data cartridge;
U/L SBCS (MUL) modified; 2 GB
and DBCS uncompressed
z/OS Application Connectivity to DB2 for z/OS
English -- U.S. 6027 3480 1/2-in data
U/L SBCS (ENU) cartridge 34K
bpi uncompressed
English -- U.S. 6028 4-mm data cartridge;
U/L SBCS (ENU) modified; 2 GB
uncompressed
Customization options: Select the appropriate feature numbers to customize your order to specify the delivery options desired. These features can be specified on the initial or MES orders.
Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.
Feature
Description Number
Initial shipments
Serial number only (suppresses shipment 3444
of media and documentation)
Ship media only (suppresses initial 3470
shipment of documentation)
Ship documentation only (suppresses 3471
initial shipment of media)
Update shipments
Ship Media updates only (suppresses 3480
update shipment of documentation)
Ship documentation only (suppresses 3481
update shipment of media)
Suppress updates (suppresses update 3482
shipment of media and documentation)
Feature
Description Number
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.
Optional machine-readable material: To order, select the feature number for the desired distribution medium:
Unlicensed documentation: A memo and the program directory are shipped with the basic machine-readable material. Also included is a copy of each of the following publications:
DB2 Universal Database for z/OS, V8
- Installation Guide
- Licensed Program Specifications
- Messages and Codes
- Licensed Library Collection (CD-ROM)
The following QMF publications are delivered in softcopy only. When ordering DB2 UDB for z/OS, V8, these QMF publications are included on the publication CD "DB2 UDB for z/OS, V8 Licensed Library Collection, LK3T-7128".
- Introducing DB2 QMF
- Installing and Managing DB2 QMF for TSO/CICS
- Using DB2 QMF
- DB2 QMF Reference
- DB2 QMF Messages and Codes
- Developing DB2 QMF Applications
- Installing and Managing DB2 QMF for Windows and DB2 QMF for WebSphere
- Getting Started with DB2 QMF for Windows and DB2 QMF for WebSphere
- DB2 QMF High Performance Option User's Guide for TSO/CICS
- DB2 QMF Visionary Studio Getting Started Guide
- DB2 QMF Visionary Studio Developer's Guide
The following V7 Extenders books, in softcopy format only, will be included with DB2 UDB for z/OS, V8:
DB2 Universal Database for OS/390 and z/OS, V7
- Image, Audio, and Video Extenders Administration and Programming
- Text Extender Administration and Programming
- Net Search Extender Administration Programming
The following optional publications are available for ordering immediately:
Order
Title number
DB2 Universal Database for z/OS, V8
Administration Guide SC18-7413
Application Programming Guide and SC18-7414
Reference for JAVA
Application Programming & SQL Guide SC18-7415
Command Reference SC18-7416
Data Sharing: Planning and SC18-7417
Administration
Installation Guide GC18-7418
Messages and Codes GC18-7422
ODBC Guide and Reference SC18-7423
Reference Summary SX26-3853
Release Planning Guide SC18-7425
SQL Reference SC18-7426
Utility Guide and Reference SC18-7427
What's New? GC18-7428
XML Extender Administration and SC18-7431
Programming
All of the publications listed above can be ordered using bill-of-forms number XBOF-7786.
The following DB2 UDB for z/OS, V8 publications will be available in softcopy format only; they cannot be ordered in hardcopy. The publications are made available on the Web at
- DB2 Universal Database for z/OS, V8:
- RACF Access Control Module Guide
- Reference for Remote DRDA Requesters and Servers
Information center: DB2 UDB for z/OS product information will be viewable in the DB2 Information Center for z/OS solutions. The information center is a new delivery vehicle for information about DB2 UDB for z/OS, IMS, QMF, and related tools. The information center is based on Eclipse open source technology. This center enables users to search across related product information in multiple languages for data management solutions for the z/OS environment. Product technical information is provided in a new format that will give users more options and tools for accessing, integrating, and customizing information resources.
The information center will be viewable at the following Web site within two weeks of the DB2 UDB for z/OS, V8 planned availability date:
Licensed documentation: The following licensed material will be available from IBM by March 26, 2004. To order, contact your IBM representative. Use the feature number 8XXX to order additional copies for a fee.
Order Feature
Title number number
DB2 Universal Database for z/OS, V8
Diagnosis Guide and Reference LY37-3201 8001
Diagnostic Quick Reference LY37-3202 8002
Terms and conditions for use of the machine-readable files are shipped with the files.
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.
Customized offerings
Most product media is shipped only via Customized Offerings (CBPDO, ServerPac, Systempac®).
Non-customized items (CDs, diskettes, source media, media kits) will continue to be shipped via the
stand-alone product.
Back to top
|
|
| Terms and conditions |
|
Agreement: IBM Customer Agreement (ICA)
Variable charges apply: No
Indexed monthly license charge (IMLC) applies: No
Location license applies: No
Use limitation applies: No
Educational allowance available: Yes, 15% education allowance applies to qualified education institution customers.
Volume orders: Not applicable
Replaced program Replacement program Program Program Program Program Number Name number name 5740-XYR DB2 V1_ 5625-DB2 DB2 UDB V8 5665-DB2 DB2 V2_ 5625-DB2 DB2 UDB V8 5685-DB2 DB2 V3_ 5625-DB2 DB2 UDB V8 5695-DB2 DB2 V4_ 5625-DB2 DB2 UDB V8 5655-DB2 DB2 V5_ 5625-DB2 DB2 UDB V8 5645-DB2 DB2 V6_ 5625-DB2 DB2 UDB V8 5675-DB2 DB2 V7_ 5625-DB2 DB2 UDB V8 5625-DB2 DB2 V8_ To a follow-on program, if any.
Warranty applies: Yes
Licensed program materials availability
- Restricted Materials of IBM: None
- Non-Restricted Source Materials: None
- Object Code Only (OCO): All
Program services/support line
- Support Center applies: Yes; Access available through the IBM Support Center
- Available until discontinued: 12-months' written notice
-
APAR Mailing Address:
-
IBM Corporation
APAR Processing
555 Bailey Ave.
San Jose, CA 95141
IBM operational support services — Support line: Yes
EWLC:
A revised contract (Attachment for zSeries z800 Software License Charges, Z125-6587-04) is in
place for EWLC. This revised contract must be signed by the customer.
Back to top
|
|
| IBM Electronic Services |
|
IBM Global Services has transformed its delivery of hardware and software support services to put you on the road to higher systems availability. IBM Electronic Services is a Web-enabled solution that provides you with an exclusive, no-additional-charge enhancement to the service and support on the IBM eServer. You should benefit from greater system availability due to faster problem resolution and preemptive monitoring. IBM Electronic Services is comprised of two separate but complementary elements: IBM Electronic Services news page and IBM Electronic Service Agent™.
IBM Electronic Services news page provides you with a single Internet entry point that replaces the multiple entry points traditionally used by customers to access IBM Internet services and support. By using the news page, it enables you to gain easier access to IBM resources for assistance in resolving technical problems.
The IBM Electronic Service Agent is no-additional-charge software that resides on your IBM eServer system that is designed to proactively monitor events and transmit system inventory information to IBM on a periodic customer-defined timetable. The IBM Electronic Service Agent tracks system inventory, hardware error logs and performance information. If the server is under a current IBM maintenance service agreement or within the IBM Warranty period, the Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to provide proactive service that maintains higher system availability and performance. In addition, information collected through the Service Agent will be made available to IBM service support representatives when they are helping answer your questions or diagnosing problems.
To learn how IBM Electronic Services can work for you, visit
Back to top
|
|
| Prices |
|
Contact your IBM representative for charges information for this announcement.
Trademarks
Back to top
Printable version