Edit
Attach
P
rintable
r15 - 2013-06-11 - 20:33:00 - Main.aalaird
You are here:
TWiki
>
Deployment Web
>
DeploymentConfiguringAndTuning
>
ConfiguringAndTuningDB2
<div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/uc.png" alt="uc.png" width="50" height="50" align="right"/> Tuning DB2 %DKGRAY% Authors: [[Main.DavidToczala][DanToczala]] <br> Build basis: CLM 2012, CLM 2011 %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> ---++ Initial assessment |Database tuning is outside of the scope of the Jazz Administrator. Any information provided below is for reference only and should be passed to your database administrator.| When discussing the tuning of DB2, it is important to note the various editions of DB2, such as DB2 Workgroup, DB2 Enterprise, and DB2 for z/OS. Jazz licensing currently supports the use of DB2 Workgroup Edition. DB2 Express is also supported, but it should _not_ be used for anything other than a product demo, pilot project, or functionality review, because it will not scale to support a typical user load. ---++ DB2 for z/OS Most DB2 customers turn on the following monitoring and tracing for their Jazz-supporting DB2 instance on z/OS: | TNO | TYPE | CLASS| DEST | QUAL | IFCID | |01 | STAT | 01,03,04,05, | SMF | NO | | |01 | | 06 | | | | |02 | ACCTG | 01,02,03,07, | SMF | NO | | |02 | | 08 | | | | |04 | MON | 01,02,03,05, | OP1 | NO | | |04 | | 07, 08 | | | | How to interpret the previous table: * For statistics, monitor classes 1, 3, 4, 5, and 6. This shows overall health. * For accounting purposes, monitor classes 1, 2, 3, 7, and 8. This gets into more specifics about what is happening. * For monitoring purposes, monitor classes 1, 2, 3, 5, 7, and 8. When working with DB2 you should be doing a RUNSTATS [multi-table, multi-index] whenever you make changes to the DB2 database. The database administrator should complete this action on a regular basis to ensure that DB2 performs efficiently. If this doesnt work, you might want to increase MAX_R_BLOCK in the z/OS parameters. | *Note:* Thorough DB2 administrators will want to create indexes based on the results from some of the monitoring and the RUNSTATS commands. They can do this, but make sure that you measure database performance both before and after doing this, so you can determine the impact on performance. | ---++ DB2 Enterprise Edition <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/todo16.png" alt="todo16.png" width="16" height="16"/> Need real tuning examples here. ---++ DB2 Workgroup Edition <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/todo16.png" alt="todo16.png" width="16" height="16"/> Need real tuning examples here. ---+++++!! Related topics: [[DeploymentTroubleshooting][Deployment troubleshooting]], [[DeploymentMonitoring][Deployment monitoring]] ---+++++!! External links: ---++++++ System requirements * <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/constantchange16.png" alt="constantchange16.png" width="16" height="16"/> [[CLMSystemRequirements][Rational CLM 2013 (Release in process)]] * <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/uc16.png" alt="uc16.png" width="16" height="16"/> [[CLMSystemRequirements403][Rational CLM 4.0.3]] * [[https://jazz.net/library/article/1109][Rational CLM 4.0.1 and 4.0.2]] * [[https://jazz.net/library/article/811][Rational CLM 4.0]] * [[https://jazz.net/library/article/632][Rational CLM 3.0.1.x]] * Including: Rational Team Concert, Rational Quality Manager, Rational Requirements Composer, Rational DOORS Next Generation, and Rational Reporting for Development Intelligence ---+++++!! Additional contributors: None ---+++++!! Questions and comments: %COMMENT{type="below" target="TuningDB2Comments" button="Submit"}% %INCLUDE{"TuningDB2Comments"}% <sticky></div></sticky>
Edit
|
Attach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
:
r18
<
r17
<
r16
<
r15
<
r14
|
More topic actions...
Deployment
Deployment web
Planning and design
Installing and upgrading
Migrating and evolving
Integrating
Administering
Monitoring
Troubleshooting
Community information and contribution guidelines
Create new topic
Topic list
Search
Advanced search
Notify
RSS
Atom
Changes
Statistics
Web preferences
NOTE: Please use the Sandbox web for testing
Status icon key:
To do
Under construction
New
Updated
Constant change
None - stable page
Smaller versions of status icons for inline text:
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more
here
.