Session 3: Identifying Storage Structure Problems

From DBArtisan
Jump to: navigation, search

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

Space Analyst can help you quickly find storage structure problems that threaten the availability of your databases.

Pinpointing 'out of space' Problems

You can quickly tell if your transaction logs are about to run out of free space by following these steps:

  1. Open Space Analyst.
  2. View the Database and Log Overview sections on the Storage Overview tab.
  3. Examine the free and used space metrics in the pie chart. If the transaction log is nearing the end of free space, then action should be taken to prevent a log full error.

You can also obtain graphical views of tablespaces and pertinent storage property information by viewing the Tablespaces tab of Space Analyst. You can visually get a handle on the amount of used and free space of your tablespaces and quickly view critical storage property facts such as the number of containers for each tablespace, the space allocated for each container, the usage of tablespace space on each partition in a multi-partition database.

All the graphs can be toggled to grids by using the right mouse menu option of 'Toggle Display'. When in grid mode, very detailed information is available concerning the selected tablespace.

Note: You can perform further corrective actions on a tablespace, by opening it in the tablespace editor by using either the right mouse menu or the Command toolbar button (the yellow arrow).

Using Analysis Reports

You can run HTML-formatted reports that pinpoint all major storage-related problems for a particular database and the objects that are contained within it. To produce an Analysis Report, follow these steps:

  1. On the Space Analyst toolbar, select Analysis Report.
  2. If you want to change the location and report title of the report, edit the predefined entries for the Report File Name and Report Title.
  3. Select the types of space problems you would like identified on the report by using the Category list.
  4. Click Execute.
    Space Analyst creates a frame-based Analysis report for the database you indicated.

Proceed to Session 4: Pinpointing SQL server Performance Inefficiencies