Operations
In this section we will cover some of the native Amazon services that help you with day-to-day operations of your IBM Db2 database for SAP applications.
Monitoring
Amazon provides multiple native services to monitor and manage your infrastructure and applications on Amazon. Services like Amazon CloudWatch
CloudWatch provides ready-to-use key performance indicators (KPIs) that you can use to monitor CPU utilization and disk utilization.
You can also create custom metrics
With Amazon CloudTrail, you can log, continuously monitor, and retain account activity related to actions across your Amazon infrastructure. Amazon CloudTrail is enabled on all Amazon accounts, and records your account activity upon account creation. You can view and download the last 90 days of your account activity for create, modify, and delete operations of supported services without the need to manually set up CloudTrail.
Backup and Recovery
You need to regularly back up your operating system and database to recover them in case of failure. Amazon provides various services and tools that you can use to back up your IBM Db2 database of SAP applications.
Amazon Backup
Amazon Backup
AMI
You can use the Amazon Management Console
The Amazon CLI create image command creates a new AMI based on an existing Amazon EC2 instance. The new AMI contains a complete copy of the operating system and its configuration, software configurations, and optionally all EBS volumes that are attached to the instance.
A simple command to create an AMI with reboot (if running) of your EC2 instance (with instance ID i-0b09a25c58929de26 as example) including all attached EBS volumes:
aws ec2 create-image --instance-id i-0b09a25c58929de26 --name "My server"
A simple command to create AMI without reboot (if running[underline]) of your EC2 instance (with instance ID i-0b09a25c58929de26 as example) including all attached EBS volumes:
aws ec2 create-image --instance-id i-0b09a25c58929de26 --name "My server" --no-reboot
Amazon EBS Snapshots
You can back up your Amazon EBS volumes to Amazon S3 by taking point-in-time snapshots. Snapshots are incremental backups, which means that only the blocks on the device that have changed after your most recent snapshot are saved.
Snapshots are suited to backup SAP file systems like /usr/sap/* , /sapmnt/*. We do not recommend using snapshots to back up your volumes containing data and log files. If you decide to take snapshots for your database volume snapshot, keep in mind that for consistency you should use Microsoft’s Volume Shadow Copy Service
A simple command to create a snapshot of volume (with volume id vol-1234567890abcdef0 as example):
aws ec2 create-snapshot --volume-id vol-1234567890abcdef0 --description "This is my volume snapshot."
Database Backups
One of following methods can be used for IBM Db2 database backup:
-
With native tools to take backup on disk-- Backup requires high throughput compared to Input/Output Operations Per Second (IOPS). We recommend using st1 disk
, which provides maximum throughput of 500MB/s per volume. Once the backup completes on disk it can be moved to an Amazon S3 bucket via scripts. -
With third party backint tools-- There are many third-party tools from partners like Commvault and Veritas that use SAP backint interface and store backups directly in Amazon S3 buckets.
Storage
The storage services we use across this guide are:
Amazon EBS
Amazon EBS
Once you have extended the volume, you need to extend the drive with your Linux volume manager software.
Amazon S3
Amazon S3
Operating System Maintenance
Operating system maintenance across large estates of EC2 instances can be managed by:
-
Tools specific to each operating system such as SUSE Manager
and Red Hat Smart Management . -
3rd party products such as those available on the Amazon Marketplace
. -
Using Amazon Systems Manager
.
Here are some key operating system maintenance tasks that can help with:
Patching
Follow SAP recommended patching processes to update your landscape on Amazon. For operating system patching, with Amazon Systems Manager Patch Manager
-
Scheduling based on tags
-
Auto-approving patches with lists of approved and rejected patches
-
Defining patch baselines
Amazon Systems Manager Patch Manager integrates with IAM, Amazon CloudTrail, and Amazon CloudWatch Events to provide a secure patching experience that includes event notifications and the ability to audit usage. For details about the process, see How Patch Manager Operations Work. If Amazon Systems Manager Patch Manager does not fulfil your requirements, there are third-party products available as well. Some of these are available via the Amazon Marketplace
Maintenance Window
Amazon Systems Manager Maintenance Windows enables you to define a schedule for when to perform potentially disruptive actions on your instances, such as patching an operating system, updating drivers, or installing software or patches.
Automation Using Documents
Amazon Systems Manager Automation simplifies common maintenance and deployment tasks of Amazon EC2 instances and other Amazon resources. Automation enables you to do the following:
-
Build automation workflows to configure and manage instances and Amazon resources.
-
Create custom workflows or use pre-defined workflows maintained by Amazon.
-
Receive notifications about Automation tasks and workflows by using Amazon CloudWatch Events.
-
Monitor automation progress and execution details by using the Amazon EC2 or the Amazon Systems Manager console.
Business Continuity
Amazon recommends periodically scheduling business continuity process validations by executing disaster recovery tests. This planned activity helps to flush out any potential unknowns, and helps the organization deal with any real disaster in a streamlined manner. Depending on your disaster recovery architecture it may include:
-
Backup/Recovery of databases from S3.
-
Creation of systems from AMI and point-in-time recovery via snapshots.
-
Changing EC2 instance size of pilot light systems.
-
Validation of integration (AD/DNS, email, 3^rd^ party, and more)
Support
SAP requires customers to have a minimum Amazon Business Support
For any SAP application issues, Amazon suggests raising an incident with SAP via the SAP support portal. After the first level of investigation, SAP can redirect the incident to Amazon support if they find an infrastructure related issue which needs to be managed by Amazon. However, if you choose to raise support issues for SAP applications with Amazon support, we cannot redirect the tickets to SAP. For any infrastructure related issues, you can raise the issue directly with Amazon support.
Cost Optimization
Resources (CPU, memory, additional application servers, system copies for different tests/validations and more) required the SAP landscape change over time. Amazon recommends monitoring system utilization, and the need for existing systems, on a regular basis to take actions that will reduce cost. In cases of databases like IBM Db2 as we cannot scale out only opportunity to right size database server is by scaling up/down or shutting it down if not required. A few suggestions to consider:
-
Consider reserved instances or savings plans over on-demand instances if your requirement is to run 24-7, 365 days a year. Reserved instances provide up to 75% discount over on-demand instances. See Amazon EC2 pricing
. -
Consider running occasionally required systems like training and sandbox on-demand for the duration required.
-
Monitor CPU and memory utilization overtime for other non-production systems like Dev/QA, and right-size them when possible.