• 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 145 - 148 of 178

×

PS_DB2SQL UserData Data Table

The UserData table contains information about the PeopleSoft user activity in the database. It collects information on which users are running what SQL statements along with the relevant application server domain and SQL metrics.

 

NOTE: The DB_Monitoring value should be set to one in the application server domains connected to the PeopleSoft database instance being monitored, in order to get all the information in the UserData table.

 

NOTE: If “NA” displays in a field, then the information for that field is not available for that collection period.

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

 

Field	Description
PSApplicationUser	The PeopleSoft operator ID who is executing the SQL statement.
PSDatabaseUser	The PeopleSoft Database Owner.
PSDomainName	The online Application Server Domain Name associated with the SQL statement. For Process Scheduler and two-tier processes, this column is blank.
PSMachineName	The name of the computer from where the PeopleSoft application user logged in.
PSOSUser	The name of the PeopleSoft OS User. This is the operating system name running on the computer from where the PeopleSoft application user logged in.
PSProcessName	The name of either the application server or the process scheduler process.
PSProcessPID	The PID corresponding to the PSProcessName.
PSSessionID	The name of the PeopleSoft DB2 UDB SID.
PSRowsRead	The number of rows read from the table.
SQL	The SQL statement syntax being executed by the user.
PSStatementExecTime	The SQL statement execution time in milliseconds. If the statement is still in execution and has no end time available at the time of data collection, then the execution time is either the difference between: • Statement end time and statement start time, or • Foglight collection time and statement start time.
PSRowsWritten	The number of rows changed (inserted, deleted or updated) in the table.
PSStatementSorts	The total number of times that a set of data is sorted in order to process the statement operation.
PSStatementStartTime	The date and time when the statement operation started executing.
PSStatementEndTime	The date and time when the statement operation stopped executing.
Status	The status of the DB2 Session ID. The Status can be one of the following values: • Connect pending • Connect completed • UOW executing • UOW waiting • Lock wait • Commit active • Rollback active • Recompiling a plan • Compiling a SQL statement • Request interrupted • Disconnect pending • Prepared transaction • Heuristically committed • Heuristically rolled back • Transaction ended • Creating Database • Restarting a Database • Restoring a Database • Performing a Backup • Performing a fast load • Performing a fast unload • Wait to disable table space • Quiescing a table space • Waiting for remote node • Pending results from remote request

PS_MSSQL Agent Data Tables

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

•	PS_MSSQL AgentMsgs Data Table

•	PS_MSSQL UserData Data Table

PS_MSSQL AgentMsgs Data Table

The AgentMsgs (Agent Messages) Table contains data about PS_MSSQL agent information and errors, with respect to database connection 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_MSSQL Agent Error Messages:

 

Message ID	Severity	Message Text	User Action
PS_MSSQL_100	Informational	Using DB Share Library Version %s	Check if the Shared Library Version is as described in the online help.
PS_MSSQL_101	Informational	PeopleTools version is %s	None.
PS_MSSQL_102	Critical	PeopleTools version is not 7 or 8	Ensure that PeopleTools version is 7.x to 8.x.
PS_MSSQL_103	Informational	Successfully connected to Database	None.
PS_MSSQL_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_MSSQL_105	Warning	%s	Message contents point to action if needed.
PS_MSSQL_106	Critical	Failed to Load DB Share Library. %s	Check if the Dell Shared Library named exists.
PS_MSSQL_107	Critical	Failed to set Environment for ... %s	Check if required database client libraries are available.
PS_MSSQL_108	Critical	Failed to Create Object ... %s	Check if client computer is low on available physical memory.
PS_MSSQL_109	Critical	Database Connection Error: OTL Message Error: %s	Message contents point to action if needed.
PS_MSSQL_109	Informational	Agent successfully reconnected to Database	None.
PS_MSSQL_110	Informational	%s	None.
PS_MSSQL_110	Warning	%s	Message contents point to action if needed.
PS_MSSQL_110	Critical	%s	Message contents point to action if needed.
PS_MSSQL_111	Informational	%s %s	None.
PS_MSSQL_111	Warning	%s %s	Message contents point to action if needed.
PS_MSSQL_111	Critical	%s %s	Message contents point to action if needed.
PS_MSSQL_112	Informational	%s %s %s	None.
PS_MSSQL_112	Warning	%s %s %s	Message contents point to action if needed.
PS_MSSQL_112	Critical	%s %s %s	Message contents point to action if needed.
PS_MSSQL_113	Warning	Cannot open the logfile: %s. Log SQL output switched off	The file path needs to be fixed.
PS_MSSQL_114	Informational	ResourceBundle initialized. Resource File Path = %s	None.
PS_MSSQL_115	Critical	Failed to initialize ResourceBundle. Resource File Path = %s	The resource file, PS_MSSQL_en.res, may need to be replaced if missing.
PS_MSSQL_999	Critical	Failed to initialize icu adapter validate resource file.	Contact Dell Support and verify installation status.

PS_MSSQL UserData Data Table

The UserData table contains information about the PeopleSoft user activity in the database. It collects information on which users are in the SQL Server 2000 database running particular SQL statements or stored procedures at the time of data collection, along with the relevant application server domain and SQL metrics.

 

NOTE: The DB_Monitoring value should be set to one in the application server domains connected to the PeopleSoft database instance being monitored, in order to get all the information in the UserData table.

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

 

Field	Description
BufferGets	The number of buffer reads by the SQL statement.
DiskReads	The number of disk reads by the SQL statement.
PSApplicationUser	The PeopleSoft operator ID who is executing the SQL statement.
PSDatabaseUser	The PeopleSoft Database Owner.
PSDomainName	The online Application Server Domain Name associated with the SQL statement. For Process Scheduler and two-tier processes, this column is blank.
PSMachineName	The name of the computer from where the PeopleSoft application user logs in.
PSOSUser	The name of the PeopleSoft OS User. This is the operating system name running on the computer from where the PeopleSoft application user logs in.
PSProcessName	The name of either the application server or the process scheduler process. NOTE: The PSProcessName value depends on the Select server for the agent property values (SQL Server SQL Criteria). If the PS_MSSQL agent is installed on the database server, this field only shows PeopleSoft as values. If the PS_MSSQL agent is installed on the box where PeopleSoft application server domain(s) are configured, then the process names (PSAPPSRV, PSSAMSRV, and so on) belonging to only those domains on the box are displayed in the ProcessName column. Processes belonging to PeopleSoft application server domains not on the same box are displayed as PeopleSoft.
PSProcessPID	The PID corresponding to the PSProcessName.
PSSessionID	The PeopleSoft SessionID.
RowsProcessed	The number of rows returned by the SQL statement.
SQL	The SQL statement syntax or stored procedure name being executed by the PeopleSoft application user.
PSPercentCPU	The CPU percentage for the PeopleSoft process. This percentage is relative to the total PeopleSoft CPU.
PSPercentIO	The I/O percentage for the PeopleSoft process. This percentage is relative to the total PeopleSoft I/O.
PSRawCpuCount	Shows CPU consumed for this PeopleSoft process.
PSRawIOCount	Shows I/O consumed for this PeopleSoft process.
Status	The status of the SQL Server 2000 Session ID. The status can have one of the following values: • Sleeping • Background • Runable • Running

•  上一页
• Viewing Topics 145 - 148 of 178
• 下一页 

搜索该文档 搜索所有文档

×

 欢迎访问支持

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

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级