Knowledge is wealth. Share it!

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

Showing posts with label DB2. Show all posts
Showing posts with label DB2. Show all posts

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"