Description
Part 1
•Chapter 1: DB2 traces: sources of key performance indicators
•Chapter 2: Where is a DB2 transaction spending its time?
•Chapter 3: CPU vs. suspension time
•Chapter 4: Most common reasons for large suspension times
•Chapter 5: SQL / Locking / BP / GBP accounting counters
Chapter 6: Tuning hints and tips as we go along
Part 2
•Chapter 7: Data Collection
•Chapter 8: System Address Space CPU Time
•Chapter 9: EDM Pools
•Chapter 10: Dataset Open/Close
•Chapter 11: Log Activity
•Chapter 12: Lock/Latch
•Chapter 13: DBM1 Virtual Storage and Real Storage
•Chapter 14: Buffer Pools and Group Buffer Pools
•Chapter 15: RDS Sort
•Chapter 16: DDF Activity
Resident Prerequisites
Skills Needed
| Skill Areas | Requested Skill Level |
| English | 4 |
Scale is 1 = None, 2 = Limited, 3 = Average, 4 = Good and 5 = Excellent.
You personally do not have to have all of these skills to be considered a good candidate for this residency. The project leader will match your skills with those of the other nominations to bring together the best team possible.
Documentation Skills Needed
| Skill Areas | Requested Skill Level |
| None | - |
Scale is 1 = None, 2 = Limited, 3 = Average, 4 = Good and 5 = Excellent.
These documentation skills are desirable, but not critical, for acceptance into this residency. The only definite requirements are familiarity with standard text processing and readiness to learn.
This Residency
Profile
Start Date
26 Aug 2013
End Date
13 Sep 2013
Length
6 weeks
Residents needed
4
Residency Location
San Jose CA, USA
Residency Leader
Paolo Bruni