6. DATA SOURCES › 6.4 Query CP Parallelism Considerations

Previous Topic: The DB2DSY (DB2 System Activity) File

Next Topic: 6.4.1 Collecting Query CP Parallelism Information

6.4 Query CP Parallelism Considerations


 DB2 can significantly reduce the response time for
 processor-intensive queries by initiating multiple parallel
 operations when it needs to access data from a table or index
 in a table space.
 
 Query CP parallelism enables true multi-tasking by breaking a
 large query into many smaller queries running simultaneously
 on several processors accessing data in parallel, therefore
 reducing the query elapsed time.

The following topics describe the impact of query CP
parallelism on CA MICS processing and data analysis:

  1 - Collecting Query CP Parallelism Information
  2 - Parallel Tasks Data Analysis