Symptom
Running dbcc tablalloc(syslogs) reporting inaccurate percent complete, exceeding 100%.
1> dbcc tablealloc(syslogs,full) 2> go The default fix option of NOFIX is used for this run. *************************************************************** TABLE: syslogs OBJID = 8 PARTITION ID=8 FIRST=256003 ROOT=256003 SORT=0 Data level: indid 0, partition 8. 1 Data pages allocated and 1 Extents allocated. TOTAL # of extents = 1 Alloc page 256000 (# of extent=1 used pages=6 ref pages=2) Total (# of extent=1 used pages=6 ref pages=2) in this database Database 'report' is not in single user mode - may find spurious allocation problems due to transactions in progress. Processed 1001 allocation unit(s) out of 1024 units (allocation page 256000). 97% completed. Processed 1096 allocation unit(s) out of 1024 units (allocation page 280320). 107% completed. [snip for brevity] Processed 3042 allocation unit(s) out of 1024 units (allocation page 778496). 297% completed.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise For Business Suite 15.7
- SAP Adaptive Server Enterprise Cluster Edition 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
- SAP Adaptive Server Enterprise Cluster Edition 15.7
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0
Keywords
inaccurate,log,space , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.
SAP Knowledge Base Article - Preview