在打开合适的监控器开关之后,您可以在同一db2命令窗口使用GET SNAPSHOT命令来收集监控统计信息。
After the proper monitor switches are on, you can use the GET SNAPSHOT command from the same DB2 command window to collect monitoring statistics information.
为了设置SAMPLE数据库自动进行统计信息收集,需要为自动维护开关设置数据库配置参数,如下所示。
To set up the SAMPLE database for automatic statistics collection, set the database configuration parameters for automatic maintenance switches as follows.
在没有分布统计信息的情况下,执行该查询时,动态sql的一个快照返回以下监视器值(假定所需的监视器开关已激活)。
When the query is executed without distribution statistics, a snapshot for dynamic SQL returns the following monitor values (given that the required monitor switches are active).
应用推荐