CA AuthMinder UNIX Installation Guide › Preparing for Installation › Configuring Database Server › Configuring IBM DB2 Universal Database › Creating a New Database

Creating a New Database

Create a new database (the recommended name is arcotdb) that stores information in the UTF-8 character set. This allows AuthMinder to use international characters including double-byte languages.

Perform the following steps to configure the IBM DB2 UDB:

1. Log in to the IBM DB2 UDB database server.
2. Run the following command to enable UTF-8 support:

   create db <DB-NAME> using codeset utf-8 territory us;
   

3. Set the tablespace page size to 16K. By default, the tablespace page size is 4K.

   Refer to the vendor documentation for more information on changing the tablespace page size.

4. If your data volume is high, then the default size of transaction log file might be insufficient. Therefore, it is recommended to increase the log file size.

   Refer to the vendor documentation for more information on changing the log file size.

5. Ensure that the configuration changes have been applied.

If you plan to use alternate schema, then refer to appendix, "Configuring Alternate Schema for IBM DB2 Universal Database" for more information.