Registering the repository for the exceptions database on Windows
You can register the repository for the exceptions database with the template properties file.
Procedure
- On the computer that hosts the services tier, switch to the \InformationServer\ASBServer\bin directory.
- 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.
- 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.
- 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.
- Register the repository for the exceptions database with the following command:
RepositoryAdmin.bat -rr -pf esdb_repository.properties
- 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;
- Run the following command for the new driver properties. It is applicable only for
Db2:
- Verify that the properties are configured correctly with
the following command:
RepositoryAdmin.bat -dr -rn ESDB
- 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