reorg

reorg

 英

  • 网络重组;表重组;重组操作

例句

A few weeks ago Natasha (my girlfriend) told me about a post she wrote on her blog (Reorg) which described some basecamp best practices.

星期以前女朋友Natasha告诉博客关于Basecamp最佳实践博客文章

You need to monitor the system (ideally in an automated fashion) to determine when a REORG needs to be run.

需要监控系统最好通过自动方式决定何时运行REORG

COMPACT ON is the default for the redistribute utility, where it performs space compaction much like an offline table reorg does.

COMPACTON分发实用程序默认选项离线tablereorg那样执行空间压缩

Conversations with folks at IBM reveal a viewpoint within the company that DBAs may reduce REORG frequency.

IBM员工谈话揭示公司内部一个观点DBA可能会降低REORG频率

REORG will restore a disorganized index to a well-organized state, at a cost of some CPU consumption.

REORG一个组织混乱索引恢复良好组织状态要以一些CPU消耗代价

Word disappears, and Outlook 2003 appears, showing an e-mail message addressed to Andrew Fuller with a subject of "department reorg. "

Word消失,Outlook2003出现其中显示要发给林彩瑜电子邮件主题部门重组”。

Taken together, they represented the biggest reorg of the Pentagon in a generation.

两者合计他们代表一代人中五角大楼最大重组

Each of these operations: redistribute, table reorg, index create, and runstats require scanning the table data once.

这些操作redistributetablereorgindexcreaterunstats每个操作需要扫描一次数据

For later versions of DB2 you can remove or ignore the REORG statements or their generation SQL, which are not required to be run.

对于版本DB2,可以删除忽略REORG语句它们生成SQL并不是运行所必需

This is also why maintenance operations like REORG cannot be performed on an individual local index.

也是无法单个本地索引执行类似REORG维护操作原因

The table dictionary is built only when a REORG is performed, after which the data in the table can be compressed.

只有执行REORG时候构建字典之后便可以压缩数据

The reorg command reorganizes the tables by reconstructing the rows to eliminate fragmented data.

reorg命令通过重新构造消除碎片数据从而进行重新组织

Also, there should not be any need to run the REORG utility.

而且没有任何必要运行REORG实用程序

Before you execute the generated script reorg. sql, you need to create the ALTER TABLE statements to activate value compression.

执行生成reorg.sql脚本之前需要创建ALTERTABLE语句激活压缩

The script below will scan for AW fact tables named using the wildcard expression %_MEASURES and scripts ALTER TABLE and REORG commands.

以下脚本使用表达%_MEASURES以及脚本ALTERTABLEREORG命令扫描指定AW事实

Use this utility after massive changes to the data and possibly after running REORG.

大量更改数据之后运行REORG之后使用实用程序

In DB2 9. 1, the compression takes effect only after the table dictionary is built, which is usually during the table REORG phase.

DB29.1只有建立字典之后字典通常REORG阶段建立),压缩才能生效

In addition, maintenance commands such as reorg and rebind are also included to restore the state of the database after command deployment.

此外包括reorgrebind维护命令用于命令部署恢复数据库状态

However, reserving free space only trades disk space for time, potentially letting you go longer between REORGs.

尽管如此保留空闲空间只是时间换取磁盘空间可能REORG之间耗时

A third problem can occur when performing RUNSTATS or REORG on your table.

执行RUNSTATSREORG可能出现第三问题

The REORG TABLE step between two scenarios will establish the clustering order.

场景之间REORGTABLE步骤建立聚集顺序

When a table has been reorganized with the REORG utility.

REORG实用程序重新组织

Thus the UPDATE statement fails to find the row with the ROW CHANGE TOKEN that was retrieved before the REORG occurred.

因此UPDATE语句无法找到具有ROWCHANGETOKEN这些发生REORG之前检索得到

Both the RUNSTATS and REORG utilities use log files when moving table data around.

到处移动数据RUNSTATSREORG实用程序使用日志文件

In addition to the RUNSTATS, you can automate database backups and REORGs (defragmentation of table and index data).

除了RUNSTATS可以数据库备份REORG索引数据整理自动化

The REORG uses a sampling technique to build the dictionary.

REORG使用一种抽样技术建立字典

And since they are written in physical clustering sequence, there should be no need to REORG.

由于这些按照物理群集顺序因此需要运行REORG

In most cases, ALTER SET DATA TYPE requires table reorganization (reorg) because it changes the physical row format.

大多数情况ALTERSETDATATYPE需要执行重组reorg),因为修改物理格式

If you use the offline table reorg or rowcompestimate option in the inspect tool, data in the table is fully compressed.

如果inspect工具使用离线tablereorgrowcompestimate选项数据完全压缩

Therefore, REORG usually produces a dictionary that is more representative of the data in the entire table space or partition.

因此REORG常常可以产生代表整个空间分区数据字典

Therefore, REORG usually produces a dictionary that is more representative of the data in the entire table space or partition.

因此REORG常常可以产生代表整个空间分区数据字典

In order to synchronize with the new ADC feature, the behavior of KEEPDICTIONARY for the offline table reorg has changed.

为了ADC特性同步离线tablereorgKEEPDICTIONARY行为已经更改

Based on the data and trends you observe , adjust your REORG frequency and PCTFREE number accordingly .

根据当前数据以及观察趋势REORG频率PCTFREE数字进行相应调整

Deploying table spaces on SSDs can reduce the need to REORG.

SSD部署空间可以减少REORG需要

In DB2 LUW, the REORG INDEX utility can perform both functions.

DB2LUWREORGINDEX实用程序可以同时执行两个函数

For more information, see the " 2. 4 Behavior changes in row compression using offline reorg utility" section.

了解更多信息请参阅“2.4使用离线reorg实用程序压缩行为变化小节

Additionally, DSNACCOX with DB2 10 has specific code to reduce the REORG requirements for table spaces residing on SSDs.

另外,DB210DSNACCOX具有特定代码降低驻留SSD磁盘空间REORG需求

Extra indexes also add to the CPU consumption of certain DB2 utilities, such as the REORG utility.

额外索引增加某些DB2实用工具比如REORG实用工具CPU占用

They can increase logging during the REORG process.

REORG过程增加日志

We all know the mantra: reorg, runstats, and rebind.

我们知道一个口号重新组织运行统计重新绑定