SAP Knowledge Base Article - Preview

2747756 - sp_spaceused "reserved_pages" value keeps growing - SAP ASE

Symptom

  • sp_spaceused reserved_pages value keeps growing
  • sp_spaceused syslogs
    go
     name            total_pages     free_pages      used_pages      reserved_pages
     --------------- --------------- --------------- --------------- ---------------
     syslogs         16357376        14630165        1652095         75116
  • reserved_pages only decrements if ASE is recycled
  • sp_helpdb shows that "delay_commits" is enabled

sp_helpdb <database>
go

 name          db_size       owner             dbid created      durability lobcomplvl inrowlen status

 ------------- ------------- ----------------- ---- ------------ ---------- ---------- -------- -----------------------------------------------------------------------

 <database>   271052.0 MB <owner>    4 Aug 22, 2018 full                0     NULL select into/bulkcopy/pllsort, delayed commit, deferred table allocation


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

sybase, ASE, delayed commit, reserved_pages, syslogs, sp_spaceused, CR 819222, #819222, HADR, SRS , 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.