Ensuring data integrity

 

DB2® UDB for iSeries™ provides several integrity measures, such as constraints, trigger programs, and commitment control.

Protecting your database against inadvertent insertions, deletions, and updates is accomplished using commitment control, constraints, and triggers. Constraints basically govern how data values can change, while triggers are automatic actions that start, or trigger, an event, such as an update of a specific table.

 

Parent topic:

Database administration

Related concepts
Commitment control Working with triggers and constraints