5724-B62 IBM Db2 Connect Unlimited Edition for System z V11.5

IBM United States Sales Manual
Revised: May 12, 2020


Table of contents
Product life cycle datesProduct life cycle datesDescriptionDescription
Program numberProgram numberOperating environmentOperating environment
AbstractAbstractPlanning informationPlanning information
Product positioningProduct positioningPublicationsPublications
HighlightsHighlightsSecurity, auditability, and controlSecurity, auditability, and control


Product life cycle dates

Top rule

Program Number VRM Announced Available Marketing Withdrawn Service Discontinued
5724-B62 11.05.00 2019-10-29 2019-10-29 - -
5724-B62 11.01.00 2016-04-12 2016-06-15 - 2022-04-30
5724-B62 10.05.00 2013-04-23 2013-06-14 2016-09-30 2020-04-30
5724-B62 10.01.00 2012-04-03 2012-04-30 2016-04-12 2017-09-30
5724-B62 09.07.00 2009-05-19 2009-06-19 2013-11-12 2017-09-30
5724-B62 09.05.00 2007-10-16 2007-10-31 2013-02-13 2015-04-30
5724-B62 09.01.00 2006-06-07 2006-07-28 2011-01-20 2012-04-30
5724-B62 08.02.00 2004-08-17 2004-09-17 2008-01-25 2009-04-30
5724-B62 08.01.00 2002-09-17 2002-11-21 2007-01-19 2009-04-30
5765-F30 11.05.00 2019-10-29 2019-10-29 - -
5765-F30 11.01.00 2016-04-12 2016-06-15 - 2022-04-30
5765-F30 10.05.00 2013-04-23 2013-06-14 2016-09-30 2020-04-30
5765-F30 10.01.00 2012-04-03 2012-04-30 2016-04-12 2017-09-30
5765-F30 09.07.00 2009-05-19 2009-06-19 2013-11-12 2017-09-30
5765-F30 09.05.00 2007-10-16 2007-10-31 2013-02-13 2015-04-30
5765-F30 09.01.00 2006-06-07 2006-07-28 2011-01-21 2012-04-30
5765-F30 08.02.00 2004-08-17 2004-09-17 2008-01-25 2009-04-30
5765-F30 08.01.00 2002-09-17 2002-11-21 2007-01-19 2009-04-30
5724-Z19 11.05.00 2019-10-29 2019-10-29 - -
5724-Z19 11.01.00 2016-04-12 2016-06-15 - 2022-04-30
5724-Z19 10.05.00 2013-04-23 2013-06-14 2016-09-30 2020-04-30
5724-Z19 10.01.00 2012-04-03 2012-04-30 2016-04-12 2017-09-30
5724-Z19 09.07.00 2009-10-20 2009-10-20 2013-11-12 2017-09-30
5724-Z18 11.05.00 2019-10-29 2019-10-29 - -
5724-Z18 11.01.00 2016-04-12 2016-06-15 - 2022-04-30
5724-Z18 10.05.00 2013-04-23 2013-06-14 2016-09-30 2020-04-30
5724-Z18 10.01.00 2012-04-03 2012-04-30 2016-04-12 2017-09-30
5724-Z18 09.07.00 2009-10-20 2009-10-20 2013-11-12 2017-09-30
5724-M15 11.05.00 2019-10-29 2019-10-29 - -
5724-M15 11.01.00 2016-04-12 2016-06-15 - 2022-04-30
5724-M15 10.05.00 2013-04-23 2013-06-14 2016-09-30 2020-04-30
5724-M15 10.01.00 2012-04-03 2012-04-30 2016-04-12 2017-09-30
5724-M15 09.07.00 2009-05-19 2009-06-19 2013-11-12 2017-09-30
5724-M15 09.05.00 2007-10-16 2007-10-31 2013-02-13 2015-04-30
5724-M15 09.01.00 2006-06-07 2006-07-28 2011-01-21 2012-04-30
5724-D54 11.05.00 2019-10-29 2019-10-29 - -
5724-D54 11.01.01 2016-12-13 2016-12-15 - -
5724-D54 11.01.00 2016-04-12 2016-06-15 - 2022-04-30
5724-D54 10.05.00 2013-04-23 2013-06-14 2016-09-30 2020-04-30
5724-D54 10.01.00 2012-04-03 2012-04-30 2016-04-12 2017-09-30
5724-D54 09.07.00 2009-05-19 2009-06-19 2013-11-12 2017-09-30
5724-D54 09.05.00 2007-10-16 2007-10-31 2013-02-13 2015-04-30
5724-D54 09.01.00 2006-06-07 2006-07-28 2011-01-21 2012-04-30
5724-D54 08.02.00 2004-08-17 2004-09-17 2008-01-25 2009-04-30
5724-D54 08.01.00 2002-09-17 2002-11-21 2007-01-19 2009-04-30
5724-B56 10.01.00 2012-04-03 2012-04-30 - 2015-04-30
5724-B56 09.07.00 2009-05-19 2009-06-19 2013-11-12 2017-09-30
5724-B56 09.05.00 2007-10-16 2007-10-31 2013-02-13 2015-04-30
5724-B56 09.01.00 2006-06-07 2006-07-28 2011-01-21 2012-04-30
5724-B56 08.02.00 2004-08-17 2004-09-17 2008-01-25 2009-04-30
5724-B56 08.01.00 2002-09-17 2002-11-21 2007-01-19 2009-04-30


