CA Strong Authentication Administration 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 edit the arcotcommon.ini file to configure these settings.

Perform the following steps:

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.