At runtime, you can dynamically modify the server parameters using the tools SETXPARM and RESETXPARM. The use of these tools reduces the number of table definitions required to map the external data. The changes to the server parameters are stored in either of the following two session tables:
TIBCO Object Service Broker Shareable Tools for detailed descriptions of the SETXPARM and RESETXPARM tools.
To begin copying dictionary data from an external DBMS into the shadow dictionary, run the @SLKEXTRACT rule from the workbench. The @SLKEXTRACT rule produces a screen similar to the one shown below:
If you already have an SLK table defined with the Serverid and DBSource jointly denoting the external DBMS from which you want to extract metadata, enter the name in the
TableName field and press Enter. The
Serverid,
DBSource,
Qualifier, and
Owner fields are filled in automatically.
If extracting columns and/or tables, you can restrict the amount of metadata extracted by using the filters in the lower portion of the screen. The following filters can be used with both tables (PF4) and columns (PF5):
If selecting tables only (PF4), you can also specify Y or N in each of the five fields (
Table,
View,
System Table,
Alias, and
Synonym). Specifying N means that dictionary information for tables of this type is not extracted.
After extracting the desired information, use the PF keys listed below to clean up the shadow dictionary. After making a selection, you are prompted for confirmation.
To optimize access to the SLK table, you can bind an SLK table definition; you cannot bind its data. SLK tables for which you request binding are bound to both the Execution Environment and the Gateway when they are accessed from a rule.
You can dynamically request a re-bind for the Execution Environment if you want to change a bound definition. To do this, modify the definition using the Table Definer and run the $BINDOBJECT routine against the new definition. Subsequent access requests against this definition, issued within the Execution Environment where you run $BINDOBJECT, refresh the definition in the Gateway.
TIBCO Object Service Broker Application Administration for information on binding tables and on the $BINDOBJECT routine.