IBM Support

SAP HANA requirements: IBM Storage Copy Data Management 2.2.20

Detailed System Requirements


Abstract

This document details the backup and restore requirements for SAP HANA for IBM Storage Copy Data Management 2.2.20.

Content

Note: The product now known as IBM Storage Copy Data Management was named IBM Spectrum Copy Data Management in levels earlier than 2.2.20. To learn more about the brand change, see IBM Spectrum Protect brand change to IBM Storage Protect.
 

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

  • IBM Storage Copy Data Management installs an agent on application servers when it is registered. Some anti-virus software might flag or attempt to remove the agent software. If you run anti-malware software application servers, exclude the installation path of the IBM Storage Copy Data Management agent.
  • For Linux-based and AIX-based systems, the agent installation directory must be excluded for any anti-virus software scans. Add this path to the exclusion list for all anti-virus software that is installed on the application server. For Oracle, InterSystems Caché and IRIS, and SAP HANA:
    /tmp/cdm_guestapps_username
    Where username of the account used to register the application server in IBM Storage Copy Data Management.
  • IBM Storage Copy Data Management support for third-party operating systems, applications, services, and hardware depend on the respective vendor. If a third-party product or version moves into extended support, self-service support, or end-of-life, IBM Storage Copy Data Management supports the product or version at the same level as the vendor. See also IBM Support General Guidelines and Limitations - IBM support for software on unsupported operating systems


 

Before you register each SAP HANA server in IBM Copy Data Management, ensure it meets the following requirements.



 

Configuration

Supported platforms and configurations

Table 1: SAP HANA configuration requirements
Operating system
  • SAP HANA 1.0 SPS 07 or later [6, 9]
  • SAP HANA 2.0 SPS 02 [5, 6, 9]
  • SAP HANA 2.0 SPS 03 [6, 9]
  • SAP HANA 2.0 SPS 04 [6, 8, 9] (See following Prerequisite note.)
  • SAP HANA 2.0 SPS 05 [6, 8, 9] (See following Prerequisite note.)
Storage system
  • IBM Spectrum Virtualize Software 7.3 or later, 8.1.2 or later, 8.4 or later and 8.5 or later
    - IBM SAN Volume Controller [7]
    - IBM Storwize [7]
    - IBM FlashSystem [7]
  • Pure Storage running Pure APIs 1.5 or later
    - FlashArray//c
    - FlashArray//m
    - FlashArray//x

    - FlashArray 4xx series
Server types Operating Systems Storage Configuration
Physical [4, 10]
  • Red Hat Enterprise Linux 6.5 or later
  • Red Hat Enterprise Linux 7.0 or later
  • Red Hat Enterprise Linux 8.0 or later (beginning with 2.2.18)
  • SUSE Linux Enterprise Server 12 or later
  • SUSE Linux Enterprise Server 15 SP3 or later
  • Fibre Channel
  • iSCSI
Virtual (VMware) [1, 3, 4, 10]
  • Red Hat Enterprise Linux 6.5 or later
  • Red Hat Enterprise Linux 7.0 or later
  • Red Hat Enterprise Linux 8.0 or later (beginning with 2.2.18)
  • SUSE Linux Enterprise Server 12 or later
  • SUSE Linux Enterprise Server 15 SP3 or later
  • Physical RDM backed by Fibre Channel or iSCSI disks attached to ESX [2]
  • VMDK (dependent and independent disks) on VMFS datastores backed by Fibre Channel or iSCSI disks attached to ESX
  • iSCSI disks directly attached to guest operating system [2]

Notes:

  • [1] For supported VMware vSphere versions, see in  System requirements: IBM Storage Copy Data Management 2.2.20.
  • [2]Select the Physical provider type when you register the provider in IBM Storage Copy Data Management. NetApp ONTAP Storage Systems are not supported.
  • [3] SAP HANA servers registered as virtual need VMware Tools installed and running.
  • [4] Supported platforms: Intel based x86, IBM Power Systems (Little Endian).
  • [5] Single tenant configurations can be automatically protected by using storage snapshots.
  • [6] Only the XFS files system is supported for SAP HANA data and logs locations.
  • [7] On IBM Systems Storage, condense is run during maintenance jobs.
  • [8] IBM Storage Copy Data Management supports protection and recovery of multitenant databases on SAP HANA 2.0 SPS 04 and SPS 05.
  • [9] Non-scale-out SAP HANA configurations are only supported.
  • [10] Supported platforms: IBM Power Systems (Little Endian).

