在数据库分区环境中,需要为DB 2创建三个组和用户ID,如下表所示。
In a database partitioning environment, you need to create three groups and user IDs for DB2. They are shown in the table below.
于是DB 2就可以在存储数据的数据库分区上执行连接或子查询,而不必在数据库分区之间移动数据。
DB2 can then choose to perform the join or subquery at the database partition where the data is stored, instead of having to move data between database partitions.
distinct值的数量必须多到足以确保数据行均匀地分布在数据库分区组中的所有数据库分区上。
The number of distinct values must be great enough to ensure an even distribution of rows across all database partitions in the database partition group.
如果容器名称中在数据库分区表达式后面没有空格字符,则认为剩下的字符串是表达式的一部分。
If there is no space character in the container name after the database partition expression, it is assumed that the rest of the string is part of the expression.
如果不需要特别考虑并置,那么能使数据均匀地散布在数据库分区组中所有数据库分区上的分区键就是好的分区键。
If collocation is not a major consideration, a good partitioning key for a table is one that spreads the data evenly across all database partitions in the database partition group.
理论上讲,可以在数据库分区组中尚未重分发的表上执行select、insert、update或delete语句。
In theory, you can perform select, insert, update, or delete statements against a table that is not yet redistributed in the database partition group.
通常,在数据库分区组重分发之后,需要在重分发的表上执行离线的table reorg、indexrecreation(必要时)和runstats。
Generally, after a redistribution of a database partition group, you need to perform an offline table reorg, index recreation (if necessary), and runstats on the redistributed table.
通常,在数据库分区组重分发之后,需要在重分发的表上执行离线的table reorg、indexrecreation(必要时)和runstats。
Generally, after a redistribution of a database partition group, you need to perform an offline table reorg, index recreation (if necessary), and runstats on the redistributed table.
应用推荐