Job Management Partner 1/Performance Management - Remote Monitor for Platform Description, User's Guide and Reference

Fields that are added only when a record is recorded in the Store database

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

Table 5-8 Fields that are added only when a record is recorded in the Store database

PFM - View name
(PFM - Manager name) Description Format Delta Supported version

Agent Host (DEVICEID) Identifier including the name of the host where PFM - RM for Platform is running string (256) No All

Agent Instance (PROD_INST) Instance name of PFM - RM for Platform string (256) No All

Agent Type (PRODID) Product ID of PFM - RM for Platform, expressed as a 1-byte identifier char No All

Date (DATE) Record creation date, in GMT (Greenwich Mean Time)^{#1, #2} char (3) No All

Date and Time (DATETIME) Combination of the Date (DATE) and Time (TIME) fields^#2 char (6) No All

Drawer Type (DRAWER_TYPE) For a record of the PI record type, the data summarization type.
The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.^#3 char No All

GMT Offset (GMT_ADJUST) Difference (in seconds) between Greenwich Mean Time and local time long No All

Time (TIME) Record creation time in GMT (Greenwich Mean Time)^{#1, #2} char (3) No All

#1

A relative time during summarization is set because data is summarized for records of the PI record type. The following table shows the setting for each record type:

Table 5-9 Setting for each record type

Type Setting for each record type

Minute At the 0 second of the time when the record was created.

Hour At the 0 minute and 0 second of the time when the record was created.

Day At 00:00:00 of the day when the record was created.

Week At 00:00:00 on Monday of the week when the record was created.

Month At 00:00:00 on the first of the month when the record was created.

Year At 00:00:00 on January 1st of the year when the record was created.

#2

When data is displayed in reports and by the ODBC driver, the Date field is displayed in the format YYYYMMDD, the Date and Time field is displayed in the format YYYYMMDD hh:mm:ss, and the Time field is displayed in the format hh:mm:ss.

#3

The following table shows the summary type displayed in PFM - Web Console reports and the type displayed when the ODBC driver is used.

Table 5-10 Differences in summary type depending on the display method

Type PFM - Web Console ODBC driver

Minute Minute m

Hour Hour H

Day Day D

Week Week W

Month Month M

Year Year Y

PFM - View name (PFM - Manager name)	Description	Format	Delta	Supported version
Agent Host (DEVICEID)	Identifier including the name of the host where PFM - RM for Platform is running	string (256)	No	All
Agent Instance (PROD_INST)	Instance name of PFM - RM for Platform	string (256)	No	All
Agent Type (PRODID)	Product ID of PFM - RM for Platform, expressed as a 1-byte identifier	char	No	All
Date (DATE)	Record creation date, in GMT (Greenwich Mean Time)^{#1, #2}	char (3)	No	All
Date and Time (DATETIME)	Combination of the Date (DATE) and Time (TIME) fields^#2	char (6)	No	All
Drawer Type (DRAWER_TYPE)	For a record of the PI record type, the data summarization type. The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.^#3	char	No	All
GMT Offset (GMT_ADJUST)	Difference (in seconds) between Greenwich Mean Time and local time	long	No	All
Time (TIME)	Record creation time in GMT (Greenwich Mean Time)^{#1, #2}	char (3)	No	All

Type	Setting for each record type
Minute	At the 0 second of the time when the record was created.
Hour	At the 0 minute and 0 second of the time when the record was created.
Day	At 00:00:00 of the day when the record was created.
Week	At 00:00:00 on Monday of the week when the record was created.
Month	At 00:00:00 on the first of the month when the record was created.
Year	At 00:00:00 on January 1st of the year when the record was created.

Type	PFM - Web Console	ODBC driver
Minute	Minute	m
Hour	Hour	H
Day	Day	D
Week	Week	W
Month	Month	M
Year	Year	Y

[Contents][Back][Next]

[Trademarks]