IBM DB2 for Linux, UNIX, and Windows product family, V11.1.2.2 provides new features and functionality

IBM Europe Software Announcement ZP17-0398
June 20, 2017

Table of contents
OverviewOverviewTechnical informationTechnical information
Key prerequisitesKey prerequisitesOrdering informationOrdering information
Planned availability datePlanned availability dateTerms and conditionsTerms and conditions
DescriptionDescriptionPricesPrices
Program numberProgram numberAnnouncement countriesAnnouncement countries
PublicationsPublications


Top rule
At a glance
Bottom rule

IBM® DB2® for Linux™, UNIX™, and Windows™ product family, V11.1.2.2 offers enhancements for recoverability, performance, and JSON.



Back to topBack to top

Top rule
Overview
Bottom rule

DB2 for Linux, UNIX, and Windows product family, V11.1.2.2 includes defect fixes and security patches along with new features and functionality. The changes help you:

  • Manage enterprise data
  • Improve programmer productivity
  • Enhance tooling capabilities
  • Deliver fast and robust connectivity to DB2 databases

DB2 for Linux, UNIX, and Windows continues to enhance features and functionality, offering:

  • Database Management System for the always available, mission-critical transactional, analytical, and mixed workload applications with security-rich features that protect data at rest or in-flight
  • A database that is designed to be simple to deploy, upgrade, and maintain, with continuous availability for transactional workloads of any size
  • Expanded, in-memory columnar technology that offers the improved scalability and performance for analytics and warehousing workloads
  • Significant feature enhancements to improve connectivity, with ease of application deployment, availability, and security for applications
  • Enhanced tooling capabilities to monitor, administer, and tune the performance of database environments
  • Updates to advanced recovery capabilities


Back to topBack to top

Top rule
Key prerequisites
Bottom rule

Supports Linux and UNIX.

For details, see the Software requirements section.



Back to topBack to top

Top rule
Planned availability date
Bottom rule

June 22, 2017



Back to topBack to top

Top rule
Description
Bottom rule

DB2 for Linux, UNIX, and Windows, V11.1.2.2 delivers new functional enhancements to the products identified below:

  • Recoverability enhancements:
    • A database can be connectable during the backward phase of crash-recovery
    • Improved rollback performance
    • Eliminated bottle necking of DGTT log-records
    • Global Lock Manager recovery design improvements, including improved hashing algorithms and increased parallelism for reducing the recovery window
    • New recovery design benefits pureScale® deployments, particularly large clusters configured with huge lock list, Global Lock Manager, and global buffer pool
    • Ability to recover an erroneous tablespace on the HADR Standby
  • Performance enhancements:
    • Parallel insert for BLU (columnar) data
    • Faster query performance with BLU synopsis tables
    • Improved text search performance
    • Runtime improvements for SAP Core Data Services
  • JSON enhancements:
    • Full support for direct SQL access to underlying JSON interfaces

New DB2 Developer-C Edition V11.1.2.2: This new community-supported edition enables developers to utilize all advanced features and functionality of DB2 to develop new innovative applications for database environments supporting pureScale, BLU Acceleration®, compression, encryption, and database partitioning.

DB2 Connect™ V11.1.2.2 integrates IBM DB2 for z/OS®, IBM DB2 for i, and other enterprise data with client/server, web, and service-oriented architecture (SOA) applications. This solution is designed to manage access to your enterprise information wherever it is stored. For those enterprises that rely on DB2 for z/OS and DB2 for i servers as the cornerstone of their agile business, DB2 Connect delivers improved application enablement and a robust, highly scalable communications infrastructure for connecting web, Windows, UNIX, and Linux applications to data. DB2 Connect 11.1.2.2 improves connectivity, including updates for:

  • Expansion of .NET environments:
    • .Net Core and EF Core support
  • Manageability enhancements:
    • Increasing diagnostic data to serviceability log
    • Options to Limit CLI trace size
  • Performance improvements
    • Data Access Accelerator Support in JCC with JDK1.8
  • Security enhancements
    • PKICard Client certificate support in JCC
    • New configuration property for TLS Support in JCC
    • Configurable property for KeyStore[Location|Password|Type] in JCC
  • Expanded IBM environments
    • IMS™ T4 Connectivity enables communication from IMS to distributed applications
    • Support for IBM i 7.3

DB2 Advanced Recovery Feature V11.1.2.2 is a bundle of advanced database backup, recovery, and data extraction tools that can help you improve data availability, mitigate risk, and accelerate crucial administrative tasks when time is of the essence. A new feature is support for DB2 native encryption.

The Advanced Recovery Feature bundle contains releases of the following tools:

  • IBM DB2 Merge Backup for Linux, UNIX, and Windows, V3.1.0.1
  • IBM DB2 Recovery Expert for Linux, UNIX, and Windows, V5.1.0.1
  • IBM Optim™ High Performance Unload for DB2 for Linux, UNIX, and Windows V6.1.0.1

DB2 Performance Management Offering V11.1.2.2 with Data Server Manager V2.1.4 is a streamlined, scalable solution that can be used to administer, monitor, manage, and optimize the performance of DB2 for Linux, UNIX, and Windows databases across the enterprise. New features include:

  • Easy setup for cross-enterprise federated data sources
  • Data Server Manager Security enhancements for:
    • Kerberos
    • Multifactor authentication
  • Accelerate hybrid problem determination
    • Redesigned home page card and grid views for faster hot spot identification and large data enterprise management
    • Additional Key Performance Indicator - Data Server CPU
    • Active hotspot drill down for in-depth historical monitoring
    • Statement history for MPP by member
    • Enhanced DB2 privilege and authority management

For more information on the specific details of the enhancements and new features, see IBM Knowledge Center.

Accessibility by people with disabilities

A US Section 508 Voluntary Product Accessibility Template (VPAT), containing details about accessibility compliance, can be found on the Product accessibility information website.



Back to topBack to top

Top rule
Reference information
Bottom rule

For information on the previous DB2 announcement, see Software Announcement ZP16-0221, dated December 13, 2016, and Software Announcement ZP16-0191, dated April 12, 2016.



Back to topBack to top

Top rule
Program number
Bottom rule
Program number VRM Program name
5725-T27 V11.1.2.2 IBM DB2 Performance Management Offering
5725-Z98 V11.1.2.2 IBM DB2 Direct Standard Edition
5725-Z99 V11.1.2.2 IBM DB2 Direct Advanced Edition


Back to topBack to top

Top rule
Offering Information
Bottom rule

Product information is available on the IBM Offering Information website.

More information is also available on the Passport Advantage® and Passport Advantage Express® website.



Back to topBack to top

Top rule
Publications
Bottom rule

Technical documentation can be found in IBM Knowledge Center.



Back to topBack to top

Top rule
Services
Bottom rule

Global Technology Services

Contact your IBM representative for the list of selected services available in your country, either as standard or customized offerings for the efficient installation, implementation, or integration of this product.



Back to topBack to top

Top rule
Technical information
Bottom rule

Specified operating environment

Software requirements

The operating system support level for various DB2 products is frequently updated. To obtain the current information for supported software levels, including recommended maintenance levels, go to the DB2 for Linux, UNIX, and Windows website.

Planning information

Packaging

For DB2 V11.1.2.2, see the License Information number section.



Back to topBack to top

Top rule
Ordering information
Bottom rule

For ordering information, consult your IBM representative or authorized IBM Business Partner, or go to the Passport Advantage website.

  • IBM DB2 Performance Management Offering (5725-T27)
  • IBM DB2 Direct Standard Edition (5725-Z98)
  • IBM DB2 Direct Advanced Edition (5725-Z99)


Passport Advantage

Program description Part number
IBM DB2 PMO for Direct Standard Edition for Non-Production Environments Virtual Processor Core Monthly License D1TSXLL
IBM DB2 PMO for Direct Standard Edition for Non-Production Environments Linux for System z® Virtual Processor Core Monthly License D1TT0LL
IBM DB2 Direct Standard Edition for Non-Production Environments Virtual Processor Core Monthly License D1TLELL
IBM DB2 Direct Standard Edition for Non-Production Environments Linux for System z Virtual Processor Core Monthly License D1TLHLL
IBM DB2 Direct Advanced Edition for Non-Production Environments Virtual Processor Core Monthly License D1TLKLL
IBM DB2 Direct Advanced Edition for Non-Production Environments Linux for System z Virtual Processor Core Monthly License D1TLNLL

Charge metric

Program name PID number Charge metric
IBM DB2 Performance Management Offering 5725-T27 Virtual Processor Core
IBM DB2 Direct Standard Edition 5725-Z98 Virtual Processor Core
IBM DB2 Direct Advanced Edition 5725-Z99 Virtual Processor Core

Virtual Processor Core

Virtual Processor Core is a unit of measure by which the program can be licensed. A physical server is a physical computer that is comprised of processing units, memory, and input/output capabilities and that executes requested procedures, commands, or applications for one or more users or client devices. Where racks, blade enclosures, or other similar equipment is being employed, each separable physical device (for example, a blade or a rack-mounted device) that has the required components is considered itself a separate physical server. A virtual server is either a virtual computer created by partitioning the resources available to a physical server or an unpartitioned physical server. A processor core (commonly called a processor or CPU ) is a functional unit within a computing device that interprets and executes instructions. A processor core consists of at least an instruction control unit, and one or more arithmetic or logic unit. A virtual processor core is a processor core in an unpartitioned physical server, or a virtual core assigned to a virtual server. Licensee must obtain entitlement for each virtual processor core made available to the program.

Note: Some programs may require licenses for the program of the lesser of the sum of all virtual cores or all physical cores. In that case, the following applies. For each physical server, Licensee must have sufficient entitlements for the lesser of 1) the sum of all available virtual processor cores on all virtual servers made available to the program or 2) all available processor cores on the physical server.



Back to topBack to top

