5 1 0:SAP IQ Configuration

Welcome to the latest SEP sesam documentation version 5.1.0 Apollon. For previous documentation version(s), check documentation archive.

Overview

Additional resources

Visit SEP sesam YouTube Channel for latest videos and webinars.

Check FAQ to find the answers to most common questions.

Problems? See the Troubleshooting Guide.

If you are using an older SEP sesam version, refer to Documentation archive.

This article describes the prerequisites and configuration requirements for the SAP IQ environment. Note that the procedures presented in this article are only the required pre-configuration steps. For details on the SAP IQ integration key features, available backup methods and backup configuration, see SAP IQ Backup.

SEP sesam supports backup and restore of your SAP IQ database environment using the libsepsybasebr library. The SEP sesam installation contains the library libsepsybase that must be renamed to libsepsybasebr for the SAP IQ API integration with the local operating system.

Key features of the SEP sesam SAP IQ integration

Easy automation of backups with SEP sesam command events.
Automatic retention management for your SAP IQ database and transaction log backups.
Simple overview and monitoring with Web UI.
No more manual housekeeping jobs for local backups.
Enables integration with system refresh utilities.

Prerequisites

To ensure error-free operation of SEP sesam and improve performance, make sure that the following conditions are met:

Check the support matrix for the list of supported SAP IQ versions.
Download SEP sesam from SEP Download Center. It is strongly recommended to use the latest SEP sesam version. A SEP sesam Client must be installed on the server hosting the SAP IQ database and added to the SEP sesam environment. For details, see SEP Sesam Quick Install Guide.
Verify that your network is set up correctly and that DNS name resolution is successful. Note that forward and reverse DNS resolution is required by SEP sesam. For details, see How to check DNS configuration.
It is recommended that 10 Gigabit Ethernet (10GbE) is available for larger backups.
Once your SEP sesam is installed, import your SEP sesam license. For details, see Licensing.
Configure SEP sesam and ensure that a data store has sufficient space. For general details, see SEP sesam data store.

Configuration procedure

Once you have downloaded the SEP sesam package, proceed as follows. Note that the following requirements must be met if you want to install the library manually:

You need to know where your SAP IQ database server is installed (for example, <DRIVE>:\sapiq\<SID>).
Ensure that you have read/write permissions to access your $SAPIQ or %SAPIQ% directory.
You must know the password of your database server administrator (SA).

Steps

Locate the libsepsybase.so (Linux) or libsepsybase.dll (Windows) file in your SEP sesam installation path. The default installation path on Linux is /opt/sesam/bin/sesam and on Windows C:\Program Files\SEPsesam\bin\sesam.
SAP IQ uses the library as libsepsybasebr. To provide the library:
- On Windows, copy the file to your %SYBASE%\%SAPIQ%\lib64 folder and then rename it to libsepsybasebr.dll.
- On Linux, copy the file to $SYBASE/$SAPIQ/lib64/libsepsybasebr.so or create a soft link:
```
ln -s /opt/sesam/bin/sesam/libsepsybase.so $SYBASE/$SAPIQ/lib64/libsepsybasebr.so
```
  Make sure the file is executable for the user running your SAP IQ database process.
To protect your SAP IQ databases, configure the SAP IQ server as a SEP sesam Client. For details, see Configuring Clients.