tablespace

tablespace

 英

  • 網絡表空間;表格空間;表空間信息

例句

Test 81 used a DMS file tablespace, and a small additional benefit would probably have occurred if a DMS raw tablespace had been used.

test81使用DMS文件空間如果使用DMSraw空間的話可以得到一點好處

The index tablespace is optional, so the system tablespace can be used for indexing purpose, instead of the index tablespace.

索引空間可以使用系統空間存儲索引

Thus a database backup, or at least a tablespace backup, should be executed following the data movement operation.

因此執行數據轉移操作之后應該執行數據庫備份至少空間備份

However, if the db2empfa command has been run against the database, each SMS tablespace has new pages allocated for it an extent at a time.

但是如果數據庫運行db2empfa命令那么每個SMS空間一次性分配一個區段

The default is to use the same tablespace name as from the source, in which case, the input mapping for this tablespace is not necessary.

默認情況使用數據庫相同空間這種情況不必提供這個空間映射

If the specified tablespace does not exist, the copy of the objects using that tablespace fails and is logged in the error file.

如果指定空間存在那么使用這個空間對象復制操作失敗情況記錄錯誤文件

This option can only be used for database managed tablespace (DMS).

這個選項用于數據庫托管空間DMS)。

Note also that you should also look towards the bottom of the db2exfmt output to verify that the tablespace configuration match.

注意查看db2exfmt輸出結尾驗證空間配置匹配

Extend size of a tablespace should be the same as stripe width or multiple of strip size of the RAID device.

空間區段大小應該RAID設備條帶寬度相同或是大小倍數

A tablespace is an abstraction of a collection of containers into which database objects are stored.

空間存儲數據庫對象容器集合抽象

All tablespace containers that are not part of the database directory must be part of the split mirror.

不在數據庫目錄所有空間容器必需屬于分割鏡像

The only exception is Linux raw device tablespace containers, which inherently bypass the file cache.

惟一例外Linux原始設備空間容器因為本身繞過文件緩存

In this case, DB2MOVE is able to chose any available tablespace to be used as the target.

這種情況下,DB2MOVE可以選擇任何可用空間作為目標空間

IBMCATGROUP - default database partition group for the tablespace containing the system catalogs.

IBMCATGROUP-用于包含系統編目空間默認數據庫分區

A database must have at least one tablespace.

一個數據庫至少一個空間

If Roslyn wants to use a specific tablespace on the target database for the new tables, she specifies it in this window.

如果Roslyn目標數據庫使用特定空間這個窗口指定

Identifies the tablespace used by the logging table for an article published from an Oracle database.

標識Oracle數據庫發布項目日志記錄使用空間

For every different page size tablespace, there should be a matching page size buffer pool.

對于每個不同大小空間應該存在一個大小匹配緩沖

This ensures that any user tables whose row size exceeds 4K bytes is successfully created into a 32K page size tablespace.

這樣可以確保能夠32K頁面大小空間創建任何大小超過4K字節用戶

To recover a loss datafile that belongs to READ-ONLY tablespace is an easy task indeed.

恢復屬于READ-ONLY空間丟失數據文件其實簡單任務

The sample code in the Download section contains the full SQL used to create the database STOGROUP, TABLESPACE, and TABLE.

下載部分代碼包含用于創建數據庫STOGROUPTABLESPACETABLE完整SQL

But again , you will have to make sure that if a tablespace is of type DMS or SMS on production , it must remain the same type in test .

但是同樣必須確保如果生產空間DMSSMS類型那么測試保留相同類型

The important information used by the optimizer for a tablespace is the following.

下面優化器空間使用重要信息

A tablespace is a logical layer between the database and the container objects that actually hold the data.

空間數據庫實際容納數據容器對象之間邏輯

A string containing tablespace information to be added to each table definition.

包含添加每個定義空間信息字符串

Recovering from the loss of a data file that belongs to a traditional rollback segment tablespace.

屬于傳統回滾空間數據文件丟失恢復

With the default behavior, the user is forced to take backups of each tablespace that was loaded into.

采用默認行為用戶必須進行裝載每個空間進行備份

When Alter Tablespace ts_name End Backup is issued, again a checkpoint SCN is recorded at the headers of online backup data files.

發出“AlterTablespacets_nameEndBackup”聯機備份數據文件文件再次記錄檢查點SCN

Table in a separate tablespace and on a separate physical disc and also define a separate bufferpool for audit log data.

表格并且審核日志數據定義一個單獨緩沖池

If you want the tables to reside in another tablespace, alter the script accordingly before you run it.

如果位于另一個空間可以運行之前腳本進行相應修改

Within a Logical Node, each tablespace is defined across two arrays, using 13 drives from each array, for a total of 26 hard drives.

一個邏輯節點每個空間定義跨越兩個使用每個13驅動器總共使用26硬盤驅動器

The tablespace size required to meet your specifications is displayed in the Analysis section.

指定空間需求體積顯示分析

If no tablespace is defined, the default tablespace is used for the new tables.

如果定義空間那么使用默認空間

You cannot specify this clause for a tablespace or for a rollback segment.

不能空間回滾指定緩沖

The tablespace for the new table SALES_TMP is explicitly defined through the IN option.

通過IN選項顯式定義SALES_TMP空間

Where -l generates the DDL statements for tablespace, database partition, groups, and buffer pool.

這里,-l創建空間數據庫分區緩存DDL語句

In this sample scenario, IBMDB2SAMPLEREL serves as the destination tablespace for moving table SALES.

這個示例場景,IBMDB2SAMPLEREL作為轉移SALES目標空間

As shown in Listing 16, create a tablespace with one container named cont1.

清單16cont1容器創建空間

You can always disable Performance Expert from collecting container and tablespace data.

隨時可以禁止PerformanceExpert收集容器空間數據

To create Query Patroller control tables and register a target tablespace to store query result tables.

創建QueryPatroller控制注冊目標空間存儲查詢結果