Table Alerts allow you to be notified when certain conditions are detected on a monitored table during a IBM Tivoli Storage Resource Manager for Databases scan. You specify the following conditions for triggering a Table alert:
All RDBMSs
when the total size of a table is greater than
a specified amount
when a table is dropped
Oracle
when the maximum extents minus the allocated extents
for a table is less than a specified number of extents
when a segment has more than a specified number
of extents
when a table has a chained row count greater than
a specified percent
when the empty used space within a table segment
exceeds a specified amount
when the total size of a table is greater than
a specified amount
when a table is dropped
SQL Server
when the total size of a table is greater than a specified amount
when a table is dropped
Sybase
when the forwarded row count is greater than a specified amount
when the total size of a table is greater than a specified amount
when a table is dropped
UDB
when the overflow row count is greater than a specified amount
when the total size of a table is greater than a specified amount
when a table is dropped
Field Name |
Description |
Creator |
Displays the creator of the Table Alert job. |
Name |
Displays the name of the Table Alert job you are editing. |
Description |
Specify a description for the Table Alert job you are editing. |
Enabled |
Select this option to enable the job. |