DBPartition 0 1

DBServer - P595 (Squadron) 64Way / 256 GB RAM

DimensionTables

Basis TablesMaster Data

Largest Table: 250GB# of Tables > 1G: 400# of Tablespaces: 500

2 3 4 5 6 7 8 9 10 3130

Large Objects(ODS / PSA)12 Partitions

MidSizeObjects (Fact)

8 Partitions

Small Objects1 Partition

File Sytems Space al located for the 60 TB databaseTotal = 65 TB

483

2083 2115

2047 20

94 2109

2089

2024 2062 2093

2049

1996 203

6 2089

2047

2010

2117

2045

2043 20

8520

9520

4520

43 2056 2066

2095

2084

1997

1963

2104

2085

1982

2127

0

500

1000

1500

2000

2500

0 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37DB2 Part it ions

Gig

aBy

tes

DB2 DPFPartitions

0-5Single LPAR

DB2Partition 0

(1-5 dormant)

DB2Partitions 6 -13

DB2Partitions 14 -21

DB2Partitions 22 -29

DB2Partitions 30 -37

DB2Partition 0

(1-5dormant)

DB2Partitions

6-13

DB2Partitions

14-21

DB2Partitions

22-29

DB2Partitions

30-37

As Received fromNestlé: single DBLPAR with 6 DB2

DPF partitons

6->33 Partitions

Redistribution of dataover 33 DB2 DPF

partitions and 5 x p5LPARs

Phase2

Scalability: DB2 distributed over 5p5-p595s. Final phase is p5 virtualization:

shared processor pool

NestléClone Phase1 Phase2

DA2

DA0

DA6

DA4

DA7

DA5

DA3

DA1

DA2

DA0

P20 – P36

P21 – P37

P20 – P36

P20 – P36P20 – P36

P21 – P37

P21 – P37P21 – P37

P6 – P22

P6 – P22 P6 – P22

P6 – P22

P7 – P23 P7 – P23

P7 – P23 P7 – P23

P8 – P24

P9 – P25

P8 – P24

P8 – P24P8 – P24

P9 – P25

P9 – P25 P9 – P25

P10 – P26

P11 – P27

P10 – P26

P10 – P26P10 – P26

P11 – P27

P11 – P27 P11 – P27

P12 – P28

P13 – P29

P12 – P28

P12 – P28 P12 – P28

P13 – P29

P13 – P29 P13 – P29

P14 – P30

P15 – P31

P14 – P30

P14 – P30P14 – P30

P15 – P31

P15 – P31 P15 – P31

P16 – P32

P17 – P33

P16 – P32

P16 – P32P16 – P32

P17 – P33

P17 – P33P17 – P33

P18 – P34

P19 – P35

P18 – P34

P18 – P34P18 – P34

P19 – P35

P19 – P35 P19 – P35

Sour

ce

Targ

et

Sour

ce

Targ

et

DS83007-20TB

DS8300Turbo20TB

4 x DS8300Turbo60TB

Phase1 Phase2

Ea. 512 Disks (146GB 15K rpm) 54TBs Capacity (production + FC)

Redistributionof DB2 datafrom sharedto non-sharedfilesystems

Grow to20TB

Redistibutethe DB2nodes over5 LPARsand 4storageservers

Grow to 60Terabyte

CPUby WLM classes sys3db1p 9/1/2006

0

10

20

30

40

50

60

T000

5

T000

6

T000

7

T000

8

T000

9

T001

0

T001

1

T001

2

T001

3

T001

4

T001

5

T001

6

T001

7

T001

8

T001

9

T002

0

T002

1

T002

2

T002

3

T002

4

T002

5

T002

6

T002

7

T002

8

T002

9

T003

0

T003

1

T003

2

T003

3

T003

4

T003

5

T003

6

T003

7

T003

8

T003

9

T004

0

T004

1

T004

2

CNODE6 CNODE7 CNODE8 CNODE9 CNODE10 CNODE11 CNODE12 CNODE13

N14 Total I/ORate - Individual Data Volumes

0

200

400

600

800

1000

1200

1400

1600

1800

5:31

5:51

6:11

6:31

6:51

7:11

7:31

7:51

8:11

8:31

8:51

9:11

9:31

9:51

10:1

1

10:3

1

10:5

1

11:1

1

11:3

1

11:5

1

12:1

1

Time

I/ORa

te(IO

PS)

N37 Total I/ORate - Individual Data Volumes

0

200

400

600

800

1000

1200

1400

1600

1800

5:31

5:51

6:11

6:31

6:51

