Data integrity

 

Data integrity protects data from being destroyed or changed by unauthorized persons, system operation or hardware failures (such as physical damage to a disk), programming errors, interruptions before a job is completed (such as a power failure), or interference from running applications at the same time (such as serialization problems).

• Concurrency
  Concurrency is the ability for multiple users to access and change data in the same table or view at the same time without risk of losing data integrity.

• Journaling
  The DB2 UDB for iSeries journal support provides an audit trail and forward and backward recovery.

• Commitment control
  The DB2 UDB for iSeries commitment control support provides a means for processing a group of database changes, such as update, insert, data definition language (DDL), or delete operations, as a single unit of work (also referred to as a transaction).

• Savepoints
  A savepoint is a named entity that represents the state of data and schemas at a particular point within a unit of work. You can create savepoints within a transaction. If the transaction rolls back, changes are undone to the specified savepoint, rather than to the beginning of the transaction.

• Atomic operations
  When running under COMMIT(*CHG), COMMIT(*CS), or COMMIT(*ALL), all operations are guaranteed to be atomic.

• Constraints
  DB2 UDB for iSeries supports unique, referential, and check constraints.

• Save and restore functions
  The i5/OS^® save and restore functions are used to save SQL objects to disk (save file) or to external media.

• Damage tolerance
  DB2 UDB for iSeries provides several mechanisms to reduce or eliminate damage caused by disk errors.

• Index recovery
  DB2 UDB for iSeries provides several functions to deal with index recovery.

• Catalog integrity
  To ensure that the information in the catalog is always accurate, DB2 UDB for iSeries prevents users from explicitly changing the information in the catalog and by implicitly maintaining the information when an SQL object described in the catalog is changed.

• User auxiliary storage pool
  You can create a schema in a user auxiliary storage pool (ASP) using the ASP clause on the CREATE SCHEMA statement.

• Independent auxiliary storage pool
  Independent disk pools are used to set up user databases on the system.

 

Parent topic:

Data protection