ASP源码.NET源码PHP源码JSP源码JAVA源码DELPHI源码PB源码VC源码VB源码Android源码
当前位置:首页 >> 数据库 >> DB2 >> DB2 添加新分区到分区组DATABASE PARTITION GROUP后,数据并未分布

DB2 添加新分区到分区组DATABASE PARTITION GROUP后,数据并未分布(1/3)

来源:网络整理     时间:2015-12-24     关键词:

本篇文章主要介绍了"DB2 添加新分区到分区组DATABASE PARTITION GROUP后,数据并未分布",主要涉及到方面的内容,对于DB2感兴趣的同学可以参考一下: 问题: DB2 DPF环境中, 往分区组中添加了新的分区之后,发现数据并没有分布到新添加的分区上, 即使是添加分区之后新创建的表空间也是如此。原因: When ...

问题:

 DB2 DPF环境中, 往分区组中添加了新的分区之后,发现数据并没有分布到新添加的分区上, 即使是添加分区之后新创建的表空间也是如此。

原因:

 When a database partition is added to a database partition group, a catalog entry is made for the database partition (see SYSCAT.DBPARTITIONGROUPDEF). The distribution map is changed immediately to include the new database partition, along with an indicator (IN_USE) that the database partition is in the distribution map if either:
    --no table spaces are defined in the database partition group or
    --no tables are defined in the table spaces defined in the database partition group and the WITHOUT TABLESPACES clause was not specified.


The distribution map is not changed and the indicator (IN_USE) is set to indicate that the database partition is not included in the distribution map if either:
    --Tables exist in table spaces in the database partition group or
    --Table spaces exist in the database partition group and the WITHOUT TABLESPACES clause was specified (unless all of the table spaces are defined to use automatic storage, in which case the WITHOUT TABLESPACES clause is ignored)


To change the distribution map, the REDISTRIBUTE DATABASE PARTITION GROUP command must be used. This redistributes any data, changes the distribution map, and changes the indicator. Table space containers need to be added before attempting to redistribute data if the WITHOUT TABLESPACES clause was specified.

问题重现:

PARTITION GROUP GOURP0123原本包含了分区0~3,并且创建了表空间tbs1。

现新添加分区4,之后创建表空间tbs2,并导入数据。 发现新添加的分区4上面根本没有数据。

相关图片

相关文章