The Allocate property specifies when the APPC conversation that exists between the DB2 access service and the target database system is allocated and deallocated. Valid values are connect and request.
If you specify connect (the default), the APPC conversation remains allocated until the client issues some form of deallocation, such as an exit. As a result, fewer APPC connections are available, but overhead for each client is reduced.
If you specify request, resources are generally released sooner and, as a result, more clients can access the target database at a time. However, overhead increases because of the repeated initiation of APPC conversations for each request handled. You can specify request for either short or long transactions.
Copyright © 2005. Sybase Inc. All rights reserved. |