Running queries on table spaces with more than n percent relocated rows
Use the performance queries function to view information about and work with tables with no more than n percent relocated rows.
Procedure
-
On the DB2 Administration Menu (ADB2) panel, specify option
3, and press Enter.
The DB2 Performance Queries panel is displayed.
- Locate option 2 - Table spaces with more than n percent relocated rows.
- If necessary, change the value of n.
-
Specify option 2, and press Enter.
The Table Spaces With More Than n Percent Relocated Rows (ADB232) panel is displayed, as shown in the following figure:
Figure 1. Table Spaces With More Than n Percent Relocated Rows (ADB232) panel DB2 Admin ------- DB2X Table Spaces with Relocated Rows > 10 Pct -------------- Command ===> Scroll ===> PAGE The following table spaces have more than 10 percent relocated rows, that is, rows not located in their original page. Consider reorganizing the table spaces or redesigning the programs that update the rows. Commands: O - Reorg UT - Utilities Line commands: S - Select O - Reorg DB TS Near Far Percent S Name Name Part Org Page Org Page Relocated Rows * * * * * * * - -------- -------- ------ ----------- ----------- ----------- ----------- ISTJE2D ISTJE2S 0 196 0 80 245 ******************************* END OF DB2 DATA *******************************The following columns are on this panel:
- S
- Selects a table space when you use the S line command.
- DB Name
- The name of the database.
- TS Name
- The name of the table space.
- Part
- The partition number. If the database is not partitioned, the value is 0.
- Near Org Page
- The number of rows that have been relocated near their original page.
- Far Org Page
- The number of rows that have been relocated far from their original page.
- Percent Relocated
- The percentage of rows that have been relocated.
- Rows
- The number of rows in the table space or partition.
- Optional:
Work with the table spaces by using the primary commands and line commands.
Tip: For table spaces that have more than 10 percent relocated rows, that is, rows that are not located in their original page, reorganize the table spaces or review the pctfree and/or the free page values to leave more space for rows to grow during an update.
The O line command enables you to quickly move to the Batch Job Utility Parameters (ADB2UPA) panel. Entering the O line command is equivalent to entering S, UT, and O commands in succession.