click to edit master title style ibm puredata system for operational analytics james cho chief...

Click to edit Master title style

IBM PureData System for Operational Analytics

James ChoChief Architect PureData Transaction SystemAnd Operational Analytics Solutions

Session Code:


Agenda

• Introduction Pure Systems• PureData for Operational Analytics• Smart Analytics 5600 • Questions/Discussion


Integration by DesignDeeply integrating and tuning hardware and software – in a ready-to-go workload optimized system

Built-in ExpertiseCapturing and

automating what experts do – from the

infrastructure patterns to the application patterns

Simplified ExperienceMaking every part of the IT lifecycle easier - with integrated management of the entire system and a

broad open ecosystem of optimized solutions

A new family of expert integrated systems

Systems with integrated expertise and built for cloud


Infrastructure Application Platform Data Platform

New

IBM PureSystems Family How much flexibility, integration and workload optimization do you want out of the box?

• New PureSystem with models optimized exclusively for data workloads

• New PureSystem with models optimized exclusively for data workloads

Integrated and optimized application platform

Built on IBM middleware to accelerate deployment of your choice of applications

Integrated and optimized infrastructure with flexibility

Runs your choice of applications and middleware

Integrated and optimized infrastructure with flexibility

Runs your choice of applications and middleware

Integrated and optimized data platform

Delivers high performance data services to transactional and analytics applications

Integrated and optimized data platform

Delivers high performance data services to transactional and analytics applications

• Delivering application platform services

• Delivering application platform services

• Delivering IT infrastructure services

• Delivering IT infrastructure services


10-100x faster than traditional custom systems4

20x greater concurrency and throughput for tactical queries than previous Netezza technology5

Pattern based database deploymentin minutes, not hours1

Handles more than 100 databases on 1 system2

IBM PureData System

Continuous ingest of operation data Handles 1000+ concurrent

operational queries3

Up to 10x storage savings with adaptive compression6

System for Transactions

System for Analytics

System for Operational Analytics

powered by Netezza technology

1. Based on IBM internal tests and system design for normal operation under expected typical workload. Individual results may vary.2. Based on one large configuration3. Based on IBM internal tests of prior generation system, and on system design for normal operations under expected typical workload. Individual results may vary. 4. Based on IBM customers' reported results. "Traditional custom systems" refers to systems that are not professionally pre-built, pre-tested and optimized. Individual results may vary.5. Based on IBM internal performance benchmarking6. Based on client testing is the DB2 10 Early Access Program

1. Based on IBM internal tests and system design for normal operation under expected typical workload. Individual results may vary.2. Based on one large configuration3. Based on IBM internal tests of prior generation system, and on system design for normal operations under expected typical workload. Individual results may vary. 4. Based on IBM customers' reported results. "Traditional custom systems" refers to systems that are not professionally pre-built, pre-tested and optimized. Individual results may vary.5. Based on IBM internal performance benchmarking6. Based on client testing is the DB2 10 Early Access Program


Operational AnalyticsExtreme concurrent query volumes on real time information

Business Analysts

Data Warehouse

Multiple, Concurrent Analytic Queries

201020092008200720062005

SALES

BI Reports and Analytics

100s to 1,000+ Read and Update QueriesBusiness Users, Call Centers, Online Queries, etc

Click to edit Master title stylePerformance and Mixed Workloads– Mixed Workloads

• Data Mining• Call Center• Small, large and extra large queries • High concurrency• Example:

Click to edit Master title styleAvailability and more frequent Ingest

Click to edit Master title styleProven Scalability Value to clients

– Can grow system as needed by adding data nodes– Typical customers grow data by 30% per year

Extra Small(Min Config)

+

Small Medium

1/3 RackUp to 133TB

2/3 RackUp to 266 TB

Full Rack400 TB

0 to 18 Data Expansion Racks+ +


• Embedded 7710 Single box solution – scales down as well as upoThe starting building block for 7700 scalable

• Consolidated GUI Console – significantly improved operational experience o“Single pane of glass” oAlerts for all HW/SW componentsoMaintenance for all firmware/software cluster wideoIntegrated OPM application management

