Inbox

You should monitor the number of active alerts in the YFS_INBOX table.

Sterling Order Management System Software alerts come from the following source:

• Transactions that are configured to raise alerts
• Monitor (such as the order monitor)

Users subscribed to queues with large number of open alerts can experience slow logins. Very large YFS_INBOX tables can impact login times for all users.

You can find out the number of active and non-active alerts by issuing the following query:

   select active_flag,count(*)
   from yfs_inbox
   group by active_flag
   

You can find out the distribution of alerts by queue name and inbox type by issuing the following query:

   select queue_name, inbox_type, active_flag, count(*)
   from yfs_inbox inb,yfs_queue q
   where inb.queue_key = q.queue_key 
   group by queue_name, inbox_type, active_flag
   

You can find out the hourly rate of alert creation for July 4, 2011 by issuing the following query:

   select substr(inbox_key,1,10),count(*)
   from yfs_inbox
   where inbox_key > '20110704000000' and
         inbox_key < '20110704999999' 
   group by substr(inbox_key,1,10);