Back to topBack to top

Program number

Top rule

  • IBM Db2 Connect Unlimited Edition for System z V11.5.0 (5724-B62)
  • IBM Db2 Connect Application Server Advanced Edition V11.5.0 (5724-Z19)
  • IBM Db2 Connect Application Server Edition V11.5.0 (5724-D54)
  • IBM Db2 Connect Enterprise Edition V11.5.0 (5765-F30)
  • IBM Db2 Connect Unlimited Advanced Edition for System z V11.5.0 (5724-Z18)
  • IBM Db2 Connect Unlimited Edition for System i V11.5.0 (5724-M15)


Back to topBack to top

Abstract

Top rule

IBM Db2 Connect V11.1 offers new features and enhancements:

  • Significant feature enhancements to improve connectivity, with ease of application deployment, availability, and security for the applications that connect to either Db2 for z/OS or Db2 for i
  • Several editions available for flexible licensing options, addressing usage scenarios in small-scale and large-scale organizations

IBM Db2 Connect 11.1 helps improve connectivity, ease of application deployment, high availability, and security. It is designed to manage your enterprise information -- no matter where it is stored. For those enterprises that have made Db2 for z/OS and Db2 for i servers the cornerstone of their agile business, Db2 Connect delivers application enablement and a robust, highly scalable communications infrastructure for connecting web, Windows, UNIX, and Linux applications to data.

Db2 Connect 11.1 Application Server Advanced Edition and Db2 Connect 11.1 Unlimited Advanced Edition for System z enhance your IT staff's ability to depend on the security and reliability of existing Db2 server investments, use the flexibility and ease of new programming languages and tools, and support efforts to increase the performance and security of database applications. Using the IBM pureQuery technology that is included in the advanced editions of Db2 Connect, you can boost the SQL performance of your data server while helping to protect your data from SQL injection attacks and other types of database application security risks. And with Db2 Connect 11.1 Unlimited Advanced Edition, IBM Configuration Manager for z/OS helps you manage your connectivity environment to Db2 z/OS.

Db2 Connect integrates IBM System z, IBM i, and other enterprise data with client/server, web, and service-oriented architecture (SOA) applications. It delivers significant feature enhancements to improve programmer productivity, deliver a more robust infrastructure, and enable the flexible deployment of Db2 Connect technology.

Db2 Connect helps you reduce administration costs with advances in performance, manageability, and installation.

With features such as server-based license activation in Unlimited Editions for System z and IBM i, non-administrator installation on Windows, response file installation enhancements, and support for coexistence of multiple copies of the Db2 database system, Db2 Connect 11.1 enables your IT staff to spend more time supporting your business needs instead of installing and deploying database systems.



Back to topBack to top

Product positioning

Top rule

Db2 Connect Unlimited Advanced Edition for System z

Db2 Connect Unlimited Advanced Edition for System z is ideal for organizations with extensive usage of Db2 Connect to access Db2 on System z, especially where multiple applications are involved. This product includes program code of Db2 Connect Unlimited Edition for System z (which contains program code identical to Db2 Connect Enterprise Edition as well a Db2 Connect Application Server Edition for unlimited deployment throughout an organization), as well as program code of InfoSphere Optim pureQuery Runtime for Linux, UNIX and Windows that can be used in conjunction with Db2 Connect. The pureQuery technology, which is included, offers further improved performance and enhanced application security features. Db2 Connect Unlimited Advanced Edition for System z also includes IBM Configuration Manager for z/OS to help manage connections and the connected Db2 for z/OS environment.

Db2 Connect Unlimited Advanced Edition for System z licenses are based on the number of production Db2 subsystems or production Db2 data sharing groups, and the capacity available to production and nonproduction Db2 for z/OS data servers (measured in MSUs). They are not affected by the number of processors available to Db2 Connect, the number of users, or the number of processors available to application servers where the application is running. This makes Db2 Connect Unlimited Advanced Edition for System z an ideal choice for organizations where multiple applications are using Db2 Connect, or organizations with a mix of two-tier, multitier client/server, and web-based applications.

Db2 Connect Application Server Advanced Edition

Db2 Connect Application Server Advanced Edition consists of Db2 Connect Application Server Edition, together with InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows. Just like Application Server Edition, its licensing terms and conditions are meant to address specific needs of multitier client/server applications as well as applications that use web technologies, and pureQuery technology in conjunction with Db2 Connect. The pureQuery technology, which is included, is meant to offer further improved performance and enhanced application security features. Db2 Connect Application Server Advanced Edition license charges are based on the processor technology and the number of processor cores available to the application servers (measured in PVU) where the application is running. License charges are not affected by the number of users of the application, the size of the Db2 Connect server itself (if deployed), or the size of the mainframe database server being accessed.

For example, an application that runs on three 2-CPU (dual core per CPU) application servers (such as WebSphere Application Server) requires PVU entitlements for 12 processor cores (3 x 2 x 2 = 12 processor cores) for the Db2 Connect Application Server Advanced Edition, regardless of how many CPUs Db2 Connect is running on.

Db2 Connect Unlimited Edition for System z

Db2 Connect Unlimited Edition for System z is ideal for organizations with extensive usage of Db2 Connect to access Db2 on System z, especially where multiple applications are involved. This product includes program code of the Db2 Connect Enterprise Edition as well as program code identical to the Db2 Connect Application Server Edition for unlimited deployment throughout an organization.

Db2 Connect Unlimited Edition licenses are based on the number of production Db2 subsystems or production Db2 data sharing groups, and he capacity available to production and nonproduction Db2 for z/OS data servers (measured in MSUs) and are not affected by the number of processors available to Db2 Connect, the number of users, or the number of processors available to application servers where the application is running. This makes Db2 Connect Unlimited Edition for System z an ideal choice for organizations where multiple applications are using Db2 Connect, or organizations with a mix of two-tier, multitier client/server, and web-based applications.

Db2 Connect Unlimited Edition for System i

Db2 Connect Unlimited Edition for System i is ideal for organizations with extensive usage of Db2 Connect to access IBM Db2 for i, especially where multiple applications are involved. This product includes program code of the Db2 Connect Enterprise Edition as well as program code identical to the Db2 Connect Application Server Edition for unlimited deployment throughout an organization.

Db2 Connect Unlimited Edition for System i licenses are based on the number of processor cores (measured in PVU) allocated to IBM Db2 for i that is being accessed. Charges for the program are not based on the number of processors attached or available to the Db2 Connect Unlimited Edition for System i itself. Unlimited users are permitted. This makes Db2 Connect Unlimited Edition for System i an ideal choice for organizations where multiple applications are using Db2 Connect or organizations with a mix of two-tier, multitier client/server, and web-based applications.

Db2 Connect Application Server Edition

Db2 Connect Application Server Edition is identical to the Db2 Connect Enterprise Edition in its technology. It is designed for large-scale, demanding environments. However, its licensing terms and conditions are meant to address specific needs of multitier client/server applications as well as applications that use web technologies. Db2 Connect Application Server Edition license charges are based on the processor technology and the number of processor cores available to the application servers (measured in PVU) where the application is running. License charges are not affected by the number of users of the application, the size of the Db2 Connect server itself (if deployed), or the size of the mainframe database server being accessed.

For example, an application that runs on three 2-CPU (dual core per CPU) application servers (such as IBM WebSphere Application Server) requires PVU entitlements for 12 processor cores (3 x 2 x 2 = 12 processor cores) for the Db2 Connect Application Server Edition, regardless of how many CPUs Db2 Connect is running on.

Db2 Connect Enterprise Edition