• Enhanced availability – fewer components, reduced outage time oIntegrated Backup leveraging 900 GB HDDoRoving Standby, Hot swap SSDo56x fewer managed resources; 1/3rd fewer relationships

• Enhanced next generation SSD and enclosureoDense (1U) Dual Controller SSD enclosureoRAID-10 at high IOPS and bandwidth

• Higher Density – simpler manufacturing, shipment, serviceoOne HA group per rack: no FC cables cross racksoP730 2U server: ½ the rack spaceoDense SSD enclosure, Double Dense IO cards

• Higher I/O Bandwidth – high ingest capability, high scalingo40 Gbps etherchannel interconnecto64 Gbps FC storage bandwidth

• New Software Stack – DB210 capabilitiesoAIX 7.1 + DB2 10

Pure Data for Operational Analytics New Features


HA Simplification (‘small cluster’) Smart Analytics

7700

PureData for Operational

Analytics


HA tools in PureData for Operational Analytics

• hareset • Soft reset will bring the domain to a base state• Clear failed, stuck, pending states - remove resource

group requests across entire configuration• Rebuild HA configuration completely

• drop the domain, create domain, create all resources/groups/relationships/equivs etc.

• hachkconfig• Detect and repair resource model problems• Detect OS configuration issues that impact HA and

alert• Can be run automatically or manually

Click to edit Master title styleA1791 Component Building Blocks

Server NodesIBM 8205-E6C

IBM 8231-E2C

StorageIBM SSD 5888

IBM V7 2076-124

IBM V7 2076-224

Ethernet SwitchesIBM 1G 1455-64CIBM 10G 1455-48E

SAN switchesSAN48B-5

HMC7042-CR6

Figures are not to scale

1 U2 U3 U4 U5 U6 U7 U8 U9 U10U11U12U13U14U15U16U17U18U19U20U21U22U23U24U25U26U27U28U29U30U31U32U33U34U35U36U37U38U39U40U41U42U

PD

U

PD

UP

DU

PD

U

Cable ingress / egress


HMC 1

HMC 2Keyboard/Monitor/KVM

Switch Pwr Cord Routing

Filler panels

Cable Ingress / Egress


Foundation Server740_2

SSD Enclosure 2

10G Enet SW 10G Enet SW 2

1G Enet SW 3 1G Enet SW 4 10G Enet SW 3 10G Enet SW 4

10G Enet SW 1

Document Drawer

1G Enet SW 1 1G Enet SW 2

SAN Switch 2

SAN Switch 1

Storage Controller 1

SSD Enclosure 1

Storage Expansion 2

Storage Expansion 1

Foundation Standby740_1

Filler panels


Filler panels

PD

U

PD

UP

DU

PD

U



Data Server730_2

Storage Controller_2

SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3


Data Server730_4


Storage Expansion_6

Storage Expansion_5

SSD Enclosure_4





SAN Switch 1

SAN Switch 2

XL Foundation Rack Data Rack (s)

Capacity Add-onData Racks

Data Module 1

Data Module 2

Data Module 3

Roving StandbyModule

Foundation Modules


Add-On up to 5 x 8279-AD3Add-On up to 2 x 8279-AD3

Upgrade path

Upgrade path

Capacity Expansion Add-On8279-AD2


Filler panels

PD

U

PD

UP

DU

PD

U


2/3

Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3





SAN Switch 1

SAN Switch 2


Filler panels

PD

U

PD

UP

DU

PD

U


Ful

l Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3


Data Server730_4


Storage Expansion_6

Storage Expansion_5

SSD Enclosure_4





SAN Switch 1

SAN Switch 2

8279-AD38279-AD1


Filler panels

PD

U

PD

UP

DU

PD

U


1/3

Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1





SAN Switch 2

SAN Switch 1

MTM: XS - 8279-A01 (0.5D)S - 8279-A02 (1.5D)M - 8279-A03 (2.5D)L - 8279-A04 (3.5D) Scalable to 9.5 DXL - 8279-A05 (3.5D) Scalable to 18.5 D

Data Expansion Add-on:8279-AD1 (1D)8279-AD2 (2D)8279-AD3 (3D)

8279-A04


PD

U

PD

UP

DU

PD

U



Fo

un

datio

n R

ack