Note: If you are using IBM Storage Systems running IBM Spectrum Accelerate level 11.5.3 or later, including FlashSystem A9000/A9000R and IBM XIV Storage Systems use IBM Spectrum Copy Data Management 2.2.13.


 

Prerequisites

  • The SAP HANA Client must be installed on your SAP HANA machine.
  • Create a symbolic link to the SAP HANA Client installation directory through the following command:
    ln -s <installation directory of SAP HANA Client> /opt/hana.
    For example, if SAP HANA Client is installed in /hana/shared/<SID>/hdbclient, you would enter the following:
    ln -s /hana/shared/<SID>/hdbclient/ /opt/hana
  • For SAP HANA 2.0 SPS 04 and SPS 05, the hdbcli module must be installed. The hdbcli module must be installed only after the complete installation of the SAP HANA client. The module might be extracted from <path to directory>/hdbclient/hdbcli-<version>.tar.gz.
  • Log backups require that the log backup option is enabled on the SAP HANA system. Additionally, the Universal Destination Directory for log backups must match the directory that is configured on the SAP HANA system when you enable log backups.
  • Each SAP HANA system has a system ID (SID). It is good practice to have the SID in the path. For example, if /hana/logbackup is the mount point, create these directories:
    mkdir /hana/logbackup/<SID>
    mkdir /hana/logbackup/<SID>/catalog
    To ensure that database logs can be saved, permissions need to be specified for the created directories:
    chown --reference=/hana/shared/<SID>/HDB01 /hana/logbackup/<SID>
    chmod --reference=/hana/shared/<SID>/HDB01 /hana/logbackup/<SID>
    chown --reference=/hana/shared/<SID>/HDB01 /hana/logbackup/<SID>/catalog
    chmod --reference=/hana/shared/<SID>/HDB01 /hana/logbackup/<SID>/catalog



 

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.
  • Python version 3.x must be installed.
    It might be necessary to add your python3 binary file location to the system PATH or to create a symbolic link. For example, if your python3 is installed at /opt/freeware/bin, you need to create a link as follows:
    ln -s /opt/freeware/bin/python3 /usr/bin/python3
    SLES only: Run the following commands before hdbcli installation:
    python3 -m ensurepip
    pip3 install hdbcli
  • RHEL/CentOS 6.x only: Ensure the util-linux-ng package is up to date by running:
    yum update util-linux-ng
    Depending on your version or distribution, the package might be named:  util-linux.
  • RHEL/CentOS 7.3 or later: A required Perl module, Digest::MD5, is not installed by default. Install the module by running:
    yum install perl-Digest-MD5
  • SLES only: The Python pip package needs to be installed. Follow these steps to install the pip module on SLES:
    $ sudo zypper addrepo https://download.opensuse.org/repositories/Cloud:Tools/SLE_12_SP4/Cloud:Tools.repo
    $ sudo zypper refresh
    $ sudo zypper python-pip
    Note: The SLES equivalent of yum is zypper.
  • Linux only: If data stays on LVM volumes, ensure that the LVM version is 2.0.2.118 or later. To check the LVM version and if necessary to update the package, run:
    lvm version
    yum update lvm2
  • Linux only: If data stays on LVM volumes, the lvm2-lvmetad service must be disabled as it can interfere with IBM Storage Copy Data Management's ability to mount and resignature volume group snapshots and clones.
    Run the following commands to stop and disable the service:
    systemctl stop lvm2-lvmetad
    systemctl disable lvm2-lvmetad
    Additionally, disable lvmetad in the LVM config file. Edit the file /etc/lvm/lvm.conf and set:
    use_lvmetad = 0



 

Connectivity

  • The SSH service must be running on port 22 on the server and any firewalls must be configured to allow IBM Storage Copy Data Management to connect to the server by using SSH. The SFTP subsystem for SSH must also be enabled.
  • The server can be registered by using a DNS name or IP address. DNS names must be resolvable by IBM Storage Copy Data Management.
  • To mount clones or copies of data, IBM Storage Copy Data Management automatically maps and unmaps LUNs to the servers. Each server must be preconfigured to connect to the relevant Storage Systems at that site.
    • For Fibre Channel, the appropriate zoning must be configured beforehand.
    • For iSCSI, the servers must be configured beforehand to discover and log in to the targets on the storage servers.



 

