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.
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.
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:
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.