为了便于展示,仅以年为单位计算时间分区。
For demonstration purposes, the time partition is calculated by year only.
然后,每个数据分区在同一时间通过流程的一个副本运行。
Then, each partition of data is run through a copy of the same process at the same time.
手动地确定前滚一个数据库的正确时间点比较困难,对于分区数据库更是如此。
Manually determining the correct point in time to which to roll forward a database is difficult, particularly for a partitioned database.
这一天结束时,仍然需要充足的底层物理cpu容量,以满足分区CPU时的响应时间和吞吐量需求。
At the end of the day, there still needs to be adequate underlying physical CPU capacity to meet response time and throughput requirements when partitioning CPUs.
前面已讨论,对目的地分区的好处是,可以在同一时间为SCA、BPC和CEI活动提供消息传递引擎的多个实例。
Discussed earlier, partitioning the destinations provides the advantage of having multiple instances of the Messaging Engines for SCA, BPC, and CEI active at the same time.
随着时间的推移,因数据的改变,旧的分区键有可能会不如之前那么好。
It is also possible that over time, as your data changes, old partitioning keys become less optimal than they were previously.
有时您可能会用尽已配置的交换空间分区,从而在短时间内需要更多VM,直到您能够组织某种更永久性的解决方案。
There are times when you can run out of configured swap space partitions and, for a short period, require more VM until you can organize a more permanent solution.
其中一项研究认为,时间是由宇宙分区所引起的,宇宙被划分为多个分区,我们所感受到的时间反映了在这些分区中的变化。
According to one, time may arise from the way that the universe is partitioned; what we perceive as time reflects the relations among its pieces.
这在分区系统中尤为重要,您可以在极短时间内进行动态逻辑分区(DLPAR)。
This is particularly important in the partitioned world, when you can Dynamic Logical Partitioning (DLPAR) at a moments notice.
此外,通过跨多个数据库分区分散数据以使多个分区可并行处理分配到其上的数据,也能减少复杂的分析查询的响应时间。
Also, the response time of complex analytical queries can be reduced by spreading the data across multiple database partitions, such that all partitions work on their assigned data in parallel.
通过对目的地分区,可以在同一时间为SCA、BPC和CEI活动提供消息传递引擎的多个实例。
Partitioning the destinations provides the advantage of having multiple instances of the Messaging Engines for SCA, BPC, and CEI active at the same time.
分区调整操作需要花费一定时间来完成,从一秒钟到几个小时不等,取决于改变的本质和移动数据的多少。
Partition resizing operations can take anywhere from a fraction of a second to several hours to complete, depending on the nature of the change and how much data must be moved.
例如,我们无法针对分区的列使用标识列或者时间戳,而分区列需要是主键的组成部分。
For example, one cannot use identity columns or timestamps for the partitioning column, but the partitioning column has to be part of the primary key.
客户想删除除时间维(表是在这一列上进行数据分区的)以外的其他维上的大量数据。
A customer wants to delete large amounts of data on other dimensions than time (which is the column that the table is data partitioned on).
对于 XFS,值为 1.82 时表示这个10 秒钟的操作在未合理对齐的分区上需要花 18.2秒的时间。
The XFS figure of 1.82 means that this 10-second operation takes 18.2 seconds on an improperly aligned partition.
在大型分区环境中,从所有20或90个分区返回DB 2快照要花费很长时间。
In a large partitioned environment, it could take a long time for the DB2 snapshot to be returned from all 20 or 90 partitions.
低延迟改进场景:基于时间的分区数据。
Low latency improvement scenario: Partition data based on time.
完成这项任务所耗的时间变成为分区大小的函数f(1,000,000),而不再是要处理的总记录数的函数 f(100,000,000)。
The elapsed time for completing the task becomes a function of the partition size f(1,000,000) versus a function of the total number of records to process f(100,000,000).
单击options选项卡,指定数据库、感兴趣的分区和db2语句事件监视器应该运行的时间。
Click the Options TAB, and specify the database, the partition you are interested in, and the elapsed time the DB2 statement event monitor should run to collect data.
将文件解压到根文件系统分区(这可能需要一点时间)
Unpack files to the root file system partition (this command may take some time)
第二个Domino分区(DPAR2)有1413个注册用户,537个活动用户(38%),每天正常上班时间平均处理大约2,300,000个事务。
The second Domino partition (DPAR2) had 1413 registered users, 537 active users (38 percent), and averaged about 2,300,000 daily prime time transactions.
所谓静态的意思是,分配到每个分区上的资源不会随着时间而改变。
By static, I mean that the resources allocated to each partition do not change over time.
它能在启动过程中给你提供更多的控制,能够设置默认的启动分区和启动超时时间。
It gives you more control over the booting process, with the ability to set the default partition to boot and the booting timeout.
通过分别定义包含历史数据和当前月份数据的数据库视图,您可以根据时间对数据进行分区。
You can partition data based on time by defining database views that contain historic data and the current month data respectively.
而且,通过使用DPF,可以显著缩短备份和恢复时间,因为每台参与分区的机器需要处理的数据量更小了。
Furthermore, backup and recovery times can be significantly reduced when using DPF, due to the smaller amounts of data that each partitioning machine would be dealing with.
跟踪每天的事务数量,并按照数据库名称、分区编号和时间戳对其进行分组,以帮助进行工作负载规划。
Track the number of transactions per day grouped by database name, partition number, and timestamp to help with workload planning.
第一条命令将运行约10分钟,具体时间取决于您的根分区有多满。
The first command will run for about 10 minutes, depending on how full your root partition is.
通常,分区键是基于时间的,因此这种设计会把某一周、月或季度的数据存储在特定分区中。
Typically, the partitioning key is time-based, resulting in a design that directs data for a given week, month, or quarter to be stored in a certain partition.
通常表分区键是基于时间的列。
Usually the table partitioning key will be a time-based column.
DurationLabel:如果分区键列的数据类型是日期、时间或时间戳,这个参数指定与Constan t值相关的时间单位。
DurationLabel: Identifies the duration that is associated with the Constant value specified if the partitioning key column has been assigned a date, time, or time stamp data type.
应用推荐