Authentication, registration, and privileges

Authentication

  • The application server must be registered in IBM Storage Copy Data Management by using an operating system user that exists on the server (referred to as "IBM Storage Copy Data Management agent user" for the rest of this topic).
  • During registration, you must provide either a password or a private SSH key that IBM Storage Copy Data Management uses to log in to the server.
  • For password-based authentication, ensure that the password is correctly configured and that the user can log in without facing any other prompts, such as prompts to reset the password.


 

Registration

When you register an SAP HANA provider in IBM Storage Copy Data Management, note the following:

  • The format for the port number is 3<instance number>15. So, for example, if the instance number is 07, then enter the following port number: 30715.
  • The System Credentials are the credentials required to access the system. These credentials are used to log in to the system and run restore operations.
  • The Database Credentials are used for querying the database and running copy operations. The user needs sufficient privileges to access the database.


 

Privileges

The IBM Storage Copy Data Management agent user needs the following privileges:

  • Privileges to run commands as root and other users by using sudo. IBM Storage Copy Data Management requires these privileges for various tasks such as discovering storage layouts and mounting and unmounting disks.
    • The sudoers configuration must allow the IBM Storage Copy Data Management agent user to run commands without a password.
    • The !requiretty setting must be set.



 

Restore and revert


Restore Jobs

When you restore a database or file system from an XFS file system, the restore process might fail if the "xfsprogs" package version on the destination server is between 3.2.0 and 4.1.9. To resolve the issue, upgrade xfsprogs to version 4.2.0 or later.


 

Revert Jobs

When you run revert jobs on SAP HANA, there are special considerations that must be met for jobs to successfully complete:

  • SAP HANA data and the operating system (OS) file system must be on separate datastores.
  • Ensure that the databases are on independent storage. The underlying storage volume for the databases being reverted must not contain data for other databases. Also, must not contain a datastore that is shared by other virtual machines (VMs) or by other databases not being reverted.
  • Ensure that the production databases are not on VMDK disks that are part of a VMware VM snapshot.
  • All VM snapshots need to be removed from the SAP HANA server before you run the revert function.
  • Production databases are automatically shut down during the revert.
  • Revert is available only after a restore is completed.

When you create a job, you need to set the default revert action for the job. Only SAP HANA can use the revert database function. This behavior is controlled through the Revert Database option during the job creation process:

  • Enabled – Always revert the database.
  • Disabled – Never reverts the database.
  • User Selection – Allows the user to make the determination to revert the database when the job session is pending.
     
Restriction: The revert function is not supported for HyperSwap environments, see APAR IT42565



 

Sample Configuration

The following commands are examples for creating and configuring an operating system user that IBM Storage Copy Data Management uses to log in to the application server. The command syntax might vary depending on your operating system type and version.

  • Create the user that is designated as the IBM Storage Copy Data Management agent user:
    useradd -m cdmagent
  • If you use password-based authentication, set a password:
    passwd cdmagent
  • If you use key-based authentication, place the public key in /home/cdmagent/.ssh/authorized_keys, or the appropriate file depending on your sshd configuration, and ensure that the correct ownership and permissions are set, such as:
    chown -R cdmagent:cdmagent /home/cdmagent/.ssh
    chmod 700 /home/cdmagent/.ssh
    chmod 600 /home/cdmagent/.ssh/authorized_keys
  • Place the following lines at the end of your sudoers configuration file, typically /etc/sudoers. If the existing sudoers file is configured to import configuration from another directory (for example, /etc/sudoers.d), you can also place the lines in a new file in that directory:
    Defaults:cdmagent !requiretty
    cdmagent ALL=(ALL) NOPASSWD:ALL



 

[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSCY00","label":"IBM Storage Copy Data Management"},"ARM Category":[{"code":"a8m3p000000hBYdAAM","label":"HW\/SW Requirements"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.2.20","Type":"MASTER"}]

Product Synonym

IBM Spectrum Copy Data Management;

Document Information

Modified date:
13 June 2023

UID

ibm16992019