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.
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.