Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

FREE TRIALS

Foglight for PeopleSoft 5.6.11 - User and Reference Guide

Table of Contents

Using Foglight for PeopleSoft

Exploring the PeopleSoft Dashboards

Deploying a Dashboard

Foglight for PeopleSoft Agents PS_AppMonitor Agent

Setting the PS_AppMonitor Connection Details Setting the PS_AppMonitor Data Management Parameters Setting the PS_AppMonitor Domain Information

PS_AppServer Agent

PS_AppServer Agent Properties Setting the PS_AppServer Connection Details Setting the PS_AppServer Data Management Parameters Setting the PS_AppServer PeopleSoft Parameters Investigating Domain Performance Investigating Domain Utilization

PS_DB2SQL Agent

PS_DB2SQL Agent Properties Setting the PS_DB2SQL Connection Details Setting the PS_DB2SQL Data Management Parameters Investigating Database Usage and PeopleSoft User Intensive SQL Statements

PS_MSSQL Agent Properties Setting the PS_MSSQL Connection Details Setting the PS_MSSQL Data Management Parameters Setting the PS_MSSQL Server Filter Parameters Investigating Database Usage and PeopleSoft User Intensive SQL Statements

PS_OracleSQL Agent

PS_OracleSQL Agent Properties Setting the PS_OracleSQL Connection Details Setting the PS_OracleSQL Data Management Parameters Setting the PS_OracleSQL Server Database Parameters Investigating Database Usage and PeopleSoft User Intensive SQL Statements

PS_PPM Agent Properties Setting the PS_PPM Connection Parameters Setting the PS_PPM Data Management Parameters Setting PS_PPM Threshold Parameters Investigating PeopleSoft Enterprise Performance Investigating PeopleSoft Web Server Performance Investigating PeopleSoft Application Server Performance

PS_SchedMonitor Agent

PS_SchedMonitor Agent Properties Setting the PS_SchedMonitor Connection Details Setting the PS_SchedMonitor Data Management Parameters Setting the PS_SchedMonitor Deployment Configuration Parameters

PS_SchedServer Agent

PS_SchedServer Agent Properties Setting the PS_SchedServer Connection Details Setting the PS_SchedServer Data Management Properties Setting the PS_SchedServer PeopleSoft Parameters Investigating Domain Performance Investigating Domain Utilization

PS_Scheduler Agent

PS_Scheduler Agent Properties Setting the PS_Scheduler Connection Details Setting the PS_Scheduler Data Management Properties Setting the PS_Scheduler Job and Process Collection Properties Setting the PS_Scheduler Oracle Database Properties Setting the PS_Scheduler DB2 UDB Database Properties Setting the PS_Scheduler MSSQL Database Properties Investigating Scheduler Status, Job and Process Details

Manual Agent Naming Deployment Scenario Procedures

Foglight for PeopleSoft Reference

PS_AppServer Views

PS_AppServer_Domain_Overview Graph View PS_AppServer_Domain_Utilization_Overview Graph View PS_AppServer_Process_Utilization_Overview Graph View PS_AppServer_Active_Clients Table View PS_AppServer_Active_Services Graph View PS_AppServer_Domain_Config Table View PS_AppServer_Domain_Totals Table View PS_AppServer_Process_Configuration Graph View PS_AppServer_Process_Details Table View PS_AppServer_Process_Totals Table View PS_AppServer_Queue_Summary Graph View PS_AppServer_Services Table View PS_AppServer_Users_In_Queue Graph View

PS_DB2SQL Views

PS_DB2SQL_PID_Overview Graph View PS_DB2SQL_PID_Detail Table View

PS_MSSQL_PID_Overview Graph View PS_MSSQL_PID_Detail Table View

PS_OracleSQL Views

PS_Ora_PID_Overview Graph View PS_Ora_PID_Detail Table View

PPM_App_Server_Overview Graph View PPM_Enterprise_Performance_Overview Graph View PPM_Web_Server_Overview Graph View PPM_App_Server_Detail Table View PPM_App_Server_Load_Distribution Graph View PPM_Enterprise_Details Table View PPM_Enterprise_Duration_Service_Level Graph View PPM_Enterprise_Duration_Time_Details Table View PPM_Enterprise_Duration_Time_Distribution Graph View PPM_Enterprise_Tier_Duration_Time Graph View PPM_Long_PMU_Detail Table View PPM_Web_Server_Detail Table View PPM_Web_Server_Load_Distribution Graph View

PS_SchedServer Views

