Larger sort pools produce fewer sort runs. If the sort pool is large enough, the buffer pools and sort work files may not be used. You want to set a large size for the sort pool and work file database because you do not want sorts to have pages being written to disk.
Note: If buffer pools and work file database are not used, the better performance will be due to less I/O.
The sort pool size defaults to 2 MB unless a different size is specified. The sort pool can range in size from 240 KB to 128 MB. The size of the sort pool is set during installation using DSNZPARM.
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|