snapdyn_sql数据来自表函数SYSPROC.SNAP_GET_DYN_SQL

CREATE VIEW "SYSIBMADM"."SNAPDYN_SQL" ("SNAPSHOT_TIMESTAMP", "NUM_EXECUTIONS", "NUM_COMPILATIONS", "PREP_TIME_WORST", "PREP_TIME_BEST", "INT_ROWS_DELETED", "INT_ROWS_INSERTED", "INT_ROWS_UPDATED", "ROWS_READ", "ROWS_WRITTEN", "STMT_SORTS", "SORT_OVERFLOWS", "TOTAL_SORT_TIME", "POOL_DATA_L_READS", "POOL_DATA_P_READS", "POOL_TEMP_DATA_L_READS", "POOL_TEMP_DATA_P_READS", "POOL_INDEX_L_READS", "POOL_INDEX_P_READS", "POOL_TEMP_INDEX_L_READS", "POOL_TEMP_INDEX_P_READS", "POOL_XDA_L_READS", "POOL_XDA_P_READS", "POOL_TEMP_XDA_L_READS", "POOL_TEMP_XDA_P_READS", "TOTAL_EXEC_TIME", "TOTAL_EXEC_TIME_MS", "TOTAL_USR_CPU_TIME", "TOTAL_USR_CPU_TIME_MS", "TOTAL_SYS_CPU_TIME", "TOTAL_SYS_CPU_TIME_MS", "STMT_TEXT", "DBPARTITIONNUM", "STATS_FABRICATE_TIME", "SYNC_RUNSTATS_TIME", "MEMBER") AS
SELECT snapshot_timestamp,       num_executions,       num_compilations,
       prep_time_worst,       prep_time_best,       int_rows_deleted,
       int_rows_inserted,       int_rows_updated,       rows_read,
       rows_written,       stmt_sorts,       sort_overflows,
       total_sort_time,       pool_data_l_reads,       pool_data_p_reads,
       pool_temp_data_l_reads,       pool_temp_data_p_reads,       pool_index_l_reads,
       pool_index_p_reads,       pool_temp_index_l_reads,       pool_temp_index_p_reads,
       pool_xda_l_reads,       pool_xda_p_reads,       pool_temp_xda_l_reads,
       pool_temp_xda_p_reads,       total_exec_time,       total_exec_time_ms,
       total_usr_cpu_time,       total_usr_cpu_time_ms,       total_sys_cpu_time,
       total_sys_cpu_time_ms,       stmt_text,       dbpartitionnum,
       stats_fabricate_time,       sync_runstats_time,       member
  FROM TABLE(SYSPROC.SNAP_GET_DYN_SQL('')) as t;
复制

DB2 SNAPSHOT MONITOR收集的数据存放在内存中，通过DBM级参数MON_HEAP_SZ设置存储的空间大小
复制

监视活动所需的内存量取决于监视应用程序（捕获快照的应用程序或事件监视器）的数目、设置了哪些开关以及数据库活动的级别。

如果此堆中配置的内存都用尽，且在实例共享内存区域中没有更多的非保留内存，将会发生以下事件中的一件：

• 当第一个应用程序连接至定义了此事件监视器的数据库时，会将一条错误消息写入到管理通知日志。
• 如果使用 SET EVENT MONITOR 语句动态启动的事件监视器失败，那么向您的应用程序返回错误代码。
• 如果一个监视器命令或 API 子例程失败，那么向您的应用程序返回错误代码。
• 如果应用程序需要发送事件监视器记录，但无法从监视器外部堆分配记录，那么该应用程序可能会受阻，直到分配了记录。

。。。