Implementing your database design

Implementing your database design involves implementing Db2 objects, loading and managing data, and altering your design as necessary.

Tip: Begin general-use programming interface information.You can simplify your database implementation by letting Db2 implicitly create certain objects for you. For example, if you omit the IN clause in a CREATE TABLE statement, Db2 creates a table space and database for the table, and creates other required objects such as:
  • The primary key enforcing index and the unique key index
  • The ROWID index (if the ROWID column is defined as GENERATED BY DEFAULT)
  • LOB table spaces and auxiliary tables and indexes for LOB columnsEnd general-use programming interface information.