Configuring the Data Quality Exception Events component

To use the Data Quality Exception Events component, you must run a script to configure the default behavior of Data Quality Exception Console. To receive exception events from the Exceptions stage, you must create the exceptions database schema.

Before you begin

Install and configure IBM Business Process Manager Standard if you want to use IBM Stewardship Center to send exception sets to the Data Quality Exception sample process application.

About this task

The event_management_setup script configures the default behavior of the Data Quality Exception Events component in the following ways:
  • Assigns all Exception Management roles to the user specified by the suite administrator.
  • Registers the exception event providers, exception event types, and applications that are required for exception management.
  • Creates the default subscription that enables all exceptions for exception management. With this configuration, all exceptions that are generated by IBM InfoSphere® Information Server products and components are displayed in Data Quality Exception Console.
  • Creates the default subscription that enables a user of Data Quality Exception Console to send selected exception sets to the Data Quality Exception sample process application by clicking Manage.

You can change the default behavior of Data Quality Exception Console. You can specify which exception sets are sent to Data Quality Exception Console. If IBM Stewardship Center is installed, you can manage those exception sets with different IBM BPM process applications. For more information, see Customizing Data Quality Exception Console.

Procedure

  1. If you installed IBM Stewardship Center, you must specify the IBM BPM SSL port.
    1. Open the IBM WebSphere® Application Server administrative console on the computer where you installed IBM Business Process Manager Standard.
    2. Click Single Cluster > Servers > Clusters > WebSphere application server clusters > Single Cluster > Cluster Members > SingleClusterMember1 > Ports. The SSL port is the WC_defaulthost_secure port number.
  2. If you did not install IBM Stewardship Center, you must provide dummy values for the following IBM BPM parameters in the script:
    • <BPM_user_name>
    • <BPM_password>
    • <BPM_url>:<BPM_SSL_port>
  3. Run the event_management_setup script from the <Information_Server_install_path>/Clients/DQ_BPM/scripts folder on the computer where you installed IBM InfoSphere Information Server.

    AIX® HP UX, Linux operating systems
    ./event_management_setup.sh <IS_admin_name> <IS_admin_password> <IS_url>:<IS_SSL_port> <BPM_user_name> <BPM_password> <BPM_url>:<BPM_SSL_port>

    For example, 

    cd /opt/IBM/InformationServer/Clients/DQ_BPM/scripts
./event_management_setup.sh isadmin infsv123pwd myinformationserver.com:9443 bpmadmin bpm123pwd mybpmserver.com:9444
    Windows operating system
    event_management_setup.bat <IS_admin_name> <IS_admin_password> <IS_url>:<IS_SSL_port> <BPM_user_name> <BPM_password><BPM_url>:<BPM_SSL_port>

    For example, 

    cd C:\IBM\InformationServer\Clients\DQ_BPM\scripts
event_management_setup.bat isadmin infsv123pwd myinformationserver.com:9443 bpmadmin bpm123pwd mybpmserver.com:9444

    To troubleshoot script errors, refer to the log files that correspond to your installation of IBM WebSphere Application Server. For information, see Configuring WebSphere Application Server logs.

  4. Create the exceptions database schema to receive events that are generated by the Exceptions Stage.
Parent topic: Configuring and managing exceptions in Data Quality Exception Console