DB 210现在支持自动重新组织分区表空间的不相连分区范围。
DB2 10 can now automatically reorganize disjoint partition ranges of a partitioned table space.
在这个分区范围中,任何对于故事板的限制都应该被识别出来。
Within this bounding, any constraints that may be applicable for the storyboard should be identified.
Constant:在使用语法的自动生成形式时,指定每个数据分区范围的宽度。
Constant: Specifies the width of each data-partition range when the automatically generated form of the syntax is used.
而且,在本文稍后的部分,您将会了解到使用DB 2范围分区来将蛋白质的第一个(默认)模型从其他变体中分离出来的方法以及原因。
Also, you will see later in this article how and why we use DB2 range partitioning to separate the first (default) model of a protein from its variations.
目前,对包含范围分区子句的语句的转换,只有当使用MT K中的导入选项在一个输入文件中提供这些语句时才受支持。
Currently translations of statements containing the range partitioning clause are supported only when these statements are provided in an input file using the import option in the MTK.
支持临时表、常规表以及范围和列表类型的分区表。
Supports temporary, regular and partitioned tables of different types of range and list.
支持用户表、临时表、常规表以及范围、哈希和多维簇类型的分区表。
Supports user, temporary, regular and partitioned tables of different types range, hash and multidimensional clusters.
基本战略是范围、列表和散列分区。
The basic strategies are range, list, and hash partitioning.
这些数字表示我们可能期望在每个分区配置了较少用户的客户环境中看到的更典型的性能改进范围。
These Numbers represent perhaps a more typical range of performance improvements that we would expect to see in a customer environment configured with lower Numbers of users per partition.
范围分区可满足多种用途。
通过TP,用户可以手动地定义每个数据分区,包括将被包括到那个分区的值的范围。
With TP, the user can manually define each data partition, including the range of values to include in that data partition.
如果数据库分区和范围分区一同使用,那么表内的行首先会跨数据库分区做散列处理,然后再在每个数据库分区中执行范围分区。
If database partitioning and range partitioning are used together, the rows in a table are first hashed across the database partitions and then range-partitioned within each database partition.
这部分区域和美国海军的势力范围重合了。
That zone significantly overlaps the United States Navy's area of supremacy.
范围分区可以满足这个管理需求,DB 2 9.7已经改进了对这种技术的支持,可以处理XML数据。
Range partitioning addresses this administrative requirement, and DB2 9.7 extends prior support for this technology to include XML data.
数据分区也称为范围(当前DB 2只支持范围分区方案),一个数据分区包含一个行子集,这些行存储在与表中其他行集不同的地方。
A data partition, also referred to as a range (currently DB2 supports only a range partitioning scheme), contains a subset of rows that are stored separately from other sets of rows in the table.
如果表是一个范围集群表(不支持行压缩),可以考虑将其变换为范围分区表(支持行压缩)。
If the table is a range clustered table (that does not support row compression), you can consider switching it to become a range partitioned table (that supports row compression).
为了获得更好的性能和最小化空间消耗,我们建议使用数据库分区、范围分区、压缩和多维集群。
For best performance and minimal space consumption, we recommend using database partitioning, range partitioning, compression, and multi-dimensional clustering.
范围分区的概念与数据库分区的概念是一种正交关系。
The concept of range partitioning is orthogonal to the database partitioning.
DB 2UD B不允许MAXVALUE后面跟上任何其他值,每个分区值的范围必须有效。
DB2 UDB does not allow MAXVALUE to be followed by any other values, and the range must be valid for each partition value.
清单1和清单2显示了MT K对一个范围分区子句的转换。
Listings 1 and 2 show the translation of a range partitioning clause by MTK.
类型表、范围分区或mdc表。
本教程的目标是在以下方面探究DB29范围分区的特性和优点
The objective of this session is to explore the features and benefits of DB2 9 range partitioning in the following areas
要想防止在某一分区中存储特定的记录,可以用EXCLUSIVE选项创建范围。
To prevent specific records from being stored in a particular partition, you can create ranges using the EXCLUSIVE option. For example.
End:指定每个数据分区的范围上限。
End: Specifies the high end of the range for each data partition.
清单6显示了带范围分区的atom_site表的扩展定义。
Listing 6 shows the extended definition of the atom_site table with range partitioning.
RANGE/TABLEPARTITIONING(DB29提供) ——根据键范围将数据划分到一个逻辑数据库分区中的多个物理对象上。
RANGE/TABLE PARTITIONING (Available with DB2 9) - splitting data by key range over multiple physical objects within a logical database partition.
Start:指定数据分区的最低范围。
Start: Specifies the low end of the range for the data partition.
End:指定数据分区的最高范围。
End: Specifies the high end of the range for the data partition.
Page_Ranges属性包含一个范围,即范围1,其涵盖分区1到分区9。
The Page_Ranges attribute contains one range, range 1, which covers partition 1 to partition 9.
在获得系统范围的物理地址(PMB)之后,Hypervisor将它转换为分区相应的有效逻辑地址(LMB)。
After obtaining the system-wide physical address (PMB), the hypervisor translates this to the corresponding valid logical address (LMB) for the partition.
应用推荐