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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.