Filler panels




SSD Enclosure 2


Document Drawer


SAN Switch 2

SAN Switch 1


SSD Enclosure 1

Storage Expansion 2

Storage Expansion 1



HMC 1Filler panels


Filler panels

PD

U

PD

UP

DU

PD

U


Fu

ll D

ata

Ra

ck


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3


Data Server730_4


Storage Expansion_6

Storage Expansion_5

SSD Enclosure_4





SAN Switch 1

SAN Switch 2

8279-A05


PD

U

PD

UP

DU

PD

U



XL

Fo

unda

tion

Ra

ck

HMC 1



Filler panels




SSD Enclosure 2

10G Enet SW 10G Enet SW 2



10G Enet SW 1

Document Drawer


SAN Switch 2

SAN Switch 1


SSD Enclosure 1

Storage Expansion 2

Storage Expansion 1


Filler panels


Filler panels

PD

U

PD

UP

DU

PD

U


Ful

l Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3


Data Server730_4


Storage Expansion_6

Storage Expansion_5

SSD Enclosure_4





SAN Switch 1

SAN Switch 2

8279-A01


PD

U

PD

UP

DU

PD

U



Fo

un

da

tion

Ra

ck

Filler panels




SSD Enclosure 2


Document Drawer


SAN Switch 2

SAN Switch 1


SSD Enclosure 1

Storage Expansion 2

Storage Expansion 1



HMC 1Filler panels

8279-A02


PD

U

PD

UP

DU

PD

U



Fou

nda

tion

Ra

ck

Filler panels




SSD Enclosure 2


Document Drawer


SAN Switch 2

SAN Switch 1


SSD Enclosure 1

Storage Expansion 2

Storage Expansion 1



HMC 1Filler panels Filler panels


Filler panels

PD

U

PD

UP

DU

PD

U


1/3

Da

ta R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


SAN Switch 2



SAN Switch 1

8279-A03


PD

U

PD

UP

DU

PD

U



Fo

und

atio

n R

ack

Filler panels




SSD Enclosure 2


Document Drawer


SAN Switch 2

SAN Switch 1


SSD Enclosure 1

Storage Expansion 2

Storage Expansion 1



HMC 1Filler panels


Filler panels

PD

U

PD

UP

DU

PD

U


Fu

ll D

ata

Ra

ck


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3





SAN Switch 1

SAN Switch 2

Config Summary

Click to edit Master title styleMES Upgrade / Add-on Options

Model Upgrade: A01 – A04 Data nodes add-on ( lesser than 9D)

Data Server730

Storage Controller

Storage Expansion

Storage Expansion

SSD Enclosure

Storage Controller

Data Node Add(MES upgrade)

AD2à AD3

Field Install

Field Install

Data Server730

Storage Controller

Storage Expansion

Storage Expansion

SSD Enclosure

Storage Controller

A01à A02


Filler panels

PD

U

PD

UP

DU

PD

U


1/3

Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1





SAN Switch 1

SAN Switch 2

8279-AD1

Model Upgrade: AD1– AD3

8279-A04


PD

U

PD

UP

DU

PD

U



Fou

ndat

ion

Rac

k

Filler panels




SSD Enclosure 2


Document Drawer


SAN Switch 2

SAN Switch 1


SSD Enclosure 1

Storage Expansion 2

Storage Expansion 1



HMC 1Filler panels

8279-AD1/2/3

Field Install

Add-On below 9 Data Modules


Filler panels

PD

U

PD

UP

DU

PD

U


Ful

l Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3


Data Server730_4


Storage Expansion_6

Storage Expansion_5

SSD Enclosure_4





SAN Switch 1

SAN Switch 2


Filler panels

PD

U

PD

UP

DU

PD

U


Ful

l Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3


Data Server730_4


Storage Expansion_6

Storage Expansion_5

SSD Enclosure_4





SAN Switch 1

SAN Switch 2


PD

U

PD

UP

DU

PD

U



Fou

ndat

ion

Rac

k

Filler panels




SSD Enclosure 2


Document Drawer


SAN Switch 2

SAN Switch 1


SSD Enclosure 1

Storage Expansion 2

Storage Expansion 1



HMC 1Filler panels


