E.3 List of remote agent and group agent properties

The following table lists the properties for remote agent and group agent of PFM - RM for Microsoft SQL Server.

Table E‒3: List of remote agent and group agent properties
Folder name		Property name	Description	Remote agent	Group agent
--		`Data Model Version`	Displays the version of the data model.	N	N
`Remote Monitoring`		--	Stores the properties of remote agent and group agent.	N	N
		`Agent Type`	Displays the agent type. Remote agent: Remote Agent Group agent: Group Agent	N	N
		`RMName`	Displays the service ID of PFM - RM for Microsoft SQL Server.	N	N
		`Target Name`	Displays the monitoring target name.	N	--
		`Target Host`	Displays the monitoring target host name.	N	--
		`Group Name`	Displays the group name.	--	N
		`Primary Host`	Displays the primary host name.	--	N
		`Grouping Targets`	Displays the list of monitoring target name for a grouping target (in the listbox).	--	Y
`Detail Records`		--	Stores the properties of a record of PD record type. The record ID of the collected record is shown in bold type.	N	N
`Detail Records`	`record-ID`^#1	--	Stores the properties of a record.	N	N
		`Description`	Displays a description of the record.	N	N
		`Log`^#2	Display whether the record is saved or not. The record is saved when this value is Yes. Not saved when No. The record is saved to the database when this value is Yes and the value of Collection Interval is more than 0.	Y	Y^#3
		`Monitoring`(`ITSLM`)	Displays Yes or No to indicate the JP1/SLM - Manager setting for specifying whether to send records to JP1/SLM - Manager. This property cannot be changed.	N	N
		`Log`(`ITSLM`)^#2	Displays Yes or No to indicate whether to save the records to the Store database of PFM - RM for Microsoft SQL Server from JP1/SLM - Manager. Records are saved to the database when this value is Yes and the value of Collection Interval is more than 0. This property cannot be changed.	N	N
		`Collection Interval`	Specifies the data collection interval. The value is in seconds, and can be from 0 to 2,147,483,647. When zero is specified, no data is collected.	N^#4	N^#4
		`Collection Offset`	Specifies the offset value to apply before the first collection cycle. The value is in seconds, and can be from 0 to 32,767, but must be less than the value specified in Collection Interval. The time at which the collected data is recorded matches the collection interval time, regardless of the offset value.	N^#4	N^#4
		`LOGIF`	Specifies conditions for saving the record to the database. Only records that satisfy the conditions are saved. This property shows the conditional expression (character string) specified in the LOGIF Expression Editor window, which opens when the user clicks LOGIF in the bottom frame of the Properties pane in the PFM - Web Console's Services page.	N^#4	N^#4
		`Realtime Report Data Collection Mode`	Specifies the display mode of the real-time report. Reschedule: Reschedule mode is used. Temporary Log: Temporary save mode is used. Note that temporary save mode (Temporary Log) must be specified for records whose Over 10 Sec Collection Time value is Yes.	Y	Y
		`Over 10 Sec Collection Time`	This property is only displayed if collection of historical data takes precedence over the display processing of real-time reports (if the functionality that prioritizes the collection of historical data is enabled).^#5 Whether record collection might require 10 seconds or more is indicated by Yes or No. Yes: Might require 10 seconds or more. No: Does not require 10 seconds. The value of this property cannot be changed.	N	N
