odbtools/odbctest/mql/bench/event/11alert_insert_del.mql

delete from /bench/event/alerts_status1 with version 
;

insert into /bench/event/alerts_status1 (acknowledged, admin, adminphone, agent, alarmkey, alarmtype, alertgroup, alertkey, alertsubtype, alerttype, area, bname, bsm_classname, bsm_identity, bsm_subidentity, businessimpact, bussinesscategory, causetype, ccpc, ccpcbank, chineseflag, ciid, cmdbenrichstatus, cname, cnsummary, contact, contactman, contactphone, corrscore, customer, deviceios, devicelocation, devicemodel, devicepurpose, devicetype, domaingroup, domainsubgroup, duration, emailstatus, entity, eventclass, eventid, eventstatus, eventtime, eventtype, evtproccode, expiretime, explain, extendedattr, firstoccurrence, flag, flash, grade, id, identifier, idname, impactflag, instance, internallast, itmdisplayitem, lastoccurrence, ld_smsflag, localnodealias, localobjrelate, localpriobj, localrootobj, localsecobj, localtertobj, location, logticket, lpar, machineid, maintainstatus, maintenance, manager, market, msg_id, n_maintenance_status, name, netype, nmoscausetype, nmosdomainname, nmosentityid, nmoseventmap, nmosmanagedstatus, nmosobjinst, nmosserial, node, nodealias, nodename, nodetype, objectfullname, oldrow, omni_class, omni_serial, orgcode, origin_class, originalseverity, originalsummary, ownergid, owneruid, phone, physicalcabinet, physicalcard, physicallocation, physicalport, physicalslot, plateng, platform, policylevel, policyname, poll, probesubsecondid, processreq, recordtime, region, remotenodealias, remoteobjrelate, remotepriobj, remoterootobj, remotesecobj, remotetertobj, resolve, rowserial, servername, serverserial, service, servicenowerrorcode, servicenowstate, servicenowsysid, severity, siteid, situationfullname, smsflag, statechange, status, submodel, subsystem, summary, suppressescl, syscode, sysplex, tags, tally, tasklist, ticketstatus, tiggerflag, tsrmflag, ttnumber, ttstate, ttuser, type, upgradeflag, url, vtime, x733corrnotif, x733eventtype, x733probablecause, x733specificprob) values (null, null, null, null, '', 'NA', null, null, 'NA', null, null, null, null, null, null, null, 'tivoli监控平台', null, null, null, null, null, null, 'OMNIBUS服务器', null, null, '韩旭扬', '18840900596', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1752202294000, null, null, null, '102760763574700{%d,mqli}', '10.1.81.124 root: this is a test
10.1.81.124', null, 1, null, null, null, 1752205967000, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '10276076357470077220', null, null, null, null, null, null, null, null, '10.1.81.124', null, null, null, null, null, null, 541322097, null, 200, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 541322097, null, null, null, null, 1, null, null, null, null, null, null, null, 'Jul 11 11:52:47 10.1.81.124 root: this is a test
', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
/**
output()
loop(1000) 
parallel(5)
fork(a)
**/
;

insert into /bench/event/alerts_status1 (acknowledged, admin, adminphone, agent, alarmkey, alarmtype, alertgroup, alertkey, alertsubtype, alerttype, area, bname, bsm_classname, bsm_identity, bsm_subidentity, businessimpact, bussinesscategory, causetype, ccpc, ccpcbank, chineseflag, ciid, cmdbenrichstatus, cname, cnsummary, contact, contactman, contactphone, corrscore, customer, deviceios, devicelocation, devicemodel, devicepurpose, devicetype, domaingroup, domainsubgroup, duration, emailstatus, entity, eventclass, eventid, eventstatus, eventtime, eventtype, evtproccode, expiretime, explain, extendedattr, firstoccurrence, flag, flash, grade, id, identifier, idname, impactflag, instance, internallast, itmdisplayitem, lastoccurrence, ld_smsflag, localnodealias, localobjrelate, localpriobj, localrootobj, localsecobj, localtertobj, location, logticket, lpar, machineid, maintainstatus, maintenance, manager, market, msg_id, n_maintenance_status, name, netype, nmoscausetype, nmosdomainname, nmosentityid, nmoseventmap, nmosmanagedstatus, nmosobjinst, nmosserial, node, nodealias, nodename, nodetype, objectfullname, oldrow, omni_class, omni_serial, orgcode, origin_class, originalseverity, originalsummary, ownergid, owneruid, phone, physicalcabinet, physicalcard, physicallocation, physicalport, physicalslot, plateng, platform, policylevel, policyname, poll, probesubsecondid, processreq, recordtime, region, remotenodealias, remoteobjrelate, remotepriobj, remoterootobj, remotesecobj, remotetertobj, resolve, rowserial, servername, serverserial, service, servicenowerrorcode, servicenowstate, servicenowsysid, severity, siteid, situationfullname, smsflag, statechange, status, submodel, subsystem, summary, suppressescl, syscode, sysplex, tags, tally, tasklist, ticketstatus, tiggerflag, tsrmflag, ttnumber, ttstate, ttuser, type, upgradeflag, url, vtime, x733corrnotif, x733eventtype, x733probablecause, x733specificprob) values (null, null, null, null, '', 'NA', null, null, 'NA', null, null, null, null, null, null, null, 'tivoli监控平台', null, null, null, null, null, null, 'PROBE服务器', null, null, '韩旭扬', '18840900596', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1752202294000, null, null, null, '102760763574700{%d,mqli}', '10.1.81.124 root: this is a test
10.1.81.124', null, 1, null, null, null, 1752205967000, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '10276076357470077220', null, null, null, null, null, null, null, null, '10.1.81.124', null, null, null, null, null, null, 541322097, null, 200, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 541322097, null, null, null, null, 1, null, null, null, null, null, null, null, 'Jul 11 11:52:47 10.1.81.124 root: this is a test
', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
/**
output()
loop(1000) 
parallel(10)
fork(b)
**/
;

select * from /bench/event/alerts_status1 limit -1
/**
wait(b)
count(1000)
**/
;