CA AuthMinder UNIX Installation Guide › Configuring Alternate Schema for IBM DB2 Universal Database › Editing Configuration File

Editing Configuration File

If you plan to use alternate schema for IBM DB2 UDB, then you must edit the arcotcommon.ini file to configure these settings. Perform the following steps to do so:

1. Navigate to the following locations:

   <install_location>/arcot/conf
   

2. Open the arcotcommon.ini file in a text editor.
3. In the [arcot/db/primarydb] and [arcot/db/backupdb] sections, set the following parameters:
   • URL.1: Set this parameter to the JDBC data source, as follows:

     jdbc:db2://<server>:<database_port>/<database>:currentSchema=<alternateID>;currentFunctionPath="SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","<alternateID>";
     

     For example

     jdbc:db2://db2server:50000/arcotdb:currentSchema=ARCOTALTERNATEUSER;currentFunctionPath="SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","ARCOTALTERNATEUSER";
     

   • Username.1: Set this parameter to the user name that is used to access the database. For example, arcotuser.
4. Save and close the arcotcommon.ini file.