注意,orderid列的值决定这个表中的行如何分区。
Note that the values of the ORDERID column dictate how rows will be partitioned for this table.
下面的例子展示如何创建采用压缩的分区表。
The following example shows how to create partition table with compression.
注意,处理器是如何基于工作负载在四个分区之间进行分配的。
Notice how the processors have been divided up between the four partitions based on workload.
图6显示了在分区的环境中如何处理中断的一个示例。
Figure 6 shows an example of how interrupt is handled in partitioned environment.
我要对R 5中的事务日志、分区、集群以及它们如何影响性能进行评论。
I have a few comments about transaction logging in R5, partitioning, and clustering, and how they affect performance.
在我的上一期专栏中,我阐述了如何使用表分区,基于一列或多列中的值,跨多个存储对象组织数据。
In my last column, I explained how you can use table partitioning to organize data across multiple storage objects based on values in one or more columns.
有一些高级的参数会影响分区如何格式化,但是对通常的用途来说,使用默认的参数就可以了。
There are various advanced parameters to affect how the partition is formatted, but for general purposes, the defaults are fine.
举例来说,您可以配置将数据划分到多少个分区中,以及如何复制这些分区。
For example, you configure how many partitions to split the data into, and how those partitions should be replicated.
清单2演示如何显示和切换激活的分页VIOS分区。
Listing 2 shows how to display and switch the active paging VIOS partition.
本文第一部分介绍 LVM配置及其如何与分区调整相互作用。
The first topic is LVM configuration and how it interacts with partition resizing.
在AIX7中,还有必要考虑虚拟内存的影响以及在工作负载分区(WPAR)中如何使用和应用它。
In AIX 7, it is also worth considering the effect of virtual memory and how it is used and applied within workload partitions (WPAR).
本文提供了如何根据您自己的需要选择最佳分区键的指导和工具。
This article provided guidance and tooling for choosing the best partitioning keys based on your needs.
还要讨论DB 2 9.7中的改进如何大大加快移入和移出数据分区的速度,减少这些操作产生的干扰。
I'll also show you how enhancements made in DB2 9.7 make the process of rolling data partitions in and out much faster and less disruptive.
如何查看工作负载分区的特征?
如何在工作负载分区中运行命令?
在这篇专栏文章中,我将讨论如何创建分区表,解释分区表的定义如何决定各个记录的存储位置。
In this column, I'll show you how to create partitioned tables, and I'll show you how a partitioned table's definition determines where individual records are stored.
如何删除工作负载分区?
如何创建工作负载分区?
如何停止工作负载分区?
如何启动工作负载分区?
Q:我如何能辨别已分区表上的索引是否被分区?
Q: How can I tell if an index on a partitioned table is partitioned?
如何登录工作负载分区?
Q:如何知道某行所在的数据分区?
本文介绍了POWER Hypervisor的作用,以及它如何在一个分区的环境中提高性能。
This article addresses the role of the POWER Hypervisor and how it facilitates performance in a partitioned environment.
通常,转出涉及到以下业务规则,并关系到如何使用DB 2分区特性的问题?
Generally, roll-out is subject to one of the following business rules, which has implications for how DB2 partitioning features are used.
概要文件类型定义了该分区如何被定制,来为终端用户支持特定功能的环境。
The profile type defines how the partition is customized to support a specific functional environment for the end user. There are currently three profile types supported in Version 6.
如果您打算在自己的环境中使用AMS,那么首先要考虑如何迁移到共享内存分区。
If you are going to use AMS in your environment, start thinking about how you will migrate to Shared memory partitions. Start with the basics, such as.
最后一个选项针对磁盘分区:安装程序将如何为机器的磁盘分区。
The last option is for disk partitioning: how the installer is going to partition the machine's disk. You have two options, but before you select one, read the Note below.
清单6展示了如何使用blkid来寻找根分区的标签和UUID,如何创建两个附加挂载点,以及在这两个附加挂载点上安装根分区。
Listing 6 shows how to use blkid to find the label and UUID for our root partition and then how to create two additional mount points and mount the root partition at these two additional points.
在保持表的可访问性的情况下如何更改分区键?
How to change partitioning keys while keeping the table fully accessible?
应用推荐