![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
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.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:
Multiple (as many as possible) data sets with separate paths and volumes.
Multiple (as many as possible) data sets with separate paths and volumes.
Multiple (as many as possible) data sets with separate paths and volumes.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 |