Example 1: Generic Use of MonitorMySessions
select * from table (monitormysessions()) as t1;
Result:
HostId 1
SessionNo 1006
LogonPENo 30718
RunVprocNo 30718
PartName DBC/SQL
PEstate DISPATCHING
LogonTime 2016/04/29 11:26:46.00
UserId 1028
LSN 0
UserName JCK
UserAccount DBC
PECPUsec 2.40000000000000E-002
XActCount 1.00000000000000E 000
ReqCount 2.00000000000000E 000
ReqCacheHits 0.00000000000000E 000
AMPState ACTIVE
AMPCPUSec 1.12050000000000E 003
AMPIO 3.49605000000000E 005
ReqSpool 4.39090831360000E 010
Blk1HostId 0
Blk1SessNo 0
Blk1UserId 0
Blk1Lmode
Blk1Otype
Blk1ObjDBID 0
Blk1ObjTID 0
Blk1Status
Blk2HostId 0
Blk2SessNo 0
Blk2UserId 0
Blk2Lmode
Blk2Otype
Blk2ObjDBID 0
Blk2ObjTID 0
Blk2Status
Blk3HostId 0
Blk3SessNo 0
Blk3UserId 0
Blk3Lmode
Blk3Otype
Blk3ObjDBID 0
Blk3ObjTID 0
Blk3Status
MoreBlockers
LogonSource (TCP/IP) f1a3 153.64.183.39 MYSYSTEM 9964
HotAmp1CPU 3.33200000000000E 001
HotAmp2CPU 3.32880000000000E 001
HotAmp3CPU 3.32880000000000E 001
HotAmp1CPUId 2
HotAmp2CPUId 1
HotAmp3CPUId 0
HotAmp1IO 1.03620000000000E 004
HotAmp2IO 1.03460000000000E 004
HotAmp3IO 1.03270000000000E 004
HotAmp1IOId 2
HotAmp2IOId 3
HotAmp3IOId 1
LowAmp1CPU 3.32760000000000E 001
LowAmp2CPU 3.32880000000000E 001
LowAmp3CPU 3.32880000000000E 001
LowAmp1CPUId 3
LowAmp2CPUId 1
LowAmp3CPUId 0
LowAmp1IO 1.03160000000000E 004
LowAmp2IO 1.03270000000000E 004
LowAmp3IO 1.03460000000000E 004
LowAmp1IOId 0
LowAmp2IOId 1
LowAmp3IOId 3
AvgAmpCPUSec 3.32930000000000E 001
AvgAmpIOCnt 1.03377500000000E 004
AmpCount 4
TempSpaceUsg 0.00000000000000E 000
ReqStartTime 2016/04/29 11:26:46.00
ReqCPU 1.12050000000000E 003
ReqIO 3.49605000000000E 005
ReqNo 3
WlcId 0
DontReclassifyFlag 255
ProxyUser
CPUDecayLevel 0
IODecayLevel 0
TacticalCPUException 0
TacticalIOException 0
ReqIOKB 4.34172850000000E 007
ReqPhysIO 9.09660000000000E 004
ReqPhysIOKB 3.97004920000000E 007
ReqStepsCompletedCnt 9
RedriveProtection MN
CurrentRedriveParticipation F
ReqRedriveSpoolSpace 0.00000000000000E 000
BlockerSessionCnt 0
ReqTblOpBytesIn 0.00000000000000E 000
ReqTblOpBytesOut 0.00000000000000E 000
ProxyUserId 0
ZoneId 0
ReqHotAmpCPU 2.80292000000000E 002
ReqHotAmpCPUId 3
ReqHotAmpIO 8.75320000000000E 004
ReqHotAmpIOId 3
ReqInvolvedAMPCnt 4
ReqFirstRespTime 0000/00/00 00:00:00.00
ReqLocalQueryStatus 0
ReqRemoteHostId 0
ReqRemoteSessionId 0
ReqRemoteRequestId 0
ReqRemoteQueryId 0.00000000000000E 000
ReqHotAmpSpool 1.09939000320000E 010
ReqHotAmpSpoolId 3
ReqMapNo 0
ReqMaxNumMapAMPs 0
ReqMinNumMapAMPs 0
ReqSysDefNumMapAMPs 0
ReqRemoteHostIp
ReqServerName
ReqFlexReleased 0
HostId 1
SessionNo 1010
LogonPENo 30719
RunVprocNo 30719
PartName DBC/SQL
PEstate DISPATCHING
LogonTime 2016/04/29 11:45:40.00
UserId 1028
LSN 0
UserName JCK
UserAccount DBC
PECPUsec 3.00000000000000E-001
XActCount 1.00000000000000E 000
ReqCount 3.00000000000000E 000
ReqCacheHits 0.00000000000000E 000
AMPState ACTIVE
AMPCPUSec 4.00000000000000E-003
AMPIO 0.00000000000000E 000
ReqSpool 0.00000000000000E 000
Blk1HostId 0
Blk1SessNo 0
Blk1UserId 0
Blk1Lmode
Blk1Otype
Blk1ObjDBID 0
Blk1ObjTID 0
Blk1Status
Blk2HostId 0
Blk2SessNo 0
Blk2UserId 0
Blk2Lmode
Blk2Otype
Blk2ObjDBID 0
Blk2ObjTID 0
Blk2Status
Blk3HostId 0
Blk3SessNo 0
Blk3UserId 0
Blk3Lmode
Blk3Otype
Blk3ObjDBID 0
Blk3ObjTID 0
Blk3Status
MoreBlockers
LogonSource (TCP/IP) f1f0 153.64.183.39 MYSYS 8348 JK
HotAmp1CPU 4.00000000000000E-003
HotAmp2CPU 0.00000000000000E 000
HotAmp3CPU 0.00000000000000E 000
HotAmp1CPUId 2
HotAmp2CPUId 0
HotAmp3CPUId 0
HotAmp1IO 0.00000000000000E 000
HotAmp2IO 0.00000000000000E 000
HotAmp3IO 0.00000000000000E 000
HotAmp1IOId 0
HotAmp2IOId 0
HotAmp3IOId 0
LowAmp1CPU 0.00000000000000E 000
LowAmp2CPU 0.00000000000000E 000
LowAmp3CPU 0.00000000000000E 000
LowAmp1CPUId 3
LowAmp2CPUId 1
LowAmp3CPUId 0
LowAmp1IO 0.00000000000000E 000
LowAmp2IO 0.00000000000000E 000
LowAmp3IO 0.00000000000000E 000
LowAmp1IOId 2
LowAmp2IOId 3
LowAmp3IOId 1
AvgAmpCPUSec 1.00000000000000E-003
AvgAmpIOCnt 0.00000000000000E 000
AmpCount 4
TempSpaceUsg 0.00000000000000E 000
ReqStartTime 2016/04/29 11:45:44.00
ReqCPU 4.00000000000000E-003
ReqIO 0.00000000000000E 000
ReqNo 3
WlcId 0
DontReclassifyFlag 255
ProxyUser
CPUDecayLevel 0
IODecayLevel 0
TacticalCPUException 0
TacticalIOException 0
ReqIOKB 0.00000000000000E 000
ReqPhysIO 0.00000000000000E 000
ReqPhysIOKB 0.00000000000000E 000
ReqStepsCompletedCnt 0
RedriveProtection MN
CurrentRedriveParticipation F
ReqRedriveSpoolSpace 0.00000000000000E 000
BlockerSessionCnt 0
ReqTblOpBytesIn 0.00000000000000E 000
ReqTblOpBytesOut 0.00000000000000E 000
ProxyUserId 0
ZoneId 0
ReqHotAmpCPU 4.00000000000000E-003
ReqHotAmpCPUId 2
ReqHotAmpIO 0.00000000000000E 000
ReqHotAmpIOId 0
ReqInvolvedAMPCnt 4
ReqFirstRespTime 0000/00/00 00:00:00.00
ReqLocalQueryStatus 0
ReqRemoteHostId 0
ReqRemoteSessionId 0
ReqRemoteRequestId 0
ReqRemoteQueryId 0.00000000000000E 000
ReqHotAmpSpool 0.00000000000000E 000
ReqHotAmpSpoolId 0
ReqMapNo 0
ReqMaxNumMapAMPs 0
ReqMinNumMapAMPs 0
ReqSysDefNumMapAMPs 0
ReqRemoteHostIp
ReqServerName
ReqFlexReleased 0