SAP Knowledge Base Article - Preview

2221561 - Incorrect status report from dbcc tablealloc on syslogs - SAP ASE

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.