database Partition Feature :
The Database Partitioning Feature (DPF) is a value-added option available with DB2 Enterprise 9. It extends the capability of DB2 9 into the parallel, multi-partition environment, improving performance and scalability of very large databases. This allows very complex queries to be executed much faster. DB2 Enterprise 9 with DPF is an ideal solution for managing data warehousing and data mining environments, but can also be used for large online transaction processing (OLTP) workloads.
A database partition can be either logical or physical. Logical partitions reside on the same physical server and can take advantage of SMP architecture. Having a
partitioned database on a single machine with multiple logical nodes is know as having a shared-everything architecture, because the partitions use common memory, CPUs, disk controllers, and disks. Physical partitions consist of two or more physical servers and the database is partitioned across these servers. This is know as a shared-nothing architecture, because each partition has its own memory, CPU’s, disk controllers and disks.
创建database partition
1、创建需要建立数据库分区的db instance
可使用命令建立db instance :
db2icrt -s ESE -u db2admin,aaa123456 -h ANWENHAO DBINSTANCENAME
创建完成对应的instance 后需要重启DB2 .
2、将新建的db instance 加入到DB2中:
CATALOG LOCAL NODE DB2INST1 INSTANCE DB2INST1 SYSTEM ANWENHAO OSTYPE NT;
3、在命令行中设置当前需要操作的dbInstance
set db2instance=db2inst1
db2 get instance
db2 attach to db2inst1
4、创建DBPartition :
db2start dbpartitionnum 1 ADD DBPARTITIONNUM HOSTNAME ANWENHAO PORT 1 COMPUTER ANWENHAO USER db2admin PASSWORD aaa123456 WITHOUT TABLESPACES
5、创建完成后需要重新启动db2。DB2在此时会增加一个database partition 并进行 redistribution
以上操作即完成database partition 。
创建database partition group :
CREATE DATABASE PARTITION GROUP "NODE1" ON DBPARTITIONNUMS (1);
COMMENT ON DATABASE PARTITION GROUP "NODE1" IS 'ANWENHAO _1';
然后可以在建立tablespace时选择是否建立在一个database partition group中。这样我们就可以轻松使用DB2的database Partition建立集群的应用了。
posted on 2007-08-21 17:03
安文豪 阅读(1409)
评论(0) 编辑 收藏