- Immediately after ASE server boots up, the tempdb database is full.
In the ASE errorlog during reboot:
Space available in the log segment has fallen critically low in database 'tempdb'. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
Failed to allocate disk space for a work table in database 'tempdb'. You may be able to free up space by using the DUMP TRANsaction command, or you may want to extend the size of the database by using the ALTER DATABASE command.
Failed to execute the threshold procedure for database 2, segment 2, free space 148102336.
- Tempdb has only one threshold -- last chance threshold is 24 page, but it triggered for “free space 148102336”.
- Tempdb has mixed data with log.
SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
CR757215, CR#757215, 757215, 1105, model, syslogs, logsegment, sysusages, traceflag, trace, flag, -T7405, 7405, -T7406, T7406, dump, truncate_only , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.