API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 26th, 2015
416
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.97 KB | None | 0 0
raw download clone embed print report
  1.  
  2. Alert Configuration
  3.  
  4. Indicator Name = db.db_op_status
  5. Default = Yes
  6. Type = State-based
  7. Sensitivity = 0
  8. Formula = db.db_status;
  9. Actions = Disabled
  10. Threshold or State checking = Enabled
  11.  
  12. Indicator Name = db.sort_shrmem_util
  13. Default = Yes
  14. Type = Threshold-based
  15. Warning = 70
  16. Alarm = 85
  17. Unit = %
  18. Sensitivity = 0
  19. Formula = ((db.sort_shrheap_allocated/sheapthres_shr)*100);
  20. Actions = Disabled
  21. Threshold or State checking = Disabled
  22.  
  23. Indicator Name = db.spilled_sorts
  24. Default = Yes
  25. Type = Threshold-based
  26. Warning = 30
  27. Alarm = 50
  28. Unit = %
  29. Sensitivity = 0
  30. Formula = ((delta(db.sort_overflows,10))/(delta(db.total_sorts,10)+1)*100);
  31. Actions = Disabled
  32. Threshold or State checking = Disabled
  33.  
  34. Indicator Name = db.max_sort_shrmem_util
  35. Default = Yes
  36. Type = Threshold-based
  37. Warning = 60
  38. Alarm = 30
  39. Unit = %
  40. Sensitivity = 0
  41. Formula = ((db.max_shr_sort_mem/sheapthres_shr)*100);
  42. Actions = Disabled
  43. Threshold or State checking = Disabled
  44.  
  45. Indicator Name = db.log_util
  46. Default = Yes
  47. Type = Threshold-based
  48. Warning = 75
  49. Alarm = 85
  50. Unit = %
  51. Sensitivity = 0
  52. Formula = (db.total_log_used/(db.total_log_used+db.total_log_available))*100;
  53. Actions = Disabled
  54. Threshold or State checking = Enabled
  55.  
  56. Indicator Name = db.log_fs_util
  57. Default = Yes
  58. Type = Threshold-based
  59. Warning = 75
  60. Alarm = 85
  61. Unit = %
  62. Sensitivity = 0
  63. Formula = ((os.fs_used/os.fs_total)*100);
  64. Actions = Disabled
  65. Threshold or State checking = Enabled
  66.  
  67. Indicator Name = db.deadlock_rate
  68. Default = Yes
  69. Type = Threshold-based
  70. Warning = 5
  71. Alarm = 10
  72. Unit = Deadlocks per hour
  73. Sensitivity = 0
  74. Formula = delta(db.deadlocks,12);
  75. Actions = Disabled
  76. Threshold or State checking = Enabled
  77.  
  78. Indicator Name = db.locklist_util
  79. Default = Yes
  80. Type = Threshold-based
  81. Warning = 75
  82. Alarm = 85
  83. Unit = %
  84. Sensitivity = 0
  85. Formula = (db.lock_list_in_use/(locklist*4096))*100;
  86. Actions = Disabled
  87. Threshold or State checking = Disabled
  88.  
  89. Indicator Name = db.lock_escal_rate
  90. Default = Yes
  91. Type = Threshold-based
  92. Warning = 5
  93. Alarm = 10
  94. Unit = Lock escalations per hour
  95. Sensitivity = 0
  96. Formula = delta(db.lock_escals,12);
  97. Actions = Disabled
  98. Threshold or State checking = Disabled
  99.  
  100. Indicator Name = db.apps_waiting_locks
  101. Default = Yes
  102. Type = Threshold-based
  103. Warning = 50
  104. Alarm = 70
  105. Unit = %
  106. Sensitivity = 0
  107. Formula = (db.locks_waiting/db.appls_cur_cons)*100;
  108. Actions = Disabled
  109. Threshold or State checking = Disabled
  110.  
  111. Indicator Name = db.pkgcache_hitratio
  112. Default = Yes
  113. Type = Threshold-based
  114. Warning = 80
  115. Alarm = 70
  116. Unit = %
  117. Sensitivity = 0
  118. Formula = (1-(db.pkg_cache_inserts/db.pkg_cache_lookups))*100;
  119. Actions = Disabled
  120. Threshold or State checking = Disabled
  121.  
  122. Indicator Name = db.catcache_hitratio
  123. Default = Yes
  124. Type = Threshold-based
  125. Warning = 80
  126. Alarm = 70
  127. Unit = %
  128. Sensitivity = 0
  129. Formula = (1-(db.cat_cache_inserts/db.cat_cache_lookups))*100;
  130. Actions = Disabled
  131. Threshold or State checking = Disabled
  132.  
  133. Indicator Name = db.shrworkspace_hitratio
  134. Default = Yes
  135. Type = Threshold-based
  136. Warning = 80
  137. Alarm = 70
  138. Unit = %
  139. Sensitivity = 0
  140. Formula = ((1-(db.shr_workspace_section_inserts/db.shr_workspace_section_lookups))*100);
  141. Actions = Disabled
  142. Threshold or State checking = Disabled
  143.  
  144. Indicator Name = db.db_heap_util
  145. Default = Yes
  146. Type = Threshold-based
  147. Warning = 85
  148. Alarm = 95
  149. Unit = %
  150. Sensitivity = 0
  151. Formula = ((db.db_heap_cur_size/db.db_heap_max_size)*100);
  152. Actions = Disabled
  153. Threshold or State checking = Disabled
  154.  
  155. Indicator Name = db.tb_reorg_req
  156. Default = Yes
  157. Type = Collection state-based
  158. Sensitivity = 0
  159. Actions = Disabled
  160. Threshold or State checking = Enabled
  161.  
  162. Indicator Name = db.hadr_op_status
  163. Default = Yes
  164. Type = State-based
  165. Sensitivity = 0
  166. Formula = db.hadr_connect_status;
  167. Actions = Disabled
  168. Threshold or State checking = Enabled
  169.  
  170. Indicator Name = db.hadr_delay
  171. Default = Yes
  172. Type = Threshold-based
  173. Warning = 10
  174. Alarm = 15
  175. Unit = Minutes
  176. Sensitivity = 0
  177. Formula = (db.hadr_log_gap*var.refresh_rate/60)DIV(delta(db.hadr_secondary_log_pos));
  178. Actions = Disabled
  179. Threshold or State checking = Enabled
  180.  
  181. Indicator Name = db.db_backup_req
  182. Default = No
  183. Type = State-based
  184. Sensitivity = 0
  185. Actions = Disabled
  186. Threshold or State checking = Enabled
  187.  
  188. Indicator Name = db.fed_nicknames_op_status
  189. Default = Yes
  190. Type = Collection state-based
  191. Sensitivity = 0
  192. Actions = Disabled
  193. Threshold or State checking = Enabled
  194.  
  195. Indicator Name = db.fed_servers_op_status
  196. Default = Yes
  197. Type = Collection state-based
  198. Sensitivity = 0
  199. Actions = Disabled
  200. Threshold or State checking = Enabled
  201.  
  202. Indicator Name = db.tb_runstats_req
  203. Default = Yes
  204. Type = Collection state-based
  205. Sensitivity = 0
  206. Actions = Disabled
  207. Threshold or State checking = Enabled
  208.  
  209. Indicator Name = db.auto_storage_util
  210. Default = Yes
  211. Type = Threshold-based
  212. Warning = 80
  213. Alarm = 90
  214. Unit = %
  215. Sensitivity = 0
  216. Formula = ((db.auto_storage_used/db.auto_storage_total)*100);
  217. Actions = Disabled
  218. Threshold or State checking = Enabled
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!