Changes to the data model for Db2®

Tables

The following tables were modified:
  • EVENT
    • DATA column changed to INLINE.
    • ATTEMPT_COUNT column was added.
    • PUBLISHED column was added.
    • PUBLISH_REQ_TIME column was added.
    • PUBLISH_ATTEMPT_COUNT column was added.
  • TRANSMISSION_BASE/H_TRANSMISSION_BASE
    • IDEMPOTENT_KEY column was added.
  • FSM
    • OBJ_SELECT_TEMPLAT column size was changed from 1000 to 2000.
  • FSM_TRANSITION
    • OVERRIDE_SELECTION column size was changed from 1000 to 2000.
  • OBJ_VALUE
    • KEY column size was changed from 40 to 100.
  • EXT_PUB_RULE
    • ISOLATION column was added.

Views

The following views were modified to add the IDEMPOTENT_KEY column:
  • TRANSMISSION_V
  • TRANSMISSION_BASE_V
  • TRANSMISSION_V_UPD

Triggers

The following triggers were modified to add the IDEMPOTENT_KEY column:
  • TRANSMISSION_V_INS
  • TRANSMISSION_V_UPD
  • TRANS_BASE_V_INS
  • TRANS_BASE_V_UPD

Stored procedures

The following stored procedures were modified:
  • UPSERT_OBJ_VALUE key parameter length was changed from 40 to 100.

Indexes

The following indexes were added:
  • New EVT_PUB_IDX index on the EVENT table.