Knowledge is wealth. Share it!

Knowledge is wealth. Share it! There is no wealth like knowledge, and no poverty like ignorance.

01 September 2014

Please use the below script to find used pages and size of the DB2 tablespaces / containers.

db2 "select TOTAL_EXEC_TIME, NUM_EXECUTIONS, substr (STMT_TEXT, 1,500) \
as statement from table(SNAPSHOT_DYN_SQL('dsv', -1)) as \
snap_dyn_sql order by 1 desc,2 desc"

No comments:

Post a Comment