DB2 in the Digital Age

DB2 in the Digital Age
—
Sheryl M. Larsen
Sr. DB2 Product Specialist
June 2015
© Copyright 2015 BMC Software, Inc.
1
World is changing
Where is new data coming from
What does it look like
Mainframe as foundation
Customer expectations have changed
Impact on data center
DB2 Changing to meet the needs
Your responsibilities
© Copyright 2015 BMC Software, Inc.
2
1983
1994
2013
2015
© Copyright 2015 BMC Software, Inc.
DB2 V1
DB2 V2.1
DB2 V2.2
DB2 V2.3
DB2 V4
DB2 V5
DB2 V6 a & b
DB2 V7
DB2 V8
DB2 9
DB2 10
DB2 11
Cypress
3
Digital Business Is Everyone’s Business
“By 2020, more than seven billion people and businesses, and at least 30 billion devices,
will be connected to the Internet. With people, businesses and things communicating,
transacting, and even negotiating with each other, a new world comes into being – the
world of digital business.”
“The fact is that digital business will disrupt all industries and business executives, CIOs
and technology providers will need to think differently to help their businesses avoid
disruption. This is a new world that makes the prior ones obsolete while creating massive
opportunities for those who can visualize the opportunity.”
-Jorge Lopez, Gartner Inc.
Forbes.com “Digital Business is Everyone’s Business” 5/7/15
http://www.forbes.com/sites/gartnergroup/2014/05/07/digital-business-is-everyones-business/
© Copyright 2015 BMC Software, Inc.
© 6/3/2015 BMC Software, Inc. CONFIDENTIAL USE ONLY.
4
4
Digital Business Is Everyone’s Business
Business leaders who do not respond to the challenge of
digital business will find their own careers sidetracked.
CIOs who do not respond to the leadership challenge may
end up as custodians of infrastructure and back-end
technology only.”
- Gartner Analyst - Forbes
© Copyright 2015 BMC Software, Inc.
© 6/3/2015 BMC Software, Inc. CONFIDENTIAL USE ONLY.
5
5
Tony Seba
is a Lecturer in Entrepreneurship, Disruption and Clean Energy at Stanford University
© Copyright 2015 BMC Software, Inc.
https://www.youtube.com/watch?v=bmnSFdk5ISg
6
Platform
Components
Mobility
Internet of Things
Analytics
Automation
“Every time a consumer makes a purchase or hits refresh on a smart phone, it can
create a cascade of events on the back end of the computing
environment.
7
© Copyright 2015 BMC Software, Inc.
7
>1,000,000 CICS transactions
60,000 Google searches
47,000 YouTube views
30,000 Facebook Likes
6,900 Tweets
3,600
Instagram
photos
© Copyright 2015 BMC Software, Inc.
250 iTunes
downloads
8
Digital Data
AnalogStructured
© Copyright 2015 BMC Software, Inc.
Digitalunstructured
9
Mainframe: The Foundation for
Digital Business
Z13
• Support for 8000 virtual
machines
• 10TB memory
• JAVA is faster than COBOL
• 2.5B transactions/day
• Estimated to be 40T
by 2025!
“91% of new customer-facing apps access
data from z Systems” (IBM)
© Copyright 2015 BMC Software, Inc.
10
10
Platform
Components
Mobility
Internet of Things
Analytics
Automation
At the foundation of the cloud sits the mainframe!
© Copyright 2015 BMC Software, Inc.
11
11
Customers Expectations have changed
Entitled Consumers
Digital convenience
Multi channel – same information from
multiple sources
Always on
Anything from anywhere
Instant choice, multiple options
Competitive differentiation increasingly
difficult, innovations give advantage for days
not months or years
Demographic of one –I want it!
Can switch providers of services with a click of
a phone!
© Copyright 2015 BMC Software, Inc.
12
Impact on the Data Center
Volume
Speed
Variety
What are your top issues for Business/IT
alignment?
zettabytes
React to business
requests more…
Source - IDC
Now
© Copyright 2015 BMC Software, Inc.
2020
54%
Improve app
availability
18%
Manage business
service levels
15%
Provide cost
visibility
13%
Other
1%
13
Economic Disruptors
Key Mainframe Metrics 2005 - 2014
MIPS/FTE
HW % of spend
SW % of spend
2005
2006
Source:
© Copyright 2015 BMC Software,
Inc. Industry Data
2007
2008
2009
2010
2012
2013
2014
14
DB2 has kept up and evolved
DB2 1980s
Database Size
•A few Gigabytes
Table Size
•Tens of thousands of rows
•Max: A few million rows
Number of Objects
•Low Hundreds
Transactions per second
•Under 100
© Copyright 2015 BMC Software, Inc.
15
DB2 1980s
DB2 2010s
Database Size
Database Size
•A few Gigabytes
•70+ Terabytes
Table Size
Table Size
•Tens of thousands of rows
•Max: A few million rows
•Tens of millions of rows
•Max: A Few Billion rows
Number of Objects
Number of Objects
•Low Hundreds
•Tens of Thousands
Transactions per second
Transactions per second
•Under 100
•Over 10,000
© Copyright 2015 BMC Software, Inc.
16
Digitizing DB2
•
•
Incrementally reduced cpu cost of SQL in every release
Scalability improvements
•
•
•
Support for more and bigger pagesets
Availability improvements
•
•
Online reorgs seem like they’ve been around forever
Increased throughput by reducing contention
•
•
•
•
•
64-bit storage to relieve limits, increased log RBA size
lock avoidance etc.
ASCII and Unicode data storage
Stored Procedures, user defined functions and user defined datatypes
Timezone support with timestamps
XML
© Copyright 2015 BMC Software, Inc.
17
Online Schema Changes
• Ability to make changes online?
• Not really – more the ability to make changes WITHOUT AN
OUTAGE
– Or at least minimizing the outage
© Copyright 2015 BMC Software, Inc.
18
Deferred Schema
• Even less outage for a schema change
• With the right tools, schema changes with NO outage
• Get the message?
• Availability is KEY
© Copyright 2015 BMC Software, Inc.
19
Is “almost 24 X 7” good enough?
• Continuous availability isn’t “almost 24x7”
• It has to be CONTINUOUS
• 99.99% is ~1 HOUR downtime per year
– 99.999% is STILL not 100%
• How much does downtime cost YOU?
© Copyright 2015 BMC Software, Inc.
20
20
Object Sizes
•
•
•
•
•
Capacity of a single pageset – 2GB ?
Number of extents for a pageset – 23,000 +
Number of partitions – 4,096
Number of open datasets – 200,000
Number of tables in a join – 225
© Copyright 2015 BMC Software, Inc.
21
LOBs are containers
of unstructured
data
© Copyright 2015 BMC Software, Inc.
22
Unstructured Data Growth – Industry-wide
Millions of Petabytes
Structured
40
Unstructured
1
2010
© Copyright 2015 BMC Software, Inc.
2020
23
23
LOBs
© Copyright 2015 BMC Software, Inc.
24
Master DB2 Unstructured Data
IBM recommendation
Run:
CHECK LOB
Check
Integrity
CHECK DATA
CHECK IX
Run
Reorg
© Copyright 2015 BMC Software, Inc.
REORG
25
25
Ensure peak performance from all SQL
Maintain peak
performance
Without impacting
availability
© Copyright 2015 BMC Software, Inc.
26
Weekly reorgs
CPU Cost / Transaction
Reorganize MORE data
MORE often
Daily reorgs
Time
26
Optimizing Mainframe for Digital Business: Infrastructure
Unpredictable activity patterns
Digital Demands
Unprecedented availability &
performance expectations
Time to find and fix problems
measured in seconds
Skills issues
Adaptive automation
Infrastructure Management
Requirements
Dynamic adjustments
Self-learning
Intuitive Experience
© Copyright 2015 BMC Software, Inc.
Cost-efficient
27
Our Mission:Reduce Mainframe Total Cost of Ownership
Software = 45% of Mainframe Costs
MLC
30-35%
WAS
Peak R4HA
MQ
CICS
DB2
IMS
RACF
BMC Omegamon
Utilities
etc.
CA
Compuware
One-Time
Charges
ASG
Independent Software Vendors
10-15%
© Copyright 2015 BMC Software, Inc.
Hours
28
Lower Peak MIPS / MSU = Reduced Customer Cost
28
You Need to Ensure Your Mainframe Infrastructure is
Digital Business Ready
Adaptive automation
Deploy Intelligent Capping
Dynamic adjustments
AutoOperator & Threshold Advisor
Self-learning
Deploy intelligent capping strategy based on your
business defined policies
Alarm management, includes persistent checking and alerts
Automate Routine task
Dynamic thresholds, includes proactive analyzes to analyze
performance and set dynamic thresholds
Digital Business Workload Management
Intuitive Experience
Cost-efficient
© Copyright 2015 BMC Software, Inc.
Single View - across your Sysplex
Unix System Services
Network IP (SNA protocol has been removed
Reduce Monitoring Total Cost Ownership (TCO)
Collect data 1x; shared across infrastructure
Offload to zIIP reduce monitoring overhead
29
So…..
• DB2 is fundamentally different than it was in 1984
• Size
• Functionality
• Complexity
• You need digital ready solutions to manage it
© Copyright 2015 BMC Software, Inc.
30
Similar pages