Db2

 View Only

Simplify DB2 HADR with IBM PureApplication System

By Rahul Kumar posted Fri December 09, 2022 06:30 AM

  

Introduction


Most applications today need continuous data availability for operation. Any downtime of a database accessed by an application can result in significant losses of time and money. Minimizing outage time and data loss has become a business necessity.
Learn more about PureApplication System and other products in the PureSystems family.

With the DBaaS 1.1.0.8 pattern type and IBM PureApplication System (PureApp System) v1.1, you can deploy your databases in a HADR environment. HADR in the PureApp System is designed to provide high availability at the database level. Disaster recovery is not yet supported, as the virtual machines (VMs) created will be in a single rack.

HADR in the PureApp System frees you from setting and configuring the environment. It provides an ultra-simple method of provisioning an HADR-enabled database. The only prerequisite is a configured IBM Tivoli Storage Manager (TSM) server and the use of Internet protocol version IPv4 while deploying a database. (In future releases, IP version IPv6 will be supported.)

PureApp System provisions two separate VMs, which are kept on separate physical nodes, so the failure of one physical device does not affect the other database on another physical node. After the VMs are ready, PureApp System installs DB2 and automatically opens the necessary port values in the firewall for TCP/IP connections. The system assigns primary and standby designations to the VMs and then creates the new HADR database on the primary. To create the standby, a backup of the primary database is sent to TSM. Users and groups are created on the standby that mirrors the user and groups on the primary. The primary backup image is restored to the standby database. The HADR configuration settings are updated on standby. In PureApp System v1.1, only the NEARSYNC mode of synchronization is supported.

In this article, you provision HADR-enabled databases as an instance and from a virtual application pattern. We also discuss auto takeover operations and compare traditional HADR setup to HADR in PureApp System. 

Download the full report for more on simplifying DB2 HADR with IBM PureApplication System.
Download the report to get started!


#Db2
0 comments
4 views

Permalink