Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

Configuring a TCPIP-based Db2 pureScale Instance on RHEL 7.6 

Fri August 28, 2020 05:13 PM

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.


#Db2

Statistics
0 Favorited
24 Views
1 Files
0 Shares
12 Downloads
Attachment(s)
pdf file
bp_Configuring TCPIP based Db2 pureScale Instance on RHEL....pdf   5.05 MB   1 version
Uploaded - Fri August 28, 2020