Databases Reference
In-Depth Information
attributes metricObjectName, metricValue:
We don't want to list every attribute of the
object metriccurrent; but only two.
where name = 'GD_IO_RQ_W_LG':
This specifies that we want to filter the output and
show only where the name of the metric (one of the attributes of metriccurrent) is
GD_IO_RQ_W_LG, which is the number of large I/O written to the griddisks.
metricObjectName like 'DWPRECO.*':
There are several griddisks. We are interested in
the griddisks used in the DWPRECO diskgroup, so we used this filtering condition. Unlike
SQL, in CellCLI the wildcard character is not “%.” CellCLI follows regular expression syntax,
and the wildcard character is an asterisk (“*”).
In the next activity we checked the history of the metric by issuing the command list metrichistory. We followed
the same type of command structure: Verb:Object:Filter. However, we introduced a new type of filter:
collectionTime > '2012-09-08T00:00:00-04:00'
This is a timestamp filter. In CellCLI you specify the timestamp as YYYY-MM-DDThh24:mi:ss-<GMT Offset>.
The GMT Offset specifies many hours behind the local time is with respect to Greenwich mean time. In this case,
it's four hours behind.