Adaptive Server version 12.5.0.3 allows you to create and manage multiple temporary databases in addition to the system tempdb, which was the only temporary database in the server in earlier versions of Adaptive Server.
Multiple temporary databases, also referred to as tempdbs, reduce contention on system catalogs and logs in the system tempdb. They allow you to:
Create temporary databases on fast-access devices
Drop a temporary database to reclaim storage
Partition tasks that create temporary objects into using specific tempdbs, which prevents these tasks from interfering with other sessions that need to use temporary database space
The multiple temporary database feature is fully enabled for:
New installations
Installations that are upgrading from an Adaptive Server earlier than version 12.5
Databases that are loaded from an Adaptive Server earlier than version 12.5
The tempdb database is the system-created temporary database. Before Adaptive Server version 12.5.0.3, tempdb was the only temporary database in the server. Temporary tables and work tables are created in tempdb.
