![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Developer’s workbench Type SIXBUILD_CARDS <Enter> Type EX SIXBUILD_CARDS <Enter>
• SIXBUILD_CARDS helps you define the control cards required by the S6BBRSIX and hrnbrsix (Batch Secondary Index Build for TDS tables) utilities.
• SIXBUILD_CARDS displays a series of screens where you identify the table and secondary index fields, and then writes the necessary controls in a file.
TIBCO Object Service Broker for z/OS Utilities or TIBCO Object Service Broker for Open Systems Utilities for complete information about the Batch Secondary Index Build utilities.TIBCO Object Service Broker Parameters for information on the DSBIFTYPE Execution Environment parameter.On z/OS systems, before you can use SIXBUILD_CARDS you must allocate a file to hold the control cards. This file must have a record length of 80 bytes and be fixed block.Task B Invoke SIXBUILD_CARDS
Control Card File The lower half of the screen specifies override values for the batch secondary index build process. Default values are available and appear on the screen. To override any of these defaults, type in a new value in the space provided.Task C Specify secondary indexes
This screen displays a list of TIBCO Object Service Broker fields with the currently assigned primary keys. Type a Y in the Secondary column beside the field or fields for which you want to define a secondary index. You can define a secondary index on any field except the first primary key field or fields with syntax RD (raw data) or UN (Unicode).After specifying the secondary index fields, press PF4. The control cards are written out to your file and the control cards definition is complete.Task D Review the output file
Notice the P and S designations next to the PK and F1 fields. These letters mean that PK is a primary key, and F1 is a secondary index. If a field is both a primary key and a secondary index, the designation is Q.The following tables relate control fields on the screens with their equivalent fields in the control records:
TIBCO Object Service Broker Field Definitions: Syntax for fields that are neither RD nor UN
Columns 45 to 48 contain the syntax if the field is raw data or Unicode; otherwise, the semantic type goes in column 46.
• H type records contain a sequence number in columns 3 – 5 that must be consecutive and must commence with 001. The types within these records must be in the order: R, if any, followed by P, if any, followed by F.
• The Dynamic Block Size, on z/OS only, is used for any temporary work files required to process secondary indexes and for table instances. The small default block size can be detrimental to good performance. If secondary indexes are to be built for large tables, that is, tables with large numbers of occurrences, consider optimizing the Dynamic Block Size.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |