Implementing your database design
Implementing your database design involves implementing Db2 objects, loading and managing data, and altering your design as necessary.
Tip: 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 columns