Filler panels

PD

U

PD

UP

DU

PD

U


1/3

Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1





SAN Switch 1

SAN Switch 2

Field Install

Data Server730

Storage Controller

Storage Expansion

Storage Expansion

SSD Enclosure

Storage Controller

Data Node Add(MES upgrade)

A03à A04

Field Install

Field Install

Data Server730

Storage Controller

Storage Expansion

Storage Expansion

SSD Enclosure

Storage Controller

A02à A03

Field Install

Field Install

Switch ExpansionUpgrade

Model A04à A05

8279-A04


PD

U

PD

UP

DU

PD

U



Fou

ndat

ion

Ra

ck

HMC 1



Filler panels



Foundation Server740

SSD Enclosure

10G Enet SW 10G Enet SW 1 10G Enet SW 2

Document Drawer


SAN Switch 2

SAN Switch 1

Storage Controller

SSD Enclosure

Storage Expansion

Storage Expansion

Foundation Standby740

Filler panels

8279-AD3 8279-AD3Add-On beyond 9

Data Modules



8279-AD1


Filler panels

PD

U

PD

UP

DU

PD

U


1/3

Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1





SAN Switch 2

SAN Switch 1


Filler panels

PD

U

PD

UP

DU

PD

U


Ful

l Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3


Data Server730_4


Storage Expansion_6

Storage Expansion_5

SSD Enclosure_4





SAN Switch 1

SAN Switch 2


Filler panels

PD

U

PD

UP

DU

PD

U


Ful

l Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3


Data Server730_4


Storage Expansion_6

Storage Expansion_5

SSD Enclosure_4





SAN Switch 1

SAN Switch 2


Filler panels

PD

U

PD

UP

DU

PD

U


Ful

l Dat

a R

ack


Data Server730_2


SSD Enclosure_1

Storage Expansion_2

Storage Expansion_1

SSD Enclosure_2

Data Standby730_1


Data Server730_3


Storage Expansion_4

Storage Expansion_3

SSD Enclosure_3


Data Server730_4


Storage Expansion_6

Storage Expansion_5

SSD Enclosure_4





SAN Switch 1

SAN Switch 2

Data nodes add-on (10-18D)

Click to edit Master title styleA1791 Configuration SizesSize System Part

NumberModules Primary

Data (TB)Backup Cold

Data(TB)Comments

Foundation Data

XS A1791-01 8279-A01 1 0 10.8 21.6 0.5D

S A1791-02 8279-A02 1 1 32.4 64.8 1.5D

M A1791-03 8279-A03 1 2 54.0 108.0 2.5D

L A1791-04 8279-A04 1 3+ 75.6 151.2 3.5D to 9.5D(add up to 2 full add-on racks AD3)

XL A1791-X4 8279-A05 1+switches 3+ 75.6 151.2 3.5D to 18.5D(add up to 5 full add-on racks AD3)

Add-on data 1

A1791-E1 8279-AD1 n/a 1 21.6 43.2 1D

Add-on data 2

A1791-E2d 8279-AD2 n/a 2 43.2 86.4 2D

Add-on data 3

A1791-E3 8279-AD3 n/a 3 64.8 129.6 3D

Capacity per data module (foundation module has half)– 21.6 TB Primary “Hot” Active data– 43.2 TB free space (for backups, cold data, etc.)


PureData System for Operational Analytics System Console

• Provide “Easy to Use”, “Common” interfaces for management of Pure System Family

Unified Appliance UIUnified Appliance UI

Alerting via SNMP & Email(Single System Software Status, Hardware)

Platform Monitoring(Hardware and non workload specific)

Maintenance Wizard (Launch point integration)

User Authentication(For console roles/access only)

Workload MonitoringOPM (SSO, Debranding, LIC)

License AcceptanceOn initial interface access

System Console

Management

Monitoring

Maintenance


Simplified maintenance with pre-integrated fixes

Single point of contact for support

Automated updates for faster maintenance

All hardware firmware and OS software patches integrated and tested together at the factory


The Overview Dashboard – At a Glance view

Details on OS-level system CPU and paging utilization, and a break down of time within DB2

Details on OS-level system CPU and paging utilization, and a break down of time within DB2



