REPLACE FUNCTION syslib.MONITORSESSION (HostIdIn INTEGER, UserNameIn TD_ANYTYPE, SessionNoIn INTEGER) RETURNS TABLE (HostId SMALLINT, SessionNo INTEGER, LogonPENo SMALLINT, RunVprocNo SMALLINT, PartName VARCHAR(16) CHARACTER SET LATIN, PEstate VARCHAR(18) CHARACTER SET LATIN, LogonTime VARCHAR(22) CHARACTER SET LATIN, UserId INTEGER, LSN INTEGER, UserName VARCHAR(128) CHARACTER SET UNICODE, UserAccount VARCHAR(128) CHARACTER SET UNICODE, PECPUsec FLOAT, XActCount FLOAT, ReqCount FLOAT, ReqCacheHits FLOAT, AMPState VARCHAR(18) CHARACTER SET LATIN, AMPCPUSec FLOAT, AMPIO FLOAT, ReqSpool FLOAT, Blk1HostId SMALLINT, Blk1SessNo INTEGER, Blk1UserId INTEGER, Blk1Lmode CHAR(1) CHARACTER SET LATIN, Blk1Otype CHAR(2) CHARACTER SET LATIN, Blk1ObjDBID INTEGER, Blk1ObjTID INTEGER, Blk1Status CHAR(1) CHARACTER SET LATIN, Blk2HostId SMALLINT, Blk2SessNo INTEGER, Blk2UserId INTEGER, Blk2Lmode CHAR(1) CHARACTER SET LATIN, Blk2Otype CHAR(2) CHARACTER SET LATIN, Blk2ObjDBID INTEGER, Blk2ObjTID INTEGER, Blk2Status CHAR(1) CHARACTER SET LATIN, Blk3HostId SMALLINT, Blk3SessNo INTEGER, Blk3UserId INTEGER, Blk3Lmode CHAR(1) CHARACTER SET LATIN, Blk3Otype CHAR(2) CHARACTER SET LATIN, Blk3ObjDBID INTEGER, Blk3ObjTID INTEGER, Blk3Status CHAR(1) CHARACTER SET LATIN, MoreBlockers CHAR(1) CHARACTER SET LATIN, LogonSource VARCHAR(128) CHARACTER SET UNICODE, HotAmp1CPU FLOAT, HotAmp2CPU FLOAT, HotAmp3CPU FLOAT, HotAmp1CPUId SMALLINT, HotAmp2CPUId SMALLINT, HotAmp3CPUId SMALLINT, HotAmp1IO FLOAT, HotAmp2IO FLOAT, HotAmp3IO FLOAT, HotAmp1IOId SMALLINT, HotAmp2IOId SMALLINT, HotAmp3IOId SMALLINT, LowAmp1CPU FLOAT, LowAmp2CPU FLOAT, LowAmp3CPU FLOAT, LowAmp1CPUId SMALLINT, LowAmp2CPUId SMALLINT, LowAmp3CPUId SMALLINT, LowAmp1IO FLOAT, LowAmp2IO FLOAT, LowAmp3IO FLOAT, LowAmp1IOId SMALLINT, LowAmp2IOId SMALLINT, LowAmp3IOId SMALLINT, AvgAmpCPUSec FLOAT, AvgAmpIOCnt FLOAT, AmpCount SMALLINT, TempSpaceUsg FLOAT, ReqStartTime VARCHAR(22) CHARACTER SET LATIN, ReqCPU FLOAT, ReqIO FLOAT, ReqNo INTEGER, WlcId INTEGER, DontReclassifyFlag SMALLINT, ProxyUser VARCHAR(128) CHARACTER SET UNICODE, CPUDecayLevel SMALLINT, IODecayLevel SMALLINT, TacticalCPUException INTEGER, TacticalIOException INTEGER, ReqIOKB FLOAT, ReqPhysIO FLOAT, ReqPhysIOKB FLOAT, ReqStepsCompletedCnt INTEGER, RedriveProtection CHAR(2) CHARACTER SET LATIN, CurrentRedriveParticipation CHAR(1) CHARACTER SET LATIN, ReqRedriveSpoolSpace FLOAT, BlockerSessionCnt SMALLINT, ReqTblOpBytesIn FLOAT, ReqTblOpBytesOut FLOAT, ProxyUserId INTEGER, ZoneId INTEGER, ReqHotAmpCPU FLOAT, ReqHotAmpCPUId SMALLINT, ReqHotAmpIO FLOAT, ReqHotAmpIOId SMALLINT, ReqInvolvedAMPCnt SMALLINT, ReqFirstRespTime VARCHAR(22) CHARACTER SET LATIN, ReqLocalQueryStatus SMALLINT, ReqRemoteHostId SMALLINT, ReqRemoteSessionId INTEGER, ReqRemoteRequestId INTEGER, ReqRemoteQueryId FLOAT, ReqHotAmpSpool FLOAT, ReqHotAmpSpoolId SMALLINT, ReqMapNo SMALLINT, ReqMaxNumMapAMPs INTEGER, ReqMinNumMapAMPs INTEGER, ReqSysDefNumMapAMPs INTEGER, ReqRemoteHostIp VARCHAR(128) CHARACTER SET UNICODE, ReqServerName VARCHAR(128) CHARACTER SET UNICODE, ReqFlexReleased SMALLINT, ReqAdmissionTime VARCHAR(22) CHARACTER SET LATIN , QueryID DECIMAL(18,0), CollectionTime TIMESTAMP(6)) SPECIFIC MonitorSession LANGUAGE C NO SQL NO EXTERNAL DATA PARAMETER STYLE SQL NOT DETERMINISTIC CALLED ON NULL INPUT TRUSTTYPE TRUSTED EXTERNAL NAME 'SL!api!F!MonitorSession_U'