Chat now with support
Chat with Support

Foglight for PeopleSoft 5.6.11 - User and Reference Guide

Using Foglight for PeopleSoft
Exploring the PeopleSoft Dashboards Foglight for PeopleSoft Agents PS_AppMonitor Agent PS_AppServer Agent PS_DB2SQL Agent PS_MSSQL Agent PS_OracleSQL Agent PS_PPM Agent PS_SchedMonitor Agent PS_SchedServer Agent PS_Scheduler Agent Manual Agent Naming Deployment Scenario Procedures
Foglight for PeopleSoft Reference
Views
PS_AppServer Views PS_DB2SQL Views PS_MSSQL Views PS_OracleSQL Views PS_PPM Views PS_SchedServer Views PS_Scheduler Views
Data

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
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating