You should review performance objectives during the internal
design of your system.
During the internal design phase, you must:
- Refine your estimated workload against the actual workload.
- Refine disk access estimates against database design. After
internal design, you can define physical data accesses for application-oriented
processes and estimate buffer hit ratios.
- Add the accesses for Db2 work
file database, Db2 log,
program library, and Db2 sorts.
- Consider whether additional processor loads can cause a
significant constraint.
- Refine estimates of processor usage.
- Estimate the internal response time as the sum of processor
time and synchronous I/O time or as asynchronous I/O time, whichever
is larger.
- Prototype your Db2 system.
Before committing resources to writing code, you can create a small
database, update the statistics stored in the Db2 catalog
tables, run SQL statements and examine the results.