Foglight for PeopleSoft 5.6.11 - User and Reference Guide


Field	Description
PS_Domain	The name of the domain containing the application process being monitored.
Process	The name of the process being monitored. This is usually the application server process (PSAPPSRV, PSSAMSRV, and so on) configured for the PeopleSoft application server domain. The server identified by TA_SERVERNAME runs on the computer identified by the T_QUEUE:TA_LMID attribute.
LogicalId	The logical machine on which servers associated with this queue are active.
PctFound	The percent of process spawning found for the collection interval. Zero percent should be the normal value if MinInstances = MaxInstances, which is the recommended configuration by PeopleSoft.
InstancesExpected	This value is set to equal MinInstances. MinInstances is the minimum number of instances of a process configured for that domain. For example, if a domain is configured to have three PSAPPSRV processes, the Instances Expected and Min Instances would be three.
InstancesFound	The number of instances of a process the agent found.
Percent_CPU	The percentage of CPU resources used by all the instances of a process in an application.
Percent_Memory	The percentage of memory used by all the instances of a process in an application.
ResidentSetSize	The total amount of physical memory that the process used, in kilobytes.
VirtualSetSize	The total amount of swap memory that the process used, in kilobytes.
RequestsEnqueued	The number of requests enqueued from the TA_SOURCE logical machine during the collection period at the time of data collection. A value greater than zero for the RequestsEnqueued indicates a queuing state where some requests or services are active and waiting in a queue for the corresponding application server process to process those requests. If request enqueued values greater than zero are observed for a number of consecutive collection cycles, it might indicate an insufficient number of instances of that application server process are configured within the application server domain to process requests from clients. NOTE: If the T_DOMAIN:TA_LDBAL attribute is N or the T_DOMAIN: TA_MODEL attribute is MP, this field does not return a value. Therefore, when this field does return a value, TA_LMID and TA_SOURCE have the same value. These values can be configured in the psappsrv.ubx configuration file.
Total enqueued	Typically the number of requests that is currently being processed by the application server process belonging to its queue at the time of data collection.
MinInstances	The minimum instances that are defined in the .ubb file.
MaxInstances	The max instances that are defined in the .ubb file.

Services Data Table

The Services Table logs information about the PS_AppServer agent.


Field	Description
ActiveRequests	The number of service requests that are enqueued during the collection period at the time of data collection. A value of ActiveRequests greater than zero indicates a queuing condition where the requests for that service type are in queue waiting to be processed by the appropriate application server process. Typically, this may be reflected by a RequestsEnqueued value greater than zero for an application server process queue (Queues table) processing that particular service. NOTE: This field shows a value only when T_DOMAIN:TA_MODEL is set to SHM, and T_DOMAIN:TA_LDBAL is set to Y. The above properties can be set in the psappsrv.ubx configuration file.
Load	Indicates the load on the system. Service load is used for load balancing purposes, (for example, queues with higher enqueued workloads are less likely to be chosen for a new request.).
LogicalId	The current logical machine on which an active server offering this service is running.
Requests	The number of service requests completed since it activated (advertised).
RequestsCompleted	The number of service requests completed since it activated (advertised).
ServerGroup	The server group name.
ServiceName	The service name.

PS_DB2SQL Agent Data Tables

The PS_DB2SQL agent contains the following tables. Select the table name to view the field definitions.

•

PS_DB2SQL AgentMsgs Data Table

•

PS_DB2SQL UserData Data Table

PS_DB2SQL AgentMsgs Data Table

The AgentMsgs (Agent Messages) Table contains data about PS_DB2SQL agent information and errors, with respect to database connections and agent configurations, and operation in the PeopleSoft environment.

The following table describes the data stored in the AgentMsgs table:


Field	Description
Message	The text provided by the agent describing the error condition. This text is displayed in the agent error rule.
MessageID	Unique agent message id, each error would start with the agent prefix followed by a three-digit number. For PeopleSoft, it would be PSFT_000, PSFT_001, and so on. Refer to the tables below for the PeopleSoft Agent Message Numbers and descriptions.
Severity	Severity of the agent error condition, for example, Informational, Warning, Critical, Fatal.

The following are the PS_DB2SQL agent error messages:

Table 60:
Message ID	Severity	Message Text	User Action
PS_DB2_100	Informational	Using DB Share Library Version %s	Check if the Shared Library Version is as described in the online help.
PS_DB2_101	Informational	PeopleTools version is %s	None.
PS_DB2_102	Critical	PeopleTools version is not 7 or 8	Ensure that PeopleTools version is 7.x to 8.x.
PS_DB2_103	Informational	Successfully connected to Database	None.
PS_DB2_104	Warning	Expensive SQL has been identified and recorded	Check if this SQL has undue impact on the computer by tracking the resources used by PSProcessID from the UserData table.
PS_DB2_105	Warning	%s	Message contents point to action if needed.
PS_DB2_106	Critical	Failed to Load DB Share Library. %s	Check if the Dell Shared Library named exists.
PS_DB2_107	Critical	Failed to set Environment for ... %s	Check if required database client libraries are available.
PS_DB2_108	Critical	Failed to Create Object ... %s	Check if client computer is low on available physical memory.
PS_DB2_109	Critical	Database Connection Error: OTL Message Error: %s	Message contents point to action if needed.
PS_DB2_109	Informational	Agent successfully reconnected to Database	None.
PS_DB2_110	Informational	%s	None.
PS_DB2_110	Warning	%s	Message contents point to action if needed.
PS_DB2_110	Critical	%s	Message contents point to action if needed.
PS_DB2_111	Informational	%s %s	None.
PS_DB2_111	Warning	%s %s	Message contents point to action if needed.
PS_DB2_111	Critical	%s %s	Message contents point to action if needed.
PS_DB2_112	Informational	%s %s %s	None.
PS_DB2_112	Warning	%s %s %s	Message contents point to action if needed.
PS_DB2_112	Critical	%s %s %s	Message contents point to action if needed.
PS_DB2_113	Warning	Can not open the logfile: %s. Log SQL output switched off	The file path needs to be fixed.
PS_DB2_114	Informational	ResourceBundle initialized. Resource File Path = %s	None.
PS_DB2_115	Critical	Failed to initialize ResourceBundle. Resource File Path = %s	The resource file, PS_DB2SQL_en.res, may need to be replaced if missing.
PS_DB2_999	Critical	Failed to initialize icu adapter validate resource file.	Contact Dell Support and verify installation status.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for PeopleSoft 5.6.11 - User and Reference Guide

Queue_Process_Totals Data Table

Services Data Table

PS_DB2SQL Agent Data Tables

PS_DB2SQL AgentMsgs Data Table