1 / 43

BMC Solutions for DB2 10 for z/OS

BMC Solutions for DB2 10 for z/OS. Peter Plevka, BMC Software. Wouldn’t it be nice…. BMC DB2 Solutions V10.1 BMC Performance Advisor, Part 3 Workload Index Advisor in Action. Agenda. BMC DB2 Solutions V10.1 – Highlights.

joben
Download Presentation

BMC Solutions for DB2 10 for z/OS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BMC Solutions for DB2 10 for z/OS Peter Plevka, BMC Software

  2. Wouldn’t it be nice…

  3. BMC DB2 Solutions V10.1 BMC Performance Advisor, Part 3 Workload Index Advisor in Action Agenda

  4. BMC DB2 Solutions V10.1 – Highlights • First vendor to exploitDB2 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....

  5. BMC DB2 Solutions V10.1 BMC Performance Advisor, Part 3 Workload Index Advisor in Action Agenda

  6. Does that sound familiar to you ? Dynamic SQL Applications Changes Additional Indexes Access Path Changes Complex SQL

  7. Performance Advisor Technology DB2 Turning DBA’s into tuning experts Advisors Automated Corrective Actions Trend reports Recommendationsnotices/alerts Statistics, Events Performance Management Database (PMDB) Merge / Rollup Access Path Data Object Statistics DB2Subsystem Stats/acctng SQL Workload Stats

  8. Performance Advisor Technology DB2 Turning data into Information Advisors Automated Corrective Actions Trend reports Recommendationsnotices/alerts Statistics, Events Performance Management Database (PMDB) RTS Catlgstats Sys/acctstats Stmt stats Object stats Stmt/obj stats Merge / Rollup Access Path Data Object Statistics DB2Subsystem Stats/acctng SQL Workload Stats Wrkld stats Reorg Cndts Index usage

  9. BMC Performance Advisor Technology DBA Smart Rebind for DB2 10 Workload Compare Advisor Workload Index Advisor Exception Advisor Reorg Advisor NEW BMC Performance Management Solutions for DB2 for z/OS

  10. Reorg Advisor – View results online

  11. BMC DB2 Solutions V10.1 BMC Performance Advisor, Part 3 Workload Index Advisor in Action Agenda

  12. PLAN_TABLE DB2A V9 PLAN_TABLE DB2P V10 OBJECT_FILE PATH_FILE SQLTXT_FILE COMPARE_FILE Workload Compare Advisor - Workflow BMC OBJECTSET DBRMLIB EXTRACT DB2 CATALOG BMC PADB DYN STMT CACHE EXPLAIN BMC APPTUNE Trace Dataset COMPARE & REPORT SQL DATASET SPUFI, SOURCE CODE

  13. OBJECT_FILE SQLTXT_FILE RIX_FILE REPORT From IXA and WLC PATH_FILE (w/ V-I) EXPLAIN #1 DSN_VIRTUAL_INDEXES EXPLAIN #2 EXPLAIN #1 DSN_VIRTUAL_INDEXES EXPLAIN #2 DB2B DB2A DB2 CATALOG BMC PADB DYN STMT CACHE DB2A Workload Index Advisor - Workflow BMC OBJECTSET DBRMLIB EXTRACT BMC APPTUNE Trace Dataset RECOMMINDEX REVIEW IX ADVISOR REPORT SQL DATASET SPUFI, SOURCE CODE

  14. Performance Advisors Menu

  15. Workload Access Path Compare Menu

  16. Extract SQL for Workload

  17. Object Set Specification

  18. Specify Explain Type

  19. Extract JCL

  20. Explain JCL

  21. Select Workload Index Advisor

  22. Index Advisor Menu

  23. IXA: Select Workload

  24. IXA: Recommindex Specifications

  25. IXA: Recommindex JCL

  26. IXA: Review Recommindex Report

  27. IXA: Select Recommindex Report

  28. IXA: Recommindex Report

  29. IXA: Recommindex Report – Select Table

  30. IXA: Column Usage Report

  31. IXA: Recommindex Report – Select Index

  32. IXA: Recommindex Report – Key Cols and Statements

  33. IXA: Recommindex Report – Select Statement

  34. IXA: SQL Text

  35. IXA: Recommindex Report – Recommendations

  36. WLC to Compare

  37. WLC: Compare

  38. WLC: Select Baseline and IXA Workloads

  39. WLC: Select Statement Compare

  40. WLC: Explain Compare

  41. Summary and Benefits • Reduce cost • Increase quality • Decrease go-to-market -time • Eliminate firefighting

  42. Questions

More Related