Agent throughput

In addition to the data provided by the System Management Console and the Sterling Order Management System Software Statistics, you can also get application processing statistics by data mining the Sterling Order Management System Software database.

This technique takes advantage of the following application characteristics:

  • A record is created in yfs_order_header for every new order.
  • A record is created in yfs_order_line for every order line.
  • A record is created in yfs_order_release_status each time the order line moves through the various states in its lifecycle.
  • An audit record is created in yfs_order_audit each time an order or order line is modified.
  • An audit record is created in yfs_inventory_audit each time an inventory item is modified.
  • Each record has a primary key whose value is made up of two parts:
    • A date/time component in the form of year, month, date, hours, minutes, and seconds. For example, a record that was created on September 21, 2011 at 4:20:14 p.m. has 20110921162014 as the first part of the key.
    • A monotonically-increasing sequence number.

    A different logic is used to generate primary keys for records in the YFS_ORDER_RELEASE_STATUS, YFS_ORDER_LINE_SCHEDULE, and YFS_INVENTORY_DEMAND tables, resulting in random primary keys rather than sequential primary keys being generated. The logic is as follows:

    • The first ten characters comprise the year (YYYY), month (MM), date (DD), and hours (HH).
    • The next two characters are random digits.
    • The next two characters comprise the minutes (MM).
    • The final ten characters comprise a monotonically-increasing sequence number, and may contain two characters for seconds (SS), as follows:
      • If the sequence number that is returned from the database is eight characters or less (for example, NNNNNNNN), the primary key includes two characters for seconds (SS) in addition to the generated sequence number.
      • If the sequence number that is returned from the database is greater than eight characters (for example, NNNNNNNNNN), the seconds (SS) are truncated and the ten-digit sequence number is honored.

    For example, a record that was created for the YFS_INVENTORY_DEMAND table on September 21, 2011 at 4:20:14 p.m. has a primary key of 2011092116RR2014NNNNNNNN (if the sequence number that is returned from the database is eight characters) or 2011092116RR20NNNNNNNNNN (if the sequence number that is returned from the database is greater than eight characters), where RR represents the two random digits and NNNNNNNNNN represents a monotonically-increasing sequence number.

    Note: In sharded environments, the first two characters of the year are replaced by the two-digit prefix for the colony.