国产高清精品免费区-男女一进一出抽搐免费视频-中日韩一二三级黄色永久视频-日韩精品人妻一区二区免费视频-日本久久视频在线观看-99热这里只有精品88热-亚洲韩国黄色最新短视频一区-日韩伦理在线观看免费全集-国产av一区二区三区天堂

reorg

reorg

 英

  • 網(wǎng)絡重組;表重組;重組操作

例句

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.

需要監(jiān)控系統(tǒng)最好通過自動方式決定何時運行REORG

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

COMPACTON分發(fā)實用程序默認選項離線tablereorg那樣執(zhí)行空間壓縮

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

IBM員工談話揭示公司內(nèi)部一個觀點DBA可能會降低REORG頻率

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

REORG一個組織混亂索引恢復良好組織狀態(tài)要以一些CPU消耗代價

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

Word消失,Outlook2003出現(xiàn)其中顯示要發(fā)給林彩瑜電子郵件主題部門重組”。

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每個操作需要掃描一次數(shù)據(jù)

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.

也是無法單個本地索引執(zhí)行類似REORG維護操作原因

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

只有執(zhí)行REORG時候構建字典之后便可以壓縮數(shù)據(jù)

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

reorg命令通過重新構造消除碎片數(shù)據(jù)從而進行重新組織

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.

執(zhí)行生成reorg.sql腳本之前需要創(chuàng)建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.

大量更改數(shù)據(jù)之后運行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維護命令用于命令部署恢復數(shù)據(jù)庫狀態(tài)

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.

執(zhí)行RUNSTATSREORG可能出現(xiàn)第三問題

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這些發(fā)生REORG之前檢索得到

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

到處移動數(shù)據(jù)RUNSTATSREORG實用程序使用日志文件

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

除了RUNSTATS可以數(shù)據(jù)庫備份REORG索引數(shù)據(jù)整理自動化

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.

大多數(shù)情況ALTERSETDATATYPE需要執(zhí)行重組reorg),因為修改物理格式

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

如果inspect工具使用離線tablereorgrowcompestimate選項數(shù)據(jù)完全壓縮

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

因此REORG常常可以產(chǎn)生代表整個空間分區(qū)數(shù)據(jù)字典

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

因此REORG常常可以產(chǎn)生代表整個空間分區(qū)數(shù)據(jù)字典

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

為了ADC特性同步離線tablereorgKEEPDICTIONARY行為已經(jīng)更改

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

根據(jù)當前數(shù)據(jù)以及觀察趨勢REORG頻率PCTFREE數(shù)字進行相應調(diào)整

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實用程序可以同時執(zhí)行兩個函數(shù)

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

了解更多信息請參閱“2.4使用離線reorg實用程序壓縮行為變化小節(jié)

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.

我們知道一個口號重新組織運行統(tǒng)計重新綁定

熱門查詢