Configuring virtual table rules for RAA

Configure Data Virtualization Manager Server Event Facility (SEF) rules to support multiple instances of the IBM Rational Asset Analyzer (RAA) schema using common virtual table and view definitions.

About this task

To support multiple instances of the RAA schema using common virtual table and view definitions, VTB rules AVZRAATB and AVZRAAVW provide support to process tables starting with RAA_ and views starting with RAAV_.
AVZRAATB
This table rule looks at the base view of a query for double underscores “__” and uses the data after the underscores to update the target subsystem for the query. This rule will also change the schema (or table owner) name of RAA tables from DMH to another value if the global system variable GLOBAL2.RAA.database-name.SCHEMA is set with an alternate schema name.
AVZRAAVW
This view rule looks for the double underscores and removes them from the view name to process.
With the rules activated, the Data Virtualization Manager studio can suffix the view names with __SSID for all calls and process multiple instances of the RAA schema using a single set of maps.

These rules must be activated regardless of the number of RAA databases to be enabled.

Use the following procedure to set up these rules.

Procedure

Use the following steps to enable rules AVZRAATB and AVZRAAVW in the VTB ruleset:
  1. In the Data Virtualization Manager server - Primary Option Menu, specify option E, Rules Mgmt.
  2. Specify option 2, SEF Rule Management.
  3. Enter VTB for Display Only the Ruleset Named.
  4. Enable the rule by specifying E and pressing Enter.
  5. Set the rules to Auto-enable by specifying A and pressing Enter.

    Setting a rule to Auto-enable activates the rule automatically when the server is re-started.