DB2 Installation Guide on ANF
Published Jan 27 2023 07:14 PM 8,110 Views
Microsoft

DB2 Installation Guide on ANF

Introduction

This document will show how you can install SAP NetWeaver 7.5 based on IBM DB2 11.1 and SLES12SP5 in Azure using Azure NetApp Files (ANF) as storage platform for data and log areas.

As of July 26th 2022, this combination is fully supported by IBM. SAP notes:

2015553 - SAP on Microsoft Azure: Support prerequisites - SAP ONE Support Launchpad

 

Microsoft documentation

IBM Db2 Azure Virtual Machines DBMS deployment for SAP workload - Azure Virtual Machines | Microsoft...

Set up IBM Db2 HADR on Azure virtual machines (VMs) - Azure Virtual Machines | Microsoft Docs

SAP on UNIX and DB2 with NFS and Network Appliance Storage | NetApp

 

First create an Azure VM in your Azure Subscription

In this case we created an E16-8ds_v4 with 128GB of RAM and deployed SLES12SP5 on it.

 

RalfKlahr_0-1685663059105.jpeg

Volume design on ANF

Create the volume structure on ANF. The size of each volume is depending on a proper capacity and performance sizing-

RalfKlahr_2-1672929472329.png

 

The performance tier and the size of the volumes must be chosen based on the performance requirements.

 

Mount the volumes and create the directories.

vi /etc/idmapd.conf
 # Example
 [General]
 Domain = defaultv4iddomain.com
 [Mapping]
 Nobody-User = nobody
 Nobody-Group = nobody

  

Create the directory structure on the OS and on the NetApp volumes.

 

mount -t nfs -o rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 172.17.10.4:/ralfdb2shared /mnt
mkdir -p /db2/Software /usr/sap/AN1 /sapmnt/AN1 /home/an1adm /db2/AN1/db2_software
mkdir -p /mnt/Software /mnt/saptmp  /mnt/usr_sap /mnt/sapmnt /mnt/an1_home /mnt/db2_software
umount /mnt

 

mount -t nfs -o rw,hard, nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 172.17.10.4:/ralfdb2data /mnt
mkdir -p /db2/AN1/sapdata/sapdata1 /db2/db2an1 /db2/AN1/db2an1 /db2/AN1/sapdata/sapdata2 /db2/AN1/sapdata/sapdata3 /db2/AN1/sapdata/sapdata4
mkdir -p /mnt/sapdata1 /mnt/db2an1 /mnt/db2_an1 /mnt/sapdata2 /mnt/sapdata3 /mnt/sapdata4
umount /mnt

 

mount -t nfs -o rw,hard, nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 172.17.10.4:/ralfdb2log /mnt
mkdir /db2/AN1/log_dir
mkdir /mnt/log_dir
umount /mnt
mount -t nfs -o rw,hard, nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 172.17.10.4:/ralfdb2saptmp /mnt
mkdir /db2/AN1/saptmp1
umount /mnt

  

mount -t nfs -o rw,hard, nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 172.17.10.4:/ralfdb2log_archive /mnt
mkdir /db2/AN1/backup /mnt/log_archive /mnt/db2dump
umount /mnt
vi /etc/fstab
...
..
172.17.10.4:/ralfdb2shared/Software  /db2/Software    nfs4        rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
172.17.10.4:/ralfdb2shared/db2_software /db2/AN1/db2_software nfs4 rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
172.17.10.4:/ralfdb2shared/usr_sap   /usr/sap/AN1     nfs4        rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
172.17.10.4:/ralfdb2shared/sapmnt    /sapmnt/AN1      nfs4        rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
172.17.10.4:/ralfdb2shared/an1_home  /home/an1adm     nfs4        rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
#
172.17.10.4:/ralfdb2data/sapdata1    /db2/AN1/sapdata/sapdata1 nfs4  rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
172.17.10.4:/ralfdb2data/db2an1    /db2/db2an1 nfs4  rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
172.17.10.4:/ralfdb2data/db2_an1    /db2/AN1/db2an1 nfs4  rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
#
172.17.10.4:/ralfdb2saptmp    /db2/AN1/saptmp nfs4        rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
#
172.17.10.4:/ralfdb2log/log      /db2/AN1/log_dir          nfs4  rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
#
172.17.10.4:/ralfdb2log_archive/log_archive /db2/AN1/log_archive nfs4 rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
172.17.10.4:/ralfdb2log_archive/db2dump /db2/AN1/db2dump nfs4 rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
172.17.10.4:/ralfdb2log_archive/backup   /db2/AN1/backup nfs4  rw,hard,nconnect=8,sync,rsize=262144,wsize=262144,vers=4.1,tcp 0  0
mount -a