Db2 Connect Enterprise Edition is a combination of Db2 Connect server and Db2 client software designed to address the needs of organizations that require robust connectivity from a variety of desktop systems to Db2 on System z and System i. Db2 client software is deployed on desktop systems and includes API drivers that connect client/server applications running on these desktop systems to a Db2 server. Designed to offer connectivity for client/server applications in large-scale, demanding environments, the optional Db2 Connect server component enables connection pooling and connection concentrator functions to maximize application availability while minimizing mainframe resource usage. The Db2 Connect server component also includes the capability to access federated data from Db2 for Linux, UNIX, and Windows (LUW); Db2 for z/OS; and Db2 for i or Informix databases via a single consolidated view.

Db2 Connect Enterprise Edition licensing terms help address the needs of two-tier client/server applications. License charges for the Db2 Connect Enterprise Server Edition are based on the number of users of the product. Two types of licensing by number of users are offered: Floating User Single Install and Authorized User. Licensing based on floating users can be used only with the Db2 Connect Server component and not for direct connectivity from the client to Db2 on host systems.

Because charges for Db2 Connect Enterprise Edition are based on the number of users (Authorized User or Floating User Single Install) and because determining the number of users in web-based applications can be very difficult or even impossible, Db2 Connect Application Server Edition and Db2 Connect Unlimited Edition are the preferred licensing options for such environments.



Back to topBack to top

Highlights

Top rule

IBM Db2 Connect V11.1.1

Db2 Connect V11.1.1, Fix pack 1 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 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 V11.1.1, Fix pack 1 improves connectivity, ease of application deployment, availability, and security for the applications that connect to either Db2 for z/OS or Db2 for i. Version 11.1.1,Fix pack 1 includes significant feature enhancements that can help improve programmer productivity, deliver a more robust infrastructure, and enable the flexible deployment of Db2 Connect technology. Db2 Connect can also help you reduce administration costs with advances in performance, manageability, and installation.

Db2 Connect is available in several editions to provide flexible licensing options and address usage scenarios in small organizations as well as large-scale enterprises:

  • Db2 Connect Enterprise Edition is for smaller installations and lower usage applications licensed with Authorized User and Floating User Single Install metrics.
  • Db2 Connect Application Server Edition provides licensing linked to specific applications. The Db2 Connect Application Server Edition introduces the Virtual Processor Core (VPC) license metric to facilitate hybrid cloud deployments. The VPC metric is sold as a monthly license charge. You can acquire the product directly online with the option to deploy either on-premises or on cloud.
  • Db2 Connect Unlimited Edition provides increased flexibility in deployment, enabling access across an enterprise.
  • Db2 Connect Advanced Editions enhance the security and reliability of your organization's existing Db2 server investments, enable increased flexibility and ease of new programming languages and tools, and help improve support efforts to increase the performance and security of database applications. Using the IBM pureQuery technology that is included in the advanced editions of Db2 Connect, you can boost the SQL execution performance of your data server while helping to protect your data from SQL injection attacks and other types of database application security risks.
  • Db2 Connect Unlimited Advanced Edition features IBM Configuration Manager for z/OS to help you improve the manageability of your connectivity and Db2 z/OS environment.

IBM Db2 Connect V11.1 includes:

High availability and performance enhancements

  • Improved serviceability with first failure data capture
  • Improved load from client side files
  • Support passive connect

New platform enhancements

  • MacOS 64 bit support
  • Java 8 support
  • Windows 10 support
  • Node.js support
  • Microsoft VisualStudio 2015 and Entity framework updates
  • .Net 4.5 Asynch support

Manageability enhancements

  • SSL simplification and PKI Card Support
  • OSGI compliance
  • Simplify migration from instance based clients, Gateway Server
  • Simplify client deployment
  • Security enhancements
  • SQLJ support with COBOL


Back to topBack to top

Description

Top rule

IBM Db2 Connect V11.1.1

Db2 Connect V11.1.1, Fix pack 1 delivers fast and robust connectivity to Db2 databases deployed on either IBM z Systems or IBM i. Db2 Connect includes several editions to best meet your company's needs. With most editions, Db2 Connect client components can be used to directly connect applications running on Linux (including Linux on z Systems ), UNIX, and Windows to Db2 servers on z Systems or IBM i. All editions include an optional Db2 Connect server component that can be used as a gateway to concentrate and manage connections from multiple desktop clients and applications to Db2 databases on IBM z Systems or IBM i servers.

Db2 Connect V11.1.1, Fix pack 1 enables client applications to create, access, update, control, and manage Db2 databases on host systems by using the following:

  • SQL
  • Db2 APIs
  • Open Database Connectivity (ODBC)
  • Java Database Connectivity (JDBC)
  • SQLJ (embedded SQL for Java )
  • Db2 Call Level Interface (CLI)
  • Ruby
  • pureQuery
  • .NET
  • PHP
  • Python
  • Perl

Db2 Connect V11.1 updates and enhancements

New platform enhancements:

  • Db2 for z/OS V12 support
  • ADO.Net Package to help simplify deployment

Security enhancements:

  • In-Memory keydb for SSL connection

Performance enhancements:

  • Blocking support for scrollable cursors
  • Keep Dynamic support for Db2 for z/OS

Usability enhancement:

  • Microsoft ODBC Data Source Administrator GUI enhancements for dsdriver

Manageability enhancements:

  • Register ODBC DSN with Description

Serviceability improvements

See the Product positioning section for more information about Db2 Connect editions.

IBM Db2 Connect V11.1 delivers fast and robust connectivity to IBM Db2 databases deployed on either IBM System z or IBM i. Db2 Connect includes several editions to best meet your company's needs. With most editions, Db2 Connect client components can be used to directly connect applications running on Linux (including Linux on System z), UNIX, and Windows to Db2 servers on System z or IBM i. All editions also include an optional Db2 Connect server component that can be used as a gateway to concentrate and manage connections from multiple desktop clients and applications to Db2 databases on IBM System z or IBM i servers.

Db2 Connect 11.1 enables client applications to create, access, update, control, and manage Db2 databases on host systems using:

  • SQL
  • Db2 APIs
  • Open Database Connectivity (ODBC)
  • Java Database Connectivity (JDBC)
  • SQLJ (embedded SQL for Java)
  • Db2 Call Level Interface (CLI)
  • Ruby
  • pureQuery
  • .NET
  • PHP
  • Python
  • Perl
  • Node.js

IBM Db2 Connect V11.1 includes:

High availability and performance enhancements

  • Improved serviceability with first failure data capture
  • Improved load from client side files
  • Support passive connect

New platform enhancements

  • MacOS 64 bit support
  • Java 8 support
  • Windows 10 support
  • Node.js support
  • Microsoft VisualStudio 2015 and Entity framework updates
  • .Net 4.5 Asynch support

Manageability enhancements

  • SSL simplification and PKI Card Support
  • OSGI compliance
  • Simplify migration from instance based clients, Gateway Server
  • Simplify client deployment
  • Security enhancements
  • SQLJ support with COBOL

Section 508 of the US Rehabilitation Act

Db2 Connect Enterprise Edition is capable as of June 15, 2016, 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), containing details on the products accessibility compliance, can be requested on the following website

http://www.ibm.com/able/product_accessibility/index.ht ml


Back to topBack to top

Operating environment

Top rule

Hardware requirements

The hardware requirements of Db2 products may be occasionally updated. To obtain the current information for supported hardware, see

http://www.ibm.com/software/data/db2/udb/sysreqs.html

Software requirements

This section indicates the minimal requirements for operating systems at the time of this announcement.

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, see

http://www.ibm.com/software/data/db2/udb/sysreqs.html

For more information, see the Installation Prerequisites in the documentation accompanying each product.



Back to topBack to top

Planning information

Top rule

Customer responsibilities

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

Compatibility

Db2 Connect is compatible with some mainframe and System i servers. For up-to-date information, see

http://www.ibm.com/software/data/db2/db2connect/sysre q s.html


Back to topBack to top

Publications

Top rule

No publications are shipped with these products.

The IBM Publications Center portal is located at

http://www.ibm.com/shop/publications/order

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card (in the US) or customer number for 20 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries.



Back to topBack to top

Security, auditability, and control

Top rule

Db2 Connect uses the security and auditability features of the host hardware or software.



Back to topBack to top

Trademarks

Top rule

(R), (TM), * Trademark or registered trademark of International Business Machines Corporation.

** Company, product, or service name may be a trademark or service mark of others.

Windows is a trademark of Microsoft Corporation.

UNIX is a registered trademark in the United States and other countries licensed exclusively through X/Open Company Limited.

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 Sales Manual at any time without notice. This Sales Manual is provided for your information only. Additional terms of use are located at

Terms of use


© IBM Corporation 2020.