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. 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
    End general-use programming interface information.