PS_SchedServer_Domain_Overview Graph View PS_SchedServer_Domain_Utilization_Overview Graph View PS_SchedServer_Process_Utilization_Overview Graph View PS_SchedServer_Domain_Totals Table View PS_SchedServer_Process_Configuration Graph View PS_SchedServer_Process_Details Table View PS_SchedServer_Process_Totals Table View PS_SchedServer_Queue_Summary Graph View

PS_Scheduler Views

PSS_Current_JobNumbers Graph View PSS_Current_Jobs Graph View PSS_Current_Processes Graph View PSS_Current_Users Graph View PSS_DB_Overview Graph View PSS_Jobs_ProcessingTime Table View PSS_JobSummary Graph View PSS_Prcs_Types Graph View PSS_Processes_Hold_List Table View PSS_Processes_ProcessingTime Table View PSS_Processes_QueuedList Table View PSS_ProcessList Table View PSS_ProcessSummary Graph View PSS_Queue_Overview Graph View PSS_RptDist_Overview Graph View PSS_RptDistPrcs_List Table View PSS_RptDistPrcs_Summary Graph View PSS_Server_Uptime Graph View

PS_AppMonitor Agent Data Table

PS_AppMonitor AgentMsgs Data Table

PS_AppServer Agent Data Tables

PS_AppServer AgentMsgs Data Table AppServer_Process_Details Data Table Clients Data Table DomainConfiguration Data Table DomainTotals Data Table LogMessages Data Table Queue_Process_Totals Data Table Services Data Table

PS_DB2SQL Agent Data Tables

PS_DB2SQL AgentMsgs Data Table PS_DB2SQL UserData Data Table

PS_MSSQL Agent Data Tables

PS_MSSQL AgentMsgs Data Table PS_MSSQL UserData Data Table

PS_OracleSQL Agent Data Tables

PS_OracleSQL AgentMsgs Data Table PS_OracleSQL UserData Data Table

PS_PPM Agent Data Tables

PS_PPM PPMAgentMsgs Data Table PPMPeoplesoftAppServerSummary Data Table PPMPeoplesoftEnterpriseSummary Data Table PPMPeoplesoftLongPMUs Data Table PPMPeoplesoftWebServerSummary Data Table

PS_SchedMonitor Agent Data Table

PS_SchedMonitor AgentMsgs Data Table

PS_SchedServer Agent Data Tables

PS_SchedServer AgentMsgs Data Table SchedServer_Domain_Totals Data Table SchedServer_LogMessages Data Table SchedServer_Queue_Process_Details Data Table SchedServer_Queue_Process_Totals Data Table

PS_Scheduler Agent Tables

PS_Scheduler AgentMsgs Data Table PrcsTypeSummary Data Table QueueJobs Data Table QueueJobSummary Data Table QueuePrcs Data Table QueuePrcsSummary Data Table ReportDistributionAgent Data Table ReportDistributionPrcs Data Table ReportDistributionPrcsSummary Data Table RunPrcs Data Table SchedConfig Data Table SchedProcess Data Table

PS_SchedServer AgentMsgs Data Table

The AgentMsgs (Agent Messages) Table logs information about the PS_SchedServer agent.


Field	Description
Message	The text provided by the agent describing the error condition. It is displayed in the agent error rule.
MessageCt	Number of Identical Message for current collection cycle—helps to avoid messages storms.
MessageID	Unique agent message id, each error would start with an agent prefix followed by a three-digit number. For PeopleSoft, it would be PS_SchedServer_001, PS_SchedServer_002, 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_SchedServer Agent Error Messages:


Message ID	Severity	Message Text	User Action
PS_SSRV_201	Warning	The Process List Name that is being used is generic. It is recommended to create a unique list name as follows: <AgentName><HostName>	The agent continues execute and collect data based on the Process List Name. It is recommended to use a unique name for the process list.
PS_SSRV_202	Critical	Invalid PeopleSoft Home Directory	The agent will break. Verify the PeopleSoft enterprise home; by checking that the binary <PS_HOME>/appserv/psadmin exists.
PS_SSRV_203	Critical	Invalid Tuxedo Home Directory	The agent will break. Verify the Tuxedo home path; by checking that the binary <TUX_HOME>/bin/BBL exists.
PS_SSRV_204	Warning	The process list has changed check agent property and validates the change	Review the change to the secondary agent property process list.
PS_SSRV_205	Critical	Invalid Asp for Domain Config File	Verify that the configuration file exists as set in the agent property.
PS_SSRV_206	Critical	Failed to find psprcsrv.ubb file	Verify the domain information is correct including a valid .ubb file in the domain directory.
PS_SSRV_207	Critical	Failed to get the tuxedo config file	Verify the Tuxedo configuration file exists and is readable.
PS_SSRV_208	Critical	Failed to find logs directory	The log directory is not found. Verify the agent property values.
PS_SSRV_209	Warning	Failed to read tuxedo log (TUXLOG.MMDDYY)	Failed to read the Tuxedo log for today from the log directory. Verify existence and permissions.
PS_SSRV_210	Critical	Agent <Agent_Name> Version/DCMs mismatched <Agent_Version> / <DCM_Version> .Agent Shut Down	There is a problem in the installation of the agent. There is a mismatch between agent and DCM. Contact Dell Support.
PS_SSRV_212	Critical	Failed to connect to tuxedo domain:	Failed to connect to the domain. Domain is either down or you do not have permissions to connect to domain. Usually when using non-root user.
PS_SSRV_214	Warning	LDBAL value in the psprcsrv.ubb file is not turned on. Some data fields will not be collected properly	Turn LDBAL on in the psappsrv.ubb file.
PS_SSRV_218	Informational	Successful Data Collection.	Internal message.
PS_SSRV_219	Critical	PeopleSoft Tools version is not supported by this agent	Verify that the PeopleSoft version is supported for this agent.
PS_SSRV_999	Critical	Failed to initialize icu adapter validate resource file.	Contact Dell Support and verify installation status.

