Guest RalfKlahr Posted January 28, 2023 Posted January 28, 2023 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 Docs 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. Volume design on ANF Create the volume structure on ANF. The size of each volume is depending on a proper capacity and performance sizing- 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,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 172.17.10.4:/ralfdb2shared /mnt mkdir -p /db2/Software /db2/AN1/saptmp /usr/sap/AN1 /sapmnt/AN1 /home/an1adm /db2/db2an1 /db2/AN1/db2_software mkdir -p /mnt/Software /mnt/saptmp /mnt/usr_sap /mnt/sapmnt /mnt/an1_home /mnt/db2_software /mnt/db2an1 umount /mnt mount -t nfs -o rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 172.17.10.4:/ralfdb2data /mnt mkdir -p /db2/AN1/sapdata/sapdata1 /db2/AN1/sapdata/sapdata2 /db2/AN1/sapdata/sapdata3 /db2/AN1/sapdata/sapdata4 mkdir -p /mnt/sapdata1 /mnt/sapdata2 /mnt/sapdata3 /mnt/sapdata4 umount /mnt mount -t nfs -o rw,hard,sync,rsize=262144,wsize=262144,sec=sys,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,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 172.17.10.4:/ralfdb2backup /mnt mkdir /db2/AN1/backup mkdir /mnt/backup mkdir /db2/AN1/offline_log_dir /db2/AN1/db2dump mkdir /mnt/offline_log_dir /mnt/db2dump umount /mnt vi /etc/fstab ... .. 172.17.10.4:/ralfdb2shared/Software /db2/Software nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2shared/saptmp /db2/AN1/saptmp nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2shared/db2_software /db2/AN1/db2_software nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2shared/usr_sap /usr/sap/AN1 nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2shared/sapmnt /sapmnt/AN1 nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2shared/an1_home /home/an1adm nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2shared/db2an1 /db2/db2an1 nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2data/sapdata1 /db2/AN1/sapdata/sapdata1 nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2data/sapdata2 /db2/AN1/sapdata/sapdata2 nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2data/sapdata3 /db2/AN1/sapdata/sapdata3 nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2data/sapdata4 /db2/AN1/sapdata/sapdata4 nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2log/log_dir /db2/AN1/log_dir nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2backup/offline_log_dir /db2/AN1/offline_log_dir nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 172.17.10.4:/ralfdb2backup/db2dump /db2/AN1/db2dump nfs4 rw,hard,sync,rsize=262144,wsize=262144,sec=sys,vers=4.1,tcp 0 0 mount -a df -h Filesystem Size Mounted on 172.17.10.4:/ralfdb2shared/saptmp 200G /db2/AN1/saptmp 172.17.10.4:/ralfdb2shared/db2_software 200G /db2/AN1/db2_software 172.17.10.4:/ralfdb2shared/usr_sap 200G /usr/sap/AN1 172.17.10.4:/ralfdb2shared/sapmnt 200G /sapmnt/AN1 172.17.10.4:/ralfdb2shared/an1_home 200G /home/an1adm 172.17.10.4:/ralfdb2shared/db2an1_home 200G /db2/db2an1 172.17.10.4:/ralfdb2data/sapdata1 500G /db2/AN1/sapdata/sapdata1 172.17.10.4:/ralfdb2data/sapdata2 500G /db2/AN1/sapdata/sapdata2 172.17.10.4:/ralfdb2data/sapdata3 500G /db2/AN1/sapdata/sapdata3 172.17.10.4:/ralfdb2data/sapdata4 500G /db2/AN1/sapdata/sapdata4 172.17.10.4:/ralfdb2log/log_dir 200G /db2/AN1/log_dir 172.17.10.4:/ralfdb2backup/offline_log_dir 400G /db2/AN1/offline_log_dir 172.17.10.4:/ralfdb2backup/db2dump 400G /db2/AN1/db2dump 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] Select SAP NetWaever 7.5 Select Custom Define the SID Select the FQDN Set the default password Specify the <sid>adm user parameter I keep the DN-SID like the SID of the SAP instance Sinse we use 11.1 MP4 we need to specify “Allow unsigned database versions” Keep it like it is Specify the database software location Specify the db2 user parameter Specify the ABAP connect user We keep the group-ID’s as default, this of course is customer specific Specify the Kernel location Specify the location of the SAPHOSTAGENT Specify the sapadm user details Specify the export location Specify the DB Software repository For ERP we do not select DB2 BLU here The DB memory is, of course, very customer specific Use the default here For the test system we do not use any encryption. This is also customer specific. No pureScale and no Tivoli for this installation Keep the default here Specify the location of the DB2 11.1 client Since we use ANF (NFS) here we need to unselect the ASM here Keep the default here unless you have customer details. This must be aligned to our storage design, so it must be: /db2/AN1/sapdata/sapdata1..n Keep the default here 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 This will result in the following port numbers. This is customer specific We keep the default passwords here No SLD integration here. This will be, most likely, different in a customer installation. Also default here We use the default Secure Storage key here We keep the user in the sapinst group. After reviewing the specified parameter let it run…. System is up and running End Continue reading... Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.