To achieve optimal performance of temporary data in the Cluster Edition, Sybase recommends that you use fast local disks for local user temporary databases. Local system temporary databases must be created on shared storage. To limit the use of shared storage for temporary data:
Create one or more private devices on local disks.
Create one or more local user temporary databases on the private devices.
Add these local user temporary databases to the default temporary database group.
A user connection that has no explicit temporary-database binding will be assigned a member database from the default group. This limits the use of local system temporary databases created on shared storage to internal system tasks while all user connections use local user temporary databases created on fast local disks.
