SAP Knowledge Base Article - Preview

3088241 - Reporting tools show invalid high free page counter in logsegment in master database -- SAP ASE


• Counter free_pages > total_pages in ‘sp_helpsegment logsegment’ output from master database.
• Invalid big number in lct_admin('logsegment_freepages', 1) output.
• Bit DBI_SPACECOUNTS_VALID is set in master database’s DBINFO, two related fields in dbcc dbinfo(master)’ output:
              dbi_logstatus: 0x01                                   ----bit DBI_SPACECOUNTS_VALID is set
              dbi_freelogpages_at_ckpt: -15850           --- negative number



SAP Adaptive Server Enterprise (ASE) and SAP Adaptive Server Enterprise Cluster Edition (ASE CE) on all versions


Sybase Adaptive Server Enterprise Cluster Edition 15.7


dbcc dbinfo, logstatus, logsegment_freepages, dbcc findstranded, dbinfo_update, dbinfo_get, dbi_logstatus, dbi_freelogpages_at_ckpt , KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.