tablespaces

美 　英

• 網(wǎng)絡(luò)表空間；將傳輸?shù)谋砜臻g列表；將要傳輸?shù)綌?shù)據(jù)庫(kù)的表空間

例句

It is not always possible to have the same tablespaces set up in test that you have in production.

并非總是可以在測(cè)試中設(shè)置與生產(chǎn)中相同的表空間。

As well as a table can be moved between tablespaces within a database, a table can be moved between two different databases.

除了可以在一個(gè)數(shù)據(jù)庫(kù)中的表空間之間轉(zhuǎn)移表之外，還可以在不同的數(shù)據(jù)庫(kù)之間轉(zhuǎn)移表。

The same is true for temporary tablespaces often used for performing sort operations.

對(duì)于經(jīng)常用于執(zhí)行排序操作的臨時(shí)表空間，也應(yīng)該這樣。

When specifying this NONRECOVERABLE keyword, the user is not forced to take backups of the tablespaces immediately.

如果指定這個(gè)NONRECOVERABLE關(guān)鍵字，那么用戶不必馬上對(duì)表空間進(jìn)行備份。

perl tbs_usage. pl - This script provides the free and used space for all the tablespaces for a given database.

perltbs_usage.pl——該腳本提供了給定數(shù)據(jù)庫(kù)的所有表空間的空閑和已用空間。

Use SMS or DMS file tablespaces, which may allow operating system caching to negate some of the performance degradation.

使用SMS或DMS文件表空間，這樣便允許操作系統(tǒng)的緩存抵消某些性能上的降低。

Views, triggers, and stored procedures reside in tablespaces, as well.

視圖、觸發(fā)器和存儲(chǔ)過(guò)程也可以保存在表空間中。

All of the tablespaces, except small_tables, are defined against the same set of disk drives.

除了small_tables之外，所有的表空間都是在同一組磁盤驅(qū)動(dòng)器上定義的。

Individual tablespaces are recommended for each table identified previously, for management efficiencies.

為了保證管理效率，推薦為前面所確定的每一個(gè)表提供單獨(dú)的表空間。

DBAs have the option to choose the type of the tablespaces required for the catalog, and for temporary and user tablespaces.

DBA有權(quán)選擇目錄表空間、臨時(shí)表空間和用戶表空間這三者所需的表空間類型。

DB2 also supports partial de-clustering, where tables and tablespaces can be spread across a subset of the available partitions.

DB2還支持部分分塊（de-clustering），在此情況下，表和表空間可以分布在可用分區(qū)的一個(gè)子集上。

With DMS tablespaces, DB2 has more control over how data pages are physically mapped in disk space groupings known as extents.

通過(guò)DMS表空間，DB2更加可以控制如何將數(shù)據(jù)頁(yè)面物理映射到稱作區(qū)段的磁盤空間分組中。

All storage components of the DB2 database were defined on this volume group, including tablespaces, log, and backups.

在這個(gè)卷組上定義了DB2數(shù)據(jù)庫(kù)的所有存儲(chǔ)組件，包括表空間、日志和備份。

Ensure that there is sufficient free space on the system catalog and the system temporary tablespaces.

確保系統(tǒng)目錄和系統(tǒng)臨時(shí)表空間中具有足夠的自由空間。

TABLESPACE_MAP The user may specify tablespace name mappings to be used instead of the tablespaces from the source system during a copy.

TABLESPACE_MAP用戶可以指定在復(fù)制期間使用的表空間名映射，而不使用來(lái)自源數(shù)據(jù)庫(kù)的表空間。

For DMS device container tablespaces, the operating system does not cache pages in the file system cache.

對(duì)于DMS設(shè)備容器表空間，操作系統(tǒng)不在文件系統(tǒng)緩存器中緩存頁(yè)面。

For optimal database performance, it is critical to have tablespaces defined properly.

為獲得最佳的數(shù)據(jù)庫(kù)性能，正確定義表空間是至關(guān)重要的。

Review the tablespaces where the indexes are to be stored.

查看將要存儲(chǔ)索引的表空間。

Review the tablespaces where the objects are to be stored.

查看對(duì)象所要存儲(chǔ)到的表空間。

The SYS_ANY keyword can be used for all tablespaces.

SYS_ANY關(guān)鍵字可以用于所有表空間。

Of course, this also requires that you create separate tablespaces for data and indexes.

當(dāng)然，這還要求為數(shù)據(jù)和索引創(chuàng)建單獨(dú)的表空間。

Note: The Segment Advisor does not evaluate undo and temporary tablespaces.

數(shù)據(jù)段顧問(wèn)工具不會(huì)評(píng)估還原表空間及臨時(shí)表空間。

The strategy is to spread the data for all tablespaces across as many drives as possible to maximize the IO parallelism.

策略是將所有表空間的數(shù)據(jù)擴(kuò)展到盡可能多的驅(qū)動(dòng)器中，以最大化IO并行性。

What are the wags tablespaces can be managed and how do they differ?

我們能夠管理的表空間有哪些？怎樣區(qū)別它們？

IBMDEFAULTGROUP - default database partition group for the tablespaces containing the user tables.

IBMDEFAULTGROUP-用于包含用戶表的表空間的默認(rèn)數(shù)據(jù)庫(kù)分區(qū)組。

You have already extracted DDL and made the required manual changes for the mapping between tables and tablespaces if required.

已經(jīng)提取了DDL，對(duì)表和表空間之間的映射做了必要的手工修改。

It is recommended for database managed tablespaces to split regular data from LOB data, placing LOB data in a large tablespace.

對(duì)于數(shù)據(jù)庫(kù)管理的表空間，建議拆開(kāi)LOB數(shù)據(jù)中的常規(guī)數(shù)據(jù)，將LOB數(shù)據(jù)放在一個(gè)很大的表空間中。

As a rule of thumb for OLTP applications, use DMS tablespaces with multiple devices.

作為OLTP應(yīng)用程序的經(jīng)驗(yàn)法則，可在多個(gè)設(shè)備上使用DMS表空間。

Spreading tablespaces over multiple containers (which map to separate disks).

將表空間分布在多個(gè)容器（這些容器映射到不同磁盤）。

Temporary and catalog tablespaces must be placed SMS.

而臨時(shí)表空間和目錄表空間必須置為SMS。

The tablespaces were defined carefully to ensure excellent disk performance.

為確保優(yōu)秀的磁盤性能，還需要慎重定義表空間。

The following example illustrates how database administrators can create a database using both DMS and SMS tablespaces.

下列示例說(shuō)明了數(shù)據(jù)庫(kù)管理員可以如何使用DMS和SMS表空間來(lái)創(chuàng)建數(shù)據(jù)庫(kù)。

The disk subsystem is organized for optimal performance by carefully mapping the tablespaces onto the disks.

還要通過(guò)仔細(xì)地將表空間映射到磁盤上來(lái)組織好磁盤子系統(tǒng)，從而獲得最佳性能。

In addition, the user can specify specific mappings for some tablespaces, and the default tablespace selection algorithm for the remaining.

另外，用戶可以為某些表空間指定特定的映射，而對(duì)其他表空間使用默認(rèn)的表空間選擇算法。

Restriction on Renaming Tablespaces : You cannot rename the SYSTEM or SYSAUX tablespaces.

重命名表空間限制：不能對(duì)SYSTEM和SYSAUX表空間重命名。

IBMTEMPGROUP is - default database partition group for system temporary tablespaces.

IBMTEMPGROUP-用于系統(tǒng)臨時(shí)表空間的默認(rèn)數(shù)據(jù)庫(kù)分區(qū)組。

Note: In AIX you can only use JFS for SMS tablespaces.

注意：在AIX中，您對(duì)于SMS表空間只能使用JFS。

The multipage_alloc is used for SMS tablespaces only, and it is used to improve insert performance.

multipage_alloc僅僅用于SMS表空間，用以提高插入性能。

In the database, five regular tablespaces and one temporary tablespace are defined.

數(shù)據(jù)庫(kù)中定義了五個(gè)常規(guī)的表空間和一個(gè)臨時(shí)表空間。

This way, a LOAD FROM CURSOR is a fast and easy possibility to move data between different tablespaces or different databases.

因此，LOADFROMCURSOR是在不同的表空間或數(shù)據(jù)庫(kù)之間快速輕松地轉(zhuǎn)移數(shù)據(jù)的方法。