Adaptive Server ESD #4
- Changes to sp_addthreshold and Roles
System and user defined roles that are active when a threshold procedure is created are preserved in systhresholds.
- Configuring the Number of Rows Waiting in the Send Buffer
Adaptive Server assembles data and accumulates rows that wait in the send buffer, but does not send them until the buffer has reached its configured size.
- Remote Backup Server Maximum Name Length
The remote backup server name length limit for dump and load commands has been increased from 30 characters to 255 characters.
- Backup Server Supports the mountwait Parameter
Backup Server supports the Tivoli Storage Manager mountwait -M parameter for the dump database, dump transaction, load database, and load transaction commands.
- Support for Query Plan Pinning
The configuration option dynamic SQL plan pinning has been introduced in Adaptive Server 15.7 ESD #4 to improve Adaptive Server performance by reducing the time spent by server connections waiting for access to the query plan manager.
- Support for AF_UNIX
Adaptive Server version 15.7 ESD #4 and later support the AF_UNIX named pipe communication, which avoids some of the overhead incurred by the TCP protocol.
Created May 27, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com