Previous Topic: Create a DatabaseNext Topic: MySQL Database Configuration

CA Strong Authentication Windows Installation Guide › How to Configure the Database Server › IBM DB2 Universal Database Configuration

IBM DB2 Universal Database Configuration

This section provides the following configuration information for IBM DB2 Universal Database (UDB):

Create a database (the recommended name is arcotdb) to store information in the UTF-8 character set. This allows CA Strong Authentication to use international characters including double-byte languages.

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

  6. Create a user (recommended name is arcotuser), with a schema in the new database arcotdb.
  7. Grant the user the following privileges: 
    CREATE TABLE

    CREATE INDEX

    CREATE SEQUENCE

    CREATE PROCEDURE

    CREATE SESSION

    DML PRIVILEGES

    CONNECT PRIVILEGES

    ALTER TABLE