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.