`Interval Records`		--	Stores the properties of a record of PI record type. The record ID of the collected record is shown in bold type.	N	N
`Interval Records`	`record-ID`^#1	--	Stores the properties of a record.	N	N
		`Description`	Displays a description of the record.	N	N
		`Log`^#2	Display whether the record is saved or not. The record is saved when this value is Yes. Not saved when No. The record is saved to the database when this value is Yes and the value of Collection Interval is more than 0.	Y	Y^#3
		`Log`(`ITSLM`)^#2	Displays Yes or No to indicate whether to save the records to the Store database of PFM - RM for Microsoft SQL Server from JP1/SLM - Manager. Records are saved to the database when this value is Yes and the value of Collection Interval is more than 0. This property cannot be changed.	N	N
		`Collection Interval`	Specifies the data collection interval. The value is in seconds, and can be from 0 to 2,147,483,647. When zero is specified, no data is collected.	N^#4	N^#4
		`Collection Offset`	Specifies the offset value to apply before the first collection cycle. The value is in seconds, and can be from 0 to 32,767, but must be less than the value specified in Collection Interval. The time at which the collected data is recorded matches the collection interval time, regardless of the offset value.	N^#4	N^#4
		`LOGIF`	Specifies conditions for saving the record to the database. Only records that satisfy the conditions are saved. This property shows the conditional expression (character string) specified in the LOGIF Expression Editor window	N^#4	N^#4
		`Realtime Report Data Collection Mode`	Specifies the display mode of the real-time report. Reschedule: Reschedule mode is used. Temporary Log: Temporary save mode is used. Note that temporary save mode (Temporary Log) must be specified for records whose Over 10 Sec Collection Time value is Yes.	Y	Y
		`Over 10 Sec Collection Time`	This property is only displayed if collection of historical data takes precedence over the display processing of real-time reports (if the functionality that prioritizes the collection of historical data is enabled).^#5 Whether record collection might require 10 seconds or more is indicated by Yes or No. Yes: Might require 10 seconds or more. No: Does not require 10 seconds. The value of this property cannot be changed.	N	N
`Log Records`		--	Contains the properties for records of the PL record type. PFM - RM for Microsoft SQL Server does not use this property.	N	N
`Remote Monitor Configuration`		--	Stores the configuration properties unique to the monitoring target.	N	--
`Remote Monitor Configuration`	`Target`	--	Displays the overview of the remote agent service.	N	--
		`SQL_INSTANCE`	Displays the instance name of the monitored Microsoft SQL Server.	Y	--
		`SQL_USER`	User name for the SQL Server authentication.	Y	--
		`DRIVER_NAME`	Displays the driver name used to communicate with the monitored Microsoft SQL Server.	N	--
		`TIMEOUT`	Displays the timeout value (in seconds) for queries to the database, which was specified by using the `jpcconf target setup` command. The default value is 60. To change this property, specify from 1 to 3600. This property can be changed.	Y	--
		`LOGIN_TIMEOUT`	Displays the timeout value (in seconds) for connecting to the database, which was specified by using the `jpcconf target setup` command. The default value is 20. To change this property, specify from 1 to 3600.This property can be changed.	Y	--
		`DB_FREE_PERC_OPTION`	Specifies the operation to be performed if the value of the Free % field and the Data Unallocate % field of the Database Space Detail (PD_DS) record is negative. This property can be changed.	Y	--
		`DB_FREE_PERC_NUMBER`	Specifies a value to replace with the value of the Free % field and the Data Unallocate % field of the Database Space Detail (PD_DS) record if the value is negative. This property is valid if Y is specified for the `DB_FREE_PERC_OPTION` property. This property can be changed.	Y	--
		`LIMIT_PD_LD_NUMBER`	The maximum number of collection records for the PD_LD records. This property can be changed.^#4	Y	--

Legend:

Y: Displayed and updatable

N: Displayed but not updatable

--: Not displayed

#1

Displays the record ID excluding the database ID as the folder name. For details about the record ID for each record, see 5. Records

#2

If the value of either property is Yes, the record is saved in the Store database.

#3

PFM - RM for Microsoft SQL Server associates only one monitoring target with one instance environment. As a result, the use of group agent is disabled. When you change the value of this property, do not change it from the group agent property. Change the value from the remote agent property.

#4

Displays the value you set up PFM - RM for Microsoft SQL Server.

#5

For details, see the chapter on troubleshooting in the JP1/Performance Management User's Guide.

To Page Top