Fields added only when data is stored in the Store database

The following table lists the fields that are added only when data is stored in the Store database:

Table 5-7 Fields added only when data is stored in the Store database

PFM - View name
(PFM - Manager name)
DescriptionFormatDeltaSupported versionsData source
Agent Host
(DEVICEID)
Name of host where PFM - RM for Oracle is runningstring (256)NoAllN/A
Agent Instance
(PROD_INST)
Instance name of PFM - RM for Oraclestring (256)NoAllN/A
Agent Type
(PROD_ID)
Product ID of PFM - RM for Oracle (1-byte identifier)charNoAllN/A
Date
(DATE)
Record creation date in (GMT)#1char (3)NoAllN/A
Date and Time
(DATETIME)
Combination of the Date (DATE) and Time (TIME) fieldschar (6)NoAllN/A
Drawer Type
(DRAWER_TYPE)
For a PI record, the data summarization type.
The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.#2
charNoAllN/A
GMT Offset
(GMT_ADJUST)
Difference (in seconds) between Greenwich Mean Time and local timelongNoAllN/A
Time
(TIME)
Record creation time (GMT)#1char (3)NoAllN/A
Legend:
N/A: The field value is specified without processing the performance data acquired from Oracle.
#1
A basic value is set because records of the PI record type are summarized. The following table shows the setting values for each record type.

Table 5-8 Setting value for each record type

TypeSetting value for each record type
Minute0 second of the time when the record was created.
Hour0 minute and 0 second of the time when the record was created.
Day0:00 and 0 second of the day when the record was created.
Week0:00 and 0 second on Monday of the week when the record was created.
Month0:00 and 0 second on the 1st day of the month when the record was created.
Year0:00 and 0 second on January 1st of the year when the record was created.
#2
The following table shows the type displayed in PFM - Web Console reports and the type displayed using the ODBC driver:

Table 5-9 Difference of displayed types made by PFM - Web Console and ODBC driver

TypePFM - Web ConsoleODBC driver
MinuteMinutem
HourHourH
DayDayD
WeekWeekW
MonthMonthM
YearYearY