Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1357633
  • 博文数量: 335
  • 博客积分: 4690
  • 博客等级: 上校
  • 技术积分: 4337
  • 用 户 组: 普通用户
  • 注册时间: 2010-05-08 21:38











分类: DB2/Informix

2012-10-16 22:31:08

SORTDEVT device-type
Specifies the device type for temporary data sets that are to be dynamically
allocated by the sort program. For device-type, you can specify any disk device
that is valid on the DYNALLOC parameter of the SORT or OPTION options
for the sort program.
device-type is the device type.
A TEMPLATE specification does not dynamically allocate sort work data sets.
The SORTDEVT keyword controls dynamic allocation of these data sets.
SORTNUM integer
Specifies the number of temporary data sets that are to be dynamically
allocated by the sort program. If you omit SORTDEVT, SORTNUM is ignored.
If you use SORTDEVT and omit SORTNUM, no value is passed to the sort
program; the sort program uses its own default.
integer is the number of temporary data sets that can range from 2 to 255.
You need at least two sort work data sets for each sort. The SORTNUM value
applies to each sort invocation in the utility. For example, if there are three
indexes, SORTKEYS is specified, there are no constraints limiting parallelism,
and SORTNUM is specified as 8, then a total of 24 sort work data sets will be
allocated for a job.
Each sort work data set consumes both above the line and below the line
virtual storage, so if you specify too high a value for SORTNUM, the utility
may decrease the degree of parallelism due to virtual storage constraints, and
possibly decreasing the degree down to one, meaning no parallelism.
Important: The SORTNUM keyword will not be considered if subsystem
parameter UTSORTAL is set to YES and IGNSORTN is set to YES.
 需要注意的是,sortnum,是指一个sort invocation调用所需要的文件数目,它的意义reorg里面的参数的意义相同,
阅读(1215) | 评论(0) | 转发(0) |

登录 注册