Changes to the Data Model for DB2

Tables

  • CHANNEL: Column PARAM length changed from 200 to 800.
  • H_CHANNEL: Column PARAM length changed from 200 to 800.
  • OUT_REQ_CORREL: The following new columns have been added :
    • REQ_TIME(TIMESTAMP)
    • SRVC_PTC_ID(BIGINT)
    • MASTER_PT_ID(BIGINT)
    • TIMEOUT(TIMESTAMP)
    • RESEND_TIME(TIMESTAMP)
    • FINAL_ACK_RESP_TIME(TIMESTAMP)
    • INTERIM_ACK_RESP_TIME(TIMESTAMP)
    • FINAL_ACK_TIME(TIMESTAMP)
    • INTERIM_ACK_TIME(TIMESTAMP)

Indexes

The following new index has been added :
  • TIMEOUT_IDX on the OUT_REQ_CORREL table.

Triggers

The following existing trigger has been updated :
  • FRAGMENT_V_INSERT

Stored Procedures

The following new Stored Procedures have been created :
  • UPSERT_COUNTER
The following existing Stored Procedures have been updated :
  • UPSERT_CAL_OBJ_REL
  • SET_PENDING
  • SET_DELETE_FLAG
  • UPSERT_OBJ_VALUE

Functions

The following new functions have been created :
  • FTM_UTC_TIMESTAMP
The following existing functions have been updated :
  • CONVERT_MODEL_TS_TO_UTC
  • FTM_TIMESTAMP
Note: As the commonly used FTM_TIMESTAMP() function was updated, a number of existing database objects had to be dropped and recreated.