db2多分区数据分布.ppt

DB2知识讲座;培训内容;Services file During the instance creation, a number of ports, which are equal to the number of logical nodes that the instance is capable of supporting, are reserved in the services file. The ports that are reserved in the services file are used by the DB2 Fast Communication Manager. The reserved ports have the following format: Cat /etc/services | grep db2 /etc/services with for ports reserved for db2inst1 DB2_InstanceName 端口号 DB2_InstanceName_1 端口号 DB2_InstanceName_2 端口号 DB2_InstanceName_END 端口号 ;;Database partitions can be added to a DPF environment by using the following commands: db2start... ADD DBPARTITIONNUM ADD DBPARTITIONNUM The db2start... ADD DBPARTITIONNUM command starts DB2 and adds a new partition to an existing instance and database.;;;;db2inst1@db2Two:～ export DB2NODE=0 (switching partitions) db2inst1@db2Two:～db2 terminate （终止db2后台进程使其有效） db2inst1@db2Two:～db2 connect to itsodb db2inst1@db2Two: ～ db2 “values (current dbpartitionnum)”(查看是否在0 这个分区上 ) db2inst1@db2Two:～ db2 “ redistribute database partition group IBMDEFAULTGROUP uniform” (从新发布下数据) db2inst1@udb2Two:～ db2 “select dbpartitionnum(id),count(*) from db2inst1.student group by dbpartitionnum(id) order by dbpartitionnum(id) （查看数据分布情况） ;db2inst1@db2Two: ～ export DB2NODE=4 db2inst1@db2Two: ～ db2 terminate db2inst1@db2Two: ～ db2 drop dbpartitionum verify (验证是否含有数据，如如有需要从新发布) db2inst1@db2Two: ～ export DB2NODE=0 db2inst1@db2Two: ～ db2 terminate db2inst1@db2Two: ～ db2 connect to itsodb db2inst1@db2Two: ～ db2 alter database partition group IBMDEFAULGROUP drop dbpartitionnum(4) “ db2inst1@db2Two: ～ db2 “ redistribute database partition group IBMDEFAULTGROUP uniform” db2inst1@db2Two:～ export export=4 db2inst1@db2Two:～ db2 terminate db2inst1@db2Two:～ db2 drop dbpartitionum verify db2inst1@db2Two: ～ db2stop drop dbpartitionnum 4 ;Thank a million;;