it's not a dream—conquer chaos for your db2® for z/os® optimization nightmares
TRANSCRIPT
It’s Not a Dream—Conquer Chaos for your DB2 for z/OS® Optimization Nightmares
Mainframe
Dhananjay Joshi (DJ)
CA Technologies
Sr. Principal Product Manager, Data Management
MFT12T
@zBigIron
#CAWorld
2 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Abstract
Database optimization tasks must be continually
performed to help improve performance, scalability,
platform support, standards compliance and usability
while simultaneously reducing costs and risk. Have
difficulty building, testing and deploying new DB2®
database functions and performance? Learn more about
a number of new enhancements for your DB2 database
management tools from CA Technologies.
Dhananjay Joshi (DJ)
CA Technologies
Sr. Principal Product Manager
Data Management
3 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Agenda
OPTIMIZING YOUR DB2 ENVIRONMENT
TESTING, MIGRATING AND DEPLOYING NEW DB2 FUNCTIONS
PROACTIVE PERFORMANCE MANAGEMENT
SPECIAL SCENARIOS
Q & A
1
2
3
4
5
4 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
The Challenge
Methods Adjusts SQL statements, runs reorg utility, tunes databases, etc.
Challenge Finding best applications to tune
Data Performance metrics for executions of SQL statements, packages and plans (Version 1 uses data from CA Detector® for DB2 for z/OS)
Limitations Performance metrics tell you where you are, but fall short: How you got here (is today’s behavior “normal”?) Where you are going (is performance getting better or worse?) Where the greatest tuning potential is (which applications account for the greatest
increases in resource usage? ) Does is matter if a transaction is using 15 GETP as opposed to 10 one month ago ?
Maybe—what if it executes 20 million times/daily and can you “normalize dynamic statements?
DBAs struggle to identify, tune & minimize elapsed time, CPU and Getpages.
5 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
A Better Outcome
Monitor trends, identify potential problems before they occur.
Manually determine, set and adjust thresholds for monitoring applications.
Automatically determine what is “normal.”
Less time needed:
– Reviewing false or short-term “spike” alerts / event notifications (as opposed to sustained deviations)
– Defining/maintaining thresholds
Proactively monitor application performance or rely on user complaints.
6 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Application monitoring
Performance trend
Threshold monitoring and
alert management
Visualizehotspots
The Solution: CA Performance Analytics for DB2 for z/OS (Pre-Release)Visualize changes in DB2 application performance.
7 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Need to Use IDAA to Improve Application Performance
Impact on DB2/Customer– IBM® Optim Data Studio is difficult to use to administer and manage
IDAA.
– IBM Optim Data Studio is not on the mainframe.
Solution– Use CA RC/Query® to drastically simplify management of your objects
on the DB2 Analytics Accelerator.
Easier Management Through a Familiar Mainframe Interface
8 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Need to Use IDAA to Improve Application PerformanceEasier Management Through a Familiar Mainframe Interface
IDAA Table level functions are available to
Define, Alter, Remove, Load, etc.
Familiar Interface
RC/Q Accelerator Table list report provides table level
admin of your IDAA
Load DB2 Table to IDAA RC/Q ALOAD CMND Load range of
partitions or entire Table
Uses IDAA Loader utility
Ability to Start, Stop, Display and PING
Accelerator
9 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
CA RC/Query® for DB2 for z/OS
Easily visualize:– list of accelerators defined to a DB2 subsystem
– list of accelerated tables
IDAA line commands help manage DB2 Analytics Accelerator:– Accelerate/decelerate table(s).
– Enable/disable acceleration for table(s).
– Load data to table(s).
– Start/stop accelerator.
– Visualize distribution/organization keys.
– Confirm whether a accelerated table column has been accelerated/not.
Easier Management Through a Familiar Mainframe Interface
10 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Application Development (New or Legacy Replacement)
Impact on DB2 / Customer– Developers need Test and QA environments
Solution– Use CA RC/Migrator to create test and QA environments.
– Use CA RC/Update to make changes to test objects during the development process.
– Use CA RC/Compare to sync test changes to QA.
– Use CA RC/Compare to sync QA changes to PRD.
CA RC/Migrator®, CA RC/Compare®, CA RC/Update®
11 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Application Development (New or Legacy Replacement)CA RC/Migrator®
Production
Test
Copy Group: TST, QA
Global Change:PRD%=TST%
Global Change:PRD%=QA%
PRD%
QA
QA%TST%
12 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Application Development (New or Legacy Replacement)CA RC/Update®
TST_IX1
TST_TBL1COL1
TST_TS1(Segmented)
Test
TST_TS1(PBG UTS)
TST_IX1
TST_VIEW1 TST_IX2
TST_TBL1COL1COL2
Test
13 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Application Development (New or Legacy Replacement)CA RC/Compare®
Test TST_TS1(PBG UTS)
TST_IX1
TST_VIEW1 TST_IX2
TST_TBL1COL1COL2
QAQA_TS1(PBG UTS)
QA_IX1
QA_VIEW1 QA_IX2
QA_TBL1COL1COL2
QA
QA_IX1
QA_TBL1COL1
QA_TS1(Segmented)
14 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
QAQA_TS1(PBG UTS)
QA_IX1
QA_VIEW1 QA_IX2
QA_TBL1COL1COL2
Application Development (New or Legacy Replacement)CA RC/Compare®
ProductionPRD_TS1(PBG UTS)
PRD_IX1
PRD_VIEW1 PRD_IX2
PRD_TBL1COL1COL2
Production
PRD_IX1
PRD_TBL1COL1
PRD_TS1(Segmented)
15 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Corporate Merger or Acquisition
Impact on DB2 / Customer– Need to consolidate DB2 environments
Solution– Use CA RC/Merger to move objects from the old DB2 environment to
the new DB2 environment without the need to copy the VSAM datasets.
– Real Life scenario took 11.5 hrs instead of the estimated 36+hrs with traditional tools and processes.
CA RC/Merger®
16 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Corporate Merger or AcquisitionCA RC/Merger®: 2 DB2 Subsystems
DB2_A
OBJ1%
DB2_B
OBJ2%
DB2_BOBJ2DASD
DB2_AOBJ1DASD
17 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Corporate Merger or AcquisitionCA RC/Merger® Step 1: Create DB2_A objects on DB2_B
DB2_A
OBJ1%
DB2_AOBJ1DASD
DB2_BOBJ2DASD
DB2_BOBJ1DASD
DB2_B
OBJ1% OBJ2%
18 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Corporate Merger or AcquisitionCA RC/Merger® Step 2:
Delete DB2_B OBJ1 VSAM datasetsRename DB2_A OBJ1 VSAM datasets
Update VSAM header pages
DB2_A
OBJ1%
DB2_B
OBJ1%
DB2_ADB2_BOBJ1DASD
DB2_BOBJ2DASD
OBJ2%
DB2_BOBJ1DASD
19 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Corporate Merger or AcquisitionCA RC/Merger® Step 3:
DB2_B
OBJ1%
DB2_ADB2_BOBJ1DASD
DB2_BOBJ2DASD
OBJ2%
20 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Participate in CA’s DB2/IMS Management Community!!communities.ca.com/community/ca-database-management-for-db2-and-ims
21 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Recommended Sessions
SESSION # TITLE DATE/TIME
MFX04E What's New with DB2 Solutions from CA Technologies—Administration, Performance, Recovery & Analytics
1/17/2015 at 11:00 amLocation: Breakers H
MFX06S CA's Strategy and Vision for Mainframe Data Management and Analytics
1/18/2015 at 1:00 pmLocation: Breakers I
MFX07E Place your vote: Addressing newer Mainframe Database Management Needs - Data Governance, Analytics and Autonomics, Big Data and others
1/17/2015 at 9:00 pmLocation: Breakers H
MFX14E Getting the Most out of Your DB2 Investment 1/17/2015 at 10:00 amLocation: Breakers H
MFT05S Big Iron + Big Data = BIG DEAL! Unlock The Power of Your Mainframe Data
1/18/2015 at 2:00 pmLocation: Mainframe Theater
MFX15S Predicting When Your Applications Will Go Off the Rails! Managing DB2 Application Performance using Analytics
1/18/2015 at 4:30 pmLocation: Breakers I
MFT12TIt's Not a Dream—Conquer Chaos for Your DB2® for z/OS® Optimization Nightmares
1/18/2015 at 3:00 pmLocation: Tech Talk 6
22 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Must See Demos
Maximize Your DB2 Tools
Investment
DB2 Tools
Mainframe Area
Station: MNFSE003
Unleash the Power of
Mainframe Data
vStorm Connect Data Streaming for Big Data
Mainframe Area
Station: MNFSE001
Maximize Your Mainframe
Database Value
CA IDMS / CA Datacom
Mainframe Area
Station: MNFSE002
Performance Analytics for DB2
DB2 Analytics
Mainframe Area
Station: MNFSE004
23 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Follow On Conversations At…
Smart Bar
DB2 Tools and Performance Analytics
Mainframe Area on Expo Floor
Tech Talks
DB2 Tools and Performance Analytics
Mainframe Area on Expo Floor
24 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
For Informational Purposes Only
© 2015 CA. All rights reserved. All trademarks referenced herein belong to their respective companies. The presentation provided at CA World 2015 is intended for information purposes only and does not form any type of warranty. Some of the specific slides with customer references relate to customer's specific use and experience of CA products and solutions so actual results may vary.
Certain information in this presentation may outline CA’s general product direction. This presentation shall not serve to (i) affect the rights and/or obligations of CA or its licensees under any existing or future license agreement or services agreement relating to any CA software product; or (ii) amend any product documentation or specifications for any CA software product. This presentation is based on current information and resource allocations as of November 18, 2015 and is subject to change or withdrawal by CA at any time without notice. The development, release and timing of any features or functionality described in this presentation remain at CA’s sole discretion.
Notwithstanding anything in this presentation to the contrary, upon the general availability of any future CA product release referenced in this presentation, CA may make such release available to new licensees in the form of a regularly scheduled major product release. Such release may be made available to licensees of the product who are active subscribers to CA maintenance and support, on a when and if-available basis. The information in this presentation is not deemed to be incorporated into any contract.
Terms of this Presentation
25 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
Q & A
26 © 2015 CA. ALL RIGHTS RESERVED.@CAWORLD #CAWORLD
For More Information
To learn more, please visit:
http://cainc.to/Nv2VOe
CA World ’15