Changes to the data model for DB2®

Views

The following views have been changed :
  • EVENT_TYPES_V
    • Added column EVENT_EXP_CONTEXT.CONTEXT_DATA_TYPE

Sequences

The following existing Sequence has been updated:
  • EVENT_ID_SEQ
    • the INCREMENT value has been changed from 1 to 1000

Configuration Data

The following update has been made to reflect the change made to the EVENT_ID_SEQ Sequence above:
  • VALUE Key=EVENT_ID_SEQ_INCREMENT
    • the value of the EVENT_ID_SEQ_INCREMENT VALUE key has been updated to 1000

Stored procedures

The following existing stored procedures have been updated:
Note: GRANT statements will need to be re-applied after these Stored| procedures are updated.
  • UPSERT_COUNTER
    • the datatype specification for the DEC input parameter(destined for the COUNTER.COUNT column) has been changed from DECIMAL to DECIMAL(31,4)