IBM Support

Setting up database schemas and users for the Data Quality Exception Events component, 11.3 Fix Packs and 11.3 to 11.5 In Place Update Patch

Product Documentation


Abstract

If you installed the metadata repository on an Oracle database or Microsoft SQL Server, you must set up database schemas and users before you install the subscriptionManagerAndDataQualityUpdates patch or update any Fix Packs.

Content

The Data Quality Exception Events component includes the Data Quality Exception Console, Subscription Manager, and the events and notification services that support these applications. In order to use these applications and services, you must first install and configure the Data Quality Exception Events component.

If you installed the metadata repository on an Oracle database or Microsoft SQL Server, you must create new database schemas and users before you install any of the following patches or Fix Packs.

-All 11.3 Fix Packs
-The subscriptionManagerAndDataQualityUpdates patch
-The version of 11.5.0.0 in place upgrade from 11.3x patch


Note: If you installed the metadata repository on DB2®, no additional configurations are required. The steps outlined in this procedure are specific to installations of the metadata repository on an Oracle database or Microsoft SQL Server.

  1. Download the install script for your database system.
    • Oracle database - rem_oracle_pre_install.sql
    • Microsoft SQL Server - rem_sqlserver_pre_install.sql
  2. Create the CEFVIEWS and REMVIEWS database users by applying the sql script for your database system.

Note: The result of MS SQL Server command is written to rem_sqlserver_pre_install.log
Database systemCommands
Oracle databasesqlplus -S -L <SYS_USER_NAME>/<SYS_USER_PASSWORD>@<SYS_SERVICE_NAME> AS SYSDBA @rem_oracle_pre_install.sql <XMETA_DATABASE_USER_NAME> <XMETA_TABLESPACE_NAME>
Microsoft SQL Serversqlcmd -U <XMETA_DATABASE_USER_NAME> -P <XMETA_DATABASE_USER_PASSWORD> -b -i rem_sqlserver_pre_install.sql -o rem_sqlserver_pre_install.log -S SERVER_NAME -v XMETA_DATABASE_USER_NAME=<XMETA_DATABASE_USER_NAME>

Original Publication Date

08 September 2014

rem_oracle_pre_install.sqlrem_oracle_pre_install.sqlrem_sqlserver_pre_install.sqlrem_sqlserver_pre_install.sql

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Data Quality Exception Console","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.5;11.3.1.2;11.3.1.1;11.3.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27044449

Page Feedback