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:
Install the IBM® DB2® Universal Server on your database
server.
Create a DB2 database
entity: dbname
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).
Give all requested database administrator privileges to
the application administrator.
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.
Connect as the application administrator:
$
db2 "CONNECT TO dbname USER appadmin USING
password"
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.
If you plan to use SERIAL column emulation, you must prepare
the database. See SERIAL data types.