Главная Обзор Помощь
Вход
libf
/
odbtools
1
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Дерево: aae7fb7fc8
Ветки Метки
odbtools
/
odbctest
/
mql
/
bench
/
event
/
11alert_insert_del.mql

11alert_insert_del.mql 19 KB
История Исходник

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495 
  1. 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
    2. 

  2. 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
    3. 

  3. ', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
    4. 

  4. /**
    5. 

  5. loop(1000) 
    6. 

  6. parallel(5)
    7. 

  7. fork(a)
    8. 

  8. **/
    9. 

  9. ;
    10. 

  10. 

  11. 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
    12. 

  12. 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
    13. 

  13. ', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
    14. 

  14. /**
    15. 

  15. loop(1000) 
    16. 

  16. parallel(10)
    17. 

  17. fork(a)
    18. 

  18. **/
    19. 

  19. ;
    20. 

  20. 

  21. select * from /bench/event/alerts_status1 limit -1
    22. 

  22. /**
    23. 

  23. wait(a)
    24. 

  24. count(1000)
    25. 

  25. **/
    26. 

  26. ;
    27. 

  27. 

  28. delete from /bench/event/alerts_status1;
    29. 

  29. /**
    30. 

  30. loop(10) 
    31. 

  31. parallel(10)
    32. 

  32. fork(a)
    33. 

  33. **/
    34. 

  34. ;
    35. 

  35. 

  36. 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
    37. 

  37. 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
    38. 

  38. ', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
    39. 

  39. /**
    40. 

  40. loop(1000) 
    41. 

  41. parallel(5)
    42. 

  42. fork(a)
    43. 

  43. **/
    44. 

  44. ;
    45. 

  45. 

  46. 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
    47. 

  47. 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
    48. 

  48. ', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
    49. 

  49. /**
    50. 

  50. loop(1000) 
    51. 

  51. parallel(10)
    52. 

  52. fork(a)
    53. 

  53. **/
    54. 

  54. ;
    55. 

  55. 

  56. select * from /bench/event/alerts_status1 limit -1
    57. 

  57. /**
    58. 

  58. wait(a)
    59. 

  59. count(1000)
    60. 

  60. **/
    61. 

  61. ;
    62. 

  62. 

  63. delete from /bench/event/alerts_status1;
    64. 

  64. /**
    65. 

  65. output()
    66. 

  66. **/
    67. 

  67. ;
    68. 

  68. 

  69. 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
    70. 

  70. 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
    71. 

  71. ', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
    72. 

  72. /**
    73. 

  73. loop(1000) 
    74. 

  74. parallel(5)
    75. 

  75. fork(a)
    76. 

  76. **/
    77. 

  77. ;
    78. 

  78. 

  79. 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
    80. 

  80. 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
    81. 

  81. ', null, null, null, null, 2, null, null, null, null, null, null, null, 1, null, null, 1752205967289, null, null, null, null)
    82. 

  82. /**
    83. 

  83. loop(1000) 
    84. 

  84. parallel(10)
    85. 

  85. fork(a)
    86. 

  86. **/
    87. 

  87. ;
    88. 

  88. 

  89. select * from /bench/event/alerts_status1 limit -1
    90. 

  90. /**
    91. 

  91. wait(a)
    92. 

  92. count(1000)
    93. 

  93. **/
    94. 

  94. ;
    95. 

  95.