IBM Support

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

Preventive Service Planning


Abstract

This document details the IBM Db2 database backup and restore requirements for IBM® Spectrum Protect™ Plus V10.1.3

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 need.
 

General
Configuration
Software
Connectivity
Authentication and Privileges
Ports


General

Before registering each IBM Db2 in IBM Spectrum Protect Plus, ensure it meets the following requirements.
 


Configuration

Database Versions

  • IBM® Db2® Version 10.5 and later maintenance levels and mod levels: Enterprise Server Edition only.

  • IBM® Db2® Version 11.1 and later maintenance levels and mod levels: Enterprise Server Edition only.
     

Operating Systems

  • On PowerPC

    • AIX 7.1 higher mod and fix pack levels (64-bit kernel).

    • AIX 7.2 higher mod and fix pack levels (64-bit kernel).

  • On Linux x86_x64

    • Red Hat Enterprise Linux 6.8 and later maintenance levels and mod levels.

    • Red Hat Enterprise Linux 7 and later maintenance levels and mod levels.

    • SUSE Linux Enterprise Server 11.0 SP4 and later maintenance levels and mod levels.

    • SUSE Linux Enterprise Server 12.0 SP1 and later maintenance levels and mod levels.
       

Additional Notes

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

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

  • IBM Db2 is configured for single partitioned databases only. Backups of multi-partition IBM Db2 databases are not supported.

  • IBM Db2 pureScale is not supported.

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

  • Logical volumes holding IBM Db2 tablespaces (data and temporary tablespaces), the local database directory and IBM Db2 log files are managed by Logical Volume Manager(LVM2) on Linux and by 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.


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 supported Linux x86_64 operating systems include the required bash and sudo packages.

  • Python version 2.6.x or 2.7.x must be installed.

  • Ensure the supported version of Linux x86_64, or AIX® is installed.
     


Connectivity

Ensure that the following connectivity criteria are in place:

  • 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 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 "IBM Spectrum Protect Plus agent user" for the rest of this topic).

  • Ensure the password is correctly configured and that the user can log in without facing any 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 IBM Db2 software owner users 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. Note that ports marked as Accept use a secure connection (https/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 Connectivity (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.3","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
12 February 2019

UID

ibm10742487