SAP HANA

Configuring parameters related to backint integration #

To start using Emory for your SAP HANA backups, you must set some specific SAP HANA parameters. You can select to update these parameters by using SAP HANA Studio, SQL Commands or Command Line. Choose your prefered option to perform these steps.

Find more information about the backint related parameters in the SAP HANA Administration Guide.
  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.

    Example: Screenshot


  1. SSH to your SAP HANA Database server as the sidadm user.

  2. Navigate to the HANA configuration directory

    cd /hana/shared/$SAPSYSTEMNAME/global/hdb/custom/config
    
  3. Modify file global.ini using your prefered text editor.

    vi global.ini
    

    or

    nano global.ini
    
  4. Add the following lines to the file.

    [backup]
    data_backup_parameter_file = /usr/sap/<SID>/SYS/global/hdb/opt/conf/emory.cfg
    catalog_backup_parameter_file = /usr/sap/<SID>/SYS/global/hdb/opt/conf/emory.cfg
    catalog_backup_using_backint = true
    log_backup_parameter_file = /usr/sap/<SID>/SYS/global/hdb/opt/conf/emory.cfg
    log_backup_using_backint = true
    data_backup_buffer_size = 4096
    parallel_data_backup_backint_channels = 8
    
    [communication]
    tcp_backlog = 2048
    
    [persistence]
    enable_auto_log_backup = yes  
    
    
Remember to change <SID> with your correct SAPSYSTEMNAME
  1. Save the file and restart your SAP HANA instance.
  1. Open HANA Studio or hdbsql session

  2. Open SQL Console or connected via hdbsql from command-line, execute the following commands:

    # Backup parameters
    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;
    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; 
    ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'catalog_backup_using_backint') = 'true' WITH RECONFIGURE;
    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;
    ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'log_backup_using_backint') = 'true' WITH RECONFIGURE;
    ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'parallel_data_backup_backint_channels') = '8' WITH RECONFIGURE;
    
    # Communication
    ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'communication', 'tcp_backlog') = '2048' WITH RECONFIGURE;
    
    # Persistence
    ALTER SYSTEM ALTER CONFIGURATION ( 'global.ini', 'SYSTEM' ) SET( 'backup', 'data_backup_buffer_size') = '4096' WITH RECONFIGURE;
    

Check SAP Note 2458043 to define the correct vaules for parallel backint channels

2458043 - SAP HANA Multistreaming Backup to Backint does not work