E.2 List of Agent Collector service properties
The following table lists the properties for the Agent Collector service of PFM - Agent for Microsoft SQL Server.
Folder name |
Property name |
Description |
|
---|---|---|---|
-- |
First Registration Date |
Displays the date and time on which the service was first recognized by PFM - Manager. |
|
Last Registration Date |
Displays the date and time on which the service was last recognized by PFM - Manager. |
||
Data Model Version |
Displays the version of the data model. |
||
General |
-- |
Stores information such as the host name and directories. The properties in this folder cannot be changed. |
|
Directory |
Displays the name of the current directory where the service runs. |
||
Host Name |
Displays the name of the physical host on which the service runs. |
||
Process ID |
Displays the process ID of the service. |
||
Physical Address |
Displays the IP address and port number of the host on which the service runs when IPv6 communication is disabled. |
||
Physical Address(IPv4) |
Displays the IP address (IPv4) of the host on which the service runs when IPv6 communication is enabled. |
||
Physical Address(IPv6) |
Displays the IP address (IPv6) of the host on which the service runs when IPv6 communication is enabled. |
||
Port Number |
Displays the port number on which the service runs when IPv6 communication is enabled. |
||
User Name |
Displays the name of the user who executed the service process. |
||
Time Zone |
Displays the time zone in which the service is used. |
||
System |
-- |
Stores information about the OS under which the service runs. The properties in this folder cannot be changed. |
|
CPU Type |
Displays the CPU type. |
||
Hardware ID |
Displays the hardware ID. |
||
OS Type |
Displays the type of OS. |
||
OS Name |
Displays the name of the OS. |
||
OS Version |
Displays the version of the OS. |
||
Network Services |
-- |
Stores information about the common library for Performance Management communication. The properties in this folder cannot be changed. |
|
Build Date |
Displays the date on which the Agent Collector service was created. |
||
INI File |
Displays the name of the directory containing the jpcns.ini file. |
||
Network Services |
Service |
-- |
Stores information about the service. The properties in this folder cannot be changed. |
Description |
Displays the host name in the following format: instance-name_host-name |
||
Local Service Name |
Displays the service ID. |
||
Remote Service Name |
Displays the service ID of the Agent Store service to which the Agent Collector service connects. |
||
AH Service Name |
Display the service ID of the connection target Correlator service. |
||
JP1 Event Configurations |
-- |
Specify the condition under which JP1 event is issued. |
|
Each service |
The user selects Yes or No from a list (Agent Collector service, Agent Store service, Action Handler service, and Status Server service) to specify whether each service issues JP1 system event. |
||
JP1 Event Send Host |
Specify the connection target JP1/Base event server. Note that you can specify the event server on the same logical or physical host that the Action Handler service is running. The value you specify must consist of alphanumeric characters, ".", and "-", and must not exceed 255 bytes. If you exceed 255 bytes, the value you specify is discarded. If you exceed 255 bytes or do not specify this value, the host on which Action Handler service is running is used as the event issuing host. If you specify localhost, the physical host is set to this property. |
||
Monitoring Console Host |
Specify the PFM - Web Console host, if you open a PFM - Web Console login page by using JP1/IM - Manager monitor startup function. The value you specify must consist of alphanumeric characters, ".", and "-", and must not exceed 255 bytes. If you exceed 255 bytes, the value you specify is discarded. If you exceed 255 bytes or do not specify this value, the connection target PFM - Manager host is set to this value. |
||
Monitoring Console Port |
Specify the port number (HTTP request port number). The range of the value is from 1 to 65535. If the value you specify is out of the range, the value is discarded. If the value is out of the range or you do not specify this value, 20358 is set to this value. |
||
Monitoring Console Https |
Specifies whether to use HTTPS-encrypted communication to access PFM - Web Console when PFM - Web Console is started by JP1/IM - Manager monitor startup. By default, thisproperty is set to No.
|
||
JP1 Event Configurations |
Alarm |
JP1 Event Mode |
Specify which type of events to issue when the alarm status changes.
|
Detail Records |
-- |
Stores the properties of a record of PD record type. The record ID of the collected record is shown in bold type. |
|
Detail Records |
record-ID#1 |
-- |
Stores the properties of a record. |
Description |
Displays a description of the record. This property cannot be changed. |
||
Log |
The user selects Yes or No from a list to specify whether to save the record to the Store database. The record is saved when this value is Yes and the value of Collection Interval is greater than zero. |
||
Log(ITSLM) |
Displays Yes or No to indicate whether to save the records to the Store database of PFM - Agent for Microsoft SQL Server from JP1/SLM - Manager. For this property, No (fixed value) is displayed. |
||
Monitoring(ITSLM) |
Displays Yes or No to indicate the JP1/SLM - Manager setting for whether to send records to JP1/SLM - Manager. For this property, No (fixed value) is displayed. |
||
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. |
||
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. |
||
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. |
||
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).#2 Whether record collection might require 10 seconds or more is indicated by Yes or No.
The value of this property cannot be changed. |
||
Realtime Report Data Collection Mode |
This property is displayed only when historical data collection takes priority over real-time report display processing. (The history collection priority function is enabled.)
Note that you must specify the temporary log mode (Temporary Log) for records for which Over 10 Sec Collection Time is set to Yes. |
||
Interval Records |
-- |
Stores the properties of a record of PI record type. The record ID of the collected record is shown in bold type. |
|
Interval Records |
record-ID#1 |
-- |
Stores the properties of the record. |
Description |
Displays a description of the record. This property cannot be changed. |
||
Log |
The user selects Yes or No from a list to specify whether to save the record to the Store database. The record is saved when this value is Yes and the value of Collection Interval is greater than zero. |
||
Log(ITSLM) |
Displays Yes or No to indicate whether to save the records to the Store database of PFM - Agent for Microsoft SQL Server from JP1/SLM - Manager. For this property, No (fixed value) is displayed. |
||
Monitoring(ITSLM) |
Displays Yes or No to indicate the JP1/SLM - Manager setting for whether to send records to JP1/SLM - Manager. For this property, No (fixed value) is displayed. |
||
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. |
||
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. |
||
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. |
||
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).#2 Whether record collection might require 10 seconds or more is indicated by Yes or No.
The value of this property cannot be changed. |
||
Realtime Report Data Collection Mode |
This property is displayed only when historical data collection takes priority over real-time report display processing. (The history collection priority function is enabled.)
Note that you must specify the temporary log mode (Temporary Log) for records for which Over 10 Sec Collection Time is set to Yes. |
||
Log Records |
-- |
Stores the properties of a record of PL record type. This folder is not used because PFM - Agent for Microsoft SQL Server does not use this record. |
|
Restart Configurations |
-- |
Sets the condition for automatically restarting the PFM service. The condition can be set when the version of PFM - Manager or PFM - Base is 09-00 or later. For details about the PFM service Auto-restart functionality, see the chapter explaining the Performance Management functions in the JP1/Performance Management Planning and Configuration Guide. |
|
Restart when Abnormal Status |
Specifies whether to automatically restart a service when the Status Server service cannot obtain the status of the Action Handler service, Agent Collector service, and Agent Store service in a normal state. |
||
Restart when Single Service Running |
Specifies whether to automatically restart a service when only either the Agent Collector service or the Agent Store service is running. |
||
Restart Configurations |
Action Handler |
Auto Restart |
Specifies whether to use automatic restart for the Action Handler service. |
Auto Restart - Interval (Minute) |
Specifies the interval for checking the operating status of a service when automatic restart is used. You can specify a value from 1 through 1,440 (minutes). |
||
Auto Restart - Repeat Limit |
Specifies the number of consecutive times restart is attempted when automatic restart is used. You can specify an integer value from 1 through 10. |
||
Scheduled Restart |
Selects Yes or No from the list items to specify whether to use the normal restart procedure for the Action Handler service. |
||
Scheduled Restart - Interval |
Specifies the restart interval when the normal restart procedure is used. You can specify an integer value from 1 through 1,000. |
||
Scheduled Restart - Interval Unit |
Selects Hour, Day, Week, or Month from the list items to specify the unit for the restart interval when the normal restart procedure is used. |
||
Scheduled Restart - Origin - Year |
Specifies the year when restart is performed. You can specify an integer value from 1971 through 2035. |
||
Scheduled Restart - Origin - Month |
Specifies the month when restart is performed. You can specify an integer value from 1 through 12. |
||
Scheduled Restart - Origin - Day |
Specifies the day when restart is performed. You can specify an integer value from 1 through 31. |
||
Scheduled Restart - Origin - Hour |
Specifies the time (hour) when restart is performed. You can specify an integer value from 0 through 23. |
||
Scheduled Restart - Origin - Minute |
Specifies the time (minute) when restart is performed. You can specify an integer value from 0 through 59. |
||
Agent Collector |
Auto Restart |
Specifies whether to use automatic restart for the Agent Collector service. |
|
Auto Restart - Interval (Minute) |
Specifies the interval for checking the operating status of a service when automatic restart is used. You can specify a value from 1 through 1,440 (minutes). |
||
Auto Restart - Repeat Limit |
Specifies the number of consecutive times restart is attempted when automatic restart is used. You can specify an integer value from 1 through 10. |
||
Scheduled Restart |
Select Yes or No from the list items to specify whether to use the normal restart procedure for the Agent Collector service. |
||
Scheduled Restart - Interval |
Specifies the restart interval when the normal restart procedure is used. You can specify an integer value from 1 through 1,000. |
||
Scheduled Restart - Interval Unit |
Selects Hour, Day, Week, or Month from the list items to specify the unit for the restart interval when the normal restart procedure is used. |
||
Scheduled Restart - Origin - Year |
Specifies the year when restart is performed. You can specify an integer value from 1971 through 2035. |
||
Scheduled Restart - Origin - Month |
Specifies the month when restart is performed. You can specify an integer value from 1 through 12. |
||
Scheduled Restart - Origin - Day |
Specifies the day when restart is performed. You can specify an integer value from 1 through 31. |
||
Scheduled Restart - Origin - Hour |
Specifies the time (hour) when restart is performed. You can specify an integer value from 0 through 23. |
||
Scheduled Restart - Origin - Minute |
Specifies the time (minute) when restart is performed. You can specify an integer value from 0 through 59. |
||
Agent Store |
Auto Restart |
Specifies whether to use automatic restart for the Agent Store service. |
|
Auto Restart - Interval (Minute) |
Specifies the interval for checking the operating status of a service when automatic restart is used. You can specify a value from 1 through 1,440 (minutes). |
||
Auto Restart - Repeat Limit |
Specifies the number of consecutive times restart is attempted when automatic restart is used. You can specify a value from 1 through 10. |
||
Scheduled Restart |
Select Yes or No from the list items to specify whether to use the normal restart procedure for the Agent Store service. |
||
Scheduled Restart - Interval |
Specifies the restart interval when the normal restart procedure is used. You can specify an integer value from 1 through 1000. |
||
Scheduled Restart - Interval Unit |
Selects Hour, Day, Week, or Month from the list items to specify the unit for the restart interval when the normal restart procedure is used. |
||
Scheduled Restart - Origin - Year |
Specifies the year when restart is performed. You can specify an integer value from 1971 through 2035. |
||
Scheduled Restart - Origin - Month |
Specifies the month when restart is performed. You can specify an integer value from 1 through 12. |
||
Scheduled Restart - Origin - Day |
Specifies the day when restart is performed. You can specify an integer value from 1 through 31. |
||
Scheduled Restart - Origin - Hour |
Specifies the time (hour) when restart is performed. You can specify an integer value from 0 through 23. |
||
Scheduled Restart - Origin - Minute |
Specifies the time (minute) when restart is performed. You can specify an integer value from 0 through 59. |
||
ITSLM Connection Configuration |
-- |
Displays information about the linked JP1/SLM - Manager. |
|
ITSLM Connection Configuration |
ITSLM Connection |
-- |
Displays information about the connection-target JP1/SLM - Manager. |
ITSLM Host |
Displays the host name of the connected JP1/SLM - Manager. If a connection with JP1/SLM - Manager has not been established, this property is not displayed. |
||
ITSLM Port |
Displays the port number of the connected JP1/SLM - Manager. If a connection with JP1/SLM - Manager has not been established, this property is not displayed. |
||
MANAGE ITSLM CONNECTION |
-- |
Specifies whether to end the connection with JP1/SLM - Manager. |
|
DISCONNECT ITSLM CONNECTION |
Selects from the list items the JP1/SLM - Manager host name that is to be disconnected. If (empty string) is selected from the list items, nothing is done. If a connection with JP1/SLM - Manager has not been established, only (empty string) is displayed in the list items. |
||
Multiple Manager Configuration |
Primary Manager |
Displays the host name of the monitoring manager specified as the primary manager for multiple monitoring. You cannot change this property. |
|
Secondary Manager |
Displays the host name of the monitoring manager specified as the secondary manager for multiple monitoring. You cannot change this property. |
||
Agent Configuration |
-- |
Stores the properties for settings specific to PFM - Agent for Microsoft SQL Server. |
|
Product |
Displays the product ID, Q. |
||
Instance |
Displays the instance name of the monitored Microsoft SQL Server, which was specified by using the jpcconf inst setup command (If the default settings are used for the instance environment, default is displayed). |
||
SQL_Host |
Displays the name of the host on which the monitored Microsoft SQL Server is running. |
||
User |
Displays the user name that is used to log in to the monitored Microsoft SQL Server (The user name is encrypted when it is stored in the jpcagt.ini file). When Windows authentication is used, the user name will not be displayed. |
||
Errorlog |
Displays the name of the error log file of the monitored Microsoft SQL Server instance, which was specified by using the jpcconf inst setup command. The file name is displayed in a full path format. |
||
Timeout |
Displays the timeout value (in seconds) for queries to the database, which was specified by using the jpcconf inst setup command. The default value is 60. To change this property, specify from 1 to 3600. This property can be changed.#2 |
||
STARTUP_PENDING |
Displays the pending time (in seconds), from when PFM - Agent for Microsoft SQL Server had started until it transferred to normal operation, which was specified by using the jpcconf inst setup command. The default value is 0. Pending is not performed when 0 is specified. To change this property, specify from 1 to 3600. This property can be changed.#2 |
||
LOG_PATH |
Displays the output folder for agent log files, which was specified by using the jpcconf inst setup command. This property can be changed.#2 |
||
LOG_SIZE |
Displays the maximum size (in MB) of an agent log file, which was specified by using the jpcconf inst setup command. The default value is 16. To change this property, specify from 1 to 32. This property can be changed. #2 |
||
LOGIN_TIMEOUT |
Displays the timeout value (in seconds) for connecting to the database, which was specified by using the jpcconf inst setup command. The default value is 20. To change this property, specify from 1 to 3600. This property can be changed.#2 |
||
TOPN_SQL |
This property is used for a reserved record, and cannot be changed. |
||
DISK_READS_PER_EXECUTION |
This property is used for a reserved record, and cannot be changed. |
||
DB_FREE_PERC_OPTION |
Specifies the operation to be performed if the value of the Free % field of the Database Space Detail (PD_DS) record is negative. This property can be changed.#2 |
||
DB_FREE_PERC_NUMBER |
Specifies a value to replace with the value of the Free% 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.#2 |
||
LIMIT_PD_LD_NUMBER |
Displays the maximum number of Lock Detail (PD_LD) records that can be collected. The default value is 1000. To change this property, specify from 0 to 900000. This property can be changed.#2 |
||
LIMIT_PD_EE_NUMBER |
Displays the maximum number of Errorlog Error Detail (PD_EE) records that can be collected. This property is valid if you collect histories or monitor operations by using alarms. The default value is 1000. To change this property, specify from 100 to 100000. This property can be changed.#2 |
Legend:
--: Not applicable.
- #1
-
The folder name is shown as the record ID excluding the database ID. For details about the record ID of each type of record, see 5. Records.
- #2
-
To reflect updated values, restart the Agent Collector service.