SAP Knowledge Base Article - Preview

1752266 - How to create or recreate an additional tempdb on ASE for SAP Business Suite - SAP ASE for Business Suite


  • You are running SAP Business Suite on SAP ASE and want to create an additional tempdb (temporary database) to separate the usage of default system tempdb, since that tempdb is being used by the SID database and "saptools" database (DBACockpit).
  • This additional temporary database already exist by default for the newer version of Business Suite on ASE. It is named "saptempdb".
  • To decrease the size of "saptempdb", best solution is to drop it first, and then recreate it with a smaller size.



  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions 


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver Application Server all versions


Error 1105, Fehler 1105, tempdb, saptempdb, sp_tempdb, bind , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.