Move (switchover) a database to another system

If you want to move, or switch, your database from one system to another, you need to create a cluster event called a switchover. A switchover is a cluster event where the primary database server or application server switches over to a backup server due to manual intervention from the cluster management interface. A switchover occurs when you manually switch access from one server to another. This is usually done when you want to perform system maintenance, such as applying fixes, installing a new release, or upgrading your system.

To create a simple cluster using the New Cluster wizard, follow these steps:

  1. In System i Navigator, expand Management Central.
  2. Right-click Clusters, and select New Cluster.

Once a cluster is available, you must then add a switchable hardware group to your cluster. To add a switchable hardware group to a cluster, follow these steps:

  1. In System i Navigator, expand Management Central.
  2. Expand Clusters.
  3. Expand the cluster for which you would like to add a switchable hardware group.
  4. Right-click Switchable Hardware, and select New Group

    Note: The New Group option is only available if all the nodes in the recovery domain are started.

And finally, you must switch the database from primary node to backup node. To switch a resource - a switchable hardware group, switchable software product, or switchable data group - from the primary node to the backup node in the recovery domain, the following conditions must be true:

To switch a resource, follow these steps:

  1. In System i Navigator, expand Management Central.
  2. Expand Clusters.
  3. Expand the cluster containing the desired resource.
  4. Click Switchable Hardware, Switchable Software, or Switchable Data.
  5. Right-click the desired resource, and select Switch.