由于关系数据和索引存储在表空间内不同的存储对象中,因此它们具有不同的读和写计数器。
Since relational data and indexes are stored in separate storage objects within a table space, they have separate read and write counters.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
具体地说,管理员必须定义适当的数据库对象,比如分区组、表空间、缓冲区池等等。
Specifically, an administrator must define appropriate database objects, such as partition groups, table Spaces, buffer pools, and so on.
这不同于全局索引,每个全局索引有自己的对象,其提供灵活的表空间定位能力,并支持单个全局索引REORG操作。
This differs from global indexes where each global index has its own object, allowing greater flexibility in table space placement and support for REORG for an individual global index.
这些对象包括模式、表空间、表、索引、视图、包、例程、序列、服务器和昵称。
These objects include schemas, table spaces, tables, indexes, views, packages, routines, sequences, servers, and nicknames.
从表空间快照数据中可以看出,这些用过的页面对象可用于告知索引、表和数据库的总大小。
From the table space snapshot data, the used page objects can be used to tell the total size of the index, tables, and the total database size.
表空间是一个包含表、索引、大对象和长数据的存储结构。
A table space is a storage structure containing tables, indexes, large objects, and long data.
每个对象对应于一个“分区”,允许每个表空间包含一定范围的数据,这样非常容易访问。
Each of the objects would correspond to a 'partition' and would allow each table space to contain a range of data which can be accessed very easily.
可以按照相同的步骤对表、表空间、别名和序列等其他数据库对象应用筛选器。
You can use these same steps to apply filters on other database objects such as tables, table Spaces, aliases, and sequences.
为了满足业务需求,常常需要创建数据库对象,比如数据库、表或表空间。
Often, you may need to create database objects such as databases, tables, or table Spaces to address incoming business requirements.
只有模式V8R2M5 中的对象被复制到源表空间中的模式 V9R0M0 中,原来的对象所有者保持不变。
Only the objects for schema V8R2M5 are copied to schema V9R0M0 into the source tablespace retaining the origin object owner.
有两个对象恢复选项,表空间或整个数据库。
You are presented with two object restore options, table space or the entire database.
在DB 2中,表空间是逻辑对象,作为逻辑表和物理容器之间的一层。
In DB2, a table space is the logical object used as a layer between logical tables and physical containers.
查看对象所要存储到的表空间。
每一个指示器都映射到数据库中特定对象(如实例、数据库、表空间等等)的某一方面的健康状况。
Each indicator maps to a health aspect of the database for a particular object (for example, an instance, database, table space, and so on).
它还可以保存诸如大对象(Large Object,lob)之类的长数据,除非这些数据显式地存储在长表空间中。
It can also hold long data, such as large objects (LOBs), unless they are explicitly stored in long table Spaces.
不过有一个例外,对于“脏(dirty)”表空间中的long型字段和大型对象数据,总是需要进行备份。
The exception is for long field and large object data in "dirty" table Spaces, which are always backed up.
使用带COPYNO选项的ADMIN_COPY_SCHEMA过程会使目标数据库对象所在的表空间进入backuppending状态。
Using the ADMIN_COPY_SCHEMA procedure with the COPYNO option places the table Spaces, in which the target database object resides, in backup pending state.
在一个定义好的DB 2数据库中,实际的表必须在称作表空间(tablespace)的DB 2对象中创建。
Within a defined DB2 database, the actual tables must be created within DB2 objects called table Spaces. The user can define four different kinds of table Spaces in DB2.
这样做的效果是,大对象化的空间数据将被放入到那个表空间。
The effect will be that lobified spatial data will go to that table space.
为了在不同缓冲池中隔离对象,您可以在同一个数据库中创建一个以上的表空间,并给每一个表空间关联不同的缓冲池。
To isolate objects in different buffer pools, you can create more than one table space in the same database, and associate each table space with separate buffer pools.
它基本上允许将一个逻辑表拆分成跨一个或多个表空间的多个物理存储对象。
It basically allows a single logical table to be broken up into multiple physical storage objects across one or more table Spaces.
因为已经连接了一个V9.1示例数据库,所以应该能够看到所有表、列、表空间和其他重要的数据库对象。
Since you have connected to a V9.1 sample database, you should be able to see all the tables, columns, tablespaces, and other database objects that are of importance.
来自表空间userspace1的对象被复制到表空间V9_USERSPACE1中,其他表空间使用默认的表空间选择算法。
Objects from tablespace USERSPACE1 are copied to tablespace V9_USERSPACE1, the remaining table Spaces use a default table space selection algorithm.
这个过程调用从d: \TEMP \ UTIL_SCHEMA \中获取对象,并使用默认表空间将它们恢复到原来的模式中。
This procedure call retrieves the objects from d: \ TEMP \ UTIL_SCHEMA \ and restores them to the original schema using default tablespaces.
这意味着把表空间ts 1中的所有对象复制到目标数据库中的表空间ts2中,把表空间ts3中的对象复制到目标数据库中的表空间ts4中。
This means that all objects from tablespace TS1 is copied into tablespace TS2 on the target database, and objects from tablespace TS3 are copied into tablespace TS4 on the target.
可锁定的数据库对象有表空间、表和行,但是只有表和表空间可以显式地锁定。
Database objects that are lockable are table Spaces, tables and rows, however, only tables and table Spaces can be explicitly locked.
表空间是数据库与实际容纳数据的容器对象之间的逻辑层。
A tablespace is a logical layer between the database and the container objects that actually hold the data.
模式V 8r2m 5中的对象和包含的数据被复制到源表空间中的模式V 9r0m 0中,原来的对象所有者保持不变。
Objects for schema V8R2M5, and containing data, are copied to schema V9R0M0 into the source tablespace retaining the origin object owner.
因此,在索引对象包含数据分区的全部索引的情况下,指定表空间时,就无法为每个单独的索引指定表空间。
Hence, while you can specify the table space where the index object containing all the indexes for a data partition go, it is not possible to specify a table space for each individual index.
应用推荐