Articles & Content

Archives

G09 - How to Survive SQL Shark Week Using CA Detector for DB2 for z/OS and CA Plan Analyzer for DB2 for z/OS

Topic: DB2 for z/OS

Subtopic: 2013



This presentation will demonstrate effective and efficient ways to capture and tranquilize rogue SQL in an ocean of DB2 applications, to prevent it from eating your mainframe alive. We will provide a basic understanding of CA Detector and CA Plan Analyzer concepts and functionality, and show how they can be used in real-world situations. We will identify and isolate an SQL problem using Detector's current activity and exception reporting, and dive into DB2 access paths with Plan Analyzer, finding sunken treasure that help to resolve SQL performance problems. This valuable information can be shared with your applications team to help make your corporate DB2 applications smooth sailing.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.