CA Strong Authentication Administration Guide › Configuring Alternate Schema for IBM DB2 Universal Database › Creating Schema

Creating Schema

Perform the following steps to set up the alternate schema:

1. Log in to IBM DB2 UDB database.

   If the login name is arcotuser, then the default schema for this user is arcotuser.

2. Create an alternate schema.

   For example, the alternate schema can be arcotalternateuser.

   Note: See IBM DB2 UDB database documentation for more information how to create the alternate schema.

3. Run the following queries to set up the alternate schema (arcotalternateuser):

   set current schema ARCOTALTERNATEUSER
   set current path ARCOTALTERNATEUSER  
   

   Note: The alternate schema must be specified in upper case.

4. Navigate to the following location:

   <install_location>/arcot/dbscripts/db2
   

5. Run the scripts in the following order:
   1. arcot-db-config-for-common-2.0.sql
   2. arcot-db-config-for-webfort-7.1.01.sql

   Note: If you encounter any error while executing the scripts, then check with your database administrator whether you have the required privileges.

6. Ensure that the database user name (arcotuser)and the corresponding password are set in the securestore.enc file. You can use the DBUtil tool to insert the database user name and password.

   See chapter, "Tools for System Administrators" in CA AuthMinder Administration Guide for more information.