IBM Support

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

Preventive Service Planning


Abstract

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

Content

This document is divided into linked sections for ease of navigation. You may use the links below to jump to the section of the document you require.
 

General
Configuration
Software
Connectivity
Authentication and Privileges
Ports


General

Before you register an IBM Db2 database in IBM Spectrum Protect Plus, ensure that the database meets the following requirements.


Configuration

Database Versions

  • IBM Db2 V10.5 and later maintenance and modification levels: Enterprise Server Edition

  • IBM Db2 V11.1 and later maintenance and modification levels: Enterprise Server Edition

Operating Systems

  • On 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_x64

    • Red Hat Enterprise Linux 6.8 and later maintenance and modification levels

    • Red Hat Enterprise Linux 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)

    • Red Hat Enterprise Linux 7.1 and later maintenance and modification levels

    • SUSE Linux Enterprise Server 12.0 SP1 and later maintenance and modification levels

Additional Notes

Install the latest IBM Db2 patches and updates in your environment.

IBM Db2 pureScale is not supported.

Ensure that your IBM Db2 environment is configured to meet the following criteria:

  • IBM Db2 archive logging is activated and IBM Db2 is in recoverable mode.

  • Logical volumes holding IBM Db2 table spaces (data and temporary table spaces), the local database directory, and IBM Db2 log files are managed by Logical Volume Management system (LVM2) on Linux and by the Journaled File System (JFS2) on AIX respectively. 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 IBM Knowledge Center under LVM2 and JFS2.

  • IBM Db2 must be in parallel backup mode if multiple partitions must be protected. Parallel backup mode can be enabled by IBM Db2 registry variables.  For more information, see IBM Knowledge Center under Prerequisites for Db2.


Software

  • The bash and sudo packages must be installed. Sudo must be version 1.7.6p2 or above. Run sudo -V to check the version.
    Note: The required bash and sudo packages are included in the supported Linux86_64 and Linux Power Systems (little endian) operating systems

  • Python V2.6 (any level) or V.2.7 (any level) must be installed on Linux.

  • Python version 2.7 (any level) must be installed on AIX.

  • 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 in place:

  • The 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 using SSH.

  • The SFTP subsystem for SSH is enabled.

  • The server can be registered using a DNS name or 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 IBM Db2 server must be registered in IBM Spectrum Protect Plus using an operating system user that exists on the IBM 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.

The IBM Spectrum Protect Plus agent user must have the following privileges:

  • Privileges to run commands as root and as an IBM Db2 software owner user using sudo. IBM Spectrum Protect Plus requires this 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.

  • Privileges to read the IBM Db2 inventory using /usr/local/bin/db2ls. IBM Spectrum Protect Plus requires this to discover and collect information about IBM Db2 instances and databases.
     


Ports

The following ports are used by IBM Spectrum Protect Plus Agents. Ports that are indicated with "Accept" in the Firewall Rule column use secure connections (HTTPS or SSL).

Incoming IBM Spectrum Protect Plus agent firewall connections
Port Protocol Firewall Rule Service Description
22 TCP Accept SSH Used for SSH data transfer to and from the internal vSnap server


 

Outgoing IBM Spectrum Protect Plus agent firewall connections
Port Protocol Service Description
111 TCP vSnap RPC Port Bind Allows clients to discover ports that Open Network Computing (ONC) clients require to communicate with ONC servers
2049 TCP vSnap NFS Used for NFS file sharing via vSnap
20048 TCP vSnap NFS Mount Mounts vSnap file systems on clients such as the VADP proxy, application servers, and virtualization data stores



 

[{"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.4","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
27 June 2019

UID

ibm10881760