Data model changes

All tables that are under DBCM get a “checked-outs” table. The layout of this table is identical to the normal, or “checked-ins”, table. The name of the “checked-outs” table is identical to the name of the normal table, except that the first “t” is replaced with a “v”. For example, the ttdsls400812 table gets a “checked-outs” table with the name vtdsls400812. The checked-outs table is used to store non-approved, or draft, changes to rows.

All tables that are under DBCM are extended with these columns:

• rcd_toid
• rcd_cmac
• rcd_seqn (Db2 and Microsoft SQL Server)

The values of these columns are maintained by the system. We strongly discourage that you manually modify them.