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


Appendix B S6BBRTBL/S6BBRSIX Tuning : Overview

Overview
Reason for Tuning
When loading large tables with secondary indexes or building secondary indexes on existing large tables, tuning your configuration can significantly decrease the elapsed time of the job.
Tuning Overview
Jobs should be run in a favored z/OS batch performance group, as they tend to be I/O bound. The activities undertaken by S6BBRTBL and S6BBRSIX and the tuning opportunities or impact at each activity are as follows:
1.
Optimum block size and DCB=(BUFNO= xx) where xx > 5 (S6BBRTBL only).
2.
3.
If the input file and target segment already exist prior to the need for the proposed load or index build there is little opportunity for tuning these components, but if it is possible it is recommended to improve performance.

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