reorg
- 网络重组;重整;表重组;表执行重组;重组数据表空间
-
At last , a true low-overhead online table reorg capability .
最后,一个真正的低开销在线表格重组功能。
-
This provided some improvement on the table reorg problem , because you could use these options to perform a partial reorganization in the background without taking the table offline .
这为表重组问题提供了一些改进,因为您可以使用这些选项来在后台执行一个部分重组,而不需要让表处于脱机状态。
-
REORG also helps us implement another performance feature of DB2 .
REORG还帮助我们实现DB2的另一个性能特性。
-
The REORG TABLE step between two scenarios will establish the clustering order .
两个场景之间的REORGTABLE步骤将建立聚集顺序。
-
The REORG utility can be used in many ways beyond purging data .
除了清理数据,REORG实用程序可以通过多种方式使用。
-
The REORG uses a sampling technique to build the dictionary .
REORG使用一种抽样技术来建立字典。
-
Also , there should not be any need to run the REORG utility .
而且,也没有任何必要去运行REORG实用程序。
-
They can increase logging during the REORG process .
会在REORG过程中增加日志。
-
This is also why maintenance operations like REORG cannot be performed on an individual local index .
这也是无法对单个本地索引执行类似REORG维护操作的原因。
-
The dictionary gets updated for every subsequent REORG operation .
对于以后的每次REORG操作,更新表词典。
-
At a later time , REORG can be used to put the rows back in cluster order .
一段时间以后,REORG可用来将各行以集群顺序放回。
-
Both the RUNSTATS and REORG utilities use log files when moving table data around .
当到处移动表数据时,RUNSTATS和REORG实用程序都使用日志文件。
-
You should run reorg and runstats after creating new indexes , as shown below
您在创建新索引之后运行reorg和runstats命令,如下所示
-
Before you apply new stats to the database , I recommend you reorg the data first .
在您将新语句应用到数据库之前,我建议您首先重新组织数据。
-
Deploying table spaces on SSDs can reduce the need to REORG .
在SSD上部署表空间可以减少REORG的需要。
-
A third problem can occur when performing RUNSTATS or REORG on your table .
当对表执行RUNSTATS或REORG时,可能出现第三个问题。
-
And since they are written in physical clustering sequence , there should be no need to REORG .
由于这些行是按照物理的群集顺序来写的,因此不需要运行REORG。
-
Here are a few things to keep in mind when using partition-level REORG
在使用分区级别REORG时,要注意以下几个问题
-
He reminds his team to use the reorg utility , which clusters the data for efficient access .
他提醒他的团队使用重新组织实用工具,该工具会收集数据以实现有效访问。
-
For more information , see the " 2.4 Behavior changes in row compression using offline reorg utility " section .
欲了解更多信息,请参阅2.4使用离线reorg实用程序的行压缩中的行为的变化小节。
-
Based on the data and trends you observe , adjust your REORG frequency and PCTFREE number accordingly .
根据当前的数据以及您所观察到的趋势,对REORG的频率和PCTFREE的数字进行相应的调整。
-
When a table has been reorganized with the REORG utility .
当用REORG实用程序重新组织表时。
-
Remember , REORG is basically an unload and a reload of data .
请记住,REORG从根本上说是卸载和重新加载数据。
-
The following examples illustrate partition-level REORG on a table that has no global indexes
以下例子阐明了如何在不含全局索引的表上应用分区级别REORG
-
Conversations with folks at IBM reveal a viewpoint within the company that DBAs may reduce REORG frequency .
与IBM员工的谈话揭示了公司内部一个观点,DBA可能会降低REORG频率。
-
In most cases , ALTER SET DATA TYPE requires table reorganization ( reorg ) because it changes the physical row format .
大多数情况下,ALTERSETDATATYPE需要对表执行重组(reorg),因为它修改了物理行格式。
-
In this policy , the REORG TABLESPACE and LOAD utilities are being monitored for specific syntax parameters .
在这个策略中,REORGTABLESPACE和LOAD实用程序正在受到监视,监视它们是否使用特定的语法参数。
-
However , you can only create a compression dictionary using either the offline reorg table command or the inspect utility .
但是,只能使用离线reorgtable命令或inspect实用程序来创建压缩字典。
-
Therefore , REORG usually produces a dictionary that is more representative of the data in the entire table space or partition .
因此,REORG常常可以产生更能代表整个表空间或分区中的数据的字典。
-
You need to monitor the system ( ideally in an automated fashion ) to determine when a REORG needs to be run .
您需要监控系统(最好通过自动方式)来决定何时运行REORG。