Copyright © Cloud Software Group, Inc. All Rights Reserved

S6BBRSET (Batch Segment Re-initialization)

S6BBRSET re-registers empty tables into a TDS segment.

S6BBRSET is useful in situations where specific data is periodically purged and reloaded into TIBCO Object Service Broker in its entirety, for example, daily sales data. The transient data is normally stored in a separate Pagestore segment. This utility can be used to do the following:

•	Rebuild the resident table index

•	Create the empty tables

•	Rebuild the secondary index structures for the deleted tables

Having used S6BBRSET to build the empty table and index structures, you can reload the data using either the LOAD tool or Batch Load utility (S6BBRTBL).

Invocation

The steps to analyze, clear, and re-initialize the segment are as follows:

1.	Delete and redefine the TIBCO Object Service Broker segment (for example, using IDCAMS).

2.	Format the segment using the S6BTLFPS utility.

If you are employing the continuous backup method, be aware that your current backup contains page images for the segment you plan to re-initialize. As a precaution, after re-initializing the segment, consider filtering out any pages associated with that segment from your latest backup. For information about filtering your backup, refer to TIBCO Object Service Broker for z/OS Managing Backup and Recovery.

3.	Run S6BBRSET.

The S6BBRSET member of the JCL data set distributed with TIBCO Object Service Broker contains sample JCL required to run this utility.

This sample is provided as a reference only; modify the JCL for your needs.

The S6BBRSET utility is passed four parameters:

BROWSE	Indicates whether this execution is a test (Y) or production (N) run.
SEGMENT	The segment number you want to re-initialize. The segment number is a one, two, or three digit decimal number. The maximum segment number is 255. It must be offline.
TDS	The Data Object Broker communications identifier of an active TIBCO Object Service Broker system (one to eight characters).
MDL	The MDL Execution Environment communications identifier (one to eight characters).

If the tables were unloaded with the UNLOAD tool, the empty tables and secondary indexes can be reloaded using the LOAD tool after they are in place.

Constraints

The following constraints apply:

•	The target can be any segment other than segment 0.

•	A TIBCO Object Service Broker system with the same DBDLIB must be active.

•	The target segment (the one to be re-initialized) must be offline.

Since this utility updates the segment offline and does not normally perform Journaling, you must back up any changes you make to the target segment. For information about backing up a segment, refer to TIBCO Object Service Broker for z/OS Managing Backup and Recovery.

Sample Report

The execution report provides information about the resident tables and the secondary indexes that are rebuilt on the reformatted segment. A sample report for a TDS segment follows.

---

 

S6BBRSET REBUILD EMPTY TABLES IN FORMATTED TDS SEGMENT 001 DATE: 2009 JUN 18 TIME: 08:31:48      V520E049      PAGE: 1

TABLE NAME ACTION SECONDARY INDEX FIELDNAMES

 

$TABWITHLOC ADDED

$TABWITHLOCDATA ADDED

$TABWITHNOLOC ADDED

@RULESLIBRARY KEPT

DZYP4 ADDED

DZYTDS1 ADDED

DZYTEST ADDED

DZYTESTTDS ADDED

EVENTRULES KEPT

FIELDS KEPT

ORDERING KEPT

PARMS KEPT

RAJTD_C#7QU8B9 ADDED

SCREENFIELDS KEPT

SCREENS KEPT

SCREENTABLES KEPT

SELECTION KEPT

TABLES KEPT

TABWITHLOC ADDED

TABWITHLOCDATA ADDED

TABWITHNOLOC ADDED

TEST_3PAR ADDED

T7FZDYH ADDED

T7FZDYHB ADDED

T76UAJ9 ADDED

 

******************* TARGET SEGMENT UPDATED - RTIX-IX **********************

******************* TARGET SEGMENT UPDATED - RTIX **********************

 

PAGES CREATED:

RTIX-IX PAGES: 1 RTIX PAGES: 1 ALLOC PAGES: 5 SECIX PAGES: 0

 

---

 

If an error condition is encountered, S6BBRSET execution terminates. You should investigate the cause of the error, correct it, and run S6BBRSET again.

See Also

TIBCO Object Service Broker Messages With Identifiers for messages associated with this utility.

Copyright © Cloud Software Group, Inc. All Rights Reserved