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控制注册目标空间存储查询结果