db2多分區(qū)數(shù)據(jù)分布

1、2021/8/21DB2知識講座2021/8/22培訓(xùn)內(nèi)容Adding database partitionsRedistributing partition groupsAltering database partitionsDropping a database partitions2021/8/23Services file During the instance creation, a number of ports, which are equal to the number of logical nodes that the instance is capable of suppo

2、rting, 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

3、_1 端口號DB2_InstanceName_2 端口號DB2_InstanceName_END 端口號The only mandatory entries are the beginning (DB2_InstanceName) and ending (DB2_InstanceName_END) ports. The other entries are reserved in the services so that other applications do not use these ports2021/8/242021/8/25Database partitions can be ad

4、ded 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. db2start DBPARTITIONNUM 4 ADD DBPARTITIONNUM HOSTNAME db2Two PORT 2 without tab

5、lespaces(可選 ，建議有 )04/04/2007 09:00:16 4 0 SQL6075W The Start Database Manager operation successfully added the node. The node is not active until all nodes are stopped and started again. SQL6075W The Start Database Manager operation successfully added the node. The node is not active until all nodes

6、 are stopped and started again. 注意:那臺機器增加數(shù)據(jù)庫分區(qū)就登陸到那臺機器上發(fā)布命令2021/8/26Upon successful completion of the command, the new db2nodes.cfg is as shown The db2nodes.cfg after successfully adding a databaspartition 0 db2One 0 1 db2One 1 2 db2Two 0 3 db2Two 1 4 db2Two 2 Note: 也可以先更改db2nodes.cfg. 把要增加的分區(qū)填進去202

7、1/8/272021/8/28Add tablespacesu db2inst1db2Two: db2 alter tablespace tempspace01 add (/db2temp/db2inst1/itsodb/NODE0004/tempspace01) on dbpartitionnum (4)“u db2inst1db2Two: db2 alter database partition group IBMDEFAULTGROUP add dbpartitionnum(4) without tablespaces“u db2inst1db2Two: db2 alter tablespace userspace01 add ( file /tablespaces/db2inst1/itsodb/NODE0004/userspace01.001 20M ) on dbpartitionnum (4) DB20000I The SQL command completed successful表在 ibmcatagroup和ibm