Articles & Content

Archives

Put a Smile on Your DBA's Face - Performance for the Developer (and You Know It All DBA's) (F06)

Topic: DB2 for z/OS

Subtopic: 2007



DATE: 2007-5-8 (10:40 AM - 11:40 AM)
SPEAKERS: Rob Crane II (FedEx Freight System), Marc Costa (FedEx Freight System)

Dual Presenters (Marc Costa & Rob Crane) Who is responsible for performance? No, not the wizard behind the curtain. Is it the application developers? How about the DBAís? Maybe both? Hopefully the answer is not "What is performance?". In this presentation we will explore simple things that most shops have probably experienced or are currently experiencing with performance. We will discuss easy ways to spot performance issues in development before the become production nightmares. We will also look at ways to efficiently ask common questions of the database (does this row exist, does this column add filtering to the index, etc.). We will cover clustering, indexing and the importance of the 3 Rís (runstats, reorg, rebind) when analyzing performance issues. Come away with an understanding of performance pitfalls and how to avoid them at your shop.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

My visual explain says I am using an index. Get off my case. Did you check the cardinality of that index? Visual Explains shows I am only joining two tables together, it canít take that long? Whatís Stats advisor?

Is multiple index access similar to multiple personality disorder? Who is this Cartesian guy? Should I worry about him? I used LIKE because the user does not know what they want, why should I be concerned with re-optimization?

My drain is stuck, got any drano? Commit logic and impacts to online schema evolution, online reorg, cursors, DRDA remote connections and database commands

Bueller..Runstats..Bueller..Reorg..Bueller..Rebind..Anyone? Statistics rule opthints drool. NPGTHSH vs. VOLIATILE table, is there a difference?

Clustering concepts and impacts on your SQL Performance. Why clustering matters; sequential access, join sequences, conversion efforts. What caused sequential prefetch to change to list prefetch? What is prefetch anyway?



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.