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


Chapter 3 Tools : SIXBUILD

SIXBUILD
Creates a secondary index online for a TDS table. (C)
Invocation
Do one of the following:
CALL SIXBUILD(table, secondary_key)
 
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).
Usage Notes
Using SIXBUILD from the Administrator’s Workbench
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.
Unloading Tables with Secondary Indexes
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:
1.
2.
3.
4.
5.
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.
See Also
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.

Exceptions
 
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.
Example
The following statement builds a secondary index for the table EMPLOYEE using the field MGR#:

 
RULE EDITOR ===> SCROLL: P
SIXBUILD_1;
_
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ CALL SIXBUILD('EMPLOYEE', 'MGR#'); | 1
_ ---------------------------------------------------------------------------

 
Change to Table Definition
Executing the rule causes the following change to the table definition:

 
COMMAND==> TABLE DEFINITION
 
Table: EMPLOYEE Type: TDS Unit:USR40 IDgen: N
 
Parameter Name Typ Syn Len Dec Reference ' Event Rule Typ Acc
---------------- - - --- -- ---------------- ' ---------------- - -
_ ' _
_ ' _
Field Name Typ Syn Len Dec Key Ord Rqd Default Reference
---------------- - -- ---- -- - - - ---------------- ----------------
_ EMPNO I P 3 0 P
_ LNAME S C 22 0
_ POSITION S C 14 0
_ MGR# I P 3 0 S
_ DEPTNO I B 2 0
_ SALARY Q P 3 2
_ HIREDATE D B 4 0
_ ADDRESS S V 38 0
_ CITY S C 20 0
_ PROV S C 3 0
_ P_CODE S C 7 0
_
PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRINT 14=FIELDS 21=DATA 2=DOC

 

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