Management of Definitions and Data Across Nodes

Some development environments require the developer to maintain consistency with data and definitions that are stored on different nodes. TIBCO Object Service Broker provides a number of tools and facilities to assist in this task. With these, you can:

•

Set promotion rights to individual objects at a central location

•

Promote objects across nodes

•

Manipulate data and definitions across nodes

Setting the Location for Promotion Rights

Using the following shared tables you can centralize where promotion rights are determined for individual objects across the nodes used for development.


@BORROWED_OBJ	This table, parameterized by LOCATION, holds the promotion rights for each object for a node.
@BOROBJLOC	This table can be used to hold the value for LOCATION for @BORROWED_OBJ.

Sample Scenario

The following table illustrates how one or more nodes can use the same source to determine promotion rights.


Node	Value in @BOROBJLOC	LOCATION for @BORROWED_OBJ
NODEA	NODEA	NODEA
NODEB	NODEA	NODEA
NODEC	NODEA	NODEA

Promoting Across Locations

Using the option PR Remote Promotion Admin from the administrator’s workbench, you can apply promotions to or from a remote node that is connected to your node. When using Remote Promotion Admin, either the node of the source system or the node of the target system must be the same as the node from which you are administering the promotion.

Tools Available to Help Development Across Nodes

The following list describes the tools available to manipulate data and definitions across nodes.


COPY_DATA	Copy data from one table or table instance to another table or table instance.
COPY_DEFN	Copy the definition of an object from a source location to a destination location.
COPYDEFN	Copy the definition of one or more objects. This tool is available on the standard developer workbench.
DELETE_DATA	Delete the data from a table or table instance.
DELETE_DEFN	Delete the definition of an object.
DIFF_DATA	Compare the data of two tables and list the differences.
DIFF_DEFN	Compare the definitions of two objects and list the differences.
DIFFDEFN	Compare the definitions of one or more pairs of objects and list the differences. This tool is available on the standard developer workbench.
PRINT_DATA	Print the data of an object.
PRINT_DEFN	Print the definition of an object.
UNLOAD	Unload table data or definitions of objects.
UNLOAD_DATA	Unload table data.
UNLOAD_DEFN	Unload the definition of objects.
UNLOADLIBRARY	Unload a library of rules.

Transferring Files Across Different Platforms

Because the file format used on z/OS is different from the file format used on Open Systems, if you transfer files using FTP you must reformat them using the z/OS offline batch utility S6BBRFRU. Refer to the S6BBRFRU documentation for information about formatting requirements and FTP procedures.

What Types of Files or Data Set Types Can be Reformatted?

You can use S6BBRFRU to reformat the following types of files or data sets:

•

TIBCO Object Service Broker segment archives

•

Import/export table files

•

Missing BDW Variable Format files

•

Workbench unload files

•

TIBCO Object Service Broker offline batch utility unload files