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


Appendix A Defining Batch Load Control Cards Manually : Page Fill Tailoring

Page Fill Tailoring
Tailoring Guidelines
With the S6BBRTBL (Batch Load) utility you can manipulate the percentage of usable page space that is filled during the load process. By adjusting the page fill values, you can create page structures that are better suited to their intended purposes. For example, if the table you want to load is very stable and you expect few or no updates to be applied (for example, a history instance of sales records), you could increase the fill percentage. However, if you expect your table to have much occurrence expansion, you could decrease the fill percentage to minimize the number of page splits.
Page Split/Merge Processing
During normal online processing, if a page is too full to accept an update or insert, the page is split dynamically. If two consecutive pages can hold all the data on one page after a delete, the pages can be merged dynamically. This dynamic split/merge process alleviates the need for offline page restructuring, but can slow down your processing. If you adjust the fill percentages to meet your specific intentions, page split/merge processing is reduced.

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