SAP Knowledge Base Article - Preview

2709213 - Temp worktable not cleaned up in user temporary database (user tempdb) - SAP ASE

Symptom

  • User temporary database space is occupied by several temp worktables even though there is no user process/task associated with them in ASE server;
  • The occupied space can be shown in 'dbcc usedextents' output like following:


Disk piece 0 (3145728 pages), extents used = 123, worktable extents used = 12056, free = 381037
Total used extents = 123
Total worktable used extents = 12056     <===


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

Sybase, ASEServer, SAPASE, dataserver, tempdb space, worktable, cleaned up, CR 817084, CR817084, 817084, CR817439, CR 817439, 817439, CR816851, CR 816851, 816851   , 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 for Me (Login required).

Search for additional results

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