PSPMTRANS26_VW

index back

Redirect PMUs

Performance monitor view of all redirect PMUs.
SELECT C.PM_INSTANCE_ID , C.PM_TRANS_DEFN_SET , C.PM_TRANS_DEFN_ID , C.PM_AGENTID , C.PM_TRANS_STATUS , C.OPRID , C.PM_CONTEXT_VALUE1 , C.PM_CONTEXT_VALUE2 , C.PM_CONTEXT_VALUE3 , C.PM_CONTEXTID_1 , C.PM_CONTEXTID_2 , C.PM_CONTEXTID_3 , C.PM_PROCESS_ID , C.PM_AGENT_STRT_DTTM , C.PM_MON_STRT_DTTM , C.PM_TRANS_DURATION , C.PM_PARENT_INST_ID , C.PM_TOP_INST_ID , C.PM_METRIC_VALUE1 , C.PM_METRIC_VALUE2 , C.PM_METRIC_VALUE3 , C.PM_METRIC_VALUE4 , C.PM_METRIC_VALUE5 , C.PM_METRIC_VALUE6 , C.PM_METRIC_VALUE7 , C.PM_ADDTNL_DESCR FROM PSPMTRANSHIST C WHERE PM_TRANS_DEFN_SET = 1 AND PM_TRANS_DEFN_ID = 116

PeopleSoft Field Name Field Type Column Type Description
PM_INSTANCE_ID Number(20,0) DECIMAL(20) NOT NULL Instance Identifier
PM_TRANS_DEFN_SET Number(5,0) INTEGER NOT NULL Performance monitor transaction definition set number.
PM_TRANS_DEFN_ID Number(5,0) INTEGER NOT NULL Performance Monitor Transaction Definition Identifier.
PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
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
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
PM_CONTEXT_VALUE1 Character(254) VARCHAR2(254) NOT NULL Context 1
PM_CONTEXT_VALUE2 Character(254) VARCHAR2(254) NOT NULL Context 2
PM_CONTEXT_VALUE3 Character(254) VARCHAR2(254) NOT NULL Context 3
PM_CONTEXTID_1 Number(5,0) INTEGER NOT NULL Context Identifier 1
PM_CONTEXTID_2 Number(5,0) INTEGER NOT NULL Context Identifier 2
PM_CONTEXTID_3 Number(5,0) INTEGER NOT NULL Context Identifier 3
PM_PROCESS_ID Number(8,0) INTEGER NOT NULL Process ID
PM_AGENT_STRT_DTTM DateTime(26) TIMESTAMP Agent Start Date/Time
PM_MON_STRT_DTTM DateTime(26) TIMESTAMP Monitor Received Date/Time
PM_TRANS_DURATION Number(22,3) DECIMAL(21,3) NOT NULL Duration (ms)
PM_PARENT_INST_ID Number(20,0) DECIMAL(20) NOT NULL Parent Instance Identifier
PM_TOP_INST_ID Number(20,0) DECIMAL(20) NOT NULL Top Instance Identifier
PM_METRIC_VALUE1 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 1
PM_METRIC_VALUE2 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 2
PM_METRIC_VALUE3 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 3
PM_METRIC_VALUE4 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 4
PM_METRIC_VALUE5 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 5
PM_METRIC_VALUE6 Signed Number(30,4) DECIMAL(28,4) NOT NULL Metric Value 6
PM_METRIC_VALUE7 Character(128) VARCHAR2(128) NOT NULL Metric Value 7
PM_ADDTNL_DESCR Long Character CLOB Additional Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19