Configure backint-related parameters

As part of any Third-Party Backup Tool configuration, as described in Backup Configuration Parameters in the SAP HANA Administration Guide, before you start using Backint, you must set the following SAP HANA parameters. These parameters will configure SAP HANA to send the backups to Backint instead of using a disk storage target.

_14

[backup]

_14

data_backup_parameter_file = /usr/sap/<SID>/SYS/global/hdb/opt/conf/emory.cfg

_14

catalog_backup_parameter_file = /usr/sap/<SID>/SYS/global/hdb/opt/conf/emory.cfg

_14

catalog_backup_using_backint = true

_14

log_backup_parameter_file = /usr/sap/<SID>/SYS/global/hdb/opt/conf/emory.cfg

_14

log_backup_using_backint = true

_14

data_backup_buffer_size = 4096

_14

parallel_data_backup_backint_channels = 8

_14

_14

[communication]

_14

tcp_backlog = 2048

_14

_14

[persistence]

_14

enable_auto_log_backup = yes

tip

For parallel backint channels check SAP Note 2458043 - SAP HANA Multistreaming Backup to Backint does not work for the proper parameters.

Use one of the following methods to configure the parameters:

• Configure using Hana Studio
• Configure using command line
• Configure using SQL Commands

---

Configure using Hana Studio

You can set the parameters using HANA Studio configuration section:

1. Open Hana Studio and connect to the SYSTEMDB database.
2. Select Configuration and Monitoring -> Open Administration
3. Open to the Configuration tab.
4. Modify the values in the [global.ini][backup] section.

---

Configure using command line

You can set the parameters using the following commands:

• SSH to your SAP HANA Database server as the SAP HANA Administrator User (sidadm).

• Navigate to the HANA configuration directory

  sidadm

  
  

  _10

  cd /hana/shared/$SAPSYSTEMNAME/global/hdb/custom/config

  
  

• Modify file global.ini using your prefered text editor.

  sidadm

  
  

  _10

  vi global.ini

  
  

• Add the parameters at the beginning of the page:

  Change SID

  Remember to change <SID> with your correct SAPSYSTEMNAME

• Save the file and restart your SAP HANA instance.

---

Configure using SQL Commands

You can set the parameters using the following SQL statements:

1. Open a database session by using HANA Studio or hdbsql

2. On the session opened, paste the following contents:

   hdbsql

   
   

   _13

   # Backup parameters

   _13

   ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'data_backup_parameter_file') = '/usr/sap/<SID>/SYS/global/hdb/opt/conf/emory.cfg' WITH RECONFIGURE;

   _13

   ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'catalog_backup_parameter_file') = '/usr/sap/<SID>/SYS/global/hdb/opt/conf/emory.cfg' WITH RECONFIGURE;

   _13

   ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'catalog_backup_using_backint') = 'true' WITH RECONFIGURE;

   _13

   ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'log_backup_parameter_file') = '/usr/sap/<SID>/SYS/global/hdb/opt/conf/emory.cfg' WITH RECONFIGURE;

   _13

   ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'log_backup_using_backint') = 'true' WITH RECONFIGURE;

   _13

   ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'parallel_data_backup_backint_channels') = '8' WITH RECONFIGURE;

   _13

   _13

   # Communication

   _13

   ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'communication', 'tcp_backlog') = '2048' WITH RECONFIGURE;

   _13

   _13

   # Persistence

   _13

   ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'data_backup_buffer_size') = '4096' WITH RECONFIGURE;

   
   
   Change SID

   Remember to change <SID> with your correct SAPSYSTEMNAME