Job Management Partner 1/Performance Management - Agent Option for Virtual Machine Description, User's Guide and Reference

List of ODBC key fields

Some ODBC key fields are common to all records, while others are specific to individual records. This section presents the ODBC key fields common to all records. With PFM - Manager, ODBC key fields are required in order for you to use SQL statements to access record data stored in the Store database.

The table below lists the ODBC key fields that are common to all records. For details about the ODBC key fields that are specific to each record, see the individual record descriptions.

Table 5-2 List of ODBC key fields common to all records

ODBC key field	ODBC format	Data	Explanation
record-ID_DATE	SQL_INTEGER	Internal	Record key indicating the date when the record was generated
record-ID_DATETIME	SQL_INTEGER	Internal	Combination of record ID_DATE field and record ID_TIME field
record-ID_DEVICEID	SQL_VARCHAR	Internal	Instance name [host name]
record-ID_DRAWER_TYPE	SQL_VARCHAR	Internal	Category. The values are valid: m: Minute H: Hour D: Day W: Week M: Month Y: Year
record-ID_PROD_INST	SQL_VARCHAR	Internal	PFM - Agent instance name
record-ID_PRODID	SQL_VARCHAR	Internal	PFM - Agent product ID
record-ID_RECORD_TYPE	SQL_VARCHAR	Internal	ID indicating a record type (4 bytes)
record-ID_TIME	SQL_INTEGER	Internal	Time at which the record was generated (Greenwich Mean Time)

[Contents][Back][Next]

All Rights Reserved. Copyright (C) 2009, 2010, Hitachi, Ltd.