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

ReportDistributionAgent Data Table

The following table describes the data stored in the ReportDistributionAgent table.


Field	Description
CMD	The operating system process name for the Report Distribution - PSDSTSRV.
CPU	The percentage of CPU resources the Report Distribution process is using at the time of collection.
DBName	The name of the database to which the PeopleSoft Process Scheduler is connected.
MEM	The percentage of physical memory the Report Distribution process is using at the time of collection.
OperatorID	The name of the PeopleSoft application user. This is usually the ID of the operator who booted the PeopleSoft Process Scheduler.
PID	The unique process identification number that the kernel assigned when the Report Distribution process is created.
RSS	The resident set size of the Report Distribution process at the time of collection.
Uptime	The amount of time in hours the Report Distribution process runs, measured in 15 minute intervals.
VSS	The amount of swap memory that the Report Distribution process used, in kilobytes.

ReportDistributionPrcs Data Table

The following table describes the data stored in the ReportDistributionPrcs table.


Field	Description
Class	The job class that the process belongs to.
DBName	The name of the database to which the PeopleSoft Process Scheduler is connected.
EndTime	The date and time the process completes.
OperatorID	The name of the PeopleSoft application user who schedules the job or process.
PrcsInstance	The Process Instance ID from PS_CMD_LIST.PRCSINSTANCE. If the parent QueueJobs.JobStatus is either cancelled, deleted or errored out, it does not collect information after a specific elapsed time defined by the agent property. This feature is necessary so that the same hold processes are not collected for future collection cycles which significantly reduces the amount of redundant data collected by Foglight.
PrcsName	The name of the process.
PrcsStatus	The current status description of the process. NOTE: For Posting status, the agent collects data for processes that are in a posting status for more than 30 minutes and less than 24 hours from the Foglight agent’s current collection period. The agent uses this data to notify the user of processes that are hung on a posting status. NOTE: For Not Posted and Generated status, the agent collects data when the current time minus the end time is greater than five minutes and less than 20 minutes. This is required because the Not Posted and Generated status EndTime is time stamped with a back date and not the current time.
ProcessingTime	The amount of time, in seconds, the job takes to process completely. If the job completes successfully during the collection period, the Processing Time is the difference between the end time and the begin time for the job. If the job is in the processing state at the time of collection, the Processing Time is the difference between the system time at the time of collection and the begin time for the job. For jobs that end with other statuses, such as Unsuccessful, the Processing Time is the time from the Begin Time to the time the job ended with that status.
QueueName	This is the Process Scheduler server name from which the job or process is assigned to at the time of submission.
RequestTime	The time the job or process request is scheduled.
Status	The current status numerical value of the ReportDistribution process.

ReportDistributionPrcsSummary Data Table

The following table describes the data stored in the ReportDistributionPrcs table.


Field	Description
DBName	The PS Database Name.
Delete	The number of Delete (DISTSTATUS == 6) Reports.
Generated	The number of Generated (DISTSTATUS == 3) Reports.
Not Posted	The number of Not Posted (DISTSTATUS == 4) Reports.
Posted	The number of Posted (DISTSTATUS == 5) Reports.
Posting	The number of Posting (DISTSTATUS == 7) Reports.
Processing	The number of Processing (DISTSTATUS == 2) Reports.
Scheduled	The number of Scheduled (DISTSTATUS == 1) Reports.
Total	The total number of DISTSTATUS Reports.

RunPrcs Data Table

The RunPrcs (Run Process) Table provides information about the processes that are currently in the processing state. It provides information about the resource consumption for each of those processes. The following table describes the data stored in the RunPrcs table.


Field	Description
CPU	The percentage of CPU resources the process is using.
Class	The job class that the process belongs to.
DBName	The name of the database to which the scheduler is connected.
JobName	The name of the job.
JobNumber	This is the Job ID.
JobSeq	The sequence number of the process within the job.
MEM	The percentage of memory used by the process.
OperatorID	The name of the PeopleSoft application user who scheduled the job.
PID	The operating system Process ID assigned by PeopleSoft for that particular process.
PrcsName	The name of the process.
QueueName	The name of the Process Scheduler queue under which the job is queued.
RSS	The physical memory used by the process.
RunTime	How long the process is running, in hours. This is the CPU time for the process at the time of collection.
SID	The database session ID for this process.
Serial	The Oracle session serial number for this process.
VSS	The amount of swap memory that the process used, in kilobytes.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating