9.7.3.8 DESCRIBE METRICHISTORY

Purpose

The DESCRIBE METRICHISTORY command displays a list of attributes for the METRICHISTORY object type.

Syntax

DESCRIBE METRICHISTORY

Usage Notes

Table 9-9 lists the attributes for the DESCRIBE METRICHISTORY command.

Table 9-9 DESCRIBE METRICHISTORY Attributes

Attribute	Description
alertState	Indicator of the alert state. Values are normal, warning, or critical.
collectionTime	Time stamp when the metric value was collected.
memory	The metrics in Management Server memory. This attribute can be used instead of the collectionTime attribute when the collection time is less than an hour.
metricObjectName	Name of the object, such as database server disk being measured.
metricType	Specification for how the statistic was created or defined.
metricValue	Value of the metric when it was collected.
metricValueAvg	Average value of the metric.
metricValueMax	Maximum value of the metric.
metricValueMin	Minimum value of the metric.
name	Unique name of the current metric.
objectType	Options are DBSERVER, DBSERVER_FILESYSTEM, and IBPORT
over	Specification for amount of time in minutes for the aggregation. This attribute works in conjunction with the max, min and avg keywords.

Example 9-44 Describing the METRICHISTORY Object

This example shows the DESCRIBE command with the METRICHISTORY object.

DBMCLI> DESCRIBE METRICHISTORY

         name
         alertState
         collectionTime
         memory
         metricObjectName
         metricType
         metricValue
         metricValueAvg
         metricValueMax
         metricValueMin
         objectType
         over