Throughput within DB2 (statements, transactions, rows and connections) and average response time

Throughput within DB2 (statements, transactions, rows and connections) and average response time


The Overview Dashboard – At a Glance viewTop 3 SQLs – by elapsed time, CPU time, rows read, or lock wait time

Top 3 SQLs – by elapsed time, CPU time, rows read, or lock wait time



Two key pureScale metrics shown here:- GBP hit ratio- Average XI time

Two key pureScale metrics shown here:- GBP hit ratio- Average XI time

Performance focus: choose a tab to show core information on locking, I/O, SQL or pureScale-specific metrics.

Performance focus: choose a tab to show core information on locking, I/O, SQL or pureScale-specific metrics.


Performance Overview Report Provides good top-level view of overall system performance

– Choose metrics and sort orders that are most relevant for the database being analyzed

Report is exportable to pdf/xls/ppt formats– Useful for upline reporting– Drill-down available via other reports:


Drill down to alert in Database Performance Monitor


Enhanced Information Center• Information is organized according

to topic area and operational lifecycle• Overview, Planning, Getting Started,

Operational Tasks, Advanced Tasks, Troubleshooting, Reference

• Each section has further detail, and links to relevant information

• Easily searchable within the Information Center

• Easily searchable from any search engine

• Ability for users to enter comments on topics and participate in discussions

Click to edit Master title styleInformation Center – Sample comment


ISAS 5600 R3Announced April 9th

GA June 2013


5600 R3 Highlights• Server Refresh• 16 core, Intel® Xeon E5-2600 series

processors• 2 cores per partition• 192GB Memory

• 24 GB memory per partition

• Increased Storage Capacity• 900 GB SAS-2 Disk Drives Standard

• Excess space intended for cold data and/or local backup

• SSD Standard• Hot swap and RAID protected

• 10 Gb Database Interconnect Standard

• Optim Performance Manager 5.2• New Software Stack

• SLES 11 + DB2 10.1• Enhanced HA

• Roving Standby• Higher Availability with simpler HA

management• More stable cluster based file

system (replacing NFS)• fewer managed resources• fewer relationships

• New ATK Deployment• Simpler deployment model with

new ATK• Simplified software upgrades via

master image


Management Module

• New management module

• Incorporates Application module (separate in 5600 R1 and R2)• Provides rootfs images for core modules (xCAT)• HA for applications ISW and xCAT

• Management Module hosts the following applications• InfoSphere Warehouse (ISW) 10.1• Optim Performance Manager (OPM) 5.2• IBM Systems Director (ISD) 6.3• xCAT 2.7.5

IBM x3650 M48 core E5-2680 64GB memory

Management standby node

IBM x3650 M48 core E5-2680

64GB memory

Management node

Management module

DS35246 disks


IBM System x3650 M4

ISAS R3 PCI Adapters• 3 x Dual Port HBAs

•4 ports to disk•2 ports to LAN-free backup

• 1 x 10 Gb Ethernet NIC

ISAS R3 PCI Adapters• 3 x Dual Port HBAs

•4 ports to disk•2 ports to LAN-free backup

• 1 x 10 Gb Ethernet NIC


PCI placement – Core Warehouse Modules• Dual Socket Configuration

• Slot 1 (Riser1/Slot 1) full height full length• (empty)

• Slot 2 (Riser1/Slot 2) full height half length• 2nd QLogic 8Gb FC Dual-port HBA

• Slot 3 (Riser1/Slot 3) full height half length• 1st QLogic 8Gb FC Dual-port HBA

• Suggested slot priority: 3, 2, 6, 1, 5, 4

(empty)

QLogic 8Gb FC HBA

QLogic 8Gb FC HBA

(empty)

QLogic 8Gb FC HBA

Emulex 10GbE

– Slot 4 (Riser2/Slot 1) full height full length• (empty)

– Slot 5 (Riser2/Slot 2) full height full length• 3rd QLogic 8Gb FC Dual-port HBA

(LAN-free backup)– Slot 6 (Riser2/Slot 3) full height half length

• Emulex Dual Port 10GbE SFP+ VFA III (95Y3762)


GPFS DesignMGMT MGMT-STDBY ADMIN DATA1 DATA2 DATA3 DATA4 STDBY1