SchedServer_Domain_Totals Data Table

The SchedServer_Domain_Totals table logs information about the PS_SchedServer agent.


Field	Description
Availability_Pct	Measures the minimum availability of the overall PeopleSoft Process Scheduler server domain. Availability is based on the minimum number of instances defined for a server process in the .ubb file. If Instances Found are less than Min Instances for any server process within the domain, then Availability % equals zero. If Instances Found equals Min Instances, then Availability % equals 100.
PS_Domain	The name of the domain containing the Process Scheduler being monitored.
PS_Domain_Unique	The name of the domain, including the host on which it is running.
PS_Instance	The name of the PeopleSoft instance being monitored.
Percent_CPU	The percentage of CPU resources used by all the processes belonging to the Process Scheduler server domain.
Percent_Memory	The percentage of memory resources used by all the processes belonging to the Process Scheduler server domain.
ResidentSetSize	The total physical memory for all the processes belonging to the Process Scheduler server domain.
TotalQueueLength	The current length of the queue measured by the number of requests waiting to be processed for the PeopleSoft Scheduler server domain at the time of data collection.
TotalRequestsCompleted	The total number of requests a server process has processed for all server groups during the collection interval.
TotalWorkCompleted	The total workload completed by all server groups being monitored during the collection interval.
VirtualSetSize	The total size of swap space for all the monitored processes belonging to the Process Scheduler server domain.

SchedServer_LogMessages Data Table

The SchedServer_LogMessages Table logs information about the PS_SchedServer agent.


Field	Description
Error_Count	The number of times the error is found.
Error_Message	The error the user instructs the PS_SchedServer agent to trap. This error message is specified in the agent properties.
LogFile	The name of the log file being monitored.
Severity	The severity of the error that is trapped: informational, warning, critical. This severity is specified in the agent properties.
User_Message	The message the PS_SchedServer agent sends to the log if it encounters the error it is instructed to trap. This message is specified in the agent properties.

SchedServer_Queue_Process_Details Data Table

The SchedServer_Queue_Process_Details Table logs information about the PS_SchedServer agent.


Field	Description
ActiveRequests	The number of requests initiated by the server via tpcall(3c) or tpacall(3c) that are still active at the time of data collection. Active requests represent the number of requests that are made by the application server process.
PS_Domain	The name of the domain containing the application process being monitored.
Percent_CPU	The percentage of CPU resources used by a process.
Percent_Memory	The percentage of memory used by a process.
Process	The name of the process being monitored.
Process_ID	The number given by the system to this process.
Process_Unique	The name of the process and the process ID.
Requests	The number of requests made by the server via tpcall(3c) or tpacall(3c) at the time of data collection. Requests represent the number of requests that are made by the application server process.
RequestsCompleted	The total number of requests a server process has processed during the collection interval. RequestsCompleted displays the number of service requests that are processed and completed by the Process Scheduler server process advertising those particular services during the collection interval.
ResidentSetSize	The physical memory for the process belonging to the Process Scheduler server domain.
ServerPath	The fully qualified path name of the server executable. This is usually the name of the application server process (PSAPPSRV, PSSAMSRV, and so on).
Uptime	The number of hours the process is running.
VirtualSetSize	The size of swap space for the monitored process belonging to the Process Scheduler server domain.
WorkCompleted	The total work load completed by the application server process at the time of data collection. Work completed is the requests completed multiplied by the load factor (typically, 50).

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating