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

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:

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

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

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

Agent Type
(PRODID) Product ID of PFM - Agent (1-byte identifier) char No All --

Date
(DATE) Record creation date (GMT)^#¹^,^#³ char(3) No All --

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

Drawer Type
(DRAWER_TYPE) Data summarization type (for a record of the PI record type).
The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.^#2 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 (GMT)^#1,^#³ char(3) No All --

Legend:

--: Indicates that the field's value is obtained without processing the performance data acquired from SAP system.

#1

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

Type Setting value for each record type

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

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

Day 0:00 and 0 second of the day when the record was created.

Week 0:00 and 0 second on Monday of the week when the record was created.

Month 0:00 and 0 second on the 1st day of the month when the record was created.

Year 0: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:

Type PFM - Web Console ODBC driver

Minute Minute m

Hour Hour H

Day Day D

Week Week W

Month Month M

Year Year Y

#3

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

PFM - View name (PFM - Manager name)	Description	Format	Delta	Supported version	Data source
Agent Host (DEVICEID)	Name of host where PFM - Agent is running	string(256)	No	All	--
Agent Instance (PROD_INST)	Instance name of PFM - Agent	string(256)	No	All	--
Agent Type (PRODID)	Product ID of PFM - Agent (1-byte identifier)	char	No	All	--
Date (DATE)	Record creation date (GMT)^#¹^,^#³	char(3)	No	All	--
Date and Time (DATETIME)	Combination of the Date (DATE) and Time (TIME) fields^#³	char(6)	No	All	--
Drawer Type (DRAWER_TYPE)	Data summarization type (for a record of the PI record type). The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.^#2	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 (GMT)^#1,^#³	char(3)	No	All	--

Type	Setting value for each record type
Minute	0 second of the time when the record was created.
Hour	0 minute and 0 second of the time when the record was created.
Day	0:00 and 0 second of the day when the record was created.
Week	0:00 and 0 second on Monday of the week when the record was created.
Month	0:00 and 0 second on the 1st day of the month when the record was created.
Year	0:00 and 0 second 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]