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

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

The table below shows the fields that are added only when data is being recorded in the Store database.

Table 5-7 Fields that are added only when data is being recorded in the Store database

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

Agent Host
(DEVICEID) Name of the host on which PFM - Agent is running string (256) No All

Agent Instance
(PROD_INST) PFM - Agent instance name string (256) No All

Agent Type
(PRODID) PFM - Agent product ID, expressed as a 1-byte ID char No All

Date
(DATE) Date on which the record was created. Greenwich Mean Time^{#1, #2} char (3) No All

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

Drawer Type
(DRAWER_TYPE) For a record of the PI record type, this is the category in which data is summarized. The category display differs depending on whether the record is displayed as a report on PFM - Web Console, or whether it is displayed using an ODBC driver.^#3 char No All

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

Time
(TIME) Time at which the record was created. Greenwich Mean Time^{#1, #2} char (3) No All

#1

Since a record of the PI record type summarizes data, the time used as the basis for summarizing data is specified. The following table indicates the setting for each record category.

Table 5-8 Setting for each record category

Category Setting for each record category

Minute The 0^th second of the time at which the record was created

Hour The 0^th minute and 0^th second of the time at which the record was created

Day The 0^th hour, 0^th minute, and 0^th second of the time at which the record was created

Week The 0^th hour, 0^th minute, and 0^th second of the Monday of the week in which the record was created

Month The 0^th hour, 0^th minute, and 0^th second of the first day of the month in which the record was created

Year The 0^th hour, 0^th minute, and 0^th second of January 1st of the year in which the record was created

#2

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

#3

The table below shows the difference in data summary category between a report displayed on PFM - Web Console and data displayed using the ODBC driver.

Table 5-9 Difference in data summary category depending on the display method

Category 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)	Explanation	Format	Delta	Supported version
Agent Host (DEVICEID)	Name of the host on which PFM - Agent is running	string (256)	No	All
Agent Instance (PROD_INST)	PFM - Agent instance name	string (256)	No	All
Agent Type (PRODID)	PFM - Agent product ID, expressed as a 1-byte ID	char	No	All
Date (DATE)	Date on which the record was created. Greenwich Mean Time^{#1, #2}	char (3)	No	All
Date and Time (DATETIME)	Combination of Date (DATE) field and Time (TIME) field^#2	char (6)	No	All
Drawer Type (DRAWER_TYPE)	For a record of the PI record type, this is the category in which data is summarized. The category display differs depending on whether the record is displayed as a report on PFM - Web Console, or whether it is displayed using an ODBC driver.^#3	char	No	All
GMT Offset (GMT_ADJUST)	Difference between Greenwich Mean Time and the local time, in seconds	long	No	All
Time (TIME)	Time at which the record was created. Greenwich Mean Time^{#1, #2}	char (3)	No	All

Category	Setting for each record category
Minute	The 0^th second of the time at which the record was created
Hour	The 0^th minute and 0^th second of the time at which the record was created
Day	The 0^th hour, 0^th minute, and 0^th second of the time at which the record was created
Week	The 0^th hour, 0^th minute, and 0^th second of the Monday of the week in which the record was created
Month	The 0^th hour, 0^th minute, and 0^th second of the first day of the month in which the record was created
Year	The 0^th hour, 0^th minute, and 0^th second of January 1st of the year in which the record was created

Category	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]