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


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

hrnbrsix (Batch Secondary Index Build – TDS Tables)
Syntax
hrnbrsix -C controlfile [arguments]
Platforms
Windows, Solaris
Description
The hrnbrsix utility provides a fast method for building one or more secondary indexes on a large TDS table. It offers significant performance improvements over the online secondary index build tool (SIXBUILD) because it can build multiple secondary indexes from just one pass through the data.
Argument
 
-A auditreport
-C controlfile
-n buffers
The maximum number of buffers for sorting secondary indexes. The default is four and the minimum is two.
-s segment#
The offline segment number. If this argument is omitted, the segment number defaults to zero (that is, the base segment is used).
-W workpath
The directory to be used for temporary storage. If this argument is omitted, the current directory is used.
Constraints
The following constraints apply:
The segment containing the specified table must be offline. If the segment containing the data of the table is segment 0, the Data Object Broker must be shut down.
You must have a correctly formatted ASCII text control file describing the name, definition, and secondary index fields of the target table. The table must be completely defined. The control file can be prepared with other relevant information using the SIXBUILD_CARDS tool, or it can be created with an ASCII editor like Notepad, vi, or a word processor in ASCII mode. For more information, refer to TIBCO Object Service Broker Shareable Tools.
On the first screen of the SIXBUILD_CARDS tool, there is a field called Dynamic Block Size, which defaults to 4096 if left blank. You can set this to 65536 for optimum performance unless you have memory constraints or maximum throughput is not required.
Any secondary indexes to be built must not be predefined. All secondary indexes to be built must be empty; if they already exist (contain index data) they are ignored.
The table must contain data. If the table is empty, use the online secondary index build tool, SIXBUILD. Refer to TIBCO Object Service Broker Shareable Tools for more information.
The table definition is stored in the MetaStor, so the hrnbrsix utility cannot access the table definition to record the secondary indexes that have been created. Consequently, after the hrnbrsix utility runs, you must edit the table definition to make the new secondary index fields available to the Table Definer. For more information, refer to TIBCO Object Service Broker Application Administration.
Example
Windows
hrnbrsix -A audit.trail -C c:\cntl\control.file -s 1 -n 40
Solaris
hrnbrsix -A audit.trail -C /usr/cntl/control.file -s l -n 40
These command lines indicate:
Sample Audit Log
The following illustrates a sample audit log for the hrnbrsix utility:

 
*batchsrv OFFLINE BATCH UTILITY SERVER DATE 2007 MAR 06 TIME 11 27
Requested Utility: hrnbrsix
 
CONTROL - file: Y2000SIX.CTL
TABLE - TDS Table: Y2000_TDS_LOAD
 
Fill Percentage: SIndex - 075; Group - 075
#fields - 50; #rows - 100000; #parameters - 0; #secondaries - 1
Areas: IxBuf - 4096; Ix - 14; E - 0; Parms - 0; PKeys - 4; LSIndex - 10
Sort Work: Maximum Areas - 999
 
 
FIELD NAME - KEY (PRIMARY KEY)
Definition: type= I; syn= B; len= 4; dec= 0; fld= 1; key= 1; prm= 0
 
FIELD NAME - FLD (SECONDARY KEY)
Definition: type= S; syn= C; len= 10; dec= 0; fld= 2; key= 0; prm= 0
 
 
**NOTE** -1 = Not Applicable.
END OF TABLE
 
 
PAGESTORE SEGMENT NAME SEG01 SEGMENT # 1 TYPE TDS - OPENED
 
 
*hrnbrsix TDS SIX BUILDER Date 2007 MAR 06 Time 11:27
 
PAGESTORE SEGMENT NAME SEG01 SEGMENT # 1 SEGMENT TYPE TDS
 
CONTROL - file: Y2000SIX.CTL
OUTPUT - TDS Table: Y2000_TDS_LOAD
 
Table's primary path begins at page: 00000084; no secondaries allocated.
S6BBX112I TABLE HAS NO DATA
 
 
 
PAGESTORE SEGMENT NAME SEG01 SEGMENT # 1 TYPE TDS - CONNECTION TERMINATED

 
Related Utilities

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