Hi,

when i type at the DB2-Shell:
db2 get snapshot for all on ds2 | grep -i pref

I get only one result for Prefetch wait time.

But, when i do a SQL-query on admin view:
SELECT SUBSTR(DB_NAME,1,8) AS DB_NAME, AGENT_ID, PREFETCH_WAIT_TIME FROM SYSIBMADM.SNAPAPPL

I get several results! (mostly zero)

does the shell do a sum() here?