DATA5 DATA6 DATA7 DATA8 DATA9 STDBY2

HA GROUP 1

HA GROUP 2

GPFS cluster 1/db2home, /dwhome, /db2fs, /db2plog, /db2mlog, /stage

GPFS cluster 2/db2fs, /db2plog, /db2mlog

Remote from GPFS cluster 1/db2home, /dwhome, /stage

GPFS cluster 1/db2home, /dwhome,

/stage

quorum-managernsd server





Spinning diskSpinning disk: The total amount of storage available to the system, ie. Total drives x Drive capacity

Available spaceAvailable space: The total amount of storage that is available to the database software after RAID

Usable spaceUsable space: The total amount of storage that is available for hot active data including supporting objects like indexes, and temps

User spaceUser space: the amount of base data input to the system (Raw hot data) - number of records x record size; plus any aggregates or derived tables – assumed to be 55% of available usable space

Backup Space / Cold DataBackup Space / Cold Data: The total amount of storage that is available for database backups and cold data, which is infrequently accessed historical data

What is a Terabyte: Defining Terms

Indexes

Aggregates, Derived Tables

Raw Hot Data

Sys Overhead

Temp

Spinning Disk

Available Space

Ba

ck

up

/ C

old

Da

ta

RA

ID –

6 +

13

%

Backup Space

Aggregates, Derived Tables

Raw Hot Dataafter compression

User Space

no compression

Usable S

pace

User Space with compression


Smart Analytics System 5600 R3 data sizingCapacity Sizes

Smart Analytics System 5600

5600 R3 (900GB)5600 R2(300GB)

# Data Modules 1 1

Spinning Disk (TB) 42.2 14.1

Available Database Space after RAID formatting (/db2fs) (TB) 26.2 8.7

Active Space @ 33% (TB) 8.7 8.7

User Space @ 55% (TB) 4.8 4.8

User Space Compressed – Assuming 2.5x compression (TB) 12 12

Space available for index, temp, logs (TB) 3.9 3.9

Backup Space / Cold Data @ 66% (TB) 17.5 -

Peak User Space Compressed with Cold Data Compressed* (TB) 55.7 -

Solid State Device for temp (TB) 1.2 0.6 **

*Cold Data Compressed – infrequently accessed historical data w/o temps or logs** 5600 R2 with SSD option


ISAS 5600 Data Module ComparisonsData Module Configuration 5600 R1 5600 R2 5600 R3Data Partitions per Module 4 8 8

IBM Server X3650 M2 X3650 M3 X3650 M4

ProcessorIntel Xeon Processor

X5570 2.93 GHzIntel Xeon Processor

X5680 3.33 GHz Intel Xeon Processor

E5-2680 2.7 GHz

# cores4

1 x 4-core6

1 x 6-core16

2 x 8-core

Memory (GB) (@ Expedia)64 GB

(16 GB per partition)128 GB

(16 GB per partition)192 GB

(24 GB per partition)

SPECint_rate2006 per server 131 (estimated)193 (estimated)

(377 for 12 cores)664

SAN Subsystem 2 x DS3400 2 x DS3500 2 x DS3500# of disk drives 24 48 48HDD Disk type (@ Expedia) 600 GB @ 15k 3.5" 600 GB @ 10k SAS-2 2.5" 900 GB @ 10k SAS-2 2.5"

SSD Storageoptional

not configuredoptional

not configured

standard6 x 512GB SATA Enterprise

MLC SSDMB/second (estimated) 1200* 2400* 2400*

File System ext3 ext3 GPFS

Network 1 Gb Ethernet1 Gb Ethernet

10 Gb Ethernet (optional)10 Gb Ethernet

HAFailure to Standby server within

HA GroupFailure to Standby server within

HA GroupFailover to ROVING Standby

server within HA Group

Click to edit Master title styleClick to edit Master title style

James [email protected] PureData System for Operational

Evaluate my session online: www.idug.org/na2013/eval

click to edit master title style ibm puredata system for operational analytics james cho chief...

Documents

analytics system

system design

transactions system

entire system

ibm puredata system

analytics applications

optimized data platform

master title style performance