- 论坛徽章:
- 0
|
用SQL语句实现DB2主要指标的监控
The general form of a snapshot function is:
SELECT * FROM TABLE(SNAPSHOT_FUNCTION(database, partition)) AS S;
The SNAPSHOT_FUNCTION is replaced with the appropriate snapshot command, and the DATABASE field contains the name of the database you want the snapshot to be taken against. The partition should be set to -1 to return information for the current partition and -2 for all partitions. If this field is not included or set to null, the command will only work against the current partition. |
|