SAP ASE has a temporary database, tempdb, that provides a storage area for temporary tables and other temporary working storage needs. The space in tempdb is shared among all users of all databases on the server.
Large temporary tables.
A lot of activity on temporary tables, which fills up the tempdb logs.
Large or many simultaneous sorts. Subqueries and aggregates with group by also cause some tempdb activity.
Use alter database to increase the size of tempdb. tempdb is initially created on the master device. You can add space to tempdb from the master device or from any other database device.
If you run update index statistics against large tables, the command fails with error number 1105 if tempdb is not large enough.
You can create and manage multiple temporary databases in addition to the system temporary database, tempdb. Multiple temporary databases reduce contention on system catalogs and logs in tempdb.