Refresh use of materialized query tables: No materialized query tables are used to evaluate the select-statement during the processing of REFRESH TABLE statement.
Refresh isolation level: The isolation level used to evaluate the select-statement is either:
Number of rows: After successful execution of a REFRESH TABLE statement, the ROW_COUNT statement information item in the SQL Diagnostics Area (or SQLERRD(3) in the SQLCA) will contain the number of rows inserted into the materialized query table.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.