TransferPacketSize

Sets the packet size between the DirectConnect server and the target database.

Syntax

TransferPacketSize=integer

Default

512

Values

integer must be in multiples of 512 and cannot exceed the target packet size.

Warning!   If you increase the packet size beyond the capabilities of Adaptive Server, the transfer login to the secondary database fails.

Comments

To determine the Adaptive Server packet size, use sp_configure.

Example 1:

Returns the default packet size:
sp_configure “default network packet”

Example 2:

Returns the maximum size:
sp_configure “max network packet”