posts - 30,  comments - 85,  trackbacks - 0

 

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、创建完成后需要重新启动db2DB2在此时会增加一个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中。这样我们就可以轻松使用DB2database Partition建立集群的应用了。

posted on 2007-08-21 17:03 安文豪 阅读(1403) 评论(0)  编辑  收藏

只有注册用户登录后才能发表评论。


网站导航:
 

<2007年8月>
2930311234
567891011
12131415161718
19202122232425
2627282930311
2345678

常用链接

留言簿(6)

随笔档案(28)

文章分类(3)

文章档案(4)

最新随笔

搜索

  •  

积分与排名

  • 积分 - 85908
  • 排名 - 663

最新评论

阅读排行榜

评论排行榜