Snapshot monitoring of federated systems - Overview

You can use the snapshot monitor to capture information about federated data sources and any connected applications at a specific time.

Snapshots are useful for determining the status of a federated system. Taken at regular intervals, snapshots are also useful for observing trends and foreseeing potential problems.

The output of the snapshot monitor is available in the following formats:

In textual form, through the snapshot monitor command-line processor interface.
As the output of table functions. This output is useful for writing queries that limit output.

The snapshots that are particularly useful for federated workloads include:

Dynamic SQL statement snapshot: Provides a snapshot of all dynamic SQL statements currently in the statement cache that includes federated and non-federated statements.
Application snapshot: Provides information about a specific application, including the text of the currently running SQL statement.
Remote databases snapshot: Provides information about a specific federated system database.
All remote databases snapshot: Provides information about each federated system database that is active.
Remote applications snapshot: Provides application-level information for each federated system application that is active.