Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 1 Using TIBCO Object Service Broker Utilities : S6BBRSIX (Batch Secondary Index Build for TDS Tables)

S6BBRSIX (Batch Secondary Index Build for TDS Tables)
S6BBRSIX is a batch utility that provides a fast method for building one or more secondary indexes on a large, existing TDS table.
S6BBRSIX versus SIXBUILD
S6BBRSIX offers significant performance improvements over the online secondary index build tool (SIXBUILD) because it builds multiple secondary indexes from just one pass through the data. The segment must be offline. If the table occupies more than 3000 pages or exceeds site limits for online processing, you must use S6BBRSIX.
Invocation
Complete the following steps to run S6BBRSIX:
Step 1: Describe Input and Output
Describe the input and output to the utility by coding control cards. You can use the SIXBUILD_CARDS utility to define a data set containing the necessary control cards.
The SIXBUILD_CARDS utility is described in detail in SIXBUILD_CARDS (Prepare Cards for Batch Secondary Index Build).
Step 2: Define and Run JCL to run S6BBRSIX
The S6BBRSIX 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.
Step 3: Identify the Secondary Index Fields
When you use the Batch Secondary Index Build utilities, the segment containing the table must be offline. The utility cannot access the table definition to record the secondary indexes that were created because the definition is stored in the MetaStor. Consequently, after the batch utility is run, the secondary indexes are built and usable but you must edit the table’s definition to make the new secondary index fields available to the Table Definer.
To mark the fields that have secondary indexes, edit the FIELDS table using the Table Editor. The table is parameterized by table name, so if you had a table called EMPLOYEE, you would edit the FIELDS table from the workbench as follows:
ED edit table ==> FIELDS(EMPLOYEE)
Enter an uppercase S in the KEYTYPE column next to the field names of the fields that have secondary indexes. If the KEYTYPE column already contains a P and that field is also a secondary index, enter an uppercase Q. The next time you look at the table definition through the Table Definer, you see an S or Q next to these fields in the KEY field.
Step 4: Back up the Segment
To ensure the integrity of your continuous backup after you run the S6BBRSIX utility, you must back up the segment containing the new data.
See Also
TIBCO Object Service Broker Shareable Tools for more information about the SIXBUILD tool.
TIBCO Object Service Broker for z/OS Managing Backup and Recovery for information about backing up a segment.
TIBCO Object Service Broker Messages With Identifiers for messages associated with this utility.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved