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:
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.