CA AuthMinder UNIX Installation 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 will be arcotuser.

2. Create an alternate schema.

   For example, the alternate schema can be arcotalternateuser.

   Note: Refer to 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.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, you need to use the DBUtil tool to insert the database user name and password.

   Refer to chapter, "Tools for System Administrators" in CA AuthMinder Installation and Deployment Guide for more information.