SAP Knowledge Base Article - Preview

2008974 - The tempdb database is full after reboot. - SAP ASE

Symptom

  • 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.

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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 page

This 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.