1. Implementing Siebel Business Applications on DB2 for z/OS
  2. Naming Conventions for Partitioning Triggers

Naming Conventions for Partitioning Triggers

Partitioning Trigger names comprise eight characters (for example, PTH0401) that consist of three elements in the following order:

  1. The leading two letters must be PT, to designate that this is a partitioning trigger.

  2. The third letter (H, V, or S) designates the product group or component that the trigger belongs to.

    • H represents Horizontal (also known as Core)

    • V represents Vertical (also known as Siebel Industry Applications or SIA).

    • S represents partitioning triggers used for Assignment Manager or other components.

  3. The ending four-digit number uniquely identifies the trigger based on the table number, for example, 0401.

    The trigger name is normally related to a corresponding table space name; for example, the trigger name PTH0401 relates to the table space name H0401000.