Exec Time (hhhh:mm:ss.ms) ------------------------------------------------------------------- Exec Total Min Max Avg FirstSeen LastSeen --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Run(eDRP_COMMAND_REXX_COMMAND_EVENT_MON_SET(580)) 1 0.785 0.785 0.785 0.785 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 EvMon::RexxCommandEventMonSet 1 0.785 0.785 0.785 0.785 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 EvMon::RexxCommandEventMonSet - GetClassFromDataRecordPacket_Impl 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 EvMon::RexxCommandEventMonSet_Impl 1 0.785 0.785 0.785 0.785 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 EvMon::RexxCommandEventMonSet_Impl - SetLockDef_Impl 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 EvMon::RexxCommandEventMonSet_Impl - SetLock_Impl 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 EvMon::RexxCommandEventMonSet_Impl - CheckEUInitialization_Impl 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 EvMon::RexxCommandEventMonSet_Impl - GetEUData 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 EvMon::RexxCommandEventMonSet_Impl - GetEUStatusWithFilter 1 0.138 0.138 0.138 0.138 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 db_select_eu_status_with_filter 1 0.138 0.138 0.138 0.138 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 db_select_eu_status_with_filter - HasEUStatusTheFollowingColumns 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 db_select_eu_status_with_filter - Format1 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 db_select_eu_status_with_filter - Build and execute statement 1 0.138 0.138 0.138 0.138 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 db_select_eu_status_with_filter - cmd.Execute 1 0.137 0.137 0.137 0.137 18.11.2016 14:11:59.022 18.11.2016 14:11:59.022 ImyCursor::Execute1 - param markers to bound values 10 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ImyCursor::Execute1 - vor SACriticalSectionScope 10 0.778 0.000 0.158 0.077 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ImyCursor::Execute1 - g_myAPI.mysql_real_query - 3639485 1 0.137 0.137 0.137 0.137 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ########################################################################################## SQL-Statement 1 - SELECT select UniqueEventUnitID, ModifyTime, LMByHostName, LMByHandlerName, LMByZISUserID, LMByUniqueID, ModifyCounter, CreateTime, EventUnitState, case When EventUnitState = 10 then 10 When AcknowledgeFlag = '1' then 41 When RevisionFlag = '1' then 11 When AcknowledgeFlag = '0' then EventUnitState end as VirtualEventUnitState, UserDefinedEventUnitID, StateText, ZISSourceDescData, ZISSourceOTypNr, ZISSourceRBNr, AcknowledgeFlag, RevisionFlag, RepeatCounter, HelpFileName, HasEventUnitTMOAction, TMOActionDateTime, TMOSetAcknowledgeFlag, TMONewAcknowledgeFlag, TMOSetRevisionFlag, TMONewRevisionFlag, TMOSetEventUnitState, TMONewEventUnitState, TMOEventUnitTMOAction, ProductInterfaceType, ProductInterfaceID, UniqueProductInterfaceEventID, CreatorZISSourceDescData, Description, EventAttributesDictionary, EventAttributes, UserDefinedREXXLabelMenuName, DeleteTime, DeleterZISSourceDescData, AcknowledgeTime, AcknowledgerZISSourceDescData, EventRawDataType, EventRawData from EUStatus00000123868_Pending where UserDefinedEventUnitID = '15514' order by ModifyTime DESC, UniqueEventUnitID DESC ImyCursor::Execute - GetRowsAffected 10 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.000 18.11.2016 14:12:00.000 ImyCursor::Execute - g_myAPI.mysql_store_result 10 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.000 18.11.2016 14:12:00.000 ImyCursor::Execute - Check 6 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.000 18.11.2016 14:12:00.000 db_select_eu_status_with_filter - db_fetch_eu_status 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.036 18.11.2016 14:11:59.036 EvMon::RexxCommandEventMonSet_Impl - GetEUStatusContainerForUpdate_Impl 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.036 18.11.2016 14:11:59.036 EvMon::RexxCommandEventMonSet_Impl - UpdatePendingWithResponse_Impl 1 0.645 0.645 0.645 0.645 18.11.2016 14:11:59.036 18.11.2016 14:11:59.036 EvMon::UpdatePending_Impl 1 0.644 0.644 0.644 0.644 18.11.2016 14:11:59.036 18.11.2016 14:11:59.036 ImyCursor::Execute1 - g_myAPI.mysql_real_query - 3639641 1 0.146 0.146 0.146 0.146 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ########################################################################################## SQL-Statement 2 - SELECT select UniqueEventUnitID, ModifyTime, LMByHostName, LMByHandlerName, LMByZISUserID, LMByUniqueID, ModifyCounter, CreateTime, EventUnitState, EventUnitState, UserDefinedEventUnitID, StateText, ZISSourceDescData, ZISSourceOTypNr, ZISSourceRBNr, AcknowledgeFlag, RevisionFlag, RepeatCounter, HelpFileName, HasEventUnitTMOAction, TMOActionDateTime, TMOSetAcknowledgeFlag, TMONewAcknowledgeFlag, TMOSetRevisionFlag, TMONewRevisionFlag, TMOSetEventUnitState, TMONewEventUnitState, TMOEventUnitTMOAction, ProductInterfaceType, ProductInterfaceID, UniqueProductInterfaceEventID, CreatorZISSourceDescData, Description, EventAttributesDictionary, EventAttributes, UserDefinedREXXLabelMenuName, DeleteTime, DeleterZISSourceDescData, AcknowledgeTime, AcknowledgerZISSourceDescData, EventRawDataType, EventRawData from EUStatus00000123868_Pending where UniqueEventUnitID = 1 ImyCursor::Execute1 - g_myAPI.mysql_real_query - 3639749 1 0.059 0.059 0.059 0.059 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ########################################################################################## SQL statement 3 - SELECT select MarkedAsDeleted from ExecuterDef where RBNr = :1 ImyCursor::Execute1 - g_myAPI.mysql_real_query - 3639796 1 0.060 0.060 0.060 0.060 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ########################################################################################## SQL statement 4 - SELECT select distinct a.RBNr, a.OTypNr, a.RelNr, a.Active, a.Name, a.Description, a.ZISObjectType, a.VersNr, a.LastModified, a.LMByHostName, a.LMByHandlerName, a.LMByZISUserID, a.LMByUniqueID, a.MarkedAsDeleted, a.MsgID, a.IsSynchronized, a.ZISUniversalIDCreateTimeSec, a.ZISUniversalIDCreateTimeUSec, a.ZISUniversalIDCycleCount, a.DisplayNamesBinaryStream, a.ZISProcessDefRBNr from ExecuterDef as a where a.RBNr = :1 and a.OTypNr = :2 EvMon::UpdatePending_Impl - cTransaction.ExecuteWithRetry 1 0.215 0.215 0.215 0.215 18.11.2016 14:11:59.063 18.11.2016 14:11:59.063 ImyCursor::Execute1 - g_myAPI.mysql_real_query - 3639835 1 0.002 0.002 0.002 0.002 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ########################################################################################## SQL statement 5 - BEGIN Additional Info: begin ImyCursor::Execute - NextResult 4 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 db_update_eu_status 1 0.213 0.213 0.213 0.213 18.11.2016 14:11:59.063 18.11.2016 14:11:59.063 db_internal_update_eu_status 1 0.213 0.213 0.213 0.213 18.11.2016 14:11:59.063 18.11.2016 14:11:59.063 db_internal_update_eu_status - vor DB_LT_TRY 1 0.085 0.085 0.085 0.085 18.11.2016 14:11:59.063 18.11.2016 14:11:59.063 db_internal_update_eu_status - HasEUStatusTheFollowingColumns 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.063 18.11.2016 14:11:59.063 db_internal_update_eu_status - cmd.Execute() 1 0.085 0.085 0.085 0.085 18.11.2016 14:11:59.063 18.11.2016 14:11:59.063 ImyCursor::Execute1 - g_myAPI.mysql_real_query - 3639839 1 0.084 0.084 0.084 0.084 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ########################################################################################## SQL statement 6 - UPDATE update EUStatus00000123868_Pending set ModifyTime = :1, LMByHostName = :81, LMByHandlerName = :82, LMByZISUserID = :83, LMByUniqueID = :84, ModifyCounter = :2, EventUnitState = :3, UserDefinedEventUnitID = :4, StateText = :5, ZISSourceDescData = :7, ZISSourceOTypNr = :8, ZISSourceRBNr = :9, AcknowledgeFlag = :10, RevisionFlag = :11, RepeatCounter = :12, HelpFileName = :13, HasEventUnitTMOAction = :14, TMOActionDateTime = :15, TMOSetAcknowledgeFlag = :16, TMONewAcknowledgeFlag = :17, TMOSetRevisionFlag = :18, TMONewRevisionFlag = :19, TMOSetEventUnitState = :20, TMONewEventUnitState = :21, TMOEventUnitTMOAction = :22, ProductInterfaceType = :120, ProductInterfaceID = :121, UniqueProductInterfaceEventID = :122, Description = :130, EventAttributesDictionary = :180, EventAttributes = :181, UserDefinedREXXLabelMenuName = :150, AcknowledgeTime = :164, AcknowledgerZISSourceDescData = :165, AcknowledgerZISSourceOTypNr = :166, AcknowledgerZISSourceRBNr = :167, EventRawDataType = :170, EventRawData = :171 where UniqueEventUnitID = :23 db_internal_update_eu_status - db_set_cache_id_of_eu_status() 1 0.127 0.127 0.127 0.127 18.11.2016 14:11:59.072 18.11.2016 14:11:59.072 ImyCursor::Execute1 - g_myAPI.mysql_real_query - 3639954 1 0.127 0.127 0.127 0.127 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ########################################################################################## SQL statement 7 - SELECT Additional Info: select CreateTime, ModifyTime, ModifyCounter from EUStatus00000123868_Pending where UniqueEventUnitID = :1 db_internal_update_eu_status - db_delete_event_unit_tmo_action() 1 0.000 0.000 0.000 0.000 18.11.2016 14:11:59.084 18.11.2016 14:11:59.084 ImyCursor::Execute1 - g_myAPI.mysql_real_query - 3640085 1 0.001 0.001 0.001 0.000 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ########################################################################################## SQL statement 8 - DELETE Additional Info: delete from EventUnitTMOAction where EventUnitDefRBNr = :1 and UniqueEventUnitID = :2 ImyCursor::Execute1 - g_myAPI.mysql_real_query - 3640086 1 0.001 0.001 0.001 0.000 18.11.2016 14:11:59.000 18.11.2016 14:11:59.000 ########################################################################################## SQL statement 9 - COMMIT Additional Info: commit EvMon::UpdatePending_Impl - CalculateCurrentState_Impl 1 0.160 0.160 0.160 0.160 18.11.2016 14:11:59.084 18.11.2016 14:11:59.084 EvMon::UpdatePending_Impl - CheckForTriggerReactionEUStatusWasModified 1 0.000 0.000 0.000 0.000 18.11.2016 14:12:00.000 18.11.2016 14:12:00.000 EvMon::UpdatePending_Impl - CheckForTriggerReactionEUStatusWasAcknowledged 1 0.000 0.000 0.000 0.000 18.11.2016 14:12:00.000 18.11.2016 14:12:00.000 EvMon::UpdatePending_Impl - CheckForTriggerReactionCurrentEUStatusHasChanged 1 0.000 0.000 0.000 0.000 18.11.2016 14:12:00.000 18.11.2016 14:12:00.000 EvMon::UpdatePendingWithResponse_Impl - cDataDRPProtocol.UpdatePendingResponse 1 0.000 0.000 0.000 0.000 18.11.2016 14:12:00.000 18.11.2016 14:12:00.000 EvMon::UpdatePendingWithResponse_Impl - cDataDRPProtocol.RexxCommandEventMonSetResponse 1 0.000 0.000 0.000 0.000 18.11.2016 14:12:00.000 18.11.2016 14:12:00.000 ------------------------------------------------------------------------------------------------------------- show create table eventmonitor.EUStatus00000123868_Pending; 'CREATE TABLE `eustatus00000123868_pending` ( `UniqueEventUnitID` int(11) NOT NULL, `LMByHostName` varchar(255) DEFAULT ''?'', `LMByHandlerName` varchar(80) DEFAULT ''?'', `LMByZISUserID` varchar(80) DEFAULT ''?'', `LMByUniqueID` int(11) DEFAULT ''0'', `ModifyTime` datetime DEFAULT ''2004-01-01 00:00:00'', `ModifyCounter` int(11) DEFAULT ''0'', `CreateTime` datetime DEFAULT ''2004-01-01 00:00:00'', `EraseTime` datetime DEFAULT ''2004-01-01 00:00:00'', `EventUnitState` smallint(6) DEFAULT ''0'', `UserDefinedEventUnitID` varchar(80) DEFAULT '''', `StateText` text, `ZISSourceDescData` blob, `ZISSourceOTypNr` int(11) DEFAULT ''0'', `ZISSourceRBNr` int(11) DEFAULT ''0'', `AcknowledgeFlag` tinyint(4) DEFAULT ''0'', `RevisionFlag` tinyint(4) DEFAULT ''0'', `RepeatCounter` int(11) DEFAULT ''0'', `HelpFileName` varchar(255) DEFAULT '''', `HasEventUnitTMOAction` tinyint(4) DEFAULT ''0'', `TMOActionDateTime` datetime DEFAULT NULL, `TMOSetAcknowledgeFlag` tinyint(4) DEFAULT NULL, `TMONewAcknowledgeFlag` tinyint(4) DEFAULT NULL, `TMOSetRevisionFlag` tinyint(4) DEFAULT NULL, `TMONewRevisionFlag` tinyint(4) DEFAULT NULL, `TMOSetEventUnitState` smallint(6) DEFAULT NULL, `TMONewEventUnitState` smallint(6) DEFAULT NULL, `TMOEventUnitTMOAction` tinyint(4) DEFAULT NULL, `ProductInterfaceType` tinyint(4) DEFAULT NULL, `ProductInterfaceID` varchar(80) DEFAULT NULL, `UniqueProductInterfaceEventID` varchar(255) DEFAULT NULL, `CreatorZISSourceDescData` blob, `CreatorZISSourceOTypNr` int(11) DEFAULT NULL, `CreatorZISSourceRBNr` int(11) DEFAULT NULL, `Description` text, `UserDefinedREXXLabelMenuName` varchar(80) DEFAULT NULL, `AcknowledgeTime` datetime DEFAULT NULL, `AcknowledgerZISSourceDescData` blob, `AcknowledgerZISSourceOTypNr` int(11) DEFAULT NULL, `AcknowledgerZISSourceRBNr` int(11) DEFAULT NULL, `DeleteTime` datetime DEFAULT NULL, `DeleterZISSourceDescData` blob, `DeleterZISSourceOTypNr` int(11) DEFAULT NULL, `DeleterZISSourceRBNr` int(11) DEFAULT NULL, `EventRawDataType` int(11) DEFAULT NULL, `EventRawData` longblob, `EventAttributesDictionary` blob, `EventAttributes` longblob, PRIMARY KEY (`UniqueEventUnitID`), KEY `NCI_EUS00000123868_P_UserDefID` (`UserDefinedEventUnitID`), KEY `NCI_EUS00000123868_P_ModifyTime` (`ModifyTime`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1' show create table zissystem.ExecuterDef; 'CREATE TABLE `executerdef` ( `RBNr` int(11) NOT NULL, `OTypNr` int(11) NOT NULL DEFAULT ''1000'', `RelNr` int(11) NOT NULL, `Name` varchar(80) NOT NULL, `Description` varchar(255) DEFAULT NULL, `ZISObjectType` smallint(6) NOT NULL DEFAULT ''0'', `Active` smallint(6) NOT NULL DEFAULT ''0'', `LastModified` datetime NOT NULL DEFAULT ''2004-01-01 00:00:00'', `LMByHostName` varchar(255) DEFAULT ''?'', `LMByHandlerName` varchar(80) DEFAULT ''?'', `LMByZISUserID` varchar(80) DEFAULT ''?'', `LMByUniqueID` int(11) DEFAULT ''0'', `VersNr` int(11) NOT NULL DEFAULT ''0'', `MarkedAsDeleted` smallint(6) NOT NULL DEFAULT ''0'', `MsgID` int(11) DEFAULT ''0'', `IsSynchronized` smallint(6) NOT NULL DEFAULT ''0'', `ZISUniversalIDCreateTimeSec` bigint(20) NOT NULL DEFAULT ''0'', `ZISUniversalIDCreateTimeUSec` int(11) NOT NULL DEFAULT ''0'', `ZISUniversalIDCycleCount` bigint(20) NOT NULL DEFAULT ''0'', `LastAssignedUniqueTriggerNr` int(11) DEFAULT ''0'', `ZISObjectWasBuildFromTemplate` smallint(6) DEFAULT ''0'', `CtgryItmsBlngng2ZISObjBnryStrm` blob, `DisplayNamesBinaryStream` blob, `ZISProcessDefRBNr` int(11) DEFAULT ''0'', PRIMARY KEY (`RBNr`), UNIQUE KEY `NCI_ExecuterDef_ZISUniversalID` (`ZISUniversalIDCreateTimeSec`,`ZISUniversalIDCreateTimeUSec`,`ZISUniversalIDCycleCount`), KEY `NCI_ExecuterDef_RelNr_ZOT_MAD` (`RelNr`,`ZISObjectType`,`MarkedAsDeleted`), KEY `NCI_ExecuterDef_Name_ZOT_MAD` (`Name`,`ZISObjectType`,`MarkedAsDeleted`), KEY `NCI_ExecuterDef_MSGID` (`MsgID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1' show create table eventmonitor.EventUnitTMOAction; 'CREATE TABLE `eventunittmoaction` ( `EventUnitDefRBNr` int(11) NOT NULL DEFAULT ''0'', `UniqueEventUnitID` int(11) NOT NULL DEFAULT ''0'', `ModifyCounter` int(11) NOT NULL DEFAULT ''0'', `ActionDateTime` datetime DEFAULT NULL, `SetAcknowledgeFlag` tinyint(4) DEFAULT NULL, `NewAcknowledgeFlag` tinyint(4) DEFAULT NULL, `SetRevisionFlag` tinyint(4) DEFAULT NULL, `NewRevisionFlag` tinyint(4) DEFAULT NULL, `SetEventUnitState` tinyint(4) DEFAULT NULL, `NewEventUnitState` smallint(6) DEFAULT NULL, `EventUnitTMOAction` tinyint(4) DEFAULT NULL, PRIMARY KEY (`EventUnitDefRBNr`,`UniqueEventUnitID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1'