How to view I/O statistics in DB2

In Sybase, one can view the I/O 开发者_如何学JAVAstatistics of a query using the following:

set noexec on
set statistics io on

This allows one to see the total logical I/O for a query without actually executing it. Is there an equivalent sort of command for DB2?

The EXPLAIN statement may provide some of what you want (I'm afraid I don't have actual use details), or Visual Explain if you have access to that.

Explain: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0001001.htm