SAP HANA Studio Best Practices for DPX Plugin

SAP HANA Studio is a client tool used to access and manage SAP HANA databases. Databases must be registered and configured through the SAP HANA Studio interface.

Before you begin

SAP HANA Studio must be installed on a SAP supported machine and is used to manage SAP HANA database. For more information, consult the SAP HANA Studio documentation.

The DPX client software must be installed on the SAP HANA node. For more information, see Installing the DPX client for SAP HANA.

The plugin must be installed and configured on the SAP HANA mode. For more information, see Installing and Configuring the DPX Plugin for SAP HANA.

About this task

Database systems must be registered and configured in SAP HANA Studio before backup and restore (recovery) jobs can be initiated. When adding a system to Studio, make sure to select Multiple containers mode. Completed the following procedure for each system that is to be protected with DPX.

Procedure

To register a database system and verify configuration in SAP HANA Studio, complete the following steps:

1. Launch SAP HANA Studio.

2. Click on the Specify System button above the Systems pane. The System window will open.

3. Enter the following information for Specify System:

   • The SAP HANA node hostname in the Host Name field.

   • Enter an instance number in the Instance Number field.

   • For Mode, select Multiple containers.

   • Leave System database selected.

Note. By default, SAP HANA 2.0 SPS 01 and later versions run in Multiple containers mode. To ensure proper functionality of the DPX plugin, select Multiple Container mode when adding a system in SAP HANA Studio. This applies even when adding systems with a single tenant database.

1. Click Next. The System window will remain open and Connection Properties is displayed.

2. Select Authentication by database user.

3. Enter a database username in the User Name field and the password in the Password field.

4. Select Enable SAP start service connection.

5. Click Finish.

6. Click on the Backup entry in the tree under the SAP HANA database system that was registered in the Systems pane. The Backup SYSTEMDB@<xxx> (SYSTEM) pane will open, where <xxx> is the Security ID.

7. Click on the Configuration tab. Expand Backint Settings.

8. Verify that Backint Agent is set to /opt/DPX/bin/dpxhdb.

9. Verify that Backint Parameter File has the proper path set to /usr/sap/<xxx>/SYS/global/hdb/opt/hdbconfig/dpxhdb.utl, where <xxx> is the Security ID of the SAP HANA database.

10. In the Log Backup Setting section, ensure that Backint is selected for Destination Type.

Results

The SAP HANA database system has been registered in SAP HANA Studio. Each database that will be protected by DPX must be registered.

What to do next

Run a backup job. For more information, see Running a backup job with SAP HANA Studio.