Client Case Study.....2

Client Case Study.....2

• Using Three Pools, DB2 Version 3
  • BP0 6000 Buffers Catalog, Directory, Tablespaces
  • BP1 8000 Buffers Indexes
  • BP2 6000 Buffers Sort/Work DSNDB07
  • Total of 20,000 Buffers.....80 Megabytes
• Average Transaction Elapsed Time (Class 2)
  • .29 Seconds
  • Transaction Spikes to .48 Seconds

Previous slide

Next slide

Back to the first slide

View Graphic Version

The transaction elapsed time is rather high, and the spikes indicate a sporadic performance problem. This will ultimately prove to be mostly I/O related.