tablespaces

tablespaces

 英

  • 网络表空间;将传输的表空间列表;将要传输到数据库的表空间

例句

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

并非总是可以测试设置生产相同空间

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

除了可以一个数据库空间之间转移之外可以不同数据库之间转移

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

对于经常用于执行排序操作临时空间应该这样

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

如果指定这个NONRECOVERABLE关键字那么用户不必马上空间进行备份

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

perltbs_usage.pl——脚本提供给定数据库所有空间空闲空间

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

使用SMSDMS文件空间这样便允许操作系统缓存抵消某些性能降低

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

视图触发器存储过程可以保存空间

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

除了small_tables之外所有空间都是同一磁盘驱动器定义

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

为了保证管理效率推荐前面确定每一提供单独空间

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

DBA有权选择目录空间临时空间用户空间空间类型

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

DB2支持部分(de-clustering),在此情况空间可以分布可用分区一个子集

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

通过DMS空间,DB2更加可以控制如何数据页面物理映射称作区段磁盘空间分组

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

这个定义DB2数据库所有存储组件包括空间日志备份

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

确保系统目录系统临时空间具有足够自由空间

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用户可以指定复制期间使用空间映射使用来自数据库空间

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

对于DMS设备容器空间操作系统不在文件系统缓存缓存页面

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

获得最佳数据库性能正确定义空间至关重要

Review the tablespaces where the indexes are to be stored.

查看将要存储索引空间

Review the tablespaces where the objects are to be stored.

查看对象存储空间

The SYS_ANY keyword can be used for all tablespaces.

SYS_ANY关键字可以用于所有空间

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

当然要求数据索引创建单独空间

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

数据顾问工具不会评估还原空间临时空间

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

策略所有空间数据扩展尽可能驱动器最大化IO并行性

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

我们能够管理空间哪些怎样区别它们

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

IBMDEFAULTGROUP-用于包含用户空间默认数据库分区

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

已经提取DDL空间之间映射必要手工修改

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

对于数据库管理空间建议拆开LOB数据常规数据LOB数据一个空间

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

作为OLTP应用程序经验法则多个设备使用DMS空间

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

空间分布多个容器这些容器映射不同磁盘)。

Temporary and catalog tablespaces must be placed SMS.

临时空间目录空间必须SMS

The tablespaces were defined carefully to ensure excellent disk performance.

确保优秀磁盘性能需要慎重定义空间

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

下列示例说明数据库管理员可以如何使用DMSSMS空间创建数据库

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

通过仔细地空间映射磁盘上来组织磁盘子系统从而获得最佳性能

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

另外用户可以某些空间指定特定映射其他空间使用默认空间选择算法

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

命名空间限制不能SYSTEMSYSAUX空间命名

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

IBMTEMPGROUP-用于系统临时空间默认数据库分区

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

注意AIX对于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.

数据库定义五个常规空间一个临时空间

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

因此LOADFROMCURSOR不同空间数据库之间快速轻松转移数据方法

热门查询