Creating and managing temporary database groups is the same all editions of Adaptive Server.
In the Cluster Edition, the local system temporary database
is not a member of the default group.
To create a temporary database group, use sp_tempdb create. For example, to create a temporary database group named tempdbgroup1:
sp_tempdb "create", "tempdbgroup1"
To drop a temporary database group, use sp_tempdb drop. For example, to drop the temporary database group named tempdbgroup1:
sp_tempdb "drop", "tempdbgroup1"
To add a database to a temporary database group, use sp_tempdb add. For example, to add database local_tempdb1 to the temporary database group named tempdbgroup1:
sp_tempdb "add", "local_tempdb1", "tempdbgroup1"
To remove a database from a temporary database group, use sp_tempdb remove. For example, to remove database local_tempdb1 from the temporary database group named tempdbgroup1:
sp_tempdb "remove", "local_tempdb1", "tempdbgroup1"
See the Reference Manual, Procedures for complete syntax and usage information for sp_tempdb.