Changes to the data model for DB2®

Tables

  • IN_REQ_CORREL: New table:
    • ID(BIGINT)
    • CORRELATION_KEY(VARCHAR 200)
    • MASTER_ID(BIGINT)
    • REQ_TIME(TIMESTAMP)
    • RECVD_TIME(TIMESTAMP)
    • RESP_DESTINATION(VARCHAR 200)
    • FIRST_RESP_TIME(TIMESTAMP)
    • FINAL_RESP_TIME(TIMESTAMP)
    • FIRST_RESP_TYPE(VARCHAR 100)
    • FINAL_RESP_TYPE(VARCHAR 100)

Indexes

The following new indexes have been added:
  • IN_RCL_PK on the IN_REQ_CORREL.ID column [Primary key].
  • IN_RCL_UI on the IN_REQ_CORREL.MASTER_ID column [Unique index].

Triggers

The following new triggers have been added:
  • T_OUT_REQ_CORREL_RT

Stored procedures

The following existing stored procedures have been updated:
  • UPSERT_VALUE
  • UPSERT_SCHEDULER_TASK