CA AuthMinder Windows 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 (recommended name is arcotdb) that stores information in the UTF-8 character set. This allows AuthMinder to use international characters including double-byte languages.

To configure the IBM DB2 UDB, perform the following steps:

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. Ensure that the following system environment variable is set:

   DB2CODEPAGE=1208
   

4. 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.

5. 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.

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

6. 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.