Performance tuning
This information describes the performance guidelines for operations such as loading data and tuning.
Examples of performance optimization include:
- Allocating appropriate CPU and memory resources to Db2® Big SQL
- Tuning HBase performance
- Setting an appropriate number of logical workers in order to improve parallelism
- Using appropriate data types
- Setting informational constraints to provide useful information to the Db2 Big SQL query optimizer
- Setting performance registry variables to improve compiler and runtime performance
- Adjusting temp space database directories
Best practices:
For an overview of methods to optimize performance in Db2 Big SQL, see Db2 Big SQL v5 Best Practices and Guidelines - Performance.
- Specific tuning methods
- Specific tuning methods and best practices are described in the following articles:
- Auto-analyze
- Memory allocation in Yarn
- Logical Db2 Big SQL workers
- Data type implications to performance
- Informational constraints
See the topics below for details about each performance area.