Replicating DB2 and DB2/DPF Databases with Libelle DBShadow

Libelle’s DBShadow® software for DB2 version is a turnkey software solution to replicate single-node DB2 and multi-node DB2 DPF databases. With the core Libelle replication based on standard TCP/IP protocols, the installation can be stretched across two geographically distant locations to achieve full Disaster Recovery protection for mission-critical high-end systems.

DB2 and DPF in the Enterprise Application Market

IBM’s DB2 has crystalized itself as top choice for enterprise applications on Open Systems. Technologically, DB2 is undoubtedly one of the leading provider of database services to important application. Additionally, from our observations in the last 5 years, DB2 seems to have benefited strongly from the competing positions between Oracle and SAP in the ERP market and strongly increased its footprint as one of the four key databases for SAP applications.

Libelle BusinessShadow Components

With our renowned BusinessShadow software, we provide a proven solution to replicate System Landscapes such as SAP and other other critical enterprise applications. In its core, four software building blocks ensure complete landscape coverage including database replication (DBShadow), flat file replication (FSShadow), managing IP addresses and hostnames (SwitchApplication), and a dedicated extension for Wide Area Networks (SwitchApplication).

Libelle BusinessShadow Components

Both DBShadow and FSShadow rely on host-based server agent to manage replication tasks such as setting up the initial sync between Source and Target System (Initial Copy), picking up database or flat file changes (Archiver), and manage the Target System’s database and flat file configuration both in normal operation or during fail-over. After fail-over, roles between Source and Target can be reversed and replication could go in the opposite direction if desired.

DB2 Replication with Libelle DBShadow

Libelle DBShadow is and advanced automation solution for backup and recovery mechanisms based on database log files. Contrary to a standard log shipping setup, focus of DBShadow is an holistic, robust, and tightly integrated automation approach of every aspect of looping through shipping log files: from setting up a configuration, interacting with the Source Database, log file handling, log file transport to the Target System, controlling log file queues, and managing both day-to-day roll-forward and Standby Database startup if it becomes necessary. The screenshot below shows the Libelle GUI setting Server Agent Parameters for a DB2 database.

Once setup and running and after Initial Sync, replication is started and managed through the Libelle GUI. Alternatively, server agents can interact with the Administrators via email or smtp. The screenshot below shows Operation on a DPF NODE 0000; the screenshot after multiple Nodes.

DPF Integration

Libelle DBShadow for DB2 fully supports Direct Partitioning Feature (DPF) Installations. For DPF installations, one Libelle configuration can manage multiple Nodes, or each Node can have its own Agent, or a combination of both to support concepts of combined virtual/physical host setups. While basic replication technique is identical to a one-node-installation, with DPF Log Files are now picked up from multiple locations. The Recover Process (Roll-forward sessions and mirror system activation) is managed by one single Recover Process on Node 0000 on the target host which communicates through the DPF installation to the other hosts.

Libelle Fleet Concept applied to DPF

In a DPF configurations there are be multiple DBShadow configuration to manage: one for each node. Libelle’s “Fleet” concept can be utilized to better manage the operation of multiple configurations. In the first step, an XML configuration file is added to the ‘flagship’ configuration’s home directory. This XML file defines all Libelle configurations independent if they are on the same server or not. With the Libelle Fleet defined, multiple configurations are be managed from a central interface. As an example, if Log File Shipping should be stopped for all DPF nodes one simple command : trdb2 –fleet BI_FLEET –set ARCHIVER stop. This command will trigger each configuration to stop shipping log files. Any other operation can done in a similar manner. A Libelle-Fleet-DPF configuration can be setup in the following way:

<tr>
  <fleets>
    <fleet name="BI_FLEET">
      <configuration refname="BI_N0"  role="flagship" />
      <configuration refname="BI_N1"  role="ship" />
      <configuration refname="BI_N2"  role="ship" />
      <configuration refname="BI_N3"  role="ship" />
      <configuration refname="BI_N4"  role="ship" />
      <configuration refname="BI_N5"  role="ship" />
      <configuration refname="BI_N6"  role="ship" />
      <configuration refname="BI_N7"  role="ship" />
    </fleet>
  </fleets>
  <configurations>
    <configuration>
      <name>BI_N0</name>
      <port>7000</port>
      <primary>prdhost_1</primary>
      <mirror>trgthost_1</mirror>
    </configuration>
    <configuration>
      <name>BI_N1</name>
      <port>7001</port>
      <primary>prdhost_1</primary>
      <mirror>trgthost_1</mirror>
    </configuration>
    <configuration>
      <name>BI_N2</name>
      <port>7002</port>
      <primary>prdhost_1</primary>
      <mirror>trgthost_1</mirror>
    </configuration>
    <configuration>
      <name>BI_N3</name>
      <port>7003</port>
      <primary>prdhost_1</primary>
      <mirror>trgthost_1</mirror>
    </configuration>
    <configuration>
      <name>BI_N4</name>
      <port>7004</port>
      <primary>prdhost_2</primary>
      <mirror>trgthost_2</mirror>
    </configuration>
    <configuration>
      <name>BI_N5</name>
      <port>7005</port>
      <primary>prdhost_2</primary>
      <mirror>trgthost_2</mirror>
    </configuration>
    <configuration>
      <name>BI_N6</name>
      <port>7006</port>
      <primary>prdhost_2</primary>
      <mirror>trgthost_2</mirror>
    </configuration>
    <configuration>
      <name>BI_N7</name>
      <port>7007</port>
      <primary>prdhost_2</primary>
      <mirror>trgthost_2</mirror>
    </configuration>
</tr>

More Information

Please contact Libelle to setup a live demo of the solution. For North and South America, please reach our Atlanta Office at [+1] (770) 435 1101 or sales@us.libelle.com. For Europe, Middle East, Africa, and Asia, please reach out at [+49] (711) 78335-0 or sales@libelle.com.