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


Appendix B S6BBRTBL/S6BBRSIX Tuning : Work File Allocation and Tuning

Work File Allocation and Tuning
Primary and Secondary Allocation
The work file is dynamically allocated during processing and is used to temporarily save index information prior to building table index pages.
When only a single volume is available for the work file (the default), the primary allocation is always sufficient to complete the job based on the maximum number of records/rows (columns 15-29 of control record type S).
When multiple volumes are specified (in columns 50-51 of control record type S) the secondary allocation for the work file is 75 percent of the primary.
The default number of volumes available for allocation of the work file is one that is normally sufficient but with very large tables the space required could exceed the total space of a single volume. To reduce the primary allocation, in this case it is necessary to manipulate the number of records or rows.
Secondary Indexes and Block Size Allocation
When secondary indexes are to be built, the block size of the work file is critical: the elapsed time (with similar system activity) of a job using an optimum block size can be up to half that of the same job using the default block size of 4096 bytes.

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