What are "Internal Plan Lock" and "Internal Variation Lock" objects ? Answer Internal Plan Lock(P lock) (Package Cache/ Plan Lock): Any execution of SQL, whether static or dynamic, must be done while holding a 'package lock'. This ensures that no-on...(more)

db2性能监控 为了保证监控尽可能多的sql语句，建议增中DBM配置参数mon_heap_sz get snapshot for dynamic sql on dbname >snap.out number of executions --执行次数，是累加值 worst preparation time(ms) --最差的sql词句准备时间 Total execution time(sec.ms) sql　...(more)

Whoever defined this view should be get fired! It is an insult to db2 users/community for playing such cheap trick!   CREATE VIEW SYSIBMADM.TOP_DYNAMIC_SQL  ( SNAPSHOT_TIMESTAMP, NUM_EXECUTIONS, AVERAGE_EXECUTION_TIME_S, STMT_SORTS, SORTS_P...(more)