db2 dpf linux,《DB2分区数据库简介-DPF.pdf》-支持高清全文免费浏览-max文档

DB2分区数据库简介-DPF.pdf

Global Technology Services

DB2-DPF

Grow market share

Thrive for excellence

2009-09

Succeed with smarter solutions

Zhang xiaodong

a-star@163.com

© 2009 IBM Corporation

Global Technology Services Growth Thrive for excellence Smarter solutions

Agenda

DB2

Why and When DPF

Page 2 | Zhang Xiao dong © 2009 IBM Corporation

Global Technology Services Growth Thrive for excellence Smarter solutions

DB2 DB2 DPF(Data Partitioning Feature)

DB2 Share-nothing

CPU

Page 3 | Zhang Xiao dong © 2009 IBM Corporation

Global Technology Services Growth Thrive for excellence Smarter solutions

DB2 DFP

DPF

shared-nothing

DPF SMP

DPF“”

DPF DB2 UDB ESE online

analytical processingOLAP

online transaction processingOLTP

Hash

SQL Coordinate Node

Partition key

Page 4 | Zhang Xiao dong © 2009 IBM Corporation

Global Technology Services Growth Thrive for excellence Smarter solutions

DB2 inter-partition parallelism

hash

intra-partition parallelism

CPU inter-partition parallelismintra-

partition parallelism DB2

backup/restore/load I/O

Page 5 | Zhang Xiao dong © 2009 IBM Corporati