• United States (English)
• Brazil (Português)
• China (中文)
• France (Français)
• Germany (Deutsch)
• Italy (Italiano)
• Japan (日本語)
• Korea (한국어)
• Mexico (Español)

• 登录
• 创建支持帐户

免费试用版

• 成为门户专家
• 打印
• 我的下载 ()

• 支持
• 技术说明文件
• Foglight for PeopleSoft 5.6.11
• Foglight for PeopleSoft 5.6.11 - User and Reference Guide

Foglight for PeopleSoft 5.6.11 - User and Reference Guide

内容导航  

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

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

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

Views

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 Views

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

PS_PPM Views

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

Data

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

• Viewing Topics 169 - 172 of 178

×

QueueJobs Data Table

The QueueJobs Table contains the detailed information about jobs that are being processed by the PeopleSoft Process Scheduler. The values in the table columns represent the data since the last Foglight collection cycle. Data is collected in this table only for those jobs when the current time of collection is later than the scheduled run time for the job.

The maximum number of rows of data collected for this table is determined by the limit entered in the Jobs/Prcs Collection agent property (with a hard limit of 50). For jobs that are on hold (or other jobs that change status to hold), the data collection is determined by the value entered for the age of the jobs (from the original run time to the current collection time) in the Jobs/Prcs Collection agent property.

 

NOTE: Jobs with statuses other than hold (for example, pending) that have changed status to hold and are older than the age specified in the agent property are not collected, as the original run time is taken into account for computing the age of the jobs.

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

 

Field	Description
BeginTime	The date and time the job started processing.
Class	The job class, for example, SQR, PSJob, Crystal, and so on.
DBName	The name of the database to which the PeopleSoft Process Scheduler is connected.
EndTime	The date and time the job completed.
JobName	The name of the job.
JobNumber	This is the Job ID. This is the Job Instance Number if the JobNumber is not zero. If the JobNumber is zero or the process submitted through the process scheduler has no job associated with it, then this number is the Process Instance Number.
JobStatus	The current status description of the job.
Late	How far past the scheduled run time the job is queued, in seconds. It is the difference between the system time at the time of collection and the run time for the job, if the job has not yet begun processing OR the difference between the Start Time and the run time if the job has begun processing.
OperatorID	The name of the PeopleSoft application user who scheduled the job.
PrcsInstance	The process instance number is the order that the process appears in the queue. This number is automatically generated.
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	The name of PS Scheduler job queue.
QueueTime	The date and time the job is queued.
RunTime	The date and time the job is scheduled to run.
Status	The current status numerical value of the job.

QueueJobSummary Data Table

The QueueJobSummary Table contains the summary information about jobs that are being processed by the PeopleSoft Process Scheduler. The values in the table columns represent the data since the last Foglight collection cycle. The following table describes the data stored in the QueueJobSummary table.

 

Field	Description
Blocked	The number of Blocked (RunStatus == 18) jobs.
Cancel	The number of Cancel (RunStatus == 1) jobs.
Cancelled	The number of Cancelled (RunStatus == 8) jobs.
Content_Generated	The number of Content_Generated (RunStatus == 15) jobs.
DBName	The PS Database Name.
Delete	The number of Delete (RunStatus == 2) jobs.
Error	The number of Error (RunStatus == 3) jobs.
Hold	The number of Hold (RunStatus == 4) jobs.
Initiated	The number of Initiated (RunStatus == 6) jobs.
Pending	The number of Pending (RunStatus == 16) jobs.
Posted	The number of Posted (RunStatus == 11) jobs.
Posting	The number of Posting (RunStatus == 14) jobs.
Processing	The number of Processing (RunStatus == 7) jobs.
Queue Name	The name of PS Scheduler job queue.
Queued	The number of Queued (RunStatus == 5) jobs.
Resend	The number of Resend (RunStatus == 13) jobs.
Restart	The number of Restart (RunStatus == 19) jobs.
Successful	The number of Successful (RunStatus == 9) jobs.
Total	The total number of jobs.
Unable_to_Post	The number of UnabletoPost (RunStatus == 12) jobs.
Unsuccessful	The number of Unsuccessful (RunStatus == 10) jobs.
Warning	The number of Warning (RunStatus == 17) jobs.

QueuePrcs Data Table

The QueuePrcs (Queue Process) Table contains the detailed information about processes that are being processed by the PeopleSoft Process Scheduler. The values in the table columns represent the values since the last Foglight collection cycle. Data is collected in this table only for those processes when the current time of collection is later than the scheduled run time for the process.

The maximum number of rows of data collected for this table is determined by the limit entered in the Jobs/Prcs Collection agent property (with a hard limit of 50). For processes that are on hold (or other processes that change status to hold), the data collection is determined by the value entered for the age of the processes (from the original run time to the current collection time) in the Jobs/Prcs Collection agent property.

 

NOTE: Processes with statuses other than hold (for example, pending) that have changed status to hold and are older than the age specified in the agent property are not collected, as the original run time is taken into account for computing the age of the processes.

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

 

Field	Description
BeginTime	The date and time the job started processing.
Class	The job class, for example, SQR, PSJob, Crystal, and so on.
DBName	The name of the database to which the PeopleSoft Process Scheduler is connected.
EndTime	The date and time the job completed.
JobName	The name of the job.
JobNumber	This is the Job Instance Number if the JobNumber is not zero. If the JobNumber is zero or the process submitted through the process scheduler has no job associated with it, then this number is the Process Instance Number.
JobSeq	The sequence number of the Job within the job that the process is associated with. This number is zero if the JobNumber is zero or the process submitted through the process scheduler has no job associated with it. For jobs with multiple processes (and a JobNumber not equal to zero), the addition of a JobSeq number to the JobNumber value equals the Process Instance Number assigned by the Process Scheduler.
Late	How far past the scheduled run time the job is queued, in seconds. It is the difference between the system time at the time of collection and the run time for the job, if the job has not yet begun processing OR the difference between the Start Time and the run time if the job has begun processing.
OperatorID	The name of the PeopleSoft application user who scheduled the job.
PrcsInstance	The process instance number is the order that the process appears in the queue. This number is automatically generated.
PrcsName	The name of the process.
PrcsStatus	The current status description of the process.
Processing Time	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	The name of PS Scheduler job queue.
QueueTime	The date and time the job queued.
RunTime	The date and time the job is scheduled to run.
Status	The current status numerical value of the job.

QueuePrcsSummary Data Table

The QueuePrcsSummary (Queue Process Summary) Table contains the summary information about processes that are being processed by the PeopleSoft Process Scheduler. The values in the table columns represent the data since the last Foglight collection cycle. The following table describes the data stored in the QueuePrcsSummary table.

 

Field	Description
Blocked	The number of Blocked (RunStatus == 18) processes.
Cancel	The number of Cancel (RunStatus == 1) processes.
Cancelled	The number of Cancelled (RunStatus == 8) processes.
Content_Generated	The number of Content_Generated (RunStatus == 15) processes.
DBName	The PS Database Name.
Delete	The number of Delete (RunStatus == 2) processes.
Error	The number of Error (RunStatus == 3) processes.
Hold	The number of Hold (RunStatus == 4) processes.
Initiated	The number of Initiated (RunStatus == 6) processes.
Pending	The number of Pending (RunStatus == 16) processes.
Posted	The number of Posted (RunStatus == 11) processes.
Posting	The number of Posting (RunStatus == 14) processes.
Processing	The number of Processing (RunStatus == 7) processes.
QueueName	The name of PS Scheduler job queue.
Queued	The number of Queued (RunStatus == 5) processes.
Resend	The number of Resend (RunStatus == 13) processes.
Restart	The number of Restart (RunStatus == 19) processes.
Successful	The number of Successful (RunStatus == 9) processes.
Total	The total number of jobs.
Unable_to_Post	The number of UnabletoPost (RunStatus == 12) processes.
Unsuccessful	The number of Unsuccessful (RunStatus == 10) processes.
Warning	The number of Warning (RunStatus == 17) processes.

•  上一页
• Viewing Topics 169 - 172 of 178
• 下一页 

搜索该文档 搜索所有文档

×

 欢迎访问支持

您可以在附属支持站点上查找适用于戴尔*产品*的在线支持帮助。单击“继续”，转至适用于*产品*的正确支持内容和帮助。

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级