IBM Db2 database backup and restore requirements: IBM Spectrum Protect Plus V10.1.6

Preventive Service Planning

Abstract

This document details the IBM Db2 database backup and restore requirements for IBM Spectrum Protect Plus Version 10.1.6.

Content

This document is divided into linked sections for ease of navigation. Use the following links to jump to the section of the document that you require:

General
Configuration
Software
Authentication and privileges
- Authentication
- Privileges
Prerequisites and Operations
- Prerequisites
- Operations
Connectivity
Ports
Hardware

General

Beginning with IBM Spectrum Protect Plus V10.1.2, support was added for backing up and restoring Db2 database data.

Before you register a Db2 database with IBM Spectrum Protect Plus, ensure that the system environment meets the following requirements.

Configuration

Application versions

**Table 1.** Coverage matrix for application levels supported by IBM Spectrum Protect Plus
IBM Spectrum Protect Plus	Db2 V10.5* Enterprise Edition	Db2 V11.1* Enterprise Edition	Db2 V11.5* Enterprise Edition
V10.1.2			--
V10.1.3			--
V10.1.4			--
V10.1.5
V10.1.6

* The base release and later maintenance and modification levels are supported.

Operating systems

**Table 2.** Coverage matrix for supported operating systems on IBM PowerPC
IBM Spectrum Protect Plus	IBM AIX 7.1*	IBM AIX 7.2*
V10.1.2
V10.1.3
V10.1.4
V10.1.5
V10.1.6

* The base release and later maintenance and modification levels are supported.

**Table 3.** Coverage matrix for supported operating systems on Linux® x86_64
IBM Spectrum Protect Plus	RHEL 6.8*	RHEL 7.0*	SLES 11.0 SP4*	SLES 12.0 SP1*
V10.1.2
V10.1.3
V10.1.4
V10.1.5
V10.1.6

*The base release and later maintenance and modification levels are supported.

**Table 4.** Coverage matrix for supported operating systems on Linux on Power Systems (little endian)
IBM Spectrum Protect Plus	RHEL 7.1*	SLES 12.0 SP1*
V10.1.4
V10.1.5
V10.1.6

*The base release and later maintenance and modification levels are supported.

Restrictions

The Db2 pureScale feature is not supported.
Ensure that your Db2 logical volume setup does not include nested mount points.
If you plan to protect multiple partitions, Db2 must be in parallel backup mode Parallel backup mode can be enabled by editing Db2 registry variables. For more information, see Prerequisites for Db2
The DB2_PARALLEL_ACS registry variable is available only in certain fix pack levels of Db2. If the DB2_PARALLEL_ACS variable is not available in your version, you can meet the requirement by specifying DB2_WORKLOAD = SAP.

Software

The bash and sudo packages must be installed. Sudo must be version 1.7.6p2 or later. Run sudo -V to check the version.
Tip: The required bash and sudo packages are included in the supported Linux x86_64 and Linux on Power Systems (little endian) operating systems.
Install the most recent Db2 patches and updates in your environment.
Ensure that the supported version of Linux x86_64, Linux on Power Systems (little endian), or AIX is installed. Ensure that the most recent patches and updates are installed.
The International Components for Unicode (libicu) RPM-package corresponding to the operating system must be installed.
Ensure that the effective file size value ulimit -f, for the IBM Spectrum Protect Plus agent user and the Db2 instance user is set to unlimited. Alternatively, set the value sufficiently high to allow copying of the largest database files in your backup and restore jobs. If you change the ulimit setting, restart the Db2 instance to finalize the configuration.
In a Linux environment, depending on your version or distribution, ensure that the Linux utility package util-linux-ng or util-linux package is current.
RHEL and CentOS 6 users: To ensure that the util-linux-ng or util-linux package is current, run the following command:
```
  yum update package_name
```

Authentication and privileges

Authentication

The Db2 server must be registered with IBM Spectrum Protect Plus by using an operating system user who exists on the Db2 server. The user is then referred as the IBM Spectrum Protect Plus agent user.
Ensure that the password is correctly configured and that the user can log in without other prompts, such as prompts to reset the password.

Privileges

To use a Db2 database, an IBM Spectrum Protect Plus agent user must have the following permissions:

Privileges to run commands as root user and as a Db2 software owner user by using sudo. IBM Spectrum Protect Plus requires these privileges for various tasks such as discovering storage layouts, mounting and unmounting disks, and managing databases.
- The sudoers configuration must allow the IBM Spectrum Protect Plus agent user to run commands without a password.
- The !requiretty setting must be set, as described in Setting sudo privileges for Db2
Privileges to read the Db2 inventory by using the db2ls command in the /usr/local/bin directory. IBM Spectrum Protect Plus requires these privileges to discover and collect information about Db2 instances and databases.

Prerequisites and Operations

Prerequisites

Ensure that the Software, Connectivity, and Authentication and privileges requirements are met.

The following prerequisites must be met before you start protecting your resources. For details, see Prerequisites for Db2

Db2 archive logging is activated and Db2 is in recoverable mode.
Sufficient space is available in the Db2 database management system, in the volume groups for the backup operation, and on the target volumes for copying files during the restore operation. For more information about space requirements, see Space requirements for Db2 protection
- Before you back up Db2 databases, ensure you have enough free disk space on the target and source hosts, and in the vSnap repository. Extra free disk space is required in the volume groups on the source host for creating temporary Logical Volume Manager (LVM) snapshots of the logical volumes that the Db2 database and log files are stored on. To create LVM snapshots of a protected Db2 database, ensure that the volume groups with Db2 data have sufficient free space.
  - For AIX®, no more than 15 snapshots can exist for each Enhanced Journaled File System (JFS2). Internal and external JFS2 snapshots cannot exist at the same time for the same file system. Ensure that no internal snapshots exist on the JFS2 volumes, as these snapshots can cause issues when the IBM Spectrum Protect Plus Db2 agent is creating external snapshots.
  - For every LVM or JFS2 snapshot logical volume that contains data, allow at least 10% of its size as free disk space in the volume group. If the volume group has enough free disk space, the IBM Spectrum Protect Plus Db2 agent reserves up to 25% of the source logical volume size for the snapshot logical volume.
- When you are restoring data to an alternative location, allocate extra dedicated volumes for copy and restore processes. The data paths for table spaces and logs on the target host are the same as the paths on the original host. This setup supports the copying of data from the mounted vSnap to the target host. Ensure that dedicated local database directories are allowed for each database in your volume setup.
Logical volumes holding Db2 table spaces (data and temporary table spaces), the local database directory, and Db2 log files are managed by the Logical Volume Management system (LVM2) on Linux or by the JFS2 on AIX. LVM2 on Linux and JFS2 on AIX are used for creating temporary volume snapshots. The logical volume grows in size with data as it changes on the source volume while the snapshot exists. For more information, see LVM2 and JFS2

Operations

Before you start a backup or restore operation:

You must add the host address where your Db2 instances are located to IBM Spectrum Protect Plus. You can repeat the procedure to add every host that you want to protect. If your Db2 environment is multi-partitioned with multiple hosts, you must add each host to IBM Spectrum Protect Plus. For instructions, see Adding a Db2 application server
Configure a service level agreement (SLA) policy. For instructions, see Defining a Service Level Agreement backup job
Before an IBM Spectrum Protect Plus user can implement backup and restore operations, roles and resource groups must be assigned to the user. Grant users access to backup and restore operations by using the Accounts pane. For instructions, see Managing user access
Inventory jobs should not be scheduled to run at the same time as backup jobs.
Avoid configuring log backups for a single Db2 database with many backup jobs. If a single Db2 database is added to multiple job definitions with log backup enabled, a log backup from one job can truncate a log before it is backed up by the next job. This truncation might cause point-in-time restore jobs to fail.
For all restore operations, Db2 must be at the same version level on the source and target hosts. In addition to that requirement, you must ensure that an instance with the same name as the instance that is being restored exists on each host. This requirement applies when the target instance has the same name, and when the names are different. In order for the restore operation to succeed, both instances must be provisioned, one with original name and the other with the new name.
If you plan to restore multi-partitioned databases to an alternative location, ensure that the target instance is configured with the same partition numbers as the original instance. All of the partitions must be on a single host. When you are restoring data to a new instance that is renamed, both instances required for the restore operation must be configured with the same number of partitions.

Review the following information about creating backup and restore jobs:

Define regularly scheduled Db2 backup jobs to protect your data. You also enable continuous backup operations for archive logs so that you can restore a point-in-time copy with rollforward options if required. For instructions, see Backing up Db2 data
To restore Db2 data from the vSnap repository, define a job that restores data from either the newest backup or an earlier backup copy. You can choose to restore data to the original instance or to an alternative instance on a different client host. For instructions, see Restoring Db2 data

Connectivity

Ensure that the following connectivity requirements are met:

The secure file transfer protocol (SFTP) subsystem for Secure Shell (SSH) is enabled.
The Secure Shell (SSH) service is running on port 22 on the proxy host server.
Firewalls are configured to allow IBM Spectrum Protect Plus to connect to the proxy host server by using SSH.

IBM Spectrum Protect Plus uses the Network File System (NFS) protocol to mount storage volumes for backup and restore operations.
- On Linux, ensure that the native Linux NFS client is installed on the proxy host server.
- On AIX, ensure that NFS communication is configured with reserved ports by using the following command:
```
  nfso -p -o nfs_use_reserved_port=1
```
All servers, proxies, applications, and hypervisors that are added to the IBM Spectrum Protect Plus environment must be registered by using a Domain Name System (DNS) name or Internet Protocol (IP) address.
If DNS names are used, they must be resolvable over the network by the IBM Spectrum Protect Plus virtual appliance server and the vSnap server. All IBM Spectrum Protect Plus components must also be resolvable by their DNS names.
If DNS is not available, you must add the server to the /etc/hosts file on the IBM Spectrum Protect Plus virtual appliance by using the command line.

Ports

The following ports are used by IBM Spectrum Protect Plus agent users.

**Table 5.** Communication ports when the target is an IBM Spectrum Protect Plus agent
Port	Protocol	Initiator	Target	Description
22	Transmission Control Protocol (TCP)	IBM Spectrum Protect Plus virtual appliance¹	Db2 server	Provides access to troubleshoot and maintain remote proxy host servers running guest application components by using the SSH protocol

¹ The IBM Spectrum Protect Plus virtual appliance contains the following base components: the IBM Spectrum Protect Plus server, the vSnap server, and a VADP proxy, as described in Product components

**Table 6.** Communication ports when the initiator is the IBM Spectrum Protect Plus agent
Port	Protocol	Initiator	Target	Description
111	TCP	Db2 server	vSnap server	Allows Open Network Computing (ONC) clients to discover ports for communications with ONC servers
2049	TCP	Db2 server	vSnap server	Used for NFS data transfer to and from vSnap servers
20048	TCP	Db2 server	vSnap server	Mounts vSnap file systems on clients such as the VMware vStorage API for Data Protection (VADP) proxy, application servers, and virtualization data stores

Hardware

**Table 7.** Minimum hardware requirements
System	Disk Space
Compatible hardware that is supported by the operating system and Db2 database server	A minimum of 500 MB of disk space for the product to be installed

Related Information

IBM Spectrum Protect™ Plus - All Requirements Doc

Featured Documents for IBM Spectrum Protect™ Plus

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.1.6","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Tips