Registering the repository for the exceptions database on Windows

You can register the repository for the exceptions database with the template properties file.

Procedure

  1. On the computer that hosts the services tier, switch to the \InformationServer\ASBServer\bin directory.
  2. Copy the esdb_repository.properties template file from the installation directory on the computer that hosts the engine tier into the current directory. The installation directory is \InformationServer\Server\ESDB.
  3. Edit the esdb_repository.properties file, and enter the values from the following example for your database type.
    Db2®
    DatabasePlatform.databaseType=DB2
    DatabasePlatform.version=10.5
    DatabaseServer.host=localhost
    DatabaseServer.port=50000
    Database.name=ESDBDB2
    Database.alias=
    Database.location=C:\
    Tablespace.name=ESDBSPACE
    Repository.name=ESDB
    Repository.tool=DataQualityConsole
    Repository.schema=esuser
    RepositoryConnection.name=ESDB
    RepositoryConnection.userName=esuser
    RepositoryConnection.password=ibm_0123
    RepositoryConnection.managedDataSourceName=ESDB
    RepositoryConnection.properties=
    SQL Server
    DatabasePlatform.databaseType=SQLSERVER
    DatabasePlatform.version=2012
    DatabaseServer.host=ipsvm00187.swg.usma.ibm.com
    DatabaseServer.port=1433
    Database.name=ESDBSQLS
    Database.location=C:\ESDB
    Database.alias=
    Repository.name=ESDB
    Repository.tool=DataQualityConsole
    Repository.schema=esuser
    RepositoryConnection.name=ESDB
    RepositoryConnection.userName=esuser
    RepositoryConnection.password=ibm_0123
    RepositoryConnection.managedDataSourceName=ESDB
    Oracle database
    DatabasePlatform.databaseType=SQLSERVER
    DatabasePlatform.version=2012
    DatabaseServer.host=ipsvm00187.swg.usma.ibm.com
    DatabaseServer.port=1433
    Database.name=ESDBSQLS
    Database.location=C:\ESDB
    Database.alias=
    Repository.name=ESDB
    Repository.tool=DataQualityConsole
    Repository.schema=esuser
    RepositoryConnection.name=ESDB
    RepositoryConnection.userName=esuser
    RepositoryConnection.password=ibm_0123
    RepositoryConnection.managedDataSourceName=ESDB
    If you plan to use Db2 for the exceptions database schema, the following restrictions apply:
    • The user that you specify to access the exceptions database must be an existing operating system user, and cannot be the same user that you use to run the db2 command during the schema creation process.
    • You cannot create the exceptions database schema on a system that has only the Db2 client installed.
    If you plan to use SQL Server for the exceptions database schema and your instance of SQL Server uses only Windows authentication, the following restriction applies:
    • The user that you specify to access the exceptions database must be an existing operating system user, and cannot be the same user that you use to run the sqlcmd command during the schema creation process.
  4. Verify that the Database.location property is specified correctly in the esdb_repository.properties file.
    If you set this property to the default value, ensure that the path to the database location exists and ensure that the user who registers the repository for the exceptions database has access to that file path.
  5. Register the repository for the exceptions database with the following command:
    RepositoryAdmin.bat -rr -pf esdb_repository.properties
    1. Run the following command for the new driver properties. It is applicable only for Db2:
      RepositoryAdmin.bat -updateRepositoryConnection -rn ESDB -cn ESDB -cr 
      jdbc:db2://<DB2_Server>:<DB2_port>/<ESBDNAME>:useJDBC4DataType=2;useJDBC4ColumnNameAndLabelSemantics=2;
  6. Verify that the properties are configured correctly with the following command:
    RepositoryAdmin.bat -dr -rn ESDB
  7. If the properties file is not configured correctly, unregister the repository, correct the properties file, and repeat the process to register the repository again.

    You can unregister the repository with the following command:

    RepositoryAdmin.bat -urr -rn ESDB

    If you misconfigured the server name for the database, you must also remove the database record with the following command:

    RepositoryAdmin.bat -urd -dn ESDB