Session 8: Fixing Performance Problems Using Performance Analyst for DB2

Go Up to Performance Analyst for IBM DB2 for Linux, Unix and Windows Tutorial

Finding performance problems is one thing, but fixing them is another. Many performance monitors point out a particular problem in a database, but then offer no way to actually correct the situation. Such is not the case with Performance Analyst. Because of its tight integration with DBArtisan, certain problems found in Performance Analyst can be visually corrected by DBArtisan.

If a DB2 tablespace is about to run out of free space, Performance Analyst can issue an alarm that a space shortage exists. Once the space problem has been identified, do the following:

1. On the Space home page toolbar, click the Space button.
2. In the Space Analyst grid, right-click a tablespace, and then select Manage with DBArtisan.

   You will then be taken to DBArtisan’s Tablespace Editor where you can perform corrective actions, such as adding new containers to the tablespace, or resizing the tablespace’s existing container(s)