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.
您需要監(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.
這些操作中:redistribute、tablereorg、indexcreate和runstats,每個操作都需要掃描一次表數(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以及腳本ALTERTABLE和REORG命令掃描指定的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.
此外,還包括reorg和rebind等維護命令,用于在命令部署后恢復數(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í)行RUNSTATS或REORG時,可能出現(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ù)時,RUNSTATS和REORG實用程序都使用日志文件。
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工具中使用離線tablereorg或rowcompestimate選項,則表中的數(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特性同步,離線tablereorg的KEEPDICTIONARY行為已經(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.
在DB2LUW中,REORGINDEX實用程序可以同時執(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.
另外,DB210的DSNACCOX具有特定的代碼來降低對駐留在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)計和重新綁定。