Articles & Content

Archives

Taking back control of database application performance - a cross organizational look at the tools and techniques available (E11)

Topic: 2011 NA

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2011-5-5 (01:30 PM - 02:30 PM)
SPEAKERS: Patrick Titzler (IBM ), Saghi Amirsoleymani (IBM )

Building data access and managing performance of your mission critical applications can be a challenge, especially for growing workloads. In this session you will also see how to proactively avoid problems by taking advantage of database best practices during the development phase and how tooling facilitates collaboration between DBAs and Developers to build better data access code. We will look at how Static SQL can be used to improve and stabilize performance. You will see how to build efficient data access via Stored Procedures, queries and other DML operations, with a focus on application development.Finally, you will see how DBAs can prevent rogue queries or problemmatic workloads, and also stabilize the performance of applications without impacting application design.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

How to effectively manage performance for existing applications in a minimally invasive way.

How you can help developers build efficient data access code.

Learn how to use tooling effectively during development to collaborate between DBAs and Developers

Learn how to use tools to do Query Tuning

See some of the available tools in a live demo.



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.