Analyzing DB2 processor usage

Many factors affect the amount of processor resources that DB2 consumes. You can reduce DB2 consumption of the processor resources by:

• Reusing threads
• Using efficient caching of authorizations in all environments to eliminate DB2 authorization checks
• Reducing the amount of overhead processing by suppressing traces, using fixed-length columns, reducing locking, and using more efficient access paths

Use the DB2 System CPU % by Address Space, Overview report (see Figure 77) to monitor the relative processor usage by system address spaces for your DB2 subsystems.

Figure 77. DB2 System CPU % by Address Space, Overview report

The report shows the relative CPU usage for these address spaces:

• DB2 database service (DBM1) address space
• DB2 system services (MSTR) address space
• DB2 distributed data facility (DIST) address space
• IMS Resource Lock Manager (IRLM) address space

[ Top of Page | Previous Page | Next Page | Contents ]