![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
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.
You must use this utility if your table is greater than 3000 pages or exceeds site limits for online processing.
-A auditreport The file to which the audit report is written. If this argument is omitted, the report is written to stdout. -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.
• 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.
• You must have enough disk space to build the work files required for sorting the secondary index data prior to the build.
• 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.
• The control information is in file c:\cntl\control.file (Windows) or /usr1/cntl/control.file (Solaris).Sample Audit Log
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |