Installing DataFlow Matrix ODI
To install the DataFlow Matrix ODI
1. Download and install the appropriate DataFlow ODI RPM for your version of Actian Matrix. Use a command similar to:
sudo rpm -ivh ODI-Dataflow-1.0.0-9.x86_64.rpm
This will prepare the UDFs for installation as well as provide documentation and Python scripts for completing the installation.
2. Ensure Matrix is running and no users are logged in.
3. For new installations, run:
/opt/paraccel/bin/install_dataflow_odi_all.py -a
This command installs the ODI UDFs for all databases in the Matrix cluster. If you want to install the UDFs for specific databases, replace the -a option with the list of databases. The following example specifies a list of databases.
/opt/paraccel/bin/install_dataflow_odi_all.py db1 db2
4. (Optional) To allow DataFlow jobs to check for available workload managment (WLM) resources before running a job, add the DataFlow service class and query classification to your WLM configuration file. The default location is /home/paraccel/padb/rel/etc/padb_wlm.xml.
To add the service class:
<service_class name="dataflow_queries">
<!-- You may add parameters such as min_concurrent_queries and max_concurrent_queries for Dataflow jobs here. -->
</service_class>
To add the classification within the <serviceclass_classification> tag:
<classification>
<condition>
query_group=DATAFLOW
</condition>
<action>
<assign service_class="dataflow_queries" />
</action>
</classification
For more information about workload management, see the “Managing Workloads” section of the Administrator's Guide and SQL Reference for Matrix.