Preventive Service Planning
Abstract
This document details the IBM Db2 database backup and restore requirements for IBM Spectrum Protect Plus Version 10.1.5.
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
Before you register a IBM Db2 database in IBM Spectrum Protect Plus, ensure that the system environment meets the following requirements.
Configuration
Database versions
- Db2 V10.5 and later maintenance and modification levels: Enterprise Server Edition
- Db2 V11.1 and later maintenance and modification levels: Enterprise Server Edition
- Db2 V11.5 and later maintenance and modification levels: Enterprise Server Edition
Operating systems
- On IBM PowerPC:
- AIX 7.1 and later fix pack and modification levels (64-bit kernel)
- AIX 7.2 and later fix pack and modification levels (64-bit kernel)
- On Linux® x86_64:
- Red Hat Enterprise Linux (RHEL) 6.8 and later maintenance and modification levels
- RHEL 7 and later maintenance and modification levels
- SUSE Linux Enterprise Server 11.0 SP4 and later maintenance and modification levels
- SUSE Linux Enterprise Server 12.0 SP1 and later maintenance and modification levels
- On Linux on Power Systems (little endian):
- RHEL 7.1 and later maintenance and modification levels
- SUSE Linux Enterprise Server 12.0 SP1 and later maintenance and modification levels
Note: Previously it indicated that SLES 15.0 SP1 is supported. However SLES 15.0 SP1 is not supported by IBM Db2 database. Because of that IBM Spectrum Protect Plus DB2 agent also does not support this OS level, see APAR IT32290.
Additional notes
Install the latest Db2 patches and updates in your environment.
Db2 pureScale is not supported.
Ensure that the Db2 environment is configured to meet the following criteria:
- Db2 archive logging is activated and Db2 is in recoverable mode.
- Before you start backing up Db2 databases, ensure you have enough free disk space on the target and source hosts, and in the vSnap repository. For more information, see Space requirements for Db2 protection
- 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 Journaled file system (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
- Db2 must be in parallel backup mode if multiple partitions must be protected. Parallel backup mode can be enabled by Db2 registry variables. For more information, see Prerequisites for Db2
Software
- The bash and sudo packages must be installed. Sudo must be version 1.7.6p2 or later. Run
sudo -Vto check the version.
Tip: The required bash and sudo packages are included in the supported Linux86_64 and Linux Power Systems (little endian) operating systems. - Ensure that the supported version of Linux x86_64, Linux on Power Systems (little endian), or AIX is installed.
Connectivity
Ensure that the following connectivity criteria are met:
- The Secure Shell (SSH) service is running on port 22 on the server.
- Firewalls must be configured to allow IBM Spectrum Protect Plus to connect to the server by using SSH.
- The Secure Shell (SSH) subsystem for SSH is enabled.
- The server can be registered by using a Domain Name System (DNS) name or an Internet Protocol (IP) address. DNS names must be resolvable by IBM Spectrum Protect Plus.
- On AIX, ensure that the NFS communication is configured with reserved ports by using the following command:
nfso -p -o nfs_use_reserved_port=1
Authentication and privileges
- The Db2 Server must be registered in IBM Spectrum Protect Plus by using an operating system user that exists on the Db2 Server (referred to as the "IBM Spectrum Protect Plus agent user" for the rest of this topic).
- Ensure that the password is correctly configured and that the user can log in without other prompts, such as prompts to reset the password.
To use a DB2 database, an IBM Spectrum Protect Plus agent user must have the following permissions:
- Privileges to run commands as root 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
sudoersconfiguration must allow the IBM Spectrum Protect Plus agent user to run commands without a password. - The
!requirettysetting must be set.
- The
- Privileges to read the Db2 inventory by using
/usr/local/bin/db2ls. IBM Spectrum Protect Plus requires these privileges to discover and collect information about Db2 instances and databases.
Ports
The following ports are used by IBM Spectrum Protect Plus agents users. The ports use secure connections (HTTPS or SSL).
| Port | Protocol | Initiator | Target | Description |
|---|---|---|---|---|
| 22 | Transmission Control Protocol (TCP) | IBM Spectrum Protect Plus virtual appliance1 | Db2 database | Provides access to troubleshoot and maintain remote proxy host servers running guest applications components by using the Secure Shell (SSH) protocol |
1The IBM Spectrum Protect Plus virtual appliance contains the base components: IBM Spectrum Protect Plus server, site, vSnap server, vSnap pool, and VADP proxy.
| Port | Protocol | Initiator | Target | Description |
|---|---|---|---|---|
| 111 | TCP | Db2 database | vSnap server | Allows Open Network Computing (ONC) clients to discover ports for communications with ONC servers |
| 2049 | TCP | Db2 database | vSnap server | Used for Network File System (NFS) data transfer to and from vSnap servers |
| 20048 | TCP | Db2 database | 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
| System | Disk Space |
|---|---|
| Compatible hardware that is supported by the operating system and Db2 database | A minimum of 500 MB of disk space for the product to be installed |
Related Information
Was this topic helpful?
Document Information
Modified date:
25 May 2020
UID
ibm11071982