PM_INSTANCE_ID1=Success
2=Abort
3=Failed
4=Unknown
5=Admin Timeout
6=Timeout
7=Reaper Timeout
PSPMTRANSHISTVW(SQL View) |
Index Back |
|---|---|
PMU History ViewPerformance monitor PMU history table. Stores all PMUs received by the monitoring system. |
| 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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PM_INSTANCE_ID |
Number(20,0) | DECIMAL(20) NOT NULL | Instance Identifier |
| 2 | PM_TRANS_DEFN_SET | Number(5,0) | INTEGER NOT NULL | Performance monitor transaction definition set number. |
| 3 | PM_TRANS_DEFN_ID | Number(5,0) | INTEGER NOT NULL | Performance Monitor Transaction Definition Identifier. |
| 4 | PM_AGENTID | Number(10,0) | DECIMAL(10) NOT NULL | Performance Monitor Agent Identifier. |
| 5 | PM_TRANS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PMU Status
1=Success 2=Abort 3=Failed 4=Unknown 5=Admin Timeout 6=Timeout 7=Reaper Timeout |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | PM_PERF_TRACE | Character(128) | VARCHAR2(128) NOT NULL | Performance Trace Name |
| 8 | PM_CONTEXT_VALUE1 | Character(254) | VARCHAR2(254) NOT NULL | Context 1 |
| 9 | PM_CONTEXT_VALUE2 | Character(254) | VARCHAR2(254) NOT NULL | Context 2 |
| 10 | PM_CONTEXT_VALUE3 | Character(254) | VARCHAR2(254) NOT NULL | Context 3 |
| 11 | PM_CONTEXTID_1 | Number(5,0) | INTEGER NOT NULL | Context Identifier 1 |
| 12 | PM_CONTEXTID_2 | Number(5,0) | INTEGER NOT NULL | Context Identifier 2 |
| 13 | PM_CONTEXTID_3 | Number(5,0) | INTEGER NOT NULL | Context Identifier 3 |
| 14 | PM_PROCESS_ID | Number(8,0) | INTEGER NOT NULL | Process ID |
| 15 | PM_AGENT_STRT_DTTM | DateTime(26) | TIMESTAMP | Agent Start Date/Time |
| 16 | PM_MON_STRT_DTTM | DateTime(26) | TIMESTAMP | Monitor Received Date/Time |
| 17 | PM_TRANS_DURATION | Number(22,3) | DECIMAL(21,3) NOT NULL | Duration (ms) |
| 18 | PM_PARENT_INST_ID | Number(20,0) | DECIMAL(20) NOT NULL | Parent Instance Identifier |
| 19 | PM_TOP_INST_ID | Number(20,0) | DECIMAL(20) NOT NULL | Top Instance Identifier |
| 20 | PM_METRIC_VALUE1 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 1 |
| 21 | PM_METRIC_VALUE2 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 2 |
| 22 | PM_METRIC_VALUE3 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 3 |
| 23 | PM_METRIC_VALUE4 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 4 |
| 24 | PM_METRIC_VALUE5 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 5 |
| 25 | PM_METRIC_VALUE6 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 6 |
| 26 | PM_METRIC_VALUE7 | Character(128) | VARCHAR2(128) NOT NULL | Metric Value 7 |
| 27 | PM_ADDTNL_DESCR | Long Character | CLOB | Additional Description |