Some product modules make use of data stores for their
supporting information. The IBM®
InfoSphere® Information Analyzer database
can be created before installation or by the installation program.
Other data stores--the operations database, standardization rules
designer database, and the exceptions database--can be created by
the installation program or you can create them afterward. Depending
on the installation options you chose, you might need to register
them, create them, or both before you can use them.
Procedure
- The operations database:
The operations
database is a data store that stores the monitoring data that is displayed
by the IBM
InfoSphere
DataStage® and QualityStage® Operations Console.
This data store is offered for installation with IBM
InfoSphere
DataStage and QualityStage.
- If you used the installation program to install
the repository tier in a Db2 database on the local computer and you
did not skip the creation of the operations database, then it would
have been registered and created for you during installation.
- If you connected to a remote Db2 database while
installing the services tier, then the operations database would have
been registered, but it would not have been created. You must create
the operations database on the remote computer by using the scripts
that the installation program has created for you.
The scripts are
in the following location on the services tier computer:
- AIX Linux
- IS_install_path/SQLScripts/dsodb
- Windows
- IS_install_path\SQLScripts\dsodb
For instructions on running the scripts, start at
step 3 in Creating the operations database
schema.
- If, during installation, you chose to skip the
creation of this database in a Db2 database on the local computer,
then you must register and create the operations database schema.
Complete all of the steps in Creating the operations database
schema.
- If you are creating the operations database
in a non-DB2 database, then you must register and create the operations
database schema. Complete all of the steps in Creating the operations database
schema.
- The standardization rules designer database:
Important: IBM
InfoSphere
QualityStage Standardization Rules Designer will not
be supported after 31 December 2020. No replacement is planned.
The standardization rules designer database is a data store
that stores data that is used by the IBM
InfoSphere
QualityStage Standardization Rules Designer.
This data store is offered for installation with IBM
InfoSphere
QualityStage.
- If you used the installation program to install
the repository tier in a Db2 database on the local computer, then
the standardization rules designer database would have been registered
and created for you during installation.
- If you did not use the installation program to install the
repository tier, then the standardization rules designer database
would have been registered, but it would not have been created. You
must create the standardization rules designer database on the remote
computer by using the scripts that the installation program has created
for you.
The scripts are in the following location on the services
tier computer:
- AIX Linux
- IS_install_path/SQLScripts/qssrd
- Windows
- IS_install_path\SQLScripts\qssrd
For instructions on running the scripts, start at
step 5 in Example: Manually registering a
repository.
- The exceptions database:
The exceptions
database is a data store that stores exception descriptors for the
Exceptions stage. This data is used by the Data Quality Exception
Console. The exceptions database is not offered for installation by
the installation program and must be registered and created after
installation if you want to use it.
To register and create the
exceptions database, see Creating the exceptions database schema.