15.4.4 Specifying common key fields

The PFM - Agent or PFM - RM store database contains records with keys. You must specify at least one ODBC key field for a query.

The following table lists and describes the ODBC key fields that are common among PFM - Agents or PFM - RM.

Table 15‒4: Common ODBC key fields
Common ODBC key field	Description
`record-id_DATE`	The record key that indicates the record creation date
`record-id_DATETIME`	Combination of `record-id_DATE` and `record-id_TIME` fields
`record-id_DEVICEID`	For an Agent which starts an instance: `instance-name` [`host-name`] For an Agent which does not start an instance: `host-name`
`record-id_DRAWER_TYPE`	Classification. Valid values are as follows: `m`: minute `H`: hour `D`: date `W`: week `M`: month `Y`: year
`record-id_PROD_INST`	Name of monitored system
`record-id_PRODID`	Product identifier
`record-id_RECORD_TYPE`	The 4-byte identifier that indicates the record type
`record-id_TIME`	Record creation time (GMT)

Note:: For record-id, enter the record ID of each PFM - Agent or PFM - RM. For details on record IDs of each PFM - Agent or PFM - RM, see the chapters that describe records (record list) in the PFM - Agent or PFM - RM manuals.

Depending on the PFM - Agent or PFM - RM records, you may also be able to specify key fields other than common ODBC key fields. For details on available ODBC key fields, see the chapters that describe records (ODBC key field list) in the PFM - Agent or PFM - RM manuals.

To Page Top