7:11

7:31

7:51

8:11

8:31

8:51

9:11

9:31

9:51

10:1

1

10:3

1

10:5

1

11:1

1

11:3

1

11:5

1

12:1

1

I/ORa

te(IO

PS)

AIX operating system

AIX operating system

DB2 UDB ESE

Tivoli Data Protectionfor SAP (DB2)

Tivoli Storage ManagerAPI Client

Tivoli Data Protectionfor ACS

Tivoli Storage AgentLANfree backup/restore

Online backuptape restoreLog archiving

Management andWorkflow forFlashCopy Backup

DB2 UDB ESE

Tivoli Data Protectionfor SAP (DB2)

Tivoli Storage ManagerAPI Client

Tivoli StorageManager Server

Backup ofFlashCopy image

Tivoli Data Protectionfor ACS

Management andWorkflow forFlashCopy Backup

LTO3tape delegation for LANfree

Log archiving (LAN)

Source FCTarget

FlashCopy

DS8000

CIM AgentInterface toFlashCopyCopyServices

http:Port 5988

production server backup server

SHMEM

SHMEMTCP/IP (loopback)

TCP/IP

Restore per DB2 Partition

0,00

100,00

200,00

300,00

400,00

500,00

600,00

700,00

800,00

0 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

Parti tion Number

GB/h

our

2 Tape Devices used

470 GB/h => 133 MB/sec.

Rollforward Recovery per Partition

0

50

100

150

200

250

03:30:00 04:30:00 05:30:00 06:30:00time

logfi

les

reco

vere

d[G

B]

NODE0000 NODE0006 NODE0007 NODE0008 NODE0009 NODE0010 NODE0011 NODE0012 NODE0013NODE0014 NODE0015 NODE0016 NODE0017 NODE0018 NODE0019 NODE0020 NODE0021 NODE0022NODE0023 NODE0024 NODE0025 NODE0026 NODE0027 NODE0028 NODE0029 NODE0030 NODE0031NODE0032 NODE0033 NODE0034 NODE0035 NODE0036 NODE0037

DB2 Partition 0

32 inParallel

Ref. Description Requirement AchievementKPI-1 Recovery of an entire days’ work

Restore database and roll forward500GB of logs

<8hrs 2hr 40minusing IBMFlashCopy

KPI-2 Disaster recoveryComplete database restore from tape plusroll forward of 2TB of logs

<24hr 10hrsUsing LTO3tapes

KPI-3.a Daily backup to tapeFull database backup to tape

<12hr 6hr 10minusing LTO3

KPI-3.b Daily backup to diskCompleted incremental FlashCopyof production day

<8hr 30minDS8300 Turbo

AIX 5.2DB2 V8

AIX 5.3DB2 V8

AIX 5.3DB2 V9

AIX 5.3micropartions

DB2 V9

Phase 1 Phase 2

7TB - 20 TB

20TB - 60 TB

CustomerBasis

21

21 1

6

12,25

1

3,9

01234567

PhysicalCPUs

Query Aggregate Load KPI-A KPI-D

Workload Distribution Ratio DB:APPS

DBAPPS

Backup

Online

Extractor

Aggregate

SAPCI

DB

Backup

Online

Upload

DB

Backup

Online

Upload

DB

Backup

Online

Upload

DB

Backup

Online

Upload

DB1

2

3

P595 N °0 P595 N °1 P595 N °2 P595 N °3 P595 N °4

Upload

Online

DB

Backup

Max

CPU:

488

Max

CPU:

20M

ax10

1

2

3

P595 N °1 to 4 :

CE= 16

CE = 5

CE= 10

CE= 7

Total Virtual CPU= 86 Total CE = 38

MAXCPUper P595 = 64

PhysCPUUtil per Component

70

140 146

219

31 3549

72

0

50

100

150

200

250

KPIA-20 KPID-20 KPID-60 KPIG-60

PhyC

PUUt

ilize

d

AppsDBLinear (DB)

Load vs CPURatio for Scale (GHz basis)

0123456

KPIA-20 KPID-20 KPID-60 KPIG-60

Incr

ease

Fact

or

Load.Scale

Phyc.Scale

Linear (Load.Scale)

Linear (Phyc.Scale)

0

20

40

60

80

100

120

140

KPIA

KPIA

KPIA

KPID

KPID

KPID

KPID

KPID

KPID

KPID

KPID

KPID

KPIG

0

5

10

15

20

25

LOADAGGRRTIME10x TXTRATE

i bm -sap .c om

s ap.c om

ibm .c om

ibm .c om