Adaptive Server includes a group of temporary databases called the default group. When Adaptive Server starts a session, it selects a temporary database from the default group (using a round-robin technique) in which all temporary database activities are performed. Adaptive Server assigns this temporary database to the session. sp_who displays this temporary database in the tempdbname column. The round-robin scheme allows Adaptive Server to distribute the load evenly across all temporary databases in the default group because a single temporary database from the group is not performing all activities.
Initially, the default group consists only of tempdb. However, users may add multiple user databases to the default group. Use sp_tempdb to add a user database to the default group. For example, to add tempdb_1 to the default group, use:
sp_temodb "add'", "tempdb_1" , "default"
To drop tempdb_1 from the default group, use:
sp_tempdb "drop", "tempdb_1" , "default"
See the Reference Manual: Procedures for the complete sp_tempdb syntax.