Top rule
Terms and conditions
Bottom rule

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage Agreement, and the IBM Agreement for Acquisition of Software Maintenance.

Licensing

IBM International Program License Agreement including the License Information document and Proof of Entitlement (PoE) govern your use of the program. PoEs are required for all authorized use. Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.

Agreement for Acquisition of Software Maintenance

These programs are licensed under the IBM Program License Agreement (IPLA) and the associated Agreement for Acquisition of Software Maintenance, which provide for support with ongoing access to releases and versions of the program. IBM includes one year of Software Subscription and Support (also referred to as Software Maintenance) with the initial license acquisition of each program acquired. The initial period of Software Subscription and Support can be extended by the purchase of a renewal option, if available. These programs have a one-time license charge for use of the program and an annual renewable charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours), as well as access to updates, releases, and versions of the program as long as support is in effect.

License Information number

Program name LI number
IBM DB2 Performance Management Offering L-EFUL-AKAMPS
IBM DB2 Direct Standard Edition L-EFUL-AKAMEP
IBM DB2 Direct Advanced Edition L-EFUL-AKAMF9

See the License Information documents page on the IBM Software License Agreement website for more information.

Limited warranty applies

Yes

Limited warranty

IBM warrants that when the program is used in the specified operating environment, it will conform to its specifications. The warranty applies only to the unmodified portion of the program. IBM does not warrant uninterrupted or error-free operation of the program or that IBM will correct all program defects. You are responsible for the results obtained from the use of the program.

IBM provides you with access to IBM databases containing information on known program defects, defect corrections, restrictions, and bypasses at no additional charge. For further information, see the IBM Software Support Handbook.

IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Money-back guarantee

If for any reason you are dissatisfied with the program and you are the original licensee, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the refund.

For clarification, note that (1) for programs acquired under the IBM International Passport Advantage offering, this term applies only to your first acquisition of the program and (2) for programs acquired under any of IBM's On/Off Capacity on Demand (On/Off CoD) software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.

Volume orders (IVO)

No

Passport Advantage applies

Yes, information is available on the Passport Advantage and Passport Advantage Express website.

Software Subscription and Support applies

Yes. Software Subscription and Support, also referred to as Software Maintenance, is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and Technical Support are provided by the Software Subscription and Support offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software, and Technical Support provides voice and electronic access to IBM support organizations, worldwide.

IBM includes one year of Software Subscription and Support with each program license acquired. The initial period of Software Subscription and Support can be extended by the purchase of a renewal option, if available.

While your Software Subscription and Support is in effect, IBM provides you assistance for your routine, short duration installation and usage (how-to) questions, and code-related questions. IBM provides assistance by telephone and, if available, electronic access, only to your information systems (IS) technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. (This assistance is not available to your users.) IBM provides Severity 1 assistance 24 hours a day, 7 days a week. For additional details, see the IBM Software Support Handbook. Software Subscription and Support does not include assistance for the design and development of applications, your use of programs in other than their specified operating environment, or failures caused by products for which IBM is not responsible under the applicable agreements.

Unless specified otherwise in a written agreement with you, IBM does not provide support for third-party products that were not provided by IBM. Ensure that when contacting IBM for covered support, you follow problem determination and other instructions that IBM provides, included in the IBM Software Support Handbook.

For additional information about the International Passport Advantage Agreement and the IBM International Passport Advantage Express Agreement, go to the Passport Advantage and Passport Advantage Express website.

Variable charges apply

No

Educational allowance available

Education allowance does not apply. Education software allowance does not apply. Special education prices are available for qualified customers through Passport Advantage.



Back to topBack to top

Top rule
Statement of good security practices
Bottom rule

IT system security involves protecting systems and information through intrusion 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 regulatory compliant, 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 topBack to top

Top rule
Prices
Bottom rule

For all local charges, contact your IBM representative.


Business Partner information

If you are an IBM Business Partner -- Distributor for Workstation Software acquiring products from IBM, you may link to Passport Advantage Online for resellers where you can obtain Business Partner pricing information. An IBMid and password are required to access the IBM Passport Advantage website.


Passport Advantage

For Passport Advantage information and charges, contact your IBM representative. Additional information is also available on the Passport Advantage and Passport Advantage Express website.



Back to topBack to top

Top rule
Announcement countries
Bottom rule

All European, Middle Eastern, and African countries, except Islamic Republic of Iran, Sudan, and Syrian Arab Republic.

Trademarks

DB2 Connect, IMS and Optim are trademarks of IBM Corporation in the United States, other countries, or both.

IBM, DB2, Global Technology Services, PartnerWorld, Passport Advantage, Express, pureScale, BLU Acceleration, z/OS and System z 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.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Windows is a trademark of Microsoft Corporation in the United States, other countries, or both.

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. Reference to other products in this announcement does not necessarily imply those products are announced, or intend to be announced, in your country. Additional terms of use are located at

Terms of use

For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page

IBM Directory of worldwide contacts

Contact IBM

Feedback