User Guide
© 2021 IBM Corporation
14
IBM
®
Power
®
POWER10 Quick Start Guide - Recommendations for Db2
General
§ Use SMT8 mode
§ Use dedicated CPU LPARs
Db2 Warehouse
§ Ensure that a high-speed private network exists between all nodes
§ Limit MLN configuration to one node per socket
CP4D
§ Use PCIe4 for OCP nodes network
§ Prior to OCP 4.8, set kernel parameter slub_max_order=0
Db2 Best Practices
https://www.ibm.com/docs/en/db2/11.5?topic=overviews-db2-best-practices