Authors: Yogesh Shivaji Gawali, Shashank Kharche, and Ajay Patil

Download the best practices paper by clicking this file: bp_Configuring_TCPIP_based_Db2_pureScale_Instance_on_RHEL_7_6.pdf

The IBM® Db2® pureScale® environment provides extreme capacity and application transparency which can help reduce the risk and cost of growing your business. The DB2 pureScale environment is designed for continuous availability and is capable of exceeding even the strictest industry standard.

With the Db2 pureScale Feature, scaling your database solution is simple. Multiple database servers, known as members, process incoming database requests. These members operate in a clustered system and share data. You can transparently add more members to scale out to meet even the most demanding business needs. There is no application modification, data redistribution, or performance tuning required.

The pureScale setup requires high speed Db2 cluster interconnect. For the most demanding write-intensive data sharing workloads, an RDMA protocol over Converged Ethernet (RoCE) network can offer better performance. The RoCE adapters come at some cost and may not be available to administrators for testing purposes. Db2 pureScale Feature supports all storage area network (SAN) and directly attached shared block storage.

The main purpose of this paper is to describe detailed steps on how to configure a Db2 pureScale environment on Linux VM images. The database administrators should be able to create an environment for their own testing and learning purposes by following this document. This will be a TCPIP-based Db2 pS instance, therefore, you cannot consider it for any performance benchmarking. For real-time performance testing, you must configure Db2 pS with high speed interconnect.

While setting up Db2 pS instance on VM images for learning and testing purposes, you will not require any high-speed interconnect and SAN storage. We will make use of a TCPIP network along with ISCSI drivers to configure a Db2 pS instance here.

This document covers detailed steps on how to create a Db2 pS instance consisting of two members and two CFs.