FSx for ONTAP for SAP MaxDB

Before you create FSx for ONTAP file system, determine the total storage space you need for your SAP MaxDB system. You can increase the storage size later. To decrease the storage size, you must create a new file system.

To create a FSx for ONTAP file system, see Step 1: Create an Amazon FSx for NetApp ONTAP file system. For more information, see Managing FSx for ONTAP file systems.

Create storage virtual machines (SVM)

You get one SVM per FSx for ONTAP file system by default. You can create additional SVMs at any time. We recommend a separate SVM for each volume. You don't need to join your file system to Active Directory for SAP MaxDB. For more information, see Managing FSx for ONTAP storage virtual machines.

Volume configuration and layout

The storage capacity of your file system should align with the needs of SAP MaxDB data, log, and backup volumes. We recommend creating a separate FSx for ONTAP file system for each of these volumes. You must also consider the capacity required for snapshots, if applicable.

The following table lists example recommendation sizes per volume.

Volume name	Junction name	Linux mount points
<DBSID>-sapmnt	<DBSID>-sapmnt	/sapmnt/
<DBSID>-usrsap	<DBSID>-usrsap	/usr/sap
<DBSID>-sapdata	<DBSID>-sapdata	/sapdb/<DBSID>/sapdata
<DBSID>-saplog	<DBSID>-saplog	/sapdb/<DBSID>/saplog
<DBSID>-backup	<DBSID>-backup	/sapdb/<DBSID>/backup
<DBSID>-sapdb	<DBSID>-sapdb	/sapdb

File system setup

After creating a FSx for ONTAP file system, you must complete additional file system setup.

Set administrative password

If you did not create an administrative password during FSx for ONTAP file system creation, you must set an ONTAP administrative password for fsxadmin user.

The administrative password enables you to access the file system via SSH, the ONTAP CLI, and REST API. To use tools like NetApp SnapCenter, you must have an administrative password.

Sign in to the management endpoint via SSH

Get the DNS name of the management endpoint from AWS console. Sign in to the management endpoint via SSH, using the fsxadmin user and administrative password.

ssh fsxadmin@management.<file-system-id>.fsx.<aws-region>.amazonaws.com Password:

Set TCP max transfer size

We recommend a TCP max transfer size of 262,144 for your SAP MaxDB systems. Elevate the privilege level to advanced and use the following command on each SVM.

set advanced
nfs modify -vserver <svm> -tcp-max-xfer-size 262144
set admin      

Disable snapshots

FSx for ONTAP automatically enables a snapshot policy for volumes that take hourly snapshots. The default policy offers limited value due to missing application awareness. We recommend disabling the automatic snapshots by setting the policy to none.

volume modify -vserver <vserver-name> -volume <volume-name> -snapshot-policy none