PerformanceWiki [the blog]

Database System Performance Best Pract=
ices on UNIX, Windows and LinuxThe paper published by IBM and found he=
re

http://www.ibm.com/developerworks/data/bestpractices/systemperformance/?S=
_TACT=3D105AGX11&S_CMP=3DLP.

The key area covered an=
d are at the heart of performance tuning include the following:

=
The first step: configuring for good performanceHardware =
configurationAIX configurationSolaris and HP-UX configura=
tionLinux configurationDB2 Data Partitioning Feature=
Choice of code page and collationPhysical database
designInitial DB2 configuration settingsDB2 autonomics a=
nd automatic parametersExplicit configuration settingsSta=
tistics collectionConsiderations for SAP and other ISV environment=
sThe next step: monitoring system performanceA g=
ood ’starter set’ of DB2 snapshot metricsOther important data to c=
ollectCross-partition monitoring in partitioned database environme=
nts=0A Performance Tuning and TroubleshootingTypes of problems that you might seeDisk bottlenecksCPU bottlenecksMemory bottlenecks’Lazy System’ bot=
tlenecksSystem bottlenecks =E2=80=94 The overall picture=
Localized and system-wide troubleshootingBest practices
.pw.