Deployment Web > DeploymentConfiguringAndTuning > ConfiguringAndTuningDB2
Initial Assessment
| Database Tuning is outside of the scope of the Jazz Administrator. Any information contained below is for reference only and should be passed on to your D.B.A. |
When discussing the tuning of DB2, it is important to be aware of the differences between the various types of DB2. There is DB2 Workgroup, DB2 Enterprise, and DB2 for z/OS. Jazz licensing currently provides an entitlement for the use of the DB2 Workgroup edition.
DB2 Express is also supported, but it should NEVER be used for anything other than a product demo, pilot project, or functionality review. It will not scale to support a typical user load.
DB2 for z/OS
Most DB2 customers will turn on the following monitoring and tracing for their Jazz supporting DB2 instance on zOS:
| 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 |
What does all of this mean?
- 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 any changes to the DB2 database. It should then be done by the database administrator on a regular basis, to make sure that DB2 performs efficiently.
If this doesn’t work, you might want to increase MAX_R_BLOCK in the zOS parameters.
| Note: A good DB2 Administrator 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 it's impact on your performance. |
DB2 Enterprise
Need real tuning examples here
DB2 Workgroup
Need real tuning examples here
Related topics: Deployment troubleshooting, Deployment monitoring
External links:
System requirements
-
Rational CLM 2013 (Release in Process) -
Rational CLM 4.0.3
- Rational CLM 4.0.1 and 4.0.2
- Rational CLM 4.0
- Rational CLM 3.0.1.x
- Including: Rational Team Concert, Rational Quality Manager, Rational Requirements Composer, Rational DOORS Next Generation and Rational Reporting for Developer Intelligence
-
Additional contributors: None
Questions and comments:
Warning: Can't find topic Deployment.TuningDB2Comments
-
Deployment web
-
Planning and design
- Installing and upgrading
- Migrating and evolving
- Integrating
- Administering
- Monitoring
- Troubleshooting
Community information and contribution guidelines
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.