Copyright © Cloud Software Group, Inc. All Rights Reserved

Mass Updates of TDS Data

You can do mass updates of large TDS tables in TIBCO Object Service Broker using the batch utilities S6BBRTBL/hrnbrtbl (batch load) or S6BBRCLR/hrnbrclr (batch table clear). Within the z/OS environment you can also use the mass update feature within a rule.

What Method to Use?

Use the following table to determine the method to use to do a mass update of data:

If you want to…	Use…	For more information refer to…
Load a table with initial data.	S6BBRTBL/hrnbrtbl.	Utilities
Clear a table or table instance of all its data.	S6BBRCLR/hrnbrclr.	Utilities
Selectively insert, replace, or delete data in a z/OS environment.	The mass update feature from within a rule.	The following sections.

Advantages of the Mass Update Feature

You can use the mass update feature to:

•	Improve performance because it takes a lock at a table level and not at an occurrence level. This decreases message traffic.

•	Manipulate, through rules processing, the data prior to updating the table.

•	Make global or selective changes to a table or table instance.

•	Bypass the existence test of the two-phase commit process.

•	Keep the segment where the table is located online, so that journaling can be performed.

Copyright © Cloud Software Group, Inc. All Rights Reserved