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.
On a CREATE TABLE statement, if you do not specify a database name, DB2 will use an existing implicitly
created database. If an implicitly created database does not exist, DB2 creates one using the naming
convention of DSNxxxxx. The DSNxxxxx values can range from DSN00001
to DSNnnnnn, where nnnnn is the maximum value of the sequence
SYSIBM.DSNSEQ_IMPLICITDB, with a default of 10000. If the table space
is implicitly created, DB2 will
create all of the required system objects for you, including:
- The primary key enforcing index and the unique key index
- The ROWID index (if the ROWID column is defined as GENERATED BY DEFAULT)
- The LOB table spaces, the auxiliary tables, and the auxiliary indexes