Table Scans (iSeries)

This monitor provides an overview of table scan activity. It lists the tables against which table scans have been performed since the last IPL of the database server.

To display information on table scan activity, call transaction DB4COCKPIT.

  1. In the navigation frame, choose Performance ® Database Monitor ® Table Scans.
  2. To display detailed information, click the table you are interested in.

The window that appears displays information on the SQL statement that caused the table scan. The query optimizer indicates why it chose to perform a table scan (Reason Code) and may advise you to create an index to improve performance.

See also:

Table Scan Access (iSeries)