IBM Db2 for z/OS enriches the Query Management Facility Enterprise Edition Advanced feature with enhanced cross-QMF client interoperability, additional data access, and improved cost-effectiveness
IBM United States Software Announcement 218-261May 15, 2018
ENUS218-261.PDF| Table of contents | ||||||||||||||||||||
|
Revised Description section.
At a glance
The new Query Management Facility™ (QMF™) Enterprise Edition Advanced feature of IBM® Db2® 12 for z/OS® delivers the robust functionality available in the QMF Enterprise Edition feature, and is enhanced with a new TSO Client and QMF Server that enhances cross-QMF client interoperability, provides additional data access, and improves cost-effectiveness. It also advances self-service business intelligence (BI) capabilities with augmented analytics and visualizations and support for more data types and programs.
The Db2 for z/OS base delivers infrastructure for getting and controlling the adoption of new Db2 capabilities in function levels, new encryption capabilities, security improvements, and performance enhancements, all in the single maintenance service stream.
Back to top
Overview
The QMF Enterprise Edition Advanced feature offers significant performance improvements:
- The new QMF Server interconnects objects created across all QMF clients, making any QMF object accessible from any QMF client, regardless of which client created the object. It also improves cost-effectiveness, as the processing of the queries is zIIP eligible, including TSO and batch queries. The new QMF Server runs on IBM z/OS, Linux®, or Microsoft™ Windows™.
- The new QMF Z Client delivers significant usability and productivity additions to give TSO users a user experience that has a more modern look and feel. Users can open multiple queries and toggle between them from the new QMF Home Panel.
- The self-service BI capabilities are enhanced with augmented analytics and visualization that help users discover, analyze, and make decisions on data in a collaborative and intuitive environment.
The Db2 for z/OS base delivers continuous delivery infrastructure that enables you to get new Db2 capabilities faster and control the adoption of new capabilities with function levels, all without waiting for a new Db2 release.
The Db2 for z/OS base also continues to deliver new capabilities and enhancements in the service stream for ease of consumption, such as more reliable disaster recovery with Geographically Dispersed Parallel Sysplex™ (GDPS®) active/active, powerful new analytics capabilities with IBM Db2 Analytics Accelerator (IDAA), more secure and efficient access to Db2 data with native REST services, transparent encryption of Db2 data with z/OS DFSMS data set encryption, and more.
Back to top
Key prerequisites
The QMF Enterprise Edition Advanced feature operates on any IBM Z® hardware configuration that supports the required software. See the Hardware requirements and Software requirements sections in Software Announcement 218-221, dated May 15, 2018, for further details about the QMF Enterprise Edition Advanced feature.
Back to top
Planned availability date
June 15, 2018
Back to top
Description
The Db2 12 for z/OS, QMF Enterprise Edition Advanced feature has been enhanced with the following new capabilities:
TSO Client helps deliver CPU savings
A new TSO Client gives users the ability to deliver CPU savings as work submitted from this new TSO interface is zIIP eligible. This is of significant importance as the zIIP eligibility can be extended to batch workloads, procedures, and ad hoc queries, which makes the new TSO interface an important way to minimize costs as workload increases.
The TSO Client offers usability and productivity features designed to help QMF users edit and administer QMF objects such as intuitive list filtering and simultaneous multiple object editing. It also offers the ability to seamlessly share objects created in the new client across the other QMF clients (TSO, web, workstation, and Vision) without the need for client-specific configuration or tuning.
Common centralized server connects the entire QMF ecosystem
QMF introduces a common centralized server to connect the entire QMF ecosystem, simplify installation and configuration, and help you leverage your data and queries. The QMF Server is written in Java™ and architected to exploit the advantages delivered by IBM Z for Java workloads.
The new TSO Client is referred to as the QMF Z Client and delivers significant productivity improvements to QMF TSO users, including major improvements for working with QMF objects and integration with the wider QMF ecosystem. A new, customizable home panel provides instant access to your favorite and recently used QMF objects and recent commands. When listing objects, you can quickly and easily filter and sort the list, add an object to your favorites, and filter to objects modified within a number of days, months, and so on, all interactively and while supporting screen sizes up to 98 x 160.
You can now have multiple QMF objects open and easily switch between them, including between multiple edit windows using the improved, built-in Query and Procedure Editor. Mouse support, along with right-click, context-sensitive menus and drop-down menus, helps both the experienced and novice user to complete tasks in less time. QMF Workstation and IBM WebSphere® objects previously limited to distributed platform users can now be used by your TSO users, enabling QMF objects to be shared across all UIs and the ability to build QMF objects once and use them anywhere.
Common QMF Server: Key benefits
- The QMF Server runs on zIIP engines, making MSU savings and improved performance possible.
- The server can be deployed on z/OS, Linux, UNIX®, and Windows. This gives QMF users the ability to individually choose the best platform deployment option for the QMF Server, QMF Clients, and QMF workloads.
- Users can choose to put the QMF Server close to the data to reduce the load on the network and improve performance.
- Multiple QMF Servers are supported to bring the execution closer to the data. For example, if you need to query data on Db2 on the Linux platform and data on IBM Db2 for z/OS, you could set up a QMF Server on the z/OS platform for the Db2 for z/OS queries and one on the Linux platform for Db2 queries. QMF will route the work to the QMF Server you chose, improving performance.
- Direct database support to relational data sources using JDBC on IBM Z or distributed platforms. This is in addition to existing data source access using the QMF Data Service, which can access relational and nonrelational data sources.
- One instance of the QMF Server can handle multiple user components: TSO, workstation, web, and Vision. This eliminates the need to set up servers for each of the specific QMF components.
- Mainframe users can create, access, and reuse the newer QMF objects, such as Visual Queries and JavaScript™ procedures.
- Simple and consistent setup for all users, both mainframe and distributed.
- JavaScript is now supported for QMF procedures.
- To experience the benefits of the new QMF Server, batch jobs need to be updated to run under the new QMF Server.
New QMF TSO user experience: Key benefits
- Productivity and usability improvements for TSO users:
- New home panel provides instant access to your favorite and recently used QMF objects and commands.
- Major improvements for listing and editing your QMF objects.
- Easily switch between open QMF objects and actions.
- Mouse support with right-click, context-sensitive menus and drop-down menus.
- Seamless integration with QMF Workstation and WebSphere and the broader QMF ecosystem.
- Share QMF objects across all UIs: build it once, use it anywhere.
- Do QMF tasks in less time, including tasks previously not possible.
The self-service BI capabilities of the QMF Vision component are enhanced with new automatic dashboarding, JSON support, and multitenancy.
QMF Vision key highlights:
- Automatic dashboarding capabilities that are driven by analytics, which can be used as a starting point in discovery, analysis, and decision-making processes.
- Expands platform support to Linux.
- Dashboard publishing that can enable embedding in web pages.
- Support for network relationship diagram/chart.
- Support for annotations on dashboards.
- Support for JSON format data sources.
- Support for QMF-prompted queries.
- Simplified adding of multiple data sources to a dashboard.
The Db2 for z/OS base is enhanced with the following new capabilities:
Improved disaster recovery with GDPS Active/Active support
GDPS Active/Active can be used for planned site switches and also for maintenance activities. This capability is currently available in the Db2 11 for z/OS service stream.
New analytics capabilities with IBM Db2 Analytics Accelerator (IDAA)
New capabilities delivered in the service stream provide support for IDAA V6, target accelerator, HTAP for dynamic queries, IDAA catalog UTS migration, and HTAP data coherency.
Native RESTful support
Db2 REST unleashes your enterprise data and applications on Db2 for z/OS for the API economy, with more efficient and secure access to Db2 for z/OS data.
Mobile and cloud application developers can use consumable and scalable RESTful services by using any REST client. They can use these services to securely interact with business-critical data and transactions, without special Db2 for z/OS expertise.
The latest service update to the Db2 REST services support introduces the new BIND SERVICE and FREE SERVICE subcommands. Db2 database administrators (DBAs) can issue these DSN commands to create and drop user-defined REST services the same way as they use BIND PACKAGE and FREE PACKAGE for normal application package creation and deletion.
Db2 as a Service (Db2 aaS): RESTful APIs and automation improves developer self-service and DevOps results. Db2 REST services support is available in the DB2® 11 service stream.
Transparent Data Encryption support
Db2 for z/OS supports z/OS DFSMS data set encryption to encrypt DB2 data sets. Db2 supports Secure Socket Layer (SSL) protocol by using the z/OS Communications Server IP Application Transparent Transport.
zHyperlink support
zHyperlink support provides database synchronous read I/O exploitation and performance improvements.
In a well-tuned environment, this feature can improve average response latencies for database page reads in online transactions.
New system parameters to enable the feature are introduced, along with instrumentation to estimate the potential benefit of using zHyperLink read support and instrumentation to report the results of zHyperLink requests.
For a current list of Db2 12 capabilities available in function levels, see What's new in Db2 12 function levels.
For a current list of service-stream Db2 APARs, see Highlighted new capabilities in the Db2 12 base release.
For a current summary of all external changes in Db2 12, see What's changed in DB2 12. You can also find this information collected in the latest edition of Db2 12 for z/OS What's new?.
For a more in-depth overview of continuous delivery in Db2 12, see the IBM Redpaper™ publication Exploring IBM DB2 for z/OS Continuous Delivery.
Section 508 of the US Rehabilitation Act
IBM Db2 12 for z/OS, QMF Enterprise Edition Advanced feature, is capable as of June 15, 2018, when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it. A US Section 508 Voluntary Product Accessibility Template (VPAT) can be requested at the Product accessibility information website.
Back to top
Hardware and software support services
SmoothStart/installation services
IBM SmoothStart Services and Installation Services are offered in conjunction with general availability of this product.
Back to top
Program number
| Program number | VRM | Program name |
|---|---|---|
| 5650-DB2® | 12.1.0 | Db2 12 for z/OS, QMF Enterprise Edition Advanced feature |
Back to top
Business Partner information
If you are a Direct Reseller - System Reseller acquiring products from IBM, you may link directly to Business Partner information for this announcement. A PartnerWorld® ID and password are required (use IBMid).
Back to top
Technical information
Specified operating environment
Hardware requirements
For details of the hardware requirements for the QMF Enterprise Edition Advanced feature, see Software Announcement 218-221, dated May 15, 2018.
Software requirements
For the mandatory installation requirements for the QMF Enterprise Edition Advanced feature, see Software Announcement 218-221, dated May 15, 2018.
User group requirements
This announcement satisfies or partially satisfies 202 Db2 for z/OS and Db2 Utilities Suite for z/OS V12 requirements from one or more of the worldwide user group communities. Requirements satisfied include the following, which were identified as Delivered following the general availability announcement of Db2 12 for z/OS and Db2 Utilities Suite for z/OS V12:
| Request for enhancement | Description |
|---|---|
| 20606 | Provide the ability to define temporal referential integrity for temporal tables with business time. |
| 20906 | Option to specify SQLID to use for DB2 installation clist DSNTINST |
| 20921 | Better messaging from BACKUP and RESTORE SYSTEM UTILITIES |
| 21406 | Performance improvement through Vendor scratch pad feature |
| 21620 | Built in function for CRC on DB2 for z/OS. |
| 21653 | Single Bufferpool with pagefix YES and 1MB page size support multiple DB2 object (TS & IX) CISIZE definitions. |
| 21654 | Return a -905 error code rather than a -4499 (asutime limit reached on stored procedure) or issue an SQLSTATE which correlate |
| 21656 | eliminate unnecessary sort |
| 21660 | UNLOAD utility BP impact reduction |
| 21665 | Increase active log pairs from current limit to 400 |
| 21671 | Native Stored Procedure source deployment process |
| 22127 | Incorporate PK58338 into the DB2 for z/OS maintenance stream |
| 22129 | Break down remote client statistics by IP address / location for high water mark data |
| 22132 | IFCID 306 gets dictionary not found, RC00C90064, after DSN1COPY of compressed tablespace is imported to a new system. |
| 22558 | Authorization enhancement: Enable a Plan for a named executable program |
| 22657 | DB2 optimizer enhancements |
| 23020 | FR537: Stored procedure to submit z/OS console commands |
| 23287 | Use functional ID's to be used in lieu of PUBLIC on DB2 install GRANTs |
| 23288 | Add the RETAIN keyword to all BIND PLAN statements in the DSNTI* and DSNTE* jobs |
| 23527 | DSNULI needs to work with IMS™ |
| 23762 | API SQLESETI has tenga more capacity copy information to SMF101 (DB2 for z/OS) |
| 23835 | Avoiding DEADLOCK for SYSDBASE at LOAD REPLACE for a same tablespace but different parts |
| 23847 | PARSE_TYPE 'LS' (for LOBs) for SP ADMIN_COMMAND_DB |
| 23983 | FR539: BIND QUERY via ADMIN_COMMAND_DSN should respect CURRENT SQLID |
| 24006 | Improving the GRECP Recovery |
| 24009 | Overestimation of filter factors |
| 24316 | SAP FR501: Simplify creation of all tables required by EXPLAIN |
| 24469 | CAF support for Trusted Context definitions |
| 24537 | DB2 subsystem level roll back |
| 24993 | IFCID 23 and 25 timestamp or RBA when utility actually takes effect |
| 25019 | Increase REST UDF capacity for HTTPGETCLOB |
| 25269 | DSNHPC7 support in the next coming DB2 releases or disclose EOS date if it is in plan |
| 25332 | Will DSNHPC7 be supported in the next DB2 version (V11). |
| 25441 | FR449: RESTORE SYSTEM messages from hsm |
| 25883 | Provide DB2 GRECP status during DB2 startup |
| 25934 | 249-VLDB2011: Data Availability and Performance Improvements Using RTS |
| 25936 | 42-VLDB Online reorg -- eliminate abends and timeouts |
| 25944 | 234-VLDB2011: Improve performance of part-level reorg with large NPI (also include DPSIs) |
| 25946 | 238-VLDB2011: Hybrid PBR/PBG tablespace |
| 25951 | 54-VLDB: Runstats management and consumption of CPU and DBA time |
| 25953 | 124-VLDB: Online Conversion of Segmented Tables to Partitioned Tables |
| 25986 | Request for optimized data transition from IDAA to DB2 when moderately result set involved |
| 26702 | Improve concurrency of COPYTOCOPY |
| 26741 | DB2 LISTDEF Processing to Generate RC4 When Produced List is Empty |
| 27161 | DB2 z/OS REORG Utility REORG REBALANCE SHRLEVEL CHANGE |
| 27163 | Add REST User Definded Functions to DB2 z/OS |
| 27201 | Reorg rebalance with shrlevel change |
| 27392 | REORG Flashcopy avoid potential Copy Pending |
| 27801 | Remove IDAA offload restrictions for 'short-running' access paths |
| 27820 | FR548: Part-level Runstats with NPIs |
| 27933 | IDAA's support of LOB column (partial/initial support) |
| 28258 | Conserve RTS statistics past a DB2 RECOVER TOLOGPOINT |
| 28424 | Provide more reliability for better query access path decisions |
| 28425 | Provide 'number of rows' additional to 'number of SQL calls' |
| 28441 | Sort avoidance during merge scan join |
| 28458 | REORG of a Partition by Growth TS |
| 28465 | MODIFY RECOVERY DELETE DATASETNOTFOUND Option |
| 28474 | REORG REBALANCE add compression dictionary |
| 28477 | ALIAS for SEQUENCES (DDL-Enhancement) |
| 28479 | reverse scalar function for MIDNIGTH SECONDS |
| 28489 | particular inline-copy-datasets per tablespacepartition |
| 28581 | Give Package awareness to RLFPKG column of DSNRLSTxx |
| 28951 | Add the Large parameter in Template |
| 29735 | Provide workload balancing mechanism among multiple IDAAs |
| 30295 | Add temporal component to RTS tables |
| 30299 | Have a HASH scalar function in DB2 |
| 30543 | Online QUIESCE |
| 30978 | DB2 as a Service |
| 31373 | Implicit casting of a date/string representation of a date to a timestamp |
| 31529 | Auto-LPL recovery to output DSNI022I messages based on a timer |
| 31677 | Request FIXCAT for DB2 TargetSystem-RequiredService |
| 32322 | UTS PBG in workfiles |
| 33022 | DSNACCOX more scalable |
| 33191 | DB2 WLM 64-bit JAVA support |
| 33250 | TRUNCATE in DSNUTILB |
| 33717 | FR553: Enable DROP ALIAS, RENAME TABLE, CREATE ALIAS with concurrent DML access to alias |
| 33939 | IDAA selection by user |
| 34162 | DB2 v10 enhancement which allows IFI 306 to access dictionary pages ( the compressed table) |
| 34163 | DB2 v10 enhancement which allows compression dictionary pages built by insert being written to DASD as soon as being built. |
| 34472 | DB2 for z/OS we want job DSNTXAZP to catch the datasharing group attach name and populate GRPATTNM field |
| 34796 | UNLOAD, PUNCH file option |
| 35025 | 255 VLDB2012 - Maintain consistent SWITCH phase execution times, maybe fast replication failures |
| 35154 | Would like DB2 to interpret HSM messages and give us DB2 messages. |
| 35276 | Collect utility statistics(LOAD) in RTS |
| 35324 | Different retrieval of next sequence value by using VALUES clause |
| 36101 | DB2 V10 Load Resume Into A PBG |
| 36145 | Enhance Load and Unload |
| 36242 | I need module DSN1SMFP in DB2 V10 |
| 37020 | Deliver new function that is compatible with the V9 CHAR function |
| 37393 | LOAD/UNLOAD DELIMITED utility fails with DSNU1141I INVALID DELIMITER CHARACTER |
| 37713 | Better XML-support in DB2 z/OS utilities |
| 37817 | Automatic Startup of Profiles during subsystem startup |
| 38213 | DB2 - data sharing member clean-up concurrency |
| 38400 | Update REORG utility so the locks on catalog and directory does not count on NUMLKUS |
| 38413 | BIND/REBIND - APREUSE with WARN option |
| 38757 | FR559: Immediate DROP TRIGGER |
| 38939 | Gather stats, when an index is created on a non-empty table |
| 39197 | OQWT: virtual IDAA for eligibility testing with targeted IDAA during 'EXPLAIN' |
| 39463 | Reassign Database Owner |
| 39541 | DB2 Profile Table: LOCATION_NAME can not be used for monitoring connections, although it's documented |
| 39545 | column REORG_LR_TS is not available for SYSIBM.SYSINDEXPART |
| 39608 | Prefer index access for newly created indexes on non-empty tables |
| 39651 | Provide STMTID and/or USERID, if reasoncode 00E70081 |
| 39983 | More than 1 candidate access path for a statement |
| 40090 | Allow suppression of +394/+395 SQLCODE during execution of dynamic SQL |
| 40689 | CURRENT DATE / CURRENT TIMESTAMP filter factor calculation limitation removal |
| 41632 | FR48: Online Reorg and Readers Drain |
| 41852 | Enhance display group |
| 41932 | Support Online LOAD Replace as a utility |
| 42014 | FR563: Allow online REORG on all DB2 catalog/directory objects |
| 42926 | Parallel threads (100+) from single distributed user. ASUTIME and thread limits cannot resolve the issue. |
| 43250 | Improve concurrency of COPYTOCOPY |
| 43354 | Optimizer enhancement - consider index lookaside for correlated subquery |
| 43364 | COPYTOCOPY places objects in a UTRW status causing concurrency problems with other utilities |
| 43365 | Create DB2 incremental image copy even when no data has changed. |
| 43596 | DB2 Grecp Recovery Completion Message for Automation Usage |
| 43635 | FR566: Report all DB2 directory tablespaces and indexes in DB2 Catalog |
| 43693 | supply SAMPLE JCL for DB2 Catalog and Directory REORG job in the SDSNSAMP LIBRARY |
| 43838 | Programmatic setting of correlation ID on the JDBC connection |
| 44326 | Provide Versioning support for Triggers w/SQLPL |
| 45648 | Starting DB2 v11 Subsystem with incompatible v9 Early Code |
| 46200 | Documentation update 'Deactivating data sharing members' |
| 48760 | Flexibility in deleting empty PBG partitions |
| 52740 | Reduce XML tablespace constraints |
| 52825 | Change owner of objects to (secondary) authorization id |
| 54348 | DB2 Recovery Issue - After Tablespace with "Define NO " Materialized |
| 54973 | Interface to Drain Readers and Writers |
| 55046 | VLDB 373 - After Each Retry Iteration Show DRAIN Blocker While REORG is Running. |
| 55051 | IBM Load resume doesn't support PARALLEL option for Partition by growth (PBG) tablespaces |
| 56004 | Enhance archive log command for RESTART |
| 56430 | IX on Expression and COLLATION_KEY |
| 56625 | Parameter SPRMMUP goes to ZPARM |
| 57715 | DB2 LOAD Enhancement - Discards |
| 57786 | 350 VLDB2014 - Eliminate human managed reorg and associated outages |
| 57864 | Estimating SQL Performance with Multi-row Operations without the need for an expensive Perfm trace. |
| 58235 | Changing bufferpool parms for an inactive data sharing member |
| 58580 | RFE for DB2 LUW |
| 58844 | Provide proper sample job with DDL of Hadoop support UDFs |
| 58872 | Create Part Level Copies When Reorging Multiple Tablespace Parts |
| 58977 | page registration process change for UNLOAD ISOLATION UR |
| 59548 | "open-ended" syslgrnx entries |
| 60972 | MODIFY RECOVERY - control action on COPY PENDING event |
| 61937 | PROFILE TABLE IMPLEMENTATION |
| 62400 | BSDS Update |
| 62572 | Local Timestamp w/TEMPLATE |
| 62657 | Improve time for Recover to RBA |
| 63402 | 357 VLDB - Eliminate Runstats Management by automatically collecting correct statistics without DBA involvement |
| 63481 | FR477: REORG on tables with NPI: <1 sec impact on business transactions |
| 65382 | DB2 for z/OS to provide support on EBCDIC MBCS CCSID 1379 |
| 65802 | give me an alternative for helping get past the year 2042 problem |
| 66391 | Extend the performance enhancement implemented for 'In-List' processing to more than 129 elements |
| 66447 | Increase the REORG usability on PBG tablespaces |
| 66538 | COPYTOCOPY: add a new parameter FROMLASTFLASHCOPY |
| 66569 | Exempt ALIAS DDL from Dynamic Cache contention (00E70081) |
| 66623 | Improved instrumentation for DB2 work/temp space |
| 68365 | Use results of index probing more broadly to estimate composite cardinalities |
| 68799 | SQLCODE = -214, ERROR: AN EXPRESSION in the following Position, or Starting with 1 in the order by clause is not valid |
| 68929 | DB2z should support recording all claimer and resource information in joblog when REORG drain unsuccessfully every time |
| 70033 | enable literal concentration on package level |
| 70285 | Performance Optimization for Java™ IMS |
| 72529 | Allow altering owners |
| 72826 | TCPALVER=SERVER_ENCRYPT support with Passtickets |
| 72948 | Support of UDF functions in CMA reports when using IDAA with TDS database on DB2 z/OS v10 |
| 73023 | Provide correct elapsed time for queries in IFCID 316 if query parallelism is used |
| 74940 | Add COPY_FASTREPLICATION zparm or additional parm to COPY statement |
| 75695 | ISF0114-1673 Provide Versioning support for Triggers w/SQLPL |
| 75707 | IPSG0913-1629 ALLOW OPTIMIZATION HINT FOR DYNAMIC SQL WITHOUT SQLCODES +394/+395 ISSUED |
| 77267 | new DDL TABLE COLUMN option to allow "FOR EACH ROW ON UPDATE UPDATE AS SESSION_USERID" |
| 77365 | LISTAGG |
| 77379 | Testability of DDF thread recycle feature |
| 77381 | CHECK DATA SHARELEVEL(CHANGE) provide alternative to requiring BYPASSACS authority for FlashCopy® |
| 78713 | Provide consistent results from PREPARE for all GENERATED ALWAYS column types. |
| 79544 | DB2 for z/OS to provide support on EBCDIC MBCS CCSID 1371 |
| 79614 | Allow MODIFY and RUNSTATS on RREPL tablespaces |
| 79701 | REORG doesn't move rows from one PBG partition to another unless the whole or a range of the tablespace's partitions are REOR |
| 80997 | Add optional ability to utilize System Temporal syntax on Insert/Update statements. |
| 81578 | LOAD RESUME: include the BACKOUT YES at partition level |
| 81961 | Avoid the sort during REORG using the order of the existing indexes. In such way the REORG will be faster and will save disks |
| 82144 | Optimization of joins should provide optimal performance with less manual intervention |
| 82993 | DB2 Function Improvement on lock control |
| 84886 | Show global claimers during DRAIN of REORG (option) |
| 87891 | Avoid abends due to bad input data in LOAD utility, just discard bad records instead. |
| 88728 | DB2 migration and installation panels should have a save function and the ability to continue where you left off. |
| 90125 | Unique Cache for identity column (and sequence) for all members of Data Sharing |
| 91096 | A new message should be produced for a bufferpool going from PGSTEAL(NONE) to PGSTEAL(FIFO) |
| 92750 | DB2 utility dataset closing algorithm |
| 93659 | DB2 Reorg classic to UTS - Parallelism SubTasks |
| 93695 | Run the Image copy for TS in check pending state after Load Utility. |
| 96001 | 31-bit Private Constraint Relief - Allow Customers to Reduce "Cushion" |
| 96060 | LOAD SHRLEVEL CHANGE provides the capability of retry logic upon receiving SQLCODE -911 or -913. |
| 96145 | Allow unload/reload parallelism processing in REORG when converting tablespace type |
| 96744 | IN-LIST performance enhancement for REORGs |
| 98089 | acronym for "fetch first row" only clause in DB2 (All platforms) |
| 99303 | 00C9009C (partition is full) |
| 100772 | New RLF-values should control also already submitted queries |
| 101069 | DB2 error handling during Move function should be the same as when outage occurs when a tran is waiting for open lock |
| 101198 | IRLM externalize with message for APAR PI76732 event |
| 102589 | Commit/Rollback persistent User-defined global variables |
| 106288 | GDPS A-A ZDL: BSDS duplexing feature in CDDS |
| 106517 | Avoid flooding of DSNB355I and DSNB356I |
| 106733 | Improve character conversion (CCSID 930 and 290) |
| 113996 | (RE)BIND option for handling all dynamic SQL having set ATTRIBUTES to 'CONCENTRATE STATEMENTS WITH LITERALS' in PREPARE stmt |
Planning information
Customer responsibilities
Db2 12 for z/OS migration considerations
Db2 12 is upwardly compatible with earlier releases of Db2 for z/OS. Migration with full fallback protection is available for clients running on Db2 11 for z/OS. Existing clients should ensure that they are successfully running on Db2 11 for z/OS (NFM) before migrating to Db2 12 for z/OS. Fallback SPE APAR PI33871 must be applied. Clients should also use FIX CATEGORIES IBM.Migrate-Fallback.DB2.V12 and IBM.Coexistence.DB2.SYSPLEXDataSharing to identify and apply fixes that enable prior releases of Db2 to migrate to or fall back from Db2 12 for z/OS and fixes that enable Db2 11 to co-exist when in data sharing mode, respectively.
For more information on FIXCAT, see the IBM Fix Category Values and Descriptions website.
For more information on Db2 12 incompatible changes for migration, deprecated functions, and functions that Db2 12 no longer supports, see What's changed in Db2 12.
Direct customer support
Direct customer support is provided by IBM Operational Support Services - SoftwareXcel Enterprise Edition or SoftwareXcel Basic Edition. These fee services can enhance your productivity by providing voice and electronic access into the IBM support organization. IBM Operational Support Services - SoftwareXcel Enterprise Edition or SoftwareXcel Basic Edition 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 888-426-4343.
Eligible customers can obtain installation and usage assistance from the Industry Support Center through a telephone response line.
Packaging
The following materials are included with the QMF Enterprise Edition Advanced feature of Db2 12 for z/OS:
| Title | Publication number |
|---|---|
| QMF Enterprise Edition Advanced feature: | |
| QMF Enterprise Edition Advanced Program Directory (ENU) | GI13-4627 |
| QMF Enterprise Edition Advanced Program Directory (MUL) | GI13-4628 |
| QMF Enterprise Edition Advanced (QMF Z Client) Program Directory (ENU and MUL) | GI13-5003 |
| Accessing QMF Enterprise Edition Advanced distributed components CD (ENU and MUL) | LCD4-8603 |
Source files for the distributed components of QMF Enterprise Edition Advanced feature must be downloaded from the IBM Web Membership (IWM) site. Physical DVD kits and ISO images will not be delivered with your order.
Obtaining QMF Enterprise Edition Advanced distributed components
- Verify that the purchase order that you received includes the above materials.
- Check for and download the latest technical update at Customer access portal for QMF.
- The Accessing QMF Enterprise Edition Advanced distributed components CD includes a "Memo to Users." The memo contains the product access key and the full URL to the IWM site where you can download the following source code and installation materials:
- QMF for Workstation and QMF Data Service Studio for installation on 32-bit Windows
- QMF for Workstation and QMF Data Service Studio for installation on 64-bit Windows
- QMF for WebSphere® and QMF Vision
- QMF Server
Back to top
Ordering information
Ordering z/OS through the Internet
Shopz provides an easy way to plan and order your z/OS ServerPac or CBPDO. It will analyze your current installation, determine the correct product migration, and present your new configuration based on z/OS. Additional products can also be added to your order (including determination of whether all product requisites are satisfied). Shopz is available in the US, Canada, and several countries in Europe. In countries where Shopz is not available yet, contact your IBM representative (or IBM Business Partner) to handle your order through the traditional IBM ordering process. For more details and availability, go to the Shopz website.
New licensees
Orders for new licenses can be placed now. Registered customers can access IBMLink for ordering information and charges. Shipment will not occur before the availability date.
New users of Db2 12 for z/OS, QMF Enterprise Edition Advanced feature, should specify:
- Type: 5650 Model: DB2
Parallel Sysplex license charge (PSLC)
Parallel Sysplex® license charge (PSLC) basic license
To order a basic license, specify the program number and quantity of MSU.
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 license options and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the System Usage Registration No-Charge (SYSUSGREG NC) Identifier on the licenses.
Program name: IBM Db2 12 for z/OS, QMF Enterprise Edition Advanced feature
Program PID: 5650-DB2
| Entitlement identifier | Description | License option/Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, PSLC below 3 MSU |
| Basic MLC, PSLC AD | ||
| SYSUSGREG NC, PSLC AD |
Advanced Workload License Charges (AWLC)
Advanced Workload License Charges (AWLC) basic license
To order a basic license, specify the program number and quantity of MSUs. 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 AWLC license options and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the System Usage Registration No-Charge (SYSUSGREG NC) Identifier on the licenses.
Program name: IBM Db2 12 for z/OS, QMF Enterprise Edition Advanced feature
Program PID: 5650-DB2
| Entitlement identifier | Description | License option/Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, AWLC |
Advanced Entry Workload License Charges (AEWLC)
Advanced Entry Workload License Charges (AEWLC) basic license
To order a basic license, specify the program number and quantity of MSUs.
Program name: IBM Db2 12 for z/OS, QMF Enterprise Edition Advanced feature
Program PID: 5650-DB2
| Entitlement identifier | Description | License option/Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, AEWLC |
Country Multiplex License Charges (CMLC)
Country Multiplex License Charges (CMLC) basic license
To order a basic license, specify the program number and quantity of MSUs.
If there is more than one program copy in a Country Multiplex, the charge for all copies is associated to one license if all the copies are licensed to one customer number within the multiplex. If there is more than one customer number, the charge for all copies is prorated to one license for each customer within the multiplex.
For each license being charged, specify the applicable CMLC license options and the prorated quantity of the Service Units in Millions (MSUs) for each customer number within the multiplex. For all other program copies, specify the Workload Registration No-Charge (WLREG NC) Identifier on the licenses.
Program name: IBM Db2 12 for z/OS, QMF Enterprise Edition Advanced feature
Program PID: 5650-DB2
| Entitlement identifier | Description | License option/Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, CMLC |
Variable Workload License Charge (VWLC)
Workload License Charge (WLC) Basic License
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 WLC license options and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the Workload Registration Variable WLC Identifier on the licenses.
Program name: IBM Db2 12 for z/OS, QMF Enterprise Edition Advanced feature
Program PID: 5650-DB2
| Entitlement identifier | Description | License option/Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, Variable WLC |
| Workload Registration, Variable WLC |
Entry Workload License Charge (EWLC)
Entry Workload License Charge (EWLC) Basic License
To order a basic license, specify the program number and the quantity of MSUs.
| Entitlement identifier | Description | License option/Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, Entry WLC |
z Systems entry license charge (zELC)
To order a basic license, specify the program number and machine model.
Program name: IBM Db2 12 for z/OS, QMF Enterprise Edition Advanced feature
Program PID: 5650-DB2
| Entitlement identifier | Description | License option/ Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, zELC |
Basic machine-readable material
Program name: IBM Db2 12 for z/OS, QMF Enterprise Edition Advanced feature
Program PID: 5650-DB2
| Orderable Supply ID | Language | Distribution medium | Description |
|---|---|---|---|
| S018BZD | US English | 1/2 Inch Data Cartridge - IBM 3590 - 30 GB 128 Track | QMF Enterprise Edition Advanced |
| S018BZF | Multilingual | 1/2 Inch Data Cartridge - IBM 3590 - 30 GB 128 Track | QMF Enterprise Edition Advanced |
Customization options
Not applicable
Publications
A memo and one copy of the following publications are supplied automatically with the basic machine-readable material:
| Title | Order number |
|---|---|
| QMF Enterprise Edition Advanced feature (ENU ) | |
| Program Directory | GI13-4627 |
| Program Directory (Z Client) | GI13-5003 |
| Accessing QMF Enterprise Edition distributed components CD | LCD4-8603 |
| QMF Enterprise Edition Advanced feature (MUL) | |
| Program Directory | GI13-4628 |
| Program Directory (Z Client) | GI13-5003 |
| Accessing QMF Enterprise Edition distributed components CD | LCD4-8603 |
Source files for the distributed components of QMF Enterprise Edition Advanced feature must be downloaded from the IBM Web Membership (IWM) site. Physical DVD kits and ISO images will not be delivered with your order.
Obtaining QMF Enterprise Edition Advanced distributed components
- Verify that the purchase order that you received includes the above materials.
- Check for and download the latest technical update at Customer access portal for QMF.
- The Accessing QMF Enterprise Edition Advanced distributed components CD includes a "Memo to Users." The memo contains the product access key and the full URL to the IWM site where you can download the following source code and installation materials:
- QMF for Workstation and QMF Data Service Studio for installation on 32-bit Windows
- QMF for Workstation and QMF Data Service Studio for installation on 64-bit Windows
- QMF for WebSphere and QMF Vision
- QMF Server
The following optional publications cannot be ordered in hardcopy. These publications are available in the Db2 Query Management Facility Library.
| Title | Order number |
|---|---|
| Db2 Query Management Facility for z/OS, V12.2 | |
| Introducing Db2 QMF | GC27-8876 |
| Installing and Managing Db2 QMF for TSO and CICS® | GC27-8877 |
| Developing Db2 QMF applications | SC27-8878 |
| Db2 QMF Reference | SC27-8880 |
| Db2 QMF Messages and Codes | GC27-8881 |
| Using Db2 QMF | SC27-8879 |
| Installing and Managing QMF for Workstation and QMF for WebSphere | GC27-8883 |
| Getting Started with QMF for Workstation and QMF for WebSphere | SC27-8884 |
| QMF High Performance Option User's Guide for TSO and CICS | SC27-8882 |
| Getting Started with QMF Vision | GC27-8889 |
| Db2 QMF Data Service Getting Started Guide | GC27-8885 |
| Db2 QMF Data Service Studio User's Guide | SC27-8886 |
| Db2 QMF Data Service Customization Guide | GC27-8888 |
| Db2 QMF Data Service Solution Guide | GC27-8887 |
| Getting Started with QMF Z Client | GC27-9134 |
| Installing and Managing Db2 QMF Server | GC27-9134 |
To order a previous edition of a publication, use the correct suffix level for the version desired.
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
Product deliverables are shipped only through CBPDO and ServerPac. These customized offerings are offered for internet delivery from Shopz. Internet delivery reduces software delivery time and allows you to install software without the need to handle tapes. For more details on internet delivery, go to the Help section on the Shopz website.
You choose the delivery method when you order the software. IBM recommends internet delivery. In addition to internet and DVD, the supported tape delivery options include:
- 3590
- 3592
Most products can be ordered in ServerPac the month following their availability in CBPDO. z/OS can be ordered through CBPDO and ServerPac at general availability. Many products will also be orderable in a Product ServerPac without also having to order the z/OS operating system or subsystem.
Shopz and CFSW will determine the eligibility based on product requisite checking. For more details on the product ServerPac, go to the Help section on the Shopz website.
For additional information on the Product ServerPac option, see Software Announcement 212-272, dated July 31, 2012.
Production of software product orders will begin on the planned general availability date.
- CBPDO shipments will begin one week after general availability.
- ServerPac shipments will begin two weeks after general availability.
Back to top
Terms and conditions
The terms for IBM Db2 12 for z/OS, as previously announced in Software Announcement 216-378, dated October 4, 2016, licensed under the IBM Customer Agreement are unaffected by this announcement.
Back to top
Statement of good security practices
IT system security involves protecting systems and information through prevention, detection, and response to improper access from within and outside your enterprise. Improper access can result in information being altered, destroyed, or misappropriated or can result in misuse of your systems to attack others. Without a comprehensive approach to security, no IT system or product should be considered completely secure and no single product or security measure can be completely effective in preventing improper access. IBM systems and products are designed to be part of a lawful, comprehensive security approach, which will necessarily involve additional operational procedures, and may require other systems, products, or services to be most effective.
Important: IBM does not warrant that any systems, products, or services are immune from, or will make your enterprise immune from, the malicious or illegal conduct of any party.
Back to top
IBM Electronic Services
Electronic Service Agent™ and the IBM Electronic Support web portal are dedicated to providing fast, exceptional support to IBM Systems customers. The IBM Electronic Service Agent tool is a no-additional-charge tool that proactively monitors and reports hardware events, such as system errors, performance issues, and inventory. The Electronic Service Agent tool can help you stay focused on your company's strategic business initiatives, save time, and spend less effort managing day-to-day IT maintenance issues. Servers enabled with this tool can be monitored remotely around the clock by IBM Support, all at no additional cost to you.
Now integrated into the base operating system of AIX® V5.3, AIX V6.1, and AIX V7.1, Electronic Service Agent is designed to automatically and electronically report system failures and utilization issues to IBM, which can result in faster problem resolution and increased availability. System configuration and inventory information collected by the Electronic Service Agent tool also can be viewed on the secure Electronic Support web portal, and used to improve problem determination and resolution by you and the IBM support team. To access the tool main menu, simply type smitty esa_main, and select Configure Electronic Service Agent. In addition, ESA now includes a powerful web user interface, giving the administrator easy access to status, tool settings, problem information, and filters. For more information and documentation on how to configure and use Electronic Service Agent, go to the IBM Electronic Support website.
The IBM Electronic Support portal is a single internet entry point that replaces the multiple entry points traditionally used to access IBM internet services and support. This portal enables you to gain easier access to IBM resources for assistance in resolving technical problems. The My Systems and Premium Search functions make it even easier for Electronic Service Agent tool-enabled customers to track system inventory and find pertinent fixes.
Benefits
Increased uptime: The Electronic Service Agent™ tool is designed to enhance the Warranty or Maintenance Agreement by providing faster hardware error reporting and uploading system information to IBM Support. This can translate to less wasted time monitoring the symptoms, diagnosing the error, and manually calling IBM Support to open a problem record. Its 24 x 7 monitoring and reporting mean intervention is not required to report errors.
Security: The Electronic Service Agent tool is designed to be secure in monitoring, reporting, and storing the data at IBM. The Electronic Service Agent tool is designed to securely transmit either through the internet (HTTPS or VPN) or modem to provide customers a single point of exit from their site. Communication is one way. Activating Electronic Service Agent does not enable IBM to call into a customer's system.
For additional information, go to the IBM Electronic Service Agent website.
More accurate reporting: Because system information and error logs are automatically uploaded to the IBM Support Center in conjunction with the service request, you are not required to find and send system information, decreasing the risk of misreported or misdiagnosed errors. Once inside IBM, problem error data is run through a data knowledge management system and knowledge articles are appended to the problem record.
Customized support: Using the IBMid entered during activation, you can view system and support information in the My Systems and Premium Search sections of the IBM Electronic Support page.
My Systems provides valuable reports of installed hardware and software using information collected from the systems by Electronic Service Agent. Reports are available for any system associated with your IBMid. Premium Search combines the function of search and the value of Electronic Service Agent information, providing advanced search of the technical support knowledgebase. Using Premium search and the Electronic Service Agent information that has been collected from your system, you are able to see search results that apply specifically to your systems.
For more information on how to utilize the power of IBM Electronic Services, contact your IBM Systems Services Representative, or go to the IBM Electronic Support website.
Back to top
Prices
For additional information and current prices, contact your local IBM representative or IBM Business Partner.
| Entitlement identifier | Description | License option/ Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, zELC |
| Entitlement identifier | Description | License option/ Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, PSLC below 3 MSU |
| Basic MLC, PSLC AD | ||
| SYSUSGREG NC, PSLC AD |
| Entitlement identifier | Description | License option/ Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, AWLC |
| Entitlement identifier | Description | License option/ Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, AEWLC |
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, CMLC |
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, Variable WLC |
| Workload Registration, Variable WLC |
Sub-capacity charges for AWLC, AEWLC, CMLC, zNALC, VWLC, EWLC, and MWLC products
Sub-capacity charges for eligible products are based on product LPAR utilization capacity. Product LPAR utilization capacity for a sub-capacity product is the highest number of MSUs utilized by the combined LPARs in which the product runs concurrently during a reporting period. The number of MSUs is based on the highest observed rolling 4-hour average utilization used by the combination of the relevant LPARs during the reporting period.
Sub-capacity charges terms and conditions
z Systems® software charges at less than full machine capacity for eligible sub-capacity products apply when z/OS, z/TPF, or z/VSE® is running in z/Architecture® (64-bit) mode on an IBM z Systems® server, no other MVS™-based, TPF-based, or VSE-based operating system respectively is licensed to that server, and the required information is provided by the customer in accordance with the applicable terms.
Sub-capacity charges for a sub-capacity product are based on the utilization of the LPARs where/when the product executes. To obtain charges at less than full machine capacity for sub-capacity products, the customer is required to:
- Sign and abide by the terms of one of the following:
- Attachment for IBM System z® Advanced Workload License Charges (Z125-8538)
- Attachment for IBM System z Advanced Entry Workload License Charges (Z125-8755)
- Attachment for IBM Country Multiplex Pricing (Z126-6965)
- Attachment for zNALC License Charges on IBM System z (Z125-7454)
- Attachment for IBM System z Workload License Charges (Z125-6516
- Attachment for EWLC, TWLC, zELC, and z/OS.e License Charges (Z125-6587)
- Attachment for IBM System z Midrange Workload License Charges (Z125-7452)
- Obtain the latest version of the Sub-Capacity Reporting Tool.
- Install any sub-capacity product and IBM z Systems Licensed Internal Code (LIC) service required for sub-capacity charging. Required service will be listed on the IBM z Systems Sub-Capacity website.
- Collect SMF or SCRT89 data as required by the Sub-Capacity Reporting Tool. Retain the collected data for a period of not less than six months.
- Use the IBM provided Sub-Capacity Reporting Tool to process the collected SMF or SCRT89 data. The Sub-Capacity Report produced by the tool is used to determine required license capacity for the sub-capacity products. Required license capacity is determined based on the largest MSU value of a sub-capacity product running concurrently in all LPARs during the reporting period. IBM reserves the right to request the system data that supports these product-defined capacity values for a period of up to six months after the data was collected.
- Provide an initial Sub-Capacity Report to begin to receive the benefits of less than full machine capacity charges. Sub-capacity charging will follow submission of a Sub-Capacity Report. There will be no retroactive application of sub-capacity charges.
- Submit Sub-Capacity Reports monthly between the second and ninth days of the month after the reporting period.
- Submit Sub-Capacity Reports for all sub-capacity products with complete data for the entire
reporting period via the method specified on the IBM z Systems Sub-Capacity website.
Sub-Capacity Reports that reflect a changed product defined capacity will be considered to be orders placed by the customer without further action on the customer's part, and IBM is authorized to make any resulting billing increase or decrease, including the ordering of any necessary new licenses. To discontinue licenses, move licenses between machines, report a hardware model upgrade, or enable or disable product features, the customer must contact IBM or their IBM Business Partner.
- Configure the machine to send weekly Transmit System Availability Data (TSAD) to IBM via the IBM z Systems Remote Support Facility (RSF). If the machine cannot connect via the RSF, provide this TSAD through an alternate means documented in the SCRT Users Guide (SG24-6522) publication on the IBM z Systems Sub-Capacity website.
Entry Workload License Charge (EWLC)
| Entitlement identifier | Description | License option/ Pricing metric |
|---|---|---|
| S018BZC | QMF Enterprise Ed Advanced | Basic MLC, Entry WLC |
Customers who pay a PLC and an ALC for a licensed program receive enhancements and future releases, if any, at no additional charge. Significant new functions may be offered as an optional feature and charged for separately. If a replacement program is announced and the customer elects to license the replacement program for a PLC/ALC and replace the prior program, an upgrade charge may apply.
The first payment consists of the primary license charge and the annual license charge. The annual license charge applies yearly thereafter.
For additional product information, see Software Announcement 216-378, dated October 4, 2016.
The applicable processor based one-time charge will be based on the group of the designated machine on which the program is licensed for use. If the program is designated to a processor in a group for which no charge is listed, the charge of the next higher group listed applies. For movement to a machine in a higher group, an upgrade charge equal to the difference in the then-current charges between the two groups will apply. For movement to a machine in a lower group, there will be no adjustment or refund of charges paid.
IBM Global Financing
IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, from both IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or go to the IBM Global Financing website for more information.
IBM Global Financing offerings are provided through IBM Credit LLC in the United States, and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.
Back to top
Order now
To order, contact the IBM Digital Sales Center or your local IBM representative. To identify your local IBM representative, call 800-IBM-4YOU (426-4968). For more information, contact the IBM Digital Sales Center.
Phone: 800-IBM-CALL (426-2255)
Fax: 800-2IBM-FAX (242-6329)
For IBM representative: askibm@ca.ibm.com
IBM Digital Sales Offices
1177 S Belt Line Rd
Coppell, TX 75019-4642, US
The IBM Digital Sales Center, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.
Note: Shipments will begin after the planned availability date.
Trademarks
Query Management Facility, QMF, Geographically Dispersed Parallel Sysplex, Redpaper, IMS, Electronic Service Agent and MVS are trademarks of IBM Corporation in the United States, other countries, or both.
IBM, Db2, z/OS, GDPS, IBM Z, PartnerWorld, System z, AIX, CICS, WebSphere, DB2, FlashCopy, Parallel Sysplex, z Systems, z/VSE, z/Architecture and IBM z Systems are registered trademarks of IBM Corporation in the United States, other countries, or both.
Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.
Microsoft and Windows are trademarks of Microsoft Corporation in the United States, other countries, or both.
Oracle and Java are trademarks of Oracle and/or its affiliates in the United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Other company, product, and service names may be trademarks or service marks of others.
Terms of use
IBM products and services which are announced and available in your country can be ordered under the applicable standard agreements, terms, conditions, and prices in effect at the time. IBM reserves the right to modify or withdraw this announcement at any time without notice. This announcement is provided for your information only. Additional terms of use are located at
For the most current information regarding IBM products, consult your IBM representative or reseller, or go to the IBM worldwide contacts page