-
They can increase logging during the REORG process.
会在REORG过程中增加日志。
youdao
-
When a table has been reorganized with the reorg utility.
当用REORG实用程序重新组织表时。
youdao
-
At last, a true low-overhead online table reorg capability.
最后,一个真正的低开销在线表格重组功能。
youdao
-
The REORG USES a sampling technique to build the dictionary.
REORG使用一种抽样技术来建立字典。
youdao
-
The dictionary gets updated for every subsequent REORG operation.
在随后的每次REORG操作中,表字典随之更新。
youdao
-
Behavior changes in row compression using the offline reorg utility.
使用离线reorg实用程序的行压缩中的行为的变化。
youdao
-
Rename, alter, reorg, refresh, nickname, comments, or lock statements.
refresh、nickname、comments和lock语句。
youdao
-
Here are a few things to keep in mind when using partition-level reorg.
在使用分区级别REORG时,要注意以下几个问题。
youdao
-
A third problem can occur when performing RUNSTATS or REORG on your table.
当对表执行RUNSTATS或REORG时,可能出现第三个问题。
youdao
-
You should run reorg and runstats after creating new indexes, as shown below.
您在创建新索引之后运行reorg和runstats命令,如下所示。
youdao
-
The REORG TABLE step between two scenarios will establish the clustering order.
两个场景之间的REORGTABLE步骤将建立聚集顺序。
youdao
-
Before you apply new stats to the database, I recommend you reorg the data first.
在您将新语句应用到数据库之前,我建议您首先重新组织数据。
youdao
-
Both the RUNSTATS and REORG utilities use log files when moving table data around.
当到处移动表数据时,RUNSTATS和REORG实用程序都使用日志文件。
youdao
-
Taken together, they represented the biggest reorg of the Pentagon in a generation.
两者合计,他们代表了在一代人中五角大楼最大的重组。
youdao
-
Use this utility after massive changes to the data and possibly after running REORG.
大量更改数据之后或运行REORG之后使用该实用程序。
youdao
-
While the reorg operation is running, execute the following script from another session.
在执行重组操作时,从另一会话执行下列脚本。
youdao
-
The following examples illustrate partition-level REORG on a table that has no global indexes.
以下例子阐明了如何在不含全局索引的表上应用分区级别reorg ?
youdao
-
Reorg index - For example, reorg indexes all for table <Schema Name>. allow no access
Reorgindex ——比如,reorgindexesallfortable <SchemaName>.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