2522600 - How to use DBCC commands to fix incorrect log free space accounting - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2522600 - How to use DBCC commands to fix incorrect log free space accounting - SAP ASE

Symptom

Need to validate that DBCC commands fixed the issue with the free log space accounting in a database:

dbcc checktable (syslogs)
go
Checking table 'syslogs' (object ID 8): Logical page size is 2048 bytes.
Checking partition 'syslogs_8' (partition ID 8) of table 'syslogs'. The logical page size of this table is 2048 bytes.
The total number of data pages in partition 'syslogs_8' (partition ID 8) is 1395.
Partition 'syslogs_8' (partition ID 8) has 33019 data rows.
The total number of data pages in this table is 1395.
*** NOTICE: Space used on the log segment is 6395 pages (12.49 MB), 0.50%.
*** NOTICE: Space reserved on the log segment is 0 pages (0.00 MB), 0.00%.
*** NOTICE: Space free on the log segment is 1273605 pages (2487.51 MB), 99.50%.
Table has 33019 data rows.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

dbcc tablealloc (syslogs)
go
The default report option of OPTIMIZED is used for this run.
The default fix option of NOFIX is used for this run.
***************************************************************
TABLE: syslogs OBJID = 8
PARTITION ID=8 FIRST=6596037 ROOT=6597437 SORT=0
Msg 12947, Level 16, State 1:
Server 'MyASE', Line 2:
Syslogs free space is currently 1662218 pages but DBCC counted 1273598 pages. This descrepancy may be spurious if this count was done in multi-user mode. Please run DBCC TABLEALLOC(syslogs, full, fix) to correct it.
Data level: indid 0, partition 8. 1395 Data pages allocated and 175 Extents allocated.
TOTAL # of extents = 175
Alloc page 6595840 (# of extent=8 used pages=59 ref pages=59)
Alloc page 6596096 (# of extent=32 used pages=256 ref pages=256)
Alloc page 6596352 (# of extent=32 used pages=256 ref pages=256)
Alloc page 6596608 (# of extent=32 used pages=256 ref pages=256)
Alloc page 6596864 (# of extent=32 used pages=256 ref pages=256)
Alloc page 6597120 (# of extent=32 used pages=256 ref pages=256)
Alloc page 6597376 (# of extent=8 used pages=64 ref pages=62)
Total (# of extent=176 used pages=1403 ref pages=1401) in this database
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

Error 12947, dbcc dbrepair, full fix, fixlogfreespace, log space wrong calculated , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.