Transcript Slide 1

BMC Solutions for DB2 10 for z/OS
Peter Plevka, BMC Software
Wouldn’t it be nice…
© Copyright 7/16/2015 BMC Software, Inc
2
Agenda
BMC DB2 Solutions V10.1
BMC Performance Advisor, Part 3
Workload Index Advisor in Action
© Copyright 7/16/2015 BMC Software, Inc
3
BMC DB2 Solutions V10.1 – Highlights
First vendor to exploit DB2 10 for z/OS in all 23 BMC products for DB2
New release supports DB2 8, DB2 9 and DB2 10 for z/OS
Reduce costs through more zIIP enablement across solutions
Efficiency Filtering - Don’t waste CPU by monitoring efficient SQL
Workload Compare Advisor ensures that migration to DB2 10 does not
introduce performance problems
Increase staff scalability with new intelligent Workload Index Advisor
Web access to Common Explain Function via Mainview Explorer
Reduce scheduled outages with more efficient DB2 utilities
More....
© Copyright 7/16/2015 BMC Software, Inc
4
Agenda
BMC DB2 Solutions V10.1
BMC Performance Advisor, Part 3
Workload Index Advisor in Action
© Copyright 7/16/2015 BMC Software, Inc
5
Does that sound familiar to you ?
Applications
Changes
Dynamic SQL
Additional
Indexes
Access Path
Changes
© Copyright 7/16/2015 BMC Software, Inc
Complex SQL
6
Performance Advisor Technology
Turning DBA’s into tuning experts
Automated
Corrective
Actions
DB2
Advisors
Trend reports
Recommendations
notices/alerts
Statistics, Events
DB2 Subsystem
Stats/acctng
Object Statistics
Access Path
Data
SQL Workload
Stats
© Copyright 7/16/2015 BMC Software, Inc
Performance Management
Database (PMDB)
Merge / Rollup
7
Performance Advisor Technology
Turning data into Information
Automated
Corrective
Actions
DB2
Trend reports
Recommendations
notices/alerts
Advisors
Statistics, Events
DB2 Subsystem
Stats/acctng
Object Statistics
Access Path
Data
SQL Workload
Stats
© Copyright 7/16/2015 BMC Software, Inc
Merge / Rollup
Performance Management
Database (PMDB)
RTS
Catlg
stats
Sys/acct
stats
Stmt
stats
Object
stats
Stmt/obj
stats
Wrkld
stats
Reorg
Cndts
Index
usage
8
BMC Performance Advisor Technology
DBA
Smart Rebind
for DB2 10
Workload
Compare
Advisor
Workload
Index NEW
Advisor
Exception
Advisor
Reorg
Advisor
BMC Performance Management Solutions for DB2 for z/OS
© Copyright 7/16/2015 BMC Software, Inc
9
Reorg Advisor – View results online
© Copyright 7/16/2015 BMC Software, Inc
10
Agenda
BMC DB2 Solutions V10.1
BMC Performance Advisor, Part 3
Workload Index Advisor in Action
© Copyright 7/16/2015 BMC Software, Inc
11
Workload Compare Advisor - Workflow
BMC OBJECTSET
SQLTXT_FILE
DBRMLIB
EXTRACT
DB2A V9
DB2P V10
PLAN_TABLE
DB2 CATALOG
BMC PADB
DYN STMT CACHE
PLAN_TABLE
EXPLAIN
OBJECT_FILE
PATH_FILE
BMC
APPTUNE
Trace Dataset
COMPARE_FILE
SQL DATASET
SPUFI,
SOURCE CODE
© Copyright 7/16/2015 BMC Software, Inc
COMPARE &
REPORT
12
Workload Index Advisor - Workflow
BMC OBJECTSET
SQLTXT_FILE
From IXA and WLC
DBRMLIB
DB2A
EXTRACT
BMC
APPTUNE
Trace Dataset
DB2B
EXPLAIN #1
DSN_VIRTUAL_INDEXES
EXPLAIN #2
DB2A
DB2 CATALOG
BMC PADB
DYN STMT CACHE
SQL DATASET
SPUFI,
SOURCE CODE
© Copyright 7/16/2015 BMC Software, Inc
EXPLAIN #1
DSN_VIRTUAL_INDEXES
EXPLAIN #2
RECOMMINDEX
OBJECT_FILE
PATH_FILE (w/ V-I)
RIX_FILE REPORT
REVIEW IX ADVISOR
REPORT
13
Performance Advisors Menu
© Copyright 7/16/2015 BMC Software, Inc
14
Workload Access Path Compare Menu
© Copyright 7/16/2015 BMC Software, Inc
15
Extract SQL for Workload
© Copyright 7/16/2015 BMC Software, Inc
16
Object Set Specification
© Copyright 7/16/2015 BMC Software, Inc
17
Specify Explain Type
© Copyright 7/16/2015 BMC Software, Inc
18
Extract JCL
© Copyright 7/16/2015 BMC Software, Inc
19
Explain JCL
© Copyright 7/16/2015 BMC Software, Inc
20
Select Workload Index Advisor
© Copyright 7/16/2015 BMC Software, Inc
21
Index Advisor Menu
© Copyright 7/16/2015 BMC Software, Inc
22
IXA: Select Workload
© Copyright 7/16/2015 BMC Software, Inc
23
IXA: Recommindex Specifications
© Copyright 7/16/2015 BMC Software, Inc
24
IXA: Recommindex JCL
© Copyright 7/16/2015 BMC Software, Inc
25
IXA: Review Recommindex Report
© Copyright 7/16/2015 BMC Software, Inc
26
IXA: Select Recommindex Report
© Copyright 7/16/2015 BMC Software, Inc
27
IXA: Recommindex Report
© Copyright 7/16/2015 BMC Software, Inc
28
IXA: Recommindex Report – Select Table
© Copyright 7/16/2015 BMC Software, Inc
29
IXA: Column Usage Report
© Copyright 7/16/2015 BMC Software, Inc
30
IXA: Recommindex Report – Select Index
© Copyright 7/16/2015 BMC Software, Inc
31
IXA: Recommindex Report – Key Cols and
Statements
© Copyright 7/16/2015 BMC Software, Inc
32
IXA: Recommindex Report – Select Statement
© Copyright 7/16/2015 BMC Software, Inc
33
IXA: SQL Text
© Copyright 7/16/2015 BMC Software, Inc
34
IXA: Recommindex Report – Recommendations
© Copyright 7/16/2015 BMC Software, Inc
35
WLC to Compare
© Copyright 7/16/2015 BMC Software, Inc
36
WLC: Compare
© Copyright 7/16/2015 BMC Software, Inc
37
WLC: Select Baseline and IXA Workloads
© Copyright 7/16/2015 BMC Software, Inc
38
WLC: Select Statement Compare
© Copyright 7/16/2015 BMC Software, Inc
39
WLC: Explain Compare
© Copyright 7/16/2015 BMC Software, Inc
40
Summary and Benefits
Reduce cost
Increase quality
Decrease go-to-market -time
Eliminate firefighting
© Copyright 7/16/2015 BMC Software, Inc
41
Questions
© Copyright 7/16/2015 BMC Software, Inc
42
© Copyright 7/16/2015 BMC Software, Inc
43