If you are using fast bcp, consider that each bcp in batch requires the page manager to allocate one or more extents. Each such allocation generates a single log record.
Use the number of preallocated extents configuration parameter to specify how many extents Adaptive Server is to allocate through the page manager.
Valid values for the number of preallocated extents configuration parameter are from 0 to 31; the default value is 2.
You must restart Adaptive Server to change the value.
When performing large bcp operations, increase this number to prevent the page allocations from filling the log.
Set this value to 0 to prevent large extent allocations, so that the page manager performs only single-page allocations.
Adaptive Server may allocate more pages than are actually needed, so keep the value small when space is limited. These pages are deallocated at the end of the batch.
For more information, see the System Administration Guide.
