Table, table partition, or table cluster.
表,分区表,簇表。
An in-place alter does not change the table partition Numbers.
in - placealter不会改变表分区号。
Validate the structure of an index or index partition, table or table partition, index-organized table.
增加下列结构的有效性:索引或索引分区,表或表分区,索引表。
Process DML log records generated due to an alter operation while moving the rows from the old partition to the new table partition.
处理在将旧分区中的行转移到新表分区时因alter操作而生成的DML日志记录。
Although, since table partitions are treated just like an individual table, a partition could theoretically grow to a maximum of 16tb.
尽管表分区就像是一个单独的表,但是一个分区理论上最大可以达到16TB。
The replay position advancement is necessary because the slow alter, alter fragment, and clustered index creation operations change the table partition Numbers.
重放位置的推进是必需的,因为slowalter、alterfragment和集群索引创建操作会改变表分区号。
If a table partition does not exist on the database partition, the request is sent to the first database partition in the database partition group that holds a partition for that table.
如果表分区不在该数据库分区上,那么将请求发送给数据库分区组中持有该表分区的第一个数据库分区。
We have shown you how to partition one table.
我们已经展示了如何划分一个表。
The following example shows how to create partition table with compression.
下面的例子展示如何创建采用压缩的分区表。
Additionally, ADC only occurs if no compression dictionary exists within the physical table data object or partition.
此外,只有当物理表数据对象或分区中没有压缩字典时,才能运行adc。
Each row in the table represents one partition or system to verify.
表中的一行代表要验证的一个分区或系统。
It does this by looking through the partition table for an active partition.
它是通过在分区表中查找一个活动分区来实现这种功能的。
Partition the table space as evenly as possible, because the degree of parallelism is influenced by skews in the data.
尽可能均匀地对表空间分区,因为数据不整齐会对并行度产生影响。
DB2 provides the capability to compress the data in a table space or partition.
DB 2提供了压缩一个表空间或分区中的数据的能力。
Patterns in the data: the frequency of recurring patterns in the data determines how effective compression will be for a particular table space or partition.
数据中的模式:对于特定的表空间或分区,数据中重复出现的模式的出现频率将决定压缩的效果。
Specifically, an administrator must define appropriate database objects, such as partition groups, table Spaces, buffer pools, and so on.
具体地说,管理员必须定义适当的数据库对象,比如分区组、表空间、缓冲区池等等。
If the SQL table was a partitioned table, each partition (member) could have a separate media preference.
如果sql表是一个分区表,每个分区(成员)都可以有一个单独的媒介首选项。
Create the table space in the database partition group.
创建数据库分区组内的表空间。
The primary boot loader that resides in the MBR is a 512-byte image containing both program code and a small partition table (see Figure 2).
MBR中的主引导加载程序是一个 512字节大小的映像,其中包含程序代码和一个小分区表(参见图2)。
Disk errors, administrator mistakes, and other problems can affect all the volumes on a disk by wiping out critical disk structures, such as the partition table.
磁盘错误、管理员的失误和其他问题可能会破坏关键的磁盘结构(比如分区表),从而影响一个磁盘上的所有卷。
Note that each partition of a partitioned table can have a different compression dictionaries and each partition of a table in DPF can have a different compression dictionaries.
注意,分区表的每个分区可以有不同的压缩词典,在DPF中一个表的每个分区也可以有不同的压缩词典。
Q: Can the local index partition and data partition be in the same table space for each partition?
Q:每个分区的本地索引分区和数据分区能否处于同一表空间中?
Therefore, REORG usually produces a dictionary that is more representative of the data in the entire table space or partition.
因此,REORG常常可以产生更能代表整个表空间或分区中的数据的字典。
There are several ways to partition a table, but the focus of this article is distribution by hash.
对表进行分区的方法有几种,但本文只着重于哈希方式的分区。
For other ways to partition the table, refer to the article in the Resources section.
有关其他的分区方式,请参考 参考资料部分给出的文章。
The MBR is the first sector on the disk, so the partition table is not a very large part of it.
MBR是磁盘上的第一个扇区,因而分区表在其中所占空间不大。
These counters are incremented by the respective DML operation occurring on the partition, both table and index partitions.
这些计数器由表和索引分区中发生的各个DML操作实现值累加。
The IPL interrogates the partition table and subsequently is able to load data wherever it may exist on the various media.
IPL查询分区表,从而能够加载位于不同介质上任意位置的数据。
For example, DB2 UDB LUW allows a maximum size of 512 GB for a table per partition.
比如,DB 2UDBLUW在每个分区上允许表最大为512GB。
For example, DB2 UDB LUW allows a maximum size of 512 GB for a table per partition.
比如,DB 2UDBLUW在每个分区上允许表最大为512GB。
应用推荐