Unit Objectives
- Describe the system platforms supported by the Db2 Family of products
- Compare the features available with different Db2 product editions
- Select the appropriate Db2 client software to support application client or server systems
- Choose a method to install your Db2 product edition and plan migrations of existing Db2 servers to the latest release
- Compare cloud-based Db2 options to a locally installed Db2 server
Db2 Family Product Platforms
Db2 for z/OS
Operating Systems:
- AIX
- Linux
- Windows
Db2: The Scalable Database
Db2 Advanced Enterprise Server Edition
Includes the functions and tools needed for large, complex enterprise environments, and is ideal for both transactional and data warehouse workloads. No CPU or memory limits.
Db2 Enterprise Server
Designed to meet the data server needs of midsize to large-size businesses and is ideal for transactional and mixed workloads. It can be deployed on Linux, UNIX, or Windows servers of any size, from one processor to hundreds of processors, and on both physical and virtual servers.
Db2 Advanced Workgroup Edition
Includes the capabilities needed for medium-sized business environments, and is ideal for both transactional and data warehouse workloads. 16 CPU cores, 128GB memory limits.
Db2 Workgroup Server
Suitable for transactional database workloads in a departmental, workgroup, or medium-sized business environment.
Db2 Express C
Provides all the core capabilities of Db2 at no charge. Easy to use and embed. 2 CPU cores, 16GB memory limits.
Examples of Features and Functions by Db2 LUW Editions
| Feature | Express C | Workgroup | Advanced Workgroup | Enterprise Server | Advanced Enterprise |
|---|---|---|---|---|---|
| Data Compression (row organized) | No | No | Yes | No | Yes |
| Db2 pureScale | No | Yes (idle) | Yes | Yes (idle) | Yes |
| HADR | No | Yes | Yes | Yes | Yes |
| Column-organized Tables (BLU) | No | No | Yes | No | Yes |
| Federation | Db2 LUW | Db2 & Informix | All | Db2 & Informix | All |
| Temporal tables | Yes | Yes | Yes | Yes | Yes |
| Data Partitioning (MPP) | No | No | Yes | No | Yes |
| Db2 Workload Management | No | Offering | Yes | Offering | Yes |
| Data Server Manager | No | Base | Enterprise | Base | Enterprise |
Db2 Direct Editions
New Delivery Mechanism for Db2 licenses:
- New license metrics to facilitate hybrid cloud deployments
- Acquire the product directly online (Passport Advantage)
- Option to deploy either on-premises or on cloud
Two Versions depending on Requirements:
- Db2 Direct Standard Edition 11.1 - Has all of the database features of Db2 Workgroup Server Edition
- Db2 Direct Advanced Edition 11.1 - Has all of the database features of Db2 Advanced Enterprise Server Edition
Newly introduced simplified license metric, the Virtual Processor Core (VPC) sold as a monthly license charge
Predictable maintenance options:
- Enhancements and fixes approximately every four months
- A stable stream that only includes fixes once a year
Virtual Processor Core (VPC)
Virtual Processor Core (VPC):
- 1 VPC for every VPC available to a virtual Servers Operating System, or 1 VPC for each physical core of a non-partitioned physical server
- If the number of VPCs is greater than the physical cores, then you only need to license the number of physical cores on the machine
- Minimum of 2 VPCs per deployment (1 VPC for idle/warm standby)
Benefits to Customers:
- Simplifies Processor and Sub-capacity Licensing
- Aligns to Cloud Hosted Solution Licensing standards across MSP’s
- Makes it easier for customers On-prem and in Cloud to stay in compliance
Expand Db2 Ecosystem/Skills
New Db2 Developer-C Edition:
- Freely downloadable just like Express-C
- Fully functional Db2 database server
- pureScale and DPF deployments
- Compression and BLU Acceleration
Use Limitations:
- For development and non-production only
- Unsupported edition (non-warranted)
- Environment limited usage:
- 4 cores, 16GB of memory
- 100GB of data in user tablespaces
Functional Differences from Db2 Developer Edition:
- Excludes some “Supporting Programs”
- Cognos, IDA, WebSphere AS / MQ, DSM Enterprise
Operating Systems Supported by Db2 11.1
New Operating System Support:
- Power Linux LE (Little Endian)
- Red Hat Enterprise Linux (RHEL) 7.1+
- SUSE Linux Enterprise Server (SLES) 12
- Ubuntu 14.04 LTS
Supported Operating Systems:
- Intel 64-bit
- Windows 7, 8.1, 10, Windows Server 2012 R2
- Red Hat Enterprise Linux (RHEL) 6.7+, 7.1+
- SUSE Linux Enterprise Server (SLES) 11SP4+, 12
- CentOS 6.7, 7.1
- Ubuntu 14.04 LTS
- AIX Version 7.1 TL 3 SP5+
- zLinux
- Red Hat Enterprise Linux (RHEL) 7.1+
- SUSE Linux Enterprise Server (SLES) 12
Operating Systems: Virtualization
- IBM System z
- IBM Processor Resource/System Manager
- z/VM and z/KVM on IBM System z
- IBM Power
- IBM PowerVM and PowerKVM and IBM Workload Partitions on IBM Power Systems
- Linux X86-64 Platforms
- Red Hat KVM
- SUSE KVM
- VMWare ESXi
- Docker container support – Linux only
- Microsoft
- Hyper-V
- Microsoft Windows Azure on x86-64 Windows Platforms only
- pureScale support on Power VM/KVM, VMWare, and KVM
Db2 Server Connectivity Options
- IBM Data Server Driver Package
- IBM Data Server Runtime Client
- IBM Data Server Client
- IBM Data Server Driver for JDBC and SQLJ
- IBM Data Server Driver for ODBC and CLI
Streamlined Upgrade Process
Upgrade directly from Version 9.7, 10.1, and 10.5 (3 releases back)
Ability to roll-forward through database version upgrades:
- Single-partition Db2 Enterprise Server Edition or Db2 pureScale
- Upgrading from Db2 Version 10.5 Fix Pack 7, or later
- Users are no longer required to perform an offline backup of existing databases before or after they upgrade
- A recovery procedure involving roll-forward through database upgrade now exists
HADR environments can now be upgraded without the need to re-initialize the standby database after performing an upgrade on the primary database:
- For single-partition Db2 Enterprise Server Edition users upgrading from Db2 Version 10.5 Fix Pack 7, or later
Preparing to Install Db2 Database Servers
Use the db2prereqcheck command to check the software and firmware prerequisites of a specific Db2 version
Installation prerequisites:
- Ensure that your system meets the necessary operating system, hardware, software, communications, disk, and memory requirements
- There are different prerequisites for AIX, Linux, and Windows operating systems
Disk and memory requirements:
- Ensure appropriate amount of disk space is available for Db2 environment
- Db2 Setup wizard provides dynamic size estimates based on the components selected during a typical, compact, or custom installation
- On Linux and UNIX operating systems, 2 GB of free space in the /tmp directory is recommended
- Memory requirements are affected by the size and complexity of your database system, database activity, and the number of clients
- At a minimum, a Db2 database system requires 256 MB of RAM, 1 GB of RAM is recommended for improved performance
Db2 Software Installation Methods
| Installation Method | Windows | UNIX / Linux |
|---|---|---|
| Db2 Setup Wizard | Yes | Yes |
| Install Using Response File | Yes | Yes |
| db2_install command | No | Yes |
| Payload File deployment | No | Yes |
Db2 Deployment Options
On Premises
On Cloud
- SOFTWARE
- APPLIANCE
- HOSTED DBaaS
- MANAGED DBaaS
IBM Db2 Hosted
Provides a hosted Db2 environment that is deployed on IBM SoftLayer (virtual private nodes/bare metal) or AWS (virtual private nodes) cloud platform
Administered by your organization's DBAs (all software including OS & database)
Available via pay-as-you-go or subscription model (support included)
Benefits include:
- Convenience without the loss of control on cost-effective infrastructure
- Five high-performance hardware configurations and two database software tiers to match capability and affordability needs
- BLU Acceleration
- Native encryption support included in all configurations ensuring data remains secure in the cloud
- HADR for high availability and disaster recovery
- Unlimited ability to create databases to fully utilize the cloud infrastructure
Deployment options:
- Choice of cloud provider: SoftLayer or AWS
- Five t-shirt sized configurations: Small, Medium, Large, X-Large, 2X-Large
- Two versions of Db2 available: Workgroup Server Edition (Standard) and Advanced Enterprise Server Edition (Advanced)
Target Use-cases Addressed by Db2 Hosted
Db2 Hosted is a great way to lift and shift an existing app to the cloud, but there are other ways to take advantage of this offering as well:
- Prototyping proof of concept (POC) development projects - Take advantage of the latest Db2 technologies and experiment in a cost-effective environment that doesn’t take up data center space or management bandwidth
- Retain relevance to LOB initiatives - Quickly demonstrate a positive ROI associated with IT projects and manage year-to-year budget growth
- Redundancy without building a new data center - Mitigate risks for unplanned downtime with easy setup of a secondary environment, monthly charges, SoftLayer data centers
- Consolidation of smaller on-premise databases - Leverage cloud to consolidate sprawling on-premise systems and streamline initial move to cloud with automated deployment, and use all of your on-premises management processes/tools
- Reduce CAPEX - Take advantage of a monthly charge model
Db2 Connect
Db2 Connect client access to host databases:
- Db2 Connect's basic feature is providing a direct connection to a host database from desktop applications running on your workstations
- IBM Data Server Driver Package with Db2 Connect license is the simplest way to provide this solution
- Each workstation that has a client package and Db2 Connect license installed can establish a direct TCP/IP connection to:
- Db2 for z/OS
- IBM Db2 for IBM i
- Db2 servers
- In addition, applications can connect to and update multiple Db2 family databases in the same transaction with the complete data integrity provided by the two-phase commit protocol
Unit Summary
- Describe the system platforms supported by the Db2 Family of products
- Compare the features available with different Db2 LUW product editions
- Select the appropriate Db2 client software to support application client or server systems
- Choose a method to install your Db2 product edition and plan migrations of existing Db2 servers to the latest release
- Compare cloud-based Db2 options to a locally installed Db2 server