When DataServer connection management is enabled, connections for stored procedures are allocated from the managed connections. If your stored procedures modify the connection environment or attributes, allocate a set of managed connections exclusively for stored procedures to prevent the modified connections from being reallocated for general use.

Allocate managed connections exclusively for stored procedures with the following syntax:

Syntax

-Dsrv PRGRS_SP_CACHE_CONN,n

Where n is the number of managed connections allocated to stored procedures. Set n to a value large enough to handle the largest number of stored procedures you can run simultaneously. If you exceed n, the connection will be allocated from the ODBC connection pool, if enabled, making the modified connection available for general reuse.

Note: This switch is off by default, and is only needed for applications that modify the connection environment or attributes within stored procedures.