![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
• From the administrator’s workbench, move the cursor to the DT Define Table option and press Enter.
The name of the field for which a secondary index must be created. A secondary index cannot be created on a field with syntax RD (raw data) or UN (Unicode).
• SIXBUILD ignores the location parameter of the input table. Minimal table definitions are not allowed.
• SIXBUILD runs and updates are made even if it is called in a transaction that is running in browse mode.
• If you want to build multiple secondary indexes on a large existing table, use S6BBRSIX, the batch secondary build utility.If you use SIXBUILD from the administrator’s workbench, when you press Enter a list of tables appears on the screen. From this screen:
1. Type the line command X beside the table you want to build a secondary index for and press Enter.
2. From the displayed screen, select the field or fields on which you want to build the secondary index.Because secondary indexes are not carried over when tables are unloaded, promotion problems can result. To use SIXBUILD as a work around, complete the following steps:
4. Call SIXBUILD or, on the Administrator workbench, (@ADMIN) use the Table Definer to designate SIX fields.
Be cautious when using SIXBUILD because it does not take part in the TIBCO Object Service Broker two-phase commit/intent list protocol. It is strongly recommended that this tool not be used in a transaction that accesses or updates data within the same table and that it should normally be the only logical unit of work within a transaction. If a user uses this tool on the data of a bound table, the data is updated (the updates take place on the bound copy of the data).
If SIXBUILD fails, you must run it again before running another TIBCO Object Service Broker function, to prevent damage to the database. If SIXBUILD fails again, contact your database administrator or TIBCO Support immediately.TIBCO Object Service Broker Application Administration for information about building secondary indexes.TIBCO Object Service Broker for z/OS Utilities for more information on S6BBRSIX.
The secondary index field length is greater than 127, the table definition does not exist or is inconsistent, or the table is not a TDS table. The table that you want to build the index on is being used by someone else.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |