Exec Time (ms) — The SQL statement execution time in milliseconds. This is either the difference between the statement end time and statement start time OR the difference between the Foglight collection time and statement start time, if the statement is still in execution and has no end time available at the time of data collection.
PS Application User — The PeopleSoft operator ID who is executing the SQL statement.
•
PS Process PID — The PID corresponding to the PSProcessName.
•
PS Domain Name — The online Application Server Domain Name associated with the SQL statement. For Process Scheduler and two-tier processes, this column is blank.
•
PS Machine Name — The name of the computer that the PeopleSoft application user logged in from.
•
SQL Statement — The SQL statement syntax being executed by the user.
•
SQL Status. The status of the DB2 Session ID. The Status can be one of the following values:
PS Process Name — The name of either the application server or the process scheduler process.
•
SQL Execution Time (ms) — The SQL statement execution time in milliseconds. This is either the difference between the statement end time and statement start time OR the difference between the Foglight collection time and statement start time, if the statement is still in execution and has no end time available at the time of data collection.
•
Rows Read — The number of rows read from the table.
•
Rows Written — The number of rows changed (inserted, deleted or updated) in the table.
•
Statement Sorts — The total number of times that a set of data is sorted in order to process the statement operation.
