PM_INSTANCE_ID1=Success
2=Abort
3=Failed
4=Unknown
5=Admin Timeout
6=Timeout
7=Reaper Timeout
PSPMTRANSHISTVW |
| Platform | View Text |
|---|---|
| Default | SELECT PM_INSTANCE_ID , PM_TRANS_DEFN_SET , PM_TRANS_DEFN_ID , PM_AGENTID , PM_TRANS_STATUS , OPRID , PM_PERF_TRACE , PM_CONTEXT_VALUE1 , PM_CONTEXT_VALUE2 , PM_CONTEXT_VALUE3 , PM_CONTEXTID_1 , PM_CONTEXTID_2 , PM_CONTEXTID_3 , PM_PROCESS_ID , PM_AGENT_STRT_DTTM , PM_MON_STRT_DTTM , PM_TRANS_DURATION , PM_PARENT_INST_ID , PM_TOP_INST_ID , PM_METRIC_VALUE1 , PM_METRIC_VALUE2 , PM_METRIC_VALUE3 , PM_METRIC_VALUE4 , PM_METRIC_VALUE5 , PM_METRIC_VALUE6 , PM_METRIC_VALUE7 , PM_ADDTNL_DESCR FROM PSPMTRANSHIST WHERE PM_ADDTNL_DESCR IS NOT NULL |
| Sybase | SELECT PM_INSTANCE_ID ,PM_TRANS_DEFN_SET ,PM_TRANS_DEFN_ID ,PM_AGENTID ,PM_TRANS_STATUS ,OPRID ,PM_PERF_TRACE ,PM_CONTEXT_VALUE1 ,PM_CONTEXT_VALUE2 ,PM_CONTEXT_VALUE3 ,PM_CONTEXTID_1 ,PM_CONTEXTID_2 ,PM_CONTEXTID_3 ,PM_PROCESS_ID ,PM_AGENT_STRT_DTTM ,PM_MON_STRT_DTTM ,PM_TRANS_DURATION ,PM_PARENT_INST_ID ,PM_TOP_INST_ID ,PM_METRIC_VALUE1 ,PM_METRIC_VALUE2 ,PM_METRIC_VALUE3 ,PM_METRIC_VALUE4 ,PM_METRIC_VALUE5 ,PM_METRIC_VALUE6 ,PM_METRIC_VALUE7 ,PM_ADDTNL_DESCR FROM PSPMTRANSHIST WHERE textptr(PM_ADDTNL_DESCR) <> NULL |
| PeopleSoft Field Name | Description |
|---|---|
| PM_INSTANCE_ID | Instance Identifier |
| PM_TRANS_DEFN_SET | Performance monitor transaction definition set number. |
| PM_TRANS_DEFN_ID | Performance Monitor Transaction Definition Identifier. |
| PM_AGENTID | Performance Monitor Agent Identifier. |
| PM_TRANS_STATUS | PMU Status 1=Success 2=Abort 3=Failed 4=Unknown 5=Admin Timeout 6=Timeout 7=Reaper Timeout |
| OPRID | A user's ID |
| PM_PERF_TRACE | Performance Trace Name |
| PM_CONTEXT_VALUE1 | Context 1 |
| PM_CONTEXT_VALUE2 | Context 2 |
| PM_CONTEXT_VALUE3 | Context 3 |
| PM_CONTEXTID_1 | Context Identifier 1 |
| PM_CONTEXTID_2 | Context Identifier 2 |
| PM_CONTEXTID_3 | Context Identifier 3 |
| PM_PROCESS_ID | Process ID |
| PM_AGENT_STRT_DTTM | Agent Start Date/Time |
| PM_MON_STRT_DTTM | Monitor Received Date/Time |
| PM_TRANS_DURATION | Duration (ms) |
| PM_PARENT_INST_ID | Parent Instance Identifier |
| PM_TOP_INST_ID | Top Instance Identifier |
| PM_METRIC_VALUE1 | Metric Value 1 |
| PM_METRIC_VALUE2 | Metric Value 2 |
| PM_METRIC_VALUE3 | Metric Value 3 |
| PM_METRIC_VALUE4 | Metric Value 4 |
| PM_METRIC_VALUE5 | Metric Value 5 |
| PM_METRIC_VALUE6 | Metric Value 6 |
| PM_METRIC_VALUE7 | Metric Value 7 |
| PM_ADDTNL_DESCR | Additional Description |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |