关于DB2排序相关参数优化问题
请教大家个参数调整的问题，如果DB2设置私有排序，sheapthres = n，sortheap为每个代理私有排序的限制，同时设置sheapthres_shr非0，用于内部并行，这个可以理解。 DB2启用了共享排序， sheapthres = 0, 数据库级参数sortheap感觉就没用了，为什么还要设置大小，sortheap这个参数是否可以...显示全部
查看其它 2 个回答drdb2的回答
Under the shared sort model, all sortheap allocations are from the shared sort heap
(sheapthres_shr), which is part of database shared memory (database_memory);
sortheap defines the maximum number of private or shared memory pages possibly allocated for an operation.
不管shared sort model or private sort model, sortheap 都是要定义的， 因为它决定：每个sort操作最大可以allocate多少sort memory。 自己画个图可能更清楚些。
(sheapthres_shr), which is part of database shared memory (database_memory);
sortheap defines the maximum number of private or shared memory pages possibly allocated for an operation.
不管shared sort model or private sort model, sortheap 都是要定义的， 因为它决定：每个sort操作最大可以allocate多少sort memory。 自己画个图可能更清楚些。