DBShadow for DB2 Databases

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 DB2/DPF for mission-critical Applications

IBM's DB2 database has crystallized itself as top choice for enterprise applications on Open Systems. Technologically, DB2 is undoubtedly one of the leading providers of database services to applications. Additionally, from our observations over the last couple of years, DB2 seems to have benefited strongly from the competing positions between Oracle and SAP in the ERP market and drastically 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 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 (LongDistance Option) .

Libelle DBShadow and FSShadow Architecture

Both DBShadow and FSShadow rely on host-based server agents to manage replication tasks such as setting up the initial sync between Source and Target System (Libelle "Initial Copy"), picking up database or flat file changes (Libelle "Archiver"), and manage the Target System's database and flat file configuration both in normal operation or during fail-over (Libelle "Recover"). 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 an advanced automation solution for backup and recovery mechanisms based on database log files. Contrary to a standard log shipping setup, focus of DBShadow is a 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 start-up if it becomes necessary. The screenshot below shows the Libelle GUI populating Server Agent Parameters for a DB2 replication.

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 of a DPF NODE0000; the screenshot after shows monitoring multiple nodes with the Libelle GUI group view.

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 the basic replication technique is identical to a one-node-installation, Log Files are picked up from multiple locations in a DPF setting. The Recover Process (Roll-forward sessions and mirror system activation) is managed by one single Recover Process on NODE0000 on the target host which communicates through the DPF installation to the other hosts.

Libelle Fleet Concept applied to DPF

In a DPF configuration there may be multiple DBShadow configurations to be managed: 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 reside on the same server or not. With the Libelle Fleet defined, multiple configurations can be controlled from a central interface. As an example, if Log File Shipping should be stopped for all DPF nodes, one simple command is sufficient: ./trdb2.sh –fleet BI_FLEET –set ARCHIVE_STATUS STOP .This single command will trigger each configuration to stop shipping log files. Any other operation can be done in a similar manner. Below the configuration of a multiple DPF node-fleet with Libelle:

<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 salesremoveThisTextIfYouWantToUseThisEmailAddress@us.libelleremoveThisTextTooIfYouWantToUseThisEmailAddress.com. For Europe, Middle East, Africa, and Asia, please reach out at [+49] (711) 78335-0 or salesremoveThisTextIfYouWantToUseThisEmailAddress@libelleremoveThisTextTooIfYouWantToUseThisEmailAddress.com.