SAP Knowledge Base Article - Preview

3469537 - How to return the 3 system segments back to master device section of tempdb - SAP ASE


  • The tempdb database is extended on several devices
  • The tempdb allocation on the master device has been changed so it is not used and shows -- unused by any segments --
  • Example (partial) output of sp_helpdb shows

    device_fragments     size              usage                         
    ---------------------    -------------   -------------------------------
    master                     12.0 MB      -- unused by any segments --
    tempdbdata01       1500.0 MB    data only
    tempdblog01          500.0 MB     log only

  • How to return the tempdb system, default and log segments back to the master device?



SAP Adaptive Server Enterprise (ASE). All versions.


SAP Adaptive Server Enterprise all versions


KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.