Prepare the SAP installation

Download the required packages from the SAP Software Download Center. Store the files in /db2/Software.

ralfdb2vm01:/db2/Software # ls -l
drwxr-xr-x  3 root root      4096 51050829_3_Export
drwxr-xr-x  3 root root      4096 51054236_DB2_11.1_Client
drwxr-xr-x  3 root root      4096 51054886_DB2_11.1_MP4_FP6
drwxr-xr-x  3 root root      4096 51054888_DB2_11.1_MP4_FP6_Data
drwxr-xr-x  2 root root      4096 Kernel_753
-rw-r--r--  1 root root   4483040 SAPCAR
drwxr-xr-x 34 root root      4096 SWPM

 

ralfdb2vm01:/db2/Software/Kernel_753 # ls -l
-rw-r--r-- 1 root root  53267510 DBATL740O11_44-80002679.SAR
-rw-r--r-- 1 root root  18564826 SAPEXEDB_800-80002603.SAR
-rw-r--r-- 1 root root 365661644 SAPEXE_800-80002573.SAR
-rw-r--r-- 1 root root  95454415 SAPHOSTAGENT51_51-20009394.SAR
-rw-r--r-- 1 root root 104064440 igsexe_13-80003187.sar
-rw-r--r-- 1 root root  62964377 igshelper_17-10010245.sar

 

Maintain the hosts file

vi /etc/hosts
127.0.0.1       localhost
172.17.4.6      ralfdb2vm01.lab.demo.com ralfdb2vm01

 

vi /etc/hostname
ralfdb2vm01.lab.demo.com


Uncommennt the DB2 port in the /etc/services file

vi /etc/services
#fis                5912/tcp     # Flight Information Services 
#fis                5912/udp     # Flight Information Services 
#fis                5912/sctp    # Flight Information Services 

 

Copy the SAPCAR to /usr/bin which allows you an easier usage.

cd /db2/Software
cp SAPCAR /usr/bin
chmod 755 /usr/bin/SAPCAR

  

Update the system

uname -a  # actual Kernel 4.12.14-16.44-azure
zypper up
zypper in libstdc++6-32bit libstdc++33-32bit gcc-c++
zypper in sap-locale sap_server sapconf gcc
uname -a  à 4.12.14-16.56-azure

Set the SAP NetWeaver parameter to the OS and make sure the sapconf is running. If you run SLES for SAP Solutions also saptune is available.

sapconf netweaver

 

systemctl status sapconf
sapconf.service - sapconf
Loaded: loaded (/usr/lib/systemd/system/sapconf.service; enabled; vendor preset: enabled)
Active: active (exited) since Fri 2021-05-14 11:37 UTC; 3min 1s ago
Process: 3827 ExecStart=/usr/sbin/sapconf start (code=exited, status=0/SUCCESS)
Main PID: 3827 (code=exited, status=0/SUCCESS)
    Tasks: 0 (limit: 512)
      CPU: 0
CGroup: /system.slice/sapconf.service

 

Disable the Firewall

systemctl disable SuSEfirewall2_init
systemctl disable SuSEfirewall2

Now start the SAP Installation

cd /db2/Software/SWPM
./sapinst
[==============================] - extracting...  done! -xf ../SWPM10SP31_5-20009701.SAR
********************************************************************

Open your browser and paste the following URL address to access the GUI

https://ralfdb2vm01.lab.demo.com:4237/sapinst/docs/index.html

Logon users: [root]

RalfKlahr_3-1672929472331.png

 

RalfKlahr_4-1672929472335.png

 

 

Select SAP NetWaever 7.5

RalfKlahr_5-1672929472340.png

 

 

Select Custom

RalfKlahr_6-1672929472351.png

 

 

 

Define the SID

RalfKlahr_7-1672929472357.png

 

Select the FQDN

RalfKlahr_8-1672929472365.png

 

Set the default password

RalfKlahr_9-1672929472372.png

 

 

 

Specify the <sid>adm user parameter

RalfKlahr_10-1672929472379.png

 

I keep the DN-SID like the SID of the SAP instance

RalfKlahr_11-1672929472388.png

 

Sinse we use 11.1 MP4 we need to specify “Allow unsigned database versions”

RalfKlahr_12-1672929472395.png

 

Keep it like it is

RalfKlahr_13-1672929472432.png

 

Specify the database software location

RalfKlahr_14-1672929472446.png

 

 

 

Specify the db2 user parameter

RalfKlahr_15-1672929472454.png

 

Specify the ABAP connect user

RalfKlahr_16-1672929472464.png

 

 

 

We keep the group-ID’s as default, this of course is customer specific

RalfKlahr_17-1672929472473.png

 

 

Specify the Kernel location

RalfKlahr_18-1672929472481.png

 

RalfKlahr_19-1672929472493.png

 

Specify the location of the SAPHOSTAGENT

 

RalfKlahr_21-1672929472516.png

 

 

Specify the sapadm user details

RalfKlahr_22-1672929472525.png

 

 

 

Specify the export location

RalfKlahr_23-1672929472532.png

 

Specify the DB Software repository

RalfKlahr_24-1672929472547.png

 

For ERP we do not select DB2 BLU here

RalfKlahr_25-1672929472558.png

 

 

 

The DB memory is, of course, very customer specific

RalfKlahr_26-1672929472583.png

 

Use the default here

RalfKlahr_27-1672929472597.png

 

 

 

For the test system we do not use any encryption. This is also customer specific.

RalfKlahr_28-1672929472603.png

 

No pureScale and no Tivoli for this installation

RalfKlahr_29-1672929472610.png

 

RalfKlahr_30-1672929472616.png

 

Keep the default here

RalfKlahr_31-1672929472622.png

 

Specify the location of the DB2 11.1 client

RalfKlahr_32-1672929472629.png

 

Since we use ANF (NFS) here we need to unselect the ASM here

RalfKlahr_33-1672929472637.png

 

RalfKlahr_34-1672929472647.png

 

RalfKlahr_35-1672929472656.png

 

Keep the default here unless you have customer details.

RalfKlahr_36-1672929472671.png

 

This must be aligned to our storage design, so it must be:

/db2/AN1/sapdata/sapdata1..n

RalfKlahr_37-1672929472678.png

 

Keep the default here

RalfKlahr_38-1672929472689.png

 

 

RalfKlahr_39-1672929472695.png

 

That was the DB part. Now we enter the specification of the Application Server

We define 00 for the PAS the 00 and for the ASCS the 01

RalfKlahr_40-1672929472703.png

 

This will result in the following port numbers.

RalfKlahr_41-1672929472710.png

 

This is customer specific

RalfKlahr_42-1672929472719.png

 

We keep the default passwords here

RalfKlahr_43-1672929472727.png

 

No SLD integration here. This will be, most likely, different in a customer installation.

RalfKlahr_44-1672929472746.png

 

Also default here

RalfKlahr_45-1672929472758.png

 

RalfKlahr_46-1672929472772.png

 

We use the default Secure Storage key here

RalfKlahr_47-1672929472777.png

 

We keep the user in the sapinst group.

RalfKlahr_48-1672929472783.png

 

 

After reviewing the specified parameter let it run….

RalfKlahr_49-1672929472786.png

 

 

RalfKlahr_50-1672929472791.png

 

System is up and running

 

End

Co-Authors
Version history
Last update:
‎Jun 01 2023 04:54 PM
Updated by: