How to manage SAP IQ License in HA Scenario
Published Feb 24 2021 12:18 PM 2,072 Views
Microsoft

How to manage SAP IQ License in HA Scenario

 

This blog is an extension to Deploy SAP IQ-NLS HA Solution using Azure NetApp Files on SUSE Linux Enterprise Server

 

As part of this blog, we will learn how to manage the SAP IQ license when configured for High-Availability on ANF.

 

Problem Statement: 

The SAP IQ High Availability Architecture on ANF proposes to hosts the SAP IQ database on ANF Volume.

 
As part of failover, the database filesystem [ANF Volume] moves from Node1 to Node2. The files including the license file on ANF Volume remain static, meaning the license will have Node1 hostname [Old Primary node] when it failovers to Node2 [New Primary node] stopping SAP IQ from start-up on Node2 as part of failover.

SAP IQ-NLS HA Solution using ANF on SLES & Agent.png

The above architecture points to an update (option) where SBD VM's can be replaced with Azure Fencing Agent to simplify the architecture.

 

Solution:

Please refer to SAP Note 26286202376507 to understand further on SAP IQ License generation and options.

Follow the below steps to update the license key for ANF volume

1. Based on the SAP IQ system, generate Production type CP license or non-production type DT for Primary node.

2. Generate Standby license type SF for Secondary node. System type must be Backup system & License Type should be Standby Instance [IB] [On SAP Portal, the selection will be IB].

SAP IQ-NLS HA Solution using ANF on SLES & Agent_NONPRD.png

 

3. Create two separate .lmp files with below format <hostname1>.lmp

In this LT should be equal to CP (for prod) and DT (for non-prod)

SAP IQ-NLS HA Solution using ANF on SLES & Agent_NONPRD_2.png

<hostname2>.lmp

In this LT should be equal to SF (for Standby node)

SAP IQ-NLS HA Solution using ANF on SLES & Agent_NONPRD_3.png

 

4. Change IQ startup script (sapiq_start.sh) and add below code lines into the script cd <path to database directory

hostnm=`hostname`

if [ -f ./${hostnm}.lmp ]; then

cp ${hostnm}.lmp SAPIQDB_<SID>.lmp fi

SAP IQ-NLS HA Solution using ANF on SLES & Agent_NONPRD_4.png

 

5. Start the cluster and execute HA test cases for validation.

 

 

Co-Authors
Version history
Last update:
‎Feb 26 2021 02:51 PM
Updated by: