allownoaccess
youdao
Extra indexes also add to the CPU consumption of certain DB2 utilities, such as the REORG utility.
额外索引还会增加某些DB2实用工具(比如 REORG 实用工具)的CPU 占用。
youdao
This is also why maintenance operations like REORG cannot be performed on an individual local index.
这也是无法对单个本地索引执行类似 REORG维护操作的原因。
youdao
REORG will restore a disorganized index to a well-organized state, at a cost of some CPU consumption.
REORG将把一个组织混乱的索引恢复为良好组织状态,但要以一些CPU消耗为代价。
youdao
Based on the data and trends you observe, adjust your REORG frequency and PCTFREE number accordingly.
根据当前的数据以及您所观察到的趋势,对REORG的频率和PCTFREE的数字进行相应的调整。
youdao
In DB2 9, the default compression dictionary directive for the REORG TABLE command is KEEPDICTIONARY.
在DB 29中,REORGTABLE命令中的默认压缩字典指令是KEEPDICTIONARY。
youdao
DB2 provides various utilities, such as RUNSTATS, REORG and REORGCHK, to improve database performance.
DB 2提供了各种实用程序来提高数据库性能,如RUNSTATS、REORG和REORGCHK。
youdao
Just like the offline table reorg, LOAD REPLACE has both the KEEPDICTIONARY and RESETDICTIONARY options.
和离线table reorg一样,LOADreplace有keepdictionary和RESETDICTIONARY选项。
youdao
Conversations with folks at IBM reveal a viewpoint within the company that DBAs may reduce REORG frequency.
与IBM员工的谈话揭示了公司内部一个观点,DBA可能会降低reorg频率。
youdao
For more information, see the "2.4 Behavior changes in row compression using offline reorg utility" section.
欲了解更多信息,请参阅“2.4使用离线reorg实用程序的行压缩中的行为的变化”小节。
youdao
The table dictionary is built only when a REORG is performed, after which the data in the table can be compressed.
只有在执行 REORG 的时候才构建表字典,之后便可以压缩表中的数据。
youdao
In most cases, ALTER SET DATA TYPE requires table reorganization (reorg) because it changes the physical row format.
大多数情况下,ALTERSETDATATYPE需要对表执行重组(reorg),因为它修改了物理行格式。
youdao
Each of these operations: redistribute, table reorg, index create, and runstats require scanning the table data once.
这些操作中:redistribute、table reorg、indexcreate和runstats,每个操作都需要扫描一次表数据。
youdao
Thus the UPDATE statement fails to find the row with the row CHANGE TOKEN that was retrieved before the REORG occurred.
因此,update语句无法找到具有ROWCHANGETOKEN的行,这些行是在发生REORG之前检索得到的。
youdao
Additionally, DSNACCOX with DB2 10 has specific code to reduce the REORG requirements for table Spaces residing on SSDs.
另外,DB 210的DSNACCOX具有特定的代码来降低对驻留在SSD上的磁盘空间的REORG需求。
youdao
If you use the offline table reorg or rowcompestimate option in the inspect tool, data in the table is fully compressed.
如果在inspect工具中使用离线table reorg或rowcompestimate选项,则表中的数据将被完全压缩。
youdao
In order to synchronize with the new ADC feature, the behavior of KEEPDICTIONARY for the offline table reorg has changed.
为了与新的adc特性同步,离线table reorg的KEEPDICTIONARY行为已经被更改。
youdao
Therefore, REORG usually produces a dictionary that is more representative of the data in the entire table space or partition.
因此,REORG常常可以产生更能代表整个表空间或分区中的数据的字典。
youdao
The following REORGCHK command examines whether the REORG is required and also updates the statistics on table bench.customer.
下列REORGCHK命令检查是否需要REORG,并且更新关于表bench .customer的统计信息。
youdao