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 database (the recommended name is arcotdb) to store 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.

   See the vendor documentation for more information about changing the tablespace page size.

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

   See the vendor documentation for more information about changing the log file size.

5. Ensure that the configuration changes have been applied.

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