Right-sizing Amazon RDS for Db2 by replaying the Db2 LUW workload
Database Blog
This article describes a process for right-sizing Amazon RDS for Db2 by replaying the workload from a self-managed Db2 LUW database. It provides a solution to capture a production workload, format it, and replay it on Amazon RDS for Db2 to assess performance and resource requirements.
Specifically, the article covers:
- Capturing the Db2 LUW workload using Db2 workload management
- Formatting the captured workload using a Python script to generate files compatible with IBM's db2batch benchmarking tool
- Replaying the formatted workload on Amazon RDS for Db2 using db2batch
- Scaling up the workload on RDS for Db2 to simulate peak load scenarios
- Gathering performance metrics from Amazon CloudWatch to optimize RDS for Db2 instance sizing
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Apr 24
2024
2024
Performance optimization of full load and ongoing replication tasks from self-managed Db2 to Amazon RDS for Db2
May 15
2024
2024
Data migration strategies to Amazon RDS for Db2
May 21
2024
2024
Announcing Amazon RDS for Db2 with license through AWS Marketplace
Jun 11
2024
2024
Near zero-downtime migrations from self-managed Db2 on AIX or Windows to Amazon RDS for Db2 using IBM Q Replication
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.