CA AuthMinder Windows Installation Guide › Configuring Alternate Schema for IBM DB2 Universal Database › Creating Schema

Creating Schema

To set up the alternate schema, perform the following steps:

1. Log in to IBM DB2 UDB database.

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

2. Create an alternate schema.

   For example, the alternate schema can be arcotalternateuser.

   Book: See the IBM DB2 UDB database documentation for more information about creating 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 Systems\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.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. If not, then use the DBUtil tool to insert the database user name and password.

   See the "Tools for System Administrators" chapter in CA AuthMinder Installation and Deployment Guide for more information.