|
|
|
ReportCenter charts and tables require the data to be sorted correctly, and many report queries involve extensive sorting.
The internal sorting of DB2 generally performs faster with a number of DSNDB07 data sets spread out on different volumes (to eliminate contention and I/O wait), rather than with fewer, larger data sets. Do not use the default sort pool sizes.
Use four to five data sets. Allocate the data sets with the same size for the most efficient sorting. Keep the data in the primary space.
Define DSNDB07 in a separate buffer pool, and tune it specifically for sorting. Do not use BP0.
Make your sort pools as large as possible. Sorting efficiency increases with sort pool size. Large sort pools minimize the use of a buffer pool or the DSNDB07 file. This reduction in external I/O improves performance.
| Copyright © 2012 CA. All rights reserved. |
|