You can alter network message utilization for a prefetch query with the startup parameters -prefetchNumRecs and -prefetchFactor. NumRecs takes an integer value that represents the number of records to put in the network message. Factor takes an integer value that represents a "percent full" calculation for the network message. The network message is sent when the minimum of either parameter is reached. The interaction of the two parameters is governed as follows:
When NumRecs is set extremely high, it guarantees that the Factor percentage is the minimum.
When Factor is set to zero (0), it guarantees that the number of records specified by NumRecs is the minimum.
By default, the size of the prefetch data in a network message is controlled by the number of records (16).
When NumRecs is set extremely high, it guarantees that the Factor percentage is the minimum.