Changes to the data model for Db2®

Tables

The following new tables have been added:
  • ID_REFERENCE

Indexes

The following new indexes have been added on the ID_REFERENCE table:
  • CC_ID_UI on columns(OBJ_ID, CATEGORY, KEY)
  • CC_ID_VAL on columns(VALUE, CATEGORY, KEY, CREATED, OBJ_ID)

Columns

The following existing table columns have been altered:
  • The CLASSIFICATION.CODE column changed from CHAR(40) to CHAR(150)
  • The H_CLASSIFICATION.CODE column changed from CHAR(40) to CHAR(150)
Note: These alter column statements put the tables into a REORG PENDING state. Reorganize the table using the REORG TABLE command.

Stored Procedures

The following existing stored procedures have been altered:
  • UPSERT_CLASSIFICATION: input parameter CODE changed from CHAR(40) to CHAR(150)