Temporary Files (iSeries)

This monitor provides an overview of temporary files that have been created in the database since the last IPL of the database server.

The query optimizer may need to create temporary files for some complex queries.

To display information on temporary files, call transaction DB4COCKPIT.

  1. In the navigation frame, choose Performance ® Database Monitor ® Temporary Files.

    The monitor displays the time required to build a temporary file (Total Time (ms)) and indicates why the query optimizer needed to create the temporary file (Reason Code). This information indicates how the query can be rewritten to avoid a temporary file being created in future.

  2. You can access information on the SQL statement that caused the temporary file to be built by clicking the file you are interested in.