Install DB2 and create a database - database configuration/design tasks

If you are tasked with installing and configuring the database, here is a list of steps to be taken:

  1. Install the IBM® DB2® Universal Server on your database server.
  2. Create a DB2 database entity: dbname
  3. Declare a database user dedicated to your application: the application administrator. This user will manage the database schema of the application (all tables will be owned by it).
  4. Give all requested database administrator privileges to the application administrator.
  5. If you plan to use temporary table emulation, you must setup the database for DB2 global temporary tables (create a user temporary tablespace and grant privileges to all users). See Temporary tables.
  6. Connect as the application administrator:

    $ db2 "CONNECT TO dbname USER appadmin USING password"

  7. Create the application tables. Do not forget to convert Informix® data types to DB2 data types. See issue Data Type Conversion Table for more details.
  8. If you plan to use SERIAL column emulation, you must prepare the database. See SERIAL data types.