Listing 1 shows you the commands to use to create automatic storage table Spaces.
清单1显示了用于创建存储表空间的命令。
Create a table called accounts. This fictional table mocks a storage table of account Numbers.
创建名为accounts的表。
These automatic storage table Spaces actually use the DMS FILE infrastructure and have auto-resize turned on by default.
这些自动存储表空间实际上使用DMSFILE基础设施,并默认自动调整大小。
These automatic storage table Spaces that can automatically extend existing containers (or creates news ones) as your table Spaces fill up.
这些自动存储表空间可以随着您表空间的填满,自动扩展现有的容器(或创建新的)。
This feature is not enabled by default unless you are using the new automatic storage table space feature in V8.2.2 - then it's the default.
该特性不是默认启用的,除非使用V8.2.2中新的自动存储表空间特性 ——它才是默认的。
Within such a database, you can then create what are known as automatic storage table Spaces (they are available as DMS FILE table Spaces only).
在这样的数据库中,您可以接着创建称作自动存储表空间(它们仅仅可以作为DMSfile表空间使用)的东西。
The key file was generated with encrypted user key to store in the field of key in key storage table, and the key file was decrypted with the inputted user key.
用户密钥加密运算后生成的密文存入密钥存储表密钥字段,用输入的密钥解此密文。
The table collapses for easy storage.
这桌子可折叠起来方便存放。
The resulting table space will have a container on each storage path used by the database.
生成的表空间将在数据库使用的每个存储路径上拥有一个容器。
This feature requires you to specify, at database level, one or more storage paths where you want DB2 to create containers for every table space.
该功能需要您在数据库级指定一个或多个存储路径,您希望DB 2在该路径中为每个表空间创建容器。
Since relational data and indexes are stored in separate storage objects within a table space, they have separate read and write counters.
由于关系数据和索引存储在表空间内不同的存储对象中,因此它们具有不同的读和写计数器。
Table Types Depends on the storage engine.
表类型取决于存储引擎。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
Basically, DB2 handles all of the storage management tasks associated with the table space - completely online and without the need for manual intervention.
基本上,DB 2处理与表空间关联的所有存储管理任务——完全联机并且不需要人工干预。
A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.
缓冲池是内存中的一块存储区域,用于临时读入和更改数据库页(包含表行或索引项)。
Table space containers are the physical storage of IBM DB2 database.
表空间容器是IBMDB 2数据库的物理存储。
In simple terms, fragment-level statistics allows storage of column data distributions per fragment, and building the table level from its constituent fragments.
简单来说,片段级统计允许按片段存储列数据分布,并从组成的片段中构建表级别。
A table space is a storage structure containing tables, indexes, large objects, and long data.
表空间是一个包含表、索引、大对象和长数据的存储结构。
Once tables are distributed among table spaces, you need to determine their physical storage.
一旦将表分布到多个表空间中,就必须决定它们的物理存储器。
It basically allows a single logical table to be broken up into multiple physical storage objects across one or more table Spaces.
它基本上允许将一个逻辑表拆分成跨一个或多个表空间的多个物理存储对象。
A storage group contains database (s), and a database contains table Spaces.
存储组包含一个或多个数据库,数据库包含表空间。
There may be situations where a DBA must retain full control over how the storage for a particular table space is provided, but in most cases, databases will benefit from the use of automatic storage.
可能在某些情况下,DBA必须对如何提供特定表空间的存储保持完全控制权,但在大多数情况下,数据库将从使用自动存储中受益。
Automated storage is not really a separate type of table space but a different way of handling DMS storage.
自动存储实际上并不是一种表空间,而是另一种处理DMS存储的方法。
In addition to increasing database capacity, large RID support can also simplify table space management (through consolidation) and improve storage and memory utilization.
除了增加数据库容量外,对大型RID的支持还简化了表空间的管理(通过合并),并可以提高存储和内存的利用率。
For these table Spaces, you do not specify a list of containers to use for the storage.
对于这些表空间,您不要指定用于存储的容器列表。
Users can freely mix and match storage of traditional SQL data and XML in a single table.
用户可以在一个表中自由地混合存储传统SQL数据和XML数据。
It could be a house with a bed, a table, a chair, a place for food storage and preparation, a toilet, perhaps a shower.
它可以是一所带床,桌子,椅子的房子,一个可以储藏和准备食物,带厕所和淋浴设备的地方。
DB2 V9.5 introduces base table row storage of XML data.
DB 2V9.5引入了XML数据的基础表行存储。
Use a created global temporary table (CGTT) for per-session storage of the baseline data (use one CGTT per table function).
使用为基线数据的每会话存储创建的全局临时表(CGTT)(对于每个表函数,使用一个 CGTT)。
The ideal situation for base table row storage of XML data is when the table has only one column of XML type and the maximum size of the XML document doesn't exceed the page size.
使用XML数据基础表行存储的理想情形是,当表只有一个xml类型列并且XML文档的最大值没有超过页面